GP_PKG_IDGPFR_DU_CONT_FAMGPFR_DU_CONT_TYP_NGPFR_DU_CONT_TYP_TGPFR_DU_CONT_TYP_CGPFR_DU_CONT_RECCOT=Contributions
TAT=Additional Transportation
TRS=Transportation
GPFR_DU_CONT_ORDERGPFR_DU_CONT_SET1=Set1
2=Set2
GPFR_DUCS_CONAD(SQL Table) |
Index Back |
|---|---|
Contribution Setup DefinitionThis setup is read via an Array, which populate the Writeable Array used in the Application Engine |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | GPFR_DU_CONT_FAM |
Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Family |
| 3 | GPFR_DU_CONT_TYP_N |
Number(8,0) | INTEGER NOT NULL | GPFR: Contribution Type |
| 4 | GPFR_DU_CONT_TYP_T |
Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 5 | GPFR_DU_CONT_TYP_C |
Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 6 | GPFR_DU_CONT_REC |
Character(3) | VARCHAR2(3) NOT NULL |
GPFR: Contribution record
COT=Contributions TAT=Additional Transportation TRS=Transportation |
| 7 | GPFR_DU_CONT_ORDER |
Number(2,0) | SMALLINT NOT NULL | Order number in the contribution setup |
| 8 | GPFR_DU_CONT_SET |
Character(1) | VARCHAR2(1) NOT NULL |
Contribution Set
1=Set1 2=Set2 |
| 9 | GPFR_DU_CONT_DESC | Character(30) | VARCHAR2(30) NOT NULL | GPFR: Description |
| 10 | GPFR_DU_AT_RATE_T | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 11 | GPFR_DU_AT_RATE_N | Number(8,0) | INTEGER NOT NULL | GPFR: Contribution Type |
| 12 | GPFR_DU_GRPBY1_T | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 13 | GPFR_DU_GRPBY1_N | Number(8,0) | INTEGER NOT NULL | GPFR: Contribution Type |
| 14 | GPFR_DU_GRPBY2_T | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 15 | GPFR_DU_GRPBY2_N | Number(8,0) | INTEGER NOT NULL | GPFR: Contribution Type |
| 16 | GPFR_DU_AMT_T | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 17 | GPFR_DU_AMT_N | Number(8,0) | INTEGER NOT NULL | GPFR: Contribution Type |
| 18 | GPFR_DU_SGN_POS | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Positive Contribution Type 1 |
| 19 | GPFR_DU_SGN_NEG | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Positive Contribution Type 1 |
| 20 | GPFR_DU_QTY_T | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 21 | GPFR_DU_QTY_N | Number(8,0) | INTEGER NOT NULL | GPFR: Contribution Type |
| 22 | GPFR_DU_PDF_CEIL | Character(15) | VARCHAR2(15) NOT NULL | PDF Cieling |
| 23 | GPFR_DU_PDF_BAS_T | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 24 | GPFR_DU_PDF_BAS_N | Number(8,0) | INTEGER NOT NULL | GPFR: Contribution Type |
| 25 | GPFR_DU_PDF_RT_T | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 26 | GPFR_DU_PDF_RT_N | Number(8,0) | INTEGER NOT NULL | GPFR: Contribution Type |
| 27 | GPFR_DU_PDF_AMT_T | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 28 | GPFR_DU_PDF_AMT_N | Number(8,0) | INTEGER NOT NULL | GPFR: Contribution Type |
| 29 | GPFR_DU_REF_CD_T | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 30 | GPFR_DU_REF_CD_N | Number(8,0) | INTEGER NOT NULL | GPFR: Contribution Type |
| 31 | GPFR_DU_REF_FAM_T | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 32 | GPFR_DU_REF_FAM_N | Number(8,0) | INTEGER NOT NULL | GPFR: Contribution Type |
| 33 | GPFR_DU_EE_RATE_T | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 34 | GPFR_DU_EE_RATE_N | Number(8,0) | INTEGER NOT NULL | GPFR: Contribution Type |
| 35 | GPFR_DU_EE_AMT_T | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 36 | GPFR_DU_EE_AMT_N | Number(8,0) | INTEGER NOT NULL | GPFR: Contribution Type |
| 37 | GPFR_DU_ER_RATE_T | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 38 | GPFR_DU_ER_RATE_N | Number(8,0) | INTEGER NOT NULL | GPFR: Contribution Type |
| 39 | GPFR_DU_ER_AMT_T | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Contribution Type |
| 40 | GPFR_DU_ER_AMT_N | Number(8,0) | INTEGER NOT NULL | GPFR: Contribution Type |