HRIAMBR

UPDATED BY
HC10.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HIM-DATA-MART-NAME
Element: Data Mart Name
Alpha 20 (Lower Case)
This field contains the name of the data mart.
HIM-DIM-TYPE
Element: Dim Type
Numeric 3
HIM-MEMBER-TYPE
Element: Member Type
Numeric 3
HIM-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
HIM-MBR-USE
Element: Mbr Use
Alpha 1
HIM-MBR-NAME
Element: Mbr Name
Alpha 30 (Lower Case)
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
Element: Actuals Mbr
Alpha 30 (Lower Case)
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
Element: Type
Alpha 2
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
Element: Pay Class
Alpha 3
HIM-PAY-SUM-GRP
Element: Pay Sum Grp
Alpha 3
HIM-DATE-1
Element: Date 1
Numeric 8 (yyyymmdd)
HIM-DATE-2
Element: Date 2
Numeric 8 (yyyymmdd)
HIM-FACTOR-1
Element: Factor 1
Signed 7.2
HIM-SELECTION
Element: Selection
Alpha 100
HIM-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.
HIM-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
HIM-USER-ID
Element: User
Alpha 10 (Lower Case)


HRIAMBR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HIMSET1 DATA-MART-NAME
DIM-TYPE
MEMBER-TYPE
SEQ-NBR
HC10.1


HRIAMBR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Wed Jun 08 20:49:08 2016

Home
Contact Us



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