ATG Business Commerce Order Tables

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
`order_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_order(order_id)`.
`approver_ids`	VARCHAR(40)	NOT NULL
	Profile ID for an approver who approved the order.
`sequence_num`	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
`order_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_order(order_id)`.
`auth_appr_ids`	VARCHAR(40)	NOT NULL
	Profile ID for a valid approver for an order.
`sequence_num`	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
`order_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_order(order_id)`.
`appr_sys_msgs`	VARCHAR(254)	NOT NULL
	System generated message for an order requiring approval.
`sequence_num`	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
`order_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_order(order_id)`.
`approver_msgs`	VARCHAR(254)	NOT NULL
	Approver message for an order, which has been approved or rejected.
`sequence_num`	INT	NOT NULL
(primary key)	The sequence number of the approver message in a list.

dbcpp_sched_order

This table contains information related to scheduled orders.

Column	Data Type	Constraint
`scheduled_order_id`	VARCHAR(40)	NOT NULL
(primary key)	The repository ID of the scheduled order entry.
`type`	INT	NOT NULL
	The repository type of the item.
`version`	INT	NOT NULL
	The repository version number.
`name`	WVARCHAR(32)	NULL
	The user defined name of a scheduled order.
`profile_id`	VARCHAR(40)	NULL
	The profile ID of the owner of a scheduled order.
`create_date`	TIMESTAMP	NULL
	The creation date of the scheduled order.
`start_date`	TIMESTAMP	NULL
	The date that the scheduled order is to begin submission.
`end_date`	TIMESTAMP	NULL
	The date that the scheduled order is to terminate submission.
`template_order`	VARCHAR(32)	NULL
	The order ID of the template order.
`state`	INT	NULL
	The state of the scheduled order.
`next_scheduled`	TIMESTAMP	NULL
	The time of the next scheduled submission.
`schedule`	VARCHAR(32)	NULL
	The schedule of when the order is to be submitted.

dbcpp_invoice_req

This table contains information related to the invoice request payment method.

Column	Data Type	Constraint
`payment_group_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_pay_group(payment_group_id)`
`po_number`	VARCHAR(40)	NULL
	The user-supplied purchase order number that was used to create this invoice request.
`pref_format`	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.
`pref_delivery`	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.
`disc_percent`	NUMERIC(19, 7)	NULL
	The discount percentage offered as part of the payment terms for this invoice, if the invoice is paid within `disc_days`. This is part of the conventional representation of payment terms, which consists of discount percentage, discount days, and net days. For example, payment terms of 2/10/net 30 means that a 2% discount is offered if payment is made within 10 days, but payment in full must be received within 30 days.
`disc_days`	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.
`net_days`	INT	NULL
	The net days part of the payment terms – i.e. the number of within which the invoice must be paid in full.
`pmt_due_date`	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
`cost_center_id`	VARCHAR(40)	NOT NULL
(primary key)	The repository ID of the cost center.
`type`	INT	NOT NULL
	The repository type of the item.
`version`	INT	NOT NULL
	The repository version number.
`costctr_class_type`	VARCHAR(40)	NULL
	The mapped name of the class type of the cost center
`identifier`	VARCHAR(40) NULL
	The name of the cost center.
`amount`	NUMERIC(19, 7)	NULL
	The amount assigned to the cost center.
`order_ref`	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
`order_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_order(order_id)`.
`cost_centers`	VARCHAR(40)	NOT NULL
	Cost center ID of the cost center within the order.
`sequence_num`	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
`scheduled_order_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dbcpp_sched_order(scheduled_order_id)`.
`cloned_order`	VARCHAR(40)	NOT NULL
	The order ID of the cloned order which is derived from a template order.
`sequence_num`	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
`relationship_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_relationship(relationship_id)`.
`cost_center_id`	VARCHAR(40)	NULL
	The ID of the cost center which the relationship references.
`commerce_item_id`	VARCHAR(40)	NULL
	The ID of the commerce item which the relationship references.
`Quantity`	NUMERIC(19, 0)	NULL
	The quantity of commerce items which are assigned to the cost center.
`Amount`	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
`relationship_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_relationship(relationship_id)`.
`Cost_center_id`	VARCHAR(40)	NULL
	The ID of the cost center which the relationship references.
`shipping_group_id`	VARCHAR(40)	NULL
	The ID of the shipping group which the relationship references.
`Amount`	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
`relationship_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_relationship(relationship_id)`.
`Cost_center_id`	VARCHAR(40)	NULL
	The ID of the cost center which the relationship references.
`order_id`	VARCHAR(40)	NULL
	The ID of the order which the relationship references.
`amount`	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
`payment_group_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcspp_pay_group(payment_group_id)`.
`req_number`	VARCHAR(40)	NULL
	A requisition number for a payment group.

ATG Commerce Programming Guide