     CU_OrderQuoteTracking                  CU Order Quote Tracking        Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: N/A
     SQL Def: Y  SysDB: N                                 "MAS_"+%C$+"/CU"+%C$+"/CU_OrderQuoteTracking.M4T"

     KPRIMARY: OrderQuoteID
     KUPDATED: Updated
     KMASKEY: MASDocumentNo+MASDocumentType+MASDocumentDate+MASSequenceNo
     KDOCUMENTDATE: MASDocumentDate+OrderQuoteID

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  OrderQuoteID. . . . . . . . .    11 SNY  Order Quote ID. . . . . . . . .
       2  OpportunityID . . . . . . . .    11 SNN  Opportunity ID. . . . . . . . .
       3  RelatedDocumentID . . . . . .    11 SNN  Related Document ID . . . . . .
       4  Reference . . . . . . . . . .    30 SNN  Reference . . . . . . . . . . .
       5  IsQuote . . . . . . . . . . .     1 SYN  Is Quote. . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
       6  Description . . . . . . . . .    40 SNN  Description . . . . . . . . . .
       7  Status. . . . . . . . . . . .    20 SNN  Status. . . . . . . . . . . . .
       8  Rollup. . . . . . . . . . . .     1 SYN  Rollup. . . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    Shows on screens as "Include
                                                    In Total"
       9  MASDocumentNo . . . . . . . .     7 SNN  MAS Document Number . . . . . .
      10  MASDocumentType . . . . . . .     1 SNN  MAS Order Quote Type. . . . . .
                                                    Valid:O,Q,P Notes: O=Order,
                                                    Q=Quote, P=Prospect quote.
      11  MASDocumentDate . . . . . . .     8 SNN  MAS Document Date . . . . . . .DATE
      12  MASSequenceNo . . . . . . . .    14 SNN  MAS Sequence Number . . . . . .
      13  ShipVia . . . . . . . . . . .    30 SNN  Ship Via. . . . . . . . . . . .
      14  ConfirmTo . . . . . . . . . .    30 SNN  Confirm To. . . . . . . . . . .
      15  TermsDesc . . . . . . . . . .    30 SNN  Terms Description . . . . . . .
      16  OrderComment. . . . . . . . .    30 SNN  Order Comment . . . . . . . . .
      17  FOB . . . . . . . . . . . . .    30 SNN  FOB . . . . . . . . . . . . . .
      18  PONumber. . . . . . . . . . .    30 SNN  PO Number . . . . . . . . . . .
      19  CreatedDate . . . . . . . . .     8 SNN  Created Date. . . . . . . . . .DATE
      20  ExpireShipDate. . . . . . . .     8 SNN  Expire Ship Date. . . . . . . .DATE
      21  BillToName. . . . . . . . . .    30 SNN  Bill To Name. . . . . . . . . .NAME
      22  BillToAddress1. . . . . . . .    30 SNN  Bill To Address Line 1. . . . .ADDRESSLINE
      23  BillToAddress2. . . . . . . .    30 SNN  Bill To Address Line 2. . . . .ADDRESSLINE
      24  BillToAddress3. . . . . . . .    30 SNN  Bill To Address Line 3. . . . .ADDRESSLINE
      25  BillToCity. . . . . . . . . .    20 SNN  Bill To City. . . . . . . . . .CITY
      26  BillToState . . . . . . . . .     2 SNN  Bill To State Code. . . . . . .STATE
      27  BillToZipCode . . . . . . . .    10 SNN  Bill To Zip Code. . . . . . . .ZIPCODE
      28  BillToCountry . . . . . . . .    30 SNN  Bill To Country . . . . . . . .
      29  ShipToName. . . . . . . . . .    30 SNN  Ship To Name. . . . . . . . . .NAME
      30  ShipToAddress1. . . . . . . .    30 SNN  Ship To Address Line 1. . . . .ADDRESSLINE
      31  ShipToAddress2. . . . . . . .    30 SNN  Ship To Address Line 2. . . . .ADDRESSLINE
      32  ShipToAddress3. . . . . . . .    30 SNN  Ship To Address Line 3. . . . .ADDRESSLINE
      33  ShipToCity. . . . . . . . . .    20 SNN  Ship To City. . . . . . . . . .CITY
      34  ShipToState . . . . . . . . .     2 SNN  Ship To State Code. . . . . . .STATE
      35  ShipToZipCode . . . . . . . .    10 SNN  Ship To Zip Code. . . . . . . .ZIPCODE
      36  ShipToCountry . . . . . . . .    30 SNN  Ship To Country . . . . . . . .
      37  DiscountPercent . . . . . . .  8.3  NNN  Discount Rate . . . . . . . . .RATE
                                                    Mask:###.000-%
      38  GrossAmt. . . . . . . . . . . 16.2  NNN  Gross Amount. . . . . . . . . .
      39  NetAmount . . . . . . . . . . 16.2  NNN  Net Amount. . . . . . . . . . .
      40  SalesTaxAmt . . . . . . . . . 16.2  NNN  Sales Tax Amount. . . . . . . .
      41  DiscountAmt . . . . . . . . . 16.2  NNN  Amount. . . . . . . . . . . . .
      42  FreightAmt. . . . . . . . . . 16.2  NNN  Freight Amount. . . . . . . . .
      43  DepositAmt. . . . . . . . . . 16.2  NNN  Deposit Amount. . . . . . . . .
      44  BalanceDue. . . . . . . . . . 16.2  NNN  Balance Due . . . . . . . . . .
      45  DateTimeStamp . . . . . . . .    23 SNN  Date Time Stamp . . . . . . . .
      46  Updated . . . . . . . . . . .     1 SYN  Updated . . . . . . . . . . . .YESNO
                                                    DfltVal:Y Valid:Y,N
      47  ComputerName. . . . . . . . .    15 SNN  Computer Name . . . . . . . . .