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)SOIGR

SOI/LOI GR报文示例

json
{
  "push_id": "11111",
  "source_system": "HIC/LESHINE",
  "target_system": "VMI", 
  "system_time":"2020-11-20 14:00:00",
  "total_size": 2,
  "current_page": 1,
  "current_page_size": 1,
  "workshop_code": "LSSC-SMT",
   "data": [
    {
      "tplReceiptId": "188011",
      "supplierId": "1000068649",
      "shipToId": "L220",
      "receiptDate": "2020-11-20 14:00:00",
      "tplReceiptLineId": "S37250",
      "itemId": "000000C52509",
      "destBin": "VENDOR",
      "destType": "C21",
      "destStorageLocation": "MRNM",
      "quantity": 1440,
      "holdType": "Q",
	 "holdQuantity":0,
	 "houseAirWaybill":"APLU062607978",
	 "purchaseOrderId": "",
	 "purchaseOrderLineId":"",
	  "dnNumber":"5500150390",
      "an": "1234567896",
      "anLine": "1234567896",
      "dataType": "SOIGR"
    }
  ]
}