SCNSTRUC – No description in the Lawson data dictionary

System
General Ledger Setup (IF)
Prefix
SCN
Primary key
SCN-DIMENSION
Fields
7
Updated by
1 program
Referenced by
4 programs

SCNSTRUC is a Lawson General Ledger Setup table (prefix SCN); no description in the lawson data dictionary. It is indexed by SCN-DIMENSION (SCNSET1). It is updated by IFSS.1 and referenced by GLDM.1, GLDX.1, GLOP.1 and IFBS.1. The table has 7 fields, 1 index and 0 documented relations.

About SCNSTRUC

No description in the Lawson data dictionary.

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
SCN-SCN-DIMENSION PK
SCN_DIMENSION
Alpha 50 (Lower Case)The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 30 characters of any kind.IFSS.1
SCN-SCN-PREFIX
SCN_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.IFSS.1
SCN-SCN-ALIAS-OPT
SCN_ALIAS_OPT
Alpha 1The Products Alias Option field contains the value that represents the alias name for the members of this dimension. Valid values are:
  • 1 Prefix and Alias Name
  • 2 Alias Name
IFSS.1
SCN-ACTUALS-MBR
ACTUALS_MBR
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.IFSS.1
SCN-BUDGET-MBR
BUDGET_MBR
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.IFSS.1
SCN-COMMITMENTS
COMMITMENTS
Alpha 30 (Lower Case)IFSS.1
SCN-POSTED
POSTED
Alpha 30 (Lower Case)IFSS.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
SCNSET1SCN-DIMENSIONPrimaryGLDM.1, GLDX.1, GLOP.1, IFBS.1, IFSS.1, IFSS.2, IFSS.3

Programs

Updated by (1)

Referenced by (4)