View: Order Pre-Authorization

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

Keys: 2

Title Fields
Order Uniquifier ORDUNIQ
Transaction Status TRANSTATUS, ORDUNIQ

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 

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).