AP_InvoiceDetailPosting AP Invoice Detail Posting Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_InvoiceRegister_upd,AP_ManualCheckRegister_upd,PO_ReceiptRegister_upd,PO_ReturnRegister_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_InvoiceDetailPosting.M4T"
KPRIMARY: InvoiceNo
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 10 SNN AP Invoice Number . . . . . . . 2 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION Mask:00 3 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO 4 InvoiceHistoryHeaderSeqNo . . 6 SNN Invoice History Header Sequence 5 AccountKey. . . . . . . . . . 9 SNN Account KEY . . . . . . . . . . 6 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . FmtType:CHARNUM 7 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . . 8 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . . 9 CommentText . . . . . . . . . 2048 SNN Comment TEXT. . . . . . . . . . 10 TransferAPDivisionNo. . . . . 2 SNN Transfer AP Division Number . . 11 TransferVendorNo. . . . . . . 7 SNN Transfer Vendor Number. . . . . 12 TransferInvoiceNo . . . . . . 10 SNN Transfer AP Invoice Number. . . 13 TransferForm1099. . . . . . . 1 SNN Transfer 1099 Form. . . . . . . 14 TransferBox1099 . . . . . . . 3 SNN Transfer 1099 BOX . . . . . . . 15 AssetTemplate . . . . . . . . 25 SNN Asset Template. . . . . . . . .ASSETTEMPLATE 16 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE 17 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION 18 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . .EXTDESCKEY Read Only:Y ValGroup:NootComm ent,ItemRequired 19 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 20 UseTax. . . . . . . . . . . . 1 SYN Use Tax . . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 21 RequiredDate. . . . . . . . . 8 SNN Required Date . . . . . . . . .DATE 22 VendorPriceCode . . . . . . . 4 SNN Vendor Price Code . . . . . . . 23 Valuation . . . . . . . . . . 1 SNN Valuation . . . . . . . . . . . Valid:1,2,3,4,5,6 Notes: 1=Standard, 2=Average, 3=Fifo, 4=Lifo, 5=Lot, 6=Serial {AP_13$(80,1)} 24 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . . 25 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM 26 POWarehouseCode . . . . . . . 3 SNN PO Warehouse Code . . . . . . .WAREHOUSE FmtType:CHARNUM 27 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE 28 WorkOrderNo . . . . . . . . . 7 SNN Work Order Number . . . . . . . 29 WorkOrderStepNo . . . . . . . 4 SNN Work Order Step Number. . . . . 30 WorkOrderSubStepPfx . . . . . 1 SNN Work Order Sub-Step Prefix. . . 31 WorkOrderSubStepSfx . . . . . 4 SNN Work Order Sub-Step Suffix. . . 32 WorkOrderTransactionType. . . 1 SNN Work Order Transaction Type . . 33 VendorAliasItemNo . . . . . . 30 SNN Vendor Alias Item Number. . . . 34 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS 35 ReceiptType . . . . . . . . . 1 SYY Receipt Type. . . . . . . . . . 36 ReceiptNo . . . . . . . . . . 6 SNN Receipt Number. . . . . . . . .RECEIPTNO Mask:000000 37 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . . 38 RetentionRate . . . . . . . . 7.2 NNN Retention Rate. . . . . . . . . 39 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . . 40 OriginalUnitCost. . . . . . . 16.6 NNN Original Unit Cost. . . . . . .COST Mask:##,###,###.000000- 41 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . . 42 TransferDiscount. . . . . . . 13.2 NNN Transfer Discount . . . . . . . 43 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . .QUANTITY Mask:##,###,###.000000- 44 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . .QUANTITY Mask:##,###,###.000000- 45 QuantityInvoiced. . . . . . . 16.6 NNN Quantity Invoiced . . . . . . .QUANTITY Mask:##,###,###.000000- 46 QuantityOrderedOriginal . . . 16.6 NNN Quantity Ordered Original . . .QUANTITY Mask:##,###,###.000000- 47 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR Mask:#####0.0000 48 ExtensionAmt. . . . . . . . . 13.2 NNN Extension Amount. . . . . . . .AMOUNT Mask:###,###,###.00 49 AllocatedFreight. . . . . . . 13.2 NNN Allocated Freight . . . . . . .AMOUNT Mask:###,###,###.00 50 AllocatedTaxAmt . . . . . . . 12.2 NNN Allocated Tax Amount. . . . . .MISCAMOUNT Mask:##,###,###.00-