Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PWEXPENSE


                             PWEXPENSE FILE

UPDATED BY

AP170

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PWE-HR-COMPANY         Numeric 4                                 AP170
Element: Company

PWE-EMPLOYEE           Numeric 9                                 AP170
Element: Employee      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.

PWE-INVOICE            Alpha 22                                  AP170
Element: Invoice NumberUsed to identify the invoice.

PWE-TRANS-NBR          Alpha 10  (Right Justified)               AP170
Element: Trans Nbr     A unique, user-defined value used to
                       identify the transaction.

PWE-CHECK-DATE         Numeric 8  (yyyymmdd)                     AP170
Element: Date

PWE-TRAN-PMT-AMT       Signed 15.2                               AP170
Element: Adj Amt

PWE-BASE-CURR          Alpha 5                                   AP170
Element: Currency

                         PWEXPENSE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PWESET1   HR-COMPANY                                             AP170
          EMPLOYEE
          INVOICE
          TRANS-NBR