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

 KPRIMARY: SortField

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
   2  GroupField. . . . . . . . . .    10 SNN  Group Field . . . . . . . . . .
   3  InvoiceNo . . . . . . . . . .     7 SNN  InvoiceNo . . . . . . . . . . .
   4  HeaderSeqNo . . . . . . . . .     6 SNN  Header Sequence Number. . . . .
   5  InvoiceType . . . . . . . . .     2 SNN  Invoice Type. . . . . . . . . .
                                                DfltVal:IN
   6  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
   7  SalesOrderNo. . . . . . . . .     7 SNN  Sales Order Number. . . . . . .
   8  OrderDate . . . . . . . . . .     8 SNN  Order Date. . . . . . . . . . .DATE
   9  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .
  10  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .
  11  TelephoneNo . . . . . . . . .    17 SNN  Telephone Number. . . . . . . .
  12  FaxNo . . . . . . . . . . . .    17 SNN  Fax Number. . . . . . . . . . .
  13  EmailAddress. . . . . . . . .   250 SNN  Email Address . . . . . . . . .
  14  CustomerPONo. . . . . . . . .    15 SNN  Customer PO Number. . . . . . .
  15  ConfirmTo . . . . . . . . . .    30 SNN  Confirm To. . . . . . . . . . .
  16  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .
  17  ShipVIA . . . . . . . . . . .    15 SNN  Ship VIA. . . . . . . . . . . .
  18  ShipZone. . . . . . . . . . .     5 SNN  Ship Zone . . . . . . . . . . .
  19  ShipDate. . . . . . . . . . .     8 SNN  Ship Expire Date. . . . . . . .DATE
  20  FOB . . . . . . . . . . . . .    15 SNN  F. O. B.. . . . . . . . . . . .
  21  TrackingNumbers . . . . . . .   132 SNN  Tracking Numbers. . . . . . . .
  22  TermsCode . . . . . . . . . .     2 SNN  Terms Code. . . . . . . . . . .
  23  TermsCodeDesc . . . . . . . .    30 SNN  Terms Code Description. . . . .
  24  InvoiceDueDate. . . . . . . .     8 SNN  Invoice Due Date. . . . . . . .DATE
  25  DiscountDueDate . . . . . . .     8 SNN  Discount Due Date . . . . . . .DATE
  26  PaymentType . . . . . . . . .     5 SNN  Payment Type. . . . . . . . . .
  27  OtherPaymentTypeRefNo . . . .    24 SNN  Other Payment Type Reference Nu
  28  CheckNoForDeposit . . . . . .     6 SNN  Check Number for Deposit. . . .
  29  Last4UnencryptedCreditCardNos     4 SNN  Last 4 Unencrypted Credit Card
  30  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .
  31  SalespersonNo . . . . . . . .     4 SNN  Salesperson Code. . . . . . . .
  32  SalespersonName . . . . . . .    30 SNN  Salesperson Name. . . . . . . .
  33  BillToName. . . . . . . . . .    30 SNN  Bill To Name. . . . . . . . . .
  34  BillToAddress1. . . . . . . .    30 SNN  Bill To Address 1 . . . . . . .
  35  BillToAddress2. . . . . . . .    30 SNN  Bill To Address 2 . . . . . . .
  36  BillToAddress3. . . . . . . .    30 SNN  Bill To Address 3 . . . . . . .
  37  BillToCity. . . . . . . . . .    20 SNN  Bill To City. . . . . . . . . .
  38  BillToState . . . . . . . . .     2 SNN  Bill To State . . . . . . . . .
  39  BillToZipCode . . . . . . . .    10 SNN  Bill To ZIP Code. . . . . . . .
  40  BillToCountryCode . . . . . .     3 SNN  Bill To Country Code. . . . . .
  41  BillToCountryName . . . . . .    30 SNN  Bill To Country Name. . . . . .
  42  ShipToCode. . . . . . . . . .     4 SNN  Ship To Code. . . . . . . . . .
  43  ShipToName. . . . . . . . . .    30 SNN  Ship To Name. . . . . . . . . .
  44  ShipToAddress1. . . . . . . .    30 SNN  Ship To Address 1 . . . . . . .
  45  ShipToAddress2. . . . . . . .    30 SNN  Ship To Address 2 . . . . . . .
  46  ShipToAddress3. . . . . . . .    30 SNN  Ship To Address 3 . . . . . . .
  47  ShipToCity. . . . . . . . . .    20 SNN  Ship To City. . . . . . . . . .
  48  ShipToState . . . . . . . . .     2 SNN  Ship To State . . . . . . . . .
  49  ShipToZipCode . . . . . . . .    10 SNN  Ship To ZIP Code. . . . . . . .
  50  ShipToCountryCode . . . . . .     3 SNN  Ship To Country Code. . . . . .
  51  ShipToCountryName . . . . . .    30 SNN  Ship To Country Name. . . . . .
  52  TaxSchedule . . . . . . . . .     9 SNN  Tax Schedule. . . . . . . . . .
  53  InvalidTaxCalc. . . . . . . .     1 SNN  Invalid Tax Calculation . . . .
  54  TaxCode1. . . . . . . . . . .    15 SNN  Tax Code 1. . . . . . . . . . .
  55  TaxCode2. . . . . . . . . . .    15 SNN  Tax Code 2. . . . . . . . . . .
  56  TaxCode3. . . . . . . . . . .    15 SNN  Tax Code 3. . . . . . . . . . .
  57  TaxCode4. . . . . . . . . . .    15 SNN  Tax Code 4. . . . . . . . . . .
  58  TaxCode1Desc. . . . . . . . .    30 SNN  Tax Code 1 Description. . . . .
  59  TaxCode2Desc. . . . . . . . .    30 SNN  Tax Code 2 Description. . . . .
  60  TaxCode3Desc. . . . . . . . .    30 SNN  Tax Code 3 Description. . . . .
  61  TaxCode4Desc. . . . . . . . .    30 SNN  Tax Code 4 Description. . . . .
  62  ExemptionNo1. . . . . . . . .    20 SNN  Exemption Number 1. . . . . . .
  63  ExemptionNo2. . . . . . . . .    20 SNN  Exemption Number 2. . . . . . .
  64  ExemptionNo3. . . . . . . . .    20 SNN  Exemption Number 3. . . . . . .
  65  ExemptionNo4. . . . . . . . .    20 SNN  Exemption Number 4. . . . . . .
  66  RegistrationNo1 . . . . . . .    20 SNN  Registration Number 1 . . . . .
  67  RegistrationNo2 . . . . . . .    20 SNN  Registration Number 2 . . . . .
  68  RegistrationNo3 . . . . . . .    20 SNN  Registration Number 3 . . . . .
  69  RegistrationNo4 . . . . . . .    20 SNN  Registration Number 4 . . . . .
  70  EBMSubmissionType . . . . . .     1 SNN  EBM Submission Type . . . . . .
  71  EBMUserIDSubmittingThisOrder.    15 SNN  EBM User ID Submitting This Ord
  72  LineSeqNo . . . . . . . . . .    14 SNN  Line Sequence Number. . . . . .
  73  LineNumber. . . . . . . . . .    14 SNN  Line Number . . . . . . . . . .
  74  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
  75  AliasItemNo . . . . . . . . .    30 SNN  Alias Item Number . . . . . . .
  76  ItemType. . . . . . . . . . .     1 SNN  Item Type . . . . . . . . . . .
                                                DfltVal:1
  77  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
  78  ExtendedDescriptionKey. . . .    10 SNN  Extended Description Key. . . .
  79  ExtendedDescriptionText . . .  4096 SNN  Extended Description. . . . . .
  80  LotSerialNo . . . . . . . . .    15 SNN  Lot or Serial Number. . . . . .
  81  TierType. . . . . . . . . . .     1 SNN  Tier Type . . . . . . . . . . .
                                                DfltVal:4
  82  Category1 . . . . . . . . . .    15 SNN  Category 1. . . . . . . . . . .
  83  Category2 . . . . . . . . . .    15 SNN  Category 2. . . . . . . . . . .
  84  Category3 . . . . . . . . . .    15 SNN  Category 3. . . . . . . . . . .
  85  Category4 . . . . . . . . . .    15 SNN  Category 4. . . . . . . . . . .
  86  BinLocation . . . . . . . . .    10 SNN  Bin Location. . . . . . . . . .
  87  LineWarehouseCode . . . . . .     3 SNN  Line Warehouse Code . . . . . .
  88  ProductLine . . . . . . . . .     4 SNN  ProductLine . . . . . . . . . .
  89  Discount. . . . . . . . . . .     1 SNN  Discount. . . . . . . . . . . .
  90  Commissionable. . . . . . . .     1 SNN  Commissionable. . . . . . . . .
  91  SubjectToExemption. . . . . .     1 SNN  Subject To Exemption. . . . . .
  92  DropShip. . . . . . . . . . .     1 SNN  Drop Ship . . . . . . . . . . .
  93  UnitOfMeasure . . . . . . . .     4 SNN  Unit of Measure . . . . . . . .
  94  CostOfGoodsSoldAcctKey. . . .     9 SNN  Cost of Goods Sold Account Key.
  95  CostOfGoodsSoldAccount. . . .    41 SNN  Fully Formatted Cost of Goods S
  96  SalesAcctKey. . . . . . . . .     9 SNN  Sales Account Key . . . . . . .
  97  SalesAccount. . . . . . . . .    41 SNN  Fully Formatted Sales Account .
  98  TaxClass. . . . . . . . . . .     2 SNN  Tax Class . . . . . . . . . . .
  99  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .
 100  ExplodedKitItem . . . . . . .     1 SNN  Exploded Kit Item . . . . . . .
 101  StandardKitBill . . . . . . .     1 SNN  Standard Kit Bill . . . . . . .
 102  Revision. . . . . . . . . . .     3 SNN  Bill Revision Code. . . . . . .
 103  BillOption1 . . . . . . . . .     2 SNN  Bill Option 1 . . . . . . . . .
 104  Option1Desc . . . . . . . . .    30 SNN  Option 1 Description. . . . . .
 105  BillOption2 . . . . . . . . .     2 SNN  Bill Option 2 . . . . . . . . .
 106  Option2Desc . . . . . . . . .    30 SNN  Option 2 Description. . . . . .
 107  BillOption3 . . . . . . . . .     2 SNN  Bill Option 3 . . . . . . . . .
 108  Option3Desc . . . . . . . . .    30 SNN  Option 3 Description. . . . . .
 109  BillOption4 . . . . . . . . .     2 SNN  Bill Option 4 . . . . . . . . .
 110  Option4Desc . . . . . . . . .    30 SNN  Option 4 Description. . . . . .
 111  BillOption5 . . . . . . . . .     2 SNN  Bill Option 5 . . . . . . . . .
 112  Option5Desc . . . . . . . . .    30 SNN  Option 5 Description. . . . . .
 113  BillOption6 . . . . . . . . .     2 SNN  Bill Option 6 . . . . . . . . .
 114  Option6Desc . . . . . . . . .    30 SNN  Option 6 Description. . . . . .
 115  BillOption7 . . . . . . . . .     2 SNN  Bill Option 7 . . . . . . . . .
 116  Option7Desc . . . . . . . . .    30 SNN  Option 7 Description. . . . . .
 117  BillOption8 . . . . . . . . .     2 SNN  Bill Option 8 . . . . . . . . .
 118  Option8Desc . . . . . . . . .    30 SNN  Option 8 Description. . . . . .
 119  BillOption9 . . . . . . . . .     2 SNN  Bill Option 9 . . . . . . . . .
 120  Option9Desc . . . . . . . . .    30 SNN  Option 9 Description. . . . . .
 121  SkipPrintCompLine . . . . . .     1 SNN  Skip Printing of Component Line
 122  SalesKitLineKey . . . . . . .     6 SNN  Sales Kit Line Key. . . . . . .
 123  RMANo . . . . . . . . . . . .     7 SNN  RMA Number. . . . . . . . . . .
 124  CustomerAction. . . . . . . .     1 SNN  Customer Action . . . . . . . .
 125  WarrantyCode. . . . . . . . .    10 SNN  Warranty Code . . . . . . . . .
 126  WarrantyCodeDesc. . . . . . .    30 SNN  Warranty Code Description . . .
 127  ExpirationDate. . . . . . . .     8 SNN  Expiration Date . . . . . . . .DATE
 128  JobNo . . . . . . . . . . . .     7 SNN  Job Number. . . . . . . . . . .
 129  CostCode. . . . . . . . . . .     9 SNN  Cost Code . . . . . . . . . . .
 130  CostCodeFormatted . . . . . .    11 SNN  Cost Code Formatted . . . . . .
 131  CostType. . . . . . . . . . .     1 SNN  Cost Type . . . . . . . . . . .
 132  MessageLine1. . . . . . . . .    50 SNN  Message Line 1. . . . . . . . .
 133  MessageLine2. . . . . . . . .    50 SNN  Message Line 2. . . . . . . . .
 134  FaxSendToCompany. . . . . . .    30 SNN  Fax Send To Company . . . . . .
 135  FaxSendToName . . . . . . . .    30 SNN  FaxSendToName . . . . . . . . .
 136  BatchFax. . . . . . . . . . .     1 SYN  BatchFax. . . . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
 137  CRMUserID . . . . . . . . . .    11 SNN  CRM User ID . . . . . . . . . .
 138  CRMUserLastName . . . . . . .    30 SNN  CRM User Last Name. . . . . . .
 139  CRMUserFirstName. . . . . . .    30 SNN  CRM User First Name . . . . . .
 140  CRMCompanyID. . . . . . . . .    11 SNN  CRM Company ID. . . . . . . . .
 141  CRMCompanyName. . . . . . . .   120 SNN  CRM Company Name. . . . . . . .
 142  CRMPersonID . . . . . . . . .    11 SNN  CRMPersonID . . . . . . . . . .
 143  CRMPersonFirstName. . . . . .    60 SNN  CRM Person First Name . . . . .
 144  CRMPersonLastName . . . . . .    80 SNN  CRM Person Last Name. . . . . .
 145  CRMOpportunityID. . . . . . .    11 SNN  CRM Opportunity ID. . . . . . .
 146  CRMOpportunityDesc. . . . . .    80 SNN  CRM Opportunity Description . .
 147  PLPrint . . . . . . . . . . .     1 SYN  Paperless Office Print CustomerYESNO
                                                DfltVal:N Valid:Y,N
 148  PLEmail . . . . . . . . . . .     1 SYN  Paperless Office E-Mail CustomeYESNO
                                                DfltVal:N Valid:Y,N
 149  PLFax . . . . . . . . . . . .     1 SYN  Paperless Office Fax Customer .YESNO
                                                DfltVal:N Valid:Y,N
 150  PLPDF . . . . . . . . . . . .     1 SYN  Paperless Office Create PDF . .YESNO
                                                DfltVal:N Valid:Y,N
 151  QuantityOrdered . . . . . . . 16.6  NNN  Quantity Ordered. . . . . . . .
 152  QuantityShipped . . . . . . . 16.6  NNN  Quantity Shipped. . . . . . . .
 153  QuantityBackOrdered . . . . . 16.6  NNN  Quantity Back Ordered . . . . .
 154  LotSerialQuantityShipped. . . 16.6  NNN  Lot or Serial Quantity Shipped.
 155  ItemWeight. . . . . . . . . . 16.6  NNN  Item Weight . . . . . . . . . .
 156  SuggestedRetailPrice. . . . . 16.6  NNN  Suggested Retail Price. . . . .
 157  UnitPrice . . . . . . . . . . 16.6  NNN  Unit Price. . . . . . . . . . .
 158  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .
 159  LineDiscountPercent . . . . .  9.3  NNN  Line Discount Percentage. . . .
 160  TaxableAmt. . . . . . . . . . 15.2  NNN  Taxable Amount. . . . . . . . .
 161  NonTaxableAmt . . . . . . . . 15.2  NNN  Non-Taxable Amount. . . . . . .
 162  DiscountRate. . . . . . . . .  8.3  NNN  Discount Rate . . . . . . . . .
 163  DiscountAmt . . . . . . . . . 13.2  NNN  Discount Amount . . . . . . . .
 164  RetentionAmt. . . . . . . . . 13.2  NNN  Retention Amount. . . . . . . .
 165  FreightAmt. . . . . . . . . . 13.2  NNN  Freight Amount. . . . . . . . .
 166  SalesTaxAmt . . . . . . . . . 12.2  NNN  Sales Tax Amount. . . . . . . .
 167  SalesTaxAmt1. . . . . . . . . 12.2  NNN  Sales Tax Amount 1. . . . . . .
 168  SalesTaxAmt2. . . . . . . . . 12.2  NNN  Sales Tax Amount 2. . . . . . .
 169  SalesTaxAmt3. . . . . . . . . 12.2  NNN  Sales Tax Amount 3. . . . . . .
 170  SalesTaxAmt4. . . . . . . . . 12.2  NNN  Sales Tax Amount 4. . . . . . .
 171  DepositAmt. . . . . . . . . . 13.2  NNN  Deposit Amount. . . . . . . . .
 172  CreditCardPreAuthorizationAmt 13.2  NNN  Credit Card Pre-Authorization A
 173  CreditCardPaymentBalanceAmt . 13.2  NNN  Credit Card Payment/Balance Amo
 174  Weight. . . . . . . . . . . . 12.2  NNN  Weight. . . . . . . . . . . . .
 175  CurrentBalance. . . . . . . . 14.2  NNN  Current Balance . . . . . . . .
 176  AgingCategory1. . . . . . . . 14.2  NNN  Aging Category 1. . . . . . . .
 177  AgingCategory2. . . . . . . . 14.2  NNN  Aging Category 2. . . . . . . .
 178  AgingCategory3. . . . . . . . 14.2  NNN  Aging Category 3. . . . . . . .
 179  AgingCategory4. . . . . . . . 14.2  NNN  Aging Category 4. . . . . . . .