CU_OrderQuoteDetail CU Order Quote Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_"+%C$+"/CU"+%C$+"/CU_OrderQuoteDetail.M4T"
KPRIMARY: LineItemID
KUPDATED: Updated
KMASKEY: MASDocumentNo+MASDocumentType+MASDocumentDate+MASSequenceNo
KQUOTESEQUENCE: OrderQuoteID+LineNumber+LineItemID
Fld Column Name M/L TUR Description/Notes Class
1 LineItemID. . . . . . . . . . 11 SNY Line Item ID. . . . . . . . . .
2 OrderQuoteID. . . . . . . . . 11 SNN Order Quote ID. . . . . . . . .
3 LineNumber. . . . . . . . . . 11 SNN Line Number . . . . . . . . . .
FmtType:ZEROFILL
4 DiscountID. . . . . . . . . . 11 SNN Discount ID . . . . . . . . . .
DfltVal:1
5 DiscountSumID . . . . . . . . 11 SNN Discount Summary ID . . . . . .
DfltVal:1
6 PriceListID . . . . . . . . . 11 SNN Price List ID . . . . . . . . .
DfltVal:1
7 ProductID . . . . . . . . . . 11 SNN Product ID. . . . . . . . . . .
DfltVal:1
8 QuotedPriceID . . . . . . . . 11 SNN Quoted Price ID . . . . . . . .
DfltVal:1
9 QuotedPriceTotalID. . . . . . 11 SNN Quoted Price Total ID . . . . .
DfltVal:1
10 UnitOfMeasureID . . . . . . . 11 SNN Unit Of Measure ID. . . . . . .
DfltVal:1
11 ProductFamilyID . . . . . . . 11 SNN Product Family ID . . . . . . .
DfltVal:1
12 Reference . . . . . . . . . . 30 SNN Reference . . . . . . . . . . .
13 MASDocumentNo . . . . . . . . 7 SNN MAS Document Number . . . . . .
14 MASDocumentType . . . . . . . 1 SYN MAS Order Quote Type. . . . . .
Valid:O,Q,P Notes: O=Order,
Q=Quote, P=Product quote
15 MASDocumentDate . . . . . . . 8 SNN MAS Document Date . . . . . . .DATE
16 MASSequenceNo . . . . . . . . 14 SNN MAS Sequence Number . . . . . .
17 MASItemCode . . . . . . . . . 30 SNN MAS Item Code . . . . . . . . .
18 MASItemDesc . . . . . . . . . 1024 SNN MAS Item Description. . . . . .
19 MASUnitOfMeasure. . . . . . . 5 SNN MAS Unit of Measure . . . . . .
20 MASWarehouseCode. . . . . . . 3 SNN MAS Warehouse Code. . . . . . .
21 MASKitYesNo . . . . . . . . . 1 SYN MAS Kit Yes/No. . . . . . . . .YESNO
DfltVal:N Valid:Y,N
22 MASComponentYesNo . . . . . . 1 SYN MAS Component Yes/No. . . . . .YESNO
DfltVal:N Valid:Y,N
23 LineItemDiscAmt . . . . . . . 16.2 NNN Line Item Discount Amount . . .
24 LineItemDiscSum . . . . . . . 16.2 NNN Line Item Discount Summary. . .
25 ListPrice . . . . . . . . . . 16.2 NNN List Price. . . . . . . . . . .
26 Quantity. . . . . . . . . . . 16.2 NNN Quantity. . . . . . . . . . . .
27 QuotedPrice . . . . . . . . . 16.2 NNN Quoted Price. . . . . . . . . .
28 QuotedPriceTotal. . . . . . . 16.2 NNN Quoted Price Total. . . . . . .
29 DateTimeStamp . . . . . . . . 23 SNN Date Time Stamp . . . . . . . .
30 Updated . . . . . . . . . . . 1 SYN Updated . . . . . . . . . . . .YESNO
DfltVal:Y Valid:Y,N
31 ComputerName. . . . . . . . . 15 SNN Computer Name . . . . . . . . .