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) | 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"
}
]
}