charge
Contains information about charges, including transaction details, amounts, and applicable fees for customer transactions.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | The unique internal identifier for the billing record. | |
| amount | Decimal | The total amount of the charge or billing entry. | |
| billdate | Date | The date when the bill was issued. | |
| billingitem | String | The specific item being billed. | |
| billingmode | String | The method used for billing, such as one-time or recurring. | |
| billingschedule | String | The schedule for billing, such as monthly, quarterly, or annual. | |
| billto | String | The customer or project being billed. | |
| chargedate | Date | The date the charge was applied. | |
| chargetype | String | The type of charge, such as fixed or variable. | |
| class | String | The classification associated with the billing record. | |
| createddate | Date | The date when the billing record was created. | |
| creditmemo | String | The credit memo associated with the transaction. | |
| creditmemoline | String | The specific item line of the credit memo. | |
| currency | String | The currency used for the billing transaction. | |
| department | String | The department associated with the billing record. | |
| description | String | A description of the charge or billing item. | |
| externalid | String | A unique external identifier for referencing the billing record in external systems. | |
| grouporder | Integer | The order of the charge group within the billing process. | |
| invoice | String | The invoice number associated with the billing record. | |
| invoiceline | String | The item line on the invoice. | |
| invoiceln | String | The specific line on the invoice detailing a charge. | |
| location | String | The location associated with the billing record. | |
| memo | String | A memo or note related to the billing record. | |
| projecttask | String | The specific task or activity within the project being billed. | |
| quantity | Double | The quantity of the item or service being billed. | |
| rate | String | The rate applied to the billing item, such as per hour or per unit. | |
| rule | String | The rule applied to determine the charge, such as usage or flat rate. | |
| runid | String | The unique identifier for the billing run process. | |
| salesorder | String | The sales order associated with the billing record. | |
| salesorderline | String | The specific line item on the sales order related to the billing. | |
| serviceenddate | Date | The date when the service associated with the charge ends. | |
| servicestartdate | Date | The date when the service associated with the charge begins. | |
| stage | String | The stage or phase of the transaction or billing process. | |
| subsidiary | String | The subsidiary associated with the billing record. | |
| timerecord | String | The time entry associated with the billing record. | |
| transaction | String | The transaction identifier associated with the billing record. | |
| transactionline | String | The specific transaction line related to the charge. | |
| use | String | The use or purpose for which the charge is applied. |