| PRIMARY KEY |
|
C_BPartner_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_OrgBP_ID
NUMBER (10, 0) |
| AD_Org |
|
Invoice_PrintFormat_ID
NUMBER (10, 0) |
| AD_PrintFormat |
|
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 |
| |
|
Value
NVARCHAR2 (40) NOT NULL |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
Name2
NVARCHAR2 (60) |
| |
|
Description
NVARCHAR2 (255) |
| |
|
IsSummary
CHAR (1) default: 'N' NOT NULL |
| |
|
C_BP_Group_ID
NUMBER (10, 0) NOT NULL |
| C_BP_Group |
|
BPartner_Parent_ID
NUMBER (10, 0) |
| C_BPartner |
|
IsOneTime
CHAR (1) default: 'N' CHECK ( IsOneTime in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsProspect
CHAR (1) default: 'Y' CHECK ( IsProspect in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsVendor
CHAR (1) default: 'N' CHECK ( IsVendor in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsCustomer
CHAR (1) default: 'Y' CHECK ( IsCustomer in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsEmployee
CHAR (1) default: 'N' CHECK ( IsEmployee in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsSalesRep
CHAR (1) default: 'N' CHECK ( IsSalesRep in ( 'Y' , 'N' )) NOT NULL |
| |
|
ReferenceNo
NVARCHAR2 (40) |
Own Custoner or Vendor Number at the Business Partner
| |
|
DUNS
CHAR (11) |
| |
|
URL
NVARCHAR2 (120) |
| |
|
AD_Language
VARCHAR2 (6) |
| AD_Language |
|
TaxID
VARCHAR2 (20) |
| |
|
IsTaxExempt
CHAR (1) default: 'N' CHECK ( IsTaxExempt in ( 'Y' , 'N' )) |
| |
|
C_InvoiceSchedule_ID
NUMBER (10, 0) |
| C_InvoiceSchedule |
|
Rating
CHAR (1) |
Payment, Delivery Performance, Strategic Partner
| |
|
SalesVolume
NUMBER (10, 0) |
| |
|
NumberEmployees
NUMBER (10, 0) |
| |
|
NAICS
CHAR (6) |
| |
|
FirstSale
DATE |
| |
|
AcqusitionCost
NUMBER default: 0 |
| |
|
PotentialLifeTimeValue
NUMBER default: 0 |
| |
|
ActualLifeTimeValue
NUMBER default: 0 |
| |
|
ShareOfCustomer
NUMBER (10, 0) |
| |
|
PaymentRule
CHAR (1) |
Check, BACS, Letter of Credit
| |
|
SO_CreditLimit
NUMBER default: 0 |
| |
|
SO_CreditUsed
NUMBER default: 0 |
| |
|
SOCreditStatus
CHAR (1) default: 'O' |
| |
|
C_PaymentTerm_ID
NUMBER (10, 0) |
| C_PaymentTerm |
|
M_PriceList_ID
NUMBER (10, 0) |
| M_PriceList |
|
M_DiscountSchema_ID
NUMBER (10, 0) |
| M_DiscountSchema |
|
C_Dunning_ID
NUMBER (10, 0) |
| C_Dunning |
|
IsDiscountPrinted
CHAR (1) default: 'Y' CHECK ( IsDiscountPrinted in ( 'Y' , 'N' )) |
| |
|
SO_Description
NVARCHAR2 (255) |
| |
|
POReference
NVARCHAR2 (20) |
| |
|
PaymentRulePO
CHAR (1) |
| |
|
PO_PriceList_ID
NUMBER (10, 0) |
| M_PriceList |
|
PO_DiscountSchema_ID
NUMBER (10, 0) |
| M_DiscountSchema |
|
PO_PaymentTerm_ID
NUMBER (10, 0) |
| C_PaymentTerm |
|
DocumentCopies
NUMBER (10, 0) |
| |
|
C_Greeting_ID
NUMBER (10, 0) |
| C_Greeting |
|
SalesRep_ID
NUMBER (10, 0) |
| AD_User |
|
InvoiceRule
CHAR (1) |
| |
|
DeliveryRule
CHAR (1) |
| |
|
FreightCostRule
CHAR (1) |
| |
|
DeliveryViaRule
CHAR (1) |
| |
|
SendEMail
CHAR (1) default: 'N' CHECK ( SendEMail in ( 'Y' , 'N' )) NOT NULL |
| |
|
ShelfLifeMinPct
NUMBER (10, 0) |
| |
FOREIGN KEY
AD_Language_C_BusPartner: AD_Language => AD_Language
ADClient_CBPartner: AD_Client_ID => AD_Client
ADOrg_CBPartner: AD_Org_ID => AD_Org
ADOrg_CBPartnerOrg: AD_OrgBP_ID => AD_Org
ADPrintFormatInv_CBPartner: Invoice_PrintFormat_ID => AD_PrintFormat
ADUserSalesRep_CBPartner: SalesRep_ID => AD_User
CBPartner_CPBartnerParent: BPartner_Parent_ID => C_BPartner
CBPGroup_CBPartner: C_BP_Group_ID => C_BP_Group
CDunning_CBPartner: C_Dunning_ID => C_Dunning
CGreeting_CBPartner: C_Greeting_ID => C_Greeting
CInvoiceSchedule_CBPartner: C_InvoiceSchedule_ID => C_InvoiceSchedule
CPaymentTerm_CBPartner: C_PaymentTerm_ID => C_PaymentTerm
CPOPaymentTerm_CBPartner: PO_PaymentTerm_ID => C_PaymentTerm
MDiscountS_CBPartner: M_DiscountSchema_ID => M_DiscountSchema
MDiscountSPO_CBPartner: PO_DiscountSchema_ID => M_DiscountSchema
MPriceList_CBPartner: M_PriceList_ID => M_PriceList
MPriceListPO_CBusPartner: PO_PriceList_ID => M_PriceList
|
REFERENCED BY
A_Asset,
A_Registration,
AD_User,
C_AcctSchema_Element,
C_Allocation,
C_BankStatementLine,
C_BP_BankAccount,
C_BP_Customer_Acct,
C_BP_EDI,
C_BP_Employee_Acct,
C_BP_Relation,
C_BP_Relation,
C_BP_Vendor_Acct,
C_BP_Withholding,
C_BPartner_Location,
C_BPartner_Product,
C_BPartner,
C_Commission,
C_CommissionLine,
C_DunningRunEntry,
C_DunningRunLine,
C_Invoice,
C_Order,
C_Order,
C_Order,
C_OrderLine,
C_Payment,
C_PaySelectionCheck,
C_Project,
C_RfQ,
C_RfQ_TopicSubscriber,
C_RfQResponse,
C_Subscription,
C_ValidCombination,
Fact_Acct,
Fact_Acct_Balance,
I_BankStatement,
I_BPartner,
I_GLJournal,
I_Invoice,
I_Order,
I_Payment,
I_Product,
M_DiscountSchemaLine,
M_DistributionListLine,
M_InOut,
M_Product_PO,
M_Shipper,
PA_Measure,
PA_ReportColumn,
PA_ReportSource,
R_Request,
R_RequestAction,
S_TimeExpense,
S_TimeExpenseLine,
T_Aging,
TIRE_Storage,
W_Advertisement,
W_Basket,
W_ClickCount,
W_CounterCount |
|