The following tables contain information related to Oracle ATG Web Commerce contract functionality.
dbc_contract
The following table contains information related to contract functionality.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the price list. | |
| WVARCHAR(254) | NULL |
The name of this contract. | ||
| TIMESTAMP | NULL |
The date that this contract was created. | ||
| TIMESTAMP | NULL, |
The date that this contract becomes active. | ||
| TIMESTAMP | NULL, |
The date that this contract is no longer active. | ||
| VARCHAR(40) | NULL |
The user id of the creator of this contract. | ||
| WVARCHAR(40) | NULL |
The id of the | ||
| VARCHAR(40) | NULL |
The id of the price list that users of this contract will use. | ||
| VARCHAR(40) | NULL |
The id of the catalog that users of this contract will use. | ||
| VARCHAR(40) | NULL |
The id of the contract terms that apply. | ||
| WVARCHAR(254) | NULL |
A free form comment field. |
dbc_contract_term
The following table contains information related to contract terms.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the price list. | |
| LONG VARCHAR | NULL |
A text field for describing any terms. | ||
| NUMERIC(19, 7) | NULL |
The default discount percent for invoices. | ||
| INT | NULL |
The default discount days for invoices. | ||
| INT | NULL |
The default net days for invoices. |