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:

NameTypeDescription
CREDITLINE_IDBIGINT NOT NULLGenerated unique key for this row.
SETCCURRCHAR (3)Currency of the credit limit if specified. (This is a currency code as per ISO 4217 standards.)
ACCOUNT_IDBIGINTThe ID of the business account to which the credit line belongs. Foreign key to the ACCOUNT table.
STATEINTEGER DEFAULT 0State of the CreditLine: 0 = unknown 1 = active - available for ordering 2 = closed or suspended - not available for ordering
TIMECREATEDTIMESTAMPTime credit line is created.
TIMEUPDATEDTIMESTAMPTime credit line is updated.
CREDITLIMITDECIMAL (20,5)Reserved for HCL internal use.
DECIMALFIELD1DECIMAL (20,5)Customizable.
DECIMALFIELD2DECIMAL (20,5)Customizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CREDITLINE_IDPrimary Key
I0000549ACCOUNT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_278SETCCURRSETCURRSETCCURRCascade
F_279ACCOUNT_IDACCOUNTACCOUNT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_540CREDITLINE_IDORDPAYMTHDCREDITLINE_IDCascade
F_582CREDITLINE_IDPAYSUMMARYCREDITLINE_IDCascade
F_670CREDITLINE_IDREFUNDMTHDCREDITLINE_IDCascade