EPTRANS FILE
REFERENCED BY
AC551 AR08.1 AR210 AR219 AR48.1 AR48.3
AR501 AR550 BL02.1 BL04.1 BL121 BL123
BL13.1 BL202 BL204 BL213 BL217 BL219
BL220 BL231 BL246 BL290 BL291 BL31.1
BL31.2 BL31.3 BL31.5 BL31.7 BL32.3 BL32.4
BL33.1 BL331 BL34.1 BL46.1 BL46.2 BL530
BL80.1 BL80.3 BL802 BL81.1 BL82.1 BL85.1
BL85.2 BL90.1 BR10.1 BR11.1 BR120 BR121
BR210 BR211 BR220 BR420 BR450 BRIP.1
IC02.1 PR197 TX140 TX40.1 WH110 WH120
WH130 WH21.2 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4
UPDATED BY
BL125
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EPT-EP-TRANS-ID Numeric 12
Ep Trans Id
EPT-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
EPT-ORDER-NBR Numeric 8
Order Number This field contains the order number.
EPT-CUSTOMER Alpha 9 (Right Justified)
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
Ep Type
EPT-EP-TYPE-DESC Alpha 30
Ep Type Desc
EPT-EP-ACCOUNT Alpha 32
Ep Account
EPT-EP-TRANS-STS Numeric 1 BL125
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 BL125
Ep Error Code
EPT-TRANS-TTL-CURR Signed 15.2
Trans Ttl Curr This field contains the total amount of
the transaction in the transaction
currency.
EPT-TRANS-TTL-BASE Signed 15.2
Trans Ttl Base This field contains the total amount of
the transaction in the base currency.
EPT-CURRENCY-CODE Alpha 5
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)
Ep Auth Expdte
EPT-EP-AUTH-DATE Numeric 8 (yyyymmdd)
Ep Auth Date
EPT-EP-AUTH-BATCH Numeric 12
Ep Auth Batch
EPT-EP-AVS-RET-CD Alpha 1
Ep Avs Ret Cd
EPT-EP-AUTH-AMT Signed 15.2
Ep Auth Amt
EPT-EP-AUTH-CODE Alpha 20 BL125
Ep Auth Code
EPT-EP-STTL-AMT Signed 15.2 BL125
Ep Sttl Amt
EPT-EP-STTL-FEE Signed 15.2
Ep Sttl Fee
EPT-EP-STTL-DATE Numeric 8 (yyyymmdd) BL125
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 AR210 AR219
AR48.1 AR48.3
AR501 AR550
BL02.1 BL04.1
BL121 BL123
BL125 BL13.1
BL202 BL204
BL213 BL217
BL219 BL220
BL231 BL246
BL290 BL291
BL31.1 BL31.2
BL31.3 BL31.5
BL31.7 BL32.3
...
EPTSET2 COMPANY BL217
CUSTOMER
EP-TRANS-ID
EPTSET3 COMPANY BL217
ORDER-NBR
EP-TRANS-ID
EPTSET4 COMPANY BL217
INVC-PREFIX
INVC-NUMBER
EP-TRANS-ID
EPTSET5 COMPANY BL217
EP-TYPE
EP-TRANS-ID
EPTSET6 COMPANY BL217
EP-TRANS-ID
EPTSET7 COMPANY BL217
EP-STTL-DATE
EP-TRANS-ID
|
