Employee Advance

The Employee Advance file contains employee advance records created in the Lawson Employee Expense system.

REFERENCED BY

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

UPDATED BY

AP30.4	AP30.2	AP300	AP305	AP55.1	EE135
EE20.1	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	AP510
AP90.1	AP91.1	API1.1	API2.1	API3.1	API4.1
EE220	EE90.1	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
EEA-COMPANY Element: Company	Numeric 4 The company number. Must be a valid record in the Accounts Payable Company file.	EE20.1
EEA-VENDOR Element: Vendor	Alpha 9 (Right Justified) The employee number. Must be a valid vendor record in the Accounts Payable Vendor file.	EE20.1
EEA-ADVANCE-NBR Element: Advance Nbr	Alpha 10 A unique number assigned to the employee advance.	EE20.1
EEA-ADV-DESC Element: Item Desc	Alpha 30 The description of the advance.	EE20.1
EEA-REC-STATUS Element: Rec Status	Numeric 1 The record status of the advance. Valid values are: 0 = Unreleased. 1 = Released.	EE135 EE20.1 EE35.1 EE35.2 EE520
EEA-APPROVAL-CODE Element: Auth Code	Alpha 3 The approval code assigned to the employee advance. 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.1 EE35.1
EEA-PROC-LEVEL Element: Process Level	Alpha 5 The process level assigned to the employee advance. Must be a valid record in the Accounts Payable Process Level file.	EE20.1
EEA-TRAN-ADV-AMT Element: Intl Amt	Signed 18.2 The amount of the employee advance. Must be entered in company base currency. This field contains the same value as the Base Advance Amount field.	EE20.1
EEA-TRAN-ND Element: Acct Nd	Numeric 1 The number of decimal positions defined for the currency of the advance.	EE20.1
EEA-BASE-ADV-AMT Base Currency Advance Amount	Signed 18.2 The amount of the employee advance in the company base currency.	EE20.1
EEA-ADV-CURRENCY Element: Transaction Currency	Alpha 5 The currency of the employee advance. Defaults the company base currency. Must be a valid record in the Currency Code file.	EE20.1
EEA-CURR-RATE Element: Curr Rate	Signed 14.7 The exchange rate used to convert the transaction advance amount to the company base currency.	EE20.1
EEA-CURR-EFF-DATE Element: Date	Numeric 8 (yyyymmdd) The effective date for the currency exchange rate.
EEA-ADVANCE-DATE Element: Date	Numeric 8 (yyyymmdd) The date the employee advance was authorized. Used when updating the employee's balance (vendor balance).	EE20.1
EEA-CASH-CODE Element: Cash Code	Alpha 4 The cash code assigned to the employee advance. Represents the bank account the advance is paid from. Must be a valid record in the Cash Code file.	EE20.1
EEA-ACCR-CODE Element: Invoice Accrual Code	Alpha 4 The invoice accrual code assigned to the employee advance. Used to default a general ledger accrual account to the advance. Must be a valid record in the Invoice Accrual Code file.	EE20.1
EEA-HLD-CODE Element: Hld Code Ap	Alpha 4 The hold code assigned to the employee advance, if assigned. Used to prevent the advance 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.1 EE35.1
EEA-HOLD-TYPE Element: Hold Type	Alpha 1 Indicates the type of invoice hold code assigned to the employee advance. Valid values are: T = Temporary. Upon release to Accounts Payable, the advance will be held for only one payment cycle. AP170 (Payment Closing) removes the hold code from the advance record. P = Permanent. Upon release to Accounts Payable, the advance will be held until you remove the hold code from the advance record. Blank. A hold code is not assigned to the employee advance.	EE20.1 EE35.1
EEA-REL-FOR-PMT Element: All Flag	Alpha 1 Indicates whether the advance can be released to Accounts Payable. Valid values are: Y = Yes. N = No.	EE20.1 EE35.1
EEA-TRANS-NBR Element: Payment Number	Alpha 10 (Right Justified) The payment number assigned to the employee advance if paid with a manual payment. This field is zero for an advance payment issued with a system payment in Accounts Payable.	AP55.1 EE20.1
EEA-BANK-INST-CODE Cash Payment Transaction Code	Alpha 3 The payment code assigned to the employee advance. Represents a type of cash payment. Must be a valid cash payment type bank transaction code record in the Bank Transaction Code file.	EE20.1
EEA-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.1
EEA-CHECK-AMT Element: Intl Amt	Signed 18.2 The manual payment amount issued for the employee advance. Defaults the company base currency advance amount.	EE20.1
EEA-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.1
EEA-APPROVED-FLAG Element: Approved Flag	Alpha 1 Indicates whether the invoice is approved for payment.	EE20.1
EEA-REMIT-TO-CODE Element: Remit To Code	Alpha 4 A user-defined code that represents a vendor's remittance address.	EE20.1
EEA-JRNL-BOOK-NBR Element: Jrnl Book Nbr	Alpha 12 The journal book assigned to the transaction.
EEA-PAY-GROUP Element: Pay Group	Alpha 4 The pay group associated with the employee advance. Must be a valid record in the Pay Group file.	EE20.1
EEA-CREATE-DATE Element: Create Date	Numeric 8 (yyyymmdd) The creation date.	EE20.1
EEA-AP-STATUS Element: AP Record Status	Derived The record status of the employee advance in the Lawson Accounts Payable system. Used when matching paid advances to expenses. Valid values are: 1 = Released. 9 = Historical. Blank. Not released to Accounts Payable.
EEA-ACTIVITY Element: Activity	Alpha 15	EE20.1
EEA-ACCT-CATEGORY Element: Acct Category	Alpha 5	EE20.1
EEA-GLT-OBJ-ID Element: Obj Id	Numeric 12
EEA-ATN-OBJ-ID Element: Obj Id	Numeric 12

EEADVANCE FILE INDEX

EEADVANCE FILE RELATIONS

ONE TO ONE RELATIONS

EEADVANCE FILE RELATIONS

ONE TO MANY RELATIONS

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