CTXMEXPTYP – No description in the Lawson data dictionary
- System
- Accounts Payable (AP)
- Prefix
XMT- Primary key
EXPTYPE,COMPANY- Fields
- 10
- Updated by
- 1 program
- Referenced by
- 1 program
CTXMEXPTYP is a Lawson Accounts Payable table (prefix XMT); no description in the lawson data dictionary. It is indexed by EXPTYPE, COMPANY (XMTSET1). It is updated by EX13.1 and referenced by EXXM.1. The table has 10 fields, 1 index and 0 documented relations.
About CTXMEXPTYP
No description in the Lawson data dictionary.
Fields (10)
Column = COBOL field name without the XMT- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#XMT-EXPTYPE PKEXPTYPE | Alpha 200 | — | EX13.1 |
#XMT-COMPANY PKCOMPANY | Numeric 4 | — | EX13.1 |
#XMT-PROCESSLEVELPROCESSLEVEL | Alpha 5 | — | EX13.1 |
#XMT-JOBCODEJOBCODE | Alpha 9 | — | EX13.1 |
#XMT-PAYCODEPAYCODE | Alpha 4 | — | EX13.1 |
#XMT-DEFACCTCATGRPDEFACCTCATGRP | Alpha 15 | — | — |
#XMT-DEFACCTCATDEFACCTCAT | Alpha 5 | — | EX13.1 |
#XMT-DESCRIPTIONDESCRIPTION | Alpha 200 | — | — |
#XMT-ACCOUNTACCOUNT | Numeric 6 | — | — |
#XMT-SUB-ACCTSUB_ACCT | Numeric 4 | — | — |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
XMTSET1 |
| Primary | EX13.1, EXXM.1 |
Programs
Updated by (1)
- EX13.1 XM Interface Expense Type
Referenced by (1)
- EXXM.1 Create Expense Interface