COUNTRYDefault Value: ALL
Prompt Table: GP_COUNTRY
N=Customer Data
S=Sample Data
Y=System Data
GP_MPSLP_SQL(SQL Table) |
Index Back |
|---|---|
Mobile ePay SQLThis record contains the CE specific Payslip messages SQL definitions. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: ALL Prompt Table: GP_COUNTRY |
| 2 | GPCESQLID | Character(30) | VARCHAR2(30) NOT NULL | SQL Definition ID |
| 3 | GPCESQLIDLNG | Character(30) | VARCHAR2(30) NOT NULL | SQL Definition Language ID |
| 4 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data |