EEEXPENSE

Employee Expense

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

REFERENCED BY
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM22.1 AM500 AM51.1 AM551 AM97.1
AP03.3 AP110 AP115 AP125 AP126 AP131
AP150 AP155 AP160 AP161 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP210
AP220 AP23.1 AP230 AP240 AP245 AP246
AP25.1 AP25.2 AP250 AP26.1 AP27.1 AP271
AP30.2 AP30.4 AP32.1 AP510 AP520 AP90.1
AP91.1 API1.1 API2.1 API3.1 API4.1 ZA161
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 EE175 EE220
EE275 EE30.1 EE90.2 EEBD.1 EEBD.2 EEI1.1
DR100 IC12.1 IC140 IC141 IC142 IC145
IC243 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC83.1 IC840 MX123 MX500 MA126 MA180
MA278 MA279 MA41.1 MA41.2 MA41.4 MA41.7
MA42.1 MA42.2 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA44.1 MA44.2 MA53.1 MA530
MA531 MA540 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA65.1 MA66.2 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA69.1 MA70.1 MA75.1 MA80.1
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PD235 PD570 PO04.1 PO04.2 PO10.1
PO10.2 PO100 PO101 PO115 PO120 PO122
PO131 PO132 PO136 PO15.1 PO15.2 PO15.4
PO150 PO17.1 PO190 PO192 PO195 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.2 PO22.3 PO22.4
PO22.5 PO220 PO222 PO223 PO224 PO225
PO229 PO23.1 PO230 PO233 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO253
PO254 PO26.3 PO26.7 PO26.9 PO27.2 PO27.3
PO27.4 PO275 PO276 PO277 PO278 PO28.2
PO280 PO29.1 PO30.1 PO30.2 PO30.3 PO30.4
PO300 PO31.1 PO31.2 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO529
PO536 PO54.1 PO54.2 PO54.3 PO54.4 PO54.5
POCP.1 POI3.1 POID.1 POII.1 POIJ.1 PR05.1
PR05.3 PR226 PR247 PR26.1 PR47.1 PR514
RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5
RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ260 RQ35.1
RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1 RQII.1
RQIJ.1 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
EE230 EE235


UPDATED 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.
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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EXPSET1 COMPANY
VENDOR
EXPENSE-NBR
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 AP155
AP160 AP161
AP20.1 AP20.2
EXPSET2 COMPANY
REC-STATUS
VENDOR
EXPENSE-NBR
EXPENSE-TYPE
KeyChange
AP55.1 EE11.1
EE20.2 EE20.3
EE20.4 EE230
EXPSET3 COMPANY
APPROVAL-CODE
VENDOR
EXPENSE-NBR
KeyChange, Subset
Where(REC-STATUS =Zeroes)
EE135 EE220
EE235 EE35.2


EEEXPENSE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
EXP-COMPANY->CPY-COMPANY
Apinvoice APINVOICE Not Required
EXP-COMPANY->API-COMPANY
EXP-VENDOR->API-VENDOR
EXP-EXPENSE-NBR->API-INVOICE
Zeroes->API-SUFFIX
Zeroes->API-CANCEL-SEQ
Appayment APPAYMENT Not 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
Apvenmast APVENMAST Required
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
EXP-VENDOR->VEN-VENDOR
Cbcashform CBCASHFORM Required
APP-CASH-CODE->CCF-CASH-CODE
APP-BANK-INST-CODE->CCF-BANK-INST-CODE
APP-PROC-GRP->CCF-PROC-GRP
Cbcheck CBCHECK Not Required
APP-CASH-CODE->CHK-CASH-CODE
APP-BANK-INST-CODE->CHK-BANK-INST-CODE
APP-TRANS-IDENT->CHK-TRANS-IDENT
Eeapproval EEAPPROVAL Not Required
EXP-COMPANY->EAP-COMPANY
EXP-APPROVAL-CODE->EAP-APPROVAL-CODE
Expbod EXPBOD Not Required, Delete Cascades
EXP-COMPANY->EEB-COMPANY
EXP-VENDOR->EEB-VENDOR
EXP-EXPENSE-NBR->EEB-EXPENSE-NBR
Glsystem GLSYSTEM Required
EXP-COMPANY->GLS-COMPANY


EEEXPENSE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Eeadvance EEADVANCE
EXP-COMPANY->EEA-COMPANY
EXP-VENDOR->EEA-VENDOR
  EEA-ADVANCE-NBR
Eedistrib EEDISTRIB Delete Cascades
EXP-COMPANY->EED-COMPANY
EXP-VENDOR->EED-VENDOR
EXP-EXPENSE-NBR->EED-EXPENSE-NBR
  EED-SEQ-NBR
Eematching EEMATCHING
EXP-COMPANY->EEM-COMPANY
EXP-VENDOR->EEM-VENDOR
EXP-EXPENSE-NBR->EEM-EXPENSE-NBR
  EEM-ADVANCE-NBR


File created: Thu Jun 09 02:07:47 2016

Home
Contact Us



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