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 Descriptions
| 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.
|