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