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