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-