FKFILE: FRS TRANSACTION FILE

ElementElement NameTable or FileSQL or Focus
FK003FY CC ACCTFKFILEACCOUNT_NUM
FK006FISCAL YEARFKFILEFISCAL_YR
FK009CAMPUS CODEFKFILECAMPUS_CODE
FK012ACCOUNT NUMBERFKFILEACCOUNT_NUM
FK015ACCOUNT DIGIT 1FKFILEACCOUNT_DIGIT_1
FK018ACCT DIGITS 1-6FKFILEACCOUNT_NUM
FK021ACCT DIGITS 2-6FKFILEACCOUNT_DIGITS_2_6
FK024ACCOUNT DIGIT 2FKFILEACCOUNT_DIGIT_2
FK027ACCT DIGITS 3-6FKFILEACCOUNT_DIGITS_3_6
FK030ACCT DIGITS 7-10FKFILEACCOUNT_DIGITS_7_1
FK033ACCT DIGITS 7-8FKFILEACCOUNT_DIGITS_7_8
FK036ACCT DIGIT 7FKFILEACCOUNT_DIGIT_7
FK039ACCT DIGIT 8FKFILEACCOUNT_DIGIT_8
FK042ACCT DIGIT 9FKFILEACCOUNT_DIGIT_9
FK045ACCT DIGIT 10FKFILEACCOUNT_DIGIT_10
FK048UPDATE NOFKFILEUPDATE_NUM
FK051BATCH NOFKFILEBATCH_ID
FK054BATCH REFFKFILEBATCH_REF
FK057BATCH DATEFKFILEBATCH_DT
FK058BATCH DATE-6FKFILEBATCH_DT_6
FK060SEQ NOFKFILESEQ_NUM
FK063AMOUNT SIGNFKFILEAMT_SIGN
FK066FY CC ACCTFKFILEACCOUNT_NUM
FK069FISCAL YEARFKFILEFISCAL_YR
FK072CAMPUS CODEFKFILECAMPUS_CODE
FK075ACCOUNT NUMBERFKFILEACCOUNT_NUM
FK078ACCOUNT DIGIT 1FKFILEACCOUNT_DIGIT_1
FK081ACCT DIGITS 1-6FKFILEACCOUNT_NUM
FK084ACCT DIGITS 2-6FKFILEACCOUNT_DIGITS_2_6
FK087ACCOUNT DIGIT 2FKFILEACCOUNT_DIGIT_2
FK090ACCT DIGITS 3-6FKFILEACCOUNT_DIGITS_3_6
FK093ACCT DIGITS 7-10FKFILEACCOUNT_DIGITS_7_1
FK096ACCT DIGITS 7-8FKFILEACCOUNT_DIGITS_7_8
FK099ACCT DIGIT 7FKFILEACCOUNT_DIGIT_7
FK102ACCT DIGIT 8FKFILEACCOUNT_DIGIT_8
FK105ACCT DIGIT 9FKFILEACCOUNT_DIGIT_9
FK108ACCT DIGIT 10FKFILEACCOUNT_DIGIT_10
FK111CD-TC-ALLFKFILETRANS_CODE
FK114CD TC-0FKFILETRANS_DIGIT_1
FK117CD TCFKFILETRANS_DIGIT_2_3
FK120CD TC-1FKFILETRANS_DIGIT_1
FK123CD TC-2FKFILETRANS_DIGIT_2
FK126CD ACCTFKFILEACCOUNT_NUM
FK129CD ACCT-1-6FKFILEACCOUNT_NUM
FK132CD ACCT-1FKFILEACCOUNT_DIGIT_1
FK135CD ACCT-2-6FKFILEACCOUNT_DIGITS_2_6
FK138CD ACCT-7-10FKFILEACCOUNT_DIGITS_7_1
FK141CD REFERENCEFKFILEREF_NUM
FK144CD DATEFKFILETRANS_DT
FK147CD DATE-1-2FKFILETRANS_DT_1_2
FK150CD DATE-3-4FKFILETRANS_DT_3_4
FK153CD DESCRIPTIONFKFILETRANS_DESC
FK156CD AMOUNT-XFKFILETRANS_AMOUNT
FK159CD D/C INDICATORFKFILED_C_IND
FK162CD REF-2FKFILEREF_NUM
FK165CD CR-ACCTFKFILEACCOUNT_NUM
FK168CD CR-ACCT-1-6FKFILEACCOUNT_NUM
FK171CD CR-ACCT-1FKFILEACCOUNT_DIGIT_1
FK174CD CR-ACCT-2-6FKFILEACCOUNT_DIGITS_2_6
FK177CD CR-ACCT-7-10FKFILEACCOUNT_DIGITS_7_1
FK180CD ID-FIELDFKFILETRANS_REF
FK183CD DR-CCFKFILECAMPUS_CODE
FK186CD CR-CCFKFILECAMPUS_CODE
FK187CD REF-3FKFILETRANS_REF_3
FK192ONLINE ALT KEYFKFILEONLINE_ALT_KEY
FK195OAK BATCHFKFILEBATCH_REF
FK198OAK BATCH REFERENCEFKFILEBATCH_REF
FK201OAK BATCH DATEFKFILEBATCH_DT
FK202OAK BATCH DATE-6FKFILEBATCH_DT_6
FK204OAK BATCH-YYFKFILEBATCH_YY
FK207OAK BATCH-MMFKFILEBATCH_MM
FK210OAK BATCH-DDFKFILEBATCH_DD
FK213OAK YTD UPDATE NOFKFILEYTD_UPDATE_NUM
FK216OAK SEQUENCEFKFILESEQ_NUM
FK219CPU DATEFKFILECPU_DT
FK220CPU DATE-6FKFILECPU_DT_6
FK222CPU-YYFKFILECPU_YY
FK225CPU-MMFKFILECPU_MM
FK228CPU-DDFKFILECPU_DD
FK231CPU TIMEFKFILECPU_TIME
FK234OPERATOR IDFKFILEOPERATOR_ID
FK237TERMINAL IDFKFILETERMINAL_ID
FK2404X LIQ AMOUNTFKFILELIQUIDATION_AMT
FK243D-I INDICATORFKFILED_I_IND
FK246BANK NUMBERFKFILEBANK_NUM
FK249PROC MONTHFKFILEPROC_MONTH
FK252BATCH OWNER CCFKFILECAMPUS_CODE
FK255FBD015-SEL-SWFKFILEFBD015_SEL_SW
FK257SUSPENSE MESSAGE IDFKFILESUSP_MESSAGE_ID
FK503FY CC ACCTFKFILEACCOUNT_NUM
FK506FISCAL YEARFKFILEFISCAL_YR
FK509CAMPUS CODEFKFILECAMPUS_CODE
FK512ACCOUNT NUMBERFKFILEACCOUNT_NUM
FK515UPDATE NOFKFILEUPDATE_NUM
FK518BATCH NOFKFILEBATCH_ID
FK521BATCH REFFKFILEBATCH_REF
FK524BATCH DATEFKFILEBATCH_DT
FK525BATCH DATE-6FKFILEBATCH_DT_6
FK527SEQ NOFKFILESEQ_NUM
FK530AMOUNT SIGNFKFILEAMT_SIGN
FK533FY CC ACCTFKFILEACCOUNT_NUM
FK536FISCAL YEARFKFILEFISCAL_YR
FK539CAMPUS CODEFKFILECAMPUS_CODE
FK542ACCOUNT NUMBERFKFILEACCOUNT_NUM
FK545CD-TC-ALLFKFILETRANS_CODE
FK548BATCH NOFKFILEBATCH_ID
FK551BATCH REFFKFILEBATCH_REF
FK554BATCH DATEFKFILEBATCH_DT
FK555BATCH DATE-6FKFILEBATCH_DT_6
FK557BATCH DESCFKFILEBATCH_DESC
FK560BATCH LISTFKFILEBATCH_LIST_FLAG
FK563BATCH USERFKFILEFR_USER_CODE
FK566TRANS COUNTFKFILETRANS_COUNT
FK569DOLLAR AMOUNTFKFILETRANS_AMOUNT
FK572BATCH IDFKFILEBATCH_ID
FK578BATCH ORIGINATORFKFILEBATCH_ORIGINATOR
FK581BATCH BANKFKFILEBATCH_BANK
FK596BATCH SPECIAL PROCESFKFILESPECIAL_PROCESS
FK599BATCH FYFKFILEFISCAL_YR
FK602BATCH CCFKFILECAMPUS_CODE
FK605BATCH APPROVAL IDFKFILEBATCH_APPROVAL_ID
FK608BATCH APPROVAL DATEFKFILEBATCH_APPROVAL_DT
FK609BATCH APPROVAL DAT-6FKFILEBATCH_APPROVAL_DT_
FK614ONLINE ALT KEYFKFILEONLINE_ALT_KEY
FK617OAK BATCHFKFILEBATCH_ID
FK620OAK BATCH REFERENCEFKFILEBATCH_REF
FK623OAK BATCH DATEFKFILEBATCH_DT
FK624OAK BATCH DATE-6FKFILEBATCH_DT_6
FK627OAK BATCH-YYFKFILEBATCH_YY
FK630OAK BATCH-MMFKFILEBATCH_MM
FK633OAK BATCH-DDFKFILEBATCH_DD
FK636OAK YTD UPDATE NOFKFILEYTD_UPDATE_NUM
FK639OAK SEQUENCEFKFILESEQ_NUM
FK642CPU DATEFKFILECPU_DT
FK643CPU DATE-6FKFILECPU_DT_6
FK645CPU-YYFKFILECPU_YY
FK648CPU-MMFKFILECPU_MM
FK651CPU-DDFKFILECPU_DD
FK654CPU TIMEFKFILECPU_TIME
FK657OPERATOR IDFKFILEOPERATOR_ID
FK660TERMINAL IDFKFILETERMINAL_ID
FK6634X LIQ AMOUNTFKFILELIQUIDATION_AMT
FK666D-I INDICATORFKFILED_I_IND
FK669BANK NUMBERFKFILEBANK_NUM
FK672PROC MONTHFKFILEPROC_MONTH
FK675BATCH OWNER CCFKFILECAMPUS_CODE
FK678FBD015-SEL-SWFKFILEFBD015_SEL_SW
FK681SUSPENSE MESSAGE IDFKFILESUSP_MESSAGE_ID

©2000 All Rights Reserved