Reference > Database > WebSphere Commerce database tables > C

WebSphere Commerce database table: CREDITLINE

Each row of this table represents a credit line the account holder (buyer organization) has with the seller organization. This credit line is associated with a specific business account.

Column Name	Column Type	Description
CREDITLINE_ID	BIGINT NOT NULL	Generated unique key for this row.
SETCCURR	CHAR(3)	Currency of the credit limit if specified. (This is a currency code as per ISO 4217 standards.)
ACCOUNT_ID	BIGINT	The ID of the business account to which the credit line belongs. Foreign key to the ACCOUNT table.
STATE	INTEGER DEFAULT 0	State of the CreditLine: 0 = unknown 1 = active - available for ordering 2 = closed or suspended - not available for ordering
TIMECREATED	TIMESTAMP	Time credit line is created.
TIMEUPDATED	TIMESTAMP	Time credit line is updated.
CREDITLIMIT	DECIMAL (20,5)	Reserved for IBM internal use.
DECIMALFIELD1	DECIMAL (20,5)	Customizable.
DECIMALFIELD2	DECIMAL (20,5)	Customizable.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL100520030322060	CREDITLINE_ID	Primary Key
I0000549	ACCOUNT_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_279	ACCOUNT_ID	ACCOUNT	ACCOUNT_ID	Cascade
F_278	SETCCURR	SETCURR	SETCCURR	Cascade

Referenced By

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_540	CREDITLINE_ID	ORDPAYMTHD	CREDITLINE_ID	Cascade
F_582	CREDITLINE_ID	PAYSUMMARY	CREDITLINE_ID	Cascade
F_670	CREDITLINE_ID	REFUNDMTHD	CREDITLINE_ID	Cascade

Related reference

• Payment summary data model

• Payment data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search