GPDE_BL_PRINT(SQL Table) |
Index Back |
|---|---|
Balance PrintBalance Print |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPDE_RC_REPORTNAME |
Character(8) | VARCHAR2(8) NOT NULL | Print Class |
| 2 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: %RECNAME_EDIT |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | ENTRY_TYPE_ELEM | Character(3) | VARCHAR2(3) NOT NULL |
entry type element
Prompt Table: GPDE_BL_PRCL_VW |
| 5 | GPDE_AL_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Override Indicator
Y/N Table Edit Default Value: N |
| 6 | GPDE_AL_SIGNVALUE | Signed Number(2,0) | DECIMAL(1) NOT NULL | Element Sign |
| 7 | GPDE_BL_PR_ORDER | Number(6,0) | INTEGER NOT NULL | Print Sequence |
| 8 | GPDE_BL_PR_GROUP | Number(2,0) | SMALLINT NOT NULL | Print Group |
| 9 | GPDE_BL_PR_BASE | Character(1) | VARCHAR2(1) NOT NULL |
Print Base
Y/N Table Edit Default Value: N |
| 10 | GPDE_BL_PR_AMT | Character(1) | VARCHAR2(1) NOT NULL |
Print Amount
Y/N Table Edit Default Value: Y |
| 11 | GPDE_BL_PR_PERCENT | Character(1) | VARCHAR2(1) NOT NULL |
Print Percent
Y/N Table Edit Default Value: N |
| 12 | GPDE_BL_PR_UNITS | Character(1) | VARCHAR2(1) NOT NULL |
Print Units
Y/N Table Edit Default Value: N |
| 13 | GPDE_BL_PR_HOURS | Character(1) | VARCHAR2(1) NOT NULL |
Print Hours
Y/N Table Edit Default Value: N |
| 14 | GPDE_BL_PR_FACTOR | Character(1) | VARCHAR2(1) NOT NULL |
Print Factor
Y/N Table Edit Default Value: N |
| 15 | GPDE_BL_PR_SUM | Character(1) | VARCHAR2(1) NOT NULL |
Print Sum Amount
Y/N Table Edit Default Value: N |
| 16 | GPDE_BL_PR_TOTAL | Character(1) | VARCHAR2(1) NOT NULL |
Print Total
Y/N Table Edit Default Value: N |
| 17 | GPDE_BL_PR_FIX_VAL | Character(1) | VARCHAR2(1) NOT NULL |
Static PIN Indicator
Y/N Table Edit Default Value: N |