Expression Exercise Sample Data
The source image for the working example is here:
The AI response for a basic invoice will resemble the following output from the attached invoice sample.
CODE
{
"tables": [
{
"table": {
"tab_index": 0,
"rows": [
{
"row_index": 1,
"columns": [
{
"col_index": 1,
"value": "Invoice Number"
},
{
"col_index": 2,
"value": "159692155"
}
]
},
{
"row_index": 2,
"columns": [
{
"col_index": 1,
"value": "Customer Number"
},
{
"col_index": 2,
"value": "C8675309"
}
]
},
{
"row_index": 3,
"columns": [
{
"col_index": 1,
"value": "Invoice Date"
},
{
"col_index": 2,
"value": "02/11/2024"
}
]
},
{
"row_index": 4,
"columns": [
{
"col_index": 1,
"value": "Due Date"
},
{
"col_index": 2,
"value": "03/11/2024"
}
]
},
{
"row_index": 5,
"columns": [
{
"col_index": 1,
"value": "Customer Reference"
},
{
"col_index": 2,
"value": "S082001181"
}
]
},
{
"row_index": 6,
"columns": [
{
"col_index": 1,
"value": "Order Date"
},
{
"col_index": 2,
"value": "02/10/2023"
}
]
},
{
"row_index": 7,
"columns": [
{
"col_index": 1,
"value": "Order Number"
},
{
"col_index": 2,
"value": "S082347938"
}
]
},
{
"row_index": 8,
"columns": [
{
"col_index": 1,
"value": "Order Method"
},
{
"col_index": 2,
"value": "PHONE"
}
]
}
]
}
},
{
"table": {
"tab_index": 1,
"rows": [
{
"row_index": 1,
"columns": [
{
"col_index": 1,
"value": "ITEM NUMBER"
},
{
"col_index": 2,
"value": "DESCRIPTION"
},
{
"col_index": 3,
"value": "QTY"
},
{
"col_index": 4,
"value": "U/M"
},
{
"col_index": 5,
"value": "UNIT PRICE"
},
{
"col_index": 6,
"value": "EXT PRICE"
}
]
},
{
"row_index": 2,
"columns": [
{
"col_index": 1,
"value": "TBB70020PK"
},
{
"col_index": 2,
"value": "BTLE BDY RACK,BK,3 JUGS(TBB80020)"
},
{
"col_index": 3,
"value": "2"
},
{
"col_index": 4,
"value": "PK"
},
{
"col_index": 5,
"value": "35.99"
},
{
"col_index": 6,
"value": "71.98"
}
]
},
{
"row_index": 3,
"columns": [
{
"col_index": 1,
"value": ""
},
{
"col_index": 2,
"value": ""
},
{
"col_index": 3,
"value": ""
},
{
"col_index": 4,
"value": ""
},
{
"col_index": 5,
"value": "SUBTOTAL:"
},
{
"col_index": 6,
"value": "71.98"
}
]
},
{
"row_index": 4,
"columns": [
{
"col_index": 1,
"value": ""
},
{
"col_index": 2,
"value": ""
},
{
"col_index": 3,
"value": "TAX &"
},
{
"col_index": 4,
"value": "BOTTLE"
},
{
"col_index": 5,
"value": "DEPOSITS TOTAL:"
},
{
"col_index": 6,
"value": "0.00"
}
]
},
{
"row_index": 5,
"columns": [
{
"col_index": 1,
"value": ""
},
{
"col_index": 2,
"value": ""
},
{
"col_index": 3,
"value": ""
},
{
"col_index": 4,
"value": ""
},
{
"col_index": 5,
"value": "ORDER TOTAL:"
},
{
"col_index": 6,
"value": "71.98"
}
]
},
{
"row_index": 6,
"columns": [
{
"col_index": 1,
"value": ""
},
{
"col_index": 2,
"value": ""
},
{
"col_index": 3,
"value": ""
},
{
"col_index": 4,
"value": ""
},
{
"col_index": 5,
"value": "Total Due:"
},
{
"col_index": 6,
"value": "71.98"
}
]
}
]
}
},
{
"table": {
"tab_index": 2,
"rows": [
{
"row_index": 1,
"columns": [
{
"col_index": 1,
"value": "Remittance Section"
},
{
"col_index": 2,
"value": ""
}
]
},
{
"row_index": 2,
"columns": [
{
"col_index": 1,
"value": "Customer Number"
},
{
"col_index": 2,
"value": "C8675309"
}
]
},
{
"row_index": 3,
"columns": [
{
"col_index": 1,
"value": "Invoice Number"
},
{
"col_index": 2,
"value": "159692155"
}
]
},
{
"row_index": 4,
"columns": [
{
"col_index": 1,
"value": "Invoice Date"
},
{
"col_index": 2,
"value": "02/11/2024"
}
]
},
{
"row_index": 5,
"columns": [
{
"col_index": 1,
"value": "Terms"
},
{
"col_index": 2,
"value": "Net 30"
}
]
},
{
"row_index": 6,
"columns": [
{
"col_index": 1,
"value": "Total Due"
},
{
"col_index": 2,
"value": "71.98"
}
]
}
]
}
}
],
"header_footer": [
{
"key": "Your Registration Code:",
"value": ""
},
{
"key": "Important",
"value": ""
},
{
"key": "UNIT PRICE",
"value": "35.99"
},
{
"key": "Attn:",
"value": ""
},
{
"key": "Attn:",
"value": "Rick Astley"
},
{
"key": "PO BOX",
"value": "981101"
},
{
"key": "QTY",
"value": "2"
},
{
"key": "U/M",
"value": "PK"
},
{
"key": "EXT PRICE",
"value": "71.98"
},
{
"key": "(Page",
"value": "1)"
},
{
"key": "W.B. Mason Federal ID #:",
"value": "04-2455641"
},
{
"key": "ITEM NUMBER",
"value": "TBB70020PK"
},
{
"key": "DESCRIPTION",
"value": "BTLE BDY RACK,BK,3 JUGS(TBB80020)"
},
{
"key": "Amount Enclosed",
"value": ""
},
{
"key": "Attn",
"value": "Astley"
},
{
"key": "Invoice Date",
"value": "02/11/2024"
},
{
"key": "Terms",
"value": "Net 30"
},
{
"key": "Invoice Number",
"value": "159692155"
},
{
"key": "Total Due:",
"value": "71.98"
},
{
"key": "Registration is quick and easy at",
"value": "www.wbmason.com/paperless"
},
{
"key": "Invoice Date",
"value": "02/11/2024"
},
{
"key": "Due Date",
"value": "03/11/2024"
},
{
"key": "Order Method",
"value": "PHONE"
},
{
"key": "Total Due",
"value": "71.98"
},
{
"key": "Invoice Number",
"value": "159692155"
},
{
"key": "Address Service Requested",
"value": "888-WB-MASON www.wbmason.com"
},
{
"key": "SUBTOTAL:",
"value": "71.98"
},
{
"key": "Customer Number",
"value": "C8675309"
},
{
"key": "TAX & BOTTLE DEPOSITS TOTAL:",
"value": "0.00"
},
{
"key": "Delivery Address",
"value": "Square 9 Softworks Rick Astley 127 Church Street New Haven, CT 06510"
},
{
"key": "Customer Reference",
"value": "S082001181"
},
{
"key": "ORDER TOTAL:",
"value": "71.98"
},
{
"key": "Order Number",
"value": "S082347938"
},
{
"key": "Customer Number",
"value": "C8675309"
},
{
"key": "Order Date",
"value": "02/10/2023"
},
{
"key": "credit card on",
"value": "wbmason.com"
},
{
"key": "Square 9",
"value": "Softworks, Inc."
},
{
"key": "Sign up for Paperless Invoicing at wbmason.com/paperless.",
"value": "5637376144"
},
{
"key": "W.B.",
"value": "MASON CO., INC."
}
]
}