GPOQ

Tables (22)

TCardContractFee

  • SeqNo — int — Primary key — NOT NULL
  • CardCPID — varchar(20) — NOT NULL
  • Brand — varchar(20)
  • CheckCardFlag — char(1)
  • Version — int — NOT NULL
  • CollectPeriodID — smallint — NOT NULL
  • PGFee — money — NOT NULL
  • TransactionFee — money
  • TransactionFeeCurrency — char(3)
  • ChargebackFee — money
  • RefundFee — money
  • RollingReserve — money
  • RollingReservePeriod — smallint
  • UseState — tinyint — NOT NULL
  • AdminID — varchar(20) — NOT NULL
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TCardContractMgmt

  • CardCPID — varchar(20) — Primary key — NOT NULL
  • Version — int — NOT NULL
  • IssuerType — tinyint — NOT NULL
  • KeyinCertType — tinyint — NOT NULL
  • AcqCardCode — char(4) — NOT NULL
  • CardCPName — nvarchar(50) — NOT NULL
  • CollectCurrency — char(3) — NOT NULL
  • RoundType — tinyint — NOT NULL
  • InstmtFlag — char(1) — NOT NULL
  • LimitType — tinyint — NOT NULL
  • LimitChkType — tinyint — NOT NULL
  • LimitAmt — money — NOT NULL
  • UseState — tinyint — NOT NULL
  • AdminID — varchar(20) — NOT NULL
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TCardPGCurrency

  • CardCPID — varchar(20) — Primary key — NOT NULL
  • PGCode — varchar(20) — Primary key — NOT NULL
  • PGSubCode — varchar(20) — Primary key — NOT NULL
  • Currency — char(3) — Primary key — NOT NULL
  • SeqNo — int — NOT NULL
  • UseState — tinyint — NOT NULL
  • AdminID — varchar(20) — NOT NULL
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TCountryMst

  • CountryCode — char(3) — Primary key — NOT NULL
  • CountryName — nvarchar(100) — NOT NULL
  • UseState — tinyint — NOT NULL
  • AdminID — varchar(20) — NOT NULL
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime
  • SettleCountryCode — char(2)
  • CountryNum — char(3)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TCurrencyMst

  • Currency — char(3) — Primary key — NOT NULL
  • CurrencyName — nvarchar(100) — NOT NULL
  • UseState — tinyint — NOT NULL
  • AdminID — varchar(20) — NOT NULL
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime
  • DecimalPlace — tinyint
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TMerchant

  • MerchantID — varchar(20) — Primary key — NOT NULL
  • MerchantName — nvarchar(40) — NOT NULL
  • PostZip — varchar(10) — NOT NULL
  • PostAddr1 — nvarchar(200) — NOT NULL
  • PostAddr2 — nvarchar(200) — NOT NULL
  • UseState — tinyint — NOT NULL
  • AdminID — varchar(20) — NOT NULL
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime
  • Versions — int — NOT NULL
  • AbroadType — tinyint
  • MerchantBizNo — varchar(20)
  • MerchantKind — nvarchar(20)
  • MerchantProduct — nvarchar(50)
  • MerchantTel — varchar(20)
  • CEOName — nvarchar(40)
  • ForeignBankFlag — char(1)
  • BankCode — char(3)
  • BankAcctNo — varchar(200)
  • BankOwner — nvarchar(40)
  • SettleCountryCode — char(2)
  • BICCode — char(11)
  • ForeignBankAcctNo — varchar(200)
  • ForeignBankOwner — varchar(35)
  • ForeignBankReceiveAddr1 — varchar(35)
  • ForeignBankReceiveAddr2 — varchar(35)
  • TaxBillFlag — char(1) — NOT NULL
  • TransferFeeCurrency — char(3)
  • TransferFee — money
  • BankRoutingNumber — varchar(15)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TPGContract

  • PGMerchantID — varchar(20) — Primary key — NOT NULL
  • PGMerchantVersion — smallint — NOT NULL
  • PGCode — varchar(20) — NOT NULL
  • PGSubCode — varchar(20) — NOT NULL
  • ProdCode1 — varchar(200)
  • ProdCode2 — varchar(200)
  • ProdCode3 — varchar(200)
  • ContractYMD — char(8) — NOT NULL
  • CancelYMD — char(8)
  • UseState — tinyint — NOT NULL
  • AdminID — varchar(20) — NOT NULL
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime
  • RecurringFlag — char(1)
  • ProdCode4 — varchar(200)
  • DMFlag — char(1)
  • CYMerchantID — varchar(200)
  • CYKeyID — varchar(200)
  • CYSecretKey — varchar(200)
  • CY3DSFlag — char(1)
  • CYHybridFlag — char(1)
  • CYOrgUnitID — varchar(200)
  • CYAPIIdentifier — varchar(200)
  • CYAPIKey — varchar(200)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TPGContractFee

  • SeqNo — int — Primary key — NOT NULL
  • DefaultFlag — tinyint — NOT NULL
  • PGCode — varchar(20) — NOT NULL
  • PGMerchantID — varchar(20) — NOT NULL
  • CardCode — varchar(20) — NOT NULL
  • CountryCode — char(3) — NOT NULL
  • Currency — char(3) — NOT NULL
  • CancelFeeFlag — tinyint — NOT NULL
  • DecimalPoint — tinyint — NOT NULL
  • RoundFlag — tinyint — NOT NULL
  • FeeMethod — tinyint — NOT NULL
  • UseState — tinyint — NOT NULL
  • PGFeeVersion — smallint — NOT NULL
  • CollectPeriodID — smallint — NOT NULL
  • IncVAT — tinyint — NOT NULL
  • PGFeeCurrency — char(3) — NOT NULL
  • PGFeeType — tinyint — NOT NULL
  • PGFee — money — NOT NULL
  • TransactionFeeCurrency — char(3) — NOT NULL
  • TransactionFeeType — tinyint — NOT NULL
  • TransactionFee — money — NOT NULL
  • ChargeBackFeeCurrency — char(3) — NOT NULL
  • ChargeBackFeeType — tinyint — NOT NULL
  • ChargeBackFee — money — NOT NULL
  • RefundFeeCurrency — char(3) — NOT NULL
  • RefundFeeType — tinyint — NOT NULL
  • RefundFee — money — NOT NULL
  • RollingReserveCurrency — char(3) — NOT NULL
  • RollingReservePeriod — smallint — NOT NULL
  • RollingReserve — money — NOT NULL
  • WithHoldingTaxCurrency — char(3) — NOT NULL
  • WithHoldingTaxType — tinyint — NOT NULL
  • WithHoldingTax — money — NOT NULL
  • CollectExchangeFeeCurrency — char(3) — NOT NULL
  • CollectExchangeFeeType — tinyint — NOT NULL
  • CollectExchangeFee — money — NOT NULL
  • EtcFeeCurrency — char(3) — NOT NULL
  • EtcFeeType — tinyint — NOT NULL
  • EtcFee — money — NOT NULL
  • AdminID — varchar(20) — NOT NULL
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TPGCurrency

  • PGCode — varchar(20) — Primary key — NOT NULL
  • PGSubCode — varchar(20) — Primary key — NOT NULL
  • Currency — char(3) — Primary key — NOT NULL
  • SeqNo — smallint — NOT NULL
  • Usestate — tinyint — NOT NULL
  • AdminID — varchar(20) — NOT NULL
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TPGMst

  • PGCode — varchar(20) — Primary key — NOT NULL
  • PGSubCode — varchar(20) — Primary key — NOT NULL
  • PayTool — char(2)
  • PGName — varchar(100) — NOT NULL
  • PGDesc — nvarchar(500) — NOT NULL
  • PGAddr — nvarchar(200)
  • LogoPath1 — nvarchar(512) — NOT NULL
  • LogoPath2 — nvarchar(512) — NOT NULL
  • PGBizNo — varchar(20)
  • BankCode — char(3)
  • BankAcctNo — varchar(200)
  • BankOwner — nvarchar(20)
  • BankAddr — nvarchar(200)
  • BankBranch — nvarchar(200)
  • PGURL — varchar(100) — NOT NULL
  • PGSvcURL — varchar(256)
  • CancelFlag — tinyint
  • CancelComm — money
  • CancelCurrency — char(3)
  • CurrencyChkFlag — char(1)
  • UseState — tinyint — NOT NULL
  • AdminID — varchar(20) — NOT NULL
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime
  • KeyInChkFlag — char(1)
  • PGSvcRecurURL — varchar(256)
  • OnlyAuthFlag — char(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TPayLogMst

  • Token — bigint — Primary key — NOT NULL
  • StoreID — varchar(20) — NOT NULL
  • PGInfo — varchar(40)
  • Currency — char(3) — NOT NULL
  • StoreOrderNo — varchar(128) — NOT NULL
  • PayAmt — money — NOT NULL
  • PayerID — varchar(50) — NOT NULL
  • EncPayerEmail — varchar(300) — NOT NULL
  • PayerIP — varchar(50)
  • ServiceName — nvarchar(100)
  • ReturnURL — varchar(256) — NOT NULL
  • NotifyURL — varchar(256)
  • StoreETCParam — nvarchar(2048)
  • ClientParam — varchar(8000)
  • GMTYMD — char(8) — NOT NULL
  • YMD — char(8) — NOT NULL
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime
  • PGCode — varchar(20)
  • PGSubCode — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TPayNotiMst

  • SeqNo — bigint — Primary key — NOT NULL
  • PaySeqNo — bigint — NOT NULL
  • NotifyType — tinyint — NOT NULL
  • StoreID — varchar(20) — NOT NULL
  • NotiURL — varchar(2000) — NOT NULL
  • NotiParam — nvarchar(4000) — NOT NULL
  • TryCnt — tinyint — NOT NULL
  • WorkStatus — tinyint — NOT NULL
  • UseState — tinyint — NOT NULL
  • YMD — char(8) — NOT NULL
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime
  • LastNotiDate — datetime
  • WorkingDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TPayToolMst

  • PayTool — char(2) — NOT NULL
  • PayToolName — nvarchar(50) — NOT NULL
  • PayToolDesc — nvarchar(256)
  • UseState — tinyint — NOT NULL
  • AdminID — varchar(20)
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime

TPaymentAuth

  • PaySeq — bigint — Primary key — NOT NULL
  • StoreID — varchar(20) — NOT NULL
  • PGCode — varchar(20) — NOT NULL
  • PGSubCode — varchar(20) — NOT NULL
  • CountryCode — char(3)
  • Currency — char(3) — NOT NULL
  • PayToken — varchar(20) — NOT NULL
  • StoreOrderNo — varchar(128) — NOT NULL
  • PayAmt — money — NOT NULL
  • PayerID — varchar(50) — NOT NULL
  • EncPayerEmail — varchar(300) — NOT NULL
  • PayerIP — varchar(50) — NOT NULL
  • ServiceName — nvarchar(100)
  • ContractID — varchar(20) — NOT NULL
  • PayInfo — nvarchar(200)
  • ReturnURL — varchar(256) — NOT NULL
  • StoreETCParam — nvarchar(2048)
  • UnixTimeStamp — varchar(10) — NOT NULL
  • GMTYMD — char(8) — NOT NULL
  • YMD — char(8) — NOT NULL
  • RegDate — datetime — NOT NULL
  • PayRsltCode — varchar(10)
  • PayRsltMsg — nvarchar(256)
  • UpdDate — datetime
  • StateCode — tinyint — NOT NULL
  • NotifyURL — varchar(256)
  • FAILTYPECODE — char(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TPaymentMst

  • PaySeq — bigint — Primary key — NOT NULL
  • StoreID — varchar(20) — NOT NULL
  • PGCode — varchar(20) — NOT NULL
  • PGSubCode — varchar(20) — NOT NULL
  • CountryCode — char(3)
  • Currency — char(3) — NOT NULL
  • PayToken — varchar(20) — NOT NULL
  • StoreOrderNo — varchar(128)
  • PayAmt — money — NOT NULL
  • PayerID — varchar(50) — NOT NULL
  • EncPayerEmail — varchar(300) — NOT NULL
  • PayerIP — varchar(50) — NOT NULL
  • ServiceName — nvarchar(100) — NOT NULL
  • ContractID — varchar(20) — NOT NULL
  • ContractVersion — smallint — NOT NULL
  • PGMerchantID — varchar(20) — NOT NULL
  • PGMerchantVersion — smallint — NOT NULL
  • PGToken — varchar(60)
  • PayInfo — nvarchar(200)
  • CardKind — nvarchar(50)
  • UseState — tinyint — NOT NULL
  • CancelReason — nvarchar(1000)
  • CancelYMD — char(8)
  • GMTYMD — char(8) — NOT NULL
  • YMD — char(8) — NOT NULL
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime
  • CardCPID — varchar(20)
  • CardCode — char(4)
  • Instmt — varchar(2)
  • CID — varchar(60)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TPaymentPartialCnlMst

  • ID — int — Primary key — NOT NULL
  • StoreID — varchar(20) — NOT NULL
  • PGCode — varchar(20) — NOT NULL
  • PGSubCode — varchar(20) — NOT NULL
  • PaySeqNo — bigint
  • PayToken — varchar(40) — NOT NULL
  • PGToken — varchar(60)
  • PayAmt — money
  • TCancelDate — varchar(20)
  • CancelYMD — char(8) — NOT NULL
  • YMD — char(8) — NOT NULL
  • RegDate — datetime — NOT NULL
  • ChargebackFlag — char(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TPaymentSummary

  • SummarySeq — bigint — Primary key — NOT NULL
  • YMD — char(8) — NOT NULL
  • CountryCode — char(3) — NOT NULL
  • PGInfo — varchar(50) — NOT NULL
  • PGCode — varchar(20) — NOT NULL
  • PGSubCode — varchar(20) — NOT NULL
  • Currency — char(3) — NOT NULL
  • MerchantID — varchar(20) — NOT NULL
  • StoreID — varchar(20) — NOT NULL
  • SummaryType — tinyint — NOT NULL
  • PayAmt — money — NOT NULL
  • PayCnt — int — NOT NULL

TRecurringFailLog

  • SeqNo — bigint — Primary key — NOT NULL
  • StoreID — varchar(20) — NOT NULL
  • PGCode — varchar(20) — NOT NULL
  • PGSubCode — varchar(20) — NOT NULL
  • POQToken — varchar(40) — NOT NULL
  • PayToken — varchar(20)
  • PayAmt — money — NOT NULL
  • Currency — char(3) — NOT NULL
  • RsltCode — nvarchar(256)
  • RsltMsg — nvarchar(256)
  • YMD — char(8) — NOT NULL
  • RegDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TRecurringKeyMgmt

  • SeqNo — bigint — Primary key — NOT NULL
  • YMD — char(8) — NOT NULL
  • StoreID — varchar(20) — NOT NULL
  • ContractID — varchar(20) — NOT NULL
  • PGCode — varchar(20)
  • PGSubCode — varchar(20)
  • PGMerchantID — varchar(20)
  • POQToken — varchar(40) — NOT NULL
  • PGToken — varchar(200)
  • PayAmt — money
  • Currency — char(3)
  • NameOnCard — nvarchar(256)
  • CardKind — nvarchar(50)
  • CardNo — varchar(128) — NOT NULL
  • ExpMonth — varchar(128) — NOT NULL
  • ExpYear — varchar(128) — NOT NULL
  • APIKey1 — varchar(256)
  • APIKey2 — varchar(256)
  • UseState — tinyint — NOT NULL
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime
  • NotifyURL — varchar(256)
  • MobilePhoneNo — varchar(128)
  • BirthDay — varchar(128)
  • CardPwd — varchar(128)
  • AcqCardCode — char(4)
  • CardCode — char(4)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TStore

  • StoreID — varchar(20) — Primary key — NOT NULL
  • MerchantID — varchar(20) — NOT NULL
  • StoreName — nvarchar(40) — NOT NULL
  • StoreBizNo — varchar(20)
  • StoreKind — nvarchar(20)
  • StoreProduct — nvarchar(50)
  • CEOName — nvarchar(40)
  • BankCode — char(3) — NOT NULL
  • BankAcctNo — varchar(200)
  • BankOwner — nvarchar(40) — NOT NULL
  • StoreURL — varchar(100) — NOT NULL
  • ServiceURL — varchar(100) — NOT NULL
  • PostZip — varchar(10) — NOT NULL
  • PostAddr1 — nvarchar(200) — NOT NULL
  • PostAddr2 — nvarchar(200) — NOT NULL
  • EncHashKey — varchar(200) — NOT NULL
  • NotifyURL — varchar(256) — NOT NULL
  • NotifyTryCnt — int — NOT NULL
  • PayType — tinyint — NOT NULL
  • AbroadType — tinyint — NOT NULL
  • UseState — tinyint — NOT NULL
  • ReceiptFlag — char(1) — NOT NULL
  • AdminID — varchar(20) — NOT NULL
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime
  • VanID — varchar(10)
  • BLAutoFlag — char(1)
  • ForeignBankFlag — char(1) — NOT NULL
  • SettleYMDType — tinyint — NOT NULL
  • SettleBasicSeq — tinyint — NOT NULL
  • SettleCountryCode — char(2)
  • BICCode — char(11)
  • ForeignBankName — varchar(35)
  • ForeignBankAddr1 — varchar(35)
  • ForeignBankAddr2 — varchar(35)
  • ForeignBankAcctNo — varchar(200)
  • ForeignBankOwner — varchar(35)
  • ForeignBankReceiveAddr1 — varchar(35)
  • ForeignBankReceiveAddr2 — varchar(35)
  • CustomizingFlag — char(1)
  • CustomizingBGColor — nvarchar(10)
  • CEOBirth — varchar(8)
  • CompanyTel — varchar(20)
  • CompanyEmail — varchar(100)
  • RegistrationFeeFlag — char(1)
  • SalesManager — nvarchar(40)
  • WarrantyExemptionFlag — char(1)
  • RollingReserveFlag — char(1)
  • WarrantyInsuranceFlag — char(1)
  • WarrantyEndYMD — char(8)
  • WarrantyAMT — int
  • SettleLimitFlag — char(1)
  • TaxBillFlag — char(1) — NOT NULL
  • SettleIDType — tinyint — NOT NULL
  • TaxBillIDType — tinyint — NOT NULL
  • AfterFeeCurrency — char(3)
  • AfterFee — money
  • AfterAnnualFeeFlag — char(1) — NOT NULL
  • AfterAnnualFeeCurrency — char(3)
  • AfterAnnualFee — money
  • … +17

TStoreContract

  • ContractID — varchar(20) — Primary key — NOT NULL
  • ContractVersion — smallint — NOT NULL
  • PGMerchantID — varchar(20) — NOT NULL
  • StoreID — varchar(20) — NOT NULL
  • ContractYMD — char(8) — NOT NULL
  • CancelYMD — char(8)
  • FraudUserRegFlag — char(1)
  • UseState — tinyint — NOT NULL
  • AdminID — varchar(20) — NOT NULL
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime
  • CancelFlag — char(1) — NOT NULL
  • ParticialCancelFlag — char(1) — NOT NULL
  • KeyInFlag — char(1)
  • DisputeMgmtFlag — char(1)
  • PaypalLogicChgFlag — char(1)
  • DisplayFlag — char(1)
  • CancelAbleFlag — char(1)
  • CancelAblePeriod — int
  • DMType — tinyint
  • DomesticFlag — char(1)
  • DMFlag — char(1)
  • DisplayReason — tinyint
  • SwitchingContractID — varchar(20)
  • CY3DSFlag — char(1)
  • VanID — varchar(10)
  • InstmtFlag — char(1)
  • InstmtPeriod — varchar(100)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

TStoreContractFee

  • SeqNo — int — Primary key — NOT NULL
  • DefaultFlag — tinyint — NOT NULL
  • PGMerchantID — varchar(20) — NOT NULL
  • StoreID — varchar(20) — NOT NULL
  • ContractID — varchar(20) — NOT NULL
  • CardCode — varchar(20) — NOT NULL
  • CountryCode — char(3) — NOT NULL
  • Currency — char(3) — NOT NULL
  • UseState — tinyint — NOT NULL
  • StoreFeeVersion — int — NOT NULL
  • SettleCurrency — char(3) — NOT NULL
  • SettlePeriodID — smallint — NOT NULL
  • IncVAT — tinyint — NOT NULL
  • StoreFeeCurrency — char(3) — NOT NULL
  • StoreFeeType — tinyint — NOT NULL
  • StoreFee — money — NOT NULL
  • TransactionFeeCurrency — char(3) — NOT NULL
  • TransactionFeeType — tinyint — NOT NULL
  • TransactionFee — money — NOT NULL
  • ChargeBackFeeCurrency — char(3) — NOT NULL
  • ChargeBackFeeType — tinyint — NOT NULL
  • ChargeBackFee — money — NOT NULL
  • RefundFeeCurrency — char(3) — NOT NULL
  • RefundFeeType — tinyint — NOT NULL
  • RefundFee — money — NOT NULL
  • RollingReserveCurrency — char(3) — NOT NULL
  • RollingReservePeriod — smallint — NOT NULL
  • RollingReserve — money — NOT NULL
  • SettleExchangeFeeCurrency — char(3) — NOT NULL
  • SettleExchangeFeeType — tinyint — NOT NULL
  • SettleExchangeFee — money — NOT NULL
  • EtcFeeCurrency — char(3) — NOT NULL
  • EtcFeeType — tinyint — NOT NULL
  • EtcFee — money — NOT NULL
  • AdminID — varchar(20) — NOT NULL
  • RegDate — datetime — NOT NULL
  • UpdDate — datetime
  • DMFeeChargeFlag — char(1)
  • DMFeeCurrency — char(3)
  • DMFeeType — tinyint
  • DMFee — money
  • CY3DSFeeChargeFlag — char(1)
  • CY3DSFeeCurrency — char(3)
  • CY3DSFeeType — tinyint
  • CY3DSFee — money
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =