Description:
The Payment Line
|
| PRIMARY KEY |
|
C_Payment_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| |
|
AD_Org_ID
NUMBER (10, 0) NOT NULL |
| AD_Org |
|
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 |
| |
|
DocumentNo
NVARCHAR2 (30) NOT NULL |
| |
|
DateTrx
DATE NOT NULL |
| |
|
IsReceipt
CHAR (1) default: 'Y' CHECK ( IsReceipt in ( 'Y' , 'N' )) NOT NULL |
| |
|
C_DocType_ID
NUMBER (10, 0) NOT NULL |
| C_DocType |
|
TrxType
CHAR (1) NOT NULL |
S=Sales
| |
|
C_BankAccount_ID
NUMBER (10, 0) NOT NULL |
| C_BankAccount |
|
C_BPartner_ID
NUMBER (10, 0) |
| C_BPartner |
|
C_Project_ID
NUMBER (10, 0) |
| C_Project |
|
C_Invoice_ID
NUMBER (10, 0) |
| |
|
C_BP_BankAccount_ID
NUMBER (10, 0) |
| C_BP_BankAccount |
|
C_PaymentBatch_ID
NUMBER (10, 0) |
| C_PaymentBatch |
|
TenderType
CHAR (1) NOT NULL |
| |
|
CreditCardType
CHAR (1) |
| |
|
CreditCardNumber
NVARCHAR2 (20) |
| |
|
CreditCardVV
VARCHAR2 (4) |
Verification Value
| |
|
CreditCardExpMM
NUMBER (10, 0) |
| |
|
CreditCardExpYY
NUMBER (10, 0) |
| |
|
MICR
NVARCHAR2 (20) |
| |
|
RoutingNo
NVARCHAR2 (20) |
| |
|
AccountNo
NVARCHAR2 (20) |
| |
|
CheckNo
NVARCHAR2 (20) |
| |
|
A_Name
NVARCHAR2 (60) |
| |
|
A_Street
NVARCHAR2 (60) |
| |
|
A_City
NVARCHAR2 (60) |
| |
|
A_State
NVARCHAR2 (40) |
| |
|
A_ZIP
NVARCHAR2 (20) |
| |
|
A_Country
NVARCHAR2 (40) |
| |
|
A_Ident_DL
NVARCHAR2 (20) |
| |
|
A_Ident_SSN
NVARCHAR2 (20) |
| |
|
A_Email
NVARCHAR2 (60) |
| |
|
VoiceAuthCode
NVARCHAR2 (20) |
| |
|
Swipe
VARCHAR2 (80) |
| |
|
Orig_TrxID
NVARCHAR2 (20) |
| |
|
PONum
NVARCHAR2 (60) |
| |
|
C_Currency_ID
NUMBER (10, 0) NOT NULL |
| C_Currency |
|
C_ConversionType_ID
NUMBER (10, 0) |
| C_ConversionType |
|
PayAmt
NUMBER default: 0 NOT NULL |
| |
|
DiscountAmt
NUMBER default: 0 |
Copied into Allocation
| |
|
WriteOffAmt
NUMBER default: 0 |
| |
|
IsOverUnderPayment
CHAR (1) default: 'N' CHECK ( IsOverUnderPayment in ( 'Y' , 'N' )) NOT NULL |
| |
|
OverUnderAmt
NUMBER default: 0 |
| |
|
C_Charge_ID
NUMBER (10, 0) |
| C_Charge |
|
ChargeAmt
NUMBER default: 0 |
| |
|
TaxAmt
NUMBER default: 0 |
Only used for CreditCard Trx
| |
|
IsApproved
CHAR (1) default: 'N' CHECK ( IsApproved in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsSelfService
CHAR (1) default: 'N' CHECK ( IsSelfService in ( 'Y' , 'N' )) NOT NULL |
Was entered and/or can be edited by user via Self Service
| |
|
IsDelayedCapture
CHAR (1) default: 'N' CHECK ( IsDelayedCapture in ( 'Y' , 'N' )) NOT NULL |
| |
|
R_PNRef
NVARCHAR2 (20) |
| |
|
R_PNRef_DC
NVARCHAR2 (20) |
| |
|
R_Result
NVARCHAR2 (20) |
| |
|
R_RespMsg
NVARCHAR2 (60) |
| |
|
R_AuthCode
NVARCHAR2 (20) |
| |
|
R_AuthCode_DC
NVARCHAR2 (20) |
| |
|
R_AVSAddr
CHAR (1) |
| |
|
R_AVSZIP
CHAR (1) |
| |
|
R_CVV2Match
CHAR (1) |
| |
|
R_Info
NVARCHAR2 (2000) |
| |
|
Processing
CHAR (1) |
| |
|
OProcessing
CHAR (1) |
| |
|
DocStatus
CHAR (2) NOT NULL |
| |
|
DocAction
CHAR (2) NOT NULL |
| |
|
IsReconciled
CHAR (1) default: 'N' CHECK ( IsReconciled in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsAllocated
CHAR (1) default: 'N' CHECK ( IsAllocated in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsOnline
CHAR (1) default: 'N' CHECK ( IsOnline in ( 'Y' , 'N' )) NOT NULL |
| |
|
Processed
CHAR (1) default: 'N' CHECK ( Processed in ( 'Y' , 'N' )) NOT NULL |
| |
|
Posted
CHAR (1) default: 'N' NOT NULL |
| |
|
AD_OrgTrx_ID
NUMBER (10, 0) |
| AD_Org |
|
C_Campaign_ID
NUMBER (10, 0) |
| C_Campaign |
|
C_Activity_ID
NUMBER (10, 0) |
| C_Activity |
|
User1_ID
NUMBER (10, 0) |
| C_ElementValue |
|
User2_ID
NUMBER (10, 0) |
| C_ElementValue |
FOREIGN KEY
ADOrg_CPayment: AD_Org_ID => AD_Org
ADOrgTrx_CPayment: AD_OrgTrx_ID => AD_Org
CActivity_CPayment: C_Activity_ID => C_Activity
CBankAccount_CPayment: C_BankAccount_ID => C_BankAccount
CBPartner_CPayment: C_BPartner_ID => C_BPartner
CBPBankAcct_CPayment: C_BP_BankAccount_ID => C_BP_BankAccount
CCampaign_CPayment: C_Campaign_ID => C_Campaign
CCharge_CPayment: C_Charge_ID => C_Charge
CConversionType_CPayment: C_ConversionType_ID => C_ConversionType
CCurrency_CPayment: C_Currency_ID => C_Currency
CDocType_CPayment: C_DocType_ID => C_DocType
CElementValueUser1_CPayment: User1_ID => C_ElementValue
CElementValueUser2_CPayment: User2_ID => C_ElementValue
CPaymentBatch_CPayment: C_PaymentBatch_ID => C_PaymentBatch
CProject_CPayment: C_Project_ID => C_Project
|
REFERENCED BY
B_BuyerFunds,
B_SellerFunds,
C_Allocation,
C_BankStatementLine,
C_DunningRunLine,
C_Invoice,
C_Order,
C_PaySelectionCheck,
C_Recurring,
C_Recurring_Run,
I_BankStatement,
I_Payment,
R_Request,
R_RequestAction |
|