     AP_InvoiceRegisterWrk                 AP Invoice Register Work        Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AP_InvoiceRegister_upd,PO_ReceiptRegister_upd,PO_ReturnRegister_upd
     SQL Def: Y  SysDB: N                          "MAS_"+%C$+"/AP"+%C$+"/AP_InvoiceRegisterWrk"+%S$+".M4T"

     KPRIMARY: SortField

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
       2  GroupField. . . . . . . . . .    30 SNN  Group Field . . . . . . . . . .
       3  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .
       4  APDivisionDesc. . . . . . . .    30 SNN  AP Division Description . . . .
       5  VendorNo. . . . . . . . . . .     7 SNN  Vendor Number . . . . . . . . .
       6  VendorName. . . . . . . . . .    30 SNN  Vendor Name . . . . . . . . . .
       7  InvoiceNo . . . . . . . . . .    10 SNN  Invoice Number. . . . . . . . .
       8  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
       9  InvoiceDueDate. . . . . . . .     8 SNN  Invoice Due Date. . . . . . . .DATE
      10  InvoiceDiscountDate . . . . .     8 SNN  Invoice Discount Date . . . . .DATE
      11  HoldPayment . . . . . . . . .     1 SNN  Hold Payment. . . . . . . . . .
      12  Comment . . . . . . . . . . .    40 SNN  Comment . . . . . . . . . . . .
      13  Adjustment. . . . . . . . . .     1 SNN  Adjustment. . . . . . . . . . .
      14  PrepaidApplyToInvoiceNo . . .    10 SNN  Prepaid Apply To AP Invoice Num
      15  PrepaidPaymentDate. . . . . .     8 SNN  Prepaid Payment Date. . . . . .DATE
      16  PrepaidCheckNo. . . . . . . .    10 SNN  Prepaid Check Number. . . . . .
      17  VendorType. . . . . . . . . .     1 SNN  Vendor Type . . . . . . . . . .
      18  Form1099. . . . . . . . . . .     1 SNN  1099 Form . . . . . . . . . . .
      19  Box1099 . . . . . . . . . . .     3 SNN  1099 Box. . . . . . . . . . . .
      20  SeparateCheck . . . . . . . .     1 SNN  Separate Check. . . . . . . . .
      21  BatchNo . . . . . . . . . . .     5 SNN  Batch Number. . . . . . . . . .
      22  TaxSchedule . . . . . . . . .     9 SNN  Tax Schedule. . . . . . . . . .
      23  InvalidTaxCalc. . . . . . . .     1 SNN  Invalid Tax Calculation . . . .
      24  LineSeqNo . . . . . . . . . .    14 SNN  Line Sequence Number. . . . . .
      25  AccountKey. . . . . . . . . .     9 SNN  Account Key . . . . . . . . . .
      26  Account . . . . . . . . . . .    41 SNN  Fully Formatted Account . . . .
      27  AccountDesc . . . . . . . . .    50 SNN  Account Description . . . . . .
      28  JobNo . . . . . . . . . . . .     7 SNN  Job Number. . . . . . . . . . .
      29  CostCode. . . . . . . . . . .     9 SNN  Cost Code . . . . . . . . . . .
      30  CostCodeFormatted . . . . . .    11 SNN  Cost Code Formatted . . . . . .
      31  CostType. . . . . . . . . . .     1 SNN  Cost Type . . . . . . . . . . .
      32  UnitOfMeasure . . . . . . . .     4 SNN  Unit Of Measure . . . . . . . .
      33  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .
      34  TransferAPDivisionNo. . . . .     2 SNN  Transfer AP Division Number . .
      35  TransferVendorNo. . . . . . .     7 SNN  Transfer Vendor Number. . . . .
      36  TransferVendorName. . . . . .    30 SNN  Transfer Vendor Name. . . . . .
      37  TransferInvoiceNo . . . . . .    10 SNN  Transfer Invoice Number . . . .
      38  TransferVendorType. . . . . .     1 SNN  Transfer Vendor Type. . . . . .
      39  TransferForm1099. . . . . . .     1 SNN  Transfer 1099 Form. . . . . . .
      40  TransferBox1099 . . . . . . .     3 SNN  Transfer 1099 Box . . . . . . .
      41  ScheduleSeqNo . . . . . . . .     6 SNN  Schedule Sequence Number. . . .
      42  TaxCode . . . . . . . . . . .    15 SNN  Tax Code. . . . . . . . . . . .
      43  Overridden. . . . . . . . . .     1 SNN  Overridden. . . . . . . . . . .
      44  InvoiceAmt. . . . . . . . . . 13.2  NNN  Invoice Amount. . . . . . . . .
      45  DiscountAmt . . . . . . . . . 13.2  NNN  Discount Amount . . . . . . . .
      46  PrepaymentAmt . . . . . . . . 13.2  NNN  Prepayment Amount . . . . . . .
      47  FreightAmt. . . . . . . . . . 13.2  NNN  Freight Amount. . . . . . . . .
      48  TaxAmt. . . . . . . . . . . . 13.2  NNN  Tax Amount. . . . . . . . . . .
      49  QuantityDistributed . . . . . 16.6  NNN  Quantity Distributed. . . . . .
      50  DistributionAmt . . . . . . . 13.2  NNN  Distribution Amount . . . . . .
      51  RetentionRate . . . . . . . .  7.2  NNN  Retention Rate. . . . . . . . .
      52  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .
      53  RetentionAmt. . . . . . . . . 13.2  NNN  Retention Amount. . . . . . . .
      54  TransferDiscount. . . . . . . 13.2  NNN  Transfer Discount . . . . . . .
      55  TaxDetailAmt. . . . . . . . . 13.2  NNN  Tax Detail Amount . . . . . . .