GPFR_DA_STRUCTPIN_NUMPrompt Table: %GP_EDIT_FLD1
GPFR_DA_RECORDPrompt Table: GPFR_DA_RECORD
Prompt Table: GPFR_DA_PINVW
A=Add
S=Subtract
GPFR_DAPINCSTVW(SQL View) |
Index Back |
|---|---|
Cust. Struct. Record ElementsDADS related record: view on GPFR_DA_PIN_CST for non-rule packager export view |
| SELECT GPFR_DA_STRUCT , PIN_NUM + 50000000 , GPFR_DA_RECORD , ENTRY_TYPE_ID , GPFR_DA_SIGN_IND FROM PS_GPFR_DA_PIN_CST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_DA_STRUCT |
Character(10) | VARCHAR2(10) NOT NULL | DADS related field |
| 2 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: %GP_EDIT_FLD1 |
| 3 | GPFR_DA_RECORD |
Character(10) | VARCHAR2(10) NOT NULL |
DADS related record
Prompt Table: GPFR_DA_RECORD |
| 4 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Element Entry Type ID
Prompt Table: GPFR_DA_PINVW |
| 5 | GPFR_DA_SIGN_IND | Character(1) | VARCHAR2(1) NOT NULL |
Sign Indicator
A=Add S=Subtract |