Table C_OrderLine

Diagram I Diagram M Diagram S

PRIMARY KEY
C_OrderLine_ID NUMBER (10, 0) NOT NULL

AD_Client_ID NUMBER (10, 0) NOT NULL
AD_Org_ID NUMBER (10, 0) NOT NULL
IsActive CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL
Created DATE default: SYSDATE NOT NULL
CreatedBy NUMBER (10, 0) NOT NULL
Updated DATE default: SYSDATE NOT NULL
UpdatedBy NUMBER (10, 0) NOT NULL
C_Order_ID NUMBER (10, 0) NOT NULL		C_Order
Line NUMBER (10, 0) NOT NULL
C_BPartner_ID NUMBER (10, 0)		C_BPartner
C_BPartner_Location_ID NUMBER (10, 0)		C_BPartner_Location
DateOrdered DATE NOT NULL
DatePromised DATE
DateDelivered DATE
DateInvoiced DATE
Description NVARCHAR2 (255)
M_Product_ID NUMBER (10, 0)		M_Product
M_AttributeSetInstance_ID NUMBER (10, 0)		M_AttributeSetInstance
M_Warehouse_ID NUMBER (10, 0) NOT NULL		M_Warehouse
DirectShip CHAR (1) default: 'N' CHECK ( DirectShip in ( 'Y' , 'N' )) NOT NULL
C_UOM_ID NUMBER (10, 0) NOT NULL		C_UOM
QtyOrdered NUMBER default: 0 NOT NULL
QtyReserved NUMBER default: 0 NOT NULL
QtyDelivered NUMBER default: 0 NOT NULL
QtyInvoiced NUMBER default: 0 NOT NULL
M_Shipper_ID NUMBER (10, 0)		M_Shipper
C_Currency_ID NUMBER (10, 0) NOT NULL		C_Currency
PriceList NUMBER default: 0 NOT NULL
PriceActual NUMBER default: 0 NOT NULL
PriceLimit NUMBER default: 0 NOT NULL
LineNetAmt NUMBER default: 0 NOT NULL
Discount NUMBER
FreightAmt NUMBER default: 0 NOT NULL
C_Charge_ID NUMBER (10, 0)		C_Charge
ChargeAmt NUMBER default: 0 NOT NULL
C_Tax_ID NUMBER (10, 0) NOT NULL		C_Tax
Lot VARCHAR2 (20)
SerNo VARCHAR2 (20)
S_ResourceAssignment_ID NUMBER (10, 0)		S_ResourceAssignment
Ref_OrderLine_ID NUMBER (10, 0)		C_OrderLine
IsDescription CHAR (1) default: 'N' CHECK ( IsDescription in ( 'Y' , 'N' )) NOT NULL
FOREIGN KEY CBPartner_SOLine: C_BPartner_ID => C_BPartner CBPartnerLocation_SOLine: C_BPartner_Location_ID => C_BPartner_Location CCharge_COrderLine: C_Charge_ID => C_Charge CCurrency_COrderLine: C_Currency_ID => C_Currency COrder_COrderLine: C_Order_ID => C_Order COrderLine_Ref: Ref_OrderLine_ID => C_OrderLine CTax_COrderLine: C_Tax_ID => C_Tax CUOM_COrderLine: C_UOM_ID => C_UOM MAttrSetInst_COrderLine: M_AttributeSetInstance_ID => M_AttributeSetInstance MProduct_COrderLine: M_Product_ID => M_Product MShipper_COrderLine: M_Shipper_ID => M_Shipper MWarehouse_COrderLine: M_Warehouse_ID => M_Warehouse SResourceAssign_COrderLine: S_ResourceAssignment_ID => S_ResourceAssignment
REFERENCED BY C_CommissionDetail, C_InvoiceLine, C_OrderLine, I_Order, M_InOutLine, M_MatchPO, S_TimeExpenseLine