CXCPIUAVAL – No description in the Lawson data dictionary

System
Case Carts (CX)
Prefix
CXV
Primary key
COMPANY, REQ-LOCATION, CASE, SEQ, LINE-NBR
Fields
6
Updated by
220 programs
Referenced by
0 programs

CXCPIUAVAL is a Lawson Case Carts table (prefix CXV); no description in the lawson data dictionary. It is indexed by COMPANY, REQ-LOCATION, CASE, SEQ, LINE-NBR (CXVSET1). It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 212 more. The table has 6 fields, 1 index and 0 documented relations.

About CXCPIUAVAL

No description in the Lawson data dictionary.

Fields (6)

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

Field / columnTypeDescription & valuesUpdated by
CXV-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.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
CXV-REQ-LOCATION PK
REQ_LOCATION		Alpha 5The location requisitioning items. This location can be an inventory or noninventory location.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
CXV-CASE PK
CASE		Alpha 15—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
CXV-SEQ PK
SEQ		Numeric 3This field contains the record sequence number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
CXV-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
CXV-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.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CXVSET1COMPANY, REQ-LOCATION, CASE, SEQ, LINE-NBRPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (220)