EEEXPENSE – Employee Expense

System
Accounts Payable (AP)
Prefix
EXP
Primary key
COMPANY, VENDOR, EXPENSE-NBR
Fields
53
Updated by
11 programs
Referenced by
308 programs

EEEXPENSE is the Employee Expense table in Lawson Accounts Payable (prefix EXP). It is indexed by COMPANY, VENDOR, EXPENSE-NBR (EXPSET1); alternate indexes: EXPSET2 and EXPSET3. It is related 1:1 to APCOMPANY, APINVOICE, APPAYMENT, APVENMAST, CBCASHFORM, CBCHECK, EEAPPROVAL, EXPBOD and 1 more and 1:M to EEADVANCE, EEDISTRIB and EEMATCHING. It is updated by AP300, AP305, AP55.1, EE11.1, EE135, EE20.2, EE20.3, EE20.4 and 3 more and referenced by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 300 more. The table has 53 fields, 3 indexes and 12 documented relations.

About EEEXPENSE

The Employee Expense file contains employee expense records, including cash paybacks, created in the Lawson Employee Expense system.

Fields (53)

Column = COBOL field name without the EXP- 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 / columnTypeDescription & valuesUpdated by
#EXP-COMPANY PK
COMPANY		Numeric 4The company number. Must be a valid record in the Accounts Payable Company file.EE20.2, EE20.4, EE520
#EXP-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The employee number. Must be a valid vendor record in the Accounts Payable Vendor file.EE20.2, EE20.4, EE520
#EXP-EXPENSE-NBR PK
EXPENSE_NBR		Alpha 10A unique number assigned to the employee expense.EE20.2, EE20.4, EE520
#EXP-EXPENSE-TYPE SET2
EXPENSE_TYPE		Alpha 1Identifies the type of employee expense. Valid values are:
  • E Expense.
  • P Cash Payback.
EE20.2, EE20.4, EE520
#EXP-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description assigned to the employee expense report.EE20.2, EE20.4, EE520
#EXP-REC-STATUS SET2
REC_STATUS		Numeric 1The record status of the expense. Valid values are: expenses only).
  • 0 Unreleased.
  • 1 Released.
  • 9 Posted by EE175 (for company-paid
EE135, EE20.2, EE20.4, EE35.1, EE35.2, EE520
#EXP-APPROVAL-CODE SET3
APPROVAL_CODE		Alpha 3The approval code assigned to the employee expense. Used for approving advances and expenses before they can be released to the Accounts Payable system. Must be a valid record in the Approval Code file.EE20.2, EE20.4, EE35.2, EE520
#EXP-EXPENSE-DATE
EXPENSE_DATE		Numeric 8 (yyyymmdd)The date the expense was incurred.EE20.2, EE20.4, EE520
#EXP-DUE-DATE
DUE_DATE		Numeric 8 (yyyymmdd)This field is not used.EE20.2, EE20.4, EE520
#EXP-DISTRIB-DATE
DISTRIB_DATE		Numeric 8 (yyyymmdd)The date used for posting expense distributions to the general ledger.EE20.2, EE20.4, EE520
#EXP-TRAN-EXP-AMT
TRAN_EXP_AMT		Signed 18.2The total amount the employee expense. Includes both company-paid and employee-paid expenses. Must be entered in company base currency. This field contains the same value as the Base Currency Expense Amount field.EE20.2, EE20.4, EE520
#EXP-TRAN-ND
TRAN_ND		Numeric 1The number of decimal positions defined for the currency of the expense.EE20.2, EE20.4, EE520
#EXP-BASE-EXP-AMT
BASE_EXP_AMT		Signed 18.2The amount of the employee expense in the company base currency.EE20.2, EE20.4, EE520
#EXP-BASE-TAX-AMT
BASE_TAX_AMT		Signed 18.2The total tax amount of the expense in the company base currency.EE20.2, EE520
#EXP-BASE-EMP-PAID
BASE_EMP_PAID		Signed 18.2The total employee-paid amount of the expense in the company base currency.EE20.2, EE20.4, EE520
#EXP-PROC-LEVEL
PROC_LEVEL		Alpha 5The process level assigned to the employee expense. Must be a valid record in the Accounts Payable Process Level file.EE20.2, EE20.4, EE520
#EXP-DEF-ACCT-UNIT
DEF_ACCT_UNIT		Alpha 15The default general ledger accounting unit assigned to the employee expense. Defaults on all distributions entered for the expense.EE20.2, EE20.4, EE520
#EXP-ACTIVITY
ACTIVITY		Alpha 15The default activity assigned to the expense. Defaults on detail lines entered for the expense. Must be a valid record in the Lawson Activity Management system.EE20.2, EE20.4, EE520
#EXP-BILLABLE
BILLABLE		Alpha 1Indicates whether the expense is billable to a third party. Used for informational purposes only. Valid values are:
  • N No.
  • Y Yes.
EE20.2, EE20.4, EE520
#EXP-CASH-CODE
CASH_CODE		Alpha 4The cash code assigned to the employee expense. Represents the bank account the expense is paid from. Must be a valid record in the Cash Code file.EE20.2, EE20.4, EE520
#EXP-ACCR-CODE
ACCR_CODE		Alpha 4The invoice accrual code assigned to the employee expense. Used to default a general ledger accrual account to the expense. Must be a valid record in the Invoice Accrual Code file.EE20.2, EE20.4, EE520
#EXP-HLD-CODE
HLD_CODE		Alpha 4The hold code assigned to the employee expense, if assigned. Used to prevent the expense from being scheduled for payment in the Lawson Accounts Payable system. Must be a valid invoice hold code record in the Hold Code file.EE20.2, EE20.4, EE35.2, EE520
#EXP-HOLD-TYPE
HOLD_TYPE		Alpha 1Indicates the type of invoice hold code assigned to the employee expense. Valid values are: Payable, the expense will be held for only one payment cycle. AP170 (Payment Closing) removes the hold code from the expense record. Payable, the expense will be held until you remove the hold code from the expense record. Blank. A hold code is not assigned to the employee expense.
  • T Temporary. Upon release to Accounts
  • P Permanent. Upon release to Accounts
EE20.2, EE20.4, EE35.2, EE520
#EXP-REL-FOR-PMT
REL_FOR_PMT		Alpha 1Indicates whether the expense can be released to Accounts Payable. Valid values are:
  • Y Yes.
  • N No.
EE20.2, EE20.4, EE35.2, EE520
#EXP-REFERENCE
REFERENCE		Alpha 10 (Lower Case)The default reference assigned to the employee expense. Defaults on distributions entered for the expense.EE20.2, EE20.4, EE520
#EXP-DIST-DESCRIPT
DIST_DESCRIPT		Alpha 30 (Lower Case)The default description assigned to the expense. Defaults on distributions entered for the expense.EE20.2, EE20.4, EE520
#EXP-DIST-COMPANY
DIST_COMPANY		Numeric 4The company the expense will be posted to. Must be a valid record in the General Ledger Company file.EE20.2, EE20.4, EE520
#EXP-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).EE20.2, EE20.4, EE520
#EXP-DEF-CNV-RATE
DEF_CNV_RATE		Percent 14.6 (Percent)The exchange rate used to convert the transaction expense amount to the company base currency.EE20.2, EE20.4, EE520
#EXP-CURR-EFF-DATE
CURR_EFF_DATE		Numeric 8 (yyyymmdd)The effective date for the currency exchange rate.EE20.2, EE20.4, EE520
#EXP-TRANS-NBR
TRANS_NBR		Alpha 10 (Right Justified)The payment number assigned to the employee expense if paid with a manual payment. This field is zero for an expense payment issued with a system payment in Accounts Payable.AP55.1, EE20.2
#EXP-BANK-INST-CODE
BANK_INST_CODE		Alpha 3The payment code assigned to the employee expense. Represents a type of cash payment. Must be a valid cash payment type transaction code record in the Bank Transaction Code file.EE20.2, EE20.4, EE520
#EXP-CHECK-DATE
CHECK_DATE		Numeric 8 (yyyymmdd)The date assigned to the manual payment. This date is assigned to general ledger transactions created for the payment.AP55.1, EE20.2
#EXP-CHECK-AMT
CHECK_AMT		Signed 18.2The manual payment amount issued for the employee expense. Defaults the company base currency employee-paid expense amount.EE20.2, EE20.4
#EXP-CROSS-REF
CROSS_REF		Alpha 10The cross reference value assigned to the employee expense.EE20.2, EE20.4, EE520
#EXP-LAST-DIST-SEQ
LAST_DIST_SEQ		Numeric 4A system-assigned number used to track the last distribution entered for the employee expense.EE11.1, EE20.3, EE20.4, EE520
#EXP-BASE-DIST-TOT
BASE_DIST_TOT		Signed 18.2The total expense distribution amount entered for the employee expense. This amount is in the company base currency.EE11.1, EE20.3, EE20.4, EE520
#EXP-BASE-EMP-TOT
BASE_EMP_TOT		Signed 18.2The total employee-paid expense amount in the company base currency.EE11.1, EE20.3, EE20.4, EE520
#EXP-BASE-TAX-TOT
BASE_TAX_TOT		Signed 18.2The total tax amount for the employee expense in the company base currency.EE11.1, EE20.3, EE20.4, EE520
#EXP-TRANS-IDENT
TRANS_IDENT		Numeric 10A unique system-generated identification value assigned to the transaction to make this record unique.AP55.1, EE20.2, EE520
#EXP-INVOICE-GROUP
INVOICE_GROUP		Alpha 4The user-defined invoice group assigned to the employee expense. AP150 (Cash Requirements) has an option to select all transactions assigned the same invoice group.EE20.2, EE20.4, EE520
#EXP-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5The default account category assigned to the employee expense. Defaults on detail lines entered for the expense. Must be a valid record in the Lawson Activity Management system.EE20.2, EE20.4, EE520
#EXP-APPROVED-FLAG
APPROVED_FLAG		Alpha 1Indicates whether the expense is approved for payment. Valid values are:
  • Y Yes.
  • N No.
  • D Disapproved.
EE20.2, EE20.4, EE520
#EXP-REMIT-TO-CODE
REMIT_TO_CODE		Alpha 4The remit to location assigned to the expense. Represents an alternate remittance address for the employee. Must be a valid record in the Vendor Location file.EE20.2, EE20.4, EE520
#EXP-JRNL-BOOK-NBR
JRNL_BOOK_NBR		Alpha 12The journal book assigned to the transaction.EE20.2, EE20.4, EE520
#EXP-PAY-GROUP
PAY_GROUP		Alpha 4The pay group associated with the expense. Must be a valid record in the Pay Group file.EE20.2, EE20.4, EE520
#EXP-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)The creation date.EE11.1, EE20.2, EE20.3, EE20.4, EE520
#EXP-OUT-BAL-DIST
OUT_BAL_DIST		DerivedIndicates that distributions for the employee expense are out of balance.—
#EXP-OUT-BAL-EMP
OUT_BAL_EMP		DerivedIndicates that employee-paid distributions for the expense are out of balance.—
#EXP-OUT-BAL-TAX
OUT_BAL_TAX		DerivedIndicates that tax distributions for the employee expense are out of balance.—
#EXP-AP-STATUS
AP_STATUS		DerivedThe record status of the employee expense in the Lawson Accounts Payable system. Valid values are: Blank. Not released to Accounts Payable.
  • 1 Released.
  • 9 Historical.
—
#EXP-CB-CHECK-DATE
CB_CHECK_DATE		Derived——
#EXP-JBK-SEQ-NBR
JBK_SEQ_NBR		Numeric 10The journal book sequence number assigned to a journal book transaction when it is added or interfaced to the Lawson system. Used only when Auto Journal Book Seq Nbr is set to Yes in GL10.1 (Company).EE20.2, EE520

Indexes (3)

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.

IndexKeysFlagsConditionUsed in
EXPSET1
  1. COMPANY
  2. VENDOR
  3. EXPENSE-NBR
PrimaryAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
EXPSET2
  1. COMPANY
  2. REC-STATUS
  3. VENDOR
  4. EXPENSE-NBR
  5. EXPENSE-TYPE
KeyChangeAP55.1, EE11.1, EE20.2, EE20.3, EE20.4, EE230
EXPSET3
  1. COMPANY
  2. APPROVAL-CODE
  3. VENDOR
  4. EXPENSE-NBR
KeyChange, SubsetWhere (REC-STATUS = Zeroes)EE135, EE220, EE235, EE35.2

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APCOMPANYAPINVOICEAPPAYMENTAPVENMASTCBCASHFORMCBCHECKEEAPPROVALEXPBODGLSYSTEMEEADVANCEEEDISTRIBEEMATCHINGEEEXPENSE

One to one (9) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequired
EXP-COMPANY→CPY-COMPANY
ApinvoiceAPINVOICENot Required
EXP-COMPANY→API-COMPANY
EXP-VENDOR→API-VENDOR
EXP-EXPENSE-NBR→API-INVOICE
Zeroes→API-SUFFIX
Zeroes→API-CANCEL-SEQ
AppaymentAPPAYMENTNot Required
EXP-COMPANY→APP-COMPANY
EXP-VENDOR→APP-VENDOR
EXP-EXPENSE-NBR→APP-INVOICE
Zeroes→APP-SUFFIX
Zeroes→APP-CANCEL-SEQ
1→APP-SEQ-NBR
Zeroes→APP-VOID-SEQ
ApvenmastAPVENMASTRequired
CPY-VENDOR-GROUP→VEN-VENDOR-GROUP
EXP-VENDOR→VEN-VENDOR
CbcashformCBCASHFORMRequired
APP-CASH-CODE→CCF-CASH-CODE
APP-BANK-INST-CODE→CCF-BANK-INST-CODE
APP-PROC-GRP→CCF-PROC-GRP
CbcheckCBCHECKNot Required
APP-CASH-CODE→CHK-CASH-CODE
APP-BANK-INST-CODE→CHK-BANK-INST-CODE
APP-TRANS-IDENT→CHK-TRANS-IDENT
EeapprovalEEAPPROVALNot Required
EXP-COMPANY→EAP-COMPANY
EXP-APPROVAL-CODE→EAP-APPROVAL-CODE
ExpbodEXPBODNot Required, Delete Cascades
EXP-COMPANY→EEB-COMPANY
EXP-VENDOR→EEB-VENDOR
EXP-EXPENSE-NBR→EEB-EXPENSE-NBR
GlsystemGLSYSTEMRequired
EXP-COMPANY→GLS-COMPANY

One to many (3) — child tables

RelationTableRulesConditionField map
EeadvanceEEADVANCE
EXP-COMPANY→EEA-COMPANY
EXP-VENDOR→EEA-VENDOR
—→EEA-ADVANCE-NBR
EedistribEEDISTRIBDelete Cascades
EXP-COMPANY→EED-COMPANY
EXP-VENDOR→EED-VENDOR
EXP-EXPENSE-NBR→EED-EXPENSE-NBR
—→EED-SEQ-NBR
EematchingEEMATCHING
EXP-COMPANY→EEM-COMPANY
EXP-VENDOR→EEM-VENDOR
EXP-EXPENSE-NBR→EEM-EXPENSE-NBR
—→EEM-ADVANCE-NBR

Programs

Updated by (11)

Referenced by (308)