The following database tables contain information related to Oracle ATG Web Commerce organizational roles:
dbc_organization
The dbc_organization table contains information related to the basic model for organizational hierarchies. It layers properties onto the organization model that describe a business organization.
Column | Data Type | Constraint |
|---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique repository ID of the organization. References | |
| INT | NULL |
An enumerated property of the type of organization this organization represents. Department, company, division etc. | ||
| INT | NULL |
An enumerated property that indicates the status level of this company. Preferred, Enterprise or Standard. | ||
| VARCHAR(20) | NULL |
The company’s Dun and Bradstreet number. | ||
| VARCHAR(40) | NULL |
A default shipping address for this organization. References | ||
| VARCHAR(40) | NULL |
A default billing address for this organization. References | ||
| VARCHAR(40) | NULL |
A default credit card for this organization. References | ||
| VARCHAR(40) | NULL |
A default cost center for this organization. | ||
| NUMERIC(19, 7) | NULL |
The order limit for this organization. An order limit is used to trigger an approval condition. | ||
| VARCHAR(40) | NULL |
A contract that this organization has negotiated with the site owning organization. References | ||
| TINYINT | NULL |
Indicates whether approval is required for members of this organization. | ||
dbc_org_contact
The dbc_org_contact table contains information that associates an Organization with one or more contacts.
Column | Data Type | Constraint |
|---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique repository ID of the organization. References | |
| VARCHAR(40) | NOT NULL |
An individual that acts as the point contact for this organization. References | ||
| INT | NOT NULL |
(primary key) | Indicates the contact’s sequence in the list. | |
dbc_org_admin
The dbc_org_admin table contains information that associates an Organization with one or more administrators. Unlike contacts, administrators are required to be registered users of the site, since they can create, modify, and delete buyer accounts, organizational profile elements, etc.
Column | Data Type | Constraint |
|---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique repository ID of the organization. References | |
| VARCHAR(40) | NOT NULL |
The repository ID of the person is an administrator for the associated Organization. References | ||
| INT | NOT NULL |
(primary key) | The sequence in the list where the admin is located. | |
dbc_org_approver
The dbc_org_approver table contains information that associates an Organization with one or more order approvers. Similar to administrators, approvers are required to be registered users of the site so they can perform online approvals.
Column | Data Type | Constraint |
|---|---|---|
Column | Data Type | Constraint |
| VARCHAR(40) | NOT NULL |
(primary key) | The unique repository ID of the organization. References | |
| VARCHAR(40) | NOT NULL |
The repository ID of an individual who acts as an approver for the associated organization. References | ||
| INT | NOT NULL |
(primary key) | Indicates the approver’s sequence in the list. | |
dbc_org_costctr
The dbc_org_costctr table contains information that associates an Organization with one or more cost centers that are pre-approved for use by members of the organization.
Column | Data Type | Constraint |
|---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique repository ID of the organization. References | |
| VARCHAR(40) | NOT NULL |
The repository ID of a cost center that is associated with the organization. | ||
| VARCHAR(40) | NOT NULL |
(primary key) | Indicates the cost center’s sequence in the list. | |
dbc_org_payment
The dbc_org_payment table contains information that associates an Organization with one or more payment types that are pre-approved for use by members of the organization. For now, a payment type is always a credit card.
Column | Data Type | Constraint |
|---|---|---|
Column | Data Type | Constraint |
| VARCHAR(40) | NOT NULL |
(primary key) | The unique repository ID of the organization. References | |
| VARCHAR(42) | NOT NULL, |
(primary key) | A key by which the associated credit card will be known as. This value acts as a key into a map. | |
| VARCHAR(40) | NOT NULL |
The repository ID of a credit card. References | ||
dbc_org_shipping
The dbc_org_shipping table contains information that associates an Organization with one or more pre-approved shipping addresses
Column | Data Type | Constraint |
|---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique repository ID of an organization. References | |
| VARCHAR(42) | NOT NULL |
(primary key) | A key by which the associated shipping address will be known as. This value acts as a key into a map. | |
| VARCHAR(40) | NOT NULL |
The repository ID of a contact info. This becomes a shipping address. References | ||
dbc_org_billing
The dbc_org_billing table contains information that associates an Organization with one or more pre-approved billing addresses.
Column | Data Type | Constraint |
|---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique repository ID of an organization. References | |
| VARCHAR(42) | NOT NULL, |
(primary key) | A key by which the associated billing address will be known as. This value acts as a key into a map. | |
| VARCHAR(40) | NOT NULL |
The repository ID of a contact info. This becomes a billing address. References | ||
dbc_org_prefvndr
The dbc_org_prefvndr table contains information that associates an Organization with one or more preferred vendors.
Column | Data Type | Constraint |
|---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique repository ID of an organization. References | |
| WVARCHAR(100) | NOT NULL |
A string name that identifies a vendor. | ||
| INT | NOT NULL |
(primary key) | Indicates the vendors sequence in the list. | |
dbc_org_plist
The dbc_org_plist table contains information that associates an Organization with one or more standard purchase lists for buyers from that organization.
Column | Data Type | Constraint |
|---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique repository ID of an organization. | |
| VARCHAR(40) | NOT NULL |
The repository ID of a purchase list. | ||
| VARCHAR(40) | NOT NULL |
(primary key) | A key that is used to identify the associated purchase list. | |
