contract_id
(primary key)

varchar(40)

not null

The unique identifier associated with the price list.

display_name

wvarchar(254)

null

The name of this contract.

creation_date

timestamp

null

The date that this contract was created.

start_date

timestamp

null,

The date that this contract becomes active.

end_date

timestamp

null,

The date that this contract is no longer active.

creator_id

varchar(40)

null

The user ID of the creator of this contract.

negotiator_info

wvarchar(40)

null

The ID of the contact_info for the negotiator of this contract.

price_list_id

varchar(40)

null

The ID of the price list that users of this contract will use.

catalog_id

varchar(40)

null

The ID of the catalog that users of this contract will use.

term_id

varchar(40)

null

The ID of the contract terms that apply.

comments

wvarchar(254)

null

A free form comment field.

terms_id
(primary key)

varchar(40)

not null

The unique identifier associated with the price list.

terms

long varchar

null

A text field for describing any terms.

disc_percent

numeric(19, 7)

null

The default discount percent for invoices.

disc_days

int

null

The default discount days for invoices.

net_days

int

null

The default net days for invoices.