     SO_ShippingLabelsWrk                  SO Shipping Labels Work         Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: SO_ShippingLabels_rpt,SO_ShippingEntryLabels_rpt
     SQL Def: Y  SysDB: N                           "MAS_"+%C$+"/SO"+%C$+"/SO_ShippingLabelsWrk"+%S$+".M4T"

     KPRIMARY: SortField

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
       2  SalesOrderNo. . . . . . . . .     7 SNN  Sales Order Number. . . . . . .
       3  OrderDate . . . . . . . . . .     8 SNN  Order Date. . . . . . . . . . .DATE
       4  OrderType . . . . . . . . . .     1 SNN  Order Type. . . . . . . . . . .
       5  ShipToName. . . . . . . . . .    30 SNN  ShipToName. . . . . . . . . . .
       6  ShipToAddress1. . . . . . . .    30 SNN  Ship To Address 1 . . . . . . .
       7  ShipToAddress2. . . . . . . .    30 SNN  Ship To Address 2 . . . . . . .
       8  ShipToAddress3. . . . . . . .    30 SNN  Ship To Address 3 . . . . . . .
       9  ShipToCity. . . . . . . . . .    20 SNN  Ship To City. . . . . . . . . .
      10  ShipToState . . . . . . . . .     2 SNN  Ship To State . . . . . . . . .
      11  ShipToZipCode . . . . . . . .    10 SNN  Ship To Zip Code. . . . . . . .
      12  ShipToCountryCode . . . . . .     3 SNN  Ship To Country Code. . . . . .
      13  ShipToCountryName . . . . . .    30 SNN  Ship To Country Name. . . . . .
      14  ConfirmTo . . . . . . . . . .    30 SNN  Confirm To. . . . . . . . . . .
      15  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .
      16  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .
      17  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .
      18  SalespersonNo . . . . . . . .     4 SNN  Salesperson Number. . . . . . .
      19  SalespersonName . . . . . . .    30 SNN  Salesperson Name. . . . . . . .
      20  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .
      21  TaxSchedule . . . . . . . . .     9 SNN  Tax Schedule. . . . . . . . . .
      22  CustomerPONo. . . . . . . . .    15 SNN  Customer PO Number. . . . . . .
      23  ShipVia . . . . . . . . . . .    15 SNN  Ship Via. . . . . . . . . . . .
      24  ShipZone. . . . . . . . . . .     5 SNN  Ship Zone . . . . . . . . . . .
      25  FOB . . . . . . . . . . . . .    15 SNN  FOB . . . . . . . . . . . . . .
      26  TermsCode . . . . . . . . . .     2 SNN  Terms Code. . . . . . . . . . .
      27  TermsCodeDesc . . . . . . . .    30 SNN  Terms Code Description. . . . .
      28  InvoiceNo . . . . . . . . . .     7 SNN  Invoice Number. . . . . . . . .
      29  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
      30  LabelNumber . . . . . . . . .     4 SNN  Label Number. . . . . . . . . .
      31  CRMUserID . . . . . . . . . .    11 SNN  CRM User ID . . . . . . . . . .
      32  CRMUserLastName . . . . . . .    30 SNN  CRM User Last Name. . . . . . .
      33  CRMUserFirstName. . . . . . .    30 SNN  CRM User First Name . . . . . .
      34  CRMCompanyID. . . . . . . . .    11 SNN  CRM Company ID. . . . . . . . .
      35  CRMCompanyName. . . . . . . .   120 SNN  CRM Company Name. . . . . . . .
      36  CRMProspectID . . . . . . . .    11 SNN  CRM Prospect ID . . . . . . . .
      37  CRMPersonID . . . . . . . . .    11 SNN  CRM Person ID . . . . . . . . .
      38  CRMPersonFirstName. . . . . .    60 SNN  CRM Person First Name . . . . .
      39  CRMPersonLastName . . . . . .    80 SNN  CRM Person Last Name. . . . . .
      40  CRMOpportunityID. . . . . . .    11 SNN  CRM Opportunity ID. . . . . . .
      41  CRMOpportunityDesc. . . . . .    80 SNN  CRM Opportunity Description . .
      42  Weight. . . . . . . . . . . . 12.2  NNN  Weight. . . . . . . . . . . . .