AP_InvoiceHeaderPosting AP Invoice Header Posting 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_InvoiceHeaderPosting.M4T"
KPRIMARY: InvoiceNo
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 10 SNN AP Invoice Number . . . . . . .
2 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .
3 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . .
4 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . .NAME
5 InvoiceDate . . . . . . . . . 8 SNN Date. . . . . . . . . . . . . .DATE
6 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE
7 InvoiceDiscountDate . . . . . 8 SNN Invoice Discount Date . . . . .DATE
8 TermsCode . . . . . . . . . . 2 SNN AP Terms Code . . . . . . . . .
9 HoldPayment . . . . . . . . . 1 SNN Hold Payment. . . . . . . . . .
10 Comment . . . . . . . . . . . 40 SNN Comment . . . . . . . . . . . .
11 PrepaidApplyToInvoiceNo . . . 10 SNN Pre-Paid Apply To Invoice Numbe
12 PrepaidPaymentDate. . . . . . 8 SNN Pre-Paid Payment Invoice Date .DATE
13 PrepaidCheckNo. . . . . . . . 10 SNN Pre-Paid Check Number . . . . .
14 SourceJournal . . . . . . . . 2 SNN Source Journal. . . . . . . . .
15 Form1099. . . . . . . . . . . 1 SNN 1099 Form . . . . . . . . . . .
16 Box1099 . . . . . . . . . . . 3 SNN 1099 BOX. . . . . . . . . . . .
17 SeparateCheck . . . . . . . . 1 SNN Separate Check. . . . . . . . .
18 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . .
FmtType:CHARNUM
19 Adjustment. . . . . . . . . . 1 SYN Adjustment. . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
20 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . .
21 TaxClass. . . . . . . . . . . 2 SNN Tax CLASS . . . . . . . . . . .
22 UseTax. . . . . . . . . . . . 1 SNN Use Tax . . . . . . . . . . . .
23 PurchaseOrderNo . . . . . . . 7 SNN Purchase Order Number . . . . .PURCHASEORDERNO
24 ReceiptNo . . . . . . . . . . 6 SYN Receipt Number. . . . . . . . .RECEIPTNO
Mask:0000000
25 ReceiptDate . . . . . . . . . 8 SNN Receipt Date. . . . . . . . . .DATE
26 PurchaseAddressCode . . . . . 4 SYN Purchase Address Code . . . . .PURCHASEADDRCODE
27 PurchaseName. . . . . . . . . 30 SNN Purchase Name . . . . . . . . .NAME
28 PurchaseAddress1. . . . . . . 30 SNN Purchase Address 1. . . . . . .ADDRESSLINE
29 PurchaseAddress2. . . . . . . 30 SNN Purchase Address 2. . . . . . .ADDRESSLINE
30 PurchaseAddress3. . . . . . . 30 SNN Purchase Address 3. . . . . . .ADDRESSLINE
31 PurchaseCity. . . . . . . . . 20 SNN Purchase City . . . . . . . . .CITY
32 PurchaseState . . . . . . . . 2 SNN Purchase State. . . . . . . . .STATE
33 PurchaseZipCode . . . . . . . 10 SNN Purchase Zip Code . . . . . . .ZIPCODE
34 PurchaseCountryCode . . . . . 3 SNN Purchase Country Code . . . . .COUNTRY
35 ShipToCode. . . . . . . . . . 4 SYN Ship To Code. . . . . . . . . .
36 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . .NAME
37 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . .ADDRESSLINE
38 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . .ADDRESSLINE
39 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . .ADDRESSLINE
40 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . .CITY
41 ShipToState . . . . . . . . . 2 SNN Ship To State . . . . . . . . .STATE
42 ShipToZipCode . . . . . . . . 10 SNN Ship To Zip Code. . . . . . . .ZIPCODE
43 ShipToCountryCode . . . . . . 3 SNN Ship To Country Code. . . . . .COUNTRY
44 RequiredDate. . . . . . . . . 8 SNN Required Date . . . . . . . . .DATE
45 ShipVia . . . . . . . . . . . 15 SNN Ship Via. . . . . . . . . . . .SHIPCODE
46 FOB . . . . . . . . . . . . . 15 SNN F.O.B.. . . . . . . . . . . . .
47 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM
48 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . .
49 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION
Mask:00
50 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO
51 CODCheckNo. . . . . . . . . . 10 SNN COD Check No. . . . . . . . . .
52 CheckNo . . . . . . . . . . . 10 SNN Check Number. . . . . . . . . .
53 CheckDate . . . . . . . . . . 8 SNN Check Date. . . . . . . . . . .DATE
54 BankCode. . . . . . . . . . . 1 SNN Bank Code . . . . . . . . . . .
55 PurchaseOrderType . . . . . . 1 SYN Purchase Order Type . . . . . .
56 PurchaseOrderDate . . . . . . 8 SNN Purchase Order Date . . . . . .
57 CODNo . . . . . . . . . . . . 10 SNN COD Number. . . . . . . . . . .
58 UserKey . . . . . . . . . . . 10 SYY User Key. . . . . . . . . . . .USER
Mask:0000000000
59 TaxableMiscChargeAmt. . . . . 13.2 NNN Taxable Miscellaneous Charge AmAMOUNT
Mask:###,###,###.00
60 NonTaxableMiscChargeAmt . . . 13.2 NNN Non-Taxable Miscellaneous ChargAMOUNT
Mask:###,###,###.00
61 TotalCostForFrghtAlloc. . . . 13.2 NNN Total Cost for Freight AllocatiAMOUNT
Mask:###,###,###.00
62 PrepaidFreight. . . . . . . . 13.2 NNN Prepaid Freight . . . . . . . .AMOUNT
Mask:###,###,###.00
63 CODAmount . . . . . . . . . . 13.2 NNN COD Amount. . . . . . . . . . .AMOUNT
Mask:###,###,###.00
64 RecurringInvoice. . . . . . . 1 SNN Recurring Invoice . . . . . . .
65 InvoiceAmt. . . . . . . . . . 13.2 NNN Invoice Amount. . . . . . . . .
66 NetInvoiceAmt . . . . . . . . 13.2 NNN Net Invoice Amount. . . . . . .
67 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . .
68 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .
69 PrepaymentAmt . . . . . . . . 13.2 NNN Prepayment Amount . . . . . . .
70 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .
71 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .
72 FreightAmt. . . . . . . . . . 13.2 NNN Freight Amount. . . . . . . . .
73 TaxAmt. . . . . . . . . . . . 13.2 NNN Tax Amount. . . . . . . . . . .
74 NonRecoverableAmt . . . . . . 13.2 NNN Non Recoverable Amount. . . . .