     RA_RepairDetail                        RA Repair Detail               Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: RA_GenerateTransactions_upd
     SQL Def: Y  SysDB: N                                       "MAS_"+%C$+"/RA"+%C$+"/RA_RepairDetail.M4T"

     KPRIMARY: ARDivisionNo+CustomerNo+ItemCode+RMANo+SequenceNo
     KITEM: ItemCode+ARDivisionNo+CustomerNo+RMANo+SequenceNo
     KRMANO: RMANo+ARDivisionNo+CustomerNo+ItemCode+SequenceNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {RAI$(2,2)}
       2  CustomerNo. . . . . . . . . .    20 SYN  Customer Number . . . . . . . .CUSTOMERNO
                                                    FmtType:MASTERNUMC ChngTag:Re
                                                    place1/ARDivisionNo$ Notes:
                                                    {RAI$(4,7)}
       3  ItemCode. . . . . . . . . . .    30 SYN  Item Code . . . . . . . . . . .ITEMCODE
                                                    Notes: {RAI$(11,15)}
       4  RMANo . . . . . . . . . . . .     7 SYN  RMA Number. . . . . . . . . . .RMANO
                                                    FmtType:CHARNUM Notes:
                                                    {RAI$(26,7)}
       5  SequenceNo. . . . . . . . . .     6 SNN  Sequence Number . . . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    ChngTag:KeySeq Notes:
                                                    {RAI$(33,5)}
       6  ItemType. . . . . . . . . . .     1 SYY  Item Type . . . . . . . . . . .
                                                    Valid:1,2,3,4,5 Notes:
                                                    1=Regular Item, 2=Special
                                                    Item, 3=Charge Item,
                                                    4=Comment Item, 5=Miscellaneo
                                                    us Item {RAI$(38,1)}
       7  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .DESCRIPTION
                                                    Notes: {RAI$(54,30)}
       8  RMADate . . . . . . . . . . .     8 SNN  RMA Date. . . . . . . . . . . .DATE
                                                    Notes: {RAI$(84,6)}
       9  ReceiptDate . . . . . . . . .     8 SNN  Receipt Date. . . . . . . . . .DATE
                                                    Notes: {RAI$(90,6)}
      10  ReturnReasonCode. . . . . . .    10 SYN  Return Reason Code. . . . . . .RETURNREASONCODE
                                                    Notes: {RAI$(96,10)}
      11  InvoiceNo . . . . . . . . . .     7 SYN  Invoice Number. . . . . . . . .INVOICE
                                                    FmtType:MASTERNUM Notes:
                                                    {RAI$(106,7)}
      12  InvoiceNotOnFile. . . . . . .     1 SYN  Invoice Not on File . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {RAI$(113,1)}
      13  QuantityReturned. . . . . . . 16.6  NNN  Quantity Returned . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {RAI[0]}
      14  QuantityReceived. . . . . . . 16.6  NNN  Quantity Received . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {RAI[1]}
      15  QuantityRemaining . . . . . . 16.6  NNN  Quantity Remaining. . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {RAI[2]}
      16  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      17  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y
      18  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL