| PRIMARY KEY |
|
C_Campaign_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 |
| |
|
Value
NVARCHAR2 (40) NOT NULL |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
C_Channel_ID
NUMBER (10, 0) |
| C_Channel |
|
StartDate
DATE |
| |
|
EndDate
DATE |
| |
|
Costs
NUMBER default: 0 NOT NULL |
| |
FOREIGN KEY
CChannel_CCampaign: C_Channel_ID => C_Channel
|
REFERENCED BY
C_AcctSchema_Element,
C_Cash,
C_Invoice,
C_Order,
C_Payment,
C_Project,
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,
S_TimeExpenseLine |
|