SRF_SRC_DT

(SQL Table)
Index Back

SRF_SRC_DT

DEIU source table for DT 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 ORIGINAL_FUND Character(5) VARCHAR2(5) NOT NULL Originating Fund
6 SPS_TAS Character(27) VARCHAR2(27) NOT NULL Sender Treasury Account Symbol
7 SPS_BETC Character(8) VARCHAR2(8) NOT NULL Sender Business Event Type
8 SRF_DT_PAYMNT_ID Character(20) VARCHAR2(20) NOT NULL PaymentID
9 SUB_LEVEL_CD Character(2) VARCHAR2(2) NOT NULL Sub level prefix code
10 ALLO_TR_AGENCY Character(3) VARCHAR2(3) NOT NULL Allocation Transfer Agency Identifier
11 AGENCY_ID1 Character(3) VARCHAR2(3) NOT NULL TAS agency id
12 BEGIN_PERIOD_AVAIL Character(4) VARCHAR2(4) NOT NULL Beginning Period of Availability (BPOA)
13 END_PERIOD_AVAIL Character(4) VARCHAR2(4) NOT NULL Ending Period of Availability (EPOA)
14 AVAIL_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Availability Type Code
A=Treasury cental smmry account
C=Cancelled
F=Clearing/suspense account
M=Merged surplus account
X=No-year account
15 MAIN_ACCOUNT Character(4) VARCHAR2(4) NOT NULL Main Account TAS
16 SUB_ACCOUNT Character(3) VARCHAR2(3) NOT NULL Sub Account TAS
17 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount