Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EEADVANCE


                             EEADVANCE FILE

                            Employee Advance

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

REFERENCED BY

AM115     AM15.1    AM15.2    AM15.3    AM15.4    AM20.1
AM20.3    AM21.1    AM21.3    AM500     AM51.1    AM551
AM97.1    AP125     AP126     AP131     AP150     AP155
AP160     AP161     AP20.1    AP20.2    AP20.3    AP20.4
AP20.5    AP20.7    AP23.1    AP230     AP240     AP245
AP25.1    AP25.2    AP250     AP26.1    AP27.1    AP32.1
AP520     API1.1    API2.1    API3.1    API4.1    AR48.3
EE220     EE90.1    EEI1.1    IC28.1    IC840     MA180
MA41.2    MA41.7    MA43.1    MA43.2    MA43.3    MA43.9
MA530     MA531     MA540     MA60.2    MA60.3    MA60.5
MA61.1    MA66.2    MA66.3    MA67.1    MA67.2    MA70.1
MA75.1    MA80.1    MAI1.1    PO100     PO101     PO122
PO131     PO20.1    PO21.1    PO21.2    PO21.3    PO21.4
PO21.5    PO22.1    PO23.1    PO25.1    PO25.5    PO25.6
PO25.7    PO27.2    PO29.1    PO30.1    PO30.2    PO30.3
PO300     PO31.1    PO31.2    PO32.2    PO33.1    PO34.1
PO35.1    PO36.1    PO36.2    PO38.1    PO39.1    PO39.2
PO44.1    PO50.1    PO52.1    PO520     PO536     POI3.1
POII.1    POIJ.1    PR05.1    PR05.3    PR226     PR247
PR26.1    PR47.1    PR514     UK47.1    RQ10.1    RQ10.2
RQ10.3    RQIE.1    WH20.2    WH20.7    AP55.1    EE230
EE235

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

EEA-COMPANY            Numeric 4                                 EE20.1
Element: Company       The company number. Must be a valid
                       record in the Accounts Payable Company
                       file.

EEA-VENDOR             Alpha 9  (Right Justified)                EE20.1
Element: Vendor ID     The employee number. Must be a valid
                       vendor record in the Accounts Payable
                       Vendor file.

EEA-ADVANCE-NBR        Alpha 10                                  EE20.1
Element: Advance NumberA unique number assigned to the
                       employee advance.

EEA-ADV-DESC           Alpha 30                                  EE20.1
Element: Item DescriptiThe description of the advance.

EEA-REC-STATUS         Numeric 1                                 EE135   EE20.1
Element: Record Status The record status of the advance. Valid   EE35.1  EE35.2
                       values are:                               EE520

                       0 = Unreleased.
                       1 = Released.

EEA-APPROVAL-CODE      Alpha 3                                   EE20.1  EE35.1
Element: Authority CodeThe 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.

EEA-PROC-LEVEL         Alpha 5                                   EE20.1
Element: Process Level The process level assigned to the
                       employee advance. Must be a valid record
                       in the Accounts Payable Process Level
                       file.

EEA-TRAN-ADV-AMT       Signed 15.2                               EE20.1
Element: Adj Amt       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.

EEA-TRAN-ND            Numeric 1                                 EE20.1
Account Currency       The number of decimal positions defined
Code                   for the currency of the advance.

EEA-BASE-ADV-AMT       Signed 15.2                               EE20.1
Base Currency          The amount of the employee advance in
Advance Amount         the company base currency.

EEA-ADV-CURRENCY       Alpha 5                                   EE20.1
Element: Transaction CuThe currency of the employee advance.
                       Defaults the company base currency. Must
                       be a valid record in the Currency Code
                       file.

EEA-CURR-RATE          Signed 13.6                               EE20.1
Element: Currency Rate The exchange rate used to convert the
                       transaction advance amount to the
                       company base currency.

EEA-CURR-EFF-DATE      Numeric 8  (yyyymmdd)
Element: Date          The effective date for the currency
                       exchange rate.

EEA-ADVANCE-DATE       Numeric 8  (yyyymmdd)                     EE20.1
Element: Date          The date the employee advance was
                       authorized. Used when updating the
                       employee's balance (vendor balance).

EEA-CASH-CODE          Alpha 4                                   EE20.1
Accounts Receivable    The cash code assigned to the employee
Code                   advance. Represents the bank account the
                       advance is paid from. Must be a valid
                       record in the Cash Code file.

EEA-ACCR-CODE          Alpha 4                                   EE20.1
Element: Invoice AccruaThe 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.

EEA-HLD-CODE           Alpha 4                                   EE20.1  EE35.1
Accounts Receivable    The hold code assigned to the employee
Code                   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.

EEA-HOLD-TYPE          Alpha 1                                   EE20.1  EE35.1
Element: Hold Type     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.

EEA-REL-FOR-PMT        Alpha 1                                   EE20.1  EE35.1
Element: All Flag      Indicates whether the advance can be
                       released to Accounts Payable. Valid
                       values are:

                       Y = Yes.
                       N = No.

EEA-TRANS-NBR          Alpha 10  (Right Justified)               EE20.1
Element: Payment NumberThe 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.

EEA-BANK-INST-CODE     Alpha 3                                   EE20.1
Cash Payment           The payment code assigned to the
Transaction Code       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.

EEA-CHECK-DATE         Numeric 8  (yyyymmdd)                     EE20.1
Element: Date          The date assigned to the manual
                       payment. This date is assigned to
                       general ledger transactions created for
                       the payment.

EEA-CHECK-AMT          Signed 15.2                               EE20.1
Element: Adj Amt       The manual payment amount issued for
                       the employee advance. Defaults the
                       company base currency advance amount.

EEA-TRANS-IDENT        Numeric 10                                EE20.1
Element: Transaction IDA unique system-generated
                       identification value assigned to the
                       transaction to make this record unique.

EEA-APPROVED-FLAG      Alpha 1                                   EE20.1
Element: Approved      Indicates whether the invoice is
                       approved for payment.

EEA-REMIT-TO-CODE      Alpha 4                                   EE20.1
Purchase From
Location Code

EEA-JRNL-BOOK-NBR      Alpha 12
Element: Journal Book  The journal book assigned to the
                       transaction.

EEA-PAY-GROUP          Alpha 4                                   EE20.1
Element: Pay Group     The pay group associated with the
                       employee advance. Must be a valid record
                       in the Pay Group file.

EEA-CREATE-DATE        Numeric 8  (yyyymmdd)                     EE20.1
Element: Date

EEA-AP-STATUS          Derived
Element: AP Record StatThe 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.

                         EEADVANCE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EEASET1   COMPANY       This index is used to access employee    AM115   AM15.1
          VENDOR        advance records for a specific employee  AM15.2  AM15.3
          ADVANCE-NBR   and company.                             AM15.4  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP125
                                                                 AP126   AP131
                                                                 AP150   AP155
                                                                 AP160   AP161
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP230
                                                                 AP240   AP245
                                                                 ...

EEASET2   COMPANY       This index is used to access unreleased  AP55.1  EE20.1
          REC-STATUS    advance records for an employee.         EE230
          VENDOR        KeyChange
          ADVANCE-NBR

EEASET3   COMPANY       This index is used to access unreleased  EE135   EE220
          APPROVAL-CODE employee advance records for a specific  EE235   EE35.1
          VENDOR        approval code.
          ADVANCE-NBR   KeyChange, Subset
                        Where (REC-STATUS = Zeroes )

                         EEADVANCE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            EEA-COMPANY           -> CPY-COMPANY

Apinvoice1     APINVOICE    Not Required

                            EEA-COMPANY           -> API-COMPANY
                            EEA-VENDOR            -> API-VENDOR
                            EEA-ADVANCE-NBR       -> API-INVOICE
                            Zeroes                -> API-SUFFIX
                            Zeroes                -> API-CANCEL-SEQ

Apinvoice2     APINVOICE    Not Required

                            EEA-COMPANY           -> API-COMPANY
                            EEA-VENDOR            -> API-VENDOR
                            EEA-ADVANCE-NBR       -> API-INVOICE
                            1                     -> API-SUFFIX
                            Zeroes                -> API-CANCEL-SEQ

Appayment1     APPAYMENT    Required

                            EEA-COMPANY           -> APP-COMPANY
                            EEA-VENDOR            -> APP-VENDOR
                            EEA-ADVANCE-NBR       -> APP-INVOICE
                            Zeroes                -> APP-SUFFIX
                            Zeroes                -> APP-CANCEL-SEQ
                            1                     -> APP-SEQ-NBR
                            Zeroes                -> APP-VOID-SEQ

Appayment2     APPAYMENT    Not Required

                            EEA-COMPANY           -> APP-COMPANY
                            EEA-VENDOR            -> APP-VENDOR
                            EEA-ADVANCE-NBR       -> APP-INVOICE
                            1                     -> APP-SUFFIX
                            Zeroes                -> APP-CANCEL-SEQ
                            1                     -> APP-SEQ-NBR
                            Zeroes                -> APP-VOID-SEQ

Apvenmast      APVENMAST    Required

                            CPY-VENDOR-GROUP      -> VEN-VENDOR-GROUP
                            EEA-VENDOR            -> VEN-VENDOR

Cbcheck1       CBCHECK      Not Required
                            Valid When API-             = EEA-
                                  And  API-TRAN-INV-AMT = EEA-TRAN-PAID-AMT

                            APP-CASH-CODE         -> CHK-CASH-CODE
                            APP-BANK-INST-CODE    -> CHK-BANK-INST-CODE
                            APP-TRANS-IDENT       -> CHK-TRANS-IDENT

Cbcheck2       CBCHECK      Not Required

                            APP-CASH-CODE         -> CHK-CASH-CODE
                            APP-BANK-INST-CODE    -> CHK-BANK-INST-CODE
                            APP-TRANS-IDENT       -> CHK-TRANS-IDENT

Cbtrans1       CBTRANS      Not Required

                            APP-BANK-INST-CODE    -> CBT-BANK-INST-CODE
                            APP-TRANS-IDENT       -> CBT-TRANS-IDENT

Cbtrans2       CBTRANS      Not Required

                            APP-BANK-INST-CODE    -> CBT-BANK-INST-CODE
                            APP-TRANS-IDENT       -> CBT-TRANS-IDENT

Eeapproval     EEAPPROVAL   Required

                            EEA-COMPANY           -> EAP-COMPANY
                            EEA-APPROVAL-CODE     -> EAP-APPROVAL-CODE

Glsystem       GLSYSTEM     Required

                            EEA-COMPANY           -> GLS-COMPANY

                         EEADVANCE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Eematching     EEMATCHING

                            EEA-COMPANY           -> EEM-COMPANY
                            EEA-VENDOR            -> EEM-VENDOR
                            EEA-ADVANCE-NBR       -> EEM-ADVANCE-NBR
                                                     EEM-EXPENSE-NBR