文章目录
- HOC与HSRM
- 合同业务
- hcbm_contract
- hcbm_contract_line
- hcbm_contract_trading
- hcbm_sign_archive
- hcbm_fulfill_receive_transaction
- hcbm_erpsync_invoice_head
- hcbm_erpsync_invoice_line
- hcbm_contract_relationship
- hcbm_fulfill_check_result_sync
- hcbm_change_ctr_base
- hcbm_change_header
- hcbm_change_ctr_line
- hcbm_change_ctr_payment
- hcbm_change_ctr_relationship
工作内容,不对外开放
HOC与HSRM
①根据hsrm订单号查询合同这边对应的合同号
SELECT
hc.contract_number 合同编号,
hcsos.srm_po_number srm订单号,
hc.creator 创建人,
hc.status_code 合同状态,
hef.value as '订单类型编码'