Table C_PaymentProcessor
Description:
Process Definition for Payments/Receipts (Check, CC, etc.)
PRIMARY KEY
C_PaymentProcessor_ID
NUMBER (10, 0)
NOT NULL
AD_Client_ID
NUMBER (10, 0)
NOT NULL
AD_Org_ID
NUMBER (10, 0)
NOT NULL
IsActive
CHAR (1)
default: 'Y'
CHECK ( IsActive in ( 'Y' , 'N' ))
NOT NULL
Created
DATE
default: SYSDATE
NOT NULL
CreatedBy
NUMBER (10, 0)
NOT NULL
Updated
DATE
default: SYSDATE
NOT NULL
UpdatedBy
NUMBER (10, 0)
NOT NULL
Name
NVARCHAR2 (60)
NOT NULL
Description
NVARCHAR2 (255)
C_BankAccount_ID
NUMBER (10, 0)
NOT NULL
C_BankAccount
AD_Sequence_ID
NUMBER (10, 0)
AD_Sequence
PayProcessorClass
NVARCHAR2 (60)
PartnerID
NVARCHAR2 (60)
VendorID
NVARCHAR2 (60)
UserID
NVARCHAR2 (60)
Password
NVARCHAR2 (60)
HostAddress
NVARCHAR2 (60)
HostPort
NUMBER (10, 0)
ProxyAddress
NVARCHAR2 (60)
ProxyPort
NUMBER (10, 0)
ProxyLogon
NVARCHAR2 (60)
ProxyPassword
NVARCHAR2 (60)
AcceptVisa
CHAR (1)
default: 'Y'
CHECK ( AcceptVisa in ( 'Y' , 'N' ))
NOT NULL
AcceptMC
CHAR (1)
default: 'Y'
CHECK ( AcceptMC in ( 'Y' , 'N' ))
NOT NULL
AcceptAmex
CHAR (1)
default: 'Y'
CHECK ( AcceptAmex in ( 'Y' , 'N' ))
NOT NULL
AcceptDiners
CHAR (1)
default: 'Y'
CHECK ( AcceptDiners in ( 'Y' , 'N' ))
NOT NULL
AcceptDiscover
CHAR (1)
default: 'Y'
CHECK ( AcceptDiscover in ( 'Y' , 'N' ))
NOT NULL
AcceptCorporate
CHAR (1)
default: 'Y'
CHECK ( AcceptCorporate in ( 'Y' , 'N' ))
NOT NULL
AcceptDirectDeposit
CHAR (1)
default: 'N'
CHECK ( AcceptDirectDeposit in ( 'Y' , 'N' ))
NOT NULL
AcceptDirectDebit
CHAR (1)
default: 'N'
CHECK ( AcceptDirectDebit in ( 'Y' , 'N' ))
NOT NULL
AcceptCheck
CHAR (1)
default: 'Y'
CHECK ( AcceptCheck in ( 'Y' , 'N' ))
NOT NULL
AcceptATM
CHAR (1)
default: 'Y'
CHECK ( AcceptATM in ( 'Y' , 'N' ))
NOT NULL
RequireVV
CHAR (1)
default: 'N'
CHECK ( RequireVV in ( 'Y' , 'N' ))
NOT NULL
Verification Cide mandatory
C_Currency_ID
NUMBER (10, 0)
C_Currency
MinimumAmt
NUMBER
default: 0
CostPerTrx
NUMBER
default: 0
NOT NULL
Commission
NUMBER
NOT NULL
FOREIGN KEY
ADSequence_CPaymentProcessor: AD_Sequence_ID =>
AD_Sequence
CBankAccount_CPaymtProcessor: C_BankAccount_ID =>
C_BankAccount
CCurrency_CPaymentProcessor: C_Currency_ID =>
C_Currency
REFERENCED BY
C_PaymentBatch