RA_ReceiptsHistoryHeader RA Receipts History Header Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: RA_ReceiptsHistory_bus,RA_GenerateTransactions_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_ReceiptsHistoryHeader.M4T"
KPRIMARY: RMANo+ReceiptSeqNo
KCUSTOMER: ARDivisionNo+CustomerNo+RMANo+ReceiptSeqNo
KBILLTO: BillToName+RMANo+ReceiptSeqNo
KRECEIPTDATE: ReceiptDate(d)+RMANo+ReceiptSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO
FmtType:CHARNUM Notes:
{RA_03$(1,7)}
2 ReceiptSeqNo. . . . . . . . . 6 SNN Receipt Sequence Number . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {RA_03$(8,5)}
3 RMADate . . . . . . . . . . . 8 SNN RMA Date. . . . . . . . . . . .DATE
Notes: {RA_03$(13,6)}
4 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {RA_03$(19,2)}
5 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC ChngTag:Re
place1/ARDivisionNo$ Notes:
{RA_03$(21,7)}
6 RMAStatus . . . . . . . . . . 1 SYN RMA Status. . . . . . . . . . .
Valid:H,N,O,P,R Notes:
H=Hold, N=New, O=Open,
P=Partially received,
R=Received {RA_03$(28,1)}
7 ReturnShipVia . . . . . . . . 15 SYN Return Ship Via . . . . . . . .SHIPCODE
Notes: {RA_03$(35,15)}
8 ShipToCode. . . . . . . . . . 4 SYN Ship To Code. . . . . . . . . .SHIPTO
Notes: {RA_03$(50,4)}
9 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . .
Notes: {RA_03$(54,30)}
10 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30
Notes: {RA_03$(84,30)}
11 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS
Notes: {RA_03$(114,50)}
12 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO
Notes: {RA_03$(164,17)}
13 InspectOnReceipt. . . . . . . 1 SYN Inspect on Receipt. . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{RA_03$(182,1)}
14 ApplyRestockingCharges. . . . 1 SYN Apply Restocking Charges. . . .YESNO
DfltVal:N Valid:Y,N Notes:
{RA_03$(183,1)}
15 CrossShip . . . . . . . . . . 1 SYN Cross Ship. . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{RA_03$(184,1)}
16 BillToName. . . . . . . . . . 30 SNN Bill-To Name. . . . . . . . . .NAME
Notes: {RA_03$(190,30)}
17 BillToAddress1. . . . . . . . 30 SNN Bill-To Address 1 . . . . . . .ADDRESSLINE
Notes: {RA_03$(220,30)}
18 BillToAddress2. . . . . . . . 30 SNN Bill-To Address 2 . . . . . . .ADDRESSLINE
Notes: {RA_03$(250,30)}
19 BillToAddress3. . . . . . . . 30 SNN Bill-To Address 3 . . . . . . .ADDRESSLINE
Notes: {RA_03$(280,30)}
20 BillToCity. . . . . . . . . . 20 SNN Bill-To City. . . . . . . . . .CITY
Notes: {RA_03$(310,20)}
21 BillToState . . . . . . . . . 2 SYN Bill-To State . . . . . . . . .STATE
Notes: {RA_03$(330,2)}
22 BillToZipCode . . . . . . . . 10 SNN Bill-To Zip Code. . . . . . . .ZIPCODE
Notes: {RA_03$(332,10)}
23 BillToCountryCode . . . . . . 3 SNN Bill-To Country Code. . . . . .COUNTRY
Notes: {RA_03$(342,3)}
24 ShipToName. . . . . . . . . . 30 SNN Ship-To Name. . . . . . . . . .NAME
Notes: {RA_03$(345,30)}
25 ShipToAddress1. . . . . . . . 30 SNN Ship-To Address 1 . . . . . . .ADDRESSLINE
Notes: {RA_03$(375,30)}
26 ShipToAddress2. . . . . . . . 30 SNN Ship-To Address 2 . . . . . . .ADDRESSLINE
Notes: {RA_03$(405,30)}
27 ShipToAddress3. . . . . . . . 30 SNN Ship-To Address 3 . . . . . . .ADDRESSLINE
Notes: {RA_03$(435,30)}
28 ShipToCity. . . . . . . . . . 20 SNN Ship-To City. . . . . . . . . .CITY
Notes: {RA_03$(465,20)}
29 ShipToState . . . . . . . . . 2 SYN Ship-To State . . . . . . . . .STATE
Notes: {RA_03$(485,2)}
30 ShipToZipCode . . . . . . . . 10 SNN Ship-To Zip Code. . . . . . . .ZIPCODE
Notes: {RA_03$(487,10)}
31 ShipToCountryCode . . . . . . 3 SNN Ship-To Country Code. . . . . .COUNTRY
Notes: {RA_03$(497,3)}
32 ReturnToAddressCode . . . . . 4 SYN Return To Address Code. . . . .RETURNTOCODE
Notes: {RA_03$(500,4)}
33 ReturnToName. . . . . . . . . 30 SNN Return-To Name. . . . . . . . .NAME
Notes: {RA_03$(504,30)}
34 ReturnToAddress1. . . . . . . 30 SNN Return-To Address 1 . . . . . .ADDRESSLINE
Notes: {RA_03$(534,30)}
35 ReturnToAddress2. . . . . . . 30 SNN Return-To Address 2 . . . . . .ADDRESSLINE
Notes: {RA_03$(564,30)}
36 ReturnToAddress3. . . . . . . 30 SNN Return-To Address 3 . . . . . .ADDRESSLINE
Notes: {RA_03$(594,30)}
37 ReturnToCity. . . . . . . . . 20 SNN Return-To City. . . . . . . . .CITY
Notes: {RA_03$(624,20)}
38 ReturnToState . . . . . . . . 2 SYN Return-To State . . . . . . . .STATE
Notes: {RA_03$(644,2)}
39 ReturnToZipCode . . . . . . . 10 SNN Return-To Zip Code. . . . . . .ZIPCODE
Notes: {RA_03$(646,10)}
40 ReturnToCountryCode . . . . . 3 SNN Return-To Country Code. . . . .COUNTRY
Notes: {RA_03$(656,3)}
41 ReceiptDate . . . . . . . . . 8 SNN Receipt Date. . . . . . . . . .DATE
Notes: {RA_03$(659,6)}
42 ResidentialAddress. . . . . . 1 SYN Residential Address . . . . . .YESNO
DfltVal:N Valid:Y,N
43 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
44 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
45 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL