customerpayment
The customerpayment table.
Columns
| Name | Type | References | Description |
| account | String | Account | |
| allowemptycards | Boolean | Allowemptycards | |
| applied | Decimal | Applied | |
| aracct | String | Aracct | |
| authcode | String | Authcode | |
| autoapply | Boolean | Autoapply | |
| balance | Decimal | Balance | |
| ccapproved | Boolean | Ccapproved | |
| ccavsstreetmatch | String | Ccavsstreetmatch | |
| ccavszipmatch | String | Ccavszipmatch | |
| ccexpiredate | String | Ccexpiredate | |
| cchold | String | Cchold | |
| ccholdetails | String | Ccholdetails | |
| cciavsmatch | String | Cciavsmatch | |
| ccispurchasecardbin | Boolean | Ccispurchasecardbin | |
| ccname | String | Ccname | |
| ccnumber | String | Ccnumber | |
| ccprocessoraccount | String | Ccprocessoraccount | |
| ccsecuritycode | String | Ccsecuritycode | |
| ccsecuritycodematch | String | Ccsecuritycodematch | |
| ccstreet | String | Ccstreet | |
| cczipcode | String | Cczipcode | |
| chargeit | Boolean | Chargeit | |
| checknum | String | Checknum | |
| checknumber | String | Checknumber | |
| class | String | Class | |
| cleared | Boolean | Cleared | |
| cleareddate | Date | Cleareddate | |
| consolidatebalance | Decimal | Consolidatebalance | |
| createddate | Datetime | Createddate | |
| creditcard | String | Creditcard | |
| creditcardprocessor | String | Creditcardprocessor | |
| currency | String | Currency | |
| currencyname | String | Currencyname | |
| currencysymbol | String | Currencysymbol | |
| customer | String | Customer | |
| customercode | String | Customercode | |
| customform | String | Customform | |
| debitcardissueno | String | Debitcardissueno | |
| department | String | Department | |
| dynamicdescriptor | String | Dynamicdescriptor | |
| entitynexus | String | Entitynexus | |
| exchangerate | Decimal | Exchangerate | |
| externalid | String | Externalid | |
| handlingmode | String | Handlingmode | |
| ignoreavs | Boolean | Ignoreavs | |
| ignorecsc | Boolean | Ignorecsc | |
| inputauthcode | String | Inputauthcode | |
| inputpnrefnum | String | Inputpnrefnum | |
| inputreferencecode | String | Inputreferencecode | |
| isbasecurrency | Boolean | Isbasecurrency | |
| ispurchasecard | String | Ispurchasecard | |
| isrecurringpayment | Boolean | Isrecurringpayment | |
| lastmodifieddate | Datetime | Lastmodifieddate | |
| location | String | Location | |
| memo | String | Memo | |
| nexus | String | Nexus | |
| outputauthcode | String | Outputauthcode | |
| outputreferencecode | String | Outputreferencecode | |
| overridehold | Boolean | Overridehold | |
| overrideholdchecked | Boolean | Overrideholdchecked | |
| payment | String | Payment | |
| paymentcardcsc | String | Paymentcardcsc | |
| paymenteventdate | Datetime | Paymenteventdate | |
| paymenteventholdreason | String | Paymenteventholdreason | |
| paymenteventpurchasedatasent | String | Paymenteventpurchasedatasent | |
| paymenteventresult | String | Paymenteventresult | |
| paymenteventtype | String | Paymenteventtype | |
| paymenteventupdatedby | String | Paymenteventupdatedby | |
| paymentmethod | String | Paymentmethod | |
| paymentoperation | String | Paymentoperation | |
| paymentoption | String | Paymentoption | |
| paymentprocessingprofile | String | Paymentprocessingprofile | |
| pending | Decimal | Pending | |
| pnrefnum | String | Pnrefnum | |
| postingperiod | String | Postingperiod | |
| softdescriptor | String | Softdescriptor | |
| status | String | Status | |
| statusref | String | Statusref | |
| subsidiary | String | Subsidiary | |
| threedstatuscode | String | Threedstatuscode | |
| tobeemailed | Boolean | Tobeemailed | |
| total | Decimal | Total | |
| trandate | Date | Trandate | |
| tranid | String | Tranid | |
| unapplied | Decimal | Unapplied | |
| undepfunds | String | Undepfunds | |
| validfrom | String | Validfrom |