| PRIMARY KEY |
|
W_Advertisement_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 |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
Help
NVARCHAR2 (2000) |
| |
|
IsSelfService
CHAR (1) default: 'N' CHECK ( IsSelfService in ( 'Y' , 'N' )) NOT NULL |
Was entered and/or can be edited by user via Self Service
| |
|
Version
NUMBER (10, 0) |
| |
|
PublishStatus
CHAR (1) NOT NULL |
| |
|
C_BPartner_ID
NUMBER (10, 0) NOT NULL |
| C_BPartner |
|
AD_User_ID
NUMBER (10, 0) |
| AD_User |
|
W_ClickCount_ID
NUMBER (10, 0) |
| W_ClickCount |
|
W_CounterCount_ID
NUMBER (10, 0) |
| W_CounterCount |
|
ValidFrom
DATE |
| |
|
ValidTo
DATE |
| |
|
ImageURL
NVARCHAR2 (120) |
| |
|
AdText
NVARCHAR2 (2000) |
| |
|
WebParam1
NVARCHAR2 (2000) |
| |
|
WebParam2
NVARCHAR2 (2000) |
| |
|
WebParam3
NVARCHAR2 (2000) |
| |
|
WebParam4
NVARCHAR2 (2000) |
| |
|
Processing
CHAR (1) |
| |
FOREIGN KEY
ADUser_WAdvertisement: AD_User_ID => AD_User
CBPartner_WAdvertisement: C_BPartner_ID => C_BPartner
WClickCount_WAdvertisement: W_ClickCount_ID => W_ClickCount
WCounterCount_WAdvertisement: W_CounterCount_ID => W_CounterCount
|