| PRIMARY KEY |
|
C_BP_Relation_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| |
|
AD_Org_ID
NUMBER (10, 0) NOT NULL |
| |
|
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) |
| |
|
C_BPartner_ID
NUMBER (10, 0) NOT NULL |
| C_BPartner |
|
C_BPartner_Location_ID
NUMBER (10, 0) |
| C_BPartner_Location |
|
IsShipTo
CHAR (1) default: 'N' CHECK ( IsShipTo in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsBillTo
CHAR (1) default: 'N' CHECK ( IsBillTo in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsPayFrom
CHAR (1) default: 'N' CHECK ( IsPayFrom in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsRemitTo
CHAR (1) default: 'N' CHECK ( IsRemitTo in ( 'Y' , 'N' )) NOT NULL |
| |
|
C_BPartnerRelation_ID
NUMBER (10, 0) NOT NULL |
| C_BPartner |
|
C_BPartnerRelation_Location_ID
NUMBER (10, 0) NOT NULL |
| C_BPartner_Location |
FOREIGN KEY
CBPartner_CBPRelation: C_BPartner_ID => C_BPartner
CBPartner_CBPRelationBP: C_BPartnerRelation_ID => C_BPartner
CBPLocation_CBPRelation: C_BPartner_Location_ID => C_BPartner_Location
CBPLocation_CBPRelationBP: C_BPartnerRelation_Location_ID => C_BPartner_Location
|