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"
        }
}