FTFILE: FRS TRANSACTION HISTORY FILE

ElementElement NameTable or FileSQL or Focus
FT001FY CC ACCTFTFILEACCOUNT_NUM
FT002FISCAL YEARFTFILEFISCAL_YR
FT003CAMPUS CODEFTFILECAMPUS_CODE
FT004ACCOUNT NUMBERFTFILEACCOUNT_NUM
FT006ACCOUNT DIGIT 1FTFILEACCOUNT_DIGIT_1
FT008ACCT DIGITS 1-6FTFILEACCOUNT_NUM
FT010ACCT DIGITS 2-6FTFILEACCOUNT_DIGITS_2_6
FT012ACCOUNT DIGIT 2FTFILEACCOUNT_DIGIT_2
FT013ACCT DIGITS 3-6FTFILEACCOUNT_DIGITS_3_6
FT014ACCT DIGITS 7-10FTFILEACCOUNT_DIGITS_7_1
FT016ACCT DIGITS 7-8FTFILEACCOUNT_DIGITS_7_8
FT018ACCT DIGIT 7FTFILEACCOUNT_DIGIT_7
FT020ACCT DIGIT 8FTFILEACCOUNT_DIGIT_8
FT022ACCT DIGIT 9FTFILEACCOUNT_DIGIT_9
FT023ACCT DIGIT 10FTFILEACCOUNT_DIGIT_10
FT030CD-TC-ALLFTFILETRANS_CODE
FT033CD TC-0FTFILETRANS_DIGIT_1
FT034CD TCFTFILETRANS_DIGIT_2_3
FT035CD TC-1FTFILETRANS_DIGIT_1
FT036CD TC-2FTFILETRANS_DIGIT_2
FT040CD ACCTFTFILEACCOUNT_NUM
FT042CD ACCT-1-6FTFILEACCOUNT_NUM
FT043CD ACCT-1FTFILEACCOUNT_DIGIT_1
FT044CD ACCT-2-6FTFILEACCOUNT_DIGITS_2_6
FT046CD ACCT-7-10FTFILEACCOUNT_DIGITS_7_1
FT048CD REFERENCEFTFILEREF_NUM
FT050CD DATEFTFILETRANS_DT
FT051CD DATE-1-2FTFILETRANS_DT_1_2
FT052CD DATE-3-4FTFILETRANS_DT_3_4
FT054CD DESCRIPTIONFTFILETRANS_DESC
FT056CD AMOUNT-XFTFILETRANS_AMOUNT
FT058CD D/C INDICATORFTFILED_C_IND
FT060CD REF-2FTFILEREF_NUM
FT062CD CR-ACCTFTFILEACCOUNT_NUM
FT063CD CR-ACCT-1-6FTFILEACCOUNT_NUM
FT064CD CR-ACCT-1FTFILEACCOUNT_DIGIT_1
FT065CD CR-ACCT-2-6FTFILEACCOUNT_DIGITS_2_6
FT066CD CR-ACCT-7-10FTFILEACCOUNT_DIGITS_7_1
FT067CD ID-FIELDFTFILETRANS_REF
FT068CD DR-CCFTFILECAMPUS_CODE
FT069CD CR-CCFTFILECAMPUS_CODE
FT070CD REF-3FTFILETRANS_REF_3
FT072ONLINE ALT KEYFTFILEONLINE_ALT_KEY
FT073OAK BATCHFTFILEBATCH_REF
FT074OAK BATCH REFERENCEFTFILEBATCH_REF
FT075OAK BATCH DATEFTFILEBATCH_DT
FT076OAK BATCH DATE-6FTFILEBATCH_DT_6
FT077OAK BATCH-YYFTFILEBATCH_YY
FT078OAK BATCH-MMFTFILEBATCH_MM
FT079OAK BATCH-DDFTFILEBATCH_DD
FT080OAK YTD UPDATE NOFTFILEYTD_UPDATE_NUM
FT082OAK SEQUENCEFTFILESEQ_NUM
FT083CPU DATEFTFILECPU_DT
FT084CPU DATE-6FTFILECPU_DT_6
FT085CPU-YYFTFILECPU_YY
FT086CPU-MMFTFILECPU_MM
FT087CPU-DDFTFILECPU_DD
FT088CPU TIMEFTFILECPU_TIME
FT089OPERATOR IDFTFILEOPERATOR_ID
FT090TERMINAL IDFTFILETERMINAL_ID
FT0924X LIQ AMOUNTFTFILELIQUIDATION_AMT
FT093D-I INDICATORFTFILED_I_IND
FT094BANK NUMBERFTFILEBANK_NUM
FT095PROC MONTHFTFILEBANK_NUM
FT096BATCH OWNER CCFTFILEPROC_MONTH
FT097FBD015-SEL-SWFTFILECAMPUS_CODE
FT098SUSPENSE MESSAGE IDFTFILEFBD015_SEL_SW
FT101FY CC ACCTFTFILEACCOUNT_NUM
FT102FISCAL YEARFTFILEFISCAL_YR
FT103CAMPUS CODEFTFILECAMPUS_CODE
FT104ACCOUNT NUMBERFTFILEACCOUNT_NUM
FT106ACCOUNT DIGIT 1FTFILEACCOUNT_DIGIT_1
FT108ACCT DIGITS 1-6FTFILEACCOUNT_NUM
FT110ACCT DIGITS 2-6FTFILEACCOUNT_DIGITS_2_6
FT112ACCOUNT DIGIT 2FTFILEACCOUNT_DIGIT_2
FT113ACCT DIGITS 3-6FTFILEACCOUNT_DIGITS_3_6
FT114ACCT DIGITS 7-10FTFILEACCOUNT_DIGITS_7_1
FT116ACCT DIGITS 7-8FTFILEACCOUNT_DIGITS_7_8
FT118ACCT DIGIT 7FTFILEACCOUNT_DIGIT_7
FT120ACCT DIGIT 8FTFILEACCOUNT_DIGIT_8
FT122ACCT DIGIT 9FTFILEACCOUNT_DIGIT_9
FT123ACCT DIGIT 10FTFILEACCOUNT_DIGIT_10
FT128BB BAT-REF-DATEFTFILEBATCH_DT
FT130BB BAT-REF-NOFTFILEBATCH_REF
FT131BB BAT-DATEFTFILEBATCH_DT
FT132BB BAT-DATE-6FTFILEBATCH_DT_6
FT133BB BAT-1-2FTFILEBATCH_MM
FT134BB BAT-3-4FTFILEBATCH_DD
FT135BB BAT-5-6FTFILEBATCH_YY
FT136BB BAT-DESCFTFILEBATCH_DESC
FT138BB BAT-LISTFTFILELIST_BATCH
FT140BB BAT-USERFTFILEHR_USER_CODE
FT142BB BAT-COUNTFTFILEBATCH_COUNT
FT144BB BAT-DOL-AMTFTFILEBATCH_AMT
FT146BB BAT-IDFTFILEBATCH_REF
FT150BB BAT-ORIGFTFILEBATCH_ORIGINATOR
FT152BB BAT-BANKFTFILEBANK_NUM
FT155BB BAT-SPECIAL-PROCEFTFILESPECIAL_PROCESS
FT156BB BAT-FYFTFILEFISCAL_YR
FT157BB BAT-CCFTFILECAMPUS_CODE
FT158BB APPROVAL IDFTFILEAPRVL_ID
FT159BB APPROVAL DATEFTFILEAPRVL_DT
FT160BB APPROVAL DATE-6FTFILEAPRVL_DT_6
FT165ONLINE ALT KEYFTFILEONLINE_ALT_KEY
FT166OAK BATCHFTFILEBATCH_REF
FT168OAK BATCH REFERENCEFTFILEBATCH_REF
FT169OAK BATCH DATEFTFILEBATCH_DT
FT170OAK BATCH DATE-6FTFILEBATCH_DT_6
FT171OAK BATCH-YYFTFILEBATCH_YY
FT172OAK BATCH-MMFTFILEBATCH_MM
FT173OAK BATCH-DDFTFILEBATCH_DD
FT174OAK YTD UPDATE NOFTFILEUPDATE_NUM
FT176OAK SEQUENCEFTFILESEQ_NUM
FT177CPU DATEFTFILECPU_DT
FT178CPU DATE-6FTFILECPU_DT_6
FT179CPU-YYFTFILECPU_YY
FT180CPU-MMFTFILECPU_MM
FT181CPU-DDFTFILECPU_DD
FT182CPU TIMEFTFILECPU_TIME
FT183OPERATOR IDFTFILEOPERATOR_ID
FT184TERMINAL IDFTFILETERMINAL_ID
FT1864X LIQ AMOUNTFTFILELIQUIDATION_AMT
FT190D-I INDICATORFTFILED_I_IND
FT192BANK NUMBERFTFILEBANK_NUM
FT194PROC MONTHFTFILEPROC_MONTH
FT195BATCH OWNER CCFTFILECAMPUS_CODE
FT196FBD015-SEL-SWFTFILEFBD015_SEL_SW
FT197SUSP MSG IDFTFILESUSP_MSG_ID

©2000 All Rights Reserved