     IM_TransactionPosting                  IM Transaction Posting         Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: SO_SalesJournal_upd,PO_ReceiptRegister_upd,IM_TransactionRegister_upd,BM_ProductionRegister_up
     SQL Def: Y  SysDB: N                                 "MAS_"+%C$+"/IM"+%C$+"/IM_TransactionPosting.M4T"

     KPRIMARY: DataEntryType+DataEntryHeaderKey+DataEntryDetailLineKey

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  DataEntryType . . . . . . . .     2 SNN  Data Entry Type . . . . . . . .
                                                    Valid:11,12,14,15,16,18,21,
                                                    32,38,48 Notes: 11=I/M Sale,
                                                    12=I/M Iss, 14=I/M Trans Out,
                                                     15=I/M Trans In, 16=I/M Adj,
                                                     18=I/M Rcpt, 21=S/O Sale,
                                                    32=B/M Comp Relieve, 38=B/M
                                                    Item Produced, 48-P/O
                                                    Receipt
       2  DataEntryHeaderKey. . . . . .    50 SNY  Data Entry Header Key . . . . .
       3  DataEntryDetailLineKey. . . .     6 SNY  Data Entry Detail Line Key. . .
       4  EntryNo . . . . . . . . . . .    10 SNN  Entry Number. . . . . . . . . .
       5  TransactionDate . . . . . . .     8 SNN  Transaction Date. . . . . . . .DATE
       6  SalesOrderNo. . . . . . . . .     7 SNN  Sales Order Number. . . . . . .SALESORDERNO
       7  OrderType . . . . . . . . . .     1 SNN  Order Type. . . . . . . . . . .
       8  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00
       9  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .CUSTOMERNO
      10  ShipToCode. . . . . . . . . .     4 SNN  Ship To Code. . . . . . . . . .SHIPTO
      11  RMANo . . . . . . . . . . . .     7 SNN  RMA Number. . . . . . . . . . .RMANO
      12  InvoiceNo . . . . . . . . . .     7 SNN  Invoice Number. . . . . . . . .INVOICE
                                                    FmtType:MASTERNUM
      13  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
      14  InvoiceType . . . . . . . . .     2 SNN  Invoice Type. . . . . . . . . .
      15  LineKey . . . . . . . . . . .     6 SNN  Line Key. . . . . . . . . . . .
                                                    Mask:000000
      16  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .ITEMCODE
      17  ItemType. . . . . . . . . . .     1 SNN  Item Type . . . . . . . . . . .
      18  WarehouseCode . . . . . . . .     3 SNN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM
      19  ProductLine . . . . . . . . .     4 SNN  Product Line. . . . . . . . . .PRODUCTLINE
      20  Valuation . . . . . . . . . .     1 SNN  Valuation . . . . . . . . . . .
      21  DropShip. . . . . . . . . . .     1 SNN  Drop Ship . . . . . . . . . . .
      22  OrderWarehouseCode. . . . . .     3 SNN  Order Warehouse Code. . . . . .WAREHOUSE
                                                    FmtType:CHARNUM
      23  OrderLineKey. . . . . . . . .     6 SNN  Order Line Key. . . . . . . . .
      24  CostOverridden. . . . . . . .     1 SNN  Cost Overridden . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      25  InvoiceKitLine. . . . . . . .     1 SYN  Invoice Kit Line. . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      26  InvoiceComponentLine. . . . .     1 SYN  Invoice Component Line. . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      27  JobCostSkipCost . . . . . . .     1 SYN  Job Cost Skip Cost. . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      28  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .APDIVISION
                                                    Mask:00
      29  VendorNo. . . . . . . . . . .     7 SNN  Vendor Number . . . . . . . . .VENDORNO
      30  IMTransactionEntryComment . .    30 SNN  IM Transaction Entry Comment. .COMMENT30
      31  PurchaseOrderDate . . . . . .     8 SNN  Purchase Order Date . . . . . .DATE
      32  PurchaseOrderRecRetHistSeq. .     6 SNN  Purchase Order Receipt or Retur
      33  VendorAliasItem . . . . . . .    30 SNN  Vendor Alias Item . . . . . . .
      34  TierDistributionChannel . . .  5.0  NNN  Tier Distribution Channel . . .
      35  QuantityOrdered . . . . . . . 16.6  NNN  Quantity Ordered. . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
      36  QuantityShipped . . . . . . . 16.6  NNN  Quantity Shipped. . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
      37  QuantityBackordered . . . . . 16.6  NNN  Quantity Backordered. . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
      38  UnitPrice . . . . . . . . . . 16.6  NNN  Unit Price. . . . . . . . . . .PRICE
                                                    Mask:##,###,###.000000-
      39  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .
                                                    Mask:##,###,###.00-
      40  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .COST
                                                    Mask:##,###,###.000000-
      41  UnitOfMeasureConvFactor . . . 12.4  NNN  Unit Of Measure Conversion FactUMCONVFACTOR
                                                    Mask:#####0.0000
      42  TransactionQty. . . . . . . . 16.6  NNN  Transaction Quantity. . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
      43  ExtendedCost. . . . . . . . . 12.2  NNN  Extended Cost . . . . . . . . .COST
                                                    Mask:##,###,###.00-
      44  ExtendedNegQtyAdj . . . . . . 12.2  NNN  Extended Negative Quantity Adju
      45  PurchaseOrderRelieveQty . . . 16.5  NNN  Purchase Order Relieve QuantityQUANTITY
                                                    Mask:##,###,###.00000-
      46  PurchaseOrderCommitQty. . . . 16.5  NNN  Purchase Order Commit Quantity.QUANTITY
                                                    Mask:##,###,###.00000-
      47  ExtendedAllocationAmt . . . . 12.2  NNN  Extended Allocation Amount. . .COST
                                                    Mask:##,###,###.00-