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


Related reference
Contract data model
Order trading agreement data model