🗄️What WP Table Is This?
Home / Payment gateway NestPay for WooCommerce / wp_woocommerce_npp_transactions

wp_woocommerce_npp_transactions

Static

Stores woocommerce npp transactions data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑IDBIGINT UNSIGNEDNO
order_idBIGINT UNSIGNEDNO
oidVARCHAR( 64 )NO
trantypeVARCHAR( 20 )NO
protocolVARCHAR( 20 )NO
amountDECIMAL( 12, 2 )NO
currencyVARCHAR( 3 )NO
ResponseVARCHAR( 10 )YES
ProcReturnCodeVARCHAR( 2 )YES
mdStatusVARCHAR( 3 )YES
ErrMsgVARCHAR( 255 )YES
AuthCodeVARCHAR( 32 )YES
TransIdVARCHAR( 64 )YES
TRANIDVARCHAR( 64 )YES
clientIpVARCHAR( 15 )YES
payResults_dsIdVARCHAR( 64 )YES
signatureVARCHAR( 1024 )YES
descriptionVARCHAR( 255 )YES
orgHashVARCHAR( 512 )YES
HASHPARAMSVARCHAR( 512 )YES
HASHVARCHAR( 512 )YES
HASHPARAMSVALVARCHAR( 512 )YES
orgRndVARCHAR( 64 )YES
commentsVARCHAR( 255 )YES
instalmentVARCHAR( 3 )YES
storetypeVARCHAR( 16 )YES
langVARCHAR( 16 )YES
xidVARCHAR( 255 )YES
HostRefNumVARCHAR( 255 )YES
ReturnOidVARCHAR( 64 )YES
MaskedPanVARCHAR( 20 )YES
rndVARCHAR( 20 )YES
merchantIDVARCHAR( 255 )YES
hc_activeSMALLINT( 1 )YES
txstatusVARCHAR( 255 )YES
iReqCodeVARCHAR( 255 )YES
iReqDetailVARCHAR( 255 )YES
vendorCodeVARCHAR( 255 )YES
PAResSyntaxOKVARCHAR( 255 )YES
PAResVerifiedVARCHAR( 255 )YES
veresEnrolledStatusVARCHAR( 255 )YES
eciVARCHAR( 255 )YES
cavvVARCHAR( 255 )YES
cavvAlgorthmVARCHAR( 255 )YES
mdVARCHAR( 255 )YES
VersionVARCHAR( 255 )YES
sIDVARCHAR( 255 )YES
mdErrorMsgtextYES
clientidVARCHAR( 255 )YES
EXTRA_TRXDATEVARCHAR( 255 )YES
EXTRA_UCAFINDICATORVARCHAR( 255 )YES
ACQBINVARCHAR( 255 )YES
acqStanVARCHAR( 255 )YES
cavvAlgorithmVARCHAR( 255 )YES
digestVARCHAR( 255 )YES
dsIdVARCHAR( 255 )YES
isHPPCallVARCHAR( 255 )YES
Ecom_Payment_Card_ExpDate_MonthVARCHAR( 255 )YES
Ecom_Payment_Card_ExpDate_YearVARCHAR( 255 )YES
EXTRA_CARDBRANDVARCHAR( 255 )YES
EXTRA_CARDISSUERVARCHAR( 255 )YES
shopurlVARCHAR( 255 )YES
callbackCallVARCHAR( 20 )YES
encodingVARCHAR( 20 )YES
refreshtimeVARCHAR( 255 )YES
SettleIdVARCHAR( 255 )YES
created_attimestampNO
updated_attimestampNO
_charset_VARCHAR( 10 )YES

CREATE TABLE Statement

CREATE TABLE wp_woocommerce_npp_transactions ( ID BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, order_id BIGINT UNSIGNED NOT NULL, oid VARCHAR( 64 ) NOT null, trantype VARCHAR( 20 ) NOT null, protocol VARCHAR( 20 ) NOT null, amount DECIMAL( 12, 2 ) NOT null, currency VARCHAR( 3 ) NOT null, Response VARCHAR( 10 ) default null, ProcReturnCode VARCHAR( 2 ) default null, mdStatus VARCHAR( 3 ) default null, ErrMsg VARCHAR( 255 ) default null, AuthCode VARCHAR( 32 ) default null, TransId VARCHAR( 64 ) default null, TRANID VARCHAR( 64 ) default null, clientIp VARCHAR( 15 ) default null, payResults_dsId VARCHAR( 64 ) default null, signature VARCHAR( 1024 ) default null, description VARCHAR( 255 ) default null, orgHash VARCHAR( 512 ) default null, HASHPARAMS VARCHAR( 512 ) default null, HASH VARCHAR( 512 ) default null, HASHPARAMSVAL VARCHAR( 512 ) default null, orgRnd VARCHAR( 64 ) default null, comments VARCHAR( 255 ) default null, instalment VARCHAR( 3 ) null, storetype VARCHAR( 16 ) default null, lang VARCHAR( 16 ) default null, xid VARCHAR( 255 ) default null, HostRefNum VARCHAR( 255 ) default null, ReturnOid VARCHAR( 64 ) default null, MaskedPan VARCHAR( 20 ) default null, rnd VARCHAR( 20 ) default null, merchantID VARCHAR( 255 ) default null, hc_active SMALLINT( 1 ) default null, txstatus VARCHAR( 255 ) default null, iReqCode VARCHAR( 255 ) default null, iReqDetail VARCHAR( 255 ) default null, vendorCode VARCHAR( 255 ) default null, PAResSyntaxOK VARCHAR( 255 ) default null, PAResVerified VARCHAR( 255 ) default null, veresEnrolledStatus VARCHAR( 255 ) default null, eci VARCHAR( 255 ) default null, cavv VARCHAR( 255 ) default null, cavvAlgorthm VARCHAR( 255 ) default null, md VARCHAR( 255 ) default null, Version VARCHAR( 255 ) default null, sID VARCHAR( 255 ) default null, mdErrorMsg text default null, clientid VARCHAR( 255 ) default null, EXTRA_TRXDATE VARCHAR( 255 ) default null, EXTRA_UCAFINDICATOR VARCHAR( 255 ) default null, ACQBIN VARCHAR( 255 ) default null, acqStan VARCHAR( 255 ) default null, cavvAlgorithm VARCHAR( 255 ) default null, digest VARCHAR( 255 ) default null, dsId VARCHAR( 255 ) default null, isHPPCall VARCHAR( 255 ) default null, Ecom_Payment_Card_ExpDate_Month VARCHAR( 255 ) default null, Ecom_Payment_Card_ExpDate_Year VARCHAR( 255 ) default null, EXTRA_CARDBRAND VARCHAR( 255 ) default null, EXTRA_CARDISSUER VARCHAR( 255 ) default null, shopurl VARCHAR( 255 ) default null, callbackCall VARCHAR( 20 ) default null, encoding VARCHAR( 20 ) default null, refreshtime VARCHAR( 255 ) default null, SettleId VARCHAR( 255 ) default null, created_at timestamp NOT null default CURRENT_TIMESTAMP, updated_at timestamp NOT null default CURRENT_TIMESTAMP, _charset_ VARCHAR( 10 ) default null, PRIMARY KEY (ID), KEY trantype (trantype), KEY currency (currency), KEY Response (Response), KEY ProcReturnCode (ProcReturnCode), KEY mdStatus (mdStatus), KEY AuthCode (AuthCode) ) {$collate};"; return $tables; } /** * Adds default plugin options * * @since 2.0.0 */ public static function create_options() { } /** * Update wcnpg version to current. */ public static function update_wcnpg_version() { update_option( 'wcnpg_version', WCNPG()->version );

Safe to delete?

If you have uninstalled Payment gateway NestPay for WooCommerce, this table is generally safe to remove. However, always back up your database first.

Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.

How to remove this table

DROP TABLE IF EXISTS `wp_woocommerce_npp_transactions`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.