| PRIMARY KEY |
|
AD_User_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 |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
Title
NVARCHAR2 (40) |
| |
|
C_Greeting_ID
NUMBER (10, 0) |
| C_Greeting |
|
Description
NVARCHAR2 (255) |
| |
|
Comments
NVARCHAR2 (2000) |
| |
|
C_BPartner_ID
NUMBER (10, 0) |
| C_BPartner |
|
C_BPartner_Location_ID
NUMBER (10, 0) |
| C_BPartner_Location |
|
Password
NVARCHAR2 (40) |
| |
|
EMail
NVARCHAR2 (60) |
| |
|
EMailVerify
NVARCHAR2 (40) |
| |
|
Phone
NVARCHAR2 (40) |
| |
|
Phone2
NVARCHAR2 (40) |
| |
|
EMailUser
NVARCHAR2 (20) |
| |
|
EMailUserPW
NVARCHAR2 (20) |
| |
|
Fax
NVARCHAR2 (40) |
| |
|
Birthday
DATE |
| |
|
Supervisor_ID
NUMBER (10, 0) |
| AD_User |
|
AD_OrgTrx_ID
NUMBER (10, 0) |
| AD_Org |
|
PA_Goal_ID
NUMBER (10, 0) |
| PA_Goal |
|
PA_GoalPrivate_ID
NUMBER (10, 0) |
| PA_Goal |
|
LastContact
DATE |
| |
|
LastResult
NVARCHAR2 (255) |
| |
|
Processing
CHAR (1) |
| |
FOREIGN KEY
AD_User_Client: AD_Client_ID => AD_Client
AD_User_Org: AD_Org_ID => AD_Org
ADOrgTrx_ADUser: AD_OrgTrx_ID => AD_Org
ADUser_Supervisor: Supervisor_ID => AD_User
CBPartner_ADUser: C_BPartner_ID => C_BPartner
CBPLocation_ADUser: C_BPartner_Location_ID => C_BPartner_Location
CGreeting_ADUser: C_Greeting_ID => C_Greeting
PAGoal_ADUser: PA_Goal_ID => PA_Goal
PAGoalPrivate_ADUser: PA_GoalPrivate_ID => PA_Goal
|
REFERENCED BY
A_Asset,
A_Asset_Delivery,
A_Registration,
AD_AlertProcessor,
AD_AlertRecipient,
AD_Note,
AD_OrgInfo,
AD_PInstance,
AD_Preference,
AD_Private_Access,
AD_Role,
AD_Scheduler,
AD_TreeBar,
AD_User_Roles,
AD_User_Substitute,
AD_User_Substitute,
AD_User,
AD_UserDef_Win,
AD_WF_Activity,
AD_WF_EventAudit,
AD_WF_Process,
AD_WF_Responsible,
AD_WorkflowProcessor,
B_BidComment,
B_Buyer,
B_Seller,
C_AcctProcessor,
C_BP_BankAccount,
C_BPartner,
C_Invoice,
C_Invoice,
C_Order,
C_Order,
C_Order,
C_OrgAssignment,
C_Project,
C_Project,
C_RfQ,
C_RfQ_TopicSubscriber,
C_RfQResponse,
I_BPartner,
I_Invoice,
I_Invoice,
I_Order,
I_Order,
M_InOut,
M_InOut,
R_ContactInterest,
R_Request,
R_Request,
R_RequestAction,
R_RequestAction,
R_RequestProcessor,
R_RequestProcessor_Route,
S_Resource,
TIRE_Storage,
W_Advertisement,
W_Basket,
W_Click,
W_Counter |
|