AP_InvoiceHistoryAsset AP Invoice History Asset Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_InvoiceRegister_Upd,AP_ManualCheckRegister_Upd,PO_ReceiptRegister_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_InvoiceHistoryAsset.M4T"
KPRIMARY: InvoiceNo+HeaderSeqNo+DetailSeqNo+SystemNo KSOURCEJOURNAL: SourceJournal+RegisterNo+InvoiceNo+HeaderSeqNo+DetailSeqNo+SystemNo
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 10 SNY Invoice Number. . . . . . . . .INVOICE10 2 HeaderSeqNo . . . . . . . . . 6 SNY Header Sequence Number. . . . . 3 DetailSeqNo . . . . . . . . . 6 SNY Detail Sequence Number. . . . . 4 SystemNo. . . . . . . . . . . 25 SNY System Number . . . . . . . . . 5 SourceJournal . . . . . . . . 2 SYN Source Journal. . . . . . . . .SOURCEJOURNAL 6 RegisterNo. . . . . . . . . . 6 SNN Register Number . . . . . . . . 7 PostingDate . . . . . . . . . 8 SNN Posting Date. . . . . . . . . .DATE 8 ModuleCode. . . . . . . . . . 3 SNN Module Code . . . . . . . . . . 9 PurchaseOrderNo . . . . . . . 7 SNN Purchase Order Number . . . . .PURCHASEORDERNO 10 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 11 VendorNo. . . . . . . . . . . 7 SNN VendorNumber. . . . . . . . . . 12 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 13 AccountKey. . . . . . . . . . 9 SNN Account Key . . . . . . . . . . 14 Account . . . . . . . . . . . 41 SYN Fully Formatted Account Number. 15 AssetTemplate . . . . . . . . 25 SNN Asset Template. . . . . . . . .ASSETTEMPLATE 16 AssetTemplateDesc . . . . . . 80 SNN Asset Template Description. . . 17 AcquiredDate. . . . . . . . . 8 SNN Acquired Date . . . . . . . . .DATE 18 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST Mask:##,###,###.000000- 19 LandedCost. . . . . . . . . . 16.6 NNN Landed Cost . . . . . . . . . .COST Mask:##,###,###.000000- 20 TotalCost . . . . . . . . . . 16.6 NNN Total Cost. . . . . . . . . . .COST Mask:##,###,###.000000-