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-