AP_InvoiceHistoryWrk AP Invoice History Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_InvoiceHistoryReport_rpt,AP_InvoiceHistoryListInv_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_InvoiceHistoryWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 30 SNN Group Field . . . . . . . . . . 3 InvoiceNo . . . . . . . . . . 10 SNN AP Invoice Number . . . . . . . 4 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . . 5 DetailSeqNo . . . . . . . . . 6 SNN Detail Sequence Number. . . . . 6 ModuleCode. . . . . . . . . . 3 SNN Module Code . . . . . . . . . . 7 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . 8 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 9 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 10 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 11 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 12 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . . 13 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . . 14 Comment . . . . . . . . . . . 40 SNN Comment . . . . . . . . . . . . 15 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 16 TaxClass. . . . . . . . . . . 2 SNN Tax Class . . . . . . . . . . . 17 UseTax. . . . . . . . . . . . 2 SNN Use Tax . . . . . . . . . . . . 18 PurchaseOrderNo . . . . . . . 7 SNN Purchase Order Number . . . . . 19 PurchaseName. . . . . . . . . 30 SNN Purchase Name . . . . . . . . . 20 PurchaseAddress1. . . . . . . 30 SNN Purchase Address 1. . . . . . . 21 PurchaseAddress2. . . . . . . 30 SNN Purchase Address 2. . . . . . . 22 PurchaseAddress3. . . . . . . 30 SNN Purchase Address 3. . . . . . . 23 PurchaseCity. . . . . . . . . 20 SNN Purchase City . . . . . . . . . 24 PurchaseState . . . . . . . . 2 SNN Purchase State. . . . . . . . . 25 PurchaseZipCode . . . . . . . 10 SNN PurchaseZipCode . . . . . . . . 26 PurchaseCountryCode . . . . . 3 SNN Purchase Country Code . . . . . 27 PurchaseCountryCodeName . . . 30 SNN Purchase Country Code Name. . . 28 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . . 29 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . . 30 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . . 31 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . . 32 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . . 33 ShipToState . . . . . . . . . 3 SNN Ship To State . . . . . . . . . 34 ShipToZipCode . . . . . . . . 10 SNN Ship To Zip Code. . . . . . . . 35 ShipToCountryCode . . . . . . 3 SNN Ship To Country Code. . . . . . 36 ShipToCountryName . . . . . . 30 SNN Ship To Country Name. . . . . . 37 ShipVia . . . . . . . . . . . 15 SNN Ship Via. . . . . . . . . . . . 38 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . . 39 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . 40 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . . 41 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . . 42 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . . 43 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . . 44 TransferAPDivisionNo. . . . . 2 SNN Transfer AP Division Number . . 45 TransferVendorNo. . . . . . . 7 SNN Transfer Vendor Number. . . . . 46 TransferVendorName. . . . . . 30 SNN Transfer Vendor Name. . . . . . 47 TransferInvoiceNo . . . . . . 10 SNN Transfer Invoice Number . . . . 48 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 49 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 50 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 51 AccountKey. . . . . . . . . . 9 SNN Account Key . . . . . . . . . . 52 Account . . . . . . . . . . . 41 SNN Fully Formatted Account . . . . 53 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . . 54 UseTaxDetail. . . . . . . . . 1 SNN Use Tax Detail. . . . . . . . . 55 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 56 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . . 57 TaxClassDetail. . . . . . . . 2 SNN Tax Class Detail. . . . . . . . 58 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 59 ProductLineDesc . . . . . . . 25 SNN Product Line Description. . . . 60 TaxDetailFormatted. . . . . . 460 SNN Tax Detail Formatted. . . . . . 61 InvoiceAmt. . . . . . . . . . 13.2 NNN Invoice Amount. . . . . . . . . 62 NetInvoiceAmt . . . . . . . . 13.2 NNN Net Invoice Amount. . . . . . . 63 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . . 64 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . . 65 PrepaymentAmt . . . . . . . . 13.2 NNN Prepayment Amount . . . . . . . 66 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . . 67 NonTaxableAmt . . . . . . . . 13.2 NNN Non Taxable Amount. . . . . . . 68 FreightAmt. . . . . . . . . . 13.2 NNN Freight Amount. . . . . . . . . 69 TaxAmt. . . . . . . . . . . . 13.2 NNN Tax Amount. . . . . . . . . . . 70 UseTaxAmt . . . . . . . . . . 13.2 NNN Use Tax Amount. . . . . . . . . 71 TaxableMiscChargeAmt. . . . . 13.2 NNN Taxable Miscellaneous Charge Am 72 NonTaxableMiscChargeAmt . . . 13.2 NNN Non Taxable Miscellaneous Charg 73 RetentionAmtDetail. . . . . . 13.2 NNN Retention Amount Detail . . . . 74 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . . 75 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . . 76 QuantityInvoiced. . . . . . . 16.6 NNN Quantity Invoiced . . . . . . . 77 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . . 78 ExtensionAmt. . . . . . . . . 13.2 NNN Extension Amount. . . . . . . .