View: Transaction Log

RotoID: YP0700
Table: YPTRAN
Protocol: Flat
DLL:YPTRAN

Keys: 1

Title Fields
Key TRANSID

Fields: 44

Field Index Type Title Attributes Presentation
TRANSID 1 String*36 Transaction ID E A K R 
BANK 2 String*8 Bank E A 
CODECURN 3 String*3 Currency Code E A 
ACTION 4 Integer Action E A 
RESPIND 5 String*1 Response Indicator E A 
RESPCD 6 String*6 Response Code E A 
RESPMSG 7 String*32 Response Message E A 
GUID 8 String*36 GUID from message E A 
EXPDATE 9 String*4 Expire Date E A 
LAST4 10 String*16 Last 4 E A 
PMTDESC 11 String*30 Payment Description E A 
PMTTYPEID 12 String*1 Payment Type ID E A 
REF1 13 String*50 Reference1 E A 
REF2 14 String*50 Reference2 E A 
AMOUNT 15 BCD*10.3 Amount E A 
AUTHCODE 16 String*6 Authorization Code E A 
VANREF 17 String*16 VANReference E A 
NAME 18 String*103 Name E A 
ADDR1 19 String*50 Address Line1 E A 
ADDR2 20 String*50 Address Line2 E A 
CITY 21 String*50 City E A 
STATE 22 String*50 State E A 
ZIPCODE 23 String*50 Zip Code E A 
COUNTRY 24 String*50 Country E A 
EMAIL 25 String*255 Email E A 
TEL 26 String*50 Telephone E A 
FAX 27 String*50 Fax E A 
AVSRESULT 28 String*1 AVSResult E A 
CVVRESULT 29 String*1 CVVResult E A 
TIMESTAMP 30 String*22 Timestamp E A 
BATCHREF 31 String*10 Batch Reference E A 
SETLTYPE 32 String*1 Settlement Type E A 
SETLDATE 33 String*22 Settlement Date E A 
TRANSTYPE 34 String*2 Transaction Type E A 
DTPROCESS 35 Date Processing Date E A 
TAXAMOUNT 36 String*9 Tax Amount E A 
IDCUST 37 String*12 Customer Number E A 
PROCESSCOD 38 String*12 Processing Code E A 
IDCARD 39 String*12 Card ID E A 
DOCNUMBER 40 String*22 Document Number E A 
CARDDESC 41 String*60 Card Description E A 
CARDCMNT 42 String*255 Card Comment E A 
ISCOMPLETE 43 Integer SPS Request Process Completed Flag E A  List:2 entries
0 = No
1 = Yes
APP 44 String*2 Application E A 

This page was generated on 2021-Nov-24

© 2021 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).