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