PROCESS_INSTANCEGPFR_DUCS_NUMBERGPFR_DUCS_CDGPFR_DUCS_TYPEGPFR_ROW_NUMGPFR_ROW_NUM2GPFR_DUCS_RECORDGPFR_DUCS_REG_FLGY/N Table Edit
Default Value: N
GPFR_DUCS_R(SQL Table) |
Index Back |
|---|---|
Result DUCS SegmentsResult DUCS Segments |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | GPFR_DUCS_NUMBER |
Number(10,0) | DECIMAL(10) NOT NULL | DUCS Process Instance |
| 3 | GPFR_DUCS_CD |
Character(10) | VARCHAR2(10) NOT NULL | GPFR: DUCS Code |
| 4 | GPFR_DUCS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | GPFR: DUCS Type |
| 5 | GPFR_ROW_NUM |
Number(5,0) | INTEGER NOT NULL | Used as counter for row or column number |
| 6 | GPFR_ROW_NUM2 |
Number(5,0) | INTEGER NOT NULL | Used as counter for row or column number (level2). Used in the DUCS/BDA/TRC reports. |
| 7 | GPFR_DUCS_RECORD |
Character(3) | VARCHAR2(3) NOT NULL | GPFR: Record Code |
| 8 | GPFR_DUCS_REG_FLG |
Character(1) | VARCHAR2(1) NOT NULL |
DUCS Regularization Flag
Y/N Table Edit Default Value: N |
| 9 | GPFR_DUCS_R1_CD | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Type |
| 10 | GPFR_DUCS_R1_ID | Character(35) | VARCHAR2(35) NOT NULL | Identification Number |
| 11 | GPFR_DUCS_R1_RES | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Reserved |
| 12 | GPFR_DUCS_R1_NAME1 | Character(35) | VARCHAR2(35) NOT NULL | Name for the Declared Unit |
| 13 | GPFR_DUCS_R1_NAME2 | Character(35) | VARCHAR2(35) NOT NULL | GPFR: Name 2 |
| 14 | GPFR_DUCS_R1_ADD1 | Character(35) | VARCHAR2(35) NOT NULL | GPFR: Address 1 |
| 15 | GPFR_DUCS_R1_ADD2 | Character(35) | VARCHAR2(35) NOT NULL | GPFR: Address 2 |
| 16 | GPFR_DUCS_R1_CITY | Character(35) | VARCHAR2(35) NOT NULL | GPFR: City |
| 17 | GPFR_DUCS_R1_ZIP | Character(9) | VARCHAR2(9) NOT NULL | GPFR: Zip Code |
| 18 | GPFR_DUCS_RECORD2 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Record Code |
| 19 | GPFR_DUCS_R2_DEP | Character(35) | VARCHAR2(35) NOT NULL | Correspondant mane (service name or employee's name) |
| 20 | GPFR_DUCS_R2_TEL | Character(25) | VARCHAR2(25) NOT NULL | GPFR: Telephone |
| 21 | GPFR_DUCS_R2_FAX | Character(25) | VARCHAR2(25) NOT NULL | GPFR: Fax |
| 22 | GPFR_DUCS_R2_REF1 | Character(35) | VARCHAR2(35) NOT NULL | GPFR: Reference 1 |
| 23 | GPFR_DUCS_R2_REF2 | Character(35) | VARCHAR2(35) NOT NULL | GPFR: Reference 2 |
| 24 | GPFR_DUCS_R2_REF3 | Character(35) | VARCHAR2(35) NOT NULL | GPFR: Reference 3 |
| 25 | GPFR_DUCS_RECORD3 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Record Code |
| 26 | GPFR_DUCS_R3_DATE | Character(35) | VARCHAR2(35) NOT NULL | GPFR: Date |
| 27 | GPFR_DUCS_R3_FMT | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Date Format |
| 28 | GPFR_DUCS_R3_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 1 for the EN3 DUCS Record. Used in the SUM record. |
| 29 | GPFR_DUCS_R3_CUR | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Currency |
| 30 | GPFR_DUCS_R3_TYP | Character(3) | VARCHAR2(3) NOT NULL | DUCS R3 Amount Type |
| 31 | GPFR_DUCS_R3_AMT2 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 2 for the EN3 DUCS Record |
| 32 | GPFR_DUCS_R3_CUR2 | Character(3) | VARCHAR2(3) NOT NULL | Currency of the declaration |
| 33 | GPFR_DUCS_R3_TYP2 | Character(3) | VARCHAR2(3) NOT NULL | DUCS R3 Amount Type 2 |
| 34 | GPFR_DUCS_R3_DATE2 | Character(2) | VARCHAR2(2) NOT NULL | DUCS R3 Period |
| 35 | GPFR_DUCS_R3_FMT2 | Character(3) | VARCHAR2(3) NOT NULL | DUCS R3 Format Date 2 |
| 36 | GPFR_DUCS_R3_AMT3 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | DUCS R3 Amount 3 |
| 37 | GPFR_DUCS_R3_CUR3 | Character(3) | VARCHAR2(3) NOT NULL | DUCS R3 Currency 3 |
| 38 | GPFR_DUCS_R3_TYP3 | Character(3) | VARCHAR2(3) NOT NULL | DUCS R3 Amount Type 3 |
| 39 | GPFR_DUCS_R3_AMT4 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | DUCS R3 Amount 4 |
| 40 | GPFR_DUCS_R3_CUR4 | Character(3) | VARCHAR2(3) NOT NULL | DUCS R3 Currency 4 |
| 41 | GPFR_DUCS_R3_TYP4 | Character(3) | VARCHAR2(3) NOT NULL | DUCS R3 Amount Type 4 |
| 42 | GPFR_DUCS_RECORD4 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Record Code |
| 43 | GPFR_DUCS_R4_QTY01 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 1 for the DUCS EN4 Record |
| 44 | GPFR_DUCS_R4_QTY02 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 2 for the EN4 DUCS Record |
| 45 | GPFR_DUCS_R4_QTY03 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 3 for the EN4 DUCS Record |
| 46 | GPFR_DUCS_R4_QTY04 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 4 for the EN4 DUCS Record |
| 47 | GPFR_DUCS_R4_QTY05 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 5 for the EN4 DUCS Record |
| 48 | GPFR_DUCS_R4_QTY06 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 6 for the EN4 DUCS Record |
| 49 | GPFR_DUCS_R4_QTY07 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 7 for the EN4 DUCS Record |
| 50 | GPFR_DUCS_R4_QTY08 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 8 for the EN4 DUCS Record |
| 51 | GPFR_DUCS_R4_QTY09 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 9 for the EN4 DUCS Record |
| 52 | GPFR_DUCS_R4_QTY10 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 10 for the EN4 DUCS Record |
| 53 | GPFR_DUCS_R4_QTY11 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 11 for the EN4 DUCS Record |
| 54 | GPFR_DUCS_R4_QTY12 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 12 for the EN4 DUCS Record |
| 55 | GPFR_DUCS_R4_QTY13 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 13 for the EN4 DUCS Record |
| 56 | GPFR_DUCS_R4_QTY14 | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Quantity 14 for the EN4 DUCS Record |
| 57 | GPFR_DUCS_R2_REF4 | Character(35) | VARCHAR2(35) NOT NULL | DUCS R2 Reference 4 |
| 58 | GPFR_DUCS_R3_PRD | Character(3) | VARCHAR2(3) NOT NULL | DUCS R3 Period |
| 59 | GPFR_DUCS_R4_QTY15 | Number(8,2) | DECIMAL(7,2) NOT NULL | DUCS R4 Quantity 15 |
| 60 | GPFR_DUCS_R4_QTY16 | Number(8,2) | DECIMAL(7,2) NOT NULL | DUCS R4 Quantity 16 |
| 61 | GPFR_DUCS_RECORD5 | Character(3) | VARCHAR2(3) NOT NULL | DUCS Record5 Code |
| 62 | GPFR_DUCS_R5_EMAIL | Character(252) | VARCHAR2(252) NOT NULL | DUCS R5 EMAIL |