ORGSTRUC – Organization Structure

System
General Ledger Setup (IF)
Prefix
ORG
Primary key
USER-DIM-NAME
Fields
10
Updated by
1 program
Referenced by
10 programs

ORGSTRUC is the Organization Structure table in Lawson General Ledger Setup (prefix ORG). It is indexed by USER-DIM-NAME (ORGSET1). It is related 1:1 to GLNAMES, GLSYSTEM and GLCPYGRP. It is updated by IFOS.1 and referenced by ACDL.1, ACDM.1, GLDM.1, GLDX.1, GLOP.1, HC02.1, HCDL.1, HCHP.1 and 2 more. The table has 10 fields, 1 index and 3 documented relations.

About ORGSTRUC

No description in the Lawson data dictionary.

Fields (10)

Column = COBOL field name without the ORG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ORG-USER-DIM-NAME PK
USER_DIM_NAME		Alpha 50 (Lower Case)The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.IFOS.1
ORG-ORG-PREFIX
ORG_PREFIX		Alpha 5 (Lower Case)The Type Prefix field contains a unique prefix name that differentiates the members in the Type dimension with similar members in other dimensions. This prefix can contain up to five characters of any kind.IFOS.1
ORG-ORG-ALIAS-OPT
ORG_ALIAS_OPT		Alpha 1The Organization Alias Option field contains the value that represents the alias name for the members of this dimension. Valid values are: description of accounting unit; Default value.
  • 1 Company, accounting unit, and
  • 2 Company and accounting unit
  • 3 Description of accounting unit.
IFOS.1
ORG-COMPANY
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.IFOS.1
ORG-ACCT-UNIT
ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.IFOS.1
ORG-COMPANY-GROUP
COMPANY_GROUP		Alpha 12You can type or select a company group. A company group represents one or more companies. If you select a company group, leave the Company field blank.IFOS.1
ORG-MATRIX-LIST
MATRIX_LIST		Alpha 12Attribute categories are selection parameters used to build a list of objects (accounting units). Attribute categories and values are the basis of the selection and sorting. A attribute list can then be used for reporting on and processing objects.IFOS.1
ORG-RESOLVE-FLAG
RESOLVE_FLAG		Alpha 1—IFOS.1
ORG-LV-CONCATENATE
LV_CONCATENATE		Alpha 1—IFOS.1
ORG-RAGGED-FLAG
RAGGED_FLAG		Alpha 1—IFOS.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ORGSET1USER-DIM-NAMEPrimaryACDL.1, ACDM.1, HC02.1, HCDL.1, HCHP.1, GLDM.1, GLDX.1, GLOP.1 +5 more

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AcctunitGLNAMESNot RequiredORG-COMPANY → GLN-COMPANY, ORG-ACCT-UNIT → GLN-ACCT-UNIT
CompanyGLSYSTEMNot RequiredORG-COMPANY → GLS-COMPANY
CompanygroupGLCPYGRPNot RequiredORG-COMPANY-GROUP → GCG-COMPANY-GROUP

Programs

Updated by (1)

Referenced by (10)