GPAU_EFT_USER_NOGPAU_EFT_TRANS_CD13=Debit
50=Recipient Credit
53=Payroll Credit
BRANCH_EC_CDACCOUNT_EC_IDACCOUNT_NAMEGPAU_LODGEMENT_REFGPAU_TR_BRANCH_CDGPAU_TR_ACCOUNT_CDDESCRGPAU_EFT_CMX_DT(SQL Table) |
Index Back |
|---|---|
EFT Detail TableHold EFT detail information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPAU_EFT_USER_NO |
Character(6) | VARCHAR2(6) NOT NULL | EFT User Number used in the AE program GPAU_EFT_CMX. |
| 2 | GPAU_EFT_TRANS_CD |
Character(2) | VARCHAR2(2) NOT NULL |
This field tracks 3 values used in the output file for the AE program GPAU_EFT_CMX.
13=Debit 50=Recipient Credit 53=Payroll Credit |
| 3 | BRANCH_EC_CD |
Character(17) | VARCHAR2(17) NOT NULL | Bank Branch ID |
| 4 | ACCOUNT_EC_ID |
Character(35) | VARCHAR2(35) NOT NULL | Account Number used in banking. |
| 5 | ACCOUNT_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Account Name |
| 6 | GPAU_LODGEMENT_REF |
Character(50) | VARCHAR2(50) NOT NULL | This field is used in the AE program GPAU_EFT_CMX. |
| 7 | GPAU_TR_BRANCH_CD |
Character(17) | VARCHAR2(17) NOT NULL | The Trace Branch Code supersedes any Branch Code tracked on the Source Bank Table. |
| 8 | GPAU_TR_ACCOUNT_CD |
Character(35) | VARCHAR2(35) NOT NULL | The Trace Account Code supersedes any account code tracked on the Source Bank Table. |
| 9 | DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | GPAU_EFT_CR | Signed Number(19,2) | DECIMAL(17,2) NOT NULL | This field tracks the credit amount for the AE program GPAU_EFT_CMX. |
| 11 | GPAU_EFT_PMT_AMT | Character(10) | VARCHAR2(10) NOT NULL | This field tracks the Payment Amount in a specific character formatted format for the AE program GPAU_EFT_CMX. |