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 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 as follows:
|
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 Name | Indexed Column Names | Index 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 Name | Column Name(s) | Foreign Table Name | Foreign 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 Name | Referenced Column Name | Foreign Table Name | Foreign 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 |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.