GP_PKG_IDCOUNTRYGP_TX_TYPEA=Advance
M=Manual Payment
R=Correction
U=Additional Payment
GP_TX_REASONLANGUAGE_CDGP_OC_SU_U_LAD(SQL Table) |
Index Back |
|---|---|
Rel. Lang 4 Off Cycle SetupRelated language table for GP_OC_SETUP_U |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | GP_TX_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Transaction Type (introduced with Off-cycle). Identifies an offcycle request as correction,manual payment, unscheduled payment or advance.
XLAT values are assigned to support batch processing order
A=Advance M=Manual Payment R=Correction U=Additional Payment |
| 4 | GP_TX_REASON |
Character(18) | VARCHAR2(18) NOT NULL | Off Cycle (Transaction) Reason Identifies a particular configuration to be applied to the presentation of off cycle request information |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |