ACHISTORY

UPDATED BY
AC10.1 AC10.3 AC112 AC113 AC12.1 AC13.1
AC13.2 AC210 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

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.
AC10.1 AC10.3
AC112 AC113
AC12.1 AC13.1
AC13.2 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.
AC10.1 AC10.3
AC112 AC113
AC12.1 AC13.1
AC13.2 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.
AC10.1 AC10.3
AC112 AC113
AC12.1 AC13.1
AC13.2 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.
AC10.1 AC10.3
AC112 AC113
AC12.1 AC13.1
AC13.2 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.
AC10.1 AC10.3
AC112 AC113
AC12.1 AC13.1
AC13.2 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
AC10.1 AC10.3
AC112 AC113
AC12.1 AC13.1
AC13.2 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
AC10.1 AC10.3
AC112 AC113
AC12.1 AC13.1
AC13.2 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
AC10.1 AC10.3
AC112 AC113
AC12.1 AC13.1
AC13.2 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)
AC10.1 AC10.3
AC112 AC113
AC12.1 AC13.1
AC13.2 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*
...
AC10.1 AC10.3
AC112 AC113
AC12.1 AC13.1
AC13.2 AC210
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
HSTSET2 ACTIVITY
FIELD-ID
DATE-STAMP
SEQ-NBR*
KeyChange


ACHISTORY FILE RELATIONS


ONE TO ONE RELATIONS

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


File created: Thu Jun 09 11:04:07 2016

Home
Contact Us



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