Employee Expense
The Employee Expense file contains employee expense records, including cash paybacks, created in the Lawson Employee Expense system.
REFERENCED BY
AP300 | AP305 | AP55.1 | EE11.1 | EE135 | EE20.2 |
EE20.3 | EE20.4 | EE35.1 | EE35.2 | EE520 |
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. |
|
||||||
EXP-VENDOR Element: Employee | Alpha 9 (Right Justified) The employee number. Must be a valid vendor record in the Accounts Payable Vendor file. |
|
||||||
EXP-EXPENSE-NBR Element: Expense Nbr | Alpha 10 A unique number assigned to the employee expense. |
|
||||||
EXP-EXPENSE-TYPE Element: Expense Type | Alpha 1 Identifies the type of employee expense. Valid values are: E = Expense. P = Cash Payback. |
|
||||||
EXP-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The description assigned to the employee expense report. |
|
||||||
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). |
|
||||||
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. |
|
||||||
EXP-EXPENSE-DATE Element: Date | Numeric 8 (yyyymmdd) The date the expense was incurred. |
|
||||||
EXP-DUE-DATE Element: Due Date | Numeric 8 (yyyymmdd) This field is not used. |
|
||||||
EXP-DISTRIB-DATE Element: Post Date | Numeric 8 (yyyymmdd) The date used for posting expense distributions to the general ledger. |
|
||||||
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. |
|
||||||
EXP-TRAN-ND Element: Acct Nd | Numeric 1 The number of decimal positions defined for the currency of the expense. |
|
||||||
EXP-BASE-EXP-AMT Base Currency Expense Amount | Signed 18.2 The amount of the employee expense in the company base currency. |
|
||||||
EXP-BASE-TAX-AMT Base Currency Tax Amount | Signed 18.2 The total tax amount of the expense in the company base currency. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
EXP-REFERENCE Element: Reference | Alpha 10 (Lower Case) The default reference assigned to the employee expense. Defaults on distributions entered for the expense. |
|
||||||
EXP-DIST-DESCRIPT Distribution Description | Alpha 30 (Lower Case) The default description assigned to the expense. Defaults on distributions entered for the expense. |
|
||||||
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. |
|
||||||
EXP-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||
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. |
|
||||||
EXP-CURR-EFF-DATE Element: Date | Numeric 8 (yyyymmdd) The effective date for the currency exchange rate. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
EXP-CROSS-REF Element: Cross Reference | Alpha 10 The cross reference value assigned to the employee expense. |
|
||||||
EXP-LAST-DIST-SEQ Element: Seq Nbr | Numeric 4 A system-assigned number used to track the last distribution entered for the employee expense. |
|
||||||
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. |
|
||||||
EXP-BASE-EMP-TOT Base Curr Employee Paid Amount | Signed 18.2 The total employee-paid expense amount in the company base currency. |
|
||||||
EXP-BASE-TAX-TOT Base Currency Tax Amount | Signed 18.2 The total tax amount for the employee expense in the company base currency. |
|
||||||
EXP-TRANS-IDENT Element: Transaction ID | Numeric 10 A unique system-generated identification value assigned to the transaction to make this record unique. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
EXP-JRNL-BOOK-NBR Element: Jrnl Book Nbr | Alpha 12 The journal book assigned to the transaction. |
|
||||||
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. |
|
||||||
EXP-CREATE-DATE Element: Create Date | Numeric 8 (yyyymmdd) The creation date. |
|
||||||
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). |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EXPSET1 |
COMPANY VENDOR EXPENSE-NBR |
|
| ||||||||||||||||||||||||||||||||||||
EXPSET2 |
COMPANY REC-STATUS VENDOR EXPENSE-NBR EXPENSE-TYPE |
|
| ||||||||||||||||||||||||||||||||||||
EXPSET3 |
COMPANY APPROVAL-CODE VENDOR EXPENSE-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apcompany | APCOMPANY |
Required
| |||||||||||||||||||||
Apinvoice | APINVOICE |
Not Required
| |||||||||||||||||||||
Appayment | APPAYMENT |
Not Required
| |||||||||||||||||||||
Apvenmast | APVENMAST |
Required
| |||||||||||||||||||||
Cbcashform | CBCASHFORM |
Required
| |||||||||||||||||||||
Cbcheck | CBCHECK |
Not Required
| |||||||||||||||||||||
Eeapproval | EEAPPROVAL |
Not Required
| |||||||||||||||||||||
Expbod | EXPBOD |
Not Required, Delete Cascades
| |||||||||||||||||||||
Glsystem | GLSYSTEM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Eeadvance | EEADVANCE |
| ||||||||||||
Eedistrib | EEDISTRIB |
Delete Cascades
| ||||||||||||
Eematching | EEMATCHING |
|
All trademarks and registered trademarks are the property of their
respective owners.