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