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