API des lignes de comptage de cycles (/cycle_count_lines)
Utilisez l'API Lignes de comptage de cycles pour obtenir une liste d'éléments à compter.
Aperçu
Utilisez l'API Lignes de comptage de cycles pour obtenir une liste d'éléments à compter. L'URL pour accéder aux listes de sélection est : https ://{your_instance_name}/api/
cycle_count_lines
Voir Comptages de cycles pour plus d'informations.
Objets enfants
Actions
Verbe | Chemin d'accès | Action | Description | ||
---|---|---|---|---|---|
OBTENIR | /api/cycle_count/:cycle_count_id/cycle_count_lines | index | Lignes de comptage de cycles de requête | ||
OBTENIR | /api/cycle_count/:cycle_count_id/cycle_count_lines/:id | afficher | Afficher la ligne du comptage de cycles | ||
METTRE | /api/cycle_count/:cycle_count_id/cycle_count_lines/:id | mettre à jour | /api/cycle_count/:cycle_count_id/cycle_count_lines/:id | ||
PATCH | /api/cycle_count/:cycle_count_id/cycle_count_lines/:id | mettre à jour | /api/cycle_count/:cycle_count_id/cycle_count_lines/:id |
Éléments
Élément | Description | Dem. | Unique | Valeur autorisée | Dans | Sortie | Type de données |
---|---|---|---|---|---|---|---|
solde-quantité | Quantité de la balance | oui | décimale(30,6) | ||||
consommation-quantité | Quantité dans l'unité de mesure de consommation | oui | oui | décimale(30,6) | |||
created-at | Créé automatiquement par Coupa au format AAAA-MM-JJFHH :MM :SS+HH :MMZ | oui | datetime | ||||
cycle-count-id | Identifiant Coupa unique de Cycle Count | oui | nombre entier | ||||
rajustements de la ligne de comptage de cycle | Ajustements de la ligne de comptage | oui | CycleCountLineAdjustment | ||||
cycle-count-line-lots | Lots de ligne | oui | oui | CycleCountLineLot | |||
anomalie | Anomalie | oui | chaîne | ||||
valeur d'écart | Valeur de l'écart | oui | décimale(30,6) | ||||
iD | Identifiant unique Coupa | oui | nombre entier | ||||
inventaire-bilan | Solde d'inventaire | oui | oui | InventoryBalance | |||
article | Article | oui | Article | ||||
transactions-inventaire non annulées | Transactions d'inventaire | oui | InventoryTransaction | ||||
sur l'équilibre de la main | Solde de l'instantané | oui | chaîne | ||||
quantité-commande | Quantité commandée | oui | oui | décimale(30,6) | |||
quantité | Quantité | oui | oui | oui | décimale(30,6) | ||
statut | Statut de la ligne | oui | string(255) | ||||
uom | UDM | oui | Unité de mesure | ||||
mis-à-jour à | Créé automatiquement par Coupa au format AAAA-MM-JJFHH :MM :SS+HH :MMZ | oui | datetime |
Exemples d'appels
Vous pouvez créer pour obtenir une ligne de comptage de cycle spécifique par ID
OBTENEZ https ://{your_instance_name}/api/cycle_count_line ?id={id}
.
Sortie
<?xml version="1.0" encoding="UTF-8"?>
2<cycle-count-line>
3 <id type="integer"> 51</id>
4 <created-at type="dateTime">2022-06-25T15:20:12-07:00</created-at>
5 <updated-at type="dateTime">2022-06-25T15:20:12-07:00</updated-at>
6 <quantity nil="true"/>
7 <discrepancy type="integer">-10</discrepancy>
8 <status>en attente</status>
9 <balance-quantity nil="true"/>
10 <order-quantity nil="true"/>
11 <discrepancy-value type="decimal">-10,00</discrepancy-value>
12 <consumption-quantity nil="true"/>
13 <cycle-count-id type="integer"> 13</cycle-count-id>
14 <on-hand-balance type="decimal">10,0</on-hand-balance>
15 <inventory-balance>
16 <id type="integer"> 51</id>
17 <created-at type="dateTime">2022-06-25T15:20:12-07:00</created-at>
18 <updated-at type="dateTime">2022-06-25T15:20:12-07:00</updated-at>
19 <quantity type="decimal">10,0</quantity>
20 <allocated type="decimal">0,0</allocated>
21 <available type="decimal">10,0</available>
22 <item>
23 <id type="integer"> 51</id>
24 <created-at type="dateTime">2022-06-25T15:20:12-07:00</created-at>
25 <updated-at type="dateTime">2022-06-25T15:20:12-07:00</updated-at>
26 <description>Il s'agit d'un exemple de description d'élément que l'utilisateur verrait.</description>
27 <item-number>xxxx2</item-number>
28 <name>Nom du produit Coupa Demodata 2</name>
29 <active type="boolean">vrai</active>
30 <storage-quantity nil="true"/>
31 <consumption-quantity nil="true"/>
32 <image-url nil="true"/>
33 <external-image-url nil="true"/>
34 <manufacturer-part-number nil="true"/>
35 <manufacturer-name nil="true"/>
36 <item-type>article</item-type>
37 <require-inspection nil="true"/>
38 <require-asset-tag nil="true"/>
39 <use-pack-weight nil="true"/>
40 <pack-qty nil="true"/>
41 <pack-weight nil="true"/>
42 <pack-uom-id nil="true"/>
43 <receive-catch-weight nil="true"/>
44 <allow-partial-quantity type="boolean">false</allow-partial-quantity>
45 <inventory-lot-tracking-enabled type="boolean">false</inventory-lot-tracking-enabled>
46 <inventory-lot-expiration-type>Non requis</inventory-lot-expiration-type>
47 <reorder-alerts type="array"/>
48 <commodity nil="true"/>
49 <receiving-form nil="true"/>
50 <uom>
51 <id type="integer"> 1</id>
52 <created-at type="dateTime">2022-06-25T14:01:05-07:00</created-at>
53 <updated-at type="dateTime">2022-06-25T14:01:05-07:00</updated-at>
54 <code>EA</code>
55 <name>Chacun (e</name>)
56 <allowable-precision type="integer"> 0</allowable-precision>
57 <active type="boolean">vrai</active>
58 </uom>
59 <storage-uom nil="true"/>
60 <consumption-uom nil="true"/>
61 <tax-detail nil="true"/>
62 <updated-by>
63 <id type="integer"> 26</id>
64 <login>test_user1</login>
65 <employee-number nil="true"/>
66 <firstname>test1</firstname>
67 <lastname>user1</lastname>
68 <fullname>test1 utilisateur1</fullname>
69 <email>test_user1@coupa.com</email>
70 <salesforce-id nil="true"/>
71 <avatar-thumb-url nil="true"/>
72 </updated-by>
73 </item>
74 <warehouse>
75 <id type="integer"> 11</id>
76 <created-at type="dateTime">2022-06-25T15:20:12-07:00</created-at>
77 <updated-at type="dateTime">25/06/2022T15:20:12-07:00</updated-at>
78 <active-flag type="boolean">vrai</active-flag>
79 <description>Description de l'entrepôt 1</description>
80 <name>Entrepôt 1</name>
81 <currency>
82 <id type="integer"> 1</id>
83 <code>USD</code>
84 <decimals type="integer"> 2</decimals>
85 </currency>
86 <address>
87 <id type="integer"> 11</id>
88 <created-at type="dateTime">25-06-2022T15:20:11-07:00</created-at>
89 <updated-at type="dateTime">25-06-2022T15:20:11-07:00</updated-at>
90 <name nil="true"/>
91 <location-code nil="true"/>
92 <street1>1 Partout</street1>
93 <street2 nil="true"/>
94 <city>Oakland</city>
95 <state nil="true"/>
96 <postal-code> 94607</postal-code>
97 <attention nil="true"/>
98 <active type="boolean">vrai</active>
99 <business-group-name nil="true"/>
100 <vat-number>TVA-456</vat-number>
101 <local-tax-number></local-tax-number>
102 <type nil="true"/>
103 <country>
104 <id type="integer"> 223</id>
105 <code>États-Unis</code>
106 <name>États-Unis</name>
107 </country>
108 <vat-country>
109 <id type="integer"> 223</id>
110 <code>États-Unis</code>
111 <name>États-Unis</name>
112 </vat-country>
113 </address>
114 <warehouse-type>
115 <id type="integer"> 11</id>
116 <created-at type="dateTime">2022-06-25T15:20:11-07:00</created-at>
117 <updated-at type="dateTime">2022-06-25T15:20:11-07:00</updated-at>
118 <name>Entrepôt Type 1</name>
119 <description>Description pour le type d'entrepôt 1</description>
120 </warehouse-type>
121 <warehouse-locations type="array">
122 <warehouse-location>
123 <id type="integer"> 21</id>
124 <created-at type="dateTime">25-06-2022T15:20:12-07:00</created-at>
125 <updated-at type="dateTime">25/06/2022T15:20:12-07:00</updated-at>
126 <aisle> 1</aisle>
127 <bin> 1</bin>
128 <level> 1</level>
129 <warehouse-id type="integer"> 11</warehouse-id>
130 <warehouse-name>Entrepôt 1</warehouse-name>
131 </warehouse-location>
132 <warehouse-location>
133 <id type="integer"> 22</id>
134 <created-at type="dateTime">25-06-2022T15:20:12-07:00</created-at>
135 <updated-at type="dateTime">2022-06-25T15:20:12-07:00</updated-at>
136 <aisle>A001</aisle>
137 <bin> 0001</bin>
138 <level>L001</level>
139 <warehouse-id type="integer"> 11</warehouse-id>
140 <warehouse-name>Entrepôt 1</warehouse-name>
141 </warehouse-location>
142 </warehouse-locations>
143 </warehouse>
144 <warehouse-location>
145 <id type="integer"> 21</id>
146 <created-at type="dateTime">25/06/2022T15:20:12-07:00</created-at>
147 <updated-at type="dateTime">25-06-2022T15:20:12-07:00</updated-at>
148 <aisle> 1</aisle>
149 <bin> 1</bin>
150 <level> 1</level>
151 <warehouse-id type="integer"> 11</warehouse-id>
152 <warehouse-name>Entrepôt 1</warehouse-name>
153 </warehouse-location>
154 <uom>
155 <id type="integer"> 1</id>
156 <created-at type="dateTime">2022-06-25T14:01:05-07:00</created-at>
157 <updated-at type="dateTime">2022-06-25T14:01:05-07:00</updated-at>
158 <code>EA</code>
159 <name>Chacun (e</name>)
160 <allowable-precision type="integer"> 0</allowable-precision>
161 <active type="boolean">vrai</active>
162 </uom>
163 <inventory-valuations type="array">
164 <inventory-valuation>
165 <id type="integer"> 51</id>
166 <created-at type="dateTime">25-06-2022T15:20:12-07:00</created-at>
167 <updated-at type="dateTime">2022-06-25T15:20:12-07:00</updated-at>
168 <unit-price type="decimal">1,00</unit-price>
169 <total type="decimal">10,00</total>
170 <currency>
171 <id type="integer"> 1</id>
172 <code>USD</code>
173 <decimals type="integer"> 2</decimals>
174 </currency>
175 </inventory-valuation>
176 </inventory-valuations>
177 </inventory-balance>
178 <item>
179 <id type="integer"> 51</id>
180 <created-at type="dateTime">25/06/2022T15:20:12-07:00</created-at>
181 <updated-at type="dateTime">2022-06-25T15:20:12-07:00</updated-at>
182 <description>Il s'agit d'un exemple de description d'élément que l'utilisateur verrait.</description>
183 <item-number>xxxx2</item-number>
184 <name>Nom du produit Coupa Demodata 2</name>
185 <active type="boolean">vrai</active>
186 <storage-quantity nil="true"/>
187 <consumption-quantity nil="true"/>
188 <image-url nil="true"/>
189 <external-image-url nil="true"/>
190 <manufacturer-part-number nil="true"/>
191 <manufacturer-name nil="true"/>
192 <item-type>article</item-type>
193 <require-inspection nil="true"/>
194 <require-asset-tag nil="true"/>
195 <use-pack-weight nil="true"/>
196 <pack-qty nil="true"/>
197 <pack-weight nil="true"/>
198 <pack-uom-id nil="true"/>
199 <receive-catch-weight nil="true"/>
200 <allow-partial-quantity type="boolean">false</allow-partial-quantity>
201 <inventory-lot-tracking-enabled type="boolean">false</inventory-lot-tracking-enabled>
202 <inventory-lot-expiration-type>Non requis</inventory-lot-expiration-type>
203 <reorder-alerts type="array"/>
204 <commodity nil="true"/>
205 <receiving-form nil="true"/>
206 <uom>
207 <id type="integer"> 1</id>
208 <created-at type="dateTime">2022-06-25T14:01:05-07:00</created-at>
209 <updated-at type="dateTime">2022-06-25T14:01:05-07:00</updated-at>
210 <code>EA</code>
211 <name>Chacun (e</name>)
212 <allowable-precision type="integer"> 0</allowable-precision>
213 <active type="boolean">vrai</active>
214 </uom>
215 <storage-uom nil="true"/>
216 <consumption-uom nil="true"/>
217 <tax-detail nil="true"/>
218 <updated-by>
219 <id type="integer"> 26</id>
220 <login>test_user1</login>
221 <employee-number nil="true"/>
222 <firstname>test1</firstname>
223 <lastname>user1</lastname>
224 <fullname>test1 user1</fullname>
225 <email>test_user1@coupa.com</email>
226 <salesforce-id nil="true"/>
227 <avatar-thumb-url nil="true"/>
228 </updated-by>
229 </item>
230 <uom>
231 <id type="integer"> 1</id>
232 <created-at type="dateTime">2022-06-25T14:01:05-07:00</created-at>
233 <updated-at type="dateTime">2022-06-25T14:01:05-07:00</updated-at>
234 <code>EA</code>
235 <name>Chacun (e</name>)
236 <allowable-precision type="integer"> 0</allowable-precision>
237 <active type="boolean">vrai</active>
238 </uom>
239 <cycle-count-line-adjustments type="array"/>
240 <non-voided-inventory-transactions type="array"/>
241 <cycle-count-line-lots type="array"/>
242</cycle-count-line>
Charges utiles
XML :
Ligne simple sans article de lot
<?xml version="1.0" encoding="UTF-8"?> <cycle-count-line> <id type="integer">#{cycle_count_line.id}</id> <quantity type="integer">100</quantity> </cycle-count-line>
ligne avec article lot, pas de multi uom :
<?xml version="1.0" encoding="UTF-8"?> <cycle-count-line> <id type="integer">12</id> <cycle-count-line-lots type="array"> <cycle-count-line-lot> <quantity type="integer">10</quantity> <inventory-lot-id type="integer">#{balance_lot2.inventory_lot.id}</inventory-lot-id> </cycle-count-line-lot> <cycle-count-line-lot> <quantity type="integer">10</quantity> <inventory-lot-number >#{balance_lot1.inventory_lot.number}</inventory-lot-number> </cycle-count-line-lot> </cycle-count-line-lots> </cycle-count-line>
Ligne avec article multi uom
<?xml version="1.0" encoding="UTF-8"?> <cycle-count-line> <id type="integer">#{multi_uom_line.id}</id> <order-quantity type="integer">10</order-quantity> <consumption-quantity type="integer">10</consumption-quantity> </cycle-count-line>
Multi UDM avec lots
<?xml version="1.0" encoding="UTF-8"?> <cycle-count-line> <id type="integer">21</id> <cycle-count-line-lots type="array"> <cycle-count-line-lot> <order-quantity type="integer">10</order-quantity> <consumption-quantity type="integer">10</consumption-quantity> <inventory-lot-id type="integer">12</inventory-lot-id> </cycle-count-line-lot> <cycle-count-line-lot> <order-quantity type="integer">10</order-quantity> <consumption-quantity type="integer">10</consumption-quantity> <inventory-lot-number >EXISTING_LOT_NUMBER</inventory-lot-number> </cycle-count-line-lot> </cycle-count-line-lots> </cycle-count-line>
JSON :
Ligne simple
{ "id" : #{cycle_count_line.id}, "quantité" : 100}
Ligne simple avec lots
:
{ "id" : #{cycle_count_line.id}, "cycle_count_line_lots" : [ {"quantity" : 10, "inventory_lot_id" : "#{balance_lot.inventory_lot.id}"}, {"quantity" : 10, "inventory_lot_number" : "#{balance_lot.inventory_lot.number}"} ] }
Ligne avec article multi-uom :
{"id" : #{multi_uom_line.id},"order_quantity" : 10, "consumption_quantity" : 10}
Ligne avec support d'articles et de lots multi-usages :
{ "id" : 12, "cycle_count_line_lots" : [ {"order_quantity" : 10, "consumption_quantity" : 10, "inventory_lot_id" : 'existing-lot-id'}, {"order_quantity" : 10, "consumption_quantity" : 10, "inventory_lot_number" : "numéro-de-lot-existant}"} ] }