SRF_SRC_BN_BT

(SQL Table)
Index Back

SRF_SRC_BN_BT

DEIU source table for BN and BT 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 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
5 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
6 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
7 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer
8 EFT_LAYOUT_CD Character(10) VARCHAR2(10) NOT NULL EFT Layout Code
9 TAS_BETC_SCH Signed Number(5,0) DECIMAL(4) NOT NULL TAS/BETC Per Schedule
10 TAS_BETC_PYMNT Signed Number(5,0) DECIMAL(4) NOT NULL TAS/BETC Per Payment
11 PIR_CLASSIFICATION Character(2) VARCHAR2(2) NOT NULL PIR Classification
BA=Adjustment
BC=Check
BI=International
BN=ACH/EFT
BW=Wire
12 PIR_SUMM_NUM Character(6) VARCHAR2(6) NOT NULL PIR Schedule Number
13 PIR_SUMM_DT Date(10) DATE PIR Summary Date
14 PIR_VOUCHER_FRM_CD Character(4) VARCHAR2(4) NOT NULL PIR Voucher Form Code
215=Adjustment
5515=Payment
15 DFI_ID_NUM Character(12) VARCHAR2(12) NOT NULL A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
16 ALC Character(8) VARCHAR2(8) NOT NULL Agency Location Code
17 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
18 CREATION_DT Date(10) DATE Creation Date
19 IPAC_SENDER_DO Character(5) VARCHAR2(5) NOT NULL Sender Disbursing Office
20 SRF_BN_SCHD_NUM Character(14) VARCHAR2(14) NOT NULL Schedule Number
21 SRF_BN_SUMM_NUM Character(6) VARCHAR2(6) NOT NULL Summary Number
22 SRF_BN_SUMM_DT Character(10) VARCHAR2(10) NOT NULL Summary Date
23 SRF_BN_C_SMBL_NUM Character(4) VARCHAR2(4) NOT NULL CheckSymbolNumber
24 SRF_BN_C_FIRST_SN Character(8) VARCHAR2(8) NOT NULL Check First Serial Number
25 SRF_BN_C_ACCT_MY Character(4) VARCHAR2(4) NOT NULL Check Accounting Month And Year
26 SRF_BT_TOT_COUNT Character(8) VARCHAR2(8) NOT NULL TotalCount
27 SRF_BT_TOT_AMOUNT Character(20) VARCHAR2(20) NOT NULL TotalAmount