Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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     BR210     BR211     BR220     BR420
BR450     BRIP.1    CB06.2    IC02.1    IC531     MX223
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

UPDATED BY

WH20.7

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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


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

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

EPT-INVC-PREFIX      Alpha 2
Invoice Prefix       This 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
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
Ep Type

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

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

EPT-EP-TRANS-STS     Numeric 1                                   WH20.7
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
Ep Error Code

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

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

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


EPT-ORDER-REF-NBR    Numeric 8
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
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
Ep Auth Expdte

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

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

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

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

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

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

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

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

EPT-EP-STTL-BATCH    Numeric 12
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
                                                                 BR210   BR211
                                                                 BR220   BR420
                                                                 BR450   BRIP.1
                                                                 CB06.2  IC02.1
                                                                 IC531   MX223
                                                                 PBIP.1  PR197
                                                                 TX140   TX40.1
                                                                 WF01.1  WH110
                                                                 ...

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