EPTRANS

REFERENCED BY
AR08.1 AR09.1 AR10.1 AR10.5 AR210 AR301
AR501 AR550 CB06.2 TX140 TX40.1 WF01.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EPT-EP-TRANS-ID
Element: Ep Trans Id
Numeric 12
EPT-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
EPT-ORDER-NBR
Element: Order Nbr
Numeric 8
This field contains the order number.
EPT-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
EPT-INVC-PREFIX
Element: Invc Prefix
Alpha 2
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
Element: Invc Number
Numeric 8
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
Element: Ep Type
Alpha 5
EPT-EP-TYPE-DESC
Element: Ep Type Desc
Alpha 30
EPT-EP-ACCOUNT
Element: Ep Account
Alpha 32
EPT-EP-TRANS-STS
Element: Ep Trans Sts
Numeric 1

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
Element: Ep Error Code
Alpha 10
EPT-TRANS-TTL-CURR
Element: Intl Amt
Signed 18.2
EPT-TRANS-TTL-BASE
Element: Intl Amt
Signed 18.2
EPT-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
EPT-ORDER-REF-NBR
Element: Order Ref Nbr
Numeric 8
This field contains the order reference number. This number can be filled with extra order number information.
EPT-REF-NBR-FLAG
Element: Ref Nbr Flag
Alpha 1
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
Element: Ep Auth Expdte
Numeric 8 (yyyymmdd)
EPT-EP-AUTH-DATE
Element: Ep Auth Date
Numeric 8 (yyyymmdd)
EPT-EP-AUTH-BATCH
Element: Ep Auth Batch
Numeric 12
EPT-EP-AVS-RET-CD
Element: Ep Avs Ret Cd
Alpha 1
EPT-EP-AUTH-AMT
Element: Intl Amt
Signed 18.2
EPT-EP-AUTH-CODE
Element: Ep Auth Code
Alpha 20
EPT-EP-STTL-AMT
Element: Intl Amt
Signed 18.2
EPT-EP-STTL-FEE
Element: Intl Amt
Signed 18.2
EPT-EP-STTL-DATE
Element: Ep Sttl Date
Numeric 8 (yyyymmdd)
EPT-EP-STTL-BATCH
Element: Ep Sttl Batch
Numeric 12


EPTRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EPTSET1 EP-TRANS-ID
COMPANY
AR08.1 AR09.1
AR10.1 AR10.5
AR210 AR301
AR501 AR550
CB06.2 TX140
TX40.1 WF01.1
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


File created: Wed Jun 08 20:48:00 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.