Payment
Each row of this table represents a payment.
Columns
Name | Type | Description |
accountid | String | The 'accountid' column for the 'payment' table. |
accountingcode | String | The 'accountingcode' column for the 'payment' table. |
paymentmethodid | String | The 'paymentmethodid' column for the 'payment' table. |
updateddate | Datetime | The 'updateddate' column for the 'payment' table. |
markedforsubmissionon | Datetime | The 'markedforsubmissionon' column for the 'payment' table. |
transferredtoaccounting | String | The 'transferredtoaccounting' column for the 'payment' table. |
appliedcreditbalanceamount | Decimal | The 'appliedcreditbalanceamount' column for the 'payment' table. |
referencedpaymentid | String | The 'referencedpaymentid' column for the 'payment' table. |
softdescriptor | String | The 'softdescriptor' column for the 'payment' table. |
source | String | The 'source' column for the 'payment' table. |
secondpaymentreferenceid | String | The 'secondpaymentreferenceid' column for the 'payment' table. |
gatewayreconciliationreason | String | The 'gatewayreconciliationreason' column for the 'payment' table. |
gatewaystate | String | The 'gatewaystate' column for the 'payment' table. |
createdbyid | String | The 'createdbyid' column for the 'payment' table. |
referenceid | String | The 'referenceid' column for the 'payment' table. |
softdescriptorphone | String | The 'softdescriptorphone' column for the 'payment' table. |
gateway | String | The 'gateway' column for the 'payment' table. |
currency | String | The 'currency' column for the 'payment' table. |
gatewayreconciliationstatus | String | The 'gatewayreconciliationstatus' column for the 'payment' table. |
authtransactionid | String | The 'authtransactionid' column for the 'payment' table. |
bankidentificationnumber | String | The 'bankidentificationnumber' column for the 'payment' table. |
unappliedamount | Decimal | The 'unappliedamount' column for the 'payment' table. |
cancelledon | Datetime | The 'cancelledon' column for the 'payment' table. |
gatewayresponsecode | String | The 'gatewayresponsecode' column for the 'payment' table. |
gatewayresponse | String | The 'gatewayresponse' column for the 'payment' table. |
status | String | The 'status' column for the 'payment' table. |
comment | String | The 'comment' column for the 'payment' table. |
retrynumber_c | String | The 'retrynumber__c' column for the 'payment' table. |
submittedon | Datetime | The 'submittedon' column for the 'payment' table. |
gatewayorderid | String | The 'gatewayorderid' column for the 'payment' table. |
payoutid | String | The 'payoutid' column for the 'payment' table. |
updatedbyid | String | The 'updatedbyid' column for the 'payment' table. |
amount | Decimal | The 'amount' column for the 'payment' table. |
appliedamount | Decimal | The 'appliedamount' column for the 'payment' table. |
sourcename | String | The 'sourcename' column for the 'payment' table. |
refundamount | Decimal | The 'refundamount' column for the 'payment' table. |
type | String | The 'type' column for the 'payment' table. |
paymentmethodsnapshotid | String | The 'paymentmethodsnapshotid' column for the 'payment' table. |
settledon | Datetime | The 'settledon' column for the 'payment' table. |
createddate | Datetime | The 'createddate' column for the 'payment' table. |
id | String | The 'id' column for the 'payment' table. |
paymentnumber | String | The 'paymentnumber' column for the 'payment' table. |
effectivedate | Date | The 'effectivedate' column for the 'payment' table. |
retrystatus_c | String | The 'retrystatus__c' column for the 'payment' table. |