CTXMEXPDTL – No description in the Lawson data dictionary
- System
- Accounts Payable (AP)
- Prefix
XME- Primary key
XMHOBJID,OBJID- Fields
- 27
- Updated by
- 2 programs
- Referenced by
- 0 programs
CTXMEXPDTL is a Lawson Accounts Payable table (prefix XME); no description in the lawson data dictionary. It is indexed by XMHOBJID, OBJID (XMESET1); alternate indexes: XMESET2 and XMESET3. It is updated by EX11.1 and EXXM.1. The table has 27 fields, 3 indexes and 0 documented relations.
About CTXMEXPDTL
No description in the Lawson data dictionary.
Fields (27)
Column = COBOL field name without the XME- 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 |
|---|---|---|---|
#XME-XMHOBJID PKXMHOBJID | Numeric 12 | — | EX11.1 |
#XME-XMLOBJID SET3XMLOBJID | Numeric 12 | — | EX11.1 |
#XME-OBJID PKOBJID | Numeric 12 | — | EX11.1 |
#XME-XBASEAMTXBASEAMT | Signed 18.2 | — | EX11.1, EXXM.1 |
#XME-XBASECURRXBASECURR | Alpha 5 | — | EX11.1 |
#XME-XEXCHRATEXEXCHRATE | Signed 14.7 | — | EX11.1, EXXM.1 |
#XME-XTRANAMTXTRANAMT | Signed 18.2 | — | EX11.1, EXXM.1 |
#XME-XTRANCURRXTRANCURR | Alpha 5 | — | EX11.1 |
#XME-XDATEXDATE | Numeric 8 (yyyymmdd) | — | EX11.1, EXXM.1 |
#XME-XCOSTCENTERXCOSTCENTER | Alpha 255 | — | EX11.1, EXXM.1 |
#XME-XPROJCODEXPROJCODE | Alpha 255 | — | EX11.1, EXXM.1 |
#XME-XPAYMETHXPAYMETH | Numeric 9 | — | EX11.1, EXXM.1 |
#XME-XPERSONALXPERSONAL | Numeric 4 | — | EX11.1, EXXM.1 |
#XME-XEXPTYPLBLXEXPTYPLBL | Alpha 255 | — | EX11.1, EXXM.1 |
#XME-XGLCOMPANYXGLCOMPANY | Numeric 4 | — | EX11.1, EXXM.1 |
#XME-XGLCODEXGLCODE | Alpha 255 | — | EX11.1, EXXM.1 |
#XME-XAPPRBASEAMTXAPPRBASEAMT | Signed 18.2 | — | EX11.1, EXXM.1 |
#XME-XAPPRBASECURRXAPPRBASECURR | Alpha 5 | — | EX11.1 |
#XME-XAPPRTRANAMTXAPPRTRANAMT | Signed 18.2 | — | EX11.1, EXXM.1 |
#XME-XAPPRTRANCURRXAPPRTRANCURR | Alpha 5 | — | EX11.1 |
#XME-XCCISSUERXCCISSUER | Alpha 255 | — | EX11.1 |
#XME-XBILLABLEXBILLABLE | Numeric 4 | — | EX11.1, EXXM.1 |
#XME-DATAFILE SET2DATAFILE | Alpha 200 | — | EX11.1 |
#XME-STATUSSTATUS | Numeric 4 | — | EX11.1, EXXM.1 |
#XME-SPECIALCODESPECIALCODE | Numeric 4 | — | EX11.1, EXXM.1 |
#XME-CR-CARD-NUMBERCR_CARD_NUMBER | Alpha 16 | — | EX11.1, EXXM.1 |
#XME-CC-CARD-ISSUERCC_CARD_ISSUER | Alpha 255 | — | EX11.1, EXXM.1 |
Indexes (3)
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 |
|---|---|---|---|---|
XMESET1 |
| Primary | EX11.1, EXXM.1 | |
XMESET2 |
| EX11.1 | ||
XMESET3 |
| — |