RA_ReturnHeader RA Return Header Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: RA_Return_bus,RA_GenerateTransactions_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_ReturnHeader.M4T"
KPRIMARY: RMANo
KCUSTOMER: ARDivisionNo+CustomerNo+RMANo
KRMADATE: RMADate+RMANo
KBILLTO: BillToName+RMANo
Fld Column Name M/L TUR Description/Notes Class
1 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO
FmtType:CHARNUM Next:RMANo$
Notes: {RA1$(1,7)}
2 RMADate . . . . . . . . . . . 8 SNN RMA Date. . . . . . . . . . . .DATE
DepVal:REQUIRED Notes:
{RA1$(8,6)}
3 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
DepVal:REQUIRED Notes:
{RA1$(14,2)}
4 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC DepVal:REQ
UIRED ChngTag:Replace1/ARDivi
sionNo$ Notes: {RA1$(16,7)}
5 RMAStatus . . . . . . . . . . 1 SYN RMA Status. . . . . . . . . . .
DfltVal:N Valid:C,H,N,O,P
Notes: C=Complete, H=Hold,
N=New, O=Open, P=Partially
received {RA1$(23,1)}
6 ExpireDate. . . . . . . . . . 8 SNN Expire Date . . . . . . . . . .DATE
Notes: {RA1$(24,6)}
7 ReturnShipVia . . . . . . . . 15 SYN Return Ship Via . . . . . . . .SHIPCODE
Notes: {RA1$(30,15)}
8 ShipToCode. . . . . . . . . . 4 SYN Ship To Code. . . . . . . . . .SHIPTO
ValGroup:CustomerRequired
Notes: {RA1$(45,4)}
9 ConfirmTo . . . . . . . . . . 30 SNN Confirm to. . . . . . . . . . .
ValGroup:CustomerRequired
Notes: {RA1$(49,30)}
10 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30
ValGroup:CustomerRequired
Notes: {RA1$(79,30)}
11 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS
Notes: {RA1$(109,50)}
12 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO
DepVal:REQUIRED Notes:
{RA1$(159,17)}
13 BatchFax. . . . . . . . . . . 1 SYN Batch Fax . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{RA1$(176,1)}
14 InspectOnReceipt. . . . . . . 1 SYN Inspect on Receipt. . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{RA1$(177,1)}
15 ApplyRestockingCharges. . . . 1 SYN Apply Restocking Charges. . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:RestockRequired
Notes: {RA1$(178,1)}
16 CrossShip . . . . . . . . . . 1 SYN Cross Ship. . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{RA1$(179,1)}
17 PrintCustomerRMA. . . . . . . 1 SYN Print Customer RMA. . . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:PrintRMARequired
Notes: {RA1$(180,1)}
18 PrintRMAReceiver. . . . . . . 1 SYN Print RMA Receiver. . . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:PrintRMARecRequired
Notes: {RA1$(181,1)}
19 BillToName. . . . . . . . . . 30 SNN Bill-To Name. . . . . . . . . .NAME
ValGroup:CustomerRequired
Notes: {RA1$(185,30)}
20 BillToAddress1. . . . . . . . 30 SNN Bill-To Address 1 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {RA1$(215,30)}
21 BillToAddress2. . . . . . . . 30 SNN Bill-To Address 2 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {RA1$(245,30)}
22 BillToAddress3. . . . . . . . 30 SNN Bill-To Address 3 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {RA1$(275,30)}
23 BillToCity. . . . . . . . . . 20 SNN Bill-To City. . . . . . . . . .CITY
ValGroup:CustomerRequired
Notes: {RA1$(305,20)}
24 BillToState . . . . . . . . . 2 SYN Bill-To State . . . . . . . . .STATE
ValGroup:CustomerRequired
Notes: {RA1$(325,2)}
25 BillToZipCode . . . . . . . . 10 SNN Bill-To Zip Code. . . . . . . .ZIPCODE
ValGroup:CustomerRequired
Notes: {RA1$(327,10)}
26 BillToCountryCode . . . . . . 3 SNN Bill-To Country Code. . . . . .COUNTRY
ValGroup:CustomerRequired
Notes: {RA1$(337,3)}
27 ShipToName. . . . . . . . . . 30 SNN Ship-To Name. . . . . . . . . .NAME
ValGroup:CustomerRequired
Notes: {RA1$(340,30)}
28 ShipToAddress1. . . . . . . . 30 SNN Ship-To Address 1 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {RA1$(370,30)}
29 ShipToAddress2. . . . . . . . 30 SNN Ship-To Address 2 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {RA1$(400,30)}
30 ShipToAddress3. . . . . . . . 30 SNN Ship-To Address 3 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {RA1$(430,30)}
31 ShipToCity. . . . . . . . . . 20 SNN Ship-To City. . . . . . . . . .CITY
ValGroup:CustomerRequired
Notes: {RA1$(460,20)}
32 ShipToState . . . . . . . . . 2 SYN Ship-To State . . . . . . . . .STATE
ValGroup:CustomerRequired
Notes: {RA1$(480,2)}
33 ShipToZipCode . . . . . . . . 10 SNN Ship-To Zip Code. . . . . . . .ZIPCODE
ValGroup:CustomerRequired
Notes: {RA1$(482,10)}
34 ShipToCountryCode . . . . . . 3 SNN Ship-To Country Code. . . . . .COUNTRY
ValGroup:CustomerRequired
Notes: {RA1$(492,3)}
35 ReturnToAddressCode . . . . . 4 SYN Return To Address Code. . . . .RETURNTOCODE
Notes: {RA1$(495,4)}
36 ReturnToName. . . . . . . . . 30 SNN Return-To Name. . . . . . . . .NAME
ValGroup:ReturnedToRequired
Notes: {RA1$(499,30)}
37 ReturnToAddress1. . . . . . . 30 SNN Return-To Address 1 . . . . . .ADDRESSLINE
ValGroup:ReturnedToRequired
Notes: {RA1$(529,30)}
38 ReturnToAddress2. . . . . . . 30 SNN Return-To Address 2 . . . . . .ADDRESSLINE
ValGroup:ReturnedToRequired
Notes: {RA1$(559,30)}
39 ReturnToAddress3. . . . . . . 30 SNN Return-To Address 3 . . . . . .ADDRESSLINE
ValGroup:ReturnedToRequired
Notes: {RA1$(589,30)}
40 ReturnToCity. . . . . . . . . 20 SNN Return-To City. . . . . . . . .CITY
ValGroup:ReturnedToRequired
Notes: {RA1$(619,20)}
41 ReturnToState . . . . . . . . 2 SYN Return-To State . . . . . . . .STATE
ValGroup:ReturnedToRequired
Notes: {RA1$(639,2)}
42 ReturnToZipCode . . . . . . . 10 SNN Return-To Zip Code. . . . . . .ZIPCODE
ValGroup:ReturnedToRequired
Notes: {RA1$(641,10)}
43 ReturnToCountryCode . . . . . 3 SNN Return-To Country Code. . . . .COUNTRY
ValGroup:ReturnedToRequired
Notes: {RA1$(651,3)}
44 ResidentialAddress. . . . . . 1 SYN Residential Address . . . . . .YESNO
DfltVal:N Valid:Y,N
45 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
46 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
47 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
48 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
49 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
50 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL