SOI/LOI GR业务描述
当3PL收到供应商送货后,根据采购订单回传收货信息给VMI系统。VMI系统将收货信息同步到联想S4。
SOI/LOI GR 接口集成方式
参考Batch Integration模块
SOI/LOI GR 业务字段
参数名称 | 参数类型 | 数据库type | 描述 | Primary key | 是否必填/不为空 |
---|---|---|---|---|---|
tplReceiptId | string | VARCHAR2(20) | 3PL receipt id, | Y | |
supplierId | string | VARCHAR2(10) | Supplier id | ||
shipToId | string | VARCHAR2(4) | Logical plant | ||
receiptDate | string | Date | Receipt date, yyyy-MM-dd HH:mm:ss | ||
tplReceiptLineId | string | VARCHAR2(20) | 3PL receipt line id | Y | |
itemId | string | VARCHAR2(18) | Item id | ||
destBin | string | VARCHAR2(40) | Destination bin | ||
destType | string | VARCHAR2(40) | Destination type | ||
destStorageLocation | string | VARCHAR2(40) | Destination storage location | ||
quantity | number | NUMBER(13,3) | Quantity | ||
holdType | string | CHAR(1) | Q或者S , 如果为空字符串,表示没有hold | ||
holdQuantity | number | NUMBER(13,3) | Hold quantity | ||
houseAirWayBill | string | VARCHAR2(32) | House Airway Bill | ||
purchaseOrderId | string | VARCHAR2(10) | Empty for now | ||
purchaseOrderLineId | string | VARCHAR2(10) | Empty for now | ||
dnNumber | string | VARCHAR2(26) | Delivery Notes on Packing info | ||
an | string | VARCHAR2(10) | arrival notice | ||
anLine | string | VARCHAR2(5) | arrival notice line | ||
dataType | string | VARCHAR2(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"
}
]
}