Employee Expense

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

REFERENCED BY

AP155	AP160	AP161	AP230	AP240	AP245
AP250	AP32.1	AP520	EE175	EE275	EE30.1
EEI1.1

UPDATED BY

AP300	AP305	AP55.1	EE11.1	EE135	EE20.2
EE20.3	EE20.4	EE35.1	EE35.2	EE520	AM115
AM117	AM15.1	AM15.2	AM15.3	AM15.4	AM19.1
AM19.2	AM20.1	AM20.3	AM21.1	AM21.3	AM500
AM51.1	AM551	AM97.1	AP03.3	AP110	AP115
AP125	AP126	AP131	AP150	AP20.1	AP20.2
AP20.3	AP20.4	AP20.5	AP20.7	AP21.1	AP210
AP220	AP23.1	AP25.1	AP25.2	AP26.1	AP27.1
AP30.2	AP30.4	AP510	AP90.1	AP91.1	API1.1
API2.1	API3.1	API4.1	EE220	EE90.2	MX123
MX500	MA41.1	MA41.2	MA41.4	MA41.7	MA43.1
MA43.2	MA43.3	MA43.4	MA43.6	MA43.7	MAI1.1
PO10.1	PO136	PO190	PO300	PO520	POCP.1
POI3.1	POII.1	POIJ.1	PR05.1	PR05.3	PR226
PR247	PR26.1	PR47.1	PR514	UK47.1	EE230
EE235

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
EXP-COMPANY Element: Company	Numeric 4 The company number. Must be a valid record in the Accounts Payable Company file.	EE20.2 EE20.4 EE520
EXP-VENDOR Element: Employee	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 Element: Expense Nbr	Alpha 10 A unique number assigned to the employee expense.	EE20.2 EE20.4 EE520
EXP-EXPENSE-TYPE Element: Expense Type	Alpha 1 Identifies the type of employee expense. Valid values are: E = Expense. P = Cash Payback.	EE20.2 EE20.4 EE520
EXP-DESCRIPTION Element: Description	Alpha 30 (Lower Case) The description assigned to the employee expense report.	EE20.2 EE20.4 EE520
EXP-REC-STATUS Element: Rec Status	Numeric 1 The record status of the expense. Valid values are: 0 = Unreleased. 1 = Released. 9 = Posted by EE175 (for company-paid expenses only).	EE135 EE20.2 EE20.4 EE35.1 EE35.2 EE520
EXP-APPROVAL-CODE Element: Auth Code	Alpha 3 The 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 Element: Date	Numeric 8 (yyyymmdd) The date the expense was incurred.	EE20.2 EE20.4 EE520
EXP-DUE-DATE Element: Due Date	Numeric 8 (yyyymmdd) This field is not used.	EE20.2 EE20.4 EE520
EXP-DISTRIB-DATE Element: Post Date	Numeric 8 (yyyymmdd) The date used for posting expense distributions to the general ledger.	EE20.2 EE20.4 EE520
EXP-TRAN-EXP-AMT Transaction Expense Amount	Signed 18.2 The 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 Element: Acct Nd	Numeric 1 The number of decimal positions defined for the currency of the expense.	EE20.2 EE20.4 EE520
EXP-BASE-EXP-AMT Base Currency Expense Amount	Signed 18.2 The amount of the employee expense in the company base currency.	EE20.2 EE20.4 EE520
EXP-BASE-TAX-AMT Base Currency Tax Amount	Signed 18.2 The total tax amount of the expense in the company base currency.	EE20.2 EE520
EXP-BASE-EMP-PAID Base Curr Employee Paid Amount	Signed 18.2 The total employee-paid amount of the expense in the company base currency.	EE20.2 EE20.4 EE520
EXP-PROC-LEVEL Element: Process Level	Alpha 5 The 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 Element: Acct Unit	Alpha 15 The 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 Element: Activity	Alpha 15 The 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 Element: Billable	Alpha 1 Indicates 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 Element: Cash Code	Alpha 4 The 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 Element: Invoice Accrual Code	Alpha 4 The 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 Element: Hld Code Ap	Alpha 4 The 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 Element: Hold Type	Alpha 1 Indicates the type of invoice hold code assigned to the employee expense. Valid values are: T = Temporary. Upon release to Accounts Payable, the expense will be held for only one payment cycle. AP170 (Payment Closing) removes the hold code from the expense record. P = Permanent. Upon release to Accounts 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.	EE20.2 EE20.4 EE35.2 EE520
EXP-REL-FOR-PMT Element: All Flag	Alpha 1 Indicates 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 Element: 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 Distribution Description	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 Element: Posting Company	Numeric 4 The 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 Element: Currency Code	Alpha 5 This field contains the company base currency code established in Company (GL10.1 ).	EE20.2 EE20.4 EE520
EXP-DEF-CNV-RATE Element: 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 Element: Date	Numeric 8 (yyyymmdd) The effective date for the currency exchange rate.	EE20.2 EE20.4 EE520
EXP-TRANS-NBR Element: Expense Number	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 Cash Payment Transaction Code	Alpha 3 The 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 Element: 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 Element: Intl Amt	Signed 18.2 The manual payment amount issued for the employee expense. Defaults the company base currency employee-paid expense amount.	EE20.2 EE20.4
EXP-CROSS-REF Element: Cross Reference	Alpha 10 The cross reference value assigned to the employee expense.	EE20.2 EE20.4 EE520
EXP-LAST-DIST-SEQ Element: Seq Nbr	Numeric 4 A 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 Curr Distribution Amount	Signed 18.2 The 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 Curr Employee Paid Amount	Signed 18.2 The total employee-paid expense amount in the company base currency.	EE11.1 EE20.3 EE20.4 EE520
EXP-BASE-TAX-TOT Base Currency Tax Amount	Signed 18.2 The total tax amount for the employee expense in the company base currency.	EE11.1 EE20.3 EE20.4 EE520
EXP-TRANS-IDENT Element: Transaction ID	Numeric 10 A unique system-generated identification value assigned to the transaction to make this record unique.	AP55.1 EE20.2 EE520
EXP-INVOICE-GROUP Element: Invoice Group	Alpha 4 The 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 Element: Acct Category	Alpha 5 The 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 Element: Approved Flag	Alpha 1 Indicates 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 Element: Remit To Code	Alpha 4 The 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 Element: Jrnl Book Nbr	Alpha 12 The journal book assigned to the transaction.	EE20.2 EE20.4 EE520
EXP-PAY-GROUP Element: Pay Group	Alpha 4 The pay group associated with the expense. Must be a valid record in the Pay Group file.	EE20.2 EE20.4 EE520
EXP-CREATE-DATE Element: Create Date	Numeric 8 (yyyymmdd) The creation date.	EE11.1 EE20.2 EE20.3 EE20.4 EE520
EXP-OUT-BAL-DIST Out of Balance Distributions	Derived Indicates that distributions for the employee expense are out of balance.
EXP-OUT-BAL-EMP Out of Balance Employee Dist	Derived Indicates that employee-paid distributions for the expense are out of balance.
EXP-OUT-BAL-TAX Element: Out of Balance Tax	Derived Indicates that tax distributions for the employee expense are out of balance.
EXP-AP-STATUS Element: AP Record Status	Derived The record status of the employee expense in the Lawson Accounts Payable system. Valid values are: 1 = Released. 9 = Historical. Blank. Not released to Accounts Payable.
EXP-CB-CHECK-DATE Element: Cb Check Date	Derived
EXP-JBK-SEQ-NBR Element: Jbk Seq Nbr	Numeric 10 The 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

EEEXPENSE FILE INDEX

EEEXPENSE FILE RELATIONS

ONE TO ONE RELATIONS

EEEXPENSE FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.