FILENAME: D9530F09 MASTER
DESCRIPTION: FRSV3.0 TRANSACTION FOCUS MASTER (YTD/MTD/WTD)
FIELDNAME ALIAS FORMAT DESCRIPTION FIELDTYPE
FT002 FISCAL_YEAR_TRANS
A2
FISCAL YEAR
FT003 CAMPUS_CODE_TRANS
A2
CAMPUS CODE
FT004 ACCT_TRANS
A10
ACCOUNT NUMBER
I
FT008 ACCT_6_TRANS
A6
6 DIGIT ACCOUNT NUMBER
I
FT006 ACCT_DGT1_TRANS
A1
LEDGER NUMBER
FT010 ACCT_DGT2_6_TRANS A5 FUND
FT014 ACCT_DGT7_10_TRANS
A4
SUBCODE
I
FT030 TRANS_CODE
A3
TRANSACTION CODE
FT033 TRANS_CODE_DGT1 A1 FIRST DIGIT OF TRANCODE
FT035 TRANS_CODE_DGT2
A1
SECOND DIGIT OF TRANCODE
FT036 TRANS_CODE_DGT3
A1
THIRD DIGIT OF TRANCODE
FTUCA SCHOOL
A2
SCHOOL
FTUCB DIVISION_SL
A2
SL DIVISION
FRSDEPT UNIVDEPT
A7
UNIV. DEPT W/ SUBDEPT
FTUCC DEPARTMENT
A5
UNIV. DEPT W/O SUBDEPT
FTUCD SUB_DEPARTMENT A2 SUB DEPARTMENT
FTUCE EXECUTIVE_LEVEL A2 EXECUTIVE LEVEL
FTUCF FUND_GROUP A2 FUND GROUP
FTUCG ACCOUNT_PURPOSE A2 ACCOUNT PURPOSE
FTUCH SECURITY_CODE A6 SECURITY CODE
FT040 ACCT_NUM_A A10 ACCOUNT NUMBER
FTO42 DGT1_6_A A06 ACCOUNT NUMBER
FT046 ACCT_DGT7_10_A A04 SUBCODE
FT048 REF A07 REF
FT050 TRANS_DT A04 TRANS DATE
FT051 TRANS_DT_1_2 A02 DATE 1-2
FT052 TRANS_DT_3_4 A02 DATE 3-4
FT054 DESC A20 DESCRIPTION
FT056 TRANS_AMT P11.2C Z11.2 TRANS AMT
FT058 DR_CR_IND A01 D/C IND
FT060 REF_2 A07 REF 2
FT062 CR_ACCCT_NUM A10 CR ACCT NUMBER
FT063 CR_ACCT_DGT1_6 A06 CR ACCT NUM
FT064 CR_DGT1 A01
FT065 CR_DGT2_6 A05
FT066 CR_ACCT_DGT7_10 A04 CR SUBC
FT067 TRANS_ID A11 TRANS ID
FT068 DR_CAMPUS_CODE A02 DB CC
FT069 CR_CAMPUS_CODE A02 CR CC
FT070 REF_3 A07
FT07B UC_OLD_FUND A04 UC OLD FUND
FT07C UC_OLD_SID A03 UC OLD SID
FTO7D UC_OLD_OBJ A05 UC OLD OBJ
FT07E UC_LINENO A02 UC LINE NO
FT072 AUDIT_KEY A24 AUDIT KEY
FT073 BATCH_ID A14 BATCH ID
FT074 BATCH_REF A06 BATCH REF
FT075 BATCH_DT A08 BATCH ID
FT080 UPDATE_NUM A05 UPDATE NUM
FT082 SEQ_NUM A05 SEQ NUM
FT083 CPU_DT YYMD CPU DATE
FT088 CPU_TIME A06 CPU TIME
FT089 OPERATOR_ID A04 OPER ID
FT090 TERMINAL_ID A04 TERM ID
FT092 LIQUIDATION_AMT P11.2C Z11.2 LIQUIDATION AMOUNT
FT093 DIR_INDIRECT_IND A01 D/I IND
FT094 BANK_NUM A02 BANK NUM
FT095 PROC_MONTH A02 PROC MO
FT096 BATCH_OWNER_CC A02 BATCH CC
FT097 FBD015_SEL_SW A01 FBD015 SW
FT098 SUSP_MSG_ID A05 SUSP MSG
FT10A UC_ST_BATCHNO A04 UC_ST_BATCHNO
FT10B UC_ST_DOCTYPE A02 UC_ST DOCTYPE
FT10C UC_ST_INTFLAG A01 UC_ST INTFLAG

 

508 UsableNet Approved (v. 1.2.1)