Draft
Returns the purchase and sales orders
Method used: GET
Sales Order: /api/gfin/v1/Sales
Purchase Order: /api/gfin/v1/Purchases
Body parameters:
Attribute | Type | Description | Default |
---|---|---|---|
page | numeric | (optional) | 1 |
pagesize | numeric | (optional) | 10 |
order | character | (mandatory) | - |
filter | character | (optional) | oData pattern |
allfields | logical | (optional) | false |
fields | character | (optional, separated by comma) | - |
Example:
/api/gfin/v1/Purchases?filter=c7_filial eq 'D MG 01' and c7_num eq '000001' and |
/api/gfin/v1/Sales?filter=c6_filial eq 'D MG 01' and c6_num eq '000001' and c6_item |
It is worth noting that if, in the API call, allfields is true, it will list all fields in the combination of SC6, F76 - Sales. Sending fields in the fields parameter will bring the specified fields plus the default fields.
Json Object - Default
Attribute | Type | Description |
---|---|---|
F76_DATA | date | Date of balance |
F76_VALOR | numeric | Value |
F76_MOEDA | numeric | Order currency |
F76_TXMOED | numeric | Currency rate |
C6_FILIAL | character | System Branch |
C6_NUM | character | Order Number |
C6_ITEM | character | Item number in the order |
C6_PRODUTO | character | Product Code |
C6_VALOR | numeric | Total Item Value |
C6_CLI | character | Customer Code |
C6_LOJA | character | Customer Store |
C6_ENTREG | date | Delivery Date |
...
*Example:* *response* \
response
Bloco de código | ||||||
---|---|---|---|---|---|---|
| ||||||
{
"items": |
...
[
|
...
{
"c6_loja": "01",
"c6_valor": 1500
"f76_valor": 125
"f76_moeda": 0
"f76_seq": "001",
"c6_cli": "CLIE01",
"c6_produto": "WGS01",
"f76_data": "2021-03-12",
"f76_txmoed": 0
"c6_entreg": "2019-08-01",
"c6_filial": "D MG 01",
"c6_num": "000006",
"c6_item": "01"
|
...
},
|
...
{
"c6_loja": "01",
"c6_valor": 1500
"f76_valor": 125
"f76_moeda": 0
"f76_seq": "002",
"c6_cli": "CLIE01",
"c6_produto": "WGS01",
"f76_data": "2021-03-14",
"f76_txmoed": 0
"c6_entreg": "2019-08-01",
"c6_filial": "D MG 01",
"c6_num": "000006",
"c6_item": "01"
|
...
}
|
...
],
"hasNext": true,
"struct": |
...
[
|
...
{
"field": "C6_FILIAL",
"type": "C",
"title": "Filial "
|
...
},
|
...
{
"field": "C6_NUM",
"type": "C",
"title": "Order No. "
|
...
}
|
...
]
|
...
} |
...
It is worth noting that if, in the API call, allfields is true, it will list all fields in the combination of SC7, F76 - Purchases. Sending fields in the fields parameter will bring the specified fields plus the default fields.
Json Object - Default
Attribute | Type | Description |
---|---|---|
F76_DATA | date | Date of balance |
F76_VALOR | numeric | Value |
F76_MOEDA | numeric | Order currency |
F76_TXMOED | numeric | Currency rate |
C7_FILIAL | character | System Branch |
C7_NUM | character | Purchase Order number |
C7_ITEM | character | Purchase Order Item |
C7_PRODUTO | character | Product Code |
C7_TOTAL | numeric | Total Item Value |
C7_DATPRF | date | Delivery Date |
C7_FORNECE | character | Supplier Code |
C7_LOJA | character | Supplier store |
...
*Example:* *response* \
response
Bloco de código | ||||||
---|---|---|---|---|---|---|
| ||||||
{
"items": |
...
[
|
...
{
"c7_loja": "01",
"f76_moeda": 1
"f76_valor": 5
"f76_seq": "001",
"c7_fornece": "COM002",
"c7_filial": "D MG 01",
"c7_produto": "COMSP0000000000MAT103CT134",
"f76_data": "2021-04-21",
"f76_txmoed": 0
"c7_datprf": "2018-10-24",
"c7_total": 10
"c7_num": "COM134",
"c7_item": "0001"
|
...
},
|
...
{
"c7_loja": "01",
"f76_moeda": 1
"f76_valor": 5
"f76_seq": "002",
"c7_fornece": "COM002",
"c7_filial": "D MG 01",
"c7_produto": "COMSP0000000000MAT103CT134",
"f76_data": "2021-05-21",
"f76_txmoed": 0
"c7_datprf": "2018-10-24",
"c7_total": 10
"c7_num": "COM134",
"c7_item": "0001"
|
...
}
|
...
],
"hasNext": false,
"struct": |
...
[
|
...
{
"field": "C7_FILIAL",
"type": "C",
"title": "Filial "
|
...
},
|
...
{
"field": "C7_NUM",
"type": "C",
"title": "PC Number "
|
...
}
|
...
]
|
...
} |
...