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