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.

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
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
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
EXPSET1COMPANY, VENDOR, EXPENSE-NBRPrimaryAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
EXPSET2COMPANY, REC-STATUS, VENDOR, EXPENSE-NBR, EXPENSE-TYPEKeyChangeAP55.1, EE11.1, EE20.2, EE20.3, EE20.4, EE230
EXPSET3COMPANY, APPROVAL-CODE, VENDOR, EXPENSE-NBRKeyChange, SubsetWhere (REC-STATUS = Zeroes)EE135, EE220, EE235, EE35.2

Relations

One to one (9) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequiredEXP-COMPANY → CPY-COMPANY
ApinvoiceAPINVOICENot RequiredEXP-COMPANY → API-COMPANY, EXP-VENDOR → API-VENDOR, EXP-EXPENSE-NBR → API-INVOICE, Zeroes → API-SUFFIX, Zeroes → API-CANCEL-SEQ
AppaymentAPPAYMENTNot RequiredEXP-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
ApvenmastAPVENMASTRequiredCPY-VENDOR-GROUP → VEN-VENDOR-GROUP, EXP-VENDOR → VEN-VENDOR
CbcashformCBCASHFORMRequiredAPP-CASH-CODE → CCF-CASH-CODE, APP-BANK-INST-CODE → CCF-BANK-INST-CODE, APP-PROC-GRP → CCF-PROC-GRP
CbcheckCBCHECKNot RequiredAPP-CASH-CODE → CHK-CASH-CODE, APP-BANK-INST-CODE → CHK-BANK-INST-CODE, APP-TRANS-IDENT → CHK-TRANS-IDENT
EeapprovalEEAPPROVALNot RequiredEXP-COMPANY → EAP-COMPANY, EXP-APPROVAL-CODE → EAP-APPROVAL-CODE
ExpbodEXPBODNot Required, Delete CascadesEXP-COMPANY → EEB-COMPANY, EXP-VENDOR → EEB-VENDOR, EXP-EXPENSE-NBR → EEB-EXPENSE-NBR
GlsystemGLSYSTEMRequiredEXP-COMPANY → GLS-COMPANY

One to many (3) — child tables

RelationTableRulesConditionField map
EeadvanceEEADVANCEEXP-COMPANY → EEA-COMPANY, EXP-VENDOR → EEA-VENDOR, → EEA-ADVANCE-NBR
EedistribEEDISTRIBDelete CascadesEXP-COMPANY → EED-COMPANY, EXP-VENDOR → EED-VENDOR, EXP-EXPENSE-NBR → EED-EXPENSE-NBR, → EED-SEQ-NBR
EematchingEEMATCHINGEXP-COMPANY → EEM-COMPANY, EXP-VENDOR → EEM-VENDOR, EXP-EXPENSE-NBR → EEM-EXPENSE-NBR, → EEM-ADVANCE-NBR

Programs

Updated by (11)

Referenced by (308)