Tracelink University ## Breadcrumb 1. [Home](/) 2. [Resources](/resources/resource-center) 3. [TraceLink University](/resources/tracelink-university) # Inventory balances (IDoc) - [Download PDF](/node/625991/pdf) - [Share](#) - [ LinkedIn ](https://www.linkedin.com/shareArticle?mini=true&url=https://www.tracelink.com/resources/tracelink-university/inventory-balances-idoc&title=Inventory balances (IDoc)&summary=Inventory balances allow suppliers to communicate with their remote or third-party warehouses about their available and upcoming inventory levels. &source=TraceLink "LinkedIn") - [ Facebook ](https://www.facebook.com/share.php?u=https://www.tracelink.com/resources/tracelink-university/inventory-balances-idoc&t=Inventory balances (IDoc) "Facebook") - [ Mail ](mailto:?subject=Inventory balances (IDoc)+|+TraceLink&body=https://www.tracelink.com/resources/tracelink-university/inventory-balances-idoc "Mail") - [ Twitter ](https://twitter.com/intent/tweet?text=Inventory balances (IDoc) https://www.tracelink.com/resources/tracelink-university/inventory-balances-idoc&via=TraceLink "Twitter") #### Table of contents **Inventory balances** allow suppliers to communicate with their remote or third-party warehouses about their available and upcoming inventory levels. Inventory balances contain several types of inventory information such as physical product location within a warehouse, product category, and total available inventory. Communicating inventory levels ensures suppliers can keep the required amount of inventory stocked at their locations and enables them to perform other key activities like properly preparing to fulfill large orders. Inventory balances are usually sent at regular intervals or because the buyer requests inventory information. Suppliers use inventory balances to communicate about available and upcoming inventory levels with their remote or third-party warehouses or buyers. ![](/sites/default/files/tech_comms/mpl/Content/Resources/Images/global_images/note_tip_24x24.png) Contact your TraceLink Services representative for more information about integrating with this message. - **Message Type**: MPC\_INVENTORY\_BALANCE (Inventory Balance) - **IDoc Format**: INVRPT01 - **Transform Names**: - B2B\_IDoc\_INVRPT\_INVRPT01\_InventoryBalance\_IB\_V4 - B2B\_IDoc\_INVRPT\_INVRPT01\_InventoryBalance\_OB\_V3 [![Closed](/sites/default/files/tech_comms/mpl/Skins/Default/Stylesheets/Images/transparent.gif)Guidelines](#) Input Element Occurs Length Description Example INVRPT01 \[1…1\] – **Required.** XML IDoc DESADV root element. – IDOC \[1…1\] – **Required.** IDoc root. – @BEGIN \[1…1\] 0/\* **Required.** Begin of message attribute. 1 EDI\_DC40 \[1…1\] – **Required.** IDoc control record. – @SEGMENT \[1…1\] 0/\* **Required.** Begin of segment attribute. 1 TABNAM \[1…1\] 0/\* **Required.** IDoc table name. EDI\_DC40 MANDT \[0…1\] 0/3 Client. 300 DOCNUM \[0…1\] 0/16 IDoc number. 0000000000619827 STATUS \[0…1\] 0/\* Current IDoc processing status. 03 DIRECT \[1…1\] 0/\* **Required.** Direction. 1 OUTMOD \[0…1\] 0/1 Output mode. 2 EXPRSS \[0…1\] 0/1 Overriding in inbound processing. – TEST \[0…1\] 0/1 Test flag. – IDOCTYP \[1…1\] 0/30 **Required.** IDoc basic type. INVRPT CIMTYP \[0…1\] 0/\* Name of extension type. – MESTYP \[0…1\] 0/\* Logical message type. INVRPT01 MESCOD \[0…1\] 0/3 Logical message code. – MESFCT \[0…1\] 0/3 Logical message function. – STD \[0…1\] 0/1 EDI standard. – STDVRS \[0…1\] 0/6 Version of EDI standard. – STDMES \[0…1\] 0/6 EDI message type. – SNDPOR \[1…1\] 0/10 **Required.** Sender port (SAP System, EDI subsystem). SAPD11 SNDPRT \[1…1\] 0/2 **Required.** Partner type of sender. LS SNDPFC \[0…1\] 0/2 Partner function of sender. – SNDPRN \[0…1\] 0/10 Partner number of sender. ERPCLNT302 SNDSAD \[0…1\] 0/21 Sender address (SADR). – SNDLAD \[0…1\] 0/70 Logical address of sender mapping to fileSenderNumber. Require a value that concatenates party type with party identifier in party type format. 0010136941923 RCVPOR \[1…1\] 0/10 **Required.** SAP receiver port. TRACELINK RCVPRT \[0…1\] 0/2 Partner type of receiver. LS RCVPFC \[0…1\] 0/2 Partner function of receiver. LS RCVPRN \[0…1\] 0/10 Partner number of receiver. TRACELINK RCVSAD \[0…1\] 0/21 Receiver address (SADR). – RCVLAD \[0…1\] 0/70 Logical address of receiver. Required for TraceLink. Identifies the receiver of the IDoc for the TraceLink system. 's location ID. Must match the value that the IDoc sender has configured for their receiver partner in TraceLink. 3333331013655 CREDAT \[1…1\] 8/8 **Required.** Date IDoc was created in format YYYYMMDD. 20230511 CRETIM \[1…1\] 6/6 **Required.** Time IDoc was created in format HHMMSS. 161000 REFINT \[0…1\] 0/14 Reference to interchange file. – REFGRP \[0…1\] 0/14 Reference to message group. – REFMES \[0…1\] 0/14 Reference to message. – ARCKEY \[0…1\] 0/70 EDI archive key. – SERIAL \[0…1\] 0/20 EDI/ALE: Serialization field. – E1DRM01 \[1…1\] – **Required.** Inventory balance report header segment. – @SEGMENT \[1…1\] 0/\* **Required.** Begin of segment attribute. 1 ACTION \[0…1\] 0/3 Processing action code for the whole IDoc message. Valid values: - `000` – Original. - `001` – Reverse. - `002` – Change (header level) . Not populated – Not applicable. ORIGINAL EFF\_DATE \[0…1\] 0/8 Effective date for inventory balance report. 20240228 EFF\_TIME \[0…1\] 0/6 Effective time. 12:40:34 TRANSNO \[0…1\] 0/35 Inventory balance report document number. 0081426104 TRANDATE \[0…1\] 0/8 Inventory balance report document date. 2024-03-08 TRANTIME \[0…1\] 0/6 Inventory balance report document time. 1 E1ADRM0 \[0…10\] – Mapping for bill-to party (customer) identifier and address information. – @SEGMENT \[1…1\] 0/\* **Required.** Begin of segment attribute. 1 PARTNER\_Q \[0…1\] 0/3 Qualifier identifying customer party location data. Valid values: - `AG` – Sold to customer. - `LF` – Vendor, supplier. - `MF` – Manufacturer. - `WE` – Ship to location. AG ADDRESS\_T \[0…1\] 0/1 Address type. – PARTNER\_ID \[0…1\] 0/17 SAP partner number. 0001307782 JURISDIC \[0…1\] 0/17 Location for tax calculation - Tax Jurisdiction Code. – LANGUAGE \[0…1\] 0/2 Language key. EN NAME1 \[0…1\] 0/40 Party name or description. BLUE FERRET HEALTH NAME2 \[0…1\] 0/\* Party name or description. – NAME3 \[0…1\] 0/\* Party name or description. – STREET1 \[0…1\] 0/40 House number and street. 5995 COMMERCE CENTER DR STREET2 \[0…1\] 0/40 House number and street. – STREET3 \[0…1\] 0/40 House number and street. – POSTL\_COD1 \[0…1\] 0/10 Postal code. 43125 CITY1 \[0…1\] 0/40 Town or city. GROVEPORT TELEPHONE1 \[0…1\] 0/30 Telephone number. 6144096700 TELEFAX \[0…1\] 0/30 Telephone number. 6144096751 COUNTRY1 \[0…1\] 0/3 Country indicator (ISO alphanumeric). US REGION \[0…1\] 0/3 Region, state code. OH E1DRM02 \[0…\*\] – Inventory balance report line item details. – @SEGMENT \[1…1\] 0/\* **Required.** Begin of segment attribute. 1 POSEX \[0…1\] 0/6 Line item number for inventory balance report. 000010 ACTION \[0…1\] 0/3 Processing function, transaction set purpose code. Valid values: - `001` – Item added. - `002` – Item changed. - `003` – Cancel (item). - `005` – Item locked. Not populated – Not applicable. – STQTY \[0…1\] 0/15 Line item quantity. 1000 MEASUNIT \[0…1\] 0/3 Unit of measure for total line item quantity. [![Closed](/sites/default/files/tech_comms/mpl/Skins/Default/Stylesheets/Images/transparent.gif)Valid values](#)- `02` – Statute Mile - `4G` – Microliter - `AM` – Ampoule - `AV` – Capsule - `BD` – Bundle - `BG` – Bag - `BO` – Bottle - `BX` – Box - `C3` – Centiliter - `C8` – Cubic decimeters - `CA` – Case - `CC` – Cubic Centimeter - `CF` – Cubic Feet - `CG` – Card Blister - `CH` – Container - `CI` – Cubic Inches - `CL` – Cylinder - `CM` – Centimeter - `CN` – Can - `CP` – Crate - `CQ` – Cartridge - `CR` – Cubic Meters - `CT` – Carton - `DA` – Day - `DI` – Dispenser - `DK` – Kilometers - `DL` – Deciliter - `DM` – Decimeter - `DR` – Drum - `DS` – Display - `DZ` – Dozen - `EA` – Each - `FO` – US Fluid Ounce - `FT` – Foot - `GA` – US Gallon - `GL` – Gram/Liter - `GR` – Gram - `GS` – Gross - `H4` – Hectoliter - `HF` – Hundred Feet - `HR` – Hours - `IN` – Inch - `K6` – Kiloliters - `KG` – Kilogram - `KT` – Kit - `LB` – US Pound - `LF` – Linear Foot - `LO` – Lot (unit of procurement) - `LT` – Liter - `LY` – Linear Yard - `MC` – Microgram - `ME` – Milligram - `ML` – Milliliter - `MM` – Millimeter - `MO` – Months - `MQ` – Cubic millimeter - `MR` – Meter - `OZ` – Ounce - `P1` – Percent - `PC` – Piece - `PF` – Pallet - `PK` – Pack (Only supported Outbound) - `PK` – Package - `PR` – Pair - `PT` – Pint - `QT` – Quart - `RL` – Roll - `SC` – Square Centimeter - `SF` – Square Foot - `SH` – Sheet - `SI` – Square Inch - `SM` – Square Meter - `SP` – Self Package - `ST` – Set - `SY` – Square Yard - `SZ` – Syringe - `T3` – Thousand Pieces - `TB` – Tube - `TH` – Thousands - `TN` – Tonne - `TS` – Thousands - `TY` – Tray - `U2` – Tablet - `UM` – Million - `UN` – Unit - `US` – Dosage Form - `V2` – Pouch - `VI` – Vial - `WK` – Week - `YD` – Yard - `YR` – Years EA EFF\_DATE \[0…1\] 0/8 Effective date. 20240308 E1DRM04 \[0…\*\] – On hand quantity at storage locations for product at line item level. – @SEGMENT \[1…1\] 0/\* **Required.** Begin of segment attribute. 1 QUALF \[0…1\] 0/3 Qualifier identifying quantity type recorded in IDoc. Valid value for IDoc is `079` – ONHAND. 079 STOCK\_LOC \[0…1\] 0/10 Quantity Details for storage locations. 4578 QTY \[0…1\] 0/15 On hand quantity at storage location. 500 UOM \[0…1\] 0/3 Unit of measure for on hand quantity. [![Closed](/sites/default/files/tech_comms/mpl/Skins/Default/Stylesheets/Images/transparent.gif)Valid values](#)- `02` – Statute Mile - `4G` – Microliter - `AM` – Ampoule - `AV` – Capsule - `BD` – Bundle - `BG` – Bag - `BO` – Bottle - `BX` – Box - `C3` – Centiliter - `C8` – Cubic decimeters - `CA` – Case - `CC` – Cubic Centimeter - `CF` – Cubic Feet - `CG` – Card Blister - `CH` – Container - `CI` – Cubic Inches - `CL` – Cylinder - `CM` – Centimeter - `CN` – Can - `CP` – Crate - `CQ` – Cartridge - `CR` – Cubic Meters - `CT` – Carton - `DA` – Day - `DI` – Dispenser - `DK` – Kilometers - `DL` – Deciliter - `DM` – Decimeter - `DR` – Drum - `DS` – Display - `DZ` – Dozen - `EA` – Each - `FO` – US Fluid Ounce - `FT` – Foot - `GA` – US Gallon - `GL` – Gram/Liter - `GR` – Gram - `GS` – Gross - `H4` – Hectoliter - `HF` – Hundred Feet - `HR` – Hours - `IN` – Inch - `K6` – Kiloliters - `KG` – Kilogram - `KT` – Kit - `LB` – US Pound - `LF` – Linear Foot - `LO` – Lot (unit of procurement) - `LT` – Liter - `LY` – Linear Yard - `MC` – Microgram - `ME` – Milligram - `ML` – Milliliter - `MM` – Millimeter - `MO` – Months - `MQ` – Cubic millimeter - `MR` – Meter - `OZ` – Ounce - `P1` – Percent - `PC` – Piece - `PF` – Pallet - `PK` – Pack (Only supported Outbound) - `PK` – Package - `PR` – Pair - `PT` – Pint - `QT` – Quart - `RL` – Roll - `SC` – Square Centimeter - `SF` – Square Foot - `SH` – Sheet - `SI` – Square Inch - `SM` – Square Meter - `SP` – Self Package - `ST` – Set - `SY` – Square Yard - `SZ` – Syringe - `T3` – Thousand Pieces - `TB` – Tube - `TH` – Thousands - `TN` – Tonne - `TS` – Thousands - `TY` – Tray - `U2` – Tablet - `UM` – Million - `UN` – Unit - `US` – Dosage Form - `V2` – Pouch - `VI` – Vial - `WK` – Week - `YD` – Yard - `YR` – Years EA E1EDP19 \[0…\*\] – On hand quantity at storage locations for product at line item level. – @SEGMENT \[1…1\] 0/\* **Required.** Begin of segment attribute. 1 QUALF \[0…1\] 0/3 Qualifier identifying type of material identifier. Valid values: - `001` – Customer - `002` – Supplier - `003` – GTIN14 - `004` – Manufacturer - `010` – Batch 001 IDTNR \[0…1\] 0/35 Product code identifier value. 00015874962358 KTEXT \[0…1\] 0/70 Product name or description. PHARMA PRODUCT NAME [![Closed](/sites/default/files/tech_comms/mpl/Skins/Default/Stylesheets/Images/transparent.gif)Example](#)```xml EDI_DC40 999 DOCNUM 03 1 2 1 X INVRPT01 INVRPT COD s5 s s7 s8 s9 s1 s1 s92 SenAdd Sender s13 LS LS s93 Receiver 20240103 091013 s17 s18 s19 s20 s21 000 20240101 110123 s25 20231229 100001 AG A BillTo Juris EN BillTo BillToName2 BillToName3 BillToStreet1 BillToStreet2 BillToStreet3 BTPostal BTCity BTPhone BTFax BT S1 LF A SUPPLIER Juris EN Supplier SupplierName2 SupplierName3 LFStreer1 LFStreer2 LFStreet3 Post2 LFCity LFPhone LFFax LF LF MF A MANUFACTURER Juris EN Manufacturer ManufacturerName2 ManufacturerName3 MFStreet1 MFStreet2 MFStreet3 MFPost MFCity MFPhone MFFax MF MFR WE A SHIPTO Juris EN ShipTo ShipToName2 ShipToName3 WEStreet1 WEStreet2 WEStreet3 WEPost WECity WEPhone WEFax WE WER OSP A SHIPFROM Juris EN ShipFrom ShipFromName2 ShipFromName3 SFStreet1 SFStreet2 SFStreet3 SFPost SFCity SFPhone SFFax SF SFR 000010 005 1305750 CR 20240101 079 A-100 1500 BX 004 MANUFACTURER ProdName 1 002 Supplier Name 2 003 GTIN14 Name 3 001 CUSTOMER Customer Desc 3 ``` ![](/sites/default/files/tech_comms/mpl/Content/Resources/Images/global_images/note_tip_24x24.png) Review TraceLink's [API: Terms of Use](https://www.tracelink.com/legal-and-trust/api-terms-of-use) #### Table of contents ##### Related Content [ ![Related content](https://www.tracelink.com/sites/default/files/2024-09/cloud.svg) ](/resources/tracelink-university/forecast-plan-idoc) ##### Forecast plan (IDoc) Forecasting APIs allow companies to exchange data about anticipated product demand and supply availability with upstream supply chain Partners without giving these Partners access to their serialization system of record. [View More](/resources/tracelink-university/forecast-plan-idoc) [ ![Related content](https://www.tracelink.com/sites/default/files/2024-09/cloud.svg) ](/resources/tracelink-university/forecast-plan-x12) ##### Forecast plan (X12) Forecasting APIs allow companies to exchange data about anticipated product demand and supply availability with upstream supply chain Partners without giving these Partners access to their serialization system of record. [View More](/resources/tracelink-university/forecast-plan-x12) [ ![Related content](https://www.tracelink.com/sites/default/files/2024-09/cloud.svg) ](/resources/tracelink-university/forecast-plan-response-idoc) ##### Forecast plan response (IDoc) Forecasting APIs allow companies to exchange data about anticipated product demand and supply availability with downstream supply chain Partners without giving these Partners access to their serialization system of record. [View More](/resources/tracelink-university/forecast-plan-response-idoc)