Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ETRESABPLN


                            ETRESABPLN FILE

UPDATED BY

ET700

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ERP-ABP-ID             Numeric 10
Element: Numeric 1

ERP-ABP-COMPANY        Numeric 10                                ET700
Element: Numeric 1

ERP-ABP-RES-ID         Numeric 10                                ET700
Element: Numeric 1

ERP-ABP-AP-ID          Numeric 10                                ET700
Element: Numeric 1

ERP-ABP-AB-PLAN        Alpha 10                                  ET700
Element: Psa Plan

ERP-ABP-HREMPGRP       Alpha 12                                  ET700
Element: Alpha 12

ERP-ABP-POSITION       Alpha 12                                  ET700
Element: Alpha 12

ERP-ABP-BEGIN-DATE     Numeric 8  (yyyymmdd)                     ET700
Element: Date

ERP-ABP-END-DATE       Numeric 8  (yyyymmdd)                     ET700
Element: Date

ERP-ABP-UPDATE-DT      Numeric 8  (yyyymmdd)                     ET700
Element: Date

ERP-ABP-REAS-CODE      Numeric 10
Element: Numeric 1

ERP-ABP-AVAIL-HRS      Signed 12.2                               ET700
Element: Signed 9

ERP-ABP-CARRY-HRS      Signed 12.2                               ET700
Element: Signed 9

ERP-ABP-CARRY-DATE     Numeric 8  (yyyymmdd)                     ET700
Element: Date

ERP-ABP-OPEN-HOURS     Signed 12.2
Element: Signed 9

ERP-ABP-RES-HOURS      Signed 12.2                               ET700
Element: Signed 9

ERP-ABP-REQ-HOURS      Signed 12.2
Element: Signed 9

ERP-ABP-PEND-HOURS     Signed 12.2
Element: Signed 9

ERP-ABP-APP-HOURS      Signed 12.2
Element: Signed 9

ERP-ABP-REJ-HOURS      Signed 12.2
Element: Signed 9

ERP-ABP-REP-HOURS      Signed 12.2
Element: Signed 9

ERP-ABP-STATUS         Numeric 10
Element: Numeric 1

                         ETRESABPLN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ERPSET1   ABP-ID

ERPSET2   ABP-COMPANY                                            ET700
          ABP-RES-ID
          ABP-AB-PLAN
          ABP-HREMPGRP
          ABP-POSITION
          ABP-ID