| PRIMARY KEY |
|
C_BPartner_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 |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
IsBillTo
CHAR (1) default: 'Y' CHECK ( IsBillTo in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsShipTo
CHAR (1) default: 'Y' CHECK ( IsShipTo in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsPayFrom
CHAR (1) default: 'Y' CHECK ( IsPayFrom in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsRemitTo
CHAR (1) default: 'Y' CHECK ( IsRemitTo in ( 'Y' , 'N' )) NOT NULL |
| |
|
Phone
NVARCHAR2 (40) |
| |
|
Phone2
NVARCHAR2 (40) |
| |
|
Fax
NVARCHAR2 (40) |
| |
|
ISDN
NVARCHAR2 (40) |
| |
|
C_SalesRegion_ID
NUMBER (10, 0) |
| C_SalesRegion |
|
C_BPartner_ID
NUMBER (10, 0) NOT NULL |
| C_BPartner |
|
C_Location_ID
NUMBER (10, 0) |
| C_Location |
FOREIGN KEY
C_BusPartner_LocationClient: AD_Client_ID => AD_Client
C_BusPartner_LocationOrg: AD_Org_ID => AD_Org
CBPartner_CBPLocation: C_BPartner_ID => C_BPartner
CLocation_CBPLocation: C_Location_ID => C_Location
CSalesRegion_BPartnerLocation: C_SalesRegion_ID => C_SalesRegion
|
REFERENCED BY
A_Asset,
AD_User,
C_BP_Relation,
C_BP_Relation,
C_Invoice,
C_Order,
C_Order,
C_Order,
C_Order,
C_OrderLine,
C_Project,
C_RfQ,
C_RfQ_TopicSubscriber,
C_RfQResponse,
I_BPartner,
I_Invoice,
I_Order,
I_Order,
M_DistributionListLine,
M_InOut |
|