Description:
The Payment Line
|
| PRIMARY KEY |
|
I_Payment_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) |
| |
|
AD_Org_ID
NUMBER (10, 0) |
| |
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) |
| |
|
Created
DATE default: SYSDATE |
| |
|
CreatedBy
NUMBER (10, 0) |
| |
|
Updated
DATE default: SYSDATE |
| |
|
UpdatedBy
NUMBER (10, 0) |
| |
|
I_IsImported
CHAR (1) default: 'N' NOT NULL |
| |
|
I_ErrorMsg
NVARCHAR2 (2000) |
| |
|
Processing
CHAR (1) |
| |
|
Processed
CHAR (1) default: 'N' CHECK ( Processed in ( 'Y' , 'N' )) |
| |
|
C_Payment_ID
NUMBER (10, 0) |
| C_Payment |
|
DocumentNo
NVARCHAR2 (30) |
| |
|
DateTrx
DATE |
| |
|
IsReceipt
CHAR (1) default: 'Y' CHECK ( IsReceipt in ( 'Y' , 'N' )) |
| |
|
C_DocType_ID
NUMBER (10, 0) |
| C_DocType |
|
DocTypeName
NVARCHAR2 (60) |
| |
|
TrxType
CHAR (1) |
S=Sales
| |
|
C_BankAccount_ID
NUMBER (10, 0) |
| C_BankAccount |
|
BankAccountNo
NVARCHAR2 (20) |
| |
|
C_BPartner_ID
NUMBER (10, 0) |
| C_BPartner |
|
BPartnerValue
NVARCHAR2 (40) |
| |
|
C_Invoice_ID
NUMBER (10, 0) |
| C_Invoice |
|
InvoiceDocumentNo
NVARCHAR2 (30) |
| |
|
TenderType
CHAR (1) |
| |
|
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) |
| |
|
PayAmt
NUMBER default: 0 |
| |
|
DiscountAmt
NUMBER default: 0 |
Copied into Allocation
| |
|
WriteOffAmt
NUMBER default: 0 |
| |
|
IsOverUnderPayment
CHAR (1) default: 'N' CHECK ( IsOverUnderPayment in ( 'Y' , 'N' )) |
| |
|
OverUnderAmt
NUMBER default: 0 |
| |
|
C_Charge_ID
NUMBER (10, 0) |
| C_Charge |
|
ChargeName
NVARCHAR2 (60) |
| |
|
ChargeAmt
NUMBER default: 0 |
| |
|
TaxAmt
NUMBER default: 0 |
Only used for CreditCard Trx
| |
|
IsApproved
CHAR (1) default: 'N' CHECK ( IsApproved in ( 'Y' , 'N' )) |
| |
|
IsSelfService
CHAR (1) default: 'N' CHECK ( IsSelfService in ( 'Y' , 'N' )) |
Was entered and/or can be edited by user via Self Service
| |
|
IsDelayedCapture
CHAR (1) default: 'N' CHECK ( IsDelayedCapture in ( 'Y' , 'N' )) |
| |
|
R_PNRef
NVARCHAR2 (20) |
| |
|
R_Result
NVARCHAR2 (20) |
| |
|
R_RespMsg
NVARCHAR2 (60) |
| |
|
R_AuthCode
NVARCHAR2 (20) |
| |
|
R_Info
NVARCHAR2 (2000) |
| |
FOREIGN KEY
CBankAccount_IPayment: C_BankAccount_ID => C_BankAccount
CBPartner_IPayment: C_BPartner_ID => C_BPartner
CCharge_IPayment: C_Charge_ID => C_Charge
CDocType_IPayment: C_DocType_ID => C_DocType
CInvoice_IPayment: C_Invoice_ID => C_Invoice
CPayment_IPayment: C_Payment_ID => C_Payment
|