PROCESS_INSTANCEPIN_NUMPrompt Table: %GP_EDIT_FLD1
GPFR_DA_STRUCTPrompt Table: GPFR_DA_RECORD
Prompt Table: GPFR_DA_PINVW
GPFR_AF_PIN_TMP(SQL Table) |
Index Back |
|---|---|
Elements Attached to a RecordApplication Framework - |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: %GP_EDIT_FLD1 |
| 3 | GPFR_DA_STRUCT |
Character(10) | VARCHAR2(10) NOT NULL | DADS related field |
| 4 | GPFR_DA_RECORD | Character(10) | VARCHAR2(10) NOT NULL |
DADS related record
Prompt Table: GPFR_DA_RECORD |
| 5 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 6 | GPFR_AF_APPL | Character(10) | VARCHAR2(10) NOT NULL | Application Framework - Application |
| 7 | GPFR_AF_EXTRACT_ID | Character(18) | VARCHAR2(18) NOT NULL | Application Framework - Extraction ID |
| 8 | GPFR_AF_SNDREF | Character(10) | VARCHAR2(10) NOT NULL | Application Framework - Sending Reference |
| 9 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Element Entry Type ID
Prompt Table: GPFR_DA_PINVW |
| 10 | GPFR_AMOUNT_SIGN | Signed Number(4,0) | DECIMAL(3) NOT NULL | Amount Sign |
| 11 | GPFR_BASE_SIGN | Signed Number(4,0) | DECIMAL(3) NOT NULL | Base Sign |
| 12 | GPFR_UNIT_SIGN | Signed Number(4,0) | DECIMAL(3) NOT NULL | Unit Sign |
| 13 | PIN_CUSTOM1 | Character(20) | VARCHAR2(20) NOT NULL | Customer FIelds |
| 14 | PIN_CUSTOM2 | Character(20) | VARCHAR2(20) NOT NULL | PIN_CUSTOM2 |
| 15 | PIN_CUSTOM3 | Character(20) | VARCHAR2(20) NOT NULL | PIN_CUSTOM3 fields |
| 16 | PIN_CUSTOM4 | Character(20) | VARCHAR2(20) NOT NULL | PIN_CUSTOM4 |
| 17 | PIN_CUSTOM5 | Character(20) | VARCHAR2(20) NOT NULL | PIN_CUSTOM5 |
| 18 | GP_ELN_ATTR6 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 19 | GP_ELN_ATTR7 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 20 | GP_ELN_ATTR8 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 21 | GP_ELN_ATTR9 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |
| 22 | GP_ELN_ATTR10 | Character(20) | VARCHAR2(20) NOT NULL | ELN Attribute |