PROCESS_INSTANCEGPFR_DA_STRUCTPIN_NUMPrompt Table: %GP_EDIT_FLD1
Prompt Table: GPFR_DA_RECORD
Prompt Table: GPFR_DA_PINVW
A=Add
S=Subtract
Default Value: A
GPFR_DA_PIN_TMP(SQL Table) |
Index Back |
|---|---|
Elements Attached to a RecordDADS related record: to store the elements attached to a record used in the DADS process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | GPFR_DA_STRUCT |
Character(10) | VARCHAR2(10) NOT NULL | DADS related field |
| 3 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: %GP_EDIT_FLD1 |
| 4 | GPFR_DA_RECORD | Character(10) | VARCHAR2(10) NOT NULL |
DADS related record
Prompt Table: GPFR_DA_RECORD |
| 5 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Element Entry Type ID
Prompt Table: GPFR_DA_PINVW |
| 6 | GPFR_DA_SIGN_IND | Character(1) | VARCHAR2(1) NOT NULL |
Sign Indicator
A=Add S=Subtract Default Value: A |
| 7 | PIN_CUSTOM1 | Character(20) | VARCHAR2(20) NOT NULL | Customer FIelds |
| 8 | PIN_CUSTOM2 | Character(20) | VARCHAR2(20) NOT NULL | PIN_CUSTOM2 |
| 9 | PIN_CUSTOM3 | Character(20) | VARCHAR2(20) NOT NULL | PIN_CUSTOM3 fields |
| 10 | PIN_CUSTOM4 | Character(20) | VARCHAR2(20) NOT NULL | PIN_CUSTOM4 |
| 11 | PIN_CUSTOM5 | Character(20) | VARCHAR2(20) NOT NULL | PIN_CUSTOM5 |