PWEXPENSE – No description in the Lawson data dictionary
- System
- PW (PW)
- Prefix
PWE- Primary key
HR-COMPANY,EMPLOYEE,INVOICE,TRANS-NBR- Fields
- 7
- Updated by
- 1 program
- Referenced by
- 0 programs
PWEXPENSE is a Lawson PW table (prefix PWE); no description in the lawson data dictionary. It is indexed by HR-COMPANY, EMPLOYEE, INVOICE, TRANS-NBR (PWESET1). It is updated by AP170. The table has 7 fields, 1 index and 0 documented relations.
About PWEXPENSE
No description in the Lawson data dictionary.
Fields (7)
Column = COBOL field name without the PWE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PWE-HR-COMPANY PKHR_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. | AP170 |
PWE-EMPLOYEE PKEMPLOYEE | Numeric 9 | Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person. | AP170 |
PWE-INVOICE PKINVOICE | Alpha 22 | Used to identify the invoice. | AP170 |
PWE-TRANS-NBR PKTRANS_NBR | Alpha 10 (Right Justified) | A unique, user-defined value used to identify the transaction. | AP170 |
PWE-CHECK-DATECHECK_DATE | Numeric 8 (yyyymmdd) | The payment date. | AP170 |
PWE-TRAN-PMT-AMTTRAN_PMT_AMT | Signed 18.2 | — | AP170 |
PWE-BASE-CURRBASE_CURR | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | AP170 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PWESET1 | HR-COMPANY, EMPLOYEE, INVOICE, TRANS-NBR | Primary | AP170 |
Programs
Updated by (1)
- AP170 Payment Closing