customerdeposit
Stores details of customer deposits, which are prepayments made by customers for future goods or services.
Columns
| Name | Type | References | Description |
| account | String | The account associated with the transaction or record. | |
| allowemptycards | Boolean | Indicates whether empty cards are allowed for processing. | |
| authcode | String | The authorization code provided for the transaction. | |
| ccapproved | Boolean | Indicates whether the credit card transaction is approved. | |
| ccavsstreetmatch | String | The address verification service (AVS) street address match status. | |
| ccavszipmatch | String | The AVS ZIP code match status. | |
| ccexpiredate | String | The expiration date of the credit card. | |
| cchold | String | The status of the credit card hold. | |
| ccholdetails | String | Details regarding the credit card hold. | |
| cciavsmatch | String | The result of the credit card issuer AVS check. | |
| ccispurchasecardbin | Boolean | Indicates whether the card is a purchase card (BIN). | |
| ccname | String | The name of the cardholder. | |
| ccnumber | String | The credit card number. | |
| ccprocessoraccount | String | The account number used by the credit card processor. | |
| ccsecuritycode | String | The credit card security code (CSC). | |
| ccsecuritycodematch | String | The result of the CSC match check. | |
| ccstreet | String | The street address associated with the credit card. | |
| cczipcode | String | The ZIP code associated with the credit card. | |
| chargeit | Boolean | Indicates whether the charge was successfully processed. | |
| checknum | String | The check number associated with the transaction. | |
| checknumber | String | The check number used for the payment. | |
| class | String | The class or category associated with the transaction. | |
| cleared | Boolean | Indicates whether the transaction has been cleared. | |
| cleareddate | Date | The date when the transaction was cleared. | |
| createddate | Datetime | The date and time when the transaction or record was created. | |
| creditcard | String | The credit card type used for the transaction. | |
| creditcardprocessor | String | The processor handling the credit card transaction. | |
| currency | String | The currency used in the transaction. | |
| currencyname | String | The name of the currency used in the transaction. | |
| currencysymbol | String | The symbol of the currency used in the transaction. | |
| customer | String | The customer associated with the transaction. | |
| customercode | String | The unique code assigned to the customer. | |
| customform | String | The custom form used for the transaction. | |
| debitcardissueno | String | The debit card issue number. | |
| department | String | The department associated with the transaction. | |
| dynamicdescriptor | String | A dynamic descriptor used for transaction details. | |
| entitynexus | String | The tax nexus related to the entity in the transaction. | |
| exchangerate | Decimal | The exchange rate applied to the transaction. | |
| externalid | String | A unique external identifier for the transaction or record. | |
| handlingmode | String | The mode of handling applied to the transaction. | |
| ignoreavs | Boolean | Indicates whether AVS checks are ignored for the transaction. | |
| ignorecsc | Boolean | Indicates whether card security code (CSC) checks are ignored for the transaction. | |
| inputauthcode | String | The input authorization code provided for the transaction. | |
| inputpnrefnum | String | The input reference number for the transaction. | |
| inputreferencecode | String | The input reference code for the transaction. | |
| isbasecurrency | Boolean | Indicates whether the transaction is conducted in the base currency. | |
| ispurchasecard | String | Indicates whether the transaction is processed with a purchase card. | |
| isrecurringpayment | Boolean | Indicates whether the payment is recurring. | |
| lastmodifieddate | Datetime | The date and time when the transaction or record was last modified. | |
| location | String | The location associated with the transaction. | |
| memo | String | A memo or note associated with the transaction. | |
| nexus | String | The tax nexus information for the transaction. | |
| outputauthcode | String | The output authorization code received after processing. | |
| outputreferencecode | String | The output reference code received after processing. | |
| overridehold | Boolean | Indicates whether the credit hold status has been manually overridden. | |
| overrideholdchecked | Boolean | Indicates whether the override of credit hold has been checked. | |
| payment | String | The payment type used for the transaction. | |
| paymentcardcsc | String | The CSC used in the transaction. | |
| paymenteventdate | Datetime | The date and time when the payment event occurred. | |
| paymenteventholdreason | String | The reason for holding the payment event. | |
| paymenteventpurchasedatasent | String | Indicates whether purchase data was sent for the payment event. | |
| paymenteventresult | String | The result of the payment event, such as success or failure. | |
| paymenteventtype | String | The type of payment event, such as authorization or capture. | |
| paymenteventupdatedby | String | The user or system that updated the payment event. | |
| paymentmethod | String | The method of payment used for the transaction. | |
| paymentoperation | String | The operation type for the payment, such as refund or charge. | |
| paymentoption | String | The payment option chosen for the transaction. | |
| paymentprocessingprofile | String | The profile used for processing the payment. | |
| pnrefnum | String | The reference number associated with the payment transaction. | |
| postingperiod | String | The posting period for the transaction. | |
| salesorder | String | The sales order associated with the transaction. | |
| salesorderrequireddepositdue | String | The required deposit due for the sales order. | |
| softdescriptor | String | The soft descriptor used in the transaction's description. | |
| status | String | The current status of the transaction or payment. | |
| statusRef | String | A reference to the status of the transaction. | |
| subsidiary | String | The subsidiary associated with the transaction. | |
| threedstatuscode | String | The 3D Secure status code for the transaction. | |
| tobeemailed | Boolean | Indicates whether the transaction is marked to be emailed. | |
| trandate | Date | The date when the transaction occurred. | |
| tranid | String | The unique transaction identifier. | |
| undepfunds | String | The funds that have not been deposited for the transaction. | |
| validfrom | String | The date from which the transaction or record is valid. |