Table C_ProjectLine

PRIMARY KEY
C_ProjectLine_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_Project_ID NUMBER (10, 0) NOT NULL		C_Project
Line NUMBER (10, 0) NOT NULL
Description NVARCHAR2 (255)
PlannedQty NUMBER default: 0 NOT NULL
PlannedPrice NUMBER default: 0 NOT NULL
PlannedAmt NUMBER default: 0 NOT NULL
PlannedMarginAmt NUMBER default: 0 NOT NULL
CommittedAmt NUMBER default: 0
CommittedQty NUMBER default: 0
InvoicedAmt NUMBER default: 0 NOT NULL
InvoicedQty NUMBER default: 0 NOT NULL
IsPrinted CHAR (1) default: 'Y' CHECK ( IsPrinted in ( 'Y' , 'N' )) NOT NULL
DoPricing CHAR (1) default: 'Y' CHECK ( DoPricing in ( 'Y' , 'N' ))
M_Product_ID NUMBER (10, 0)		M_Product
M_Product_Category_ID NUMBER (10, 0)		M_Product_Category
C_ProjectIssue_ID NUMBER (10, 0)		C_ProjectIssue
C_Order_ID NUMBER (10, 0)		C_Order
C_OrderPO_ID NUMBER (10, 0)		C_Order
Processed CHAR (1) default: 'N' CHECK ( Processed in ( 'Y' , 'N' )) NOT NULL
FOREIGN KEY COrder_CProjectLine: C_Order_ID => C_Order COrderPO_CProjectLine: C_OrderPO_ID => C_Order CProject_CProjectLine: C_Project_ID => C_Project CProjectIssue_CProjectLine: C_ProjectIssue_ID => C_ProjectIssue MProduct_CProjectLine: M_Product_ID => M_Product MProductCat_CProjectLine: M_Product_Category_ID => M_Product_Category