CTXMUSER – No description in the Lawson data dictionary

System
Accounts Payable (AP)
Prefix
XMU
Primary key
OBJID
Fields
33
Updated by
3 programs
Referenced by
1 program

CTXMUSER is a Lawson Accounts Payable table (prefix XMU); no description in the lawson data dictionary. It is indexed by OBJID (XMUSET1); alternate indexes: XMUSET2, XMUSET3, XMUSET4 and XMUSET5. It is updated by EX14.1, EX14.2 and EXLD.1 and referenced by EXXM.1. The table has 33 fields, 5 indexes and 0 documented relations.

About CTXMUSER

No description in the Lawson data dictionary.

Fields (33)

Column = COBOL field name without the XMU- 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
#XMU-OBJID PK
OBJID		Numeric 12—EX14.1, EX14.2, EXLD.1
#XMU-COMPANY SET3
COMPANY		Numeric 4—EX14.1, EX14.2, EXLD.1
#XMU-EMPLOYEE SET3
EMPLOYEE		Numeric 9—EX14.1, EX14.2, EXLD.1
#XMU-FIRSTNAME
FIRSTNAME		Alpha 255—EX14.1, EX14.2, EXLD.1
#XMU-LASTNAME
LASTNAME		Alpha 255—EX14.1, EX14.2, EXLD.1
#XMU-APCOMPANY
APCOMPANY		Numeric 4—EX14.1, EX14.2, EXLD.1
#XMU-VENDORGROUP SET4
VENDORGROUP		Alpha 4—EX14.1, EX14.2, EXLD.1
#XMU-VENDOR SET4
VENDOR		Alpha 9 (Right Justified)—EX14.1, EX14.2, EXLD.1
#XMU-VENDORNAME
VENDORNAME		Alpha 30—EX14.1, EX14.2, EXLD.1
#XMU-CCVENDOR
CCVENDOR		Alpha 9 (Right Justified)—EX14.1, EX14.2, EXLD.1
#XMU-GLCOMPANY
GLCOMPANY		Numeric 4—EX14.1, EX14.2, EXLD.1
#XMU-ACCTUNIT
ACCTUNIT		Alpha 15—EX14.1, EX14.2, EXLD.1
#XMU-PROCESSLEVEL
PROCESSLEVEL		Alpha 5—EX14.1, EX14.2, EXLD.1
#XMU-SCOMPANY
SCOMPANY		Numeric 4—EX14.1, EX14.2, EXLD.1
#XMU-SEMPLOYEE
SEMPLOYEE		Numeric 9—EX14.1, EX14.2, EXLD.1
#XMU-XLOGINNAME SET5
XLOGINNAME		Alpha 200—EX14.1, EX14.2, EXLD.1
#XMU-REIMSYS
REIMSYS		Alpha 2—EX14.1, EX14.2, EXLD.1
#XMU-COUNTRY
COUNTRY		Alpha 2—EX14.1, EX14.2, EXLD.1
#XMU-XEXTERNALKEY SET2
XEXTERNALKEY		Alpha 200—EX14.1, EX14.2, EXLD.1
#XMU-XCOSTCENTER
XCOSTCENTER		Alpha 255—EX14.1, EX14.2, EXLD.1
#XMU-XUSEREMAIL
XUSEREMAIL		Alpha 255—EX14.1, EX14.2, EXLD.1
#XMU-XSTATUS
XSTATUS		Numeric 4—EX14.1, EX14.2, EXLD.1
#XMU-XCURRENCY
XCURRENCY		Alpha 5—EX14.1, EX14.2, EXLD.1
#XMU-XDEFAPPR
XDEFAPPR		Alpha 255—EX14.1, EX14.2, EXLD.1
#XMU-XCREATEDATE
XCREATEDATE		Numeric 8 (yyyymmdd)—EX14.1, EX14.2, EXLD.1
#XMU-XSTARTDATE
XSTARTDATE		Numeric 8 (yyyymmdd)—EX14.1, EX14.2, EXLD.1
#XMU-XENDDATE
XENDDATE		Numeric 8 (yyyymmdd)—EX14.1, EX14.2, EXLD.1
#XMU-XOUTOFFICE
XOUTOFFICE		Numeric 4—EX14.1, EX14.2, EXLD.1
#XMU-XPROXYSUB
XPROXYSUB		Numeric 4—EX14.1, EX14.2, EXLD.1
#XMU-XISHTMLUSER
XISHTMLUSER		Numeric 4—EX14.1, EX14.2, EXLD.1
#XMU-LASTAPPLDADV
LASTAPPLDADV		Alpha 22—EX14.1, EX14.2
#XMU-EXISTSINXM
EXISTSINXM		Numeric 1—EX14.1, EX14.2, EXLD.1
#XMU-XEMPLOYEE
XEMPLOYEE		Alpha 255—EX14.1, EX14.2, EXLD.1

Indexes (5)

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
XMUSET1
  1. OBJID
PrimaryEX14.1, EX14.2, EXLD.1
XMUSET2
  1. XEXTERNALKEY
  2. OBJID
KeyChangeEX14.1, EX14.2, EXXM.1
XMUSET3
  1. COMPANY
  2. EMPLOYEE
  3. OBJID
KeyChangeEX14.1, EX14.2, EXLD.1
XMUSET4
  1. VENDORGROUP
  2. VENDOR
  3. OBJID
KeyChangeEX14.1, EX14.2, EXLD.1
XMUSET5
  1. XLOGINNAME
  2. OBJID
KeyChangeEXXM.1

Programs

Updated by (3)

Referenced by (1)