AP_ManualCheckDetail AP Manual Check Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AP_ManualCheckDetail_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_ManualCheckDetail.M4T"
KPRIMARY: BankCode+CheckNo+LineKey
KDISPLAY: BankCode+CheckNo+LineSeqNo+LineKey
KINVOICE: InvoiceNo+BankCode+CheckNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 BankCode. . . . . . . . . . . 1 SYY Bank Code . . . . . . . . . . .BANKCODE
Read Only:Y Notes: {AP8$(1,
1)}
2 CheckNo . . . . . . . . . . . 10 SNY AP Check Number . . . . . . . .APCHECKNO
Read Only:Y Notes: {AP8$(2,
6)}
3 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . .
Read Only:Y Mask:000000
FmtType:ZEROFILL
4 LineSeqNo . . . . . . . . . . 14 SNY Line Sequence Number. . . . . .
Read Only:Y Mask:000000000000
0 FmtType:ZEROFILL
5 InvoiceNo . . . . . . . . . . 10 SYY AP Invoice Number . . . . . . .APINVOICE
Notes: {AP7$(8,10)}
6 InvoiceType . . . . . . . . . 1 SNY Invoice Type. . . . . . . . . .
Read Only:Y Valid:A,B,C
Notes: {AP7$(18,1)}, A=New
Invoice Record, B=Invoice On
File In AR4, C=Invoice
reinstated from hist
7 InvoiceDate . . . . . . . . . 8 SNN Date. . . . . . . . . . . . . .DATE
Notes: {AP7$(27,7)}
8 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . .JOBNO
FmtType:CHARNUM Notes:
{AP7${64,7)}
9 Form1099. . . . . . . . . . . 1 SNN 1099 Form . . . . . . . . . . .FORM1099
ValGroup:InvoiceNoRequired
Notes: {AP7$(71,1)}
10 Box1099 . . . . . . . . . . . 3 SNN 1099 Box. . . . . . . . . . . .BOX1099
ValGroup:InvoiceNoRequired
Notes: {AP7$(72,2)}
11 InvoiceComment. . . . . . . . 40 SNN Invoice Comment . . . . . . . .
Notes: {AP8$(31,20)}
12 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:InvoiceNoRequired
Notes: {AP7$(120,9)}
13 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS
DepVal:REQUIRED ValGroup:Invo
iceNoRequired Notes:
{AP7$(129,2)}
14 InvalidTaxCalc. . . . . . . . 1 SNN Invalid Tax Calculation . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{AP7$(131,1)}
15 UseTax. . . . . . . . . . . . 1 SNN Use Tax . . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:InvoiceNoRequired
Notes: {AP7$(132,1)}
16 InvoiceAmt. . . . . . . . . . 13.2 NNN Invoice Amount. . . . . . . . .AMOUNT
Mask:###,###,###.00-
ValGroup:InvoiceNoRequired
Notes: {AP7[0]}
17 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . .AMOUNT
Mask:###,###,###.00-
ValGroup:InvoiceNoRequired
Notes: {AP7[1]}
18 UnappliedDiscountAmt. . . . . 13.2 NNN Unapplied Discount Amount . . .AMOUNT
Mask:###,###,###.00-
19 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{AP7[2]}
20 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{AP7[4]}
21 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{AP7[5]}
22 FreightAmt. . . . . . . . . . 13.2 NNN Freight Amount. . . . . . . . .AMOUNT
Mask:###,###,###.00-
ValGroup:InvoiceNoRequired
Notes: {AP7[6]}
23 TaxAmt. . . . . . . . . . . . 13.2 NNN Tax Amount. . . . . . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{AP7[7]}
24 NonRecoverableAmt . . . . . . 13.2 NNN Non-Recoverable Amount. . . . .AMOUNT
Mask:###,###,###.00- Notes:
{AP7[8]}