|
|
HRIAMBR FILE
REFERENCED BY
HCMS.1 HCMS.2 HCOP.1 HCOP.2 HCTM.1 HCUF.1
UPDATED BY
HC01.1 HC01.2 HC02.1 HC02.2 HC02.3 HCEM.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HIM-DATA-MART-NAME Alpha 20 (Lower Case) HC01.1 HC01.2
Element: Data Mart Name HC02.1 HC02.2
HC02.3 HCEM.1
HIM-DIM-TYPE Numeric 3 HC01.1 HC01.2
Element: Dim Type HC02.1 HC02.2
HC02.3 HCEM.1
HIM-MEMBER-TYPE Numeric 3 HC01.1 HC01.2
Element: Member Type HC02.1 HC02.2
HC02.3 HCEM.1
HIM-SEQ-NBR Numeric 4 HC01.2 HC02.2
Element: Sequence NumbeAn automatically assigned sequence HC02.3 HCEM.1
number.
HIM-MBR-USE Alpha 1 HC01.1 HC01.2
Element: Mbr Use HC02.1 HC02.2
HC02.3 HCMS.1
HIM-MBR-NAME Alpha 30 (Lower Case) HC01.1 HC01.2
Element: Member Name The Member Name field contains the HC02.1 HC02.2
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) HC01.1 HC01.2
Element: Actuals Mbr HC02.1
HIM-TYPE Alpha 2 HC01.1 HC01.2
Element: Type This identifies whether this record is HC02.1 HC02.2
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 HC01.2
Element: Payment Class
HIM-PAY-SUM-GRP Alpha 3 HC01.2
Payment Summary
Group
HIM-DATE-1 Numeric 8 (yyyymmdd) HC01.1 HC01.2
Element: Date 1
HIM-DATE-2 Numeric 8 (yyyymmdd) HC01.2
Element: Date 2
HIM-FACTOR-1 Signed 7.2 HC01.2
Element: Factor 1
HIM-SELECTION Alpha 100 HC01.1 HC01.2
Element: Selection HC02.1 HC02.2
HC02.3 HCEM.1
HIM-DATE-STAMP Numeric 8 (yyyymmdd) HC01.1 HC01.2
Element: Date Stamp This field contains the server date HC02.1 HC02.2
(month, date, and year) of the last HC02.3 HCEM.1
change to this record.
HIM-TIME-STAMP Numeric 6 (hhmmss) HC01.1 HC01.2
Element: Time Stamp Contains the server time (hour, minute, HC02.1 HC02.2
and second) when the record was last HC02.3 HCEM.1
changed.
HIM-USER-ID Alpha 10 (Lower Case) HC01.1 HC01.2
Element: User HC02.1 HC02.2
HC02.3
HRIAMBR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HIMSET1 DATA-MART-NAME HC01.1 HC01.2
DIM-TYPE HC02.1 HC02.2
MEMBER-TYPE HC02.3 HCEM.1
SEQ-NBR HCMS.1 HCMS.2
HCOP.1 HCOP.2
HCTM.1 HCUF.1
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
|
