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