     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$