Gestion des réceptions fournisseurs (API)
De Wiki1000
(Différences entre les versions)
Ligne 34 : | Ligne 34 : | ||
} | } | ||
</pre> | </pre> | ||
+ | |||
+ | ===Détails de livraison par fournisseur=== | ||
+ | |||
+ | <pre> | ||
+ | GET http://localhost:8080/sdata/TDetailLivraison?select=contratcommercialdetail.statutFacturation,contratcommercialdetail.statutLivraison,referenceLigne,noPieceLivraison as piecelivraison.noPiece,dateLivraison as pieceLivraison.ldate,codeProduit as contratcommercialdetail.produitcommercial.code,contratcommercialdetail.quantitenegociee&where=pieceLivraison.roleTiersRO.tiers.code eq 'ABI 007'&orderBy pieceLivraison.ldate desc | ||
+ | |||
+ | { | ||
+ | "$baseUrl": "http://localhost:8080/sdata/gcmouvement/", | ||
+ | "$title": "TDetailLivraison - -", | ||
+ | "$updated": "2021-02-16T14:44:11.096Z", | ||
+ | "$resources": [ | ||
+ | { | ||
+ | "$url": "TDetailLivraison('1B28EFFFF1C30002027A0000000B010D')", | ||
+ | "$title": "1B28EFFFF1C30002027A0000000B010D", | ||
+ | "$updated": "2020-02-26T07:55:53.000Z", | ||
+ | "$etag": "1B28EFFFF1C30002027A0000000B010D-00000015000005A5", | ||
+ | "$shareId": "1B28EFFFF1C30002000300000003000B", | ||
+ | "$shareInfo": "S1", | ||
+ | "$shareLevel": 2, | ||
+ | "$key": "1B28EFFFF1C30002027A0000000B010D", | ||
+ | "stamp": "00000015000005A5", | ||
+ | "codeProduit": "E-RAM-BLANC", | ||
+ | "dateLivraison": "2020-02-25T23:00:00.000Z", | ||
+ | "noPieceLivraison": { | ||
+ | "value": "BR DEP000038", | ||
+ | "CounterName": "RF" | ||
+ | }, | ||
+ | "quantiteNegociee": { | ||
+ | "value": 100, | ||
+ | "Decimales": 0, | ||
+ | "CodeUnit": "DAC19ACF0B21000206EF0000024A288B", | ||
+ | "CodeReferenceUnit": "DAC19ACF0B21000206EF0000024A288B", | ||
+ | "ReferenceValue": 100 | ||
+ | }, | ||
+ | "statutFacturation": { | ||
+ | "value": 2 | ||
+ | }, | ||
+ | "statutLivraison": { | ||
+ | "value": 3 | ||
+ | } | ||
+ | }, | ||
+ | .... | ||
+ | ] | ||
+ | } | ||
+ | </pre> | ||
+ | |||
[[Category:SData]] | [[Category:SData]] | ||
[[Category:latest]] | [[Category:latest]] |
Version du 16 février 2021 à 15:46
Bons de réception par fournisseur
Récupération des bons de réception par le code du tiers du fournisseur receveur d'ordre.
GET http://localhost:8080/sdata/TPieceLivraisonAchat?select=noPiece,originePiece,referenceExterne,livrable,receptionne,dateLivraison as ldate,dateLivraisonPrevue,roleTiersRO.Tiers.Caption&where=roleTiersRO.Tiers.Code eq 'ABI 007'&orderBy=dateLivraison desc { "$baseUrl": "http://localhost:8080/sdata/gcmouvement/", "$title": "TPieceLivraisonAchat - -", "$updated": "2021-02-16T14:22:42.235Z", "$resources": [ { "$url": "TPieceLivraisonAchat('1B28EFFFF1C30002039D000002A3000B')", "$title": "1B28EFFFF1C30002039D000002A3000B", "$updated": "2021-02-16T14:20:28.000Z", "$etag": "1B28EFFFF1C30002039D000002A3000B-000002430000000C", "$shareId": "1B28EFFFF1C30002000300000003000B", "$shareInfo": "S1", "$shareLevel": 2, "$key": "1B28EFFFF1C30002039D000002A3000B", "stamp": "000002430000000C", "Caption1": "ABI Jardin", "dateLivraison": "2021-02-15T23:00:00.000Z", "dateLivraisonPrevue": "2021-02-15T23:00:00.000Z", "Livrable": true, "noPiece": { "value": "BR DEP000042", "CounterName": "RF" }, "Receptionne": false }, ...... ] }
Détails de livraison par fournisseur
GET http://localhost:8080/sdata/TDetailLivraison?select=contratcommercialdetail.statutFacturation,contratcommercialdetail.statutLivraison,referenceLigne,noPieceLivraison as piecelivraison.noPiece,dateLivraison as pieceLivraison.ldate,codeProduit as contratcommercialdetail.produitcommercial.code,contratcommercialdetail.quantitenegociee&where=pieceLivraison.roleTiersRO.tiers.code eq 'ABI 007'&orderBy pieceLivraison.ldate desc { "$baseUrl": "http://localhost:8080/sdata/gcmouvement/", "$title": "TDetailLivraison - -", "$updated": "2021-02-16T14:44:11.096Z", "$resources": [ { "$url": "TDetailLivraison('1B28EFFFF1C30002027A0000000B010D')", "$title": "1B28EFFFF1C30002027A0000000B010D", "$updated": "2020-02-26T07:55:53.000Z", "$etag": "1B28EFFFF1C30002027A0000000B010D-00000015000005A5", "$shareId": "1B28EFFFF1C30002000300000003000B", "$shareInfo": "S1", "$shareLevel": 2, "$key": "1B28EFFFF1C30002027A0000000B010D", "stamp": "00000015000005A5", "codeProduit": "E-RAM-BLANC", "dateLivraison": "2020-02-25T23:00:00.000Z", "noPieceLivraison": { "value": "BR DEP000038", "CounterName": "RF" }, "quantiteNegociee": { "value": 100, "Decimales": 0, "CodeUnit": "DAC19ACF0B21000206EF0000024A288B", "CodeReferenceUnit": "DAC19ACF0B21000206EF0000024A288B", "ReferenceValue": 100 }, "statutFacturation": { "value": 2 }, "statutLivraison": { "value": 3 } }, .... ] }