expensereport
Tracks employee expense reports, used for submission, approval, and reimbursement of employee-incurred expenses.
Columns
| Name | Type | References | Description |
| account | String | The account associated with the record, typically used to track financial transactions or categories. | |
| accountingapproval | Boolean | Indicates whether the transaction has been approved by the accounting department, used to track the approval status. | |
| acctcorpcardexp | String | The corporate card expense associated with the account, used to track expenses charged to corporate credit cards. | |
| advance | Decimal | The advance payment made, typically used to track payments made in advance of receiving goods or services. | |
| amount | Decimal | The monetary amount associated with the transaction or record, typically representing the value of a payment or charge. | |
| approvalstatus | String | The status of the approval process, such as 'Pending', 'Approved', or 'Rejected', used to track the progress of approval. | |
| class | String | The classification associated with the record, used to categorize or group related transactions for reporting purposes. | |
| complete | Boolean | Indicates whether the record or transaction is complete, typically used to track whether the process or task has been finished. | |
| createddate | Datetime | The date and time when the record was created, used for tracking the history of the record. | |
| customform | String | The custom form used to manage or process the record, typically tailored to specific business needs or data entry requirements. | |
| department | String | The department associated with the record, used for classification and reporting within an organization. | |
| duedate | Date | The date by which the payment or task is due, used for tracking deadlines or payment schedules. | |
| entity | String | The entity associated with the record, such as a customer, supplier, or employee, used for linking transactions to specific entities. | |
| entitynexus | String | The nexus (tax jurisdiction) associated with the entity, used to determine tax liability based on geographic location. | |
| expensereportcurrency | String | The currency used for the expense report, typically used in multi-currency transactions for conversion and reporting. | |
| expensereportexchangerate | Decimal | The exchange rate used to convert the expense report currency to the base currency, typically used for multi-currency financial reporting. | |
| externalid | String | An external identifier used to link the record with external systems or services, facilitating integration and synchronization. | |
| lastmodifieddate | Datetime | The date and time when the record was last modified, used for tracking updates or changes to the record. | |
| location | String | The location associated with the record, used for tracking the geographical or operational area related to the transaction. | |
| memo | String | Additional notes or comments associated with the record, often used for internal communication or explanations. | |
| nextapprover | String | The individual or role responsible for the next level of approval in the process, used to track the approval workflow. | |
| nexus | String | The tax jurisdiction associated with the record, used for determining tax obligations based on location. | |
| policyviolated | Boolean | Indicates whether the transaction or record violates any policies, typically used to track compliance with internal rules. | |
| postingperiod | String | The accounting period during which the transaction is posted, typically used for financial reporting and period-end closings. | |
| status | String | The current status of the record, such as 'Pending', 'Approved', or 'Rejected', used to track the stage of processing or approval. | |
| statusRef | String | A reference code or identifier for the status, used for internal tracking or cross-referencing purposes. | |
| subsidiary | String | The subsidiary associated with the record, used for tracking financial activity and reporting within a larger corporate structure. | |
| subsidiarytaxregnum | String | The tax registration number for the subsidiary, used for tax compliance and reporting purposes. | |
| supervisorapproval | Boolean | Indicates whether the transaction has been approved by the supervisor, used to track the approval workflow. | |
| taxdetailsoverride | Boolean | Indicates whether tax details have been overridden, typically used for exceptions or adjustments to tax calculations. | |
| taxpointdate | Date | The date when tax recognition occurs, typically used to determine when tax liability is triggered for the transaction. | |
| taxpointdateoverride | Boolean | Indicates whether the tax point date has been overridden, used for special cases or adjustments in tax accounting. | |
| total | Decimal | The total amount for the transaction or record, typically representing the sum of all charges, taxes, and adjustments. | |
| trandate | Date | The date of the transaction, used for financial and accounting tracking purposes. | |
| tranid | String | The unique identifier for the transaction, often used for reference or cross-referencing in accounting systems. | |
| usemulticurrency | Boolean | Indicates whether the transaction involves multiple currencies, typically used for global operations or cross-border transactions. |