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