MERCHANTIDPrompt Table: MERCH_ACCT_TYPE
EFFDTDefault Value: %date
MERCHANT_ACCT_NAMEPrompt Table: PSURLDEFN
MERCHANT_ACCT(SQL Table) |
Index Back |
|---|---|
Merchant Account Set-UpStores information about accounts that are tied to merchants. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MERCHANTID |
Character(30) | VARCHAR2(30) NOT NULL |
Merchant ID
Prompt Table: MERCH_ACCT_TYPE |
| 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. |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | CMPAUTHNTCTNTOKEN | Character(64) | VARCHAR2(64) NOT NULL | Company Authentication Token |
| 6 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL |
URL Identifier (see PSURLDEFN).
Prompt Table: PSURLDEFN |