接口名称t100.oapi.sales.order.details.data.read.get接口说明读取销售订单明细资料程序代号wssp00002输入参数说明参数代号型态是否必填参数说明范例值requestkeystring是检核编码(MD5)109c3c41a1441e702b909ed3de58e4b1typestring是Request类型(sync,async)固定传入synchostprodstring是发起方产品名称OAPIverstring是发起方产品版本1.0ipstring是发起方IP位置10.40.71.91idstring否发起方产品识别码,提供同一产品多台主机辨别之用acctstring是登入帐号固定传入tiptoptimestampstring是时间戳记格式:yyyyMMddHHmmssSSS20151211123204361timezonestring否发起方时区(-12~+14)+8langstring是语言别(zh_TW,zh_CN,en,vi)zh_CNserviceprodstring是接收方产品名称T100namestring是服务名称t100.oapi.sales.order.details.data.read.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码,提供同一产品多台主机辨别之用topprddatakeyEntIdstring是企业编号99CompanyIdstring否营运据点DSCTC参数代号型态是否必填参数说明范例值ERP栏位enterprise_nostring否企业编号若无传值则预设值g_enterprise99xmdaentsite_nostring否营运中心DSCTCxmdasiteis_digiwin_productstring是是否为鼎捷产品(Y,N)Yso_master—是订单主档(单头节点,支持多数组)so_nostring是订单单号CTC-S11-220900000009xmdadocnoRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:53bc96d28ab83fb65c85e734e45b7b80digi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_CN","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"T100","name":"t100.oapi.sales.order.details.data.read.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点"}{"std_data":{"parameter":{"enterprise_no":"企业编号","site_no":"营运据点","is_digiwin_product":"是否为鼎捷产品","so_master":[{"so_no":"订单单号"}]}}}成功返回参数说明参数代号型态是否必填参数说明范例值ERP栏位srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程,并产生预期的结果(Basicflow)100:服务未按照正常流程执行,例如发生信息检核不通过等情况,导致无法完成预期的结果000参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0:正确<>0:FAIL(原因代码)0sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述执行成功!so_master—是订单变更单主档(单头节点,支持多数组)om_company_idstring否营运公司编号DSCTCxmdasiteso_nostring是订单单号CTC-D08-202315130003xmdadocnoversionnumeric否版次0xmda001doc_typestring否单别D08oobxl001doc_type_namestring否单别名称oobxl003so_datedate是订单日期格式:yyyy-mm-dd2023-05-13xmdadocdtsales_nostring是业务人员D001xmda002sales_namestring否业务人员名称陈测试ooag011sales_department_nostring是业务部门DSCTCxmda003sales_department_namestring否业务部门名称T产中台中开发部ooefl003customer_nostring是客户编号00000002xmda004customer_namestring否客户名称鼎新计算机aaaapmaal004customer_full_namestring否客户全称鼎新计算机股份有限公司pmaal003so_kindstring是订单性质1.一般订单2.换货订单3.签收订单4.调拨订单5.预先订单6.调货订单7.寄销正式出货\销退8.借货订单1xmda005source_typestring是资料来源1.人工输入2.预先订单3.报价单5.销退换货6.多角抛转7.协作转入8.促销分配9.EC10.订货会订单1xmda007source_nostring否来源单号xmda008payment_condition_nostring否收款条件编号212xmda009payment_condition_namestring否收款条件说明212收款用ooibl004trade_condition_nostring否交易条件编号EXWxmda010trade_condition_namestring否交易条件说明卖方工厂交货oocql004tax_nostring否税别编号001xmda011tax_namestring否税别说明oodbl004tax_ratenumeric否税率17xmda012is_price_taxstring否单价含税否Yxmda013currencystring否币别TWDxmda015exchange_ratenumeric否汇率1xmda016valuation_method_nostring否取价方式编号131219-001xmda017valuation_method_namestring否取价方式说明Miotestxmahl003customer_contractor_nstring否客户连络人编号xmda027ocustomer_contractor_namestring否客户连络人名称pmaj012sales_channel_nostring否销售通路编号xmda023sales_channel_namestring否销售通路说明oojdl003retain_cause_nostring否留置原因代码xmda032retain_cause_namestring否留置原因说明oocql004customer_so_nostring否客户订购单号xmda033invoice_typestring否发票类型A1xmda035invoice_type_namestring否发票类型说明isacl004total_trans_curr_not_tax_amountnumeric是订单总未税金额342xmda041total_trans_curr_tax_amountnumeric是订单总含税金额400xmda042total_trans_curr_taxnumeric是订单总税额58xmda043rate_calculation_typestring否汇率计算基准1.依订单日汇率2.依Invoice日汇率3.依出货日汇率4.依立帐日汇率5.依立帐日月平均汇率1xmda049delivery_addressstring否出货地址xmda025delivery_address_descstring否出货地址说明billing_addressstring否帐款地址xmda026billing_address_descstring否帐款地址说明confirmorstring否审核者T0005xmdacnfidconfirm_datestring否审核日格式:yyyy-mm-ddhh:mm:ss2023-05-1515:28:13xmdacnfdtstatusstring否状态码N:未审核Y:已审核A:已核准D:抽单R:已拒绝W:送签中C:结案H:留置UH:取消留置X:作废Nxmdastusremarkstring否备注xmda071so_detail—是订单主要明细档(单身节点,支持多数组)so_seqnumeric是项次1xmdcseqitem_nostring是料件编号0000xmdc001item_namestring否料件品名男装imaal003item_specstring否料件规格2015新款imaal004item_feature_nostring否产品特征xmdc002item_feature_namestring否产品特征说明inaml004bom_featurestring否BOM特性xmdc062component_featurestring否子件特性1.一般2.CKD3.SKD4.可选件5.附属零件6.备品7.包装容器8.委外代买9.样品10.拆件主件11.拆件元件12.联产品13.副产品/回收料14.多产出主件1xmdc019sales_unit_nostring否销售单位PCSxmdc006sales_unit_namestring否销售单位名称件oocal003so_qtystring否销售数量10.000000xmdc007reference_unit_nostring否参考单位xmdc008reference_qtystring否参考数量0xmdc009valuation_unitstring否计价单位PCSxmdc010valuation_qtystring否计价数量10xmdc011so_due_datestring否约定交货日格式:yyyy-mm-dd2023-05-31xmdc012receive_datestring否预定签收日格式:yyyy-mm-ddxmdc013pricenumeric是单价20xmdc015tax_nostring是税别编号001xmdc016tax_namestring否税别说明oodbl004tax_ratenumeric否税率17xmdc017emergencystring否急料1.一般2.紧急3.特急1xmdc020customer_item_nostring否客户料号xmdc027warehouse_nostring否仓库编号xmdc028warehouse_namestring否仓库名称inayl003storage_spaces_nostring否储位xmdc029storage_spaces_namestring否储位名称inab003lot_nostring否批号xmdc030project_codestring否项目编号xmdc036project_namestring否项目名称pjbal003/pjabl003trans_curr_not_tax_amountnumeric否未税金额171xmdc046trans_curr_tax_amountnumeric否含税金额200xmdc047trans_curr_taxnumeric否税额29xmdc048customer_so_seqstring否客户订单项次xmdc051remarkstring否备注xmdc050statusstring否状态码1.一般2.正常结案3.长结4.短结5.留置6.已排产7.已作废1xmdc045so_delivery_detail—是订单交期明细档(子单身节点,支持多数组)so_seqnumeric否项次1xmddseqso_sub_seqnumeric否项序1xmddseq1batch_seqnumeric否分批序1xmddseq2item_nostring是料件编号0000xmdd001item_feature_nostring否产品特征xmdd002component_featurestring否子件特性1.一般2.CKD3.SKD4.可选件5.附属零件6.备品7.包装容器8.委外代买9.样品10.拆件主件11.拆件元件1xmdd00312.联产品13.副产品/回收料14.多产出主件sales_unit_nostring是销售单位PCSxmdd004so_qtynumeric否订购总数量10xmdd005so_batch_qtynumeric否分批订购数量10xmdd006so_due_datedate否约定交货日期格式:yyyy-mm-dd2023-05-31xmdd011receive_datedate否预计签收日期格式:yyyy-mm-ddxmdd012sales_notice_qtynumeric否已转出通数量0xmdd031shipping_qtynumeric否已出货量0xmdd014shipping_return_qtynumeric否已销退量0xmdd015shipping_return_change_qtynumeric否销退换货数量0xmdd016reference_unit_nostring否分批参考单位xmdd024reference_qtynumeric否分批参考数量0xmdd025valuation_unitstring否分批计价单位PCSxmdd026valuation_qtynumeric否分批计价数量10xmdd027trans_curr_not_tax_amountnumeric否分批未税金额171xmdd028trans_curr_tax_amountnumeric否分批含税金额200xmdd029trans_curr_taxnumeric否分批税额29xmdd030Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:1f041a6d-b348-4cac-b863-9e20319997dbdigi-protocol:rawdigi-srvver:1.0digi-srvcode:000{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"so_master":[{"om_company_id":"营运公司编号","so_no":"订单单号","version":"版次","doc_type":"单别","doc_type_name":"单别名称","so_date":"订单日期","sales_no":"业务人员","sales_name":"业务人员名称","sales_department_no":"业务部门","sales_department_name":"业务部门名称","customer_no":"客户编号","customer_name":"客户名称","customer_full_name":"客户全称","so_kind":"订单性质","source_type":"资料来源","source_no":"来源单号","payment_condition_no":"收款条件编号","payment_condition_name":"收款条件说明","trade_condition_no":"交易条件编号","trade_condition_name":"交易条件说明","tax_no":"税别编号","tax_name":"税别说明","tax_rate":"税率","is_price_tax":"单价含税否","currency":"币别","exchange_rate":"汇率","valuation_method_no":"取价方式编号","valuation_method_name":"取价方式说明","customer_contractor_no":"客户连络人编号","customer_contractor_name":"客户连络人名称","sales_channel_no":"销售通路编号","sales_channel_name":"销售通路说明","retain_cause_no":"留置原因代码","retain_cause_name":"留置原因说明","customer_so_no":"客户订购单号","invoice_type":"发票类型","invoice_type_name":"发票类型说明","total_trans_curr_not_tax_amount":"订单总未税金额","total_trans_curr_tax_amount":"订单总含税金额","total_trans_curr_tax":"订单总税额","rate_calculation_type":"汇率计算基准","delivery_address":"出货地址","delivery_address_desc":"出货地址说明","billing_address":"帐款地址","billing_address_desc":"帐款地址说明","confirmor":"审核者","confirm_date":"审核日","status":"状态码","remark":"备注","so_detail":[{"so_seq":"项次","item_no":"料件编号","item_name":"料件品名","item_spec":"料件规格","item_feature_no":"产品特征","item_feature_name":"产品特征说明","bom_feature":"BOM特性","component_feature":"子件特性","sales_unit_no":"销售单位","sales_unit_name":"销售单位名称","so_qty":"销售数量","reference_unit_no":"参考单位","reference_qty":"参考数量","valuation_unit":"计价单位","valuation_qty":"计价数量","so_due_date":"约定交货日","receive_date":"预定签收日","price":"单价","tax_no":"税别编号","tax_name":"税别说明","tax_rate":"税率","emergency":"急料","customer_item_no":"客户料号","warehouse_no":"仓库编号","warehouse_name":"仓库名称","storage_spaces_no":"储位","storage_spaces_name":"储位名称","lot_no":"批号","project_code":"项目编号","project_name":"项目名称","project_type_no":"项目类型","project_type_name":"项目类型名称","trans_curr_not_tax_amount":"未税金额","trans_curr_tax_amount":"含税金额","trans_curr_tax":"税额","customer_so_seq":"客户订单项次","remark":"备注","status":"状态码","so_delivery_detail":[{"so_seq":"项次","so_sub_seq":"项序","batch_seq":"分批序","item_no":"料件编号","item_feature_no":"产品特征","component_feature":"子件特性","sales_unit_no":"销售单位","so_qty":"订购总数量","so_batch_qty":"分批订购数量","so_due_date":"约定交货日期","receive_date":"预计签收日期","sales_notice_qty":"已转出通数量","shipping_qty":"已出货量","shipping_return_qty":"已销退量","shipping_return_change_qty":"销退换货数量","reference_unit_no":"分批参考单位","reference_qty":"分批参考数量","valuation_unit":"分批计价单位","valuation_qty":"分批计价数量","trans_curr_not_tax_amount":"分批未税金额","trans_curr_tax_amount":"分批含税金额","trans_curr_tax":"分批税额"}]}]}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP栏位srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程,并产生预期的结果(Basicflow)100:服务未按照正常流程执行,例如发生信息检核不通过等情况,导致无法完成预期的结果000参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0:正确<>0:FAIL(原因代码)anm-03078sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述[T100_message]查询无数据!Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:2ef583bc-69f9-41fc-a65f-02173863800bdigi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}