ZIFXREF – No description in the Lawson data dictionary

System
General Ledger Setup (IF)
Prefix
XRF
Primary key
COMPANY, CODE-1, CODE-2, VALUE-NUM-1, VALUE-ALPHA-1
Fields
52
Updated by
0 programs
Referenced by
0 programs

ZIFXREF is a Lawson General Ledger Setup table (prefix XRF); no description in the lawson data dictionary. It is indexed by COMPANY, CODE-1, CODE-2, VALUE-NUM-1, VALUE-ALPHA-1 (XRFSET1). The table has 52 fields, 1 index and 0 documented relations.

About ZIFXREF

No description in the Lawson data dictionary.

Fields (52)

Column = COBOL field name without the XRF- 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
#XRF-COMPANY PK
COMPANY		Numeric 4——
#XRF-CODE-1 PK
CODE_1		Alpha 10——
#XRF-CODE-2 PK
CODE_2		Alpha 10——
#XRF-VALUE-NUM-1 PK
VALUE_NUM_1		Numeric 9——
#XRF-VALUE-ALPHA-1 PK
VALUE_ALPHA_1		Alpha 10——
#XRF-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)——
#XRF-DESCRIPTION2
DESCRIPTION2		Alpha 30 (Lower Case)——
#XRF-X-ALPHA-01
X_ALPHA_01		Alpha 5——
#XRF-X-ALPHA-02
X_ALPHA_02		Alpha 10——
#XRF-X-ALPHA-03
X_ALPHA_03		Alpha 15——
#XRF-X-ALPHA-04
X_ALPHA_04		Alpha 3——
#XRF-X-ALPHA-05
X_ALPHA_05		Alpha 1——
#XRF-X-NUMERIC-01
X_NUMERIC_01		Numeric 4——
#XRF-X-NUMERIC-02
X_NUMERIC_02		Numeric 5——
#XRF-X-NUMERIC-03
X_NUMERIC_03		Numeric 6——
#XRF-X-NUMERIC-04
X_NUMERIC_04		Numeric 8——
#XRF-X-NUMERIC-05
X_NUMERIC_05		Numeric 12——
#XRF-X-SIGNED-01
X_SIGNED_01		Signed 5.3——
#XRF-X-SIGNED-02
X_SIGNED_02		Signed 7.2——
#XRF-X-SIGNED-03
X_SIGNED_03		Signed 9.2——
#XRF-X-SIGNED-04
X_SIGNED_04		Signed 11.2——
#XRF-X-SIGNED-05
X_SIGNED_05		Signed 13.5——
#XRF-X-DATE-01
X_DATE_01		Numeric 8 (yyyymmdd)——
#XRF-X-DATE-02
X_DATE_02		Numeric 8 (yyyymmdd)——
#XRF-X-DATE-03
X_DATE_03		Numeric 8 (yyyymmdd)——
#XRF-X-DATE-04
X_DATE_04		Numeric 8 (yyyymmdd)——
#XRF-X-DATE-05
X_DATE_05		Numeric 8 (yyyymmdd)——
#XRF-OPER-CODE
OPER_CODE		Alpha 1——
#XRF-FACTOR-OPER
FACTOR_OPER		Signed 9.2——
#XRF-X-STATUS-CODE
X_STATUS_CODE		Alpha 1——
#XRF-ALPHA-1-DESC
ALPHA_1_DESC		Alpha 30 (Lower Case)——
#XRF-ALPHA-2-DESC
ALPHA_2_DESC		Alpha 30 (Lower Case)——
#XRF-ALPHA-3-DESC
ALPHA_3_DESC		Alpha 30 (Lower Case)——
#XRF-ALPHA-4-DESC
ALPHA_4_DESC		Alpha 30 (Lower Case)——
#XRF-ALPHA-5-DESC
ALPHA_5_DESC		Alpha 30 (Lower Case)——
#XRF-NUMERIC-1-DESC
NUMERIC_1_DESC		Alpha 30 (Lower Case)——
#XRF-NUMERIC-2-DESC
NUMERIC_2_DESC		Alpha 30 (Lower Case)——
#XRF-NUMERIC-3-DESC
NUMERIC_3_DESC		Alpha 30 (Lower Case)——
#XRF-NUMERIC-4-DESC
NUMERIC_4_DESC		Alpha 30 (Lower Case)——
#XRF-NUMERIC-5-DESC
NUMERIC_5_DESC		Alpha 30 (Lower Case)——
#XRF-SIGNED-1-DESC
SIGNED_1_DESC		Alpha 30 (Lower Case)——
#XRF-SIGNED-2-DESC
SIGNED_2_DESC		Alpha 30 (Lower Case)——
#XRF-SIGNED-3-DESC
SIGNED_3_DESC		Alpha 30 (Lower Case)——
#XRF-SIGNED-4-DESC
SIGNED_4_DESC		Alpha 30 (Lower Case)——
#XRF-SIGNED-5-DESC
SIGNED_5_DESC		Alpha 30 (Lower Case)——
#XRF-DATE-1-DESC
DATE_1_DESC		Alpha 30 (Lower Case)——
#XRF-DATE-2-DESC
DATE_2_DESC		Alpha 30 (Lower Case)——
#XRF-DATE-3-DESC
DATE_3_DESC		Alpha 30 (Lower Case)——
#XRF-DATE-4-DESC
DATE_4_DESC		Alpha 30 (Lower Case)——
#XRF-DATE-5-DESC
DATE_5_DESC		Alpha 30 (Lower Case)——
#XRF-OPER-CODE-DESC
OPER_CODE_DESC		Alpha 30 (Lower Case)——
#XRF-FACTOR-OPER-D
FACTOR_OPER_D		Alpha 30 (Lower Case)——

Indexes (1)

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
XRFSET1
  1. COMPANY
  2. CODE-1
  3. CODE-2
  4. VALUE-NUM-1
  5. VALUE-ALPHA-1
Primary—

Programs

No Lawson programs are documented as updating or referencing this table.