id
(primary key)

varchar(40)

not null

The unique repository ID that identifies a cost center.

identifier

wvarchar(40)

not null

A string identifier code that is used by a business for accounting purposes.

Description

varchar(254)

null

A string description of the cost center. This description is for UI purposes to identify the cost center.

user_id

varchar(40)

null

The ID of a user associated with the cost center.

id
(primary key)

varchar(40)

not null

References dps_user(id). The unique repository ID that identifies a user.

price_list

varchar(40)

null

The repository ID of a price list. This price list is then used to retrieve pricing information from that is specific to the user.

user_catalog

varchar(40)

null

The repository ID of a catalog.

business_addr

varchar(40)

null

The repository ID of a contact info item. This will become the users business address. References dps_contact_info(id).

dflt_shipping_addr

varchar(40)

null

The repository ID of a contact info item. This will becomes the users default shipping address. References dps_contact_info(id).

dflt_billing_addr

varchar(40)

null

The repository ID of a contact info item. This will become the users default billing address. References dps_contact_info(id).

dflt_payment_type

varchar(40)

null

The repository ID of a credit card item. This will become the users default credit card. References dps_credit_card(id).

dflt_cost_center

varchar(40)

null

The repository ID of a cost center. This will become the users default cost center. References dbc_cost_center(id).

order_price_limit

numeric(19, 7)

null

The greatest amount that the user is able to purchase before triggering an approval condition.

approval_required

tinyint

null

A flag indicating whether or not the user should be checked to see if they triggered an approval condition.

user_id
(primary key)

varchar(40)

not null

The repository ID of a user.

Seq
(primary key)

varchar(42)

not null

The sequence in a list that contains the cost center.

cost_center_id

varchar(40)

not null

The repository ID of a cost center item. References dbc_cost_center(id).

user_id
(primary key)

varchar(40)

not null

The repository ID of a user. References dps_user(id).

approver_id

varchar(40)

not null

The repository ID of a user who should act as an approver for the user identified by the user_id column. References dps_user(id).

Seq
(primary key)

int

not null

Indicates the approver’s sequence in the list.

user_id
(primary key)

varchar(40)

not null

The repository ID of a user. References dps_user(id).

Tag
(primary key)

varchar(42)

not null

A key that identifies the associated credit card.

payment_id

varchar(40)

not null

The repository ID of a credit card. References dps_credit_card(id).

user_id
(primary key)

varchar(40)

not null

The repository ID of a user. References dps_user(id).

Tag
(primary key)

varchar(42)

not null

A key to identify the associated address.

addr_id

varchar(40)

not null

A repository ID of a contact info item. This item becomes a shipping address for the user. References dps_contact_info(id).

user_id
(primary key)

varchar(40)

not null

The repository ID of a user. References dps_user(id).

Tag
(primary key)

varchar(42)

not null

A key by which the associated address will be identified by

addr_id

varchar(40)

not null

The repository ID of a contact info item. This will become a billing address. References dps_contact_info(id).

user_id
(primary key)

varchar(40)

not null

The repository ID of a user References dps_user(id).

Vendor

wvarchar(100)

not null

A text name for a vendor.

Seq
(primary key)

int

not null

The sequence in a list that contains the vendor.

user_id
(primary key)

varchar(40)

not null

The repository ID of a user.

list_id

varchar(40)

not null

The repository ID of a purchase list.

Tag
(primary key)

varchar(40)

not null

A key which is used to identify the associated purchase list.