GPFR_DUCS_CONVW

(SQL View)
 Index Back

Contribution Setup Definition

This setup is read via an Array, which populate the Writeable Array used in the Application Engine

SELECT GPFR_DU_CONT_FAM , GPFR_DU_CONT_TYP_N + 50000000 , GPFR_DU_CONT_TYP_T , GPFR_DU_CONT_TYP_C , GPFR_DU_CONT_REC , GPFR_DU_CONT_ORDER , GPFR_DU_CONT_SET , GPFR_DU_CONT_DESC , GPFR_DU_AT_RATE_T , GPFR_DU_AT_RATE_N + 50000000 , GPFR_DU_GRPBY1_T , GPFR_DU_GRPBY1_N + 50000000 , GPFR_DU_GRPBY2_T , GPFR_DU_GRPBY2_N + 50000000 , GPFR_DU_AMT_T , GPFR_DU_AMT_N + 50000000 , GPFR_DU_SGN_POS , GPFR_DU_SGN_NEG , GPFR_DU_QTY_T , GPFR_DU_QTY_N + 50000000 , GPFR_DU_PDF_CEIL , GPFR_DU_PDF_BAS_T , GPFR_DU_PDF_BAS_N + 50000000 , GPFR_DU_PDF_RT_T , GPFR_DU_PDF_RT_N + 50000000 , GPFR_DU_PDF_AMT_T , GPFR_DU_PDF_AMT_N + 50000000 , GPFR_DU_REF_CD_T , GPFR_DU_REF_CD_N + 50000000 , GPFR_DU_REF_FAM_T , GPFR_DU_REF_FAM_N + 50000000 , GPFR_DU_EE_RATE_T , GPFR_DU_EE_RATE_N + 50000000 , GPFR_DU_EE_AMT_T , GPFR_DU_EE_AMT_N + 50000000 , GPFR_DU_ER_RATE_T , GPFR_DU_ER_RATE_N + 50000000 , GPFR_DU_ER_AMT_T , GPFR_DU_ER_AMT_N + 50000000 FROM PS_GPFR_DUCS_CONTS

# 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