SCNSTRUCX – No description in the Lawson data dictionary

System
General Ledger Setup (IF)
Prefix
SCX
Primary key
SCN-DIMENSION, MBR-TYPE, SEQUENCE, BUDGET-NBR, MBR-NAME
Fields
13
Updated by
2 programs
Referenced by
2 programs

SCNSTRUCX is a Lawson General Ledger Setup table (prefix SCX); no description in the lawson data dictionary. It is indexed by SCN-DIMENSION, MBR-TYPE, SEQUENCE, BUDGET-NBR, MBR-NAME (SCXSET1); alternate indexes: SCXSET2. It is updated by IFSS.2 and IFSS.3 and referenced by GLOP.1 and IFBS.1. The table has 13 fields, 2 indexes and 0 documented relations.

About SCNSTRUCX

No description in the Lawson data dictionary.

Fields (13)

Column = COBOL field name without the SCX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#SCX-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.2, IFSS.3
#SCX-MBR-TYPE PK
MBR_TYPE		Alpha 2The Member Type field specifies the member type. Valid values are:
  • BD Budget
  • BV Budget Variance
  • CH Alternate Chart
  • FY Fiscal Year
  • PD Period
  • PY Period Year-to-Date
  • QR Quarter
  • QY Quarter Year-to-Date
  • SA Subaccount
  • VW View
  • YV Year Variance
IFSS.2, IFSS.3
#SCX-SEQUENCE PK
SEQUENCE		Numeric 6The Sequence field show the sequence of a member as it is entered in either the Budget Member Names or Fiscal Year Variances subforms in AC87.1 (Financial OLAP Dimensions).IFSS.2, IFSS.3
#SCX-BUDGET-NBR PK
BUDGET_NBR		Numeric 3The Budget Number field contains the budget number.IFSS.2, IFSS.3
#SCX-MBR-NAME PK
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.IFSS.3
#SCX-ALIAS-MBR-NAME SET2
ALIAS_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.IFSS.2, IFSS.3
#SCX-BUD-AMT-PCT
BUD_AMT_PCT		Alpha 1—IFSS.3
#SCX-BUDGET-TYPE
BUDGET_TYPE		Alpha 1—IFSS.3
#SCX-BUDGET-1
BUDGET_1		Numeric 3—IFSS.3
#SCX-BUDGET-2
BUDGET_2		Numeric 3—IFSS.3
#SCX-CURRENCY-TYPE
CURRENCY_TYPE		Alpha 1This field identifies the type of currency included. You can select Base currency or Transaction currency.IFSS.2
#SCX-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).IFSS.2
#SCX-TRAN-CURRENCY
TRAN_CURRENCY		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).IFSS.2

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
SCXSET1
  1. SCN-DIMENSION
  2. MBR-TYPE
  3. SEQUENCE
  4. BUDGET-NBR
  5. MBR-NAME
PrimaryGLOP.1, IFBS.1, IFSS.1, IFSS.2, IFSS.3
SCXSET2
  1. SCN-DIMENSION
  2. ALIAS-MBR-NAME
KeyChange, SubsetWhere ALIAS-MBR-NAME != SpacesIFSS.2, IFSS.3

Programs

Updated by (2)

Referenced by (2)