Skip to content

SOI/LOI GR业务描述

当3PL收到供应商送货后,根据采购订单回传收货信息给VMI系统。VMI系统将收货信息同步到联想S4。

SOI/LOI GR 接口集成方式

参考Batch Integration模块

SOI/LOI GR 业务字段

参数名称参数类型数据库type描述Primary key是否必填/不为空
tplReceiptIdstringVARCHAR2(20)3PL receipt id,Y
supplierIdstringVARCHAR2(10)Supplier id
shipToIdstringVARCHAR2(4)Logical plant
receiptDatestringDateReceipt date, yyyy-MM-dd HH:mm:ss
tplReceiptLineIdstringVARCHAR2(20)3PL receipt line idY
itemIdstringVARCHAR2(18)Item id
destBinstringVARCHAR2(40)Destination bin
destTypestringVARCHAR2(40)Destination type
destStorageLocationstringVARCHAR2(40)Destination storage location
quantitynumberNUMBER(13,3)Quantity
holdTypestringCHAR(1)Q或者S , 如果为空字符串,表示没有hold
holdQuantitynumberNUMBER(13,3)Hold quantity
houseAirWayBillstringVARCHAR2(32)House Airway Bill
purchaseOrderIdstringVARCHAR2(10)Empty for now
purchaseOrderLineIdstringVARCHAR2(10)Empty for now
dnNumberstringVARCHAR2(26)Delivery Notes on Packing info
anstringVARCHAR2(10)arrival notice
anLinestringVARCHAR2(5)arrival notice line
dataTypestringVARCHAR2(20)dt1

SOI/LOI GR报文示例

json
{
  "push_id": "11111",
  "source_system": "ABC",
  "target_system": "VMI", 
  "system_time":"2020-11-20 14:00:00",
  "total_size": 2,
  "current_page": 1,
  "current_page_size": 1,
  "workshop_code": "workshopcode",
   "data": [
    {
      "tplReceiptId": "receipt1",
      "supplierId": "supplier1",
      "shipToId": "ABC",
      "receiptDate": "2020-11-20 14:00:00",
      "tplReceiptLineId": "line1",
      "itemId": "item1",
      "destBin": "VENDOR",
      "destType": "dest type",
      "destStorageLocation": "CCCDDD",
      "quantity": 1440,
      "holdType": "Q",
	 "holdQuantity":0,
	 "houseAirWaybill":"123456",
	 "purchaseOrderId": "",
	 "purchaseOrderLineId":"123456789",
	  "dnNumber":"dn1",
      "an": "123456789",
      "anLine": "123456789",
      "dataType": "dt1"
    }
  ]
}