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