GPFR_DA_SNDREFGPFR_DA_COMPANYPrompt Table: COMPANY_TBL
Prompt Table: ESTAB_COMP_VW
Prompt Table: ESTAB_COMP_VW
Prompt Table: GPFR_DA_ESTREP
A=All
E=Exclude
O=Include
Default Value: O
GPFR_DA_COMREF(SQL Table) |
Index Back |
|---|---|
Companies for DADS Sending Re.DADS related record: to store the companies for the sending references for DADS. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_DA_SNDREF |
Character(10) | VARCHAR2(10) NOT NULL | DADS related field |
| 2 | GPFR_DA_COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
DADS related field
Prompt Table: COMPANY_TBL |
| 3 | GPFR_DA_MNESTAB | Character(12) | VARCHAR2(12) NOT NULL |
DADS related field
Prompt Table: ESTAB_COMP_VW |
| 4 | GPFR_DA_DECESTAB | Character(12) | VARCHAR2(12) NOT NULL |
DADS related field
Prompt Table: ESTAB_COMP_VW |
| 5 | GPFR_DA_ESTREP | Character(12) | VARCHAR2(12) NOT NULL |
DADS related field.
Prompt Table: GPFR_DA_ESTREP |
| 6 | GPFR_DA_CUSTNUM | Character(20) | VARCHAR2(20) NOT NULL | DADS related field |
| 7 | GPFR_DA_ESTAB_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Store Establishment Options in Sending Ref. Page.
A=All E=Exclude O=Include Default Value: O |