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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
XMU-OBJID PKOBJID | Numeric 12 | — | EX14.1, EX14.2, EXLD.1 |
XMU-COMPANYCOMPANY | Numeric 4 | — | EX14.1, EX14.2, EXLD.1 |
XMU-EMPLOYEEEMPLOYEE | Numeric 9 | — | EX14.1, EX14.2, EXLD.1 |
XMU-FIRSTNAMEFIRSTNAME | Alpha 255 | — | EX14.1, EX14.2, EXLD.1 |
XMU-LASTNAMELASTNAME | Alpha 255 | — | EX14.1, EX14.2, EXLD.1 |
XMU-APCOMPANYAPCOMPANY | Numeric 4 | — | EX14.1, EX14.2, EXLD.1 |
XMU-VENDORGROUPVENDORGROUP | Alpha 4 | — | EX14.1, EX14.2, EXLD.1 |
XMU-VENDORVENDOR | Alpha 9 (Right Justified) | — | EX14.1, EX14.2, EXLD.1 |
XMU-VENDORNAMEVENDORNAME | Alpha 30 | — | EX14.1, EX14.2, EXLD.1 |
XMU-CCVENDORCCVENDOR | Alpha 9 (Right Justified) | — | EX14.1, EX14.2, EXLD.1 |
XMU-GLCOMPANYGLCOMPANY | Numeric 4 | — | EX14.1, EX14.2, EXLD.1 |
XMU-ACCTUNITACCTUNIT | Alpha 15 | — | EX14.1, EX14.2, EXLD.1 |
XMU-PROCESSLEVELPROCESSLEVEL | Alpha 5 | — | EX14.1, EX14.2, EXLD.1 |
XMU-SCOMPANYSCOMPANY | Numeric 4 | — | EX14.1, EX14.2, EXLD.1 |
XMU-SEMPLOYEESEMPLOYEE | Numeric 9 | — | EX14.1, EX14.2, EXLD.1 |
XMU-XLOGINNAMEXLOGINNAME | Alpha 200 | — | EX14.1, EX14.2, EXLD.1 |
XMU-REIMSYSREIMSYS | Alpha 2 | — | EX14.1, EX14.2, EXLD.1 |
XMU-COUNTRYCOUNTRY | Alpha 2 | — | EX14.1, EX14.2, EXLD.1 |
XMU-XEXTERNALKEYXEXTERNALKEY | Alpha 200 | — | EX14.1, EX14.2, EXLD.1 |
XMU-XCOSTCENTERXCOSTCENTER | Alpha 255 | — | EX14.1, EX14.2, EXLD.1 |
XMU-XUSEREMAILXUSEREMAIL | Alpha 255 | — | EX14.1, EX14.2, EXLD.1 |
XMU-XSTATUSXSTATUS | Numeric 4 | — | EX14.1, EX14.2, EXLD.1 |
XMU-XCURRENCYXCURRENCY | Alpha 5 | — | EX14.1, EX14.2, EXLD.1 |
XMU-XDEFAPPRXDEFAPPR | Alpha 255 | — | EX14.1, EX14.2, EXLD.1 |
XMU-XCREATEDATEXCREATEDATE | Numeric 8 (yyyymmdd) | — | EX14.1, EX14.2, EXLD.1 |
XMU-XSTARTDATEXSTARTDATE | Numeric 8 (yyyymmdd) | — | EX14.1, EX14.2, EXLD.1 |
XMU-XENDDATEXENDDATE | Numeric 8 (yyyymmdd) | — | EX14.1, EX14.2, EXLD.1 |
XMU-XOUTOFFICEXOUTOFFICE | Numeric 4 | — | EX14.1, EX14.2, EXLD.1 |
XMU-XPROXYSUBXPROXYSUB | Numeric 4 | — | EX14.1, EX14.2, EXLD.1 |
XMU-XISHTMLUSERXISHTMLUSER | Numeric 4 | — | EX14.1, EX14.2, EXLD.1 |
XMU-LASTAPPLDADVLASTAPPLDADV | Alpha 22 | — | EX14.1, EX14.2 |
XMU-EXISTSINXMEXISTSINXM | Numeric 1 | — | EX14.1, EX14.2, EXLD.1 |
XMU-XEMPLOYEEXEMPLOYEE | Alpha 255 | — | EX14.1, EX14.2, EXLD.1 |
Indexes (5)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
XMUSET1 | OBJID | Primary | EX14.1, EX14.2, EXLD.1 | |
XMUSET2 | XEXTERNALKEY, OBJID | KeyChange | EX14.1, EX14.2, EXXM.1 | |
XMUSET3 | COMPANY, EMPLOYEE, OBJID | KeyChange | EX14.1, EX14.2, EXLD.1 | |
XMUSET4 | VENDORGROUP, VENDOR, OBJID | KeyChange | EX14.1, EX14.2, EXLD.1 | |
XMUSET5 | XLOGINNAME, OBJID | KeyChange | EXXM.1 |
Programs
Updated by (3)
Referenced by (1)
- EXXM.1 Create Expense Interface