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 . . . . . . .