     SO_ShippingHistoryWrk                 SO Shipping History Work        Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: SO_ShippingHistoryReport_rpt
     SQL Def: Y  SysDB: N                          "MAS_"+%C$+"/SO"+%C$+"/SO_ShippingHistoryWrk"+%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  GroupFieldDesc. . . . . . . .    30 SNN  Group Field Description . . . .DESCRIPTION
       4  InvoiceNo . . . . . . . . . .     7 SNN  Invoice Number. . . . . . . . .INVOICE
       5  HeaderSeqNo . . . . . . . . .     6 SNN  Header Sequence Number. . . . .
       6  DetailSeqNo . . . . . . . . .     6 SNN  Detail Sequence Number. . . . .
       7  InvoiceType . . . . . . . . .     2 SNN  Invoice Type. . . . . . . . . .
       8  SalesOrderNo. . . . . . . . .     7 SNN  Sales Order Number. . . . . . .SALESORDERNO
       9  ShipperID . . . . . . . . . .     3 SNN  Shipper ID. . . . . . . . . . .SHIPPERID
      10  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00
      11  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .CUSTOMERNO
      12  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .NAME
      13  BillToName. . . . . . . . . .    30 SNN  Bill To Name. . . . . . . . . .
      14  TermsCode . . . . . . . . . .     2 SNN  Terms Code. . . . . . . . . . .
      15  ShipVia . . . . . . . . . . .    15 SNN  Ship Via. . . . . . . . . . . .
      16  ShipDate. . . . . . . . . . .     8 SNN  Ship Date . . . . . . . . . . .DATE
      17  ShipToName. . . . . . . . . .    30 SNN  Ship To Name. . . . . . . . . .
      18  ShipToAddress1. . . . . . . .    30 SNN  Ship To Address 1 . . . . . . .
      19  ShipToAddress2. . . . . . . .    30 SNN  Ship To Address 2 . . . . . . .
      20  ShipToAddress3. . . . . . . .    30 SNN  Ship To Address 3 . . . . . . .
      21  ShipToCity. . . . . . . . . .    20 SNN  Ship To City. . . . . . . . . .
      22  ShipToState . . . . . . . . .     2 SNN  Ship To State . . . . . . . . .
      23  ShipToZipCode . . . . . . . .    10 SNN  Ship To Zip Code. . . . . . . .
      24  ShipToCountryCode . . . . . .     3 SNN  Ship To Country Code. . . . . .
      25  ShipToCountryName . . . . . .    30 SNN  Ship To Country Name. . . . . .NAME
      26  CustomerPONo. . . . . . . . .    15 SNN  Customer PO Number. . . . . . .CUSTOMERPONO
      27  ConfirmTo . . . . . . . . . .    30 SNN  Confirm To. . . . . . . . . . .
      28  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .
      29  WarehouseCode . . . . . . . .     3 SNN  Warehouse Code. . . . . . . . .WAREHOUSE
      30  FOB . . . . . . . . . . . . .    30 SNN  FOB . . . . . . . . . . . . . .
      31  ShipZone. . . . . . . . . . .     5 SNN  Ship Zone . . . . . . . . . . .SHIPZONE
      32  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
      33  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
      34  ItemType. . . . . . . . . . .     1 SNN  Item Type . . . . . . . . . . .
      35  LineWarehouseCode . . . . . .     3 SNN  Line Warehouse Code . . . . . .WAREHOUSE
      36  UnitOfMeasure . . . . . . . .     4 SNN  Unit Of Measure . . . . . . . .UNITOFMEASURE
      37  TierType. . . . . . . . . . .     1 SNN  Tier Type . . . . . . . . . . .
      38  LotSerialNo . . . . . . . . .    15 SNN  Lot Serial Number . . . . . . .
      39  PackageNo . . . . . . . . . .     4 SNN  Package Number. . . . . . . . .
      40  TrackingID. . . . . . . . . .    30 SNN  Tracking ID . . . . . . . . . .
      41  Discount. . . . . . . . . . .     1 SNN  Discount. . . . . . . . . . . .
      42  PriceLevel. . . . . . . . . .     1 SNN  Price Level . . . . . . . . . .
      43  Commissionable. . . . . . . .     1 SNN  Commissionable. . . . . . . . .
      44  TaxClass. . . . . . . . . . .     2 SNN  Tax Class . . . . . . . . . . .TAXCLASS
      45  DropShip. . . . . . . . . . .     1 SNN  Drop Ship . . . . . . . . . . .
      46  ProductLine . . . . . . . . .     4 SNN  Product Line. . . . . . . . . .
      47  ProductLineDesc . . . . . . .    25 SNN  Product Line Description. . . .DESCRIPTION25
      48  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .COMMENT
      49  CRMUserID . . . . . . . . . .    11 SNN  CRMUserID . . . . . . . . . . .
      50  CRMUserName . . . . . . . . .    40 SNN  CRM User Name . . . . . . . . .
      51  CRMCompanyID. . . . . . . . .    11 SNN  CRM Company ID. . . . . . . . .
      52  CRMCompanyName. . . . . . . .    40 SNN  CRM Company Name. . . . . . . .
      53  CRMPersonID . . . . . . . . .    11 SNN  CRM Person ID . . . . . . . . .
      54  CRMPersonName . . . . . . . .    40 SNN  CRM Person Name . . . . . . . .
      55  CRMOpportunityID. . . . . . .    11 SNN  CRM Opportunity ID. . . . . . .
      56  CRMOpportunityName. . . . . .    40 SNN  CRMOpportunityName. . . . . . .
      57  Weight. . . . . . . . . . . . 12.2  NNN  Weight. . . . . . . . . . . . .
      58  NumberOfPackages. . . . . . .  5.0  NNN  Number of Packages. . . . . . .
      59  LineDiscountPercent . . . . .  9.3  NNN  Line Discount Percentage. . . .
      60  QuantityOrdered . . . . . . . 16.6  NNN  Quantity Ordered. . . . . . . .
      61  QuantityShipped . . . . . . . 16.6  NNN  Quantity Shipped. . . . . . . .
      62  QuantityBackordered . . . . . 16.6  NNN  Quantity Backordered. . . . . .
      63  FreightAmt. . . . . . . . . . 12.2  NNN  Freight Amount. . . . . . . . .
      64  InvoiceAmt. . . . . . . . . . 12.2  NNN  Invoice Amount. . . . . . . . .