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

AC160     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
AP155     AP160     AP161     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP210     AP220
AP23.1    AP230     AP240     AP245     AP25.1    AP25.2
AP250     AP26.1    AP27.1    AP32.1    AP510     AP520
AP90.1    AP91.1    API1.1    API2.1    API3.1    API4.1
AR48.3    BL120     BL122     BL130     BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL820
BL92.1    EE220     EE90.1    EEI1.1    MX123     MX500
MA180     MA279     MA41.1    MA41.2    MA41.4    MA41.7
MA43.1    MA43.2    MA43.3    MA43.4    MA43.6    MA43.7
MA530     MA531     MA60.2    MA60.3    MA60.5    MA61.1
MA63.1    MA65.1    MA66.2    MA66.3    MA67.2    MA67.3
MA68.2    MA68.3    MA68.5    MA70.1    MA75.1    MA80.1
MAI1.1    PD10.1    PD10.2    PD130     PD20.1    PD20.2
PD20.3    PD235     PO10.1    PO100     PO101     PO120
PO122     PO131     PO20.1    PO21.1    PO21.2    PO21.3
PO21.4    PO21.5    PO22.1    PO220     PO223     PO23.1
PO233     PO24.1    PO25.1    PO25.5    PO25.6    PO25.7
PO253     PO254     PO27.2    PO278     PO29.1    PO30.1
PO30.2    PO30.3    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     PO536     PO54.1    PO54.2    PO54.3    PO54.4
POI3.1    POID.1    POII.1    POIJ.1    PR05.1    PR05.3
PR226     PR247     PR26.1    PR47.1    PR514     UK47.1
RQ10.1    RQ10.2    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        The employee number. Must be a valid
                       vendor record in the Accounts Payable
                       Vendor file.

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

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

EEA-REC-STATUS         Numeric 1                                 EE135   EE20.1
Element: Rec 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: Auth Code     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.

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 18.2                               EE20.1
Element: Intl 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
Element: Acct Nd       The number of decimal positions defined
                       for the currency of the advance.

EEA-BASE-ADV-AMT       Signed 18.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 14.7                               EE20.1
Element: Curr 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
Element: Cash Code     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.

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
Element: Hld Code Ap   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.

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: Check Date    The date assigned to the manual
                       payment. This date is assigned to
                       general ledger transactions created for
                       the payment.

EEA-CHECK-AMT          Signed 18.2                               EE20.1
Element: Intl 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 Flag Indicates whether the invoice is
                       approved for payment.

EEA-REMIT-TO-CODE      Alpha 4                                   EE20.1
Element: Remit To Code A user-defined code that represents a
                       vendor's remittance address.

EEA-JRNL-BOOK-NBR      Alpha 12
Element: Jrnl Book Nbr 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: Create Date   The creation 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                                                AC160   AM115
          VENDOR                                                 AM117   AM15.1
          ADVANCE-NBR                                            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
                                                                 AP155   AP160
                                                                 AP161   AP20.1
                                                                 AP20.2  AP20.3
                                                                 ...

EEASET2   COMPANY       KeyChange                                AP55.1  EE20.1
          REC-STATUS                                             EE230
          VENDOR
          ADVANCE-NBR

EEASET3   COMPANY       KeyChange, Subset                        EE135   EE220
          APPROVAL-CODE Where (REC-STATUS = Zeroes )             EE235   EE35.1
          VENDOR
          ADVANCE-NBR

                         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