41 lines
864 B
Plaintext
41 lines
864 B
Plaintext
insert into evt.bpr(bpr)
|
|
SELECT
|
|
$${
|
|
"gl": {
|
|
"lines": [
|
|
{
|
|
"amount": 2.19,
|
|
"account": "h.food"
|
|
},
|
|
{
|
|
"amount": -2.19,
|
|
"account": "h.dcard"
|
|
}
|
|
],
|
|
"jpath": [
|
|
[
|
|
"{item,0}",
|
|
"{header}"
|
|
],
|
|
[
|
|
"{item,0}",
|
|
"{header}"
|
|
]
|
|
]
|
|
},
|
|
"item": [
|
|
{
|
|
"item": "green olives",
|
|
"amount": 2.19,
|
|
"reason": "food",
|
|
"account": "h.food"
|
|
}
|
|
],
|
|
"header": {
|
|
"entity": "home",
|
|
"module": "MHI",
|
|
"offset": "h.dcard",
|
|
"transaction": "purchase",
|
|
"date": "2018-08-01"
|
|
}
|
|
}$$::jsonb bpr |