Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EPBATCH


                              EPBATCH FILE

REFERENCED BY

BL216

UPDATED BY

BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
OE10.1    OE10.2    OE10.3    OE10.4    OE10.5    OE10.6
OE10.7    OE10.8    OE11.1    OE11.4    OE11.8    OE11.9
OE110     OE111     OE113     OE114     OE129     OE13.2
OE13.3    OE13.5    OE14.4    OE30.1    OE30.2    OE30.3
OE30.4    OE30.5    OE30.6    OE30.7    OE30.9    OE510
OE530     OE810     OE830     WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

EPB-COMPANY            Numeric 4                                 BL120   OE110
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

EPB-EP-BATCH-ID        Numeric 12                                BL120   OE110
Element: Ep Batch Id

EPB-OPR-CODE           Alpha 10  (Lower Case)                    BL120   OE110
Element: Operator Code This field contains the operator code.
                       This is the user ID of the person who
                       last maintained this record.

EPB-DATE               Numeric 8  (yyyymmdd)                     BL120   OE110
Element: Date          This field displays the system date
                       when this was created.

EPB-TIME               Numeric 8                                 BL120   OE110
Element: Time          This field is updated automatically to
                       indicate the time that the GL entry was
                       created. It is system-maintained.

EPB-RNBR-STTL          Numeric 5                                 BL120   BL122
Element: Rnbr Sttl                                               BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

EPB-RSTTL-BASE         Signed 18.2                               BL120   BL122
Element: Intl Amt                                                BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

EPB-RSTTL-CURR         Signed 18.2                               BL120   BL122
Element: Intl Amt                                                BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

EPB-ANBR-STTL          Numeric 5
Element: Anbr Sttl

EPB-ASTTL-BASE         Signed 18.2
Element: Intl Amt

EPB-ASTTL-CURR         Signed 18.2
Element: Intl Amt

EPB-RNBR-AUTH          Numeric 5                                 BL120   BL122
Element: Rnbr Auth                                               BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   WH20.7

EPB-RAUTH-BASE         Signed 18.2                               BL120   BL122
Element: Intl Amt                                                BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   WH20.7

EPB-RAUTH-CURR         Signed 18.2                               BL120   BL122
Element: Intl Amt                                                BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE14.4  OE30.1
                                                                 OE30.2  OE30.3
                                                                 OE30.4  OE30.5
                                                                 OE30.6  OE30.7
                                                                 OE30.9  OE510
                                                                 OE530   OE810
                                                                 OE830   WH20.7

EPB-ANBR-AUTH          Numeric 5
Element: Anbr Auth

EPB-AAUTH-BASE         Signed 18.2
Element: Intl Amt

EPB-AAUTH-CURR         Signed 18.2
Element: Intl Amt

EPB-RNBR-VOID          Numeric 5
Element: Rnbr Void

EPB-RVOID-BASE         Signed 18.2
Element: Intl Amt

EPB-RVOID-CURR         Signed 18.2
Element: Intl Amt

EPB-ANBR-VOID          Numeric 5
Element: Anbr Void

EPB-AVOID-BASE         Signed 18.2
Element: Intl Amt

EPB-AVOID-CURR         Signed 18.2
Element: Intl Amt

EPB-RNBR-RETN          Numeric 5                                 BL120   BL122
Element: Rnbr Retn                                               BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

EPB-RRETN-BASE         Signed 18.2                               BL120   BL122
Element: Intl Amt                                                BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

EPB-RRETN-CURR         Signed 18.2                               BL120   BL122
Element: Intl Amt                                                BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830

EPB-ANBR-RETN          Numeric 5
Element: Anbr Retn

EPB-ARETN-BASE         Signed 18.2
Element: Intl Amt

EPB-ARETN-CURR         Signed 18.2
Element: Intl Amt

EPB-RNBR-ADJ           Numeric 5
Element: Rnbr Adj

EPB-RADJ-BASE          Signed 18.2
Element: Intl Amt

EPB-RADJ-CURR          Signed 18.2
Element: Intl Amt

EPB-ANBR-ADJ           Numeric 5
Element: Anbr Adj

EPB-AADJ-BASE          Signed 18.2
Element: Intl Amt

EPB-AADJ-CURR          Signed 18.2
Element: Intl Amt

                         EPBATCH FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EPBSET1   COMPANY                                                BL120   BL122
          EP-BATCH-ID                                            BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL216
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE129
                                                                 ...