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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031218810 | CREDITLINE_ID | Primary Key |
I0000549 | ACCOUNT_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_279 | ACCOUNT_ID | ACCOUNT | ACCOUNT_ID | Cascade |
F_278 | SETCCURR | SETCURR | SETCCURR | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign 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 |