     AR_InvoiceWrk                          AR Invoice Work                Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AR_InvoicePrinting_rpt,AR_InvoiceHistoryPrinting_rpt
     SQL Def: Y  SysDB: N                                  "MAS_"+%C$+"/AR"+%C$+"/AR_InvoiceWrk"+%S$+".M4T"

     KPRIMARY: SortField

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
       2  GroupField. . . . . . . . . .    15 SNN  Group Field . . . . . . . . . .
       3  InvoiceNo . . . . . . . . . .     7 SNN  Invoice Number. . . . . . . . .
       4  HeaderSeqNo . . . . . . . . .     6 SNN  Header Sequence Number. . . . .
       5  InvoiceType . . . . . . . . .     2 SNN  Invoice Type. . . . . . . . . .
                                                    DfltVal:IN
       6  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
       7  InvoiceDueDate. . . . . . . .     8 SNN  Invoice Due Date. . . . . . . .DATE
       8  DiscountDueDate . . . . . . .     8 SNN  Discount Due Date . . . . . . .DATE
       9  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .
      10  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .
      11  ContactName . . . . . . . . .    30 SNN  Contact Name. . . . . . . . . .
      12  SoldTo. . . . . . . . . . . .    30 SNN  Sold To Name. . . . . . . . . .
      13  AddressLine1. . . . . . . . .    30 SNN  Address Line 1. . . . . . . . .
      14  AddressLine2. . . . . . . . .    30 SNN  Address Line 2. . . . . . . . .
      15  AddressLine3. . . . . . . . .    30 SNN  Address Line 3. . . . . . . . .
      16  City. . . . . . . . . . . . .    20 SNN  City. . . . . . . . . . . . . .
      17  State . . . . . . . . . . . .     3 SNN  State . . . . . . . . . . . . .
      18  ZipCode . . . . . . . . . . .    10 SNN  Zip Code. . . . . . . . . . . .
      19  CountryCode . . . . . . . . .     3 SNN  Country Code. . . . . . . . . .
      20  CountryName . . . . . . . . .    30 SNN  Country Name. . . . . . . . . .
      21  TelephoneNo . . . . . . . . .    17 SNN  Telephone Number. . . . . . . .
      22  FaxNo . . . . . . . . . . . .    17 SNN  Fax Number. . . . . . . . . . .
      23  EmailAddress. . . . . . . . .   250 SNN  Email Address . . . . . . . . .EMAILADDRESS
      24  CustomerPONo. . . . . . . . .    15 SNN  Customer PO Number. . . . . . .
      25  TermsCode . . . . . . . . . .     2 SNN  Terms Code. . . . . . . . . . .
      26  TermsCodeDesc . . . . . . . .    30 SNN  Terms Code Description. . . . .
      27  ShipMethod. . . . . . . . . .    15 SNN  Ship Method . . . . . . . . . .
      28  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .
      29  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .
      30  SalespersonNo . . . . . . . .     4 SNN  Salesperson Number. . . . . . .
      31  SalespersonName . . . . . . .    30 SNN  Salesperson Name. . . . . . . .
      32  TaxSchedule . . . . . . . . .     9 SNN  Tax Schedule. . . . . . . . . .
      33  InvalidTaxCalc. . . . . . . .     1 SNN  Invalid Tax Calculation . . . .
      34  TaxCode1. . . . . . . . . . .    15 SNN  Tax Code 1. . . . . . . . . . .
      35  TaxCode2. . . . . . . . . . .    15 SNN  Tax Code 2. . . . . . . . . . .
      36  TaxCode3. . . . . . . . . . .    15 SNN  Tax Code 3. . . . . . . . . . .
      37  TaxCode4. . . . . . . . . . .    15 SNN  Tax Code 4. . . . . . . . . . .
      38  TaxCode1Desc. . . . . . . . .    30 SNN  Tax Code 1 Description. . . . .
      39  TaxCode2Desc. . . . . . . . .    30 SNN  Tax Code 2 Description. . . . .
      40  TaxCode3Desc. . . . . . . . .    30 SNN  Tax Code 3 Description. . . . .
      41  TaxCode4Desc. . . . . . . . .    30 SNN  Tax Code 4 Description. . . . .
      42  ExemptionNo1. . . . . . . . .    20 SNN  Exemption Number 1. . . . . . .
      43  ExemptionNo2. . . . . . . . .    20 SNN  Exemption Number 2. . . . . . .
      44  ExemptionNo3. . . . . . . . .    20 SNN  Exemption Number 3. . . . . . .
      45  ExemptionNo4. . . . . . . . .    20 SNN  Exemption Number 4. . . . . . .
      46  RegistrationNo1 . . . . . . .    20 SNN  Registration Number 1 . . . . .
      47  RegistrationNo2 . . . . . . .    20 SNN  Registration Number 2 . . . . .
      48  RegistrationNo3 . . . . . . .    20 SNN  Registration Number 3 . . . . .
      49  RegistrationNo4 . . . . . . .    20 SNN  Registration Number 4 . . . . .
      50  JobNo . . . . . . . . . . . .     7 SNN  Job Number. . . . . . . . . . .
      51  LineNumber. . . . . . . . . .     6 SNN  Line Number . . . . . . . . . .
      52  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
      53  ItemType. . . . . . . . . . .     1 SNN  Item Type . . . . . . . . . . .
      54  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
      55  UnitOfMeasure . . . . . . . .     4 SNN  Unit Of Measure . . . . . . . .
      56  SalesAcctKey. . . . . . . . .     9 SNN  Sales Account Key . . . . . . .
      57  SalesAccount. . . . . . . . .    41 SNN  Fully Formatted Sales Acccount.
      58  CostOfGoodsSoldAcctKey. . . .     9 SNN  Cost of Goods Sold Account Key.
      59  CostOfGoodsSoldAccount. . . .    41 SNN  Fully Formatted Cost of Goods S
      60  InventoryAcctKey. . . . . . .     9 SNN  Inventory Account Key . . . . .
      61  InventoryAccount. . . . . . .    41 SNN  Fully Formatted Inventory Accou
      62  TaxClass. . . . . . . . . . .     2 SNN  Tax Class . . . . . . . . . . .
      63  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .
      64  SubjectToExemption. . . . . .     1 SNN  Subject To Exemption. . . . . .
      65  MessageLine1. . . . . . . . .    50 SNN  Message Line 1. . . . . . . . .
      66  MessageLine2. . . . . . . . .    50 SNN  Message Line 2. . . . . . . . .
      67  FaxSendToCompany. . . . . . .    30 SNN  Fax Send To Company . . . . . .
      68  FaxSendToName . . . . . . . .    30 SNN  Fax Send To Name. . . . . . . .
      69  BatchFax. . . . . . . . . . .     1 SYN  Batch Fax . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      70  PLPrint . . . . . . . . . . .     1 SYN  Paperless Office Print CustomerYESNO
                                                    DfltVal:N Valid:Y,N
      71  PLEmail . . . . . . . . . . .     1 SYN  Paperless Office E-Mail CustomeYESNO
                                                    DfltVal:N Valid:Y,N
      72  PLFax . . . . . . . . . . . .     1 SYN  Paperless Office Fax Customer .YESNO
                                                    DfltVal:N Valid:Y,N
      73  PLPDF . . . . . . . . . . . .     1 SYN  Paperless Office Create PDF . .YESNO
                                                    DfltVal:N Valid:Y,N
      74  Quantity. . . . . . . . . . . 12.3  NNN  Quantity. . . . . . . . . . . .
      75  Price . . . . . . . . . . . . 12.3  NNN  Price . . . . . . . . . . . . .
      76  Cost. . . . . . . . . . . . . 12.3  NNN  Cost. . . . . . . . . . . . . .
      77  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .
      78  TaxableSalesAmt . . . . . . . 14.2  NNN  Taxable Sales Amount. . . . . .
      79  NonTaxableSalesAmt. . . . . . 14.2  NNN  Non Taxable Sales Amount. . . .
      80  FreightAmt. . . . . . . . . . 12.2  NNN  Freight Amount. . . . . . . . .
      81  SalesTaxAmt . . . . . . . . . 12.2  NNN  Sales Tax Amount. . . . . . . .
      82  SalesTaxAmt1. . . . . . . . . 12.2  NNN  Sales Tax Amount 1. . . . . . .
      83  SalesTaxAmt2. . . . . . . . . 12.2  NNN  Sales Tax Amount 2. . . . . . .
      84  SalesTaxAmt3. . . . . . . . . 12.2  NNN  Sales Tax Amount 3. . . . . . .
      85  SalesTaxAmt4. . . . . . . . . 12.2  NNN  Sales Tax Amount 4. . . . . . .
      86  RetentionAmt. . . . . . . . . 14.2  NNN  Retention Amount. . . . . . . .
      87  CurrentBalance. . . . . . . . 14.2  NNN  Current Balance . . . . . . . .
      88  AgingCategory1. . . . . . . . 14.2  NNN  Aging Category 1. . . . . . . .
      89  AgingCategory2. . . . . . . . 14.2  NNN  Aging Category 2. . . . . . . .
      90  AgingCategory3. . . . . . . . 14.2  NNN  Aging Category 3. . . . . . . .
      91  AgingCategory4. . . . . . . . 14.2  NNN  Aging Category 4. . . . . . . .