ACHISTORY

Activity Audit

REFERENCED BY
AC210 AC88.2


UPDATED BY
AC00.1 AC10.1 AC10.3 AC110 AC112 AC113
AC12.1 AC120 AC13.1 AC13.2 AC300 AC305
AC500 BR00.1 BR00.2 BR00.3 BR01.1 BR01.2
BR02.1 BR02.2 BR03.1 BR03.2 BR03.3 BR05.2
BR05.3 BR05.4 BR05.5 BR10.1 BR10.2 BR10.3
BR10.9 BR54.2 BR54.3 BR54.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HST-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
AC00.1 AC10.1
AC10.3 AC110
AC112 AC113
AC12.1 AC120
AC13.1 AC13.2
AC300 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4
HST-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
AC00.1 AC10.1
AC10.3 AC110
AC112 AC113
AC12.1 AC120
AC13.1 AC13.2
AC300 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4
HST-OPERATOR
Element: Operator
Alpha 10
This field is used to store the login id of the person who entered the record.
AC00.1 AC10.1
AC10.3 AC110
AC112 AC113
AC12.1 AC120
AC13.1 AC13.2
AC300 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4
HST-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
AC00.1 AC10.1
AC10.3 AC110
AC112 AC113
AC12.1 AC120
AC13.1 AC13.2
AC300 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4
HST-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
AC00.1 AC10.1
AC10.3 AC110
AC112 AC113
AC12.1 AC120
AC13.1 AC13.2
AC300 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4
HST-FIELD-ID
Element: Field Id
Numeric 3

014 = Previous Begin Date
015 = Previous End Date
AC00.1 AC10.1
AC10.3 AC110
AC112 AC113
AC12.1 AC120
AC13.1 AC13.2
AC300 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4
HST-ALPHA-IMAGE
Element: Alpha Image
Alpha 30
AC00.1 AC10.1
AC10.3 AC110
AC112 AC113
AC12.1 AC120
AC13.1 AC13.2
AC300 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4
HST-NUMERIC-IMAGE
Element: Intl Cost
Signed 18.5
AC00.1 AC10.1
AC10.3 AC110
AC112 AC113
AC12.1 AC120
AC13.1 AC13.2
AC300 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4
HST-DATE-IMAGE
Element: Date Image
Numeric 8 (yyyymmdd)
AC00.1 AC10.1
AC10.3 AC110
AC112 AC113
AC12.1 AC120
AC13.1 AC13.2
AC300 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4
HST-ACTION
Element: Action
Alpha 1
AC00.1 AC10.1
AC10.3 AC110
AC112 AC113
AC12.1 AC120
AC13.1 AC13.2
AC300 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4
HST-PROGRAM
Element: Program
Alpha 5
AC00.1 AC10.1
AC10.3 AC110
AC112 AC113
AC12.1 AC120
AC13.1 AC13.2
AC300 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4
HST-FIELD-NAME
Element: Fld Name
Alpha 15
AC00.1 AC10.1
AC10.3 AC110
AC112 AC113
AC12.1 AC120
AC13.1 AC13.2
AC300 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4
HST-ALPHA-NEW
Element: Alpha Image
Alpha 30
AC00.1 AC10.1
AC10.3 AC110
AC112 AC113
AC12.1 AC120
AC13.1 AC13.2
AC300 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4
HST-NUMERIC-NEW
Element: Intl Cost
Signed 18.5
AC00.1 AC10.1
AC10.3 AC110
AC112 AC113
AC12.1 AC120
AC13.1 AC13.2
AC300 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4
HST-DATE-NEW
Element: Date Image
Numeric 8 (yyyymmdd)
AC00.1 AC10.1
AC10.3 AC110
AC112 AC113
AC12.1 AC120
AC13.1 AC13.2
AC300 AC500
BR00.1 BR00.2
BR00.3 BR01.1
BR01.2 BR02.1
BR02.2 BR03.1
BR03.2 BR03.3
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR10.3 BR10.9
BR54.2 BR54.3
BR54.4


ACHISTORY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HSTSET1 ACTIVITY
DATE-STAMP
SEQ-NBR*
...
AC00.1 AC10.1
AC10.3 AC110
AC112 AC113
AC12.1 AC120
AC13.1 AC13.2
AC300 AC305
AC500 BR00.1
BR00.2 BR00.3
BR01.1 BR01.2
BR02.1 BR02.2
BR03.1 BR03.2
BR03.3 BR05.2
BR05.3 BR05.4
BR05.5 BR10.1
BR10.2 BR10.3
HSTSET2 ACTIVITY
FIELD-ID
DATE-STAMP
SEQ-NBR*
KeyChange
HSTSET3 ACTIVITY
DATE-STAMP
OPERATOR
SEQ-NBR
AC210 AC305
AC88.2


ACHISTORY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
HST-ACTIVITY->ACV-ACTIVITY


File created: Thu Jun 09 02:03:05 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.