| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GPFR_DU_CONT_FAM |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Family
Prompt Table:
GPFR_DU_SRCH_VW
|
| 2 |
GPFR_DU_CONT_TYP_N |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Contribution Type
Prompt Table:
%GP_EDIT_FLD1
|
| 3 |
GPFR_DU_CONT_TYP_T |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
Prompt Table:
GPFR_DUCS_PINVW
|
| 4 |
GPFR_DU_CONT_TYP_C |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
|
| 5 |
GPFR_DU_CONT_REC |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution record
COT=Contributions
TAT=Additional Transportation
TRS=Transportation
Default Value: COT
|
| 6 |
GPFR_DU_CONT_ORDER |
Number(2,0) |
SMALLINT NOT NULL |
Order number in the contribution setup
|
| 7 |
GPFR_DU_CONT_SET |
Character(1) |
VARCHAR2(1) NOT NULL |
Contribution Set
1=Set1
2=Set2
|
| 8 |
GPFR_DU_CONT_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
GPFR: Description
|
| 9 |
GPFR_DU_AT_RATE_T |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
Prompt Table:
GPFR_DUCS_BASVW
|
| 10 |
GPFR_DU_AT_RATE_N |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Contribution Type
Prompt Table:
%GP_EDIT_FLD2
|
| 11 |
GPFR_DU_GRPBY1_T |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
Prompt Table:
GPFR_DUCS_BASVW
|
| 12 |
GPFR_DU_GRPBY1_N |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Contribution Type
Prompt Table:
%GP_EDIT_FLD3
|
| 13 |
GPFR_DU_GRPBY2_T |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
Prompt Table:
GPFR_DUCS_BASVW
|
| 14 |
GPFR_DU_GRPBY2_N |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Contribution Type
Prompt Table:
%GP_EDIT_FLD4
|
| 15 |
GPFR_DU_AMT_T |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
Prompt Table:
GPFR_DUCS_BASVW
|
| 16 |
GPFR_DU_AMT_N |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Contribution Type
Prompt Table:
%GP_EDIT_FLD5
|
| 17 |
GPFR_DU_SGN_POS |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Positive Contribution Type 1
Prompt Table:
GPFR_DUCS_PAR4
|
| 18 |
GPFR_DU_SGN_NEG |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Positive Contribution Type 1
Prompt Table:
GPFR_DUCS_PAR4
|
| 19 |
GPFR_DU_QTY_T |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
Prompt Table:
GPFR_DUCS_BASVW
|
| 20 |
GPFR_DU_QTY_N |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Contribution Type
Prompt Table:
%GP_EDIT_FLD6
|
| 21 |
GPFR_DU_PDF_CEIL |
Character(15) |
VARCHAR2(15) NOT NULL |
PDF Cieling
|
| 22 |
GPFR_DU_PDF_BAS_T |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
Prompt Table:
GPFR_DUCS_BASVW
|
| 23 |
GPFR_DU_PDF_BAS_N |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Contribution Type
Prompt Table:
%GP_EDIT_FLD7
|
| 24 |
GPFR_DU_PDF_RT_T |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
Prompt Table:
GPFR_DUCS_BASVW
|
| 25 |
GPFR_DU_PDF_RT_N |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Contribution Type
Prompt Table:
%GP_EDIT_FLD8
|
| 26 |
GPFR_DU_PDF_AMT_T |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
Prompt Table:
GPFR_DUCS_BASVW
|
| 27 |
GPFR_DU_PDF_AMT_N |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Contribution Type
Prompt Table:
%GP_EDIT_FLD9
|
| 28 |
GPFR_DU_REF_CD_T |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
Prompt Table:
GPFR_DUCS_BASVW
|
| 29 |
GPFR_DU_REF_CD_N |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Contribution Type
Prompt Table:
%GP_EDIT_FLD10
|
| 30 |
GPFR_DU_REF_FAM_T |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
Prompt Table:
GPFR_DUCS_BASVW
|
| 31 |
GPFR_DU_REF_FAM_N |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Contribution Type
Prompt Table:
%GP_EDIT_FLD11
|
| 32 |
GPFR_DU_EE_RATE_T |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
Prompt Table:
GPFR_DUCS_BASVW
|
| 33 |
GPFR_DU_EE_RATE_N |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Contribution Type
Prompt Table:
%EDITTABLE6
|
| 34 |
GPFR_DU_EE_AMT_T |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
Prompt Table:
GPFR_DUCS_BASVW
|
| 35 |
GPFR_DU_EE_AMT_N |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Contribution Type
Prompt Table:
%EDITTABLE7
|
| 36 |
GPFR_DU_ER_RATE_T |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
Prompt Table:
GPFR_DUCS_BASVW
|
| 37 |
GPFR_DU_ER_RATE_N |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Contribution Type
Prompt Table:
%EDITTABLE8
|
| 38 |
GPFR_DU_ER_AMT_T |
Character(3) |
VARCHAR2(3) NOT NULL |
GPFR: Contribution Type
Prompt Table:
GPFR_DUCS_BASVW
|
| 39 |
GPFR_DU_ER_AMT_N |
Number(8,0) |
INTEGER NOT NULL |
GPFR: Contribution Type
Prompt Table:
%EDITTABLE9
|