RA_ReceiptsHeader RA Receipts Header Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: RA_Receipts_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_ReceiptsHeader.M4T"
KPRIMARY: RMANo
KCUSTOMER: ARDivisionNo+CustomerNo+RMANo
KBATCH: BatchNo+RMANo
Fld Column Name M/L TUR Description/Notes Class
1 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO
FmtType:CHARNUM Next:RMANo$
Notes: {RAA$(1,7)}
2 ReceiptDate . . . . . . . . . 8 SNN Receipt Date. . . . . . . . . .DATE
DepVal:REQUIRED Notes:
{RAA$(8,6)}
3 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {RAA$(14,2)}
4 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC ChngTag:Re
place1/ARDivisionNo$ Notes:
{RAA$(16,7)}
5 RMADate . . . . . . . . . . . 8 SNN RMA Date. . . . . . . . . . . .DATE
DepVal:REQUIRED Notes:
{RAA$(23,6)}
6 RMAStatus . . . . . . . . . . 1 SYN RMA Status. . . . . . . . . . .
Valid:1,H,N,O,P,C Notes:
1=1Step, H=Hold, N=New,
O=Open, P=Partially Received,
C=reCeived {RAA$(29,1)}
7 ReturnShipVia . . . . . . . . 15 SYN Return Ship Via . . . . . . . .SHIPCODE
Notes: {RAA$(30,15)}
8 ShipToCode. . . . . . . . . . 4 SYN Ship To Code. . . . . . . . . .SHIPTO
Notes: {RAA$(45,4)}
9 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . .
Notes: {RAA$(49,30)}
10 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30
Notes: {RAA$(79,30)}
11 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS
Notes: {RAA$(109,50)}
12 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO
DepVal:REQUIRED Notes:
{RAA$(159,17)}
13 InspectOnReceipt. . . . . . . 1 SYN Inspect on Receipt. . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{RAA$(176,1)}
14 CrossShip . . . . . . . . . . 1 SYN Cross Ship. . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{RAA$(177,1)}
15 ApplyRestockingCharges. . . . 1 SYN Apply Restocking Charges. . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:RestockRequired
Notes: {RAA$(178,1)}
16 BatchNo . . . . . . . . . . . 5 SYN Batch Number. . . . . . . . . .BATCHNO
Notes: {RAA$(182,5)}
17 ReturnToAddressCode . . . . . 4 SYN Return-To Address Code. . . . .RETURNTOCODE
Notes: {RAA$(187,4)}
18 ReturnToName. . . . . . . . . 30 SNN Return-To Name. . . . . . . . .NAME
ValGroup:ReturnToRequired
Notes: {RAA$(191,30)}
19 ReturnToAddress1. . . . . . . 30 SNN Return-To Address 1 . . . . . .ADDRESSLINE
ValGroup:ReturnToRequired
Notes: {RAA$(221,30)}
20 ReturnToAddress2. . . . . . . 30 SNN Return-To Address 2 . . . . . .ADDRESSLINE
ValGroup:ReturnToRequired
Notes: {RAA$(251,30)}
21 ReturnToAddress3. . . . . . . 30 SNN Return-To Address 3 . . . . . .ADDRESSLINE
ValGroup:ReturnToRequired
Notes: {RAA$(281,30)}
22 ReturnToCity. . . . . . . . . 20 SNN Return-To City. . . . . . . . .CITY
ValGroup:ReturnToRequired
Notes: {RAA$(311,20)}
23 ReturnToState . . . . . . . . 2 SYN Return-To State . . . . . . . .STATE
ValGroup:ReturnToRequired
Notes: {RAA$(331,2)}
24 ReturnToZipCode . . . . . . . 10 SNN Return-To Zip Code. . . . . . .ZIPCODE
ValGroup:ReturnToRequired
Notes: {RAA$(333,10)}
25 ReturnToCountryCode . . . . . 3 SNN Return-To Country Code. . . . .COUNTRY
ValGroup:ReturnToRequired
Notes: {RAA$(343,3)}
26 BillToName. . . . . . . . . . 30 SNN Bill-To Name. . . . . . . . . .NAME
Notes: {RAA$(346,30)}
27 BillToAddress1. . . . . . . . 30 SNN Bill-To Address 1 . . . . . . .ADDRESSLINE
Notes: {RAA$(376,30)}
28 BillToAddress2. . . . . . . . 30 SNN Bill-To Address 2 . . . . . . .ADDRESSLINE
Notes: {RAA$(406,30)}
29 BillToAddress3. . . . . . . . 30 SNN Bill-To Address 3 . . . . . . .ADDRESSLINE
Notes: {RAA$(436,30)}
30 BillToCity. . . . . . . . . . 20 SNN Bill-To City. . . . . . . . . .CITY
Notes: {RAA$(466,20)}
31 BillToState . . . . . . . . . 2 SYN Bill-To State . . . . . . . . .STATE
Notes: {RAA$(486,2)}
32 BillToZipCode . . . . . . . . 10 SNN Bill-To Zip Code. . . . . . . .ZIPCODE
Notes: {RAA$(488,10)}
33 BillToCountryCode . . . . . . 3 SNN Bill-To Country Code. . . . . .COUNTRY
Notes: {RAA$(498,3)}
34 ShipToName. . . . . . . . . . 30 SNN Ship-To Name. . . . . . . . . .NAME
Notes: {RAA$(501,30)}
35 ShipToAddress1. . . . . . . . 30 SNN Ship-To Address 1 . . . . . . .ADDRESSLINE
Notes: {RAA$(531,30)}
36 ShipToAddress2. . . . . . . . 30 SNN Ship-To Address 2 . . . . . . .ADDRESSLINE
Notes: {RAA$(561,30)}
37 ShipToAddress3. . . . . . . . 30 SNN Ship-To Address 3 . . . . . . .ADDRESSLINE
Notes: {RAA$(591,30)}
38 ShipToCity. . . . . . . . . . 20 SNN Ship-To City. . . . . . . . . .CITY
Notes: {RAA$(621,20)}
39 ShipToState . . . . . . . . . 2 SYN Ship-To State . . . . . . . . .STATE
Notes: {RAA$(641,2)}
40 ShipToZipCode . . . . . . . . 10 SNN Ship-To Zip Code. . . . . . . .ZIPCODE
Notes: {RAA$(643,10)}
41 ShipToCountryCode . . . . . . 3 SNN Ship-To Country Code. . . . . .COUNTRY
Notes: {RAA$(653,3)}
42 LotSerialLinesExist . . . . . 1 SYN Lot/Serial Lines Exist. . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{RAA$(656,1)}
43 ReceiptSeqNo. . . . . . . . . 6 SNN Receipt Sequence Number . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {RAA$(662,5)}
44 ResidentialAddress. . . . . . 1 SYN Residential Address . . . . . .YESNO
DfltVal:N Valid:Y,N
45 NumberOfPartialLines. . . . . 5.0 NNN Number of Partial Lines . . . .
Mask:##### Notes: {RAA$(657,
5)}
46 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
47 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
48 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
49 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
50 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
51 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL