View: Order Pre-Authorization

RotoID: OE0535
Table: OEPAUTH
Protocol: Flat
DLL:OEPAUTH

Keys: 2

Title Fields

Order Uniquifier ORDUNIQ
Transaction Status TRANSTATUSORDUNIQ

Fields: 21

Field Index Type Title Attributes Presentation

ORDUNIQ 1 BCD*10.0 Order Uniquifier E A K R 
CUSTOMER 2 String*12 Customer E A  Mask: %-12C
TRANIDPRE 3 String*36 Preauth Transaction ID E A 
TRANIDCAP 4 String*36 Capture Transaction ID E A 
TRANIDVOID 5 String*36 Void Transaction ID E A 
TRANSTATUS 6 Integer Transaction Status E A  List:9 entries
0 = None
1 = Preauth Pending
2 = Capture Pending
3 = Void Pending
4 = Success
5 = Captured
6 = Voided
7 = Card Declined
8 = Card Error
YPPROCCODE 7 String*12 YP Process Code E A  Mask: %-12N
BANKCODE 8 String*8 Bank Code E A  Mask: %-8N
PAYMCODE 9 String*12 Payment Code E A  Mask: %-12C
PAYMTYPE 10 Integer Payment Type E A 
PAUTHCURR 11 String*3 Pre-Auth Amount Currency E A  Mask: %-3N
SOURCURR 12 String*3 Source Currency E A  Mask: %-3N
RATETYPE 13 String*2 Rate Type E A X  Mask: %-2N
RATEDATE 14 Date Rate Date E A X 
RATE 15 BCD*8.7 Exchange Rate E A X 
SPREAD 16 BCD*8.7 Rate Spread E A C 
DATEMTCH 17 Integer Rate Date Matching E A C 
RATEREP 18 Integer Rate Operator E A C 
RATEOVER 19 Boolean Rate Override Falg E A C 
ORDPOSTED 20 Boolean Order Posted E A C 
PAUTHAMT 21 BCD*10.3 Pre-Auth Amount E A