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: Payment Date  The payment date.

PWE-TRAN-PMT-AMT       Signed 18.2                               AP170
Element: Intl Amt      Transaction amount of invoices paid in
                       the currency of the invoice.

                         PWEXPENSE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PWESET1   HR-COMPANY                                             AP170
          EMPLOYEE
          INVOICE
          TRANS-NBR