GPFR_DUCS_PAI

(SQL Table)
 Index Back

Result DUCS PAI Segment

Written at the end of the declaration file. Contains the payment reference.

# 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_DUCS_REG_FLG Character(1) VARCHAR2(1) NOT NULL DUCS Regularization Flag

Y/N Table Edit

Default Value: N

7 GPFR_DUCS_RECORD Character(3) VARCHAR2(3) NOT NULL GPFR: Record Code
8 GPFR_DUCS_PAI_MD Character(3) VARCHAR2(3) NOT NULL GPFR: Payment Type
9 GPFR_DUCS_PAI_CNT Character(3) VARCHAR2(3) NOT NULL GPFR: Payment Order
10 GPFR_DUCS_PAI_NUM Character(35) VARCHAR2(35) NOT NULL GPFR: Account Number
11 GPFR_DUCS_PAI_BANK Character(11) VARCHAR2(11) NOT NULL GPFR: Bank Number
12 GPFR_DUCS_PAI_LST1 Character(3) VARCHAR2(3) NOT NULL GPFR: Bank Family
13 GPFR_DUCS_PAI_OFF1 Character(3) VARCHAR2(3) NOT NULL GPFR: Bank Group
14 GPFR_DUCS_PAI_DSK Character(17) VARCHAR2(17) NOT NULL GPFR: Bank Office Number
15 GPFR_DUCS_PAI_LST2 Character(3) VARCHAR2(3) NOT NULL GPFR: Bank Office Family
16 GPFR_DUCS_PAI_OFF2 Character(3) VARCHAR2(3) NOT NULL GPFR: Bank Office Group
17 GPFR_DUCS_PAI_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount in the PAI DUCS Record
18 GPFR_DUCS_PAI_CUR Character(3) VARCHAR2(3) NOT NULL GPFR: Currency
19 GPFR_DUCS_PAI_REF Character(3) VARCHAR2(3) NOT NULL GPFR: Social Reference type
20 GPFR_DUCS_PAI_SOC Character(35) VARCHAR2(35) NOT NULL GPFR: Social Reference
21 GPFR_DUCS_PAI_TYP Character(3) VARCHAR2(3) NOT NULL GPFR: Payment Date Type
22 GPFR_DUCS_PAI_DAT Character(35) VARCHAR2(35) NOT NULL GPFR: Payment Date
23 GPFR_DUCS_PAI_FMT Character(3) VARCHAR2(3) NOT NULL GPFR: Payment Date Format