Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EPTRANS


                              EPTRANS FILE

REFERENCED BY

AC551     AR08.1    AR10.1    AR10.5    AR210     AR219
AR48.1    AR48.3    AR501     AR550     BR10.1    BR11.1
BR120     BR121     BR122     BR123     BR15.1    BR151
BR152     BR155     BR156     BR16.1    BR16.2    BR210
BR211     BR215     BR220     BR251     BR252     BR253
BR420     BR450     BR51.1    BR51.2    BR52.1    BR52.2
BR521     BR53.1    BR55.2    BR91.1    BRIP.1    BRPI.1
CB06.2    IC02.1    IC531     PBIP.1    PR197     TX140
TX40.1    WF01.1    WH110     WH120     WH130     WH132
WH190     WH21.2    WH224     WH30.1    WH30.2    WH30.3
WH30.4    WH31.1    WH31.2    WH31.3    WH31.4    WH32.1
WH32.2    WH32.3    WH32.4    WH33.5    WH34.1    WH34.2
WH34.3    WH34.4    WH40.1    WH40.2    WH520     WH830
WO30.1

UPDATED BY

WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

EPT-EP-TRANS-ID        Numeric 12                                WH20.7
Element: Ep Trans Id

EPT-COMPANY            Numeric 4                                 WH20.7
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

EPT-ORDER-NBR          Numeric 8                                 WH20.7
Element: Order Number  This field contains the order number.

EPT-CUSTOMER           Alpha 9  (Right Justified)                WH20.7
Element: Customer NumbeThis field contains the number that
                       represents a customer.

EPT-INVC-PREFIX        Alpha 2
Element: Invoice PrefixThis field contains the invoice prefix
                       that is assigned from either the company
                       or process level, depending on the
                       invoice-level option chosen.

EPT-INVC-NUMBER        Numeric 8
Element: Invc Number   This field contains the invoice number
                       assigned by the system.  Invoice numbers
                       are assigned at the company or process
                       level, depending on an invoice-level
                       option on the company file.

EPT-EP-TYPE            Alpha 5                                   WH20.7
Element: Ep Type

EPT-EP-TYPE-DESC       Alpha 30                                  WH20.7
Element: Ep Type Desc

EPT-EP-ACCOUNT         Alpha 32                                  WH20.7
Element: Ep Account

EPT-EP-TRANS-STS       Numeric 1                                 WH20.7
Element: Ep Trans Sts  1 = New Transaction
                       2 = Authorizaton Pending
                       3 = Authorization Failed
                       4 = Authorization Granted
                       6 = Settlement Pending
                       7 = Settlement Failed
                       8 = Settlement Failed-Auth Failed
                       9 = Settlement Successful

EPT-EP-ERROR-CODE      Alpha 10                                  WH20.7
Element: Ep Error Code

EPT-TRANS-TTL-CURR     Signed 15.2                               WH20.7
Element: Trans Ttl CurrThis field contains the total amount of
                       the transaction in the transaction
                       currency.

EPT-TRANS-TTL-BASE     Signed 15.2                               WH20.7
Element: Trans Ttl BaseThis field contains the total amount of
                       the transaction in the base currency.

EPT-CURRENCY-CODE      Alpha 5                                   WH20.7
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

EPT-ORDER-REF-NBR      Numeric 8
Element: Order Ref Nbr This field contains the order reference
                       number.  This number can be filled with
                       extra order number information.

EPT-REF-NBR-FLAG       Alpha 1
Element: Ref Nbr Flag  This field contains a flag to indicate
                       whether the Order reference number is
                       being used.  This could be used to flag
                       whether we use the order-ref-nbr in
                       place of our order number.

EPT-EP-AUTH-EXPDTE     Numeric 8  (yyyymmdd)                     WH20.7
Element: Ep Auth Expdte

EPT-EP-AUTH-DATE       Numeric 8  (yyyymmdd)                     WH20.7
Element: Ep Auth Date

EPT-EP-AUTH-BATCH      Numeric 12                                WH20.7
Element: Ep Auth Batch

EPT-EP-AVS-RET-CD      Alpha 1                                   WH20.7
Element: Ep Avs Ret Cd

EPT-EP-AUTH-AMT        Signed 15.2                               WH20.7
Element: Ep Auth Amt

EPT-EP-AUTH-CODE       Alpha 20                                  WH20.7
Element: Ep Auth Code

EPT-EP-STTL-AMT        Signed 15.2
Element: Ep Sttl Amt

EPT-EP-STTL-FEE        Signed 15.2
Element: Ep Sttl Fee

EPT-EP-STTL-DATE       Numeric 8  (yyyymmdd)
Element: Ep Sttl Date

EPT-EP-STTL-BATCH      Numeric 12
Element: Ep Sttl Batch

                         EPTRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EPTSET1   EP-TRANS-ID                                            AC551   AR08.1
          COMPANY                                                AR10.1  AR10.5
                                                                 AR210   AR219
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BR10.1  BR11.1
                                                                 BR120   BR121
                                                                 BR122   BR123
                                                                 BR15.1  BR151
                                                                 BR152   BR155
                                                                 BR156   BR16.1
                                                                 BR16.2  BR210
                                                                 BR211   BR215
                                                                 BR220   BR251
                                                                 BR252   BR253
                                                                 ...

EPTSET2   COMPANY
          CUSTOMER
          EP-TRANS-ID

EPTSET3   COMPANY
          ORDER-NBR
          EP-TRANS-ID

EPTSET4   COMPANY
          INVC-PREFIX
          INVC-NUMBER
          EP-TRANS-ID

EPTSET5   COMPANY
          EP-TYPE
          EP-TRANS-ID

EPTSET6   COMPANY
          EP-TRANS-ID

EPTSET7   COMPANY
          EP-STTL-DATE
          EP-TRANS-ID