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

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CREDITLINE_ID	Primary Key
I0000549	ACCOUNT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_278	SETCCURR	SETCURR	SETCCURR	Cascade
F_279	ACCOUNT_ID	ACCOUNT	ACCOUNT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	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