TFFILE: FIXED ASSET ACCOUNTING FEED FILE

ElementElement NameTable or FileSQL or Focus
TF001ACCTG FEED FILE KEYTFFILEFA_FEED_KEY
TF005FEED ASSET NUMBERTFFILEASSET_NUM
TF009CPU DATETFFILECPU_DT
TF010CPU DATE-6TFFILECPU_DT_6
TF011CPU YEARTFFILECPU_YY
TF012CPU MONTHTFFILECPU_MM
TF013CPU DAYTFFILECPU_DD
TF015CPU TIMETFFILECPU_TIME
TF016CPU TIME HRTFFILECPU_TIME_HR
TF017CPU TIME MINTFFILECPU_TIME_MIN
TF018CPU TIME SECTFFILECPU_TIME_SEC
TF020ASSET FEED SEQUENCETFFILESEQ_NUM
TF025FX BATCH HEADERTFFILEBATCH_ID
TF030BATCH REFERENCETFFILEBATCH_REF
TF035BATCH TRANS DATETFFILEBATCH_DT
TF036BATCH TRANS DATE-6TFFILEBATCH_DT_6
TF040BATCH DATE YEARTFFILEBATCH_YY
TF045BATCH DATE MONTHTFFILEBATCH_MM
TF050BATCH DATE DAYTFFILEBATCH_DD
TF205DEBIT ACCOUNTTFFILEACCOUNT_NUM
TF206DEBIT ACCT DIG 1-6TFFILEACCOUNT_NUM
TF210DEBIT ACCT DIG 1TFFILEACCOUNT_DIGIT_1
TF215DEBIT ACCT DIG 2-6TFFILEACCOUNT_DIGITS_2_6
TF220DEBIT ACCT DIG 7-10TFFILEACCOUNT_DIGITS_7_1
TF225CREDIT ACCOUNTTFFILEACCOUNT_NUM
TF226CREDIT ACCT DIG 1-6TFFILEACCOUNT_NUM
TF230CREDIT ACCT DIG 1TFFILEACCOUNT_DIGIT_1
TF235CREDIT ACCT DIG 2-6TFFILEACCOUNT_DIGITS_2_6
TF240CREDIT ACCT DIG 7-10TFFILEACCOUNT_DIGITS_7_1
TF245DEBIT ACCT CCTFFILECAMPUS_CODE
TF250CREDIT ACCT CCTFFILECAMPUS_CODE
TF252ACCOUNTING FYTFFILEFISCAL_YR

©2000 All Rights Reserved