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-