|
|
EPTRANS FILE
REFERENCED BY
AR08.1 AR09.1 AR10.1 AR10.5 AR210 AR219
AR301 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 BL546 BL80.1 BL80.3
BL802 BL81.1 BL82.1 BL85.1 BL85.2 BL90.1
BR00.1 BR00.2 BR02.3 BR10.1 BR11.1 BR120
BR121 BR122 BR140 BR16.1 BR17.1 BR19.1
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR20.7
BR21.2 BR210 BR211 BR216 BR217 BR220
BR400 BR420 BR45.1 BR450 BR46.1 BR46.2
BR46.4 BR521 BRIP.1 CB06.2 IC02.1 IC531
OE112 OE116 OE130 OE16.1 OE230 OE254
OE260 OE270 OE271 OE272 OE284 OE285
OE286 OE290 OE291 OE292 OE293 OE294
OE330 OE53.1 OE54.1 OE60.1 OE80.1 OE80.2
OE81.1 OE81.2 OE85.1 OE85.3 OE86.1 OE90.1
OE90.2 PBIP.1 PR197 SA03.1 SA100 SA252
SA254 SA256 SA261 SA271 SA281 SA291
SA300 SA80.2 SA90.2 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
BL120 BL122 BL125 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE111 OE113 OE114 OE129
OE13.2 OE13.3 OE13.5 OE14.4 OE30.1 OE30.2
OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9
OE310 OE510 OE530 OE810 OE830 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EPT-EP-TRANS-ID Numeric 12 BL120 BL122
Element: Ep Trans Id BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
EPT-COMPANY Numeric 4 BL120 BL122
Element: Company Identifies the AP company if the BL130 BL20.1
resource type = V. Identifies the HR BL20.3 BL21.2
company if the resource type = E. It is BL21.5 BL29.1
blank for type A, P or Q resources. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
EPT-ORDER-NBR Numeric 8 BL120 BL122
Element: Order Number This field contains the order number. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
EPT-CUSTOMER Alpha 9 (Right Justified) BL120 BL122
Element: Customer NumbeThis field contains the number that BL130 BL20.1
represents a customer. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
EPT-INVC-PREFIX Alpha 2 BL120 BL122
Element: Invoice PrefixThis field contains the invoice prefix BL130 BL20.1
that is assigned from either the company BL20.3 BL21.2
or process level, depending on the BL21.5 BL29.1
invoice-level option chosen. BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
EPT-INVC-NUMBER Numeric 8 BL120 BL122
Element: Invc Number This field contains the invoice number BL130 BL20.1
assigned by the system. Invoice numbers BL20.3 BL21.2
are assigned at the company or process BL21.5 BL29.1
level, depending on an invoice-level BL29.2 BL520
option on the company file. BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
EPT-EP-TYPE Alpha 5 BL120 BL122
Element: Ep Type BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
EPT-EP-TYPE-DESC Alpha 30 BL120 BL122
Element: Ep Type Desc BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
EPT-EP-ACCOUNT Alpha 32 BL120 BL122
Element: Ep Account BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
EPT-EP-TRANS-STS Numeric 1 BL120 BL122
Element: Ep Trans Sts 1 = New Transaction BL125 BL130
2 = Authorizaton Pending BL20.1 BL20.3
3 = Authorization Failed BL21.2 BL21.5
4 = Authorization Granted BL29.1 BL29.2
6 = Settlement Pending BL520 BL820
7 = Settlement Failed BL92.1 OE10.1
8 = Settlement Failed-Auth Failed OE10.2 OE10.3
9 = Settlement Successful OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE129
OE13.2 OE13.3
OE13.5 OE14.4
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE530
OE810 OE830
WH20.7
EPT-EP-ERROR-CODE Alpha 10 BL120 BL122
Element: Ep Error Code BL125 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE129
OE13.2 OE13.3
OE13.5 OE14.4
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE530
OE810 OE830
WH20.7
EPT-TRANS-TTL-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the total amount of BL130 BL20.1
the transaction in the transaction BL20.3 BL21.2
currency. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
EPT-TRANS-TTL-BASE Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the total amount of BL130 BL20.1
the transaction in the base currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
EPT-CURRENCY-CODE Alpha 5 BL120 BL122
Element: Currency Code This field contains the company base BL130 BL20.1
currency code established in Company BL20.3 BL21.2
(GL10.1 ). BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
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) BL120 BL122
Element: Ep Auth Expdte BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
EPT-EP-AUTH-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Ep Auth Date BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
EPT-EP-AUTH-BATCH Numeric 12 BL120 BL122
Element: Ep Auth Batch BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
EPT-EP-AVS-RET-CD Alpha 1 BL120 BL122
Element: Ep Avs Ret Cd BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
EPT-EP-AUTH-AMT Signed 18.2 BL120 BL122
Element: Intl Amt BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
EPT-EP-AUTH-CODE Alpha 20 BL120 BL122
Element: Ep Auth Code BL125 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE129
OE13.2 OE13.3
OE13.5 OE14.4
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE530
OE810 OE830
WH20.7
EPT-EP-STTL-AMT Signed 18.2 BL120 BL122
Element: Intl Amt BL125 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE530
OE830
EPT-EP-STTL-FEE Signed 18.2 BL120 BL122
Element: Intl Amt BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
EPT-EP-STTL-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Ep Sttl Date BL125 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE530
OE830
EPT-EP-STTL-BATCH Numeric 12 BL120 BL122
Element: Ep Sttl Batch BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
EPTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EPTSET1 EP-TRANS-ID AR08.1 AR09.1
COMPANY AR10.1 AR10.5
AR210 AR219
AR301 AR48.1
AR48.3 AR501
AR550 BL02.1
BL04.1 BL120
BL121 BL122
BL123 BL125
BL13.1 BL130
BL20.1 BL20.3
BL20.6 BL202
BL204 BL21.2
BL21.5 BL213
BL217 BL219
...
EPTSET2 COMPANY BL217
CUSTOMER
EP-TRANS-ID
EPTSET3 COMPANY BL217 OE310
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
|
