The following database tables contain information related to ATG Business Commerce orders:
dbcpp_approverids
This table contains profile ids of users who have approved the order.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| VARCHAR(40) | NOT NULL |
Profile ID for an approver who approved the order. | ||
| INT | NOT NULL |
(primary key) | The sequence number of the approver ID in a list. |
dbcpp_authapprids
This table contains profile ids of users who have authorization to approver the order.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| VARCHAR(40) | NOT NULL |
Profile ID for a valid approver for an order. | ||
| INT | NOT NULL |
(primary key) | The sequence number of the approver ID in a list. |
dbcpp_apprsysmsgs
This table contains system-generated messages for order approvals.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| VARCHAR(254) | NOT NULL |
System generated message for an order requiring approval. | ||
| INT | NOT NULL |
(primary key) | The sequence number of the system message in a list. |
dbcpp_appr_msgs
This table contains user messages for order approvals.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| VARCHAR(254) | NOT NULL |
Approver message for an order, which has been approved or rejected. | ||
| INT | NOT NULL |
(primary key) | The sequence number of the approver message in a list. |
dbcpp_invoice_req
This table contains information related to the invoice request payment method.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| VARCHAR(40) | NULL |
The user-supplied purchase order number that was used to create this invoice request. | ||
| VARCHAR(40) | NULL |
The preferred format for delivery of the invoice created from this invoice request (e.g., text, HTML, XML DTD, etc.). Note: ATG Commerce does not currently use this field. The field is provided as a placeholder for applications that may wish to let the user set a preferred delivery format and then try to honor that preference when delivering an invoice. | ||
| VARCHAR(40) | NULL |
The preferred mode for delivery of the invoice created from this invoice request (e.g., postal mail, e-mail, electronic, etc.). Note: ATG Commerce does not currently use this field. The field is provided as a placeholder for applications that may wish to let the user set a preferred delivery channel and then try to honor that preference when delivering an invoice. | ||
| NUMERIC(19, 7) | NULL |
The discount percentage offered as part of the payment terms for this invoice, if the invoice is paid within | ||
| INT | NULL |
The discount days part of the payment terms – i.e., the number of days within which the invoice must be paid in order to qualify for the specified discount percentage. | ||
| INT | NULL |
The net days part of the payment terms – i.e. the number of within which the invoice must be paid in full. | ||
| TIMESTAMP | NULL |
The actual date on which payment is due. |
dbcpp_cost_center
This table contains information related to cost centers.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The repository ID of the cost center. | |
| INT | NOT NULL |
The repository type of the item. | ||
| INT | NOT NULL |
The repository version number. | ||
| VARCHAR(40) | NULL |
The mapped name of the class type of the cost center | ||
| VARCHAR(40) NULL | |
The name of the cost center. | ||
| NUMERIC(19, 7) | NULL |
The amount assigned to the cost center. | ||
| VARCHAR(40) NULL | |
The ID of the order associated with this cost center. |
dbcpp_order_cc
This table contains information about which cost centers are contained in which orders.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| VARCHAR(40) | NOT NULL |
Cost center ID of the cost center within the order. | ||
| INT | NOT NULL |
(primary key) | The sequence number of the cost center in a list. |
dbcpp_sched_clone
This table contains information related to which cloned orders are associated with scheduled orders.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| VARCHAR(40) | NOT NULL |
The order ID of the cloned order which is derived from a template order. | ||
| INTEGER | NOT NULL |
(primary key) | The sequence number of the cloned order in a list. |
dbcpp_ccitem_rel
This table contains information related to a cost center/commerce item relationship object. It ties commerce items to cost centers.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| VARCHAR(40) | NULL |
The ID of the cost center which the relationship references. | ||
| VARCHAR(40) | NULL |
The ID of the commerce item which the relationship references. | ||
| NUMERIC(19, 0) | NULL |
The quantity of commerce items which are assigned to the cost center. | ||
| NUMERIC(19, 7) | NULL |
The amount which is assigned to the cost center. |
dbcpp_ccship_rel
This table contains information related to a cost center/shipping group relationship object. It ties shipping amounts to cost centers.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| VARCHAR(40) | NULL |
The ID of the cost center which the relationship references. | ||
| VARCHAR(40) | NULL |
The ID of the shipping group which the relationship references. | ||
| NUMERIC(19, 7) | NULL |
The shipping amount which is assigned to the cost center. |
dbcpp_ccorder_rel
This table contains information related to a cost center/order relationship object. It ties order amounts to cost centers.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| VARCHAR(40) | NULL |
The ID of the cost center which the relationship references. | ||
| VARCHAR(40) | NULL |
The ID of the order which the relationship references. | ||
| NUMERIC(19, 7) | NULL |
The order amount which is assigned to the cost center. |
dbcpp_pmt_req
This table contains information related to a B2BPaymentGroup object.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| VARCHAR(40) | NULL |
A requisition number for a payment group. |