AP_InvoiceHistoryDetail AP Invoice History Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AP_InvoiceHistoryDetail_bus,AP_InvoiceRegister_upd,AP_ManualCheckRegister_upd,AP_ARClearingReg
SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_InvoiceHistoryDetail.M4T"
KPRIMARY: InvoiceNo+HeaderSeqNo+DetailSeqNo
KEXTENDEDDESC: ExtendedDescriptionKey+InvoiceNo+HeaderSeqNo+DetailSeqNo
KTRANSFER: InvoiceNo+HeaderSeqNo+TransferAPDivisionNo+TransferVendorNo
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 10 SNY AP Invoice Number . . . . . . .APINVOICE
Notes: {AP_13$(1,10)}
2 HeaderSeqNo . . . . . . . . . 6 SNY Header Sequence Number. . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {AP_13$(11,3)}
3 DetailSeqNo . . . . . . . . . 6 SNY Detail Sequence Number. . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {AP_13$(14,5)}
4 AccountKey. . . . . . . . . . 9 SNN Account Key . . . . . . . . . .ACCOUNT
Notes: {AP_13$(20,9)}
5 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO
FmtType:CHARNUM Notes:
{AP_13$(29,7)}
6 CostCode. . . . . . . . . . . 9 SYN Cost Code . . . . . . . . . . .COSTCODE
Notes: {AP_13$(36,9)}
7 CostType. . . . . . . . . . . 1 SYN Cost Type . . . . . . . . . . .COSTTYPE
Notes: {AP_13$(45,1)}
8 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT
Notes: {AP_13$(50,20)}
9 TransferAPDivisionNo. . . . . 2 SNN Transfer AP Division Number . .APDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {AP_13$(113,2)}
10 TransferVendorNo. . . . . . . 7 SYN Transfer Vendor Number. . . . .VENDORNO
FmtType:MASTERNUM ChngTag:Rep
lace1/TransferAPDivisionNo$
Notes: {AP_13$(115,7)}
11 TransferInvoiceNo . . . . . . 10 SNN Transfer AP Invoice Number. . .APINVOICE
Notes: {AP_13$(122,10)}
12 TransferForm1099. . . . . . . 1 SNN Transfer 1099 Form. . . . . . .
Notes: {AP_13$(132,1)}
13 TransferBox1099 . . . . . . . 3 SNN Transfer 1099 Box . . . . . . .
Notes: {AP_13$(133,2)}
14 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE
ChngTag:Replace0 Notes:
{AP_13$(20,15)}
15 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION
Notes: {AP_13$(129,30)}
16 ItemType. . . . . . . . . . . 1 SYN Item Type . . . . . . . . . . .
Valid:1,2,3,4,5 Notes:
1=Inventory Item, 2=Special
Item, 3=Charge Item,
4=Comment Item, 5=Miscellaneo
us Item
17 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . .EXTDESCKEY
Read Only:Y
18 UseTax. . . . . . . . . . . . 1 SYN Use Tax . . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{AP_13$(40,1)}
19 RequiredDate. . . . . . . . . 8 SNN Required Date . . . . . . . . .DATE
Notes: {AP_13$(41,6)}
20 VendorPriceCode . . . . . . . 4 SYN Vendor Price Code . . . . . . .
Notes: {AP_13$(67,4)}
21 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)}
22 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE
Notes: {AP_13$(46,4)}
23 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM Notes:
{AP_13$(85,3)}
24 POWarehouseCode . . . . . . . 3 SNN PO Warehouse Code . . . . . . .WAREHOUSE
FmtType:CHARNUM Notes:
{AP_13$(88,3)}
25 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE
Notes: {AP_13$(91,4)}
26 WorkOrderNo . . . . . . . . . 7 SNN Work Order No . . . . . . . . .WORKORDERNO
Notes: {AP_13$(112,7)}
27 WorkOrderStepNo . . . . . . . 4 SNN Work Order Step Number. . . . .
Notes: {AP_13$(119,4)}
28 WorkOrderSubStepPfx . . . . . 1 SNN Work Order Sub-Step Prefix. . .
Notes: {AP_13$(123,1)}
29 WorkOrderSubStepSfx . . . . . 4 SNN Work Order Sub-Step Suffix. . .
Notes: {AP_13$(124,4)}
30 WorkOrderTransactionType. . . 1 SNN Work Order Transaction Type . .
31 VendorAliasItemNo . . . . . . 30 SNN Vendor Alias Item Number. . . .
Notes: {AP_13$(159,30)}
32 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS
Notes: {AP_13$(189,2)}
33 AssetTemplate . . . . . . . . 25 SNN Asset Template. . . . . . . . .ASSETTEMPLATE
34 RetentionRate . . . . . . . . 7.2 NNN Retention Rate. . . . . . . . .AMOUNT
Mask:###.00- Notes:
{AP_13[2]}
35 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{AP_13[4]}
36 TransferDiscount. . . . . . . 13.2 NNN Transfer Discount . . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{AP_13[5]}
37 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . .QUANTITY
Mask:##,###,###.000000-
Notes: {AP_13[0]}
38 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . .QUANTITY
Mask:##,###,###.000000-
Notes: {AP_13[1]}
39 QuantityInvoiced. . . . . . . 16.6 NNN Quantity Invoiced . . . . . . .QUANTITY
Mask:##,###,###.000000-
Notes: {AP_13[2]}
40 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST
Mask:##,###,###.000000-
Notes: {AP_13[3]}
41 OriginalUnitCost. . . . . . . 16.6 NNN Original Unit Cost. . . . . . .COST
Mask:##,###,###.000000-
42 ExtensionAmt. . . . . . . . . 13.2 NNN Extension Amount. . . . . . . .AMOUNT
Mask:###,###,###.00 Notes:
{AP_13[4]}
43 QuantityOrderedOriginal . . . 16.6 NNN Quantity Ordered Original . . .QUANTITY
Mask:##,###,###.000000-
Notes: {AP_13[5]}
44 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR
Mask:#####0.0000 Notes:
{AP_13[6]}