MAFRXREF – No description in the Lawson data dictionary
- System
- Matching (MA)
- Prefix
MFX- Primary key
DIST-COMPANY,DIS-ACCT-UNIT,DIS-ACCOUNT,DIS-SUB-ACCT- Fields
- 4
- Updated by
- 1 program
- Referenced by
- 5 programs
MAFRXREF is a Lawson Matching table (prefix MFX); no description in the lawson data dictionary. It is indexed by DIST-COMPANY, DIS-ACCT-UNIT, DIS-ACCOUNT, DIS-SUB-ACCT (MFXSET1). It is updated by MA01.2 and referenced by AP170, AP175, AP176, AP190 and IC130. The table has 4 fields, 1 index and 0 documented relations.
About MAFRXREF
No description in the Lawson data dictionary.
Fields (4)
Column = COBOL field name without the MFX- 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 |
|---|---|---|---|
#MFX-DIST-COMPANY PKDIST_COMPANY | Numeric 4 | Identifies 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. | MA01.2 |
#MFX-DIS-ACCT-UNIT PKDIS_ACCT_UNIT | Alpha 15 | The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. | MA01.2 |
#MFX-DIS-ACCOUNT PKDIS_ACCOUNT | Numeric 6 | This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. | MA01.2 |
#MFX-DIS-SUB-ACCT PKDIS_SUB_ACCT | Numeric 4 | This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. | MA01.2 |
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 |
|---|---|---|---|---|
MFXSET1 |
| Primary | AP170, AP175, AP176, AP190, IC130, MA01.2 |
Programs
Updated by (1)
- MA01.2 Financial Reporting Account Setup