Reference > Database > WebSphere Commerce database tables > A


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 Name Column 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 IBM internal use.
DEFAULTCONTRACT INTEGER NOT NULL DEFAULT 0 Indicates if purchases using Store default contract is allowed. Valid values are...

  • 0=Not allowed

  • 1=Allowed

MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Indicates if a business account is marked for deletion. Valid values are...

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

Indexes
Index Name Indexed Column Names Index Type
I0000005 NAME+MEMBER_ID Unique Index
SQL100520030251990 ACCOUNT_ID Primary Key
I0000434 MEMBER_ID Non-Unique Index
I0000435 STORE_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names 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 Name Referenced Column Name Foreign Table Name Foreign Column Names 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


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search