OtherReceipts
Tracks receipts outside standard invoices, capturing creation dates, payment details, and metadata for financial reconciliation.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | The unique identifier for the other receipts record. |
| Whencreated | Datetime | The date and time when the other receipt record was created. |
| Recordtype | String | The type classification of the other receipt record. |
| Description2 | String | An additional description for the other receipt record. |
| Whenpaid | Datetime | The date and time when the other receipt was paid. |
| Paymethod | String | The method of payment used for the other receipt. |
| Docnumber | String | The document number associated with the other receipt. |
| Description | String | A brief description of the other receipt. |
| Bankaccountid | String | The identifier of the bank account associated with the other receipt. |
| Bankaccountname | String | The name of the bank account associated with the other receipt. |
| Bankaccountcurr | String | The currency of the bank account associated with the other receipt. |
| Depositdate | Datetime | The date when the other receipt was deposited. |
| Prbatchkey | Int64 | The batch key associated with the other receipt processing. |
| Basecurr | String | The base currency for the other receipt transaction. |
| Currency | String | The transaction currency used for the other receipt. |
| Exch_rate_date | Datetime | The date for the applicable exchange rate for the other receipt. |
| Exch_rate_type_id | String | The identifier for the exchange rate type applied to the other receipt. |
| Exchange_rate | Double | The exchange rate applied to the other receipt transaction. |
| Totalentered | Double | The total amount entered for the other receipt. |
| Trx_totalentered | Double | The total amount entered in transaction currency for the other receipt. |
| Recon_date | Datetime | The reconciliation date for the other receipt. |
| State | String | The current state of the other receipt (e.g., processed, pending). |
| Rawstate | String | The raw state code representing the other receipt status. |
| Cleared | String | Indicates whether the other receipt has been cleared (Yes/No). |
| Parentpayment | Int64 | The identifier for the parent payment associated with the other receipt. |
| Impliedlocation | Int64 | The implied location key associated with the other receipt. |
| Auwhencreated | Datetime | The date and time when the audit entry for the other receipt was created. |
| Whenmodified | Datetime | The date and time when the other receipt was last modified. |
| Createdby | Int64 | The identifier of the user who created the other receipt record. |
| Modifiedby | Int64 | The identifier of the user who last modified the other receipt record. |
| Megaentitykey | Int64 | The key for the mega-entity associated with the other receipt. |
| Megaentityid | String | The identifier of the mega-entity associated with the other receipt. |
| Megaentityname | String | The name of the mega-entity associated with the other receipt. |
| Record_url | String | The URL link to view the other receipt record. |