| PRIMARY KEY |
|
C_Location_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 |
| |
|
Address1
NVARCHAR2 (60) |
| |
|
Address2
NVARCHAR2 (60) |
| |
|
City
NVARCHAR2 (60) |
| |
|
C_City_ID
NUMBER (10, 0) |
| C_City |
|
Postal
VARCHAR2 (10) |
| |
|
Postal_Add
VARCHAR2 (10) |
| |
|
C_Region_ID
NUMBER (10, 0) |
| C_Region |
|
RegionName
NVARCHAR2 (40) |
| |
|
C_Country_ID
NUMBER (10, 0) NOT NULL |
| C_Country |
FOREIGN KEY
ADClient_CLocation: AD_Client_ID => AD_Client
ADOrg_CLocation: AD_Org_ID => AD_Org
C_Country_Location: C_Country_ID => C_Country
C_Region_Location: C_Region_ID => C_Region
CCity_CLocation: C_City_ID => C_City
|
REFERENCED BY
A_Asset,
AD_OrgInfo,
C_AcctSchema_Element,
C_Bank,
C_BPartner_Location,
C_ValidCombination,
C_ValidCombination,
Fact_Acct,
Fact_Acct,
Fact_Acct_Balance,
Fact_Acct_Balance,
I_GLJournal,
I_GLJournal,
I_Invoice,
I_Order,
M_Warehouse,
PA_ReportColumn,
PA_ReportSource |
|