EEUAVAL – No description in the Lawson data dictionary
- System
- Accounts Payable (AP)
- Prefix
EUA- Primary key
COMPANY,VENDOR,EXPENSE-NBR,SEQ-NBR,TYPE- Fields
- 6
- Updated by
- 6 programs
- Referenced by
- 6 programs
EEUAVAL is a Lawson Accounts Payable table (prefix EUA); no description in the lawson data dictionary. It is indexed by COMPANY, VENDOR, EXPENSE-NBR, SEQ-NBR, TYPE (EUASET1). It is updated by AP30.4, AP300, EE11.1, EE20.2, EE20.3 and EE520 and referenced by EE135, EE175, EE220, EE275, EE35.1 and EE35.2. The table has 6 fields, 1 index and 0 documented relations.
About EEUAVAL
No description in the Lawson data dictionary.
Fields (6)
Column = COBOL field name without the EUA- 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 |
|---|---|---|---|
#EUA-COMPANY PKCOMPANY | 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. | EE11.1, EE20.2, EE20.3, EE520 |
#EUA-VENDOR PKVENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | EE11.1, EE20.2, EE20.3, EE520 |
#EUA-EXPENSE-NBR PKEXPENSE_NBR | Alpha 10 | The expense report number. | EE11.1, EE20.2, EE20.3, EE520 |
#EUA-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | AP30.4, EE11.1, EE20.2, EE20.3, EE520 |
#EUA-TYPE PKTYPE | Alpha 2 | This identifies whether this record is created because of a picking transaction, or because of a return. Valid values are: "IS" = Picking transaction. "RR" = Return. ~$1 VENDOR The vendor's identification code. | EE11.1, EE20.2, EE20.3, EE520 |
#EUA-SEGMENT-BLOCKSEGMENT_BLOCK | Alpha 103 | This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information. | EE11.1, EE20.2, EE20.3, EE520 |
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 |
|---|---|---|---|---|
EUASET1 |
| Primary | AP30.4, AP300, EE11.1, EE135, EE175, EE20.2, EE20.3, EE220 +4 more |
Programs
Updated by (6)
- AP30.4 Invoice Cancel
- AP300 Invoice and Vendor History Purge
- EE11.1 Expense Line Detail
- EE20.2 Employee Expense
- EE20.3 Expense Detail
- EE520 Expense Interface