AP_OpenInvoice AP Open Invoice Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AP_OpenInvoice_bus,AP_ARClearingRegister_upd,AP_InvoiceRegister_upd,AP_ManualCheckRegister_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_OpenInvoice.M4T"
KPRIMARY: APDivisionNo+VendorNo+InvoiceNo
KINVOICE: APDivisionNo+VendorNo+InvoiceDate+InvoiceNo
KINVOICEDECENDING: APDivisionNo+VendorNo+InvoiceDate(d)+InvoiceNo
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {AP4$(1,2)}
2 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO
FmtType:MASTERNUM ChngTag:Rep
lace1/APDivisionNo$ Notes:
{AP4$(3,7)}
3 InvoiceNo . . . . . . . . . . 10 SNY AP Invoice Number . . . . . . .APINVOICE
Notes: {AP4$(10,10)}
4 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE
ChngTag:Min Notes: {AP4$(20,
6)}
5 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE
ChngTag:Min Notes: {AP4$(26,
6)}
6 InvoiceDiscountDate . . . . . 8 SNN Invoice Discount Date . . . . .DATE
ChngTag:Min Notes: {AP4$(32,
6)}
7 InvoiceHistoryHeaderSeqNo . . 6 SNN Invoice History Header Sequence
Mask:000000
8 PostingDate . . . . . . . . . 8 SNN Posting Date. . . . . . . . . .DATE
9 TermsCode . . . . . . . . . . 2 SYN Terms Code. . . . . . . . . . .APTERMS
Mask:00 Notes: {AP4$(38,2)}
10 HoldPayment . . . . . . . . . 1 SYN Hold Payment. . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{AP4$(40,1)}
11 Comment . . . . . . . . . . . 40 SNN Comment . . . . . . . . . . . .
Notes: {AP4$(41,30)}
12 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO
FmtType:CHARNUM Notes:
{AP4$(71,7)}
13 CheckNo . . . . . . . . . . . 10 SNN AP Check Number . . . . . . . .APCHECKNO
Notes: {AP4$(78,6)}
14 CheckDate . . . . . . . . . . 8 SNN Check Date. . . . . . . . . . .DATE
Notes: {AP4$(84,6)}
15 PaidToday . . . . . . . . . . 1 SYN Paid Today. . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{AP4$(90,1)}
16 Form1099. . . . . . . . . . . 1 SNN 1099 Form . . . . . . . . . . .
Notes: {AP4$(91,1)}
17 Box1099 . . . . . . . . . . . 3 SNN 1099 Box. . . . . . . . . . . .
Notes: {AP4$(92,2)}
18 SeparateCheck . . . . . . . . 1 SYN Separate Check. . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{AP4$(94,1)}
19 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE
Notes: {AP4$(95,9)}
20 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS
Notes: {AP4$(104,2)}
21 UseTax. . . . . . . . . . . . 1 SYN Use Tax . . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{AP4$(106,1)}
22 InvoiceAmt. . . . . . . . . . 13.2 NNN Invoice Amount. . . . . . . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {AP4[0]}
23 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {AP4[1]}
24 RetentionCost . . . . . . . . 13.2 NNN Retention Cost. . . . . . . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {AP4[2]}
25 Balance . . . . . . . . . . . 13.2 NNN Balance . . . . . . . . . . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {AP4[3]}
26 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {AP4[4]}
27 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {AP4[5]}
28 FreightAmt. . . . . . . . . . 13.2 NNN Freight Amount. . . . . . . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {AP4[6]}
29 TaxAmt. . . . . . . . . . . . 13.2 NNN Tax Amount. . . . . . . . . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {AP4[7]}
30 NonRecoverableAmt . . . . . . 13.2 NNN Non-Recoverable Amount. . . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {AP4[8]}
31 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y ChngTag:Max
Notes: YYYYMMDD
32 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y ChngTag:CopyMax/D
ateUpdated$
33 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
ChngTag:CopyMax/DateUpdated$