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]}