     RA_GenerateTransactions                RA Generate Transactions       Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: N/A
     SQL Def: Y  SysDB: N                               "MAS_"+%C$+"/RA"+%C$+"/RA_GenerateTransactions.M4T"

     KPRIMARY: DocumentType+RMANo+ARDivisionNo+CustomerNo+InvoiceNoHistory+SequenceNo+ItemCode+ReceiptsDetai
               lLineKey
     KWHSE: DocumentType+APDivisionNo+VendorNo+RMANo+ItemCode+WarehouseCode+ReceiptsDetailLineKey
     KRMANO: RMANo
     KCUSTVNDR: ARDivisionNo+CustomerNo+RMALineKey+ItemCode+RMANo+DocumentType+InvoiceNoHistory+SequenceNo+R
                eceiptsDetailLineKey
     KRMACUSTVNDR: DocumentType+RMANo+ARDivisionNo+CustomerNo+InvoiceNoHistory+SequenceNo+RMALineKey+ItemCod
                   e+ReceiptsDetailLineKey
     KVENDOR: DocumentType+RMANo+APDivisionNo+VendorNo+InvoiceNoHistory+SequenceNo+ItemCode+ReceiptsDetailLi
              neKey

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  DocumentType. . . . . . . . .     1 SYY  Document Type . . . . . . . . .
                                                    Valid:C,O,P,R,X Notes:
                                                    C=Credit memo, O=sales Order,
                                                     P=Purchase order, R=Return
                                                    order, X=repair {RAH$(1,1)}
       2  RMANo . . . . . . . . . . . .     7 SYN  RMA Number. . . . . . . . . . .RMANO
                                                    FmtType:CHARNUM Notes:
                                                    {RAH$(2,7)}
       3  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {RAH$(9,2)}
       4  CustomerNo. . . . . . . . . .    20 SYN  Customer Number . . . . . . . .CUSTOMERNO
                                                    FmtType:MASTERNUMC ChngTag:Re
                                                    place1/ARDivisionNo$ Notes:
                                                    {RAH$(11,7)}
       5  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .APDIVISION
                                                    Mask:00 FmtType:ZEROFILL
       6  VendorNo. . . . . . . . . . .     7 SYN  Vendor Number . . . . . . . . .VENDORNO
                                                    FmtType:MASTERNUM ChngTag:Rep
                                                    lace1/APDivisionNo$
       7  InvoiceNoHistory. . . . . . .     7 SYN  Invoice Number in History . . .INVOICE
                                                    FmtType:MASTERNUM Notes:
                                                    {RAH$(18,7)}
       8  SequenceNo. . . . . . . . . .     6 SNN  Sequence Number . . . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: {RAH$(25,3)}
       9  ItemCode. . . . . . . . . . .    30 SYN  Item Code . . . . . . . . . . .ITEMCODE
                                                    Notes: {RAH$(28,15)}
      10  ItemType. . . . . . . . . . .     1 SYN  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
      11  ReceiptsDetailLineKey . . . .     6 SNN  Receipts Detail Line Key. . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: {RAH$(43,5)}
      12  ActualInvoiceNo . . . . . . .     7 SYN  Actual Invoice Number . . . . .INVOICE
                                                    FmtType:MASTERNUM Notes:
                                                    {RAH$(48,7)}
      13  RMADetailLineKey. . . . . . .     6 SNN  RMA Detail Line Key . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: {RAH$(55,5)}
      14  SOPOBatchNo . . . . . . . . .     5 SNN  SO/PO Batch Number. . . . . . .
                                                    Notes: {RAH$(60,5)}
      15  WarehouseCode . . . . . . . .     3 SYN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM Notes:
                                                    {RAH$(65,3)}
      16  GeneratedDocumentNo . . . . .     7 SYN  Generated Document Number . . .
                                                    Notes: {RAH$(68,7)}
      17  RMALineKey. . . . . . . . . .     6 SNN  RMA Line Key. . . . . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: {Packed) (RAH$(75,5)}
      18  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      19  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                    Read Only:Y
      20  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL