EETRAVELHD – No description in the Lawson data dictionary
- System
- Accounts Payable (AP)
- Prefix
ETH- Primary key
COMPANY,EXPENSE-NBR,VENDOR,BEFORE-AFTER- Fields
- 19
- Updated by
- 1 program
- Referenced by
- 0 programs
EETRAVELHD is a Lawson Accounts Payable table (prefix ETH); no description in the lawson data dictionary. It is indexed by COMPANY, EXPENSE-NBR, VENDOR, BEFORE-AFTER (ETHSET1). It is updated by ET03.1. The table has 19 fields, 1 index and 0 documented relations.
About EETRAVELHD
No description in the Lawson data dictionary.
Fields (19)
Column = COBOL field name without the ETH- 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 |
|---|---|---|---|
#ETH-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. | ET03.1 |
#ETH-EXPENSE-NBR PKEXPENSE_NBR | Alpha 10 | The expense report number. | ET03.1 |
#ETH-VENDOR PKVENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | ET03.1 |
#ETH-BEFORE-AFTER PKBEFORE_AFTER | Alpha 1 | — | ET03.1 |
#ETH-DEF-ACCT-UNITDEF_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. | ET03.1 |
#ETH-BILLABLEBILLABLE | Alpha 1 | — | ET03.1 |
#ETH-ADVANCE-NBRADVANCE_NBR | Alpha 10 | This user-defined field is used to identify the advance to be entered. | ET03.1 |
#ETH-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | ET03.1 |
#ETH-APPROVAL-CODEAPPROVAL_CODE | Alpha 3 | A user-defined code representing a person or department responsible for approving a registered invoice. | ET03.1 |
#ETH-DESCDESC | Alpha 30 (Lower Case) | This field displays the description. | ET03.1 |
#ETH-BEG-DATEBEG_DATE | Numeric 8 (yyyymmdd) Occurs 3 Times ×3 | The beginning date in a range of dates. | ET03.1 |
#ETH-END-DATEEND_DATE | Numeric 8 (yyyymmdd) Occurs 3 Times ×3 | The end date for this effort period. | ET03.1 |
#ETH-EE-COMMENTEE_COMMENT | Alpha 60 Occurs 3 Times ×3 | — | ET03.1 |
#ETH-NAMENAME | Alpha 30 (Lower Case) | Displays the company description. | ET03.1 |
#ETH-EE-STATUSEE_STATUS | Alpha 1 | — | ET03.1 |
#ETH-TRAN-EXP-TOTALTRAN_EXP_TOTAL | Signed 18.2 | — | ET03.1 |
#ETH-TRAN-APP-TOTALTRAN_APP_TOTAL | Signed 18.2 | — | ET03.1 |
#ETH-ACTIVITYACTIVITY | Alpha 15 | Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. | ET03.1 |
#ETH-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru | ET03.1 |
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 |
|---|---|---|---|---|
ETHSET1 |
| Primary | ET03.1 |
Programs
Updated by (1)
- ET03.1 Travel Expense Header