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