     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