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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031218810 CREDITLINE_ID Primary Key
I0000549 ACCOUNT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_279 ACCOUNT_ID ACCOUNT ACCOUNT_ID Cascade
F_278 SETCCURR SETCURR SETCCURR Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)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

Feedback