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-