...
| Code Block | ||
|---|---|---|
| ||
{"Invoices":[
{
"WorkRequestID":11603508,
"BuildingName":"ElliotMain Hall",
"ThirdPartySystem_BuildingID":"6",
"JobCode":"ELLIOT2300207",
"InvoiceStatus":"Approved for Processing",
"ContractorName":"Triangle Fire Protection LtdContractor ABC",
"ThirdPartySystem_ContractorID":"",
"invoiceamount":1539.20,
"InvoiceTax":230.88,
"InvoiceTotal":1770.08,
"InvoiceDate":"2023-10-31T00:00:00",
"InvoiceNumber":"73596",
"InvoiceDescription":"MAIN BLOCK/ELLIOTHALL",
"InvoiceImageURL":"https://mybuildings.blob.core.windows.net/storage/Core/SiteDownloadFiles/719/ContractorInvoices/2023/11/951e84fad3644b4bb5d8url_location/invoice123.pdf",
"DateUploaded":"2023-11-06T03:27:00",
"AccountCodeBreakdown":[
{
"AccountNumber":"2810-10-5300",
"Percentage":100.0,
"Amount":1539.20,
"TaxAmount":230.88,
"TotalIncludingTax":1770.08
}
]
},
{"WorkRequestID":11567457,
"BuildingName":"Elizabeth MacFarlanAdministration Centre",
"ThirdPartySystem_BuildingID":"21",
"JobCode":"EMC2300186",
"InvoiceStatus":"Approved for Processing",
"ContractorName":"AdvantageContractor Door Services”XYZ”,
"ThirdPartySystem_ContractorID":"",
"invoiceamount":596.70,
"InvoiceTax":89.50,
"InvoiceTotal":686.20,
"InvoiceDate":"2023-10-31T00:00:00",
"InvoiceNumber":"135022",
"InvoiceDescription":"Door is constantly opening and closing a",
"InvoiceImageURL":"https://mybuildings.blob.core.windows.net/storage/Core/SiteDownloadFiles/719/ContractorInvoices/2023/11/9df18f247d934c539525url_location/invoice124.pdf",
"DateUploaded":"2023-11-09T01:33:00",
"AccountCodeBreakdown":[
{
"AccountNumber":"2040-10-5105",
"Percentage":100.0,
"Amount":596.70,
"TaxAmount":89.50,
"TotalIncludingTax":686.20
}
]
}
]
},"RecordsReturned":"2"}'; |
...
Fields for Creditor Invoice Details
Field Name | SQL Data Type | Mandatory | Description |
ContractorName | VARCHAR (100) | N | Creditor PayeeName |
ThirdPartySystem_ContractorID | INTEGER | Y | Synergetic Creditor ID |
InvoiceAmount | MONEY | Y | Invoice Amount (Excl. Tax) |
InvoiceTax | MONEY | Y | Invoice Tax Amount |
InvoiceDate | DATETIME | Y | Invoice Date |
InvoiceNumber | VARCHAR (15) | Y | Invoice Number |
InvoiceDescription | VARCHAR (100) | Y | Description for this Invoice |
...