The following tables contain information about specific extensions for Oracle ATG Web 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique repository ID that identifies a cost center. | |
| WVARCHAR(40) | NOT NULL |
A string identifier code that is used by a business for accounting purposes. | ||
| VARCHAR(254) | NULL |
A string description of the cost center. This description is for UI purposes to identify the cost center. | ||
| VARCHAR(40) | NULL |
The ID of a user associated with the cost center. |
dbc_user
The dbc_user
table provides additional user properties for commerce applications.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| 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. | ||
| VARCHAR(40) | NULL |
The repository ID of a catalog. | ||
| VARCHAR(40) | NULL |
The repository ID of a contact info item. This will become the users business address. References | ||
| VARCHAR(40) | NULL |
The repository ID of a contact info item. This will becomes the users default shipping address. References | ||
| VARCHAR(40) | NULL |
The repository ID of a contact info item. This will become the users default billing address. References | ||
| VARCHAR(40) | NULL |
The repository ID of a credit card item. This will become the users default credit card. References | ||
| VARCHAR(40) | NULL |
The repository ID of a cost center. This will become the users default cost center. References | ||
| NUMERIC(19, 7) | NULL |
The greatest amount that the user is able to purchase before triggering an approval condition. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The repository ID of a user. | |
| VARCHAR(42) | NOT NULL |
(primary key) | The sequence in a list that contains the cost center. | |
| VARCHAR(40) | NOT NULL |
The repository ID of a cost center item. References |
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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The repository ID of a user. References | |
| VARCHAR(40) | NOT NULL |
The repository ID of a user who should act as an approver for the user identified by the | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The repository ID of a user. References | |
| VARCHAR(42) | NOT NULL |
(primary key) | A key that identifies the associated credit card. | |
| VARCHAR(40) | NOT NULL |
The repository ID of a credit card. References |
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 |
| VARCHAR(40) | NOT NULL |
(primary key) | The repository ID of a user. References | |
| VARCHAR(42) | NOT NULL |
(primary key) | A key to identify the associated address. | |
| VARCHAR(40) | NOT NULL |
A repository ID of a contact info item. This item becomes a shipping address for the user. References |
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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The repository ID of a user. References | |
| VARCHAR(42) | NOT NULL |
(primary key) | A key by which the associated address will be identified by | |
| VARCHAR(40) | NOT NULL |
The repository ID of a contact info item. This will become a billing address. References |
dbc_buyer_prefvndr
The dbc_buyer_prefvndr
table contains information that associates a buyer with one or more preferred vendors.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The repository ID of a user References | |
| WVARCHAR(100) | NOT NULL |
A text name for a vendor. | ||
| 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 |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The repository ID of a user. | |
| VARCHAR(40) | NOT NULL |
The repository ID of a purchase list. | ||
| VARCHAR(40) | NOT NULL |
(primary key) | A key which is used to identify the associated purchase list. |