ERP/3.0/Developers Guide/Database Model/org.openbravo.model.externalbpartner/C ExtBP Config Property

Contents 1 C_ExtBP_Config_Property 1.1 Columns 1.1.1 Active 1.1.2 ApiKey 1.1.3 C_Extbp_Config_Property_ID 1.1.4 Category Key 1.1.5 Category Key Sequence Number 1.1.6 Client 1.1.7 Create Sequence Number 1.1.8 Create_Colspan 1.1.9 Created By 1.1.10 Creation Date 1.1.11 CustomersWindow_SeqNo 1.1.12 Detail Sequence Number 1.1.13 Detail_Colspan 1.1.14 Display in Create 1.1.15 Display in Detail 1.1.16 Display in Edit 1.1.17 Display in List 1.1.18 Edit Sequence Number 1.1.19 Edit_Colspan 1.1.20 Editable 1.1.21 External Business Partner Integration Configuration 1.1.22 Identifier Sequence Number 1.1.23 Identifierscanningaction 1.1.24 IsAddressProperty 1.1.25 IsDefaultAddress 1.1.26 IsDisplayedInCustomersWindow 1.1.27 Isbirthdaydate 1.1.28 Isdefaultemail 1.1.29 Isdefaultphone 1.1.30 Key Column 1.1.31 Key Sequence Number 1.1.32 List Sequence Number 1.1.33 List_Colspan 1.1.34 Mandatory 1.1.35 Message 1.1.36 Organization 1.1.37 Reference 1.1.37.1 List values: CRM Connector Valid References 1.1.38 Section 1.1.39 Section Create 1.1.40 Section Edit 1.1.41 Text 1.1.42 Translatable 1.1.43 Updated 1.1.44 Updated By 1.1.45 Use as Marketing Consent for Email 1.1.46 Used as Record Identifier 1.1.47 crmBusinessProperty 1.1.47.1 List values: CRM Property Type 1.2 Other Info 1.2.1 Check Constraints

C_ExtBP_Config_Property

• Name:C_ExtBP_Config_Property
• Classname:C_ExtBP_Config_Property

This table contains the following columns:

Name	Nullable	Data Type	Description
Isactive	No	CHAR (1)	There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records: (1) The system requires the record for auditing purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.
ApiKey	No	NVARCHAR (200)	Identifier of a concrete property into the external system
C_Extbp_Config_Property_ID	No	VARCHAR (32)	CRM Connector Property
IsCategoryKey	No	CHAR (1)	If checked, the property will be used as category key.
CategoryKey_Seqno	Yes	DECIMAL (10,0)	Sequence in the category key
AD_Client_ID	No	VARCHAR (32)	A Client is a company or a legal entity. You cannot share data between Clients.
Create_Seqno	Yes	DECIMAL (10,0)	Sequence to display the property in create view
Create_Colspan	Yes	DECIMAL (1,0)
Createdby	No	VARCHAR (32)	The Created By field indicates the user who created this record.
Created	No	TIMESTAMP (7)	The Created field indicates the date that this record was created.
CustomersWindow_SeqNo	Yes	DECIMAL (10,0)	Sequence to display the property in Customers Window
Detail_Seqno	Yes	DECIMAL (10,0)	Sequence to display the property in detail view
Detail_Colspan	Yes	DECIMAL (1,0)
Isdisplayedincreate	No	CHAR (1)	If checked, the property will be shown in the create view
IsDisplayedInDetail	No	CHAR (1)	If checked, the property will be shown in the detail view
Isdisplayedinedit	No	CHAR (1)	If checked, the property will be shown in the edit view
IsDisplayedInList	No	CHAR (1)	If checked, the property will be shown in the results list view
Edit_Seqno	Yes	DECIMAL (10,0)	Sequence to display the property in edit view
Edit_Colspan	Yes	DECIMAL (1,0)
IsEditable	No	CHAR (1)	It checked, the property can be edited
C_Extbp_Config_ID	No	VARCHAR (32)	Configuration to connect to the CRM system API, and which also defines the properties and filters used by Openbravo to map with the external system information.
Identifier_Seqno	Yes	DECIMAL (10,0)	The sequence indicates the order for the properties within the identifier
Identifierscanningaction	No	CHAR (1)	Use as identifier for scanning action
IsAddressProperty	No	CHAR (1)	Defines if a property is considered for address only flows
IsDefaultAddress	No	CHAR (1)	If enabled, this record will be used to retrieve the default Address of the customer
IsDisplayedInCustomersWindow	No	CHAR (1)	If checked, the property will be shown in the Customers Window
Isbirthdaydate	No	CHAR (1)	If enabled, this record will be used as birthday date of the customer
Isdefaultemail	No	CHAR (1)	If enabled, this record will be used to retrieve the default Email of the customer
Isdefaultphone	No	CHAR (1)	If checked, this will be used as the default Phone number of the customer when present.
IsKey	No	CHAR (1)	The key column must also be display sequence 0 in the field definition and may be hidden.
Key_Seqno	Yes	DECIMAL (10,0)	It allows to specify the right order when several properties are part of the key
List_Seqno	Yes	DECIMAL (10,0)	Sequence to display the property in the results list view
List_Colspan	Yes	DECIMAL (1,0)
Ismandatory	No	CHAR (1)	The Mandatory checkbox indicates if the field is required for a record to be save to the database.
AD_Message_ID	Yes	VARCHAR (32)	Information and Error messages
AD_Org_ID	No	VARCHAR (32)
AD_Reference	No	VARCHAR (60)	The Reference indicates the type of reference field
Sectionmessage_ID	Yes	VARCHAR (32)
Sectionmessagecreate_ID	Yes	VARCHAR (32)
Sectionmessageedit_ID	Yes	VARCHAR (32)
Text	Yes	NVARCHAR (2000)	The Text field stores the user entered information.
Istranslatable	No	CHAR (1)
Updated	No	TIMESTAMP (7)	The Updated field indicates the date that this record was updated.
Updatedby	No	VARCHAR (32)	The Updated By field indicates the user who updated this record.
Isemailmarketingconsent	No	CHAR (1)	If enabled, the customer gives his marketing consent
IsIdentifier	No	CHAR (1)	The Identifier checkbox indicates that this column is part of the identifier or key for this table
crmBusinessProperty	Yes	VARCHAR (60)	Semantic field type for the CRM property

Columns

Active

• Physical column name: Isactive
• Property Name: active
• Reference: YesNo
• Default value: Y

top

ApiKey

• Physical column name: ApiKey
• Property Name: apiKey
• Reference: String

• This column is part of the table's identifier

top

C_Extbp_Config_Property_ID

• Physical column name: C_Extbp_Config_Property_ID
• Property Name: id
• Reference: ID

top

Category Key

• Physical column name: IsCategoryKey
• Property Name: categoryKey
• Reference: YesNo
• Default value: N

top

Category Key Sequence Number

• Physical column name: CategoryKey_Seqno
• Property Name: categoryKeySequenceNumber
• Reference: Integer

top

Client

• Physical column name: AD_Client_ID
• Property Name: client
• Reference: TableDir

Foreign key column to AD_Client table, (column: AD_Client_ID)

top

Create Sequence Number

• Physical column name: Create_Seqno
• Property Name: createSequenceNumber
• Reference: Integer

top

Create_Colspan

• Physical column name: Create_Colspan
• Property Name: createColspan
• Reference: Integer
• Default value: 1

top

Created By

• Physical column name: Createdby
• Property Name: createdBy
• Reference: Search

Foreign key column to AD_User table, (column: AD_User_ID)

top

Creation Date

• Physical column name: Created
• Property Name: creationDate
• Reference: DateTime
• Default value: SYSDATE

top

CustomersWindow_SeqNo

• Physical column name: CustomersWindow_SeqNo
• Property Name: customersWindowSeqNo
• Reference: Integer

top

Detail Sequence Number

• Physical column name: Detail_Seqno
• Property Name: detailSequenceNumber
• Reference: Integer

top

Detail_Colspan

• Physical column name: Detail_Colspan
• Property Name: detailColspan
• Reference: Integer
• Default value: 1

top

Display in Create

• Physical column name: Isdisplayedincreate
• Property Name: displayInCreate
• Reference: YesNo
• Default value: N

top

Display in Detail

• Physical column name: IsDisplayedInDetail
• Property Name: displayInDetail
• Reference: YesNo
• Default value: N

top

Display in Edit

• Physical column name: Isdisplayedinedit
• Property Name: displayInEdit
• Reference: YesNo
• Default value: N

top

Display in List

• Physical column name: IsDisplayedInList
• Property Name: displayInList
• Reference: YesNo
• Default value: N

top

Edit Sequence Number

• Physical column name: Edit_Seqno
• Property Name: editSequenceNumber
• Reference: Integer

top

Edit_Colspan

• Physical column name: Edit_Colspan
• Property Name: editColspan
• Reference: Integer
• Default value: 1

top

Editable

• Physical column name: IsEditable
• Property Name: editable
• Reference: YesNo
• Default value: Y

top

External Business Partner Integration Configuration

• Physical column name: C_Extbp_Config_ID
• Property Name: externalBusinessPartnerIntegrationConfiguration
• Reference: TableDir

• This column is a child for a business object (is Parent)

Foreign key column to C_ExtBP_Config table, (column: C_Extbp_Config_ID)

top

Identifier Sequence Number

• Physical column name: Identifier_Seqno
• Property Name: identifierSequenceNumber
• Reference: Integer

top

Identifierscanningaction

• Physical column name: Identifierscanningaction
• Property Name: identifierscanningaction
• Reference: YesNo
• Default value: N

top

IsAddressProperty

• Physical column name: IsAddressProperty
• Property Name: isAddressProperty
• Reference: YesNo
• Default value: N

top

IsDefaultAddress

• Physical column name: IsDefaultAddress
• Property Name: isDefaultAddress
• Reference: YesNo
• Default value: N

top

IsDisplayedInCustomersWindow

• Physical column name: IsDisplayedInCustomersWindow
• Property Name: isDisplayedInCustomersWindow
• Reference: YesNo
• Default value: N

top

Isbirthdaydate

• Physical column name: Isbirthdaydate
• Property Name: isbirthdaydate
• Reference: YesNo
• Default value: N

top

Isdefaultemail

• Physical column name: Isdefaultemail
• Property Name: isdefaultemail
• Reference: YesNo
• Default value: N

top

Isdefaultphone

• Physical column name: Isdefaultphone
• Property Name: isdefaultphone
• Reference: YesNo
• Default value: N

top

Key Column

• Physical column name: IsKey
• Property Name: keyColumn
• Reference: YesNo
• Default value: N

top

Key Sequence Number

• Physical column name: Key_Seqno
• Property Name: keySequenceNumber
• Reference: Integer

top

List Sequence Number

• Physical column name: List_Seqno
• Property Name: listSequenceNumber
• Reference: Integer

top

List_Colspan

• Physical column name: List_Colspan
• Property Name: listColspan
• Reference: Integer
• Default value: 1

top

Mandatory

• Physical column name: Ismandatory
• Property Name: mandatory
• Reference: YesNo
• Default value: Y

top

Message

• Physical column name: AD_Message_ID
• Property Name: message
• Reference: OBUISEL_Selector Reference

• This column is part of the table's identifier

Foreign key column to AD_Message table, (column: AD_Message_ID)

top

Organization

• Physical column name: AD_Org_ID
• Property Name: organization
• Reference: TableDir

Foreign key column to AD_Org table, (column: AD_Org_ID)

top

Reference

• Physical column name: AD_Reference
• Property Name: reference
• Reference: List

List values: CRM Connector Valid References

The allowed values for this list are:

• D (Date)
• B (Boolean)
• N (Number)
• L (Static Text)
• S (String)
• C (Combo)

top

Section

• Physical column name: Sectionmessage_ID
• Property Name: section
• Reference: OBUISEL_Selector Reference

Foreign key column to AD_Message table, (column: AD_Message_ID)

top

Section Create

• Physical column name: Sectionmessagecreate_ID
• Property Name: sectionCreate
• Reference: OBUISEL_Selector Reference

Foreign key column to AD_Message table, (column: AD_Message_ID)

top

Section Edit

• Physical column name: Sectionmessageedit_ID
• Property Name: sectionEdit
• Reference: OBUISEL_Selector Reference

Foreign key column to AD_Message table, (column: AD_Message_ID)

top

Text

• Physical column name: Text
• Property Name: text
• Reference: String

top

Translatable

• Physical column name: Istranslatable
• Property Name: translatable
• Reference: YesNo
• Default value: Y

top

Updated

• Physical column name: Updated
• Property Name: updated
• Reference: DateTime
• Default value: SYSDATE

top

Updated By

• Physical column name: Updatedby
• Property Name: updatedBy
• Reference: Search

Foreign key column to AD_User table, (column: AD_User_ID)

top

Use as Marketing Consent for Email

• Physical column name: Isemailmarketingconsent
• Property Name: useAsMarketingConsentForEmail
• Reference: YesNo
• Default value: N

top

Used as Record Identifier

• Physical column name: IsIdentifier
• Property Name: usedAsRecordIdentifier
• Reference: YesNo
• Default value: N

top

crmBusinessProperty

• Physical column name: crmBusinessProperty
• Property Name: crmBusinessProperty
• Reference: List

List values: CRM Property Type

The allowed values for this list are:

• currency (Currency)
• creditLimit (Credit Limit)
• creditUsed (Credit Used)

top

Other Info

Check Constraints

These are the check constraints for this table:

• C_BIRTHDAYDATE_CHK: ISBIRTHDAYDATE IN ('Y', 'N')
• C_DEFAULTEMAIL_CHK: ISDEFAULTEMAIL IN ('Y', 'N')
• C_DEFAULTPHONE_CHK: ISDEFAULTPHONE IN ('Y', 'N')
• C_EXTBPCONFPROP_ACTIVE_CH: ISACTIVE IN ('Y', 'N')
• C_EXTBPCONFPROP_CONSENT_CH: ISEMAILMARKETINGCONSENT IN ('Y', 'N')
• C_EXTBPCONFPROP_CUSTW_CH: ISDISPLAYEDINCUSTOMERSWINDOW IN ('Y', 'N')
• C_EXTBPCONFPROP_DISCRE_CH: ISDISPLAYEDINEDIT IN ('Y', 'N')
• C_EXTBPCONFPROP_DISDET_CH: ISDISPLAYEDINDETAIL IN ('Y', 'N')
• C_EXTBPCONFPROP_DISEDI_CH: ISDISPLAYEDINCREATE IN ('Y', 'N')
• C_EXTBPCONFPROP_DISLIST_CH: ISDISPLAYEDINLIST IN ('Y', 'N')
• C_EXTBPCONFPROP_EDITAB_CH: ISEDITABLE IN ('Y', 'N')
• C_EXTBPCONFPROP_IDENTIF_CH: ISIDENTIFIER IN ('Y', 'N')
• C_EXTBPCONFPROP_ISADDR_CH: ISADDRESSPROPERTY IN ('Y', 'N')
• C_EXTBPCONFPROP_ISDEFADDR: ISADDRESSPROPERTY = 'Y' AND (ISDEFAULTADDRESS IN ('Y', 'N')) OR ISADDRESSPROPERTY = 'N' AND ISDEFAULTADDRESS = 'N'
• C_EXTBPCONFPROP_ISKEY_CH: ISKEY IN ('Y', 'N')
• C_EXTBPCONFPROP_ISTR_CH: ISTRANSLATABLE IN ('Y', 'N')
• C_EXTBPCONFPROP_MAND_CH: ISMANDATORY IN ('Y', 'N')
• C_EXTBPCONFPROP_TRMSG_CH: ISTRANSLATABLE = 'N' OR AD_MESSAGE_ID IS NOT NULL AND ISTRANSLATABLE = 'Y'
• C_EXTBPCONFPROP_TXTMSG_CH: TEXT IS NOT NULL OR ISTRANSLATABLE = 'Y'
• C_EXTBPCP_IDTFRSCNACTION_CHK: IDENTIFIERSCANNINGACTION IN ('Y', 'N')
• C_EXTBPCP_ISCATEGORYKEY_CH: ISCATEGORYKEY IN ('Y', 'N')
• C_EXTBPCP_ISDFADR_CHK: ISDEFAULTADDRESS IN ('Y', 'N')

top

Categories: Database Entity Model | Generated Doc