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:

NameTypeDescription
ACCOUNT_IDBIGINT NOT NULLThis column contains the primary key: Account ID. Foreign key to the TRADING table.
NAMEVARCHAR (200) NOT NULLAccount name for the business account.
MEMBER_IDBIGINT NOT NULLThe owner of the Account. Foreign key to the MEMBER table.
STORE_IDINTEGERStore in which Account is first created.
STATEINTEGER NOT NULL DEFAULT 0State of the Account. Only the following states are used:
  • 0=Initial
  • 3=Active
  • 6=Closed
CURRENCYCHAR (3)Reserved for IBM internal use.
DEFAULTCONTRACTINTEGER NOT NULL DEFAULT 0Indicates if purchases using Store default contract is allowed. Valid values are as follows:
  • 0=Not allowed
  • 1=Allowed
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if a business account is marked for deletion. Valid values are as follows:
  • 0=Not marked for deletion
  • 1=Marked for deletion
COMMENTSVARCHAR (4000)A comment for the business account.
TIMECREATEDTIMESTAMPTime Account is created.
TIMEUPDATEDTIMESTAMPTime Account is updated.
TIMEAPPROVEDTIMESTAMPReserved for IBM internal use.
TIMEACTIVATEDTIMESTAMPTime Account is activated.
PRCPLCYPREFVARCHAR (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.
USEPRCPLCYPREFSMALLINTSpecifies 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_NAMEVARCHAR (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.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ACCOUNT_IDPrimary Key
I0000005NAME+MEMBER_IDUnique Index
I0000434MEMBER_IDNon-Unique Index
I0000435STORE_IDNon-Unique Index
IPF00027UP_NAMENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_22ACCOUNT_IDTRADINGTRADING_IDCascade
F_23STORE_IDSTORESTORE_IDCascade
F_24MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_137ACCOUNT_IDBUYERPOACCOUNT_IDCascade
F_279ACCOUNT_IDCREDITLINEACCOUNT_IDCascade
F_541ACCOUNT_IDORDPAYMTHDACCOUNT_IDCascade
F_585ACCOUNT_IDPAYSUMMARYACCOUNT_IDCascade
F_671ACCOUNT_IDREFUNDMTHDTRADING_IDCascade
F_968ACCOUNT_IDCOLLABWSACCOUNT_IDCascade