importedemployeeexpense
Contains details of employee expenses that have been imported into the system for reconciliation and processing.
Columns
| Name | Type | References | Description |
| billedamount | Decimal | The total amount billed for the expense, representing the full charge amount as it appears in the financial records, including any applicable taxes, discounts, and fees. | |
| billedcurrency | String | The currency in which the billed amount is denominated, indicating the type of currency used for the transaction, such as USD, EUR, or GBP. | |
| billedtaxamount | Decimal | The total amount of tax applied to the billed amount, representing any applicable taxes on the transaction, including value added tax (VAT) and sales tax. | |
| cardcurrency | String | The currency used by the corporate card during the transaction often different from the billed currency and is important for accurately converting the transaction values. | |
| cardmemberembossedname | String | The name of the cardholder is used for identification purposes and ensures that the correct cardholder is associated with the transaction. | |
| category | String | The category or classification of the expense, corresponding to internal classifications such as 'Travel,' 'Meals,' or 'Supplies,' for reporting and analysis purposes. | |
| chargedate | Date | The date on which the charge occurred is important for tracking the timing of charges within financial reporting periods. | |
| corporatecard | Boolean | Indicates whether the expense was paid using a corporate credit card, distinguishing between personal and business expenses for card-related transactions. | |
| costcenter | String | The department or cost center that is associated with the transaction is used to allocate expenses accurately within the organization, ensuring correct budgeting and reporting. | |
| currencyexchangerate | Decimal | The exchange rate used to convert the transaction amount from the card's currency to the billed currency, converting multi-currency transactions into the company's base currency. | |
| customform | String | The identifier of the custom form used to capture the transaction details, linking the transaction to a specific custom form template. | |
| employee | String | The name or identifier of the employee who made the expense is used to track employee-specific charges, expense reporting, and reimbursement management. | |
| externalid | String | A unique external identifier assigned to the transaction often used to associate the transaction with an external system or reference number. | |
| formatprofile | String | The profile specifies the format for transaction data, including a predefined template or rules for displaying or processing transactions within the system. | |
| id | Integer | The unique identifier assigned to the transaction record is used for reference and retrieval of the specific record and ensures that each transaction can be tracked individually. | |
| internalid | Integer | The internal system ID for the transaction. It ensures that the transaction is associated with the correct records. | |
| localchargeamount | Decimal | The amount charged in the local currency, reporting and financial analysis in cases where the transaction occurred in a different currency from the company's base currency. | |
| localtaxamount | Decimal | The amount of tax charged in the local currency, ensuring that tax amounts are accurately captured and converted for reconciliation purposes. | |
| memo | String | A brief note or description related to the transaction, providing additional context for the expense, such as any other relevant details for review or approval. | |
| sourcetype | String | The source or origin of the transaction, categorizing transactions for further analysis and reporting. | |
| status | String | The current status of the expense transaction, representing whether the transaction is pending, approved, rejected, or paid. | |
| transactionid | String | A unique identifier assigned to the transaction in the financial system is important for tracking, auditing, and reconciling financial records. |