Database Table: ACCOUNT

Column Name Column Type Column Description
ACCOUNT_ID BIGINT
NOT NULL
This column contains the primary key: Account ID. Foreign key to the TRADING table.
COMMENTS VARCHAR (4000)
NULL
This column contains a comment for the business account.
CURRENCY CHARACTER (3)
NULL
Reserved for IBM internal use.
DEFAULTCONTRACT INTEGER
NOT NULL, DEFAULT 0
Indicates if purchases using Store default contract is allowed: 0 = Not allowed; 1 = Allowed.
MARKFORDELETE INTEGER
NOT NULL, DEFAULT 0
Indicates if a business account is marked for deletion: 0 = No; 1 = Marked for delete.
MEMBER_ID BIGINT
NOT NULL
The owner of the Account. Foreign key to the MEMBER table.
NAME VARCHAR (200)
NOT NULL
Account name for the business account.
STATE INTEGER
NOT NULL, DEFAULT 0
State of the Account. Only the following states are used:
0 - Initial;
3 - Active;
6 - Closed.
STORE_ID INTEGER
NULL
Store in which Account is first created.
TIMEACTIVATED TIMESTAMP
NULL
Time Account is activated.
TIMEAPPROVED TIMESTAMP
NULL
Reserved for IBM internal use.
TIMECREATED TIMESTAMP
NULL
Time Account is created.
TIMEUPDATED TIMESTAMP
NULL
Time Account is updated.
Indexes:
Index Name Indexed Column Names Index Type
I0000005 NAME, MEMBER_ID Unique Index
SQL030416034827380 ACCOUNT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint 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