AP_InvoiceHistoryHeader AP Invoice History Header Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_InvoiceHistory_bus,AP_InvoiceRegister_upd,AP_ManualCheckRegister_upd,AP_ARClearingRegister_ SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_InvoiceHistoryHeader.M4T"
KPRIMARY: InvoiceNo+HeaderSeqNo KVENDOR: APDivisionNo+VendorNo+InvoiceNo+HeaderSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 10 SNY AP Invoice Number . . . . . . .APINVOICE Notes: {AP_12$(1,10)} 2 HeaderSeqNo . . . . . . . . . 6 SNY Header Sequence Number. . . . . Mask:000000 FmtType:ZEROFILL Notes: {AP_12$(11,3)} 3 ModuleCode. . . . . . . . . . 3 SNN Module Code . . . . . . . . . .MODULECODE Notes: {AP_12$(14,2)} 4 InvoiceType . . . . . . . . . 1 SYN Invoice Type. . . . . . . . . . Notes: {AP_12$(16,1)} 5 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL Notes: {AP_12$(17,2)} 6 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM ChngTag:Rep lace1/APDivisionNo$ Notes: {AP_12$(19,7)} 7 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE Notes: {AP_12$(26,6)} 8 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE Notes: {AP_12$(32,6)} 9 InvoiceDiscountDate . . . . . 8 SNN Invoice Discount Date . . . . .DATE Notes: {AP_12$(38,6)} 10 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE Notes: {AP_12$(116,6)} 11 TermsCode . . . . . . . . . . 2 SYN AP Terms Code . . . . . . . . .APTERMS Notes: {AP_12$(44,2)} 12 HoldPayment . . . . . . . . . 1 SYN Hold Payment. . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AP_12$(46,1)} 13 Comment . . . . . . . . . . . 40 SNN Comment . . . . . . . . . . . . Notes: {AP_12$(47,30)} 14 PrepaidApplyToInvoiceNo . . . 10 SNN Pre-Paid Apply To Invoice NumbeAPINVOICE Notes: {AP_12$(77,10)} 15 PrepaidPaymentDate. . . . . . 8 SNN Pre-Paid Payment Invoice Date .DATE Notes: {AP_12$(87,6)} 16 PrepaidCheckNo. . . . . . . . 10 SNN Pre-Paid Check Number . . . . .APCHECKNO Notes: {AP_12$(93,6)} 17 SourceJournal . . . . . . . . 2 SYN Source Journal. . . . . . . . .SOURCEJOURNAL Notes: {AP_12$(99,2)} 18 SourceJournalNo . . . . . . . 6 SNN Source Journal Number . . . . . Mask:000000 FmtType:ZEROFILL Notes: {AP_12$(101,4)} 19 Form1099. . . . . . . . . . . 1 SNN 1099 Form . . . . . . . . . . . Notes: {AP_12$(105,1)} 20 Box1099 . . . . . . . . . . . 3 SNN 1099 Box. . . . . . . . . . . . Notes: {AP_12$(106,2)} 21 SeparateCheck . . . . . . . . 1 SYN Separate Check. . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AP_12$(108,1)} 22 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO FmtType:CHARNUM Notes: {AP_12$(109,7)} 23 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . .NAME Notes: If AP_12$(14,2)="AP" {AP_12$(122,30)}, If AP_12$(14,2)="PO" {AP_12$(141 ,30)} 24 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE Notes: {AP_12$(599,9)} 25 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS Notes: {AP_12$(608,2)} 26 UseTax. . . . . . . . . . . . 1 SYN Use Tax . . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AP_12$(610,1)} 27 PurchaseOrderNo . . . . . . . 7 SNN Purchase Order Number . . . . .PURCHASEORDERNO Notes: {AP_12$(134,7)} 28 ReceiptNo . . . . . . . . . . 6 SYN Receipt Number. . . . . . . . .RECEIPTNO Notes: {AP_12$(122,6)} 29 ReceiptDate . . . . . . . . . 8 SNN Receipt Date. . . . . . . . . .DATE Notes: {AP_12$(128,6)} 30 PurchaseAddressCode . . . . . 4 SYN Purchase Address Code . . . . .PURCHASEADDRCODE Notes: {AP_12$(495,4)} 31 PurchaseName. . . . . . . . . 30 SNN Purchase Name . . . . . . . . .NAME Notes: {AP_12$(141,30)} 32 PurchaseAddress1. . . . . . . 30 SNN Purchase Address 1. . . . . . .ADDRESSLINE Notes: {AP_12$(171,30)} 33 PurchaseAddress2. . . . . . . 30 SNN Purchase Address 2. . . . . . .ADDRESSLINE Notes: {AP_12$(201,30)} 34 PurchaseAddress3. . . . . . . 30 SNN Purchase Address 3. . . . . . .ADDRESSLINE Notes: {AP_12$(231,30)} 35 PurchaseCity. . . . . . . . . 20 SNN Purchase City . . . . . . . . .CITY Notes: {AP_12$(261,20)} 36 PurchaseState . . . . . . . . 2 SNN Purchase State. . . . . . . . .STATE Notes: {AP_12$(281,2)} 37 PurchaseZipCode . . . . . . . 10 SNN Purchase Zip Code . . . . . . .ZIPCODE Notes: {AP_12$(303,10)} 38 PurchaseCountryCode . . . . . 3 SNN Purchase Country Code . . . . .COUNTRY Notes: {AP_12$(283,3)} 39 ShipToCode. . . . . . . . . . 4 SYN Ship To Code. . . . . . . . . . Notes: {AP_12$(313,4)} This is a dual purpose field and could hold either the PO Ship To Code or SO Ship To Code. 40 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . .NAME Notes: {AP_12$(317,30)} 41 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . .ADDRESSLINE Notes: {AP_12$(347,30)} 42 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . .ADDRESSLINE Notes: {AP_12$(377,30)} 43 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . .ADDRESSLINE Notes: {AP_12$(407,30)} 44 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . .CITY Notes: {AP_12$(437,20)} 45 ShipToState . . . . . . . . . 2 SNN Ship To State . . . . . . . . .STATE Notes: {AP_12$(457,2)} 46 ShipToZipCode . . . . . . . . 10 SNN Ship To Zip Code. . . . . . . .ZIPCODE Notes: {AP_12$(479,10)} 47 ShipToCountryCode . . . . . . 3 SNN Ship To Country Code. . . . . .COUNTRY Notes: {AP_12$(459,3)} 48 RequiredDate. . . . . . . . . 8 SNN Required Date . . . . . . . . .DATE Notes: {AP_12$(489,6)} 49 ShipVia . . . . . . . . . . . 15 SNN Ship Via. . . . . . . . . . . .SHIPCODE Notes: {AP_12$(500,15)} 50 FOB . . . . . . . . . . . . . 15 SNN F.O.B.. . . . . . . . . . . . . Notes: {AP_12$(515,15)} 51 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM Notes: {AP_12$(530,3)} 52 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . . Notes: {AP_12$(533,30)} 53 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {AP_12$(563.2)} 54 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC Notes: {AP_12$(565,7)} 55 CODCheckNo. . . . . . . . . . 10 SNN COD Check No. . . . . . . . . . Notes: {AP_12$(572,6)} 56 BankCode. . . . . . . . . . . 1 SYN Bank Code . . . . . . . . . . .BANKCODE Notes: {AP_12$(578,1)} 57 PurchaseOrderType . . . . . . 1 SYN Purchase Order Type . . . . . . Notes: {AP_12$(579,1)} 58 PurchaseOrderDate . . . . . . 8 SNN Purchase Order Date . . . . . .DATE Notes: {AP_12$(580,6)} 59 CODNo . . . . . . . . . . . . 10 SNN COD Number. . . . . . . . . . . Notes: {AP_12$(586,10)} 60 UserKey . . . . . . . . . . . 10 SYN User Key. . . . . . . . . . . .USER Read Only:Y Mask:0000000000 Notes: {AP_12$(596,3)} 61 InvoiceAmt. . . . . . . . . . 13.2 NNN Invoice Amount. . . . . . . . .AMOUNT Mask:###,###,###.00- Notes: {AP_12[0]} 62 NetInvoiceAmt . . . . . . . . 13.2 NNN Net Invoice Amount. . . . . . .AMOUNT Mask:###,###,###.00- Notes: {AP_12[1]} 63 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . .AMOUNT Mask:###,###,###.00- Notes: {AP_12[2]} 64 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .AMOUNT Mask:###,###,###.00- Notes: {AP_12[3]} 65 PrepaymentAmt . . . . . . . . 13.2 NNN Prepayment Amount . . . . . . .AMOUNT Mask:###,###,###.00- Notes: {AP_12[4]} 66 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT Mask:###,###,###.00- Notes: {AP_12[5]} 67 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT Mask:###,###,###.00- Notes: {AP_12[6]} 68 FreightAmt. . . . . . . . . . 13.2 NNN Freight Amount. . . . . . . . .AMOUNT Mask:###,###,###.00- Notes: {AP_12[7]} 69 TaxAmt. . . . . . . . . . . . 13.2 NNN Tax Amount. . . . . . . . . . .AMOUNT Mask:###,###,###.00- Notes: {AP_12[8]} 70 NonRecoverableAmt . . . . . . 13.2 NNN Non-Recoverable Amount. . . . .AMOUNT Mask:###,###,###.00- Notes: {AP_12[9]} 71 TaxableMiscChargeAmt. . . . . 13.2 NNN Taxable Miscellaneous Charge AmAMOUNT Mask:###,###,###.00 Notes: {AP_12[7]} 72 NonTaxableMiscChargeAmt . . . 13.2 NNN Non-Taxable Miscellaneous ChargAMOUNT Mask:###,###,###.00 Notes: {AP_12[8]} 73 TotalCostForFrghtAlloc. . . . 13.2 NNN Total Cost for Freight AllocatiAMOUNT Mask:###,###,###.00 Notes: {AP_12[9]} 74 PrepaidFreight. . . . . . . . 13.2 NNN Prepaid Freight . . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {AP_12[10]} 75 CODAmount . . . . . . . . . . 13.2 NNN COD Amount. . . . . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {AP_12[11]} 76 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 77 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 78 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000