RA_ReturnReasonDetail RA Return Reason Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: RA_GenerateTransactions_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/RA"+%C$+"/RA_ReturnReasonDetail.M4T"
KPRIMARY: ItemCode+ReceiptDate+RMANo+SequenceNo KRETURNREASON: ReturnReasonCode+ItemCode+ReceiptDate+RMANo+SequenceNo KPRODUCTLINE: ProductLine+ItemCode+ReceiptDate+RMANo+SequenceNo KCUSTOMER: ARDivisionNo+CustomerNo+ItemCode+ReceiptDate+RMANo+SequenceNo KVENDOR: APDivisionNo+VendorNo+ItemCode+ReceiptDate+RMANo+SequenceNo KRECEIPTDATE: ReceiptDate(d)+ItemCode+RMANo+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE ChngTag:Replace0 Notes: Item Number - verified against IM1, Special Item Number - Not verified, Misc Charge - Verified against CI_Item, Misc Item - Verified against CI_Item {RAM$(1,15)} 2 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . . Valid:1,2,3,5 Notes: 1=Regular Item, 2=Special Item, 3=Charge Item, 4=Comment Item, 5=Miscellaneo us Item {RAM$(34,1)} 3 ReceiptDate . . . . . . . . . 8 SNN Receipt Date. . . . . . . . . .DATE Notes: {RAM$(16,6)} 4 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO FmtType:CHARNUM Notes: {RAM$(22,7)} 5 SequenceNo. . . . . . . . . . 6 SNN Sequence Number . . . . . . . . Mask:000000 FmtType:ZEROFILL Notes: {RAM$(29,5)} 6 ReturnReasonCode. . . . . . . 10 SYN Return Reason Code. . . . . . .RETURNREASONCODE Notes: {RAM$(35,10)} 7 ItemAction. . . . . . . . . . 1 SYN Item Action . . . . . . . . . . Valid:S,P,R Notes: S=Stock, P=Scrap,R=Repair {RAM$(45,1)} 8 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION Notes: {RAM$(46,30)} 9 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE FmtType:CHARNUM Notes: {RAM$(76,4)} 10 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE Notes: {RAM$(80,4)} 11 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM Notes: {RAM$(84,3)} 12 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {RAM$(87,2)} 13 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$ Notes: {RAM$(89,7)} 14 CustomerAction. . . . . . . . 1 SYN Customer Action . . . . . . . . Valid:C,P,R Notes: C=Credit, P=rePlacement,R=Repair {RAM$(96,1)} 15 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL Notes: {RAM$(97,2)} 16 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM ChngTag:Rep lace1/APDivisionNo$ Notes: {RAM$(99,7)} 17 VendorAction. . . . . . . . . 1 SYN Vendor Action . . . . . . . . . Valid:C,P,N Notes: C=Credit, P=rePlacement, N=None {RAM$(106,1)} 18 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION Mask:00 FmtType:ZEROFILL 19 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO FmtType:CHARNUM Notes: {RAM$(107,4)} 20 QuantityReturnedActual. . . . 16.6 NNN Quantity Returned Actual. . . .QUANTITY Mask:##,###,###.000000- Notes: {RAM[0]} 21 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 22 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 23 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL