Family Invoice

Data Model

Field Type Index Description
entityId string PK Primary Key, Entity Identifier
refEntityType string FK wks_family,
refDatasourceCode string FK cc-family,
refEntityId string FK family related entity Id
external_billing_account string External Billing Account Id
subject string Subject
description string Description
post_date datetime Post Date
due_date datetime Due Date
paid_date datetime Paid Date
from_email string From Email
from_name string From Name
to_email string To Email
to_name string To Name
amount decimal Amount
status string Status
stripe_customer string Stripe Customer Id
stripe_invoice string Stripe Invoice Id
data object Data
items list Items object list
metadata object Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format.

Item Model

Example

{
        "entityId": "12345",
        "external_billing_account": "account123",
        "subject": "Invoice Subject",
        "description": "Description of the invoice",
        "post_date": "2023-01-01T00:00:00",
        "due_date": "2023-01-31T00:00:00",
        "paid_date": "2023-02-01T00:00:00",
        "from_email": "sender@example.com",
        "from_name": "Sender Name",
        "to_email": "recipient@example.com",
        "to_name": "Recipient Name",
        "amount": 150.00,
        "status": "Pending",
        "stripe_customer": "cust_123456789",
        "stripe_invoice": "inv_123456789",
        "data": {
            "additionalField1": "value1",
            "additionalField2": "value2"
        },
        "items": [
            {
                "itemCode": "item1",
                "quantity": 1,
                "price": 100.00
            },
            {
                "itemCode": "item2",
                "quantity": 2,
                "price": 25.00
            }
        ],
        "metadata": {
            "metaField1": "metaValue1",
            "metaField2": "metaValue2"
        }
}