Employee Advance

The Employee Advance file contains employee advance records 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
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	EE220	EE90.1	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

AP30.4	AP300	AP305	AP55.1	EE135	EE20.1
EE35.1	EE35.2	EE520

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.