CTI Report Output Tables

The following DB2 physical files are used to hold parsed report data. You should retrieve the parsed information and store it in a more permanent manner; these tables should be treated as temporary, transactional tables and not used as permanent storage.

CTIRPTREQ - Request Data

This table will hold data from the <Request> elements of the report. This includes non-repeating elements and some nested elements.

A          R CTIRPTREQR

Record

CyberSource Report Request Info Record

A            REPORTID      15P 0

Key

Report Unique ID (corresponds to unique ID in CTIRPT)

A            REQUESTID     30A

Key

Request ID

A            MCHREFNBR     30A

Merchant Reference Number

A            MCHID         30A

Merchant ID

A            REQDT         10A

Request Date

A            SUBID         30A

Subscription ID

A            SRC           30A

Source

A            USER          30A

User

A            COMMENTS     100A

Comments

A            TRNREFNBR     30A

Transaction Reference Number

A            PREDREQID     30A

Predecessor Request ID

A            ECOMIND       30A

eCommerce Indicator

A            BTFNAM        30A

Bill To First Name

A            BTLNAM        50A

Bill To Last Name

A            BTMNAM        30A

Bill To Middle Name

A            BTNMSUF       10A

Bill To Name Suffix

A            BTADR1       100A

Bill To Address Line 1

A            BTADR2       100A

Bill To Address Line 2

A            BTCTY         50A

Bill To City

A            BTSTT         30A

Bill To State

A            BTZIP         10A

Bill To Zip

A            BTCMPNY      100A

Bill To Company Name

A            BTEML         50A

Bill To Email

A            BTCNTRY       50A

Bill To Country

A            BTTTL         30A

Bill To Title

A            BTPHN         20A

Bill To Phone Number

A            BTIPADR       20A

Bill To IP Address

A            BTHOST        30A

Bill To Host Name

A            BTUSER        30A

Bill To User Name

A            BTCUSTID      30A

Bill To Customer ID

A            BTPERSID      30A

Bill To Personal ID

A            STFNAM        30A

Ship To First Name

A            STLNAM        50A

Ship To Last Name

A            STADR1       100A

Ship To Address Line 1

A            STADR2       100A

Ship To Address Line 2

A            STCTY         50A

Ship To City

A            STSTT         30A

Ship To State

A            STZIP         10A

Ship To Zip

A            STCMPNY      100A

Ship To Company Name

A            STCNTRY       50A

Ship To Country

A            STPHN         20A

Ship To Phone Number

A            SHPMTHD       30A

Shipping Method

A            SHPCARR       50A

Shipping Carrier

A            CRDACTSFX     30A

Card Account Suffix

A            CRDEXPMON     20A

Card Expiration Month

A            CRDEXPYR       4A

Card Expiration Year

A            CRDSTRMON     20A

Card Start Month

A            CRDSTRYR       4A

Card Start Year

A            CRDISSNBR     30A

Card Issue Number

A            CRDTYPE       30A

Card Type

A            CRDBOLNBR     30A

Card Boleto Number

A            CRDCAT        30A

Card Category

A            CRDCATCD      30A

Card Category Code

A            WALLETTYPE    30A

Wallet Type

A            BATCHID       30A

Batch ID

A            BATCHDT       10A

Batch Date

A            BATCHSTS      30A

Batch Status

A            BATCHFLAG     30A

Batch Success Flag

A            MDD1NAME      30A

Merchant-Defined Data Field 1 Name

A            MDD1VALUE    100A

Merchant-Defined Data Field 1 Value

A            MDD2NAME      30A

Merchant-Defined Data Field 2 Name

A            MDD2VALUE    100A

Merchant-Defined Data Field 2 Value

A            MDD3NAME      30A

Merchant-Defined Data Field 3 Name

A            MDD3VALUE    100A

Merchant-Defined Data Field 3 Value

A            MDD4NAME      30A

Merchant-Defined Data Field 4 Name

A            MDD4VALUE    100A

Merchant-Defined Data Field 4 Value

A            MDD5NAME      30A

Merchant-Defined Data Field 5 Name

A            MDD5VALUE    100A

Merchant-Defined Data Field 5 Value

A            MDD6NAME      30A

Merchant-Defined Data Field 6 Name

A            MDD6VALUE    100A

Merchant-Defined Data Field 6 Value

A            MDD7NAME      30A

Merchant-Defined Data Field 7 Name

A            MDD7VALUE    100A

Merchant-Defined Data Field 7 Value

A            MDD8NAME      30A

Merchant-Defined Data Field 8 Name

A            MDD8VALUE    100A

Merchant-Defined Data Field 8 Value

A            MDD9NAME      30A

Merchant-Defined Data Field 9 Name

A            MDD9VALUE    100A

Merchant-Defined Data Field 9 Value

A            MDD10NAME     30A

Merchant-Defined Data Field 10 Name

A            MDD10VALUE   100A

Merchant-Defined Data Field 10 Value

A            MDD11NAME     30A

Merchant-Defined Data Field 11 Name

A            MDD11VALUE   100A

Merchant-Defined Data Field 11 Value

A            MDD12NAME     30A

Merchant-Defined Data Field 12 Name

A            MDD12VALUE   100A

Merchant-Defined Data Field 12 Value

A            MDD13NAME     30A

Merchant-Defined Data Field 13 Name

A            MDD13VALUE   100A

Merchant-Defined Data Field 13 Value

A            MDD14NAME     30A

Merchant-Defined Data Field 14 Name

A            MDD14VALUE   100A

Merchant-Defined Data Field 14 Value

A            MDD15NAME     30A

Merchant-Defined Data Field 15 Name

A            MDD15VALUE   100A

Merchant-Defined Data Field 15 Value

A            MDD16NAME     30A

Merchant-Defined Data Field 16 Name

A            MDD16VALUE   100A

Merchant-Defined Data Field 16 Value

A            MDD17NAME     30A

Merchant-Defined Data Field 17 Name

A            MDD17VALUE   100A

Merchant-Defined Data Field 17 Value

A            MDD18NAME     30A

Merchant-Defined Data Field 18 Name

A            MDD18VALUE   100A

Merchant-Defined Data Field 18 Value

A            MDD19NAME     30A

Merchant-Defined Data Field 19 Name

A            MDD19VALUE   100A

Merchant-Defined Data Field 19 Value

A            MDD20NAME     30A

Merchant-Defined Data Field 20 Name

A            MDD20VALUE   100A

Merchant-Defined Data Field 20 Value

A            RFACTORS     100A

Risk Factors

A            RHOSTSEV      30A

Risk Host Severity

A            RSCORE        30A

Risk Score

A            RTMLOCAL      10A

Risk Time Local

A            RCONSPASS     10A

Risk Consumer Password Provided

A            RLOSTPASS     10A

Risk Lost Password

A            RRPTCUST      10A

Risk Repeat Customer

A            RCOOKACCPT    10A

Risk Cookies Accepted

A            RCONSLOYAL    10A

Risk Consumer Loyalty

A            RCONSPROMO   100A

Risk Consumer Promotions

A            RGIFTWRAP     30A

Risk Gift Wrap

A            RRTNACCPT     10A

Risk Returns Accepted

A            RPRODRISK     30A

Product Risk

A            RAPPTHRESH    30A

Risk Appled Threshold

A            RAPPTMHDG     30A

Risk Applied Time Hedge

A            RAPPVELHDG    30A

Risk Applied Velocity Hedge

A            RAPPHSTHDG    30A

Risk Applied Host Hedge

A            RAPPCATGFT    30A

Risk Applied Category Gift

A            RAPPCATTM     10A

Risk Applied Category Time

A            RAPPAVS       30A

Risk Applied AVS

A            RAPPCV        30A

Risk Applied CV

A            RBINACTTYP    30A

Risk Bin Account Type

A            RBINSCHEME    30A

Risk Bin Scheme

A            RBINISSUER    50A

Risk Bin Issuer

A            RBINCNTRY     50A

Risk Bin Country

A            RIPCTY        50A

Risk IP City

A            RIPCNTRY      50A

Risk IP Country

A            RIPRTMTHD     30A

Risk IP Routing Method

A            RIPSTT        50A

Risk IP State

A            RDEVFING      30A

Risk Device Fingerprint

A            RCOOKENBL     10A

Risk Cookies Enabled

A            RFLASHENBL    10A

Risk Flash Enabled

A            RIMGENBL      10A

Risk Images Enabled

A            RJSENBL       10A

Risk JavaScript Enabled

A            RPXYIP        30A

Risk Proxy IP Address

A            RPXYIPACT    100A

Risk Proxy IP Address Activities

A            RPXYIPATTR    30A

Risk Proxy IP Address Attributes

A            RPXYSVRTYP    30A

Risk Proxy Server Type

A            RTIP          30A

Risk True IP Address

A            RTIPACT      100A

Risk True IP Activities

A            RTIPATTR      30A

Risk True IP Attributes

A            RTIPCNTRY     50A

Risk True IP Country

A            RTIPCTY       50A

Risk True IP City

A            EXPROCRSP     50A

Exception Processor Response Code

A            EXACTION      50A

Exception Action

A            EXMSG        100A

Exception Message

A            EXPROCCSID    30A

Exception Processor Case ID

A            EXAMTCURR     30A

Exception Amount Currency

A            EXRSNCD       30A

Exception Reason Code

A            EXRSNDESC    100A

Exception Reason Description

A            EXDT          10A

Exception Date

A            EXSTS         30A

Exception Status

A            EXORIGDT      10A

Exception Original Transaction Submission Date

A            EXAMT         30A

Exception Amount

A            EXFINSTS      30A

Exception Financial Status

A            EXCYBSID      30A

CYBS Exception ID

A            SSTS          30A

Settlement Status

A            SSRCRSPCD     30A

Settlement Source Response Code

A            SSRCRSPMSG    30A

Settlement Source Response Message

A            SAGE          30A

Settlement Age

A            FCURRRTE      30A

Funding Currency Exchange Rate

A            FCURRDESC    100A

Funding Currency Exchange Description

A            FPROCMSG     100A

Funding Processor Message

A            FPRRSPCD      30A

Funding Processor Response Code

A            FSTS          30A

Funding Status

A            FFEEAMT       30A

Funding Fee Amount

A            FFEECURR      30A

Funding Fee Currency

A            FFEEDESC     100A

Funding Fee Description

A            APPLCN        50A

Application

A            TRNTYPE       30A

Transaction Type

A            ORGREQID      30A

Original Request ID

A            EXCAT         20A

Error Category

A            BATCHEFFDT      Z

Batch Effective Date

CTIRPTAPR - Application Replies

This table will hold data from the <ApplicationReply> child elements of the <ApplicationReplies> element. There may be one or more CTIRPTAPR records for a given CTIRPTREQ record.

A          R CTIRPTAPRR

Record

CyberSource Report Application Reply Record

A            REPORTID      15P 0

Key

Report Unique ID (corresponds to unique ID in CTIRPT)

A            REQUESTID     30A

Key

Request ID (corresponds to record in CTIRPTREQ)

A            APRID         15P 0

Key

Application Reply Unique ID

A            APPREPNAME    30A

Key

Application Reply Name

A            RCODE          1P 0

Application Reply RCode

A            RFLAG         50A

Application Reply RFlag

A            RMSG         255A

Application Reply RMsg

CTIRPTCBD - Chargeback Data

This table will hold data from chargeback reports.

A          R CTIRPTCBDR

Record

CyberSource Report Chargeback Data Record

A            REPORTID      15P 0

Key

Report Unique ID (corresponds to unique ID in CTIRPT)

A            REQUESTID     30A

Key

Request ID (corresponds to record in CTIRPTREQ)

A            CHGBCKID      15P 0

Key

Chargeback ID

A            CBCASEID      60A

Chargeback Case ID

A            CBCASETYPE    60A

Chargeback Case Type

A            CBARN         60A

Chargeback ARN

A            CBMCHCTCD     60A

Merchant Category Code

A            CBTNSTYPE     60A

Transaction Type

A            CBCSNBR       60A

Case Number

A            CBAMT         19A

Chargeback Amount

A            CBCURR         5A

Chargeback Currency

A            CBCSTIME      20A

Case Time

A            CBCHGBTIME    20A

Chargeback Time

A            CBADJAMT      19A

Adjustment Amount

A            CBADJCURR      5A

Adjustment Currency

A            CBFEEAMT      19A

Fee Amount

A            CBFEECURR      5A

Fee Currency

A            CBFINIMP      60A

Financial Impact

A            CBFINIMPTP    60A

Financial Impact Type

A            CBPRTIND      60A

Partial Indicator

A            CBDCMIND      60A

Document Indicator

A            CBRSPBYDT     20A

Respond By Date

A            CBRSNCD       20A

Chargeback Reason Code

A            CBRSNCDD      60A

Chargeback Reason Code Description

A            CBRSTOIND     60A

Resolved To Indicator

A            CBRESTIME     20A

Resolution Time

A            CBMSG        255A

Chargeback Message

CTIRPTFEI - Fee Info Data

This table will hold data from fee reports. There may be one or more CTIRPTFEI records for a given CTIRPTREQ record.

A          R CTIRPTFEIR

Record

CyberSource Report Fee Info Record

A            REPORTID      15P 0

Key

Report Unique ID (corresponds to unique ID in CTIRPT)

A            REQUESTID     30A

Key

Request ID (corresponds to record in CTIRPTREQ)

A            FEEINFOID     15P 0

Key

Fee Info Unique ID

A            FISETTM       20A

Settlement Time

A            FISETTMZN     10A

Settlement Time Zone

A            FISETAMT      19A

Settlement Amount

A            FISETCURR      5A

Settlement Currency

A            FIDSCRT       20A

Discount Rate

A            FIDSCAMT      19A

Discount Amount

A            FIDSCCURR      5A

Discount Currency

A            FIPRITCLVL    60A

Priced Interchange Level

A            FICDITCLVL    60A

Cleared Interchange Level

A            FIDGRSNCD     60A

Downgrade Reason Code

A            FISRCDSC      60A

Source Descriptor

A            FIITCRT       60A

Interchange Rate

A            FIBLTYPE      60A

Billing Type

A            FIBLCYCL      60A

Billing Cycle

A            FITLFEEAMT    19A

Total Fee Amount

A            FITLFEECUR     5A

Total Fee Currency

A            FIPIFEEAMT    19A

Per Item Fee Amount

A            FIPIFCURR      5A

Per Item Fee Currency

A            FIITCAMT      19A

Interchange Amount

A            FIITCCURR      5A

Interchange Currency

A            FIASMAMT      19A

Assessment Amount

A            FIASMCURR      5A

Assessment Currency

CTIRPTICD - Info Code Data

This table will hold data from the <InfoCode> child elements of the <InfoCodes> element. There may be one or more CTIRPTICD records for a given CTIRPTREQ record.

A          R CTIRPTICDR

Record

CyberSource Report Info Code Record

A            REPORTID      15P 0

Key

Report Unique ID (corresponds to unique ID in CTIRPT)

A            REQUESTID     30A

Key

Request ID (corresponds to record in CTIRPTREQ)

A            INFOCODEID    15P 0

Info Code Unique ID

A            INFCDTYP      60A

Info Code Type

A            INFCDVAL      60A

Info Code Value

CTIRPTLIN - Line Item Data

This table will hold data from the <LineItem> child elements of the <LineItems> element. There maybe one or more CTIRPTLIN records for a given CTIRPTREQ record.

A          R CTIRPTLINR

Record

CyberSource Report Line Item Record

A            REPORTID      15P 0

Key

Report Unique ID (corresponds to unique ID in CTIRPT)

A            REQUESTID     30A

Key

Request ID (corresponds to record in CTIRPTREQ)

A            LINBR         10P 0

Key

Line Item Number

A            LIFLMTTYP      2A

Fulfillment Type

A            LIQNTY        10P 0

Quantity

A            LIUPRICE      19A

Unit Price

A            LITAXAMT      19A

Tax Amount

A            LIMCHPDSKU    30A

Merchant Product SKU

A            LIPRDNAME     20A

Product Name

A            LIPRDCODE     30A

Product Code

A            LIINVNBR      60A

Invoice Number

CTIRPTPAY - Payment Info Data

This table will hold payment data from <PaymentData> elements or similar fields.

A          R CTIRPTPAYR

Record

CyberSource Report Payment Info Record

A            REPORTID      15P 0

Key

Report Unique ID (corresponds to unique ID in CTIRPT)

A            REQUESTID     30A

Key

Request ID (corresponds to record in CTIRPTREQ)

A            PMTID         15P 0

Key

Payment ID

A            PMTREQID      26A

Payment Request ID

A            PMTPROC       40A

Payment Processor

A            PMTAMT        19A

Amount

A            PMTCURR        5A

Currency Code

A            PMTTTLTAX     19A

Total Tax Amount

A            PMTAUTHTYP     1A

Authorization Type

A            PMTAUTHCD     15A

Authorization Code

A            PMTAVSRT      10A

AVS Result

A            PMTAVSRTMP     5A

ABS Result Mapped

A            PMTCVRT        1A

CV Result

A            PMTPRRSCD     60A

Processor Response Code

A            PMTPYRECI     64A

Payer Authentication ECI

A            PMTPYRACV     32A

Payer Authentication AAV_CAVV

A            PMTPYRXID     28A

Payer Authentication XID

A            PMTEVTTYP     20A

Event Type

A            PMTNBRISTL     2P 0

Number of Installments

A            PMTACHVRR      2A

ACH Verification Result

A            PMTACHVRRM     2A

ACH Verification Result Mapped

A            PMTGDTTL      19A

Grand Total

A            PMTBALAMT     19A

Balance Amount

A            PMTBALCURR     5A

Balance Currency Code

A            PMTRQAMT      19A

Requested Amount

A            PMTRQAMCR      5A

Requested Amount Currency Code

A            PMTEVEMAIL   255A

EV Email

A            PMTEVEMRAW   255A

EV Email Raw

A            PMTEVNAME    255A

EV Name

A            PMTEVNMRAW   255A

EV Name Raw

A            PMTEVPHNBR    15A

EV Phone Number

A            PMTEVPHRAW    15A

EV Phone Number Raw

A            PMTEVST       60A

EV Street

A            PMTEVSTRAW    60A

EV Street Raw

A            PMTEVPSTCD    10A

EV Postal Code

A            PMTEVPCRAW    10A

EV Postal Code Raw

A            PMTBNNBR      60A

Bin Number

A            PMTPRRSID     60A

Processor Response ID

A            PMTPRCTID     60A

Processor TID

A            PMTNTTNSID    60A

Network Transaction ID

A            PMTBBCDNBR    60A

Boleto BarCode Number

A            PMTBNKCDE     15A

Bank Code

A            PMTBNKACNM    60A

Bank Account Name

A            PMTTGTAMT     15A

Target Amount

A            PMTTGTCURR     5A

Target Currency

A            PMTEXGRT      13A

Exchange Rate

A            PMTEXGRTDT      Z

Exchange Rate Date

A            PMTDCCIND      1A

DCC Indicator

Valid Values:

  • T
  • Y

A            PMTBLTONBR     6A

Boleto Number

CTIRPTPRF and CTIRPTRUL - Profiles and Rule Lists

These tables hold profile data and the associated rule lists. There may be one or more CTIRPTPRF records for a given CTIRPTREQ record, and each CTIRPTPRF may have one or more CTIRPTRUL records.

A          R CTIRPTPRFR

Record

CyberSource Report Profile List Record

A            REPORTID      15P 0

Key

Report Unique ID (corresponds to unique ID in CTIRPT)

A            REQUESTID     30A

Key

Request ID (corresponds to record in CTIRPTREQ)

A            PROFID        15P 0

Key

Profile ID

A            PRFNAME      255A

Profile Name

A            PRFMODE      255A

Profile Mode

A            PRFDEC         6A

Profile Decision

A          R CTIRPTRULR

Record

CyberSource Report Profile Rule List Record

A            REPORTID      15P 0

Key

Report Unique ID (corresponds to unique ID in CTIRPT)

A            REQUESTID     30A

Key

Request ID (corresponds to record in CTIRPTREQ)

A            PROFID        15P 0

Key

Profile ID (corresponds to a record in CTIRPTPRF)

A            RULEID        15P 0

Key

Rule ID

A            RULENAME     255A

Rule Name

A            RULEDEC        6A

Rule Decision