---
# System prepended metadata

title: Billing new collections

---

# Billing new collections

#### billingFeatures


| Field | Type  | Description |
| -- | ----- | -- |
| billingFeatureId | Integer | Autoincrement |
| name | String | Billing feature name (old name - description) |
| code | String | Feature code |
| unit | String | Unit |

#### billingPlans


| Field | Type  | Description |
| -- | ----- | -- |
| billingPlanId | Integer | Autoincrement |
| name | String | Plan name |
| parentPlanId | Integer | billingPlanId of parrent plan. For parrent plans = null |
| scope | Object | determines where CRUD operations on plan are allowed |
| - typeId | String | enum: "organization", "project", "workspace" |
| - id | Integer | Id of organization, project or workspace |
| - expirationDate | Date | Date till scope is valid |
| assignments | Object | determines where billing plan can be assigned |
| - typeId | String | enum: "organization", "project", "workspace" |
| - id | Integer | Id of organization, project or workspace |
| description | String | Description of plan |
| order | Integer | Sort order of plan in UI |
| billingFeatures | Array[{<br>&nbsp; billingFeatureId: Int,<br>&nbsp; includedCount: Int,<br>&nbsp; price: Float,<br>&nbsp; isBilledInAdvance: Boolean,<br>&nbsp;isHardlimit: Boolean<br>}] | billingFeatures, provided by plan | 

#### workspaceBillingPlans
| Field | Type  | Description |
| -- | ----- | -- |
| workspaceBillingPlanId | Integer | Autoincrement |
| workspaceId | Integer |  |
| billingPlanId | Integer |  |
| billingDayOfMonth | Integer | Day of payment process |
| billingDateStart | Date | Date when billingPlan starts |
| billingDateEnd | Date | Date when billingPlan ends |

#### billingStatements
| Field | Type  | Description |
| -- | ----- | -- |
| billingStatementId | Integer | Autoincrement |
| assignment | Object |  |
| - typeId | String | enum: "organization", "project", "workspace" |
| - id | Integer | Id of organization, project or workspace |
| startDate | Date | Date when invoice starts |
| endDate | Date | Date when invoice ends |
| beginningBalance | Float |  |
| currentBalance | Float | |
| endingBalance | Float | |
| status | String | **current**- this is the current month and billing has not processed <br>**processing** - in billing process loop <br>**closed**- billing has completed<br>**null** - has not opened (future statement)|
| ledger | Object | |
| - debits | Array[{<br>&nbsp; billingFeatureId: Int,<br>&nbsp; billingPlanId: Int,<br>&nbsp; includedQuantity: Int,<br>&nbsp; usedQuantity: Int,<br>&nbsp; billedQuantity: Int,<br>&nbsp; amountPerItem: Float,<br>&nbsp; totalAmount: Float,<br>&nbsp; date: Date<br>}] | |
| - credits | Array[{<br>&nbsp; paymentTypeId: Int,<br>&nbsp; billingTransactionId: Int,<br>&nbsp; paymentDisplayName: String, <br>&nbsp; amount: Float,<br>&nbsp; date: Date<br>}] | |

#### billingInvoiceFeatureUtilizations


| Field | Type  | Description |
| -- | ----- | -- |
| billingInvoiceFeatureUtilizationsId | Integer | Autoincrement |
| billingInvoiceId | Number |  |
| billingPlanId | Number | |
| billingFeatureId | Number |  |
| isHardLimit | Boolean | |
| includedQuantity | Number |  |
| usedQuantity | Number | |
| maxUsedQuantity | Number |  |

#### billingTransactions


| Field | Type  | Description |
| -- | ----- | -- |
| billingTransactionId | Integer | Autoincrement |
| billingStatementId | Number |  |
| billingPaymentProcessorId | Number | |
| date | Date |  |
| amount | Float | |
| status | Number | enum: 0 - pending, 1 - payed, 2 - failed  |
| billingPaymentTransactionId | Number | link to {processor}\_transactions|
| assignment | Object |  |
| - typeId | String | enum: "organization", "project", "workspace" |
| - id | Integer | Id of organization, project or workspace |


#### stripe_Transactions


| Field | Type  | Description |
| -- | ----- | -- |
| stripeTransactionId | Integer | Autoincrement |
| stripePaymentId | String | id of payment in stripe system |
| cardId | String | Card id in stripe system |
| stripeCustomerId | String | id of stripe customer|
| date | Date |  |
| amount | Float | |
| status | Number | enum: 0 - pending, 1 - payed, 2 - failed  |


#### stripe_Customers


| Field | Type  | Description |
| -- | ----- | -- |
| stripe_CustomerId | Integer | Autoincrement |
| stripeCustomerId | String |  |
| assignment | Object |  |
| - typeId | String | enum: "organization", "project", "workspace" |
| - id | Integer | Id of organization, project or workspace |

#### billingCreditTransactions


| Field | Type  | Description |
| -- | ----- | -- |
| billingCreditId | Integer | Autoincrement |
| date | Date |  |
| amount | Float | |
| assignment | Object |  |
| - typeId | String | enum: "organization", "project", "workspace" |
| - id | Integer | Id of organization, project or workspace |


#### billingPaymentProcessors


| Field | Type  | Description |
| -- | ----- | -- |
| billingPaymentProcessors | Integer | Autoincrement |
| name | String |  |


