Transaction Analysis Fields

From Vital Soft Wiki
Revision as of 23:30, 28 August 2012 by >Jeremyb (Created page with "'''The fields available in the Transaction Analysis application''' '''ACC_COLL''' The ACC (share) or COLLATERAL (loan) code associated with the transaction '''BRANCH''' ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

The fields available in the Transaction Analysis application

ACC_COLL

   The ACC (share) or COLLATERAL (loan) code associated with the transaction

BRANCH

   The branch number

BRANCH_NAME

   The branch name

BRANCH_PROD_RANGE

   The +/- range for the productivity target

BRANCH_PROD_TARGET

   The productivity target for the branch

COMMAND

   The command (text format)

DAY_PERIOD_SHORT_DESC

   The summary time fields -- 'Early AM', 'Morning', 'Midday', 'Evening'

DECISION_TELLER_INTL

DRAWER

   The drawer number

DRWHRS_EXISTS

   Flag - 1 indicates that a valid close file record exists for that tlr/drw/date

ENTRY_DATE

   The entry date of the transaction

ENTRY_DAY

   The day of week (1=Monday, 7=Sunday) of the transaction

ENTRY_MONTH

   The month (number) of the transaction

ENTRY_YEAR

   The year (4 digit) of the transaction

ENTRY_YM_AS_DATE

   The year and month as a cymd date (day is always 01) of the transaction

HIST_EXISTS

   Flag - 1 indicates that at least one history transaction existed for that date

HOUR_PERIOD

   Number -- 0 is 0:00-0:59, 1 is 1:00-1:59

MBR_ACCOUNT

   The account number of the transaction

ROLLING_DAY

   The rolling day including date

ROLLING_DAY_NUM

   The rolling day as a number

ROLLING_MONTH

   The rolling month including monthname

ROLLING_MONTH_NUM

   The rolling month as a number

ROLLING_WEEK

   The rolling week including date

ROLLING_WEEK_NUM

   The rolling week as a number

SEQUENCE

   The sequence number of the transaction

SH_LN_FLAG

   Flag - S is share transaciton, L is loan transaction

SUFFIX

   The account suffix of the transaction

TELLER_CODE

   The 3 letter teller code

TELLER_INTL

   The teller initials

TELLER_INTL_NAME

   Concatenation of teller initials and name

TELLER_NAME

   Name of teller

TIME_PERIOD

   The detail time period 0 30 100 130 200 230 etc

TRAN_TYPE

   The transaction type (number)

TRAN_TYPE_DESC

   The transaction description (CASH or NON-CASH)