The following tables contain information about specific extensions for ATG Business Commerce user profiles:

dbc_cost_center

The dbc_cost_center table contains information related to a cost center. Cost centers are used by an organization for accounting purposes. These cost centers will be associated with either an organization or a user.

Column

Data Type

Constraint

id

VARCHAR(40)

NOT NULL

(primary key)

The unique repository ID that identifies a cost center.

identifier

WVARCHAR(40)

NOT NULL

A string identifier code that is used by a business for accounting purposes.

Description

VARCHAR(254)

NULL

A string description of the cost center. This description is for UI purposes to identify the cost center.

user_id

VARCHAR(40)

NULL

The ID of a user associated with the cost center.

dbc_user

The dbc_user table layers properties on to the definition of a user that are useful in a business commerce application.

Column

Data Type

Constraint

id

VARCHAR(40)

NOT NULL

(primary key)

References dps_user(id). The unique repository ID that identifies a user.

price_list

VARCHAR(40)

NULL

The repository ID of a price list. This price list is then used to retrieve pricing information from that is specific to the user.

user_catalog

VARCHAR(40)

NULL

The repository ID of a custom catalog.

business_addr

VARCHAR(40)

NULL

The repository ID of a contact info item. This will become the users business address. References dps_contact_info(id).

dflt_shipping_addr

VARCHAR(40)

NULL

The repository ID of a contact info item. This will becomes the users default shipping address. References dps_contact_info(id).

dflt_billing_addr

VARCHAR(40)

NULL

The repository ID of a contact info item. This will become the users default billing address. References dps_contact_info(id).

dflt_payment_type

VARCHAR(40)

NULL

The repository ID of a credit card item. This will become the users default credit card. References dps_credit_card(id).

dflt_cost_center

VARCHAR(40)

NULL

The repository ID of a cost center. This will become the users default cost center. References dbc_cost_center(id).

order_price_limit

NUMERIC(19, 7)

NULL

The greatest amount that the user is able to purchase before triggering an approval condition.

approval_required

TINYINT

NULL

A flag indicating whether or not the user should be checked to see if they triggered an approval condition.

dbc_buyer_costctr

The dbc_buyer_costctr table is used to associate many cost centers to a user.

Column

Data Type

Constraint

user_id

VARCHAR(40)

NOT NULL

(primary key)

The repository ID of a user.

Seq

VARCHAR(42)

NOT NULL

(primary key)

The sequence in a list that contains the cost center.

cost_center_id

VARCHAR(40)

NOT NULL

The repository ID of a cost center item. References dbc_cost_center(id).

dbc_buyer_approver

The dbc_buyer_approver table contains information that associates a buyer with one or more order approvers. Approvers must be registered users so they can perform online approvals.

Column

Data Type

Constraint

user_id

VARCHAR(40)

NOT NULL

(primary key)

The repository ID of a user. References dps_user(id)

approver_id

VARCHAR(40)

NOT NULL

The repository ID of a user who should act as an approver for the user identified by the user_id column. References dps_user(id).

Seq

INT

NOT NULL

(primary key)

Indicates the approver’s sequence in the list.

dbc_buyer_payment

The dbc_buyer_payment table contains information that associates a buyer with one or more pre-approved payment types. A payment type is a credit card.

Column

Data Type

Constraint

user_id

VARCHAR(40)

NOT NULL

(primary key)

The repository ID of a user. References dps_user(id).

Tag

VARCHAR(42)

NOT NULL

(primary key)

A key that identifies the associated credit card.

payment_id

VARCHAR(40)

NOT NULL

The repository ID of a credit card. References dps_credit_card(id).

dbc_buyer_shipping

The dbc_buyer_shipping table contains information that associates a buyer with one or more pre-approved shipping addresses.

Column

Data Type

Constraint

Column

Data Type

Constraint

user_id

VARCHAR(40)

NOT NULL

(primary key)

The repository ID of a user. References dps_user(id).

Tag

VARCHAR(42)

NOT NULL

(primary key)

A key to identify the associated address.

addr_id

VARCHAR(40)

NOT NULL

A repository ID of a contact info item. This item becomes a shipping address for the user. References dps_contact_info(id).

dbc_buyer_billing

The dbc_buyer_billing table contains information that associates a buyer with one or more pre-approved billing addresses.

Column

Data Type

Constraint

user_id

VARCHAR(40)

NOT NULL

(primary key)

The repository ID of a user. References dps_user(id).

Tag

VARCHAR(42)

NOT NULL

(primary key)

A key by which the associated address will be identified by

addr_id

VARCHAR(40)

NOT NULL

The repository ID of a contact info item. This will become a billing address. References dps_contact_info(id).

dbc_buyer_prefvndr

The dbc_buyer_prefvndr table contains information that associates a buyer with one or more preferred vendors.

Column

Data Type

Constraint

user_id

VARCHAR(40)

NOT NULL

(primary key)

The repository ID of a user References dps_user(id).

Vendor

WVARCHAR(100)

NOT NULL

A text name for a vendor.

Seq

INT

NOT NULL

(primary key)

The sequence in a list that contains the vendor.

dbc_buyer_plist

The dbc_buyer_plist table contains information that associates a buyer with one or more standard purchase lists.

Column

Data Type

Constraint

user_id

VARCHAR(40)

NOT NULL

(primary key)

The repository ID of a user.

list_id

VARCHAR(40)

NOT NULL

The repository ID of a purchase list.

Tag

VARCHAR(40)

NOT NULL

(primary key)

A key which is used to identify the associated purchase list.

 
loading table of contents...