Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EPTRANS


                              EPTRANS FILE

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

EPR-EP-BATCH-ID        Numeric 12
Element: Ep Batch Id

EPR-EP-TRANS-ID        Numeric 12
Element: Ep Trans Id

EPR-PRIORITY           Numeric 2
Element: Priority

EPR-DEPENDENCY         Alpha 1
Element: Dependency

EPR-GROUP-ID           Alpha 15  (Lower Case)
Element: Group Id

EPR-CUST-ID            Alpha 15
Element: Cust Id

EPR-EP-TRANS-TYPE      Alpha 1
Element: Ep Trans Type

EPR-EP-TYPE            Alpha 5
Element: Ep Type

EPR-EP-ACCOUNT         Alpha 32
Element: Ep Account

EPR-DATE               Numeric 8  (yyyymmdd)
Element: Date          This field contains the system date
                       when this was created.

EPR-EP-STATUS          Alpha 10
Element: Ep Status

EPR-AMOUNT             Signed 15.2
Element: Amount        This is the amounts by period for the
                       specified record.

EPR-NBR-DECIMALS       Numeric 1
Number of Decimal      Number of decimals.
Places

EPR-TRANS-FEE          Signed 15.2
Element: Trans Fee

EPR-CURRENCYTYPE-A     Alpha 3
Element: Currencytype A

EPR-CURRENCYTYPE-N     Numeric 3
Element: Currencytype N

EPR-EP-ERROR-MSG       Alpha 128
Element: Ep Error Msg

EPR-PROGRAM            Alpha 5
Element: Program

                         EPTRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EPRSET1   EP-BATCH-ID
          EP-TRANS-ID
          EP-TRANS-TYPE

EPRSET2   EP-BATCH-ID   KeyChange
          PRIORITY
          DEPENDENCY
          EP-TRANS-ID
          EP-TRANS-TYPE

EPRSET3   EP-TRANS-ID   KeyChange
          PRIORITY
          EP-BATCH-ID
          EP-TRANS-TYPE