ACCOUNT

Each row of this table represents a business account between a Buyer organization and a Seller organization. A business account can be used to organize various trading agreements, and to specify special trading terms and conditions.

Column Descriptions:

Name	Type	Description
ACCOUNT_ID	BIGINT NOT NULL	This column contains the primary key: Account ID. Foreign key to the TRADING table.
NAME	VARCHAR (200) NOT NULL	Account name for the business account.
MEMBER_ID	BIGINT NOT NULL	The owner of the Account. Foreign key to the MEMBER table.
STORE_ID	INTEGER	Store in which Account is first created.
STATE	INTEGER NOT NULL DEFAULT 0	State of the Account. Only the following states are used: 0=Initial 3=Active 6=Closed
CURRENCY	CHAR (3)	Reserved for HCL internal use.
DEFAULTCONTRACT	INTEGER NOT NULL DEFAULT 0	Indicates if purchases using Store default contract is allowed. Valid values are as follows: 0=Not allowed 1=Allowed
MARKFORDELETE	INTEGER NOT NULL DEFAULT 0	Indicates if a business account is marked for deletion. Valid values are as follows: 0=Not marked for deletion 1=Marked for deletion
COMMENTS	VARCHAR (4000)	A comment for the business account.
TIMECREATED	TIMESTAMP	Time Account is created.
TIMEUPDATED	TIMESTAMP	Time Account is updated.
TIMEAPPROVED	TIMESTAMP	Reserved for HCL internal use.
TIMEACTIVATED	TIMESTAMP	Time Account is activated.
PRCPLCYPREF	VARCHAR (32)	The preferred price list type for the contracts under this account. This value must match the value specified in the PROPERTIES column of the POLICY table. Possible default values include either List or Cost. This is extensible by updating the bootstrap data.
USEPRCPLCYPREF	SMALLINT	Specifies whether or not contracts under this account override the preferred price list. Possible values include: 0 - Contracts under this account can override the preferred price list. 1 - Contracts under this account cannot override the preferred price list.
UP_NAME	VARCHAR (200)	The equivalent value of the NAME column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based searches issued from Management Center.
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>	ACCOUNT_ID	Primary Key
I0000005	NAME+MEMBER_ID	Unique Index
I0000434	MEMBER_ID	Non-Unique Index
I0000435	STORE_ID	Non-Unique Index
IPF00027	UP_NAME	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_22	ACCOUNT_ID	TRADING	TRADING_ID	Cascade
F_23	STORE_ID	STORE	STORE_ID	Cascade
F_24	MEMBER_ID	MEMBER	MEMBER_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_137	ACCOUNT_ID	BUYERPO	ACCOUNT_ID	Cascade
F_279	ACCOUNT_ID	CREDITLINE	ACCOUNT_ID	Cascade
F_541	ACCOUNT_ID	ORDPAYMTHD	ACCOUNT_ID	Cascade
F_585	ACCOUNT_ID	PAYSUMMARY	ACCOUNT_ID	Cascade
F_671	ACCOUNT_ID	REFUNDMTHD	TRADING_ID	Cascade
F_968	ACCOUNT_ID	COLLABWS	ACCOUNT_ID	Cascade