PIR_SRF_GRP_AET

(SQL Table)
Index Back

PIR_SRF_GRP_AET

PIR SRF File Creation State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
3 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
4 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
5 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
6 EFT_LAYOUT_CD Character(10) VARCHAR2(10) NOT NULL EFT Layout Code
7 TAS_BETC_SCH Signed Number(5,0) DECIMAL(4) NOT NULL TAS/BETC Per Schedule
8 TAS_BETC_PYMNT Signed Number(5,0) DECIMAL(4) NOT NULL TAS/BETC Per Payment
9 USF_PIR_NAME Character(40) VARCHAR2(40) NOT NULL PIR Input System Name
10 PIR_VERSION_ID Character(3) VARCHAR2(3) NOT NULL PIR Version ID
11 PIR_CLASSIFICATION Character(2) VARCHAR2(2) NOT NULL PIR Classification
BA=Adjustment
BC=Check
BI=International
BN=ACH/EFT
BW=Wire
12 PIR_SCHD_NUM Character(14) VARCHAR2(14) NOT NULL PIR Schedule Number
13 PIR_SUMM_NUM Character(6) VARCHAR2(6) NOT NULL PIR Schedule Number
14 PIR_SUMM_DT Date(10) DATE PIR Summary Date
15 PIR_VOUCHER_FRM_CD Character(4) VARCHAR2(4) NOT NULL PIR Voucher Form Code
215=Adjustment
5515=Payment
16 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
17 ALC Character(8) VARCHAR2(8) NOT NULL Agency Location Code
18 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
19 CREATION_DT Date(10) DATE Creation Date
20 IPAC_SENDER_DO Character(5) VARCHAR2(5) NOT NULL Sender Disbursing Office
21 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
22 TREASURY_PMT_NBR Number(11,0) DECIMAL(11) NOT NULL Payment Confirm Number
23 SRF_DN_PAYMENT_ID Character(20) VARCHAR2(20) NOT NULL PaymentID
24 SRF_BN_SUMM_NUM Character(6) VARCHAR2(6) NOT NULL Summary Number
25 SRF_BN_SUMM_DT Character(10) VARCHAR2(10) NOT NULL Summary Date
26 SRF_BN_C_ACCT_MY Character(4) VARCHAR2(4) NOT NULL Check Accounting Month And Year
27 SRF_BN_BC_CR_DT Character(8) VARCHAR2(8) NOT NULL Check Batch Creation Date
28 SRF_BN_C_SMBL_NUM Character(4) VARCHAR2(4) NOT NULL CheckSymbolNumber