Lawson Insight Technical Documentation |
|
EPTRANS
EPTRANS FILE
REFERENCED BY
AC56.1 AC560 AR08.1 AR09.1 AR10.1 AR10.5
AR120 AR210 AR219 AR301 AR48.1 AR48.3
AR501 AR550 BL02.1 BL04.1 BL10.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 BR10.9 BR11.1 BR120 BR121
BR122 BR123 BR140 BR151 BR152 BR155
BR156 BR16.1 BR16.2 BR17.1 BR180 BR19.1
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR20.7
BR21.2 BR210 BR211 BR216 BR217 BR220
BR251 BR252 BR253 BR400 BR420 BR45.1
BR450 BR46.1 BR46.2 BR46.4 BR51.1 BR51.2
BR52.1 BR52.2 BR521 BR53.1 BR55.2 BR70.1
BR70.2 BR91.1 BRIP.1 CB06.2 IC02.1 PW110
PW550 TX140 TX40.1 WF01.1 WH110 WH120
WH130 WH132 WH190 WH21.2 WH224 WH226
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
BL120 BL122 BL125 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 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
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
WH20.7
EPT-ORDER-NBR Numeric 8 BL120 BL122
Element: Order Nbr This field contains the order number. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
EPT-CUSTOMER Alpha 9 (Right Justified) BL120 BL122
Element: Customer This 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
WH20.7
EPT-INVC-PREFIX Alpha 2 BL120 BL122
Element: Invc Prefix This 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
WH20.7
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
WH20.7
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
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
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
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 WH20.7
8 = Settlement Failed-Auth Failed
9 = Settlement Successful
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 WH20.7
EPT-TRANS-TTL-CURR 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
WH20.7
EPT-TRANS-TTL-BASE 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
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
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
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
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
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
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
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 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 WH20.7
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
WH20.7
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 WH20.7
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
WH20.7
EPTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EPTSET1 EP-TRANS-ID AC56.1 AC560
COMPANY AR08.1 AR09.1
AR10.1 AR10.5
AR120 AR210
AR219 AR301
AR48.1 AR48.3
AR501 AR550
BL02.1 BL04.1
BL10.1 BL120
BL121 BL122
BL123 BL125
BL13.1 BL130
BL20.1 BL20.3
BL20.6 BL202
BL204 BL21.2
...
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
|