查询产品订购的所有商品信息列表

联调中

POST

inst_svc_getOfferProdInstRelInfoAndProdInst

请求参数

Header 参数

accessToken

string

可选

默认值:

addd97479b608269f1c6cd1e0acf6e9d_21b86771-a566-4247-86ab-68b0f7f6d857

staffCode

string

可选

默认值:

A1002

Body 参数text/plain

示例

示例值:{ "prodInstId": 253868208802 }

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST 'inst_svc_getOfferProdInstRelInfoAndProdInst' \
--header 'accessToken: addd97479b608269f1c6cd1e0acf6e9d_21b86771-a566-4247-86ab-68b0f7f6d857' \
--header 'staffCode: A1002' \
--header 'Content-Type: text/plain' \
--data-raw '{
    "prodInstId": 253868208802
}'

返回响应

🟢200成功

application/json

Body

object {0}

示例

{
    "resultObject": [
        {
            "prodOfferInstRel": {
                "statusCd": "1000",
                "statusDate": "2023-06-27 10:26:58",
                "createStaff": 1000000000109709,
                "createDate": "2023-06-27 10:26:58",
                "updateStaff": 1000000000109709,
                "updateDate": "2023-06-27 10:27:36",
                "remark": "单商品成员关系资产计算状态为：1000,null修正前的accnum为null从缓存ORD_PROD_INST中拷贝REGION_ID",
                "lastOrderItemId": 25001147671267,
                "dataVerNum": 0,
                "offerProdInstRelId": 253424350553,
                "offerInstId": 253205602810,
                "prodInstId": 253868208802,
                "relType": "1000",
                "effDate": "2023-06-27 10:27:26",
                "expDate": "2025-07-01 00:00:00",
                "roleId": 1,
                "offerProdRelId": 913944050,
                "prodFuncType": "101",
                "prodId": 100000379,
                "accProdInstId": 253868208802,
                "prodUseType": "1000",
                "regionId": 8320100,
                "piRegionId": 8320101,
                "ownerCustId": 250006458746,
                "objType": "120103",
                "objInstId": 253868208802,
                "roleCd": "1",
                "billingInstId": 250001225942,
                "rangeId": 913944050
            },
            "offerInst": {
                "statusCd": "1000",
                "statusDate": "2023-06-27 10:27:37",
                "createStaff": 1000000000109709,
                "createDate": "2023-06-27 10:26:58",
                "updateStaff": 1000000000109709,
                "updateDate": "2023-06-27 10:27:36",
                "remark": "单成员销售品割接成商品资产计算状态为：1000,",
                "lastOrderItemId": 25001147671267,
                "dataVerNum": 0,
                "offerInstId": 253205602810,
                "offerId": 911021337,
                "offerType": "12",
                "ownerCustId": 250006458746,
                "effDate": "2023-06-27 10:27:26",
                "expDate": "2025-07-01 00:00:00",
                "createOrgId": 11160888,
                "expProcMethod": "20",
                "lanId": 8320100,
                "regionId": 8320100,
                "isIndependent": "0",
                "skuId": 911021337,
                "spuInstId": 253868208802,
                "type": "120102"
            }
        },
        {
            "prodOfferInstRel": {
                "statusCd": "1000",
                "statusDate": "2023-06-27 10:26:58",
                "createStaff": 1000000000109709,
                "createDate": "2023-06-27 10:26:58",
                "updateStaff": 1000000000109709,
                "updateDate": "2023-06-27 10:27:36",
                "remark": "礼包与新商品关系资产计算状态为：1000,null修正前的accnum为null从缓存ORD_PROD_INST中拷贝REGION_ID",
                "lastOrderItemId": 25001147689459,
                "dataVerNum": 0,
                "offerProdInstRelId": 253424350554,
                "offerInstId": 253204990377,
                "prodInstId": 253868208802,
                "relType": "1000",
                "effDate": "2023-07-01 00:00:00",
                "expDate": "3000-01-01 00:00:00",
                "roleId": 330,
                "offerProdRelId": 911255012,
                "prodFuncType": "101",
                "prodId": 100000379,
                "accProdInstId": 253868208802,
                "prodUseType": "1000",
                "regionId": 8320100,
                "piRegionId": 8320101,
                "ownerCustId": 250006458746,
                "objType": "120102",
                "objInstId": 250013420100,
                "roleCd": "330",
                "billingInstId": 250001840807,
                "rangeId": 911255012
            },
            "offerInst": {
                "statusCd": "1000",
                "statusDate": "2023-06-21 20:26:34",
                "createStaff": 23000483436,
                "createDate": "2023-06-21 20:26:22",
                "updateStaff": 23000483436,
                "updateDate": "2023-06-27 10:27:40",
                "remark": "多成员销售品割接成礼包资产计算状态为：1000,",
                "lastOrderItemId": 25001144046284,
                "dataVerNum": 0,
                "offerInstId": 253204990377,
                "offerId": 911012463,
                "offerType": "11",
                "ownerCustId": 250006458746,
                "effDate": "2023-07-01 00:00:00",
                "expDate": "3000-01-01 00:00:00",
                "createOrgId": 11091190,
                "expProcMethod": "20",
                "lanId": 8320100,
                "regionId": 8320100,
                "extOfferInstId": "323230621339535276",
                "isIndependent": "1",
                "type": "120101"
            }
        },
        {
            "prodOfferInstRel": {
                "statusCd": "1000",
                "statusDate": "2023-06-27 10:26:59",
                "createStaff": 1000000000109709,
                "createDate": "2023-06-27 10:26:59",
                "updateStaff": 1000000000109709,
                "updateDate": "2023-06-27 10:27:36",
                "remark": "特殊商品成员关系",
                "lastOrderItemId": -1,
                "dataVerNum": 0,
                "offerProdInstRelId": 253424355826,
                "offerInstId": 253205602815,
                "prodInstId": 253868208802,
                "relType": "1000",
                "effDate": "2023-06-27 10:27:26",
                "expDate": "3000-01-01 00:00:00",
                "roleId": 0,
                "offerProdRelId": 0,
                "prodFuncType": "101",
                "prodId": 100000379,
                "accProdInstId": 253868208802,
                "prodUseType": "1000",
                "regionId": 8320100,
                "piRegionId": 8320100,
                "ownerCustId": 250006458746,
                "objType": "120103",
                "objInstId": 253868208802,
                "roleCd": "1",
                "billingInstId": 250002167100
            },
            "offerInst": {
                "statusCd": "1000",
                "statusDate": "2023-06-27 10:27:37",
                "createStaff": 1000000000109709,
                "createDate": "2023-06-27 10:26:59",
                "updateStaff": 1000000000109709,
                "updateDate": "2023-06-27 10:27:36",
                "remark": "特殊处理销售品割接成商品资产计算状态为：1000,",
                "lastOrderItemId": 25001147682289,
                "dataVerNum": 0,
                "offerInstId": 253205602815,
                "offerId": 300500003485,
                "offerType": "10",
                "ownerCustId": 250006458746,
                "effDate": "2023-06-27 10:27:26",
                "expDate": "3000-01-01 00:00:00",
                "createOrgId": 11160888,
                "expProcMethod": "20",
                "lanId": 8320100,
                "regionId": 8320100,
                "busiModDate": "2023-06-27 10:23:24",
                "isIndependent": "1",
                "skuId": 300500003485,
                "spuInstId": 253868208802,
                "type": "120102"
            }
        },
        {
            "prodOfferInstRel": {
                "statusCd": "1000",
                "statusDate": "2023-06-27 10:26:59",
                "createStaff": 1000000000109709,
                "createDate": "2023-06-27 10:26:59",
                "updateStaff": 1000000000109709,
                "updateDate": "2023-06-27 10:27:36",
                "remark": "单商品成员关系资产计算状态为：1000,null修正前的accnum为null从缓存ORD_PROD_INST中拷贝REGION_ID",
                "lastOrderItemId": 25001147682290,
                "dataVerNum": 0,
                "offerProdInstRelId": 253424355827,
                "offerInstId": 253205607571,
                "prodInstId": 253868208802,
                "relType": "1000",
                "effDate": "2023-06-27 10:27:26",
                "expDate": "3000-01-01 00:00:00",
                "roleId": 1,
                "offerProdRelId": 910984923,
                "prodFuncType": "101",
                "prodId": 100000379,
                "accProdInstId": 253868208802,
                "prodUseType": "1000",
                "regionId": 8320100,
                "piRegionId": 8320101,
                "ownerCustId": 250006458746,
                "objType": "120103",
                "objInstId": 253868208802,
                "roleCd": "1",
                "billingInstId": 250001234206,
                "rangeId": 910984923
            },
            "offerInst": {
                "statusCd": "1000",
                "statusDate": "2023-06-27 10:27:37",
                "createStaff": 1000000000109709,
                "createDate": "2023-06-27 10:26:59",
                "updateStaff": 1000000000109709,
                "updateDate": "2023-06-27 10:27:40",
                "remark": "单成员销售品割接成商品资产计算状态为：1000,",
                "lastOrderItemId": 25001147682290,
                "dataVerNum": 0,
                "offerInstId": 253205607571,
                "offerId": 911011625,
                "offerType": "12",
                "ownerCustId": 250006458746,
                "effDate": "2023-06-27 10:27:26",
                "expDate": "3000-01-01 00:00:00",
                "createOrgId": 11160888,
                "expProcMethod": "20",
                "lanId": 8320100,
                "regionId": 8320100,
                "busiModDate": "2023-06-27 10:23:24",
                "extOfferInstId": "323230627342180630",
                "isIndependent": "0",
                "skuId": 911011625,
                "spuInstId": 253868208802,
                "type": "120102"
            }
        },
        {
            "prodOfferInstRel": {
                "statusCd": "1000",
                "statusDate": "2023-06-27 10:26:59",
                "createStaff": 1000000000109709,
                "createDate": "2023-06-27 10:26:59",
                "updateStaff": 1000000000109709,
                "updateDate": "2023-06-27 10:27:36",
                "remark": "礼包与新商品关系资产计算状态为：1000,个人套餐加装副卡带出副卡加入对应融合套餐修正前的accnum为null从缓存ORD_PROD_INST中拷贝REGION_ID",
                "lastOrderItemId": 25001147682291,
                "dataVerNum": 0,
                "offerProdInstRelId": 253424355828,
                "offerInstId": 253204990935,
                "prodInstId": 253868208802,
                "relType": "1000",
                "effDate": "2023-07-01 00:00:00",
                "expDate": "3000-01-01 00:00:00",
                "roleId": 339,
                "offerProdRelId": 912681564,
                "prodFuncType": "101",
                "prodId": 100000379,
                "accProdInstId": 253868208802,
                "prodUseType": "1000",
                "regionId": 8320100,
                "piRegionId": 8320101,
                "ownerCustId": 250006458746,
                "objType": "120102",
                "objInstId": 250013420100,
                "roleCd": "330",
                "billingInstId": 250002043011,
                "rangeId": 912681564
            },
            "offerInst": {
                "statusCd": "1000",
                "statusDate": "2023-06-21 20:26:35",
                "createStaff": 23000483436,
                "createDate": "2023-06-21 20:26:22",
                "updateStaff": 23000483436,
                "updateDate": "2023-06-21 20:26:33",
                "remark": "多成员销售品割接成礼包资产计算状态为：1000,",
                "lastOrderItemId": 25001144046222,
                "dataVerNum": 0,
                "offerInstId": 253204990935,
                "offerId": 911015764,
                "offerType": "12",
                "ownerCustId": 250006458746,
                "effDate": "2023-07-01 00:00:00",
                "expDate": "3000-01-01 00:00:00",
                "createOrgId": 11091190,
                "expProcMethod": "20",
                "lanId": 8320100,
                "regionId": 8320100,
                "isIndependent": "1",
                "type": "120101"
            }
        },
        {
            "prodOfferInstRel": {
                "statusCd": "1000",
                "statusDate": "2023-06-27 10:27:37",
                "createStaff": 1000000000109709,
                "createDate": "2023-06-27 10:26:59",
                "updateStaff": 1000000000109709,
                "updateDate": "2023-06-27 10:27:40",
                "remark": "新增商品成员关系",
                "lastOrderItemId": -1,
                "dataVerNum": 0,
                "offerProdInstRelId": 260000738390,
                "offerInstId": 250013420100,
                "prodInstId": 253868208802,
                "relType": "1000",
                "effDate": "2023-07-03 20:44:10",
                "expDate": "3000-01-01 00:00:00",
                "roleId": 0,
                "offerProdRelId": 0,
                "prodFuncType": "101",
                "prodId": 100000379,
                "accProdInstId": 253868208802,
                "prodUseType": "1000",
                "regionId": 8320101,
                "piRegionId": 8320101,
                "ownerCustId": 250006458746,
                "objType": "120103",
                "objInstId": 253868208802,
                "roleCd": "1",
                "billingInstId": 250001572887
            },
            "offerInst": {
                "statusCd": "1000",
                "statusDate": "2023-07-03 20:43:52",
                "createStaff": 1000000000109709,
                "createDate": "2023-07-03 20:43:52",
                "updateStaff": 1000000000109709,
                "updateDate": "2023-07-03 20:43:52",
                "remark": "多成员销售品补充成员虚拟商品",
                "lastOrderItemId": -1,
                "dataVerNum": 0,
                "offerInstId": 250013420100,
                "offerId": 591000079,
                "offerType": "12",
                "ownerCustId": 250006458746,
                "effDate": "2023-07-03 20:43:52",
                "expDate": "3000-01-01 00:00:00",
                "createOrgId": 11160888,
                "expProcMethod": "20",
                "lanId": 8320100,
                "regionId": 8320101,
                "isIndependent": "0",
                "skuId": 591000079,
                "spuInstId": 253868208802,
                "type": "120102"
            }
        }
    ],
    "resultCode": "0"
}

修改于 2023-07-24 01:56:55

根据offerInstId查询OfferInstCutoverMark

查询可移机的SPU实例清单