WebSphere Commerce database table: 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 Description(s):
Column NameColumn TypeDescription
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 IBM 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 IBM internal use.
TIMEACTIVATED TIMESTAMP Time Account is activated.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000005 NAME+MEMBER_ID Unique Index
SQL050212031153030 ACCOUNT_ID Primary Key
I0000434 MEMBER_ID Non-Unique Index
I0000435 STORE_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_24 MEMBER_ID MEMBER MEMBER_ID Cascade
F_23 STORE_ID STORE STORE_ID Cascade
F_22 ACCOUNT_ID TRADING TRADING_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_137 ACCOUNT_ID BUYERPO ACCOUNT_ID Cascade
F_968 ACCOUNT_ID COLLABWS 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 TRADING_ID REFUNDMTHD ACCOUNT_ID Cascade

Feedback