EEADVANCE – Employee Advance
- System
- Accounts Payable (AP)
- Prefix
EEA- Primary key
COMPANY,VENDOR,ADVANCE-NBR- Fields
- 34
- Updated by
- 9 programs
- Referenced by
- 301 programs
EEADVANCE is the Employee Advance table in Lawson Accounts Payable (prefix EEA). It is indexed by COMPANY, VENDOR, ADVANCE-NBR (EEASET1); alternate indexes: EEASET2 and EEASET3. It is related 1:1 to APCOMPANY, APINVOICE, APPAYMENT, APVENMAST, CBCHECK, CBTRANS, EEAPPROVAL and GLSYSTEM and 1:M to EEMATCHING. It is updated by AP30.4, AP300, AP305, AP55.1, EE135, EE20.1, EE35.1, EE35.2 and 1 more and referenced by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 293 more. The table has 34 fields, 3 indexes and 13 documented relations.
About EEADVANCE
The Employee Advance file contains employee advance records created in the Lawson Employee Expense system.
Fields (34)
Column = COBOL field name without the EEA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#EEA-COMPANY PKCOMPANY | Numeric 4 | The company number. Must be a valid record in the Accounts Payable Company file. | EE20.1 |
#EEA-VENDOR PKVENDOR | Alpha 9 (Right Justified) | The employee number. Must be a valid vendor record in the Accounts Payable Vendor file. | EE20.1 |
#EEA-ADVANCE-NBR PKADVANCE_NBR | Alpha 10 | A unique number assigned to the employee advance. | EE20.1 |
#EEA-ADV-DESCADV_DESC | Alpha 30 | The description of the advance. | EE20.1 |
#EEA-REC-STATUS SET2REC_STATUS | Numeric 1 | The record status of the advance. Valid values are:
| EE135, EE20.1, EE35.1, EE35.2, EE520 |
#EEA-APPROVAL-CODE SET3APPROVAL_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-LEVELPROC_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-AMTTRAN_ADV_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-NDTRAN_ND | Numeric 1 | The number of decimal positions defined for the currency of the advance. | EE20.1 |
#EEA-BASE-ADV-AMTBASE_ADV_AMT | Signed 18.2 | The amount of the employee advance in the company base currency. | EE20.1 |
#EEA-ADV-CURRENCYADV_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-RATECURR_RATE | Signed 14.7 | The exchange rate used to convert the transaction advance amount to the company base currency. | EE20.1 |
#EEA-CURR-EFF-DATECURR_EFF_DATE | Numeric 8 (yyyymmdd) | The effective date for the currency exchange rate. | — |
#EEA-ADVANCE-DATEADVANCE_DATE | Numeric 8 (yyyymmdd) | The date the employee advance was authorized. Used when updating the employee's balance (vendor balance). | EE20.1 |
#EEA-CASH-CODECASH_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-CODEACCR_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-CODEHLD_CODE | 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-TYPEHOLD_TYPE | Alpha 1 | Indicates the type of invoice hold code assigned to the employee advance. Valid values are: Payable, the advance will be held for only one payment cycle. AP170 (Payment Closing) removes the hold code from the advance record. 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-PMTREL_FOR_PMT | Alpha 1 | Indicates whether the advance can be released to Accounts Payable. Valid values are:
| EE20.1, EE35.1 |
#EEA-TRANS-NBRTRANS_NBR | 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-CODEBANK_INST_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-DATECHECK_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-AMTCHECK_AMT | Signed 18.2 | The manual payment amount issued for the employee advance. Defaults the company base currency advance amount. | EE20.1 |
#EEA-TRANS-IDENTTRANS_IDENT | Numeric 10 | A unique system-generated identification value assigned to the transaction to make this record unique. | AP55.1, EE20.1 |
#EEA-APPROVED-FLAGAPPROVED_FLAG | Alpha 1 | Indicates whether the invoice is approved for payment. | EE20.1 |
#EEA-REMIT-TO-CODEREMIT_TO_CODE | Alpha 4 | A user-defined code that represents a vendor's remittance address. | EE20.1 |
#EEA-JRNL-BOOK-NBRJRNL_BOOK_NBR | Alpha 12 | The journal book assigned to the transaction. | — |
#EEA-PAY-GROUPPAY_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-DATECREATE_DATE | Numeric 8 (yyyymmdd) | The creation date. | EE20.1 |
#EEA-AP-STATUSAP_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: Blank. Not released to Accounts Payable.
| — |
#EEA-ACTIVITYACTIVITY | Alpha 15 | — | EE20.1 |
#EEA-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | — | EE20.1 |
#EEA-GLT-OBJ-IDGLT_OBJ_ID | Numeric 12 | — | — |
#EEA-ATN-OBJ-IDATN_OBJ_ID | Numeric 12 | — | — |
Indexes (3)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
EEASET1 |
| Primary | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source) | |
EEASET2 |
| KeyChange | AP55.1, EE20.1, EE230 | |
EEASET3 |
| KeyChange, Subset | Where (REC-STATUS = Zeroes) | EE135, EE220, EE235, EE35.1 |
Relations
One to one (12) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Apcompany | APCOMPANY | Required |
| ||||||||||||||||||||||
| Apinvoice1 | APINVOICE | Not Required |
| ||||||||||||||||||||||
| Apinvoice2 | APINVOICE | Not Required |
| ||||||||||||||||||||||
| Appayment1 | APPAYMENT | Required |
| ||||||||||||||||||||||
| Appayment2 | APPAYMENT | Not Required |
| ||||||||||||||||||||||
| Apvenmast | APVENMAST | Required |
| ||||||||||||||||||||||
| Cbcheck1 | CBCHECK | Not Required | Valid When API- = EEA- And API-TRAN-INV-AMT = EEA-TRAN-PAID-AMT |
| |||||||||||||||||||||
| Cbcheck2 | CBCHECK | Not Required |
| ||||||||||||||||||||||
| Cbtrans1 | CBTRANS | Not Required |
| ||||||||||||||||||||||
| Cbtrans2 | CBTRANS | Not Required |
| ||||||||||||||||||||||
| Eeapproval | EEAPPROVAL | Required |
| ||||||||||||||||||||||
| Glsystem | GLSYSTEM | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Eematching | EEMATCHING |
|
Programs
Updated by (9)
- AP30.4 Invoice Cancel
- AP300 Invoice and Vendor History Purge
- AP305 Accounts Payable Company Purge
- AP55.1 Cash Payment Entry
- EE135 Mass Employee Release
- EE20.1 Employee Advance
- EE35.1 Advance Release
- EE35.2 Expense Release
- EE520 Expense Interface
Referenced by (301)
- AC160 Asset Management Interface
- AM115 Mass Additions
- AM117 Mass Distribution Split
- AM15.1 Single Invoice Interface
- AM15.2 Combine Invoice Interface
- AM15.3 Single Activity Interface
- AM15.4 Combine Activity Interface
- AM19.1 PO Line Asset Detail
- AM19.2 Create Detail
- AM20.1 Quick Addition
- AM20.3 Items
- AM21.1 Leased Asset Quick Addition
- AM21.3 Items
- AM22.1 Items
- AM500 Asset Management Interface
- AM51.1 Item Update Adjust Interface Maint
- AM551 Item Update Adjustment Interface
- AM97.1 Item Interface Adjustment
- AP03.3 Query List Members
- AP110 Mass Vendor Update
- AP115 Vendor Merge
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP131 Chargeback
- AP150 Cash Requirements
- AP155 Payment Forms Creation
- AP160 Payment Tape Creation
- AP161 Electronic Payment File Creation
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP210 Vendor Listing
- AP220 Invoice Edit Report
- AP23.1 Transit Invoice Entry
- AP230 Open Payables Report
- AP240 Hold Payments Report
- AP245 Reportable Income Report
- AP246 Secondary Withholding Report
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP250 Cash Forecasting
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- AP271 Vendor Spend Report
- AP32.1 Workflow Approval Maintenance
- AP510 Vendor Conversion
- AP520 Invoice Interface
- AP90.1 Invoice Search by Vendor, Invoice
- AP91.1 Vendor Activity
- API1.1 Add Invoice
- API2.1 Add Invoice
- API3.1 Vendor Location Invoke
- API4.1 Vendor Master Invoke
- CX100 Pick List Print
- CX20.1 Case Build
- CX20.2 Case Detail
- CX20.4 Substitute Items
- CX20.5 Insert line
- CX220 Case, Preference Listing
- CX30.1 Case Completion Feedback
- CX300 Preference List Purge
- CX506 HL7 Schedules Import Interface
- CXCP.1 Copy preference to case
- DR100 Distribution Requirements Report
- EE220 Expense, Advance, or Payback Edit
- EE230 Expense or Advance Report
- EE235 Expense Release Edit
- EE90.1 Advance Inquiry
- EEI1.1 EE Comment Routine
- IC12.1 Item Location
- IC140 Vendor Reorder Advice
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC145 Stock Status Report
- IC243 Killed Item Report
- IC330 Item Mass Change
- IC64.1 Global Location Nbr Assignment GL/IC Company
- IC64.2 Global Location Nbr Assignment IC Location
- IC64.3 Global Location Number Assignment RQ Location
- IC64.4 Global Location Number Assignment Manuf Code
- IC64.5 Global Location Number Assignment Manuf Div
- IC64.6 Global Location Number Assignment Vendor
- IC64.7 Global Location Number Assignment Vendor Location
- IC64.8 Global Location Number Assignment IC Bin
- IC64.9 Global Location Number Assignment Buyer
- IC66.1 Replenishment PO Worksheet
- IC83.1 Par Location Counts
- IC840 Cart Par Location Conversion
- MA126 Auto Matching
- MA180 Open Receipt Archive
- MA278 Cost Variance Analysis
- MA279 Invoice AOC Detail Report
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.1 Memo Line Detail - Purchase Order
- MA42.2 Memo Line AOC Detail
- MA43.1 Invoice Line Detail - Purchase Order
- MA43.2 Purchase Order Lookup
- MA43.3 Invoice Line Detail - Receipt
- MA43.4 Invoice Line Detail - Service
- MA43.6 Service Agreement Detail
- MA43.7 GL Distribution
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA53.1 Receipt Interface
- MA530 ERS Invoice Creation
- MA531 Receipt Interface
- MA540 Invoice Interface
- MA60.2 Invoice Level Match
- MA60.3 Detail Level Match
- MA60.5 Receipt Match Reference Adjustment
- MA61.1 Match Invoice Approval
- MA63.1 Invoice Line Match
- MA65.1 Invoice Line Adjustment
- MA66.2 Invoice Message - Details
- MA67.2 Invoice Match from frontend
- MA67.3 Detail Match from frontend
- MA68.2 Invoice Level Match - Prepaid
- MA68.3 Detail Level Match - Prepaid
- MA68.5 Receipt Match Reference Adjustment
- MA69.1 AOC Level Detail Match
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
- MA80.1 Receipt Archive
- MAI1.1 Invoke for MAMATCH Object
- MX123 List Member Build
- MX500 Attribute Value Population
- PD10.1 P-Card Card Request
- PD10.2 P-Card Cardholder
- PD130 P-Card Invoice and Release
- PD20.1 P-Card Charge Approval
- PD20.2 P-Card Charge Approval Level
- PD20.3 P-Card Charge Approval SEA
- PD235 P-Card Merchant Report
- PD570 P-Card Charge Import
- PO04.1 Buyer
- PO04.2 Buyer Purchasing Class
- PO10.1 PO Vendor
- PO10.2 Vendor Purchase From Location
- PO100 Purchase Order Interface from Lawson Applications
- PO101 Create Standing PO Release
- PO115 Procurement Template Mass Changes
- PO120 Mass PO Issue
- PO122 Transmitted PO Acknowledgement
- PO131 Receiving Log
- PO132 Print Vendor Return Material Authorization
- PO136 Matched, Not Received Report
- PO15.1 Procurement Templates
- PO15.2 Procurement Template Participants
- PO15.4 Procurement Template Line Detail
- PO150 Bid Load to Contract or Catalog
- PO17.1 Purchase Order Approval Review
- PO190 Close Purchase Order Header
- PO192 PO Vendor Item Audit Report
- PO195 PO Vendor Agreement Audit Report
- PO20.1 Purchase Order Entry
- PO20.6 Substitute Vendor Items
- PO20.9 Multiple Lines
- PO204 Buyer Master Listing
- PO21.1 Select and Copy
- PO21.2 Add-On Cost Spread
- PO21.3 Account Distribution
- PO21.4 Miscellaneous Add-On Cost
- PO21.5 Item Add-On Cost
- PO22.1 Authorization, Release
- PO22.2 Mass Cancel or Delete Purchase Orders
- PO22.3 Mass Cancel or Delete Purchase Orders
- PO22.4 Mass Cancel or Delete Purchase Order Lines
- PO22.5 Purchase Order Line Inquiry
- PO220 PO Status Report
- PO222 Remaining PO Balance Report
- PO223 Buyer Expediting Report
- PO224 PO Revision Report
- PO225 Vendor Agreement Listing
- PO229 Vendor Agreement Format Print
- PO23.1 Purchase Order Worksheet
- PO230 Unreleased Receivings Listing
- PO233 PO Received Quantity Exceptions
- PO234 PO Interface Listing Report
- PO24.1 Purchase Order Direct Approval
- PO25.1 Vendor Agreements
- PO25.5 Vendor Agreement Item Add-On Cost
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO251 PO Buyer Message Listing
- PO253 Item Receipt Volume Report
- PO254 PO Inquiry Report
- PO26.3 Vendor Agreement Commitments Spread
- PO26.7 Mass Release of Vendor Agreements
- PO26.9 Vendor Agreement Release
- PO27.2 Select Blanket Lines
- PO27.3 Create PO From Procurement Template
- PO27.4 Select and Copy Template
- PO275 Delivery Date Analysis
- PO276 Deliver Quantity Analysis
- PO277 Deliver Quality Analysis
- PO278 RNI Aging Report
- PO28.2 Vendor Agreement Line Detail List
- PO280 Purchases By Class
- PO29.1 Copy Purchase Order
- PO30.1 PO Receiving
- PO30.2 Substitute Item
- PO30.3 Additional Tracking Numbers
- PO30.4 PO Receiving Line Detail List
- PO300 PO and Receipt Purge
- PO31.1 Vendor Return
- PO31.2 Vendor Return Item Selection
- PO32.2 Item Detail
- PO32.4 Cancel Detail
- PO33.1 Receiving Adjustment
- PO34.1 Inspection Accept or Reject
- PO35.1 Receiving Approval and Release
- PO36.1 Identify Lawson Items by Vendor Agreement Line
- PO36.2 Vendor Agreement Import Manual Input
- PO38.1 Invoice AOC
- PO39.1 Additional Receiving Entry
- PO39.2 Additional Adjustment/Rejection Entry
- PO44.1 PO Line Source
- PO50.1 Buyer Message Entry
- PO52.1 Buyer Message - Receiving
- PO520 Purchase Order Interface from Non Lawson
- PO529 PO Receiving File Create
- PO536 Vendor Price Agreement Load
- PO54.1 Purchase Order Inquiry
- PO54.2 Purchase Order Inquiry
- PO54.3 Purchase Order Inquiry
- PO54.4 Purchase Order Inquiry
- PO54.5 PO Line Detail List
- POCP.1 POC Comments Copy
- POI3.1 Invoke for POPI70PD
- POID.1 PO Delivery Ticket Select
- POII.1 Invoke for POPCRUPD
- POIJ.1 Invoke for POPLIUPD
- PR05.1 Deduction
- PR05.3 Additional Vendors
- PR226 United States Employee Garnishment Listing
- PR247 Canada Employee Garnishment Listing
- PR26.1 United States Employee Garnishment
- PR47.1 Canada Employee Garnishment
- PR514 Employee Deduction Master Load
- RQ01.1 Requesting Locations
- RQ10.1 Requisition
- RQ10.2 Account Distribution
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ12.1 Approval Review
- RQ13.1 Direct Approval
- RQ13.2 Direct Line Approval
- RQ260 Requisitioned Items Report
- RQ35.1 Requisition Returns
- RQ44.1 Requisition Inquiry
- RQ500 Requisition Interface
- RQ810 Request Location Load
- RQIB.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQII.1 Invoke for Reqheader Inquiry
- RQIJ.1 Requisition Copy
- WH130 Pick List Print
- WH132 Batch Feedback
- WH190 Shipment Release
- WH20.2 Nonstock and Special Allocation
- WH20.7 Substitute Location
- WH222 Shipments In Process
- WH30.1 Picking Feedback by Document
- WH30.2 Picking Feedback by Shipment
- WH30.3 Picking by Batch
- WH30.4 Bin Sequence Picking Feedback
- WH31.1 Packing Feedback by Document
- WH31.2 Packing Feedback by Shipment
- WH31.3 Packing by Batch
- WH31.4 Bin Sequence Packing Feedback
- WH32.1 Shipping Feedback by Document
- WH32.2 Shipping Feedback by Shipment
- WH32.3 Shipping by Batch
- WH32.4 Bin Sequence Shipping Feedback
- WH32.5 Shipping Line Feedback
- WH33.1 Bins
- WH33.2 Lots
- WH33.3 Serials
- WH33.4 UOMs
- WH33.5 Additional Shipment Information
- WH33.6 Catch Weight
- WH33.8 Preassembled Kits
- WH33.9 Line Options
- WH34.1 Component Bins
- WH34.2 Component Lots
- WH34.3 Component Serials
- WH34.4 Component UOMs
- WH40.1 Bill of Lading
- WH40.2 Bill of Lading Feedback
- WH520 Batch Feedback Interface
- WH830 Shipment Load Program
- ZA161 Electronic Payment File Creation