Skip to content

Inventory Snapshot 业务描述

库存移动少的时间,3PL将WMS库存发送到VMI系统,VMI将S4库存和WMS库存进行比较,帮助业务及时发现库存差异。

Inventory Snapshot 集成方式

参考Batch Integration模块

Inventory Snapshot 业务字段

参数名称参数类型数据库type描述Primary Key是否必填/不为空
supplierIdStringVARCHAR2(40)Supplier idY
shipToIdStringVARCHAR2(4)Logic plantY
itemIdStringVARCHAR2(18)Item idY
statusStringVARCHAR2(10)StatusY
storageLocationStringVARCHAR2(40)Storage locationY
storageBinStringVARCHAR2(40)Storage binY
storageTypeStringVARCHAR2(40)Storage typeY
quantitynumberNUMBERquantity
dataTypeStringVARCHAR2(40)Inventory

Inventory Snapshot 报文示例

json
{
  "push_id": "11111",
  "workshop_code": "workshop code",
  "source_system": "source system",
  "target_system": "VMI", 
  "system_time":"2020-11-20 14:00:00",
  "total_size": 2,
  "current_page": 1,
  "current_page_size": 1,
  "data": [
      {
		"supplierId": "supplier1",
		"shipToId": "shopto",
		"itemId": "item1",
		"status": "A",
		"storageLocation": "CCCDDD",
		"storageBin": "VENDOR",
		"storageType": "A**",
		"quantity": 1,
		"dataType": "Inventory"
	}
  ]
}