| PRIMARY KEY |
|
I_BPartner_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) |
| |
|
AD_Org_ID
NUMBER (10, 0) |
| |
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) |
| |
|
Created
DATE default: SYSDATE |
| |
|
CreatedBy
NUMBER (10, 0) |
| |
|
Updated
DATE default: SYSDATE |
| |
|
UpdatedBy
NUMBER (10, 0) |
| |
|
I_IsImported
CHAR (1) default: 'N' NOT NULL |
| |
|
I_ErrorMsg
NVARCHAR2 (2000) |
| |
|
C_BPartner_ID
NUMBER (10, 0) |
| C_BPartner |
|
Value
NVARCHAR2 (40) |
| |
|
Name
NVARCHAR2 (60) |
| |
|
Name2
NVARCHAR2 (60) |
| |
|
Description
NVARCHAR2 (255) |
| |
|
DUNS
CHAR (11) |
| |
|
TaxID
VARCHAR2 (20) |
| |
|
NAICS
CHAR (6) |
| |
|
GroupValue
NVARCHAR2 (40) |
| |
|
C_BP_Group_ID
NUMBER (10, 0) |
| C_BP_Group |
|
C_BPartner_Location_ID
NUMBER (10, 0) |
| C_BPartner_Location |
|
Address1
NVARCHAR2 (60) |
| |
|
Address2
NVARCHAR2 (60) |
| |
|
Postal
VARCHAR2 (10) |
| |
|
Postal_Add
VARCHAR2 (10) |
| |
|
City
NVARCHAR2 (60) |
| |
|
C_Region_ID
NUMBER (10, 0) |
| C_Region |
|
RegionName
NVARCHAR2 (60) |
| |
|
C_Country_ID
NUMBER (10, 0) |
| C_Country |
|
CountryCode
CHAR (2) |
ISO 3166 2Character code
| |
|
Title
NVARCHAR2 (40) |
| |
|
ContactName
NVARCHAR2 (60) |
| |
|
ContactDescription
NVARCHAR2 (255) |
| |
|
Comments
NVARCHAR2 (2000) |
| |
|
Phone
NVARCHAR2 (40) |
| |
|
Phone2
NVARCHAR2 (40) |
| |
|
Fax
NVARCHAR2 (40) |
| |
|
EMail
NVARCHAR2 (40) |
| |
|
Password
NVARCHAR2 (20) |
| |
|
Birthday
DATE |
| |
|
C_Greeting_ID
NUMBER (10, 0) |
| C_Greeting |
|
BPContactGreeting
NVARCHAR2 (60) |
| |
|
Processing
CHAR (1) |
| |
|
Processed
CHAR (1) default: 'N' CHECK ( Processed in ( 'Y' , 'N' )) |
| |
|
AD_User_ID
NUMBER (10, 0) |
| AD_User |
FOREIGN KEY
ADUser_IBPartner: AD_User_ID => AD_User
CBPartner_IBPartner: C_BPartner_ID => C_BPartner
CBPartnerLocation_IBPartner: C_BPartner_Location_ID => C_BPartner_Location
CBPGroup_IBPartner: C_BP_Group_ID => C_BP_Group
CCountry_IPartner: C_Country_ID => C_Country
CGreeting_IBPartner: C_Greeting_ID => C_Greeting
CRegion_IBPartner: C_Region_ID => C_Region
|