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