Payment
C_Payment
Payment identifier
Overview
| Table Name | C_Payment |
|---|---|
| Access Level | Organization Only |
| Entity Type | D |
| Is Document | Yes |
| Is View | No |
| Has UUID | Yes |
| Parent Table | AD_OrgTrx |
| Wiki | View on iDempiere Wiki |
Columns (107)
| Column | Type | Required | Default | Description |
|---|---|---|---|---|
A_Country |
String(40) | No | - | Country |
AD_OrgTrx_ID |
Table(22) | No | - | Performing or initiating organization |
C_Activity_ID |
Table Direct(22) | No | - | Business Activity |
Cashier_ID |
Table(10) | No | @#AD_User_ID@ | Cashier for Bank/Cash Account |
C_BankStatementLine_ID |
Search(22) | No | - | Line on a statement from this Bank |
C_BankTransfer_ID |
Search(22) | No | - | Bank Transfer |
C_Campaign_ID |
Table Direct(22) | No | - | Marketing Campaign |
C_Charge_ID |
Table Direct(22) | No | - | Additional document charges |
C_ConversionType_ID |
Table Direct(22) | No | - | Currency Conversion Rate Type |
C_DepositBatch_ID |
Search(10) | No | - | - |
ChargeAmt |
Amount(22) | No | - | Charge Amount |
ConvertedAmt |
Amount(22) | No | - | Converted Amount |
C_Order_ID |
Search(22) | No | - | Order |
C_PaymentProcessor_ID |
Table Direct(10) | No | - | Payment processor for electronic payments |
C_POSTenderType_ID |
Table Direct(10) | No | - | - |
C_Project_ID |
Table Direct(22) | No | - | Financial Project |
C_ShippingRegion_ID |
Table Direct(10) | No | - | Shipping coverage region |
CurrencyRate |
Number(22) | No | - | Currency Conversion Rate |
CustomerAddressID |
String(60) | No | - | - |
CustomerPaymentProfileID |
String(60) | No | - | - |
CustomerProfileID |
String(60) | No | - | - |
DateAcct |
Date(7) | Yes | @#Date@ | Accounting Date |
Description |
String(255) | No | - | Optional short description of the record |
IBAN |
String(40) | No | - | International Bank Account Number |
IsDelayedCapture |
Yes-No(1) | Yes | - | Charge after Shipment |
IsOverrideCurrencyRate |
Yes-No(1) | Yes | N | Override Currency Conversion Rate |
IsOverUnderPayment |
Yes-No(1) | Yes | Y | Over-Payment (unallocated) or Under-Payment (partial payment) |
IsPrepayment |
Yes-No(1) | Yes | - | The Payment/Receipt is a Prepayment |
IsReceipt |
Yes-No(1) | Yes | - | This is a sales transaction (receipt) |
IsSelfService |
Yes-No(1) | Yes | - | This is a Self-Service entry or this entry can be changed via Self-Service |
IsVoided |
Yes-No(1) | Yes | N | - |
OverUnderAmt |
Amount(22) | No | 0 | Over-Payment (unallocated) or Under-Payment (partial payment) Amount |
ProcessedOn |
Number(20) | No | - | The date+time (expressed in decimal format) when the document has been processed |
R_AuthCode_DC |
String(20) | No | - | Authorization Code Delayed Capture returned |
R_CVV2Match |
Yes-No(1) | No | - | Credit Card Verification Code Match |
ReferenceNo |
String(40) | No | - | Your customer or vendor number at the Business Partner's site |
Reversal_ID |
Search(22) | No | - | ID of document reversal |
R_PnRef_DC |
String(20) | No | - | Payment Reference Delayed Capture |
R_VoidMsg |
Text(255) | No | - | - |
ShipDate |
Date(29) | No | - | Shipment Date/Time |
SwiftCode |
String(20) | No | - | Swift Code or BIC |
Swipe |
String(80) | No | - | Track 1 and 2 of the Credit Card |
TaxAmt |
Amount(22) | No | - | Tax Amount for a document |
User1_ID |
Search(22) | No | - | User defined element #1 |
User2_ID |
Search(22) | No | - | User defined element #2 |
WriteOffAmt |
Amount(22) | No | 0 | Amount to write-off |
DocumentNo |
String(30) | Yes | - | Document sequence number of the document |
DateTrx |
Date(7) | Yes | @#Date@ | Transaction Date |
PayAmt |
Amount(22) | Yes | 0 | Amount being paid |
A_Name |
String(60) | No | - | Name on Credit Card or Account holder |
AccountNo |
String(20) | No | - | Account Number |
A_City |
String(60) | No | - | City or the Credit Card or Account Holder |
AD_Client_ID |
Table Direct(22) | Yes | @#AD_Client_ID@ | Tenant for this installation. |
AD_Org_ID |
Table Direct(22) | Yes | @#AD_Org_ID@ | Organizational entity within tenant |
A_EMail |
String(60) | No | - | Email Address |
A_Ident_DL |
String(20) | No | - | Payment Identification - Driver License |
A_Ident_SSN |
String(20) | No | - | Payment Identification - Social Security No |
A_State |
String(40) | No | - | State of the Credit Card or Account holder |
A_Street |
String(60) | No | - | Street address of the Credit Card or Account holder |
A_Zip |
String(20) | No | - | Zip Code of the Credit Card or Account Holder |
C_BankAccount_ID |
Table Direct(22) | No | - | Account at the Bank |
C_BPartner_ID |
Search(22) | Yes | - | Identifies a Business Partner |
C_BP_BankAccount_ID |
Table Direct(22) | No | - | Bank Account of the Business Partner |
C_CashBook_ID |
Table Direct(10) | No | - | Cash Book for recording petty cash transactions |
C_Currency_ID |
Table Direct(22) | Yes | - | The Currency for this record |
C_DocType_ID |
Table Direct(22) | Yes | - | Document type or rules |
CheckNo |
String(20) | No | - | Check Number |
C_Invoice_ID |
Search(22) | No | - | Invoice Identifier |
C_PaymentBatch_ID |
Search(22) | No | - | Payment batch for EFT |
C_Payment_ID |
ID(22) | Yes | - | Payment identifier |
C_Payment_UU |
String(36) | No | - | - |
Created |
Date+Time(7) | Yes | SYSDATE | Date this record was created |
CreatedBy |
Search(22) | Yes | - | User who created this records |
CreditCardExpMM |
Integer(22) | No | 1 | Expiry Month |
CreditCardExpYY |
Integer(22) | No | 03 | Expiry Year |
CreditCardNumber |
String(20) | No | - | Credit Card Number |
CreditCardType |
List(1) | No | - | Credit Card (Visa, MC, AmEx) |
CreditCardVV |
String(4) | No | - | Credit Card Verification code on credit card |
DiscountAmt |
Amount(22) | No | 0 | Calculated amount of discount |
DocAction |
Button(2) | Yes | CO | The targeted status of the document |
DocStatus |
List(2) | Yes | DR | The current status of the document |
IsActive |
Yes-No(1) | Yes | Y | The record is active in the system |
IsAllocated |
Yes-No(1) | Yes | - | Indicates if the payment has been allocated |
IsApproved |
Yes-No(1) | Yes | N | Indicates if this document requires approval |
IsOnline |
Yes-No(1) | Yes | - | Can be accessed online |
IsReconciled |
Yes-No(1) | Yes | - | Payment is reconciled with bank statement |
Micr |
String(20) | No | - | Combination of routing no, account and check no |
OProcessing |
Button(1) | No | - | This payment can be processed online |
Orig_TrxID |
String(20) | No | - | Original Transaction ID |
PONum |
String(60) | No | - | Purchase Order Number |
Posted |
Button(1) | Yes | N | Posting status |
Processed |
Yes-No(1) | Yes | - | The document has been processed |
Processing |
Button(1) | No | - | - |
R_AuthCode |
String(20) | No | - | Authorization Code returned |
R_AvsAddr |
List(1) | No | - | This address has been verified |
R_AvsZip |
List(1) | No | - | The Zip Code has been verified |
Ref_Payment_ID |
Search(10) | No | - | - |
R_Info |
String(2000) | No | - | Response info |
RoutingNo |
String(20) | No | - | Bank Routing Number |
R_PnRef |
String(60) | No | - | Payment reference |
R_RespMsg |
String(512) | No | - | Response message |
R_Result |
String(20) | No | - | Result of transmission |
TenderType |
List(1) | Yes | K | Method of Payment |
TrxType |
List(1) | Yes | S | Type of credit card transaction |
Updated |
Date+Time(7) | Yes | SYSDATE | Date this record was updated |
UpdatedBy |
Search(22) | Yes | - | User who updated this records |
VoiceAuthCode |
String(20) | No | - | Voice Authorization Code from credit card company |
Foreign Keys
| Column | References | Description |
|---|---|---|
AD_OrgTrx_ID |
AD_OrgTrx.AD_OrgTrx_ID | Performing or initiating organization |
C_Activity_ID |
C_Activity.C_Activity_ID | Business Activity |
Cashier_ID |
Cashier.Cashier_ID | Cashier for Bank/Cash Account |
C_BankStatementLine_ID |
C_BankStatementLine.C_BankStatementLine_ID | Line on a statement from this Bank |
C_BankTransfer_ID |
C_BankTransfer.C_BankTransfer_ID | Bank Transfer |
C_Campaign_ID |
C_Campaign.C_Campaign_ID | Marketing Campaign |
C_Charge_ID |
C_Charge.C_Charge_ID | Additional document charges |
C_ConversionType_ID |
C_ConversionType.C_ConversionType_ID | Currency Conversion Rate Type |
C_DepositBatch_ID |
C_DepositBatch.C_DepositBatch_ID | - |
C_Order_ID |
C_Order.C_Order_ID | Order |
C_PaymentProcessor_ID |
C_PaymentProcessor.C_PaymentProcessor_ID | Payment processor for electronic payments |
C_POSTenderType_ID |
C_POSTenderType.C_POSTenderType_ID | - |
C_Project_ID |
C_Project.C_Project_ID | Financial Project |
C_ShippingRegion_ID |
C_ShippingRegion.C_ShippingRegion_ID | Shipping coverage region |
Reversal_ID |
Reversal.Reversal_ID | ID of document reversal |
User1_ID |
User1.User1_ID | User defined element #1 |
User2_ID |
User2.User2_ID | User defined element #2 |
AD_Client_ID |
AD_Client.AD_Client_ID | Tenant for this installation. |
AD_Org_ID |
AD_Org.AD_Org_ID | Organizational entity within tenant |
C_BankAccount_ID |
C_BankAccount.C_BankAccount_ID | Account at the Bank |
C_BPartner_ID |
C_BPartner.C_BPartner_ID | Identifies a Business Partner |
C_BP_BankAccount_ID |
C_BP_BankAccount.C_BP_BankAccount_ID | Bank Account of the Business Partner |
C_CashBook_ID |
C_CashBook.C_CashBook_ID | Cash Book for recording petty cash transactions |
C_Currency_ID |
C_Currency.C_Currency_ID | The Currency for this record |
C_DocType_ID |
C_DocType.C_DocType_ID | Document type or rules |
C_Invoice_ID |
C_Invoice.C_Invoice_ID | Invoice Identifier |
C_PaymentBatch_ID |
C_PaymentBatch.C_PaymentBatch_ID | Payment batch for EFT |
Ref_Payment_ID |
Ref_Payment.Ref_Payment_ID | - |
Generated on 2026-05-03T15:25:02.915630127Z