|
|
HRIAMBR FILE
UPDATED BY
HC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HIM-DATA-MART-NAME Alpha 20 (Lower Case)
Element: Data Mart NameThis field contains the name of the data
mart.
HIM-DIM-TYPE Numeric 3
Element: Dim Type
HIM-MEMBER-TYPE Numeric 3
Element: Member Type
HIM-SEQ-NBR Numeric 4
Element: Seq Nbr An automatically assigned sequence
number.
HIM-MBR-USE Alpha 1
Element: Mbr Use
HIM-MBR-NAME Alpha 30 (Lower Case)
Element: Mbr Name The Member Name field contains the
user-defined member name for the income
statement member. This name can contain
up to 30 characters of any kind.
HIM-MBR-ALIAS-NAME Alpha 30 (Lower Case)
Element: Actuals Mbr The Actuals Member field contains the
user-defined name for the Actuals member
of the Scenarios dimension. This name
can contain up to 30 characters of any
kind.
HIM-TYPE Alpha 2
Element: Type This identifies whether this record is
created because of a picking
transaction, or because of a return.
Valid values are:
"IS" = Picking transaction.
"RR" = Return.
~$1 VENDOR
The vendor's identification code.
HIM-PAY-CLASS Alpha 3
Element: Pay Class
HIM-PAY-SUM-GRP Alpha 3
Element: Pay Sum Grp
HIM-DATE-1 Numeric 8 (yyyymmdd)
Element: Date 1
HIM-DATE-2 Numeric 8 (yyyymmdd)
Element: Date 2
HIM-FACTOR-1 Signed 7.2
Element: Factor 1
HIM-SELECTION Alpha 100
Element: Selection
HIM-DATE-STAMP Numeric 8 (yyyymmdd)
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
HIM-TIME-STAMP Numeric 6 (hhmmss)
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
HIM-USER-ID Alpha 10 (Lower Case)
Element: User
HRIAMBR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HIMSET1 DATA-MART-NAME HC10.1
DIM-TYPE
MEMBER-TYPE
SEQ-NBR
HRIAMBR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Dimension HRIADIM Required
HIM-DATA-MART-NAME -> HID-DATA-MART-NAME
HIM-DIM-TYPE -> HID-DIM-TYPE
Olap Db OLAPDBM Required
HIM-DATA-MART-NAME -> ODB-DATA-MART-NAME
Pay Class PAYCLASS Required
When HIM-PAY-CLASS != Spaces
HID-COMPANY -> PCL-COMPANY
HIM-PAY-CLASS -> PCL-PAY-CLASS
Pay Sum Grp PAYSUMGRP Required
When HIM-PAY-SUM-GRP != Spaces
HID-COMPANY -> PSG-COMPANY
HIM-PAY-SUM-GRP -> PSG-PAY-SUM-GRP
HRIAMBR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pay Classes PSGRELATE
Valid When HIM-PAY-SUM-GRP != Spaces
HID-COMPANY -> PSR-COMPANY
HIM-PAY-SUM-GRP -> PSR-PAY-SUM-GRP
PSR-PAY-CLASS
|
