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]}