SRF_SRC_DN(SQL Table) |
Index Back |
|---|---|
SRF_SRC_DNDEIU source table for DN records |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SRF_SRC_IS_BC |
Character(1) | VARCHAR2(1) NOT NULL |
PIR SRF source is BC
N=No Y=Yes |
| 3 | BATCH_SEQ_NUM |
Number(15,0) | DECIMAL(15) NOT NULL | Batch Number |
| 4 | PAYMENT_SEQ_NUM |
Number(6,0) | INTEGER NOT NULL | Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit. |
| 5 | TOTAL_PAY_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Payment Amount - Base |
| 6 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 7 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 8 | SRF_DN_PYMNT_TYPE | Character(25) | VARCHAR2(25) NOT NULL | PaymentTypeCode |
| 9 | ALC | Character(8) | VARCHAR2(8) NOT NULL | Agency Location Code |
| 10 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 11 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 12 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 13 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 14 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 15 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 16 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 17 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 18 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 19 | TREASURY_PMT_NBR | Number(11,0) | DECIMAL(11) NOT NULL | Payment Confirm Number |
| 20 | PYMNT_ID_REF | Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |
| 21 | BANK_ACCT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
An account attribute that describes the ostensible purposes of a given bank/counterparty account.
01=Time Deposit 03=Checking Account 05=Stock 06=Bond 07=Life Insurance Value 08=Retirement Account 10=Business Account 11=Trust Fund Account 12=Stock & Bond Account 13=Life Insurance Acct CA=Current Account CH=Charges Account DA=Demand Deposit LN=Loan RD=Return Items on DDA RS=Return Items-Savings SA=Settlement Account SV=Savings Account Z=Mutually Defined |
| 22 | EFT_LAYOUT_CD | Character(10) | VARCHAR2(10) NOT NULL | EFT Layout Code |
| 23 | RECV_DFI_ID_NUM | Character(12) | VARCHAR2(12) NOT NULL | Receiving DFI ID Number |
| 24 | PYMNT_DT | Date(10) | DATE | Payment Date |
| 25 | IPAC_SENDER_DO | Character(5) | VARCHAR2(5) NOT NULL | Sender Disbursing Office |
| 26 | ACH_RRC | Character(3) | VARCHAR2(3) NOT NULL | ACH Return Reason Code |
| 27 | SRF_DN_CHECK_SN | Character(8) | VARCHAR2(8) NOT NULL | Check Serial Number |
| 28 | SRF_DN_PAYMENT_ID | Character(20) | VARCHAR2(20) NOT NULL | PaymentID |
| 29 | SRF_DN_ACH_OTC_NUM | Character(15) | VARCHAR2(15) NOT NULL | ACH_OriginalTraceNumber |
| 30 | SRF_DN_ORGN_CURR | Character(3) | VARCHAR2(3) NOT NULL | OriginalCurrency Code |
| 31 | SRF_DN_ORGN_SCHD | Character(14) | VARCHAR2(14) NOT NULL | Original ScheduleNumber |
| 32 | SRF_DN_ORGN_PYMNT | Character(20) | VARCHAR2(20) NOT NULL | Original PaymentID |
| 33 | SRF_DN_ORGN_SUM_DT | Character(10) | VARCHAR2(10) NOT NULL | Original Summary Date |