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$