Table: Transaction Log

Table: YPTRAN
View: YP0700
Record Length: 1539

Flags: A R 

Keys: 1

Title Flags Fields
Key TRANSID

Fields: 48

Field Type Title Presentation
TRANSID String*36 Transaction ID
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
BANK String*8 Bank
CODECURN String*3 Currency Code
ACTION Integer Action
RESPIND String*1 Response Indicator
RESPCD String*6 Response Code
RESPMSG String*32 Response Message
GUID String*36 GUID from message
EXPDATE String*4 Expire Date
LAST4 String*16 Last 4
PMTDESC String*30 Payment Description
PMTTYPEID String*1 Payment Type ID
REF1 String*50 Reference1
REF2 String*50 Reference2
AMOUNT BCD*10.3 Amount
AUTHCODE String*6 Authorization Code
VANREF String*16 VANReference
NAME String*103 Name
ADDR1 String*50 Address Line1
ADDR2 String*50 Address Line2
CITY String*50 City
STATE String*50 State
ZIPCODE String*50 Zip Code
COUNTRY String*50 Country
EMAIL String*255 Email
TEL String*50 Telephone
FAX String*50 Fax
AVSRESULT String*1 AVSResult
CVVRESULT String*1 CVVResult
TIMESTAMP String*22 Timestamp
BATCHREF String*10 Batch Reference
SETLTYPE String*1 Settlement Type
SETLDATE String*22 Settlement Date
TRANSTYPE String*2 Transaction Type
DTPROCESS Date Processing Date
TAXAMOUNT String*9 Tax Amount
IDCUST String*12 Customer Number
PROCESSCOD String*12 Processing Code
IDCARD String*12 Card ID
DOCNUMBER String*22 Document Number
CARDDESC String*60 Card Description
CARDCMNT String*255 Card Comment
ISCOMPLETE Integer SPS Request Process Completed Flag List:2 entries
0 = No
1 = Yes
APP String*2 Application

This page was generated on 2022-Aug-18

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