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