| PRIMARY KEY |
|
C_Project_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| AD_Client |
|
AD_Org_ID
NUMBER (10, 0) NOT NULL |
| AD_Org |
|
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 |
| |
|
Value
NVARCHAR2 (40) NOT NULL |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
Note
NVARCHAR2 (2000) |
| |
|
IsSummary
CHAR (1) default: 'N' NOT NULL |
| |
|
C_ProjectType_ID
NUMBER (10, 0) |
| C_ProjectType |
|
ProjectCategory
CHAR (1) default: 'N' |
| |
|
C_Phase_ID
NUMBER (10, 0) |
| C_Phase |
|
AD_User_ID
NUMBER (10, 0) |
| AD_User |
|
SalesRep_ID
NUMBER (10, 0) |
| AD_User |
|
C_BPartner_ID
NUMBER (10, 0) |
| C_BPartner |
|
C_BPartner_Location_ID
NUMBER (10, 0) |
| C_BPartner_Location |
|
POReference
NVARCHAR2 (20) |
| |
|
M_Warehouse_ID
NUMBER (10, 0) |
| M_Warehouse |
|
C_PaymentTerm_ID
NUMBER (10, 0) |
| C_PaymentTerm |
|
C_Currency_ID
NUMBER (10, 0) NOT NULL |
| C_Currency |
|
M_PriceList_Version_ID
NUMBER (10, 0) |
| M_PriceList_Version |
|
C_Campaign_ID
NUMBER (10, 0) |
| C_Campaign |
|
IsCommitment
CHAR (1) default: 'Y' CHECK ( IsCommitment in ( 'Y' , 'N' )) NOT NULL |
| |
|
PlannedAmt
NUMBER default: 0 NOT NULL |
| |
|
PlannedQty
NUMBER default: 0 NOT NULL |
| |
|
PlannedMarginAmt
NUMBER default: 0 NOT NULL |
| |
|
CommittedAmt
NUMBER default: 0 NOT NULL |
Business Partner Commitment
| |
|
CommittedQty
NUMBER default: 0 NOT NULL |
| |
|
IsCommitCeiling
CHAR (1) default: 'N' CHECK ( IsCommitCeiling in ( 'Y' , 'N' )) NOT NULL |
| |
|
InvoicedAmt
NUMBER default: 0 NOT NULL |
| |
|
InvoicedQty
NUMBER default: 0 NOT NULL |
| |
|
ProjectBalanceAmt
NUMBER default: 0 NOT NULL |
| |
|
DateContract
DATE |
| |
|
DateFinish
DATE |
| |
|
GenerateTo
CHAR (1) CHECK ( GenerateTo in ( 'Y' , 'N' )) |
| |
|
CopyFrom
CHAR (1) |
Copy from same entity
| |
|
Processing
CHAR (1) |
| |
|
Processed
CHAR (1) default: 'N' CHECK ( Processed in ( 'Y' , 'N' )) NOT NULL |
| |
FOREIGN KEY
ADClient_CProject: AD_Client_ID => AD_Client
ADOrg_CProject: AD_Org_ID => AD_Org
ADUser_CProject: AD_User_ID => AD_User
ADUser_SR_CProject: SalesRep_ID => AD_User
CBPartner_CProject: C_BPartner_ID => C_BPartner
CBPLocation_CProject: C_BPartner_Location_ID => C_BPartner_Location
CCampaign_CProject: C_Campaign_ID => C_Campaign
CCurrency_CProject: C_Currency_ID => C_Currency
CPaymentTerm_CProject: C_PaymentTerm_ID => C_PaymentTerm
CPhase_CProject: C_Phase_ID => C_Phase
CProjectType_CProject: C_ProjectType_ID => C_ProjectType
MPriceListVersion_CProject: M_PriceList_Version_ID => M_PriceList_Version
MWarehouse_CProject: M_Warehouse_ID => M_Warehouse
|
REFERENCED BY
C_AcctSchema_Element,
C_Cash,
C_Invoice,
C_Order,
C_Payment,
C_Project_Acct,
C_ProjectIssue,
C_ProjectLine,
C_ProjectPhase,
C_Recurring,
C_Recurring_Run,
C_ValidCombination,
Fact_Acct,
Fact_Acct_Balance,
I_GLJournal,
I_Invoice,
I_Order,
M_InOut,
M_Inventory,
M_Movement,
M_Production,
PA_ReportColumn,
PA_ReportSource,
R_Request,
R_RequestAction,
S_TimeExpenseLine |
|