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