CXCTIUAVAL – No description in the Lawson data dictionary

System
Case Carts (CX)
Prefix
CXT
Primary key
COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, LINE-NBR
Fields
8
Updated by
3 programs
Referenced by
36 programs

CXCTIUAVAL is a Lawson Case Carts table (prefix CXT); no description in the lawson data dictionary. It is indexed by COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, LINE-NBR (CXTSET1). It is updated by CX05.1, CX05.2 and CX805 and referenced by CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 and 28 more. The table has 8 fields, 1 index and 0 documented relations.

About CXCTIUAVAL

No description in the Lawson data dictionary.

Fields (8)

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

Field / columnTypeDescription & valuesUpdated by
CXT-COMPANY PK
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.CX05.1, CX05.2, CX805
CXT-REQ-LOCATION PK
REQ_LOCATION		Alpha 5The location requisitioning items. This location can be an inventory or noninventory location.CX05.1, CX05.2, CX805
CXT-PREF-CODE PK
PREF_CODE		Alpha 8The procedure code is the second of two fields that uniquely identify a procedure. The procedure code is an identifier for a specific procedure within a procedure type.CX05.1, CX05.2, CX805
CXT-PROC-TYPE PK
PROC_TYPE		Alpha 8The procedure code is the second of two fields that uniquely identify a procedure. The procedure code is an identifier for a specific procedure within a procedure type.CX05.1, CX05.2, CX805
CXT-PROC-CODE PK
PROC_CODE		Alpha 8The procedure code is the second of two fields that uniquely identify a procedure. The procedure code is an identifier for a specific procedure within a procedure type.CX05.1, CX05.2, CX805
CXT-PRACTNR-ID PK
PRACTNR_ID		Alpha 15This field contains the practitioner ID.CX05.1, CX05.2, CX805
CXT-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.CX05.1, CX05.2, CX805
CXT-SEGMENT-BLOCK
SEGMENT_BLOCK		Alpha 103This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information.CX05.1, CX05.2, CX805

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CXTSET1COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, LINE-NBRPrimaryCX05.1, CX05.2, CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220 +22 more (list truncated in source)

Programs

Updated by (3)

Referenced by (36)