| PRIMARY KEY |
|
C_Country_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 |
| |
|
Description
NVARCHAR2 (255) |
| |
|
CountryCode
CHAR (2) NOT NULL |
ISO 3166 2Character code
| |
|
HasRegion
CHAR (1) default: 'N' CHECK ( HasRegion in ( 'Y' , 'N' )) NOT NULL |
| |
|
RegionName
NVARCHAR2 (60) |
| |
|
ExpressionPhone
NVARCHAR2 (20) |
| |
|
DisplaySequence
NVARCHAR2 (20) NOT NULL |
| |
|
ExpressionPostal
NVARCHAR2 (20) |
| |
|
HasPostal_Add
CHAR (1) default: 'N' CHECK ( HasPostal_Add in ( 'Y' , 'N' )) NOT NULL |
| |
|
ExpressionPostal_Add
NVARCHAR2 (20) |
| |
|
IsDefault
CHAR (1) default: 'N' CHECK ( IsDefault in ( 'Y' , 'N' )) |
| |
|
C_Currency_ID
NUMBER (10, 0) |
| C_Currency |
|
AD_Language
VARCHAR2 (6) |
| AD_Language |
FOREIGN KEY
ADLanguage_CCountry: AD_Language => AD_Language
C_CountryClient: AD_Client_ID => AD_Client
C_CountryOrg: AD_Org_ID => AD_Org
CCurrency_CCountry: C_Currency_ID => C_Currency
|
REFERENCED BY
C_City,
C_Country_Trl,
C_Location,
C_Region,
C_Tax,
C_Tax,
I_BPartner,
I_Invoice,
I_Order,
M_Freight,
M_Freight |
|