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 . . . . . . . . .