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