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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034918420 | CREDITLINE_ID | Primary Key |
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 |
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 |