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 Column Description
ACCOUNT_ID BIGINT
NULL
The ID of the business account to which the credit line belongs. Foreign key to the ACCOUNT table.
CREDITLIMIT DECIMAL (20,5)
NULL
Reserved for IBM internal use.
CREDITLINE_ID BIGINT
NOT NULL
Generated unique key for this row.
DECIMALFIELD1 DECIMAL (20,5)
NULL
Customizable.
DECIMALFIELD2 DECIMAL (20,5)
NULL
Customizable.
SETCCURR CHARACTER (3)
NULL
Currency of the credit limit if specified. (This is a currency code as per ISO 4217 standards.)
STATE INTEGER
NULL, DEFAULT 0
State of the CreditLine:
0 = unknown
1 = active - available for ordering
2 = closed or suspended - not available for ordering
TIMECREATED TIMESTAMP
NULL
Time credit line is created.
TIMEUPDATED TIMESTAMP
NULL
Time credit line is updated.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034918420 CREDITLINE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_278 SETCCURR SETCURR SETCCURR Cascade
F_279 ACCOUNT_ID ACCOUNT ACCOUNT_ID 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