MERCH_ACCT_DTL

(SQL Table)
Index Back

Merchant Account Detail

Defines a set of merchant account relationships between the merchant account name and the association with either business unit, regulatory region, company, department or all.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MERCHANTID Character(30) VARCHAR2(30) NOT NULL Merchant ID

Prompt Table: PSMERCHANTID

2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 MERCHANT_ACCT_NAME Character(30) VARCHAR2(30) NOT NULL Merchant account name.

Prompt Table: MERCHANT_ACCT

4 MERCHANT_ACCT_KEY Character(6) VARCHAR2(6) NOT NULL Merchant account detail value.

Prompt Table: %RECNAME_EDIT