{ "dataSetName": "GI_public_publicService_GC", "tables": [ { "tableName": "GI", "columns": [ { "columnName": "ID", "caption": "ID", "type": "System.String" }, { "columnName": "BillCode", "caption": "单据编号", "type": "System.String" }, { "columnName": "BillDate", "caption": "业务日期", "type": "System.DateTime" }, { "columnName": "InvPeriod", "caption": "库存期间", "type": "System.String" }, { "columnName": "BillTypeID", "caption": "业务种类ID", "type": "System.String" }, { "columnName": "IMTypeID", "caption": "单据类型ID", "type": "System.String" }, { "columnName": "BizTypeID", "caption": "业务类型ID", "type": "System.String" }, { "columnName": "BizType", "caption": "业务类型", "type": "System.String" }, { "columnName": "IMOrgID", "caption": "库存组织ID", "type": "System.String" }, { "columnName": "BFOrgID.MasterOrganization_Code", "caption": "组织机构ID.主组织.编码.基础数据编码", "type": "System.String" }, { "columnName": "BFOrgID.MasterOrganization_Name", "caption": "组织机构ID.主组织.名称.基础数据名称", "type": "System.String" }, { "columnName": "AccOrgID.AccountingOrganization_Code", "caption": "核算组织ID.核算组织.组织编号", "type": "System.String" }, { "columnName": "AccOrgID.AccountingOrganization_Name", "caption": "核算组织ID.核算组织.组织名称", "type": "System.String" }, { "columnName": "IMWhID", "caption": "库存仓库设置ID", "type": "System.String" }, { "columnName": "WhID", "caption": "仓库ID", "type": "System.String" }, { "columnName": "WhName", "caption": "仓库", "type": "System.String" }, { "columnName": "WhCode", "caption": "仓库编号", "type": "System.String" }, { "columnName": "IMDeptID", "caption": "库存部门ID", "type": "System.String" }, { "columnName": "IMDept", "caption": "库存部门", "type": "System.String" }, { "columnName": "IMEmpID", "caption": "库管员ID", "type": "System.String" }, { "columnName": "IMEmp", "caption": "库管员", "type": "System.String" }, { "columnName": "BFEmpID", "caption": "经办人ID", "type": "System.String" }, { "columnName": "BFEmp", "caption": "经办人", "type": "System.String" }, { "columnName": "BFEmpTel", "caption": "经办人电话", "type": "System.String" }, { "columnName": "PickPurposeID", "caption": "领料用途ID", "type": "System.String" }, { "columnName": "PickPurpose", "caption": "领料用途", "type": "System.String" }, { "columnName": "ProductID", "caption": "产品", "type": "System.String" }, { "columnName": "PVersion", "caption": "产品版本", "type": "System.String" }, { "columnName": "PCode", "caption": "产品编号", "type": "System.String" }, { "columnName": "PName", "caption": "产品名称", "type": "System.String" }, { "columnName": "PSpecs", "caption": "产品规格", "type": "System.String" }, { "columnName": "PModel", "caption": "产品型号", "type": "System.String" }, { "columnName": "PNote", "caption": "产品描述", "type": "System.String" }, { "columnName": "PExContentID", "caption": "产品辅助ID", "type": "System.String" }, { "columnName": "PExContent", "caption": "产品辅助描述", "type": "System.String" }, { "columnName": "PFeatureID", "caption": "产品特征ID", "type": "System.String" }, { "columnName": "PFeature", "caption": "产品特征描述", "type": "System.String" }, { "columnName": "PBatchCode", "caption": "产品批次", "type": "System.String" }, { "columnName": "SrcOrgID", "caption": "来源组织ID", "type": "System.String" }, { "columnName": "SrcOrg", "caption": "来源组织", "type": "System.String" }, { "columnName": "SrcDeptID", "caption": "来源部门ID", "type": "System.String" }, { "columnName": "SrcDept", "caption": "来源部门", "type": "System.String" }, { "columnName": "SrcEmpID", "caption": "来源业务员ID", "type": "System.String" }, { "columnName": "SrcEmp", "caption": "来源业务员", "type": "System.String" }, { "columnName": "CustomerID", "caption": "客户ID", "type": "System.String" }, { "columnName": "Customer", "caption": "客户", "type": "System.String" }, { "columnName": "ShipToID", "caption": "送达方ID", "type": "System.String" }, { "columnName": "ShipTo", "caption": "送达方", "type": "System.String" }, { "columnName": "BillToID", "caption": "结算方ID", "type": "System.String" }, { "columnName": "BillTo", "caption": "结算方", "type": "System.String" }, { "columnName": "InterSPathID", "caption": "结算路径ID", "type": "System.String" }, { "columnName": "InterSPath", "caption": "结算路径", "type": "System.String" }, { "columnName": "PayerID", "caption": "付款方ID", "type": "System.String" }, { "columnName": "Payer", "caption": "付款方", "type": "System.String" }, { "columnName": "SalesChannelID", "caption": "销售渠道ID", "type": "System.String" }, { "columnName": "SalesChannelCode", "caption": "销售渠道编号", "type": "System.String" }, { "columnName": "SalesChannel", "caption": "销售渠道", "type": "System.String" }, { "columnName": "ProjectID", "caption": "项目ID", "type": "System.String" }, { "columnName": "ProjectCode", "caption": "项目编号", "type": "System.String" }, { "columnName": "Project", "caption": "项目", "type": "System.String" }, { "columnName": "WbsID", "caption": "项目任务ID", "type": "System.String" }, { "columnName": "WbsName", "caption": "项目任务", "type": "System.String" }, { "columnName": "MVState", "caption": "存货状态.存货状态", "type": "System.String" }, { "columnName": "IsRed", "caption": "是否红单", "type": "System.Boolean" }, { "columnName": "IsReturn", "caption": "是否退货", "type": "System.Boolean" }, { "columnName": "BlueGIID", "caption": "原蓝单ID", "type": "System.String" }, { "columnName": "BlueGICode", "caption": "原蓝单号", "type": "System.String" }, { "columnName": "BillState", "caption": "单据状态.状态", "type": "System.String" }, { "columnName": "AccountState", "caption": "记账状态.记账状态", "type": "System.String" }, { "columnName": "ReturnState", "caption": "退货状态.退货状态", "type": "System.String" }, { "columnName": "ClearFlag", "caption": "核销标志.核销标志", "type": "System.String" }, { "columnName": "ValState", "caption": "暂估状态.暂估状态", "type": "System.String" }, { "columnName": "CreditFrozen", "caption": "信用冻结.冻结状态", "type": "System.String" }, { "columnName": "CreditInfo", "caption": "冻结信息", "type": "System.String" }, { "columnName": "OriNote", "caption": "原始来源摘要", "type": "System.String" }, { "columnName": "SrcType", "caption": "来源业务种类", "type": "System.String" }, { "columnName": "SrcBizType", "caption": "来源业务类型", "type": "System.String" }, { "columnName": "SrcID", "caption": "来源ID", "type": "System.String" }, { "columnName": "SrcCode", "caption": "来源单号", "type": "System.String" }, { "columnName": "SrcNote", "caption": "来源摘要", "type": "System.String" }, { "columnName": "POID", "caption": "采购订单ID", "type": "System.String" }, { "columnName": "POCode", "caption": "采购订单号", "type": "System.String" }, { "columnName": "SOID", "caption": "销售订单ID", "type": "System.String" }, { "columnName": "SOCode", "caption": "销售订单号", "type": "System.String" }, { "columnName": "WOZID", "caption": "生产订单ID", "type": "System.String" }, { "columnName": "WOZCode", "caption": "生产订单号", "type": "System.String" }, { "columnName": "AllowRed", "caption": "允许红单", "type": "System.Boolean" }, { "columnName": "AllowOther", "caption": "允许他人修改", "type": "System.Boolean" }, { "columnName": "AllowManual", "caption": "允许手工录入", "type": "System.Boolean" }, { "columnName": "AutoSubmit", "caption": "自动提交", "type": "System.Boolean" }, { "columnName": "UseFlow", "caption": "启用审批流", "type": "System.Boolean" }, { "columnName": "EditInFlow", "caption": "流程中修改", "type": "System.Boolean" }, { "columnName": "AutoInv", "caption": "自动出库", "type": "System.Boolean" }, { "columnName": "InvState", "caption": "出库状态.出入库状态", "type": "System.String" }, { "columnName": "ApproveFlowID", "caption": "审批流ID.流程实例", "type": "System.String" }, { "columnName": "SecLevelID", "caption": "密级ID", "type": "System.String" }, { "columnName": "SecLevel", "caption": "密级等级", "type": "System.Int32" }, { "columnName": "SecLevelName", "caption": "密级名称", "type": "System.String" }, { "columnName": "ItemCnt", "caption": "表体行数", "type": "System.Int32" }, { "columnName": "AttachmentCnt", "caption": "附件行数", "type": "System.Int32" }, { "columnName": "PrintCnt", "caption": "打印次数", "type": "System.Int32" }, { "columnName": "SumQty", "caption": "出库总数量", "type": "System.Decimal" }, { "columnName": "InvVoucherID", "caption": "库存凭证ID", "type": "System.String" }, { "columnName": "MVVoucherID", "caption": "存货凭证ID", "type": "System.String" }, { "columnName": "ExContentID", "caption": "辅助信息ID", "type": "System.String" }, { "columnName": "ExContent", "caption": "辅助信息描述", "type": "System.String" }, { "columnName": "ExChg", "caption": "辅助信息变更", "type": "System.String" }, { "columnName": "Remarks", "caption": "备注", "type": "System.String" }, { "columnName": "TimeStamp.CreatedBy", "caption": "时间戳.创建人", "type": "System.String" }, { "columnName": "TimeStamp.CreatedOn", "caption": "时间戳.创建时间", "type": "System.DateTime" }, { "columnName": "TimeStamp.LastChangedBy", "caption": "时间戳.最后修改人", "type": "System.String" }, { "columnName": "TimeStamp.LastChangedOn", "caption": "时间戳.最后修改时间", "type": "System.DateTime" }, { "columnName": "Version", "caption": "版本", "type": "System.DateTime" }, { "columnName": "ITODState", "caption": "内部交易状态.内部交易状态", "type": "System.String" }, { "columnName": "Ext_U_FOID_Lv9", "caption": "Ext_发运单内码_Lv9", "type": "System.String" }, { "columnName": "Ext_U_FOCODE_Lv9", "caption": "Ext_发运单编号_Lv9", "type": "System.String" }, { "columnName": "Ext_U_PRCTR_Lv9", "caption": "Ext_利润中心_Lv9", "type": "System.String" }, { "columnName": "IsAdvance", "caption": "是否代垫运费", "type": "System.Boolean" }, { "columnName": "Ext_U_SUMHANDLINGCHARGE_Lv9", "caption": "Ext_总装卸费分摊金额_Lv9", "type": "System.Decimal" }, { "columnName": "Ext_U_EXPENSETYPE_Lv9", "caption": "Ext_费用类型_Lv9", "type": "System.String" }, { "columnName": "Ext_U_SECTOR_Lv9", "caption": "Ext_所属板块_Lv9", "type": "System.String" }, { "columnName": "Ext_U_ISEAT_Lv9", "caption": "Ext_是否餐饮_Lv9", "type": "System.String" }, { "columnName": "Ext_U_APPLICATION_Lv9", "caption": "Ext_申请单编号_Lv9", "type": "System.String" }, { "columnName": "Ext_U_BILLCODE3RD_Lv9", "caption": "Ext_来源系统单号_Lv9", "type": "System.String" }, { "columnName": "Ext_U_BILLSOURCETYPE3RD_Lv9", "caption": "Ext_订单来源类型_Lv9", "type": "System.String" }, { "columnName": "Ext_U_FOBUSINESSTYPE_Lv9", "caption": "Ext_发运业务类型_Lv9", "type": "System.String" }, { "columnName": "Ext_U_SENDCARSTATE_Lv9", "caption": "Ext_派车状态_Lv9", "type": "System.String" }, { "columnName": "GenType", "caption": "生成方式.生成方式", "type": "System.String" }, { "columnName": "Ext_U_TAKEORDERSTATE_Lv9", "caption": "Ext_接单状态_Lv9", "type": "System.String" }, { "columnName": "Ext_U_TAKEORDERDATE_Lv9", "caption": "Ext_接单时间_Lv9", "type": "System.DateTime" }, { "columnName": "Ext_U_TAKEORDERORG_Lv9", "caption": "Ext_接单组织_Lv9", "type": "System.String" }, { "columnName": "Ext_U_TAKEORDERORGID_Lv9", "caption": "Ext_接单组织ID_Lv9", "type": "System.String" }, { "columnName": "Ext_U_RECEPTSTATE_Lv9", "caption": "Ext_经销商回执状态_Lv9", "type": "System.String" }, { "columnName": "Ext_U_PRCTRMC_Lv9", "caption": "Ext_利润中心名称_Lv9", "type": "System.String" }, { "columnName": "Ext_U_SENDWMSSTATUS_Lv9", "caption": "Ext_推送WMS状态_Lv9", "type": "System.String" } ], "newColumns": [], "rows": [ { "row": { "InvVoucherID": "191d56a1-dc31-4cdb-baf1-37262c41a57c", "Customer": "10-麦德龙（食用油、米面）普陀商场", "InvState": "Complete", "IMWhID": "358b7c14-d04e-689d-8446-4b39d214ae50", "SrcEmpID": "73b1df3e-5557-4d06-a31d-614e6fb6305f", "ReturnState": "None", "CustomerID": "44ca86a3-d033-4cb8-bc40-a1552a9a4842", "BFOrgID.MasterOrganization_Code": "0018150", "SecLevelName": null, "AutoInv": true, "SrcCode": "SO202307071173", "AccOrgID.AccountingOrganization_Code": "0018001", "SrcNote": "231860100123", "IMEmpID": null, "Ext_U_BILLCODE3RD_Lv9": null, "SrcID": "e619aa81-d13c-4e12-82a9-1f4d4e793ae7", "ID": "aaac298c-e252-413e-838c-da16656286ef", "BFEmp": null, "IMDeptID": null, "Ext_U_SUMHANDLINGCHARGE_Lv9": 0, "IMEmp": null, "Ext_U_FOID_Lv9": null, "BlueGICode": null, "WhCode": "sh150006", "BFEmpID": null, "Project": null, "SalesChannelCode": "00203", "PExContent": null, "Ext_U_SECTOR_Lv9": null, "PayerID": "44ca86a3-d033-4cb8-bc40-a1552a9a4842", "BizTypeID": "IM241", "AllowRed": true, "WhName": "上海分公司凯东源物流仓库", "SrcDeptID": "0018150A10102", "TimeStamp.CreatedOn": "2023-07-07T09:08:01.668+00:00", "Ext_U_TAKEORDERDATE_Lv9": null, "EditInFlow": false, "PickPurposeID": null, "PModel": null, "CreditInfo": "", "SrcBizType": "分公司销售订单", "Ext_U_FOBUSINESSTYPE_Lv9": "出库后发运", "Ext_U_TAKEORDERORG_Lv9": null, "IsReturn": false, "SOID": "e619aa81-d13c-4e12-82a9-1f4d4e793ae7", "OriNote": "231860100123", "ShipToID": "44ca86a3-d033-4cb8-bc40-a1552a9a4842", "InvPeriod": "2023.07", "Ext_U_EXPENSETYPE_Lv9": null, "WbsName": null, "BFEmpTel": null, "IMDept": null, "Ext_U_PRCTRMC_Lv9": "商贸普陀分公司", "UseFlow": false, "SecLevelID": null, "ItemCnt": 1, "BillCode": "S23070711730831", "BFOrgID.MasterOrganization_Name": "商贸上海分公司", "BlueGIID": null, "POCode": null, "SrcEmp": "李义环", "SOCode": "SO202307071173", "PFeatureID": null, "ITODState": "None", "PName": null, "Ext_U_SENDCARSTATE_Lv9": null, "ShipTo": "10-麦德龙（食用油、米面）普陀商场", "Ext_U_RECEPTSTATE_Lv9": null, "BillToID": "260c24cd-e5be-40e9-8acf-203eab671eea", "POID": null, "MVVoucherID": null, "BillTypeID": "GIDoc", "AllowOther": true, "ClearFlag": "None", "Remarks": null, "Version": "2023-07-08T00:17:29.088+00:00", "SrcOrg": "商贸普陀分公司", "BillTo": "山东鲁花集团商贸有限公司上海销售分公司", "SalesChannelID": "7f5af72e-f038-b0bf-886f-3789fa4fcc93", "SrcOrgID": "fedf9d68-1fbd-e42a-0d0a-ea1bed0a540f", "BillState": "Approved", "Payer": "10-麦德龙（食用油、米面）普陀商场", "MVState": "None", "IMOrgID": null, "TimeStamp.LastChangedOn": "2023-07-08T00:17:29.127+00:00", "IsAdvance": false, "BizType": "发出商品出库", "InterSPath": null, "AccountState": "None", "BillDate": "2023-07-06T16:00:00.000+00:00", "WOZCode": null, "PExContentID": null, "IMTypeID": "210", "Ext_U_BILLSOURCETYPE3RD_Lv9": null, "Ext_U_FOCODE_Lv9": null, "AccOrgID.AccountingOrganization_Name": "山东鲁花集团商贸有限公司", "CreditFrozen": "None", "PFeature": null, "TimeStamp.CreatedBy": "林琛", "Ext_U_TAKEORDERORGID_Lv9": null, "Ext_U_PRCTR_Lv9": "bc4d19fc-e4bd-45e9-954d-4656bb490fce", "InterSPathID": null, "ProjectID": null, "ExContent": null, "PrintCnt": 0, "AllowManual": true, "ExChg": "", "AutoSubmit": false, "SumQty": 1, "SalesChannel": "全国KA", "PBatchCode": null, "TimeStamp.LastChangedBy": "姜竹鹏", "Ext_U_APPLICATION_Lv9": null, "SrcType": "ScmSO", "Ext_U_ISEAT_Lv9": null, "PCode": null, "ProjectCode": null, "PickPurpose": null, "IsRed": false, "GenType": "Push", "PSpecs": null, "PVersion": null, "ValState": "None", "WhID": "dc658cd2-bcc0-429e-b5e8-4994753a48f9", "Ext_U_SENDWMSSTATUS_Lv9": "3", "SrcDept": "普陀分公司KAOTO业务2分部", "AttachmentCnt": 0, "ProductID": null, "PNote": null, "WOZID": null, "ApproveFlowID": null, "Ext_U_TAKEORDERSTATE_Lv9": null, "SecLevel": 0, "WbsID": null, "ExContentID": null } }, { "row": { "InvVoucherID": "5e35d1ec-cd31-4acb-b478-5fe85070067b", "Customer": "10-麦德龙（食用油、米面）普陀商场", "InvState": "Complete", "IMWhID": "358b7c14-d04e-689d-8446-4b39d214ae50", "SrcEmpID": "73b1df3e-5557-4d06-a31d-614e6fb6305f", "ReturnState": "None", "CustomerID": "44ca86a3-d033-4cb8-bc40-a1552a9a4842", "BFOrgID.MasterOrganization_Code": "0018150", "SecLevelName": null, "AutoInv": true, "SrcCode": "SO202307071156", "AccOrgID.AccountingOrganization_Code": "0018001", "SrcNote": "231860100118", "IMEmpID": null, "Ext_U_BILLCODE3RD_Lv9": null, "SrcID": "6dce3a33-b5ab-4934-8355-34678e17c315", "ID": "f112ca3f-4c4c-4bdf-9677-92cd3c860441", "BFEmp": null, "IMDeptID": null, "Ext_U_SUMHANDLINGCHARGE_Lv9": 0, "IMEmp": null, "Ext_U_FOID_Lv9": null, "BlueGICode": null, "WhCode": "sh150006", "BFEmpID": null, "Project": null, "SalesChannelCode": "00203", "PExContent": null, "Ext_U_SECTOR_Lv9": null, "PayerID": "44ca86a3-d033-4cb8-bc40-a1552a9a4842", "BizTypeID": "IM241", "AllowRed": true, "WhName": "上海分公司凯东源物流仓库", "SrcDeptID": "0018150A10102", "TimeStamp.CreatedOn": "2023-07-07T08:52:04.881+00:00", "Ext_U_TAKEORDERDATE_Lv9": null, "EditInFlow": false, "PickPurposeID": null, "PModel": null, "CreditInfo": "", "SrcBizType": "分公司销售订单", "Ext_U_FOBUSINESSTYPE_Lv9": "出库后发运", "Ext_U_TAKEORDERORG_Lv9": null, "IsReturn": false, "SOID": "6dce3a33-b5ab-4934-8355-34678e17c315", "OriNote": "231860100118", "ShipToID": "44ca86a3-d033-4cb8-bc40-a1552a9a4842", "InvPeriod": "2023.07", "Ext_U_EXPENSETYPE_Lv9": null, "WbsName": null, "BFEmpTel": null, "IMDept": null, "Ext_U_PRCTRMC_Lv9": "商贸普陀分公司", "UseFlow": false, "SecLevelID": null, "ItemCnt": 1, "BillCode": "S23070711560772", "BFOrgID.MasterOrganization_Name": "商贸上海分公司", "BlueGIID": null, "POCode": null, "SrcEmp": "李义环", "SOCode": "SO202307071156", "PFeatureID": null, "ITODState": "None", "PName": null, "Ext_U_SENDCARSTATE_Lv9": null, "ShipTo": "10-麦德龙（食用油、米面）普陀商场", "Ext_U_RECEPTSTATE_Lv9": null, "BillToID": "260c24cd-e5be-40e9-8acf-203eab671eea", "POID": null, "MVVoucherID": null, "BillTypeID": "GIDoc", "AllowOther": true, "ClearFlag": "None", "Remarks": null, "Version": "2023-07-08T00:20:45.871+00:00", "SrcOrg": "商贸普陀分公司", "BillTo": "山东鲁花集团商贸有限公司上海销售分公司", "SalesChannelID": "7f5af72e-f038-b0bf-886f-3789fa4fcc93", "SrcOrgID": "fedf9d68-1fbd-e42a-0d0a-ea1bed0a540f", "BillState": "Approved", "Payer": "10-麦德龙（食用油、米面）普陀商场", "MVState": "None", "IMOrgID": null, "TimeStamp.LastChangedOn": "2023-07-08T00:20:45.773+00:00", "IsAdvance": false, "BizType": "发出商品出库", "InterSPath": null, "AccountState": "None", "BillDate": "2023-07-06T16:00:00.000+00:00", "WOZCode": null, "PExContentID": null, "IMTypeID": "210", "Ext_U_BILLSOURCETYPE3RD_Lv9": null, "Ext_U_FOCODE_Lv9": null, "AccOrgID.AccountingOrganization_Name": "山东鲁花集团商贸有限公司", "CreditFrozen": "None", "PFeature": null, "TimeStamp.CreatedBy": "林琛", "Ext_U_TAKEORDERORGID_Lv9": null, "Ext_U_PRCTR_Lv9": "bc4d19fc-e4bd-45e9-954d-4656bb490fce", "InterSPathID": null, "ProjectID": null, "ExContent": null, "PrintCnt": 0, "AllowManual": true, "ExChg": "", "AutoSubmit": false, "SumQty": 1, "SalesChannel": "全国KA", "PBatchCode": null, "TimeStamp.LastChangedBy": "林琛", "Ext_U_APPLICATION_Lv9": null, "SrcType": "ScmSO", "Ext_U_ISEAT_Lv9": null, "PCode": null, "ProjectCode": null, "PickPurpose": null, "IsRed": false, "GenType": "Push", "PSpecs": null, "PVersion": null, "ValState": "None", "WhID": "dc658cd2-bcc0-429e-b5e8-4994753a48f9", "Ext_U_SENDWMSSTATUS_Lv9": "3", "SrcDept": "普陀分公司KAOTO业务2分部", "AttachmentCnt": 0, "ProductID": null, "PNote": null, "WOZID": null, "ApproveFlowID": null, "Ext_U_TAKEORDERSTATE_Lv9": null, "SecLevel": 0, "WbsID": null, "ExContentID": null } }, { "row": { "InvVoucherID": "be8e81aa-813b-4a52-b216-27ccdd61eaa6", "Customer": "上海永辉超市有限公司（昆山大仓）", "InvState": "Complete", "IMWhID": "358b7c14-d04e-689d-8446-4b39d214ae50", "SrcEmpID": "7e19c8fd-91ae-454c-b4cf-205eb9a148fe", "ReturnState": "None", "CustomerID": "b8d06cd5-b394-4a60-92e1-516ad3ab31b9", "BFOrgID.MasterOrganization_Code": "0018150", "SecLevelName": null, "AutoInv": true, "SrcCode": "SO202307070568", "AccOrgID.AccountingOrganization_Code": "0018001", "SrcNote": "4085810932", "IMEmpID": null, "Ext_U_BILLCODE3RD_Lv9": null, "SrcID": "e75f27ec-8837-4da5-aeae-0c027495a5e5", "ID": "b56a9518-5d74-4c4f-bf6f-bdc7ebebbfbb", "BFEmp": null, "IMDeptID": null, "Ext_U_SUMHANDLINGCHARGE_Lv9": 0, "IMEmp": null, "Ext_U_FOID_Lv9": null, "BlueGICode": null, "WhCode": "sh150006", "BFEmpID": null, "Project": null, "SalesChannelCode": "00203", "PExContent": null, "Ext_U_SECTOR_Lv9": null, "PayerID": "b8d06cd5-b394-4a60-92e1-516ad3ab31b9", "BizTypeID": "IM241", "AllowRed": true, "WhName": "上海分公司凯东源物流仓库", "SrcDeptID": "0018150A10701", "TimeStamp.CreatedOn": "2023-07-07T08:56:01.911+00:00", "Ext_U_TAKEORDERDATE_Lv9": null, "EditInFlow": false, "PickPurposeID": null, "PModel": null, "CreditInfo": "", "SrcBizType": "分公司销售订单", "Ext_U_FOBUSINESSTYPE_Lv9": "出库后发运", "Ext_U_TAKEORDERORG_Lv9": null, "IsReturn": false, "SOID": "e75f27ec-8837-4da5-aeae-0c027495a5e5", "OriNote": "4085810932", "ShipToID": "b8d06cd5-b394-4a60-92e1-516ad3ab31b9", "InvPeriod": "2023.07", "Ext_U_EXPENSETYPE_Lv9": null, "WbsName": null, "BFEmpTel": null, "IMDept": null, "Ext_U_PRCTRMC_Lv9": "商贸普陀分公司", "UseFlow": false, "SecLevelID": null, "ItemCnt": 21, "BillCode": "S23070705680794", "BFOrgID.MasterOrganization_Name": "商贸上海分公司", "BlueGIID": null, "POCode": null, "SrcEmp": "王涛", "SOCode": "SO202307070568", "PFeatureID": null, "ITODState": "None", "PName": null, "Ext_U_SENDCARSTATE_Lv9": null, "ShipTo": "上海永辉超市有限公司（昆山大仓）", "Ext_U_RECEPTSTATE_Lv9": null, "BillToID": "831bdd9b-8b39-4329-bfce-120adcffe8de", "POID": null, "MVVoucherID": null, "BillTypeID": "GIDoc", "AllowOther": true, "ClearFlag": "None", "Remarks": null, "Version": "2023-07-08T00:20:45.918+00:00", "SrcOrg": "商贸普陀分公司", "BillTo": "山东鲁花集团商贸有限公司上海分公司", "SalesChannelID": "7f5af72e-f038-b0bf-886f-3789fa4fcc93", "SrcOrgID": "fedf9d68-1fbd-e42a-0d0a-ea1bed0a540f", "BillState": "Approved", "Payer": "上海永辉超市有限公司（昆山大仓）", "MVState": "None", "IMOrgID": null, "TimeStamp.LastChangedOn": "2023-07-08T00:20:45.773+00:00", "IsAdvance": false, "BizType": "发出商品出库", "InterSPath": null, "AccountState": "None", "BillDate": "2023-07-06T16:00:00.000+00:00", "WOZCode": null, "PExContentID": null, "IMTypeID": "210", "Ext_U_BILLSOURCETYPE3RD_Lv9": null, "Ext_U_FOCODE_Lv9": null, "AccOrgID.AccountingOrganization_Name": "山东鲁花集团商贸有限公司", "CreditFrozen": "None", "PFeature": null, "TimeStamp.CreatedBy": "林琛", "Ext_U_TAKEORDERORGID_Lv9": null, "Ext_U_PRCTR_Lv9": "bc4d19fc-e4bd-45e9-954d-4656bb490fce", "InterSPathID": null, "ProjectID": null, "ExContent": null, "PrintCnt": 0, "AllowManual": true, "ExChg": "", "AutoSubmit": false, "SumQty": 36.708333, "SalesChannel": "全国KA", "PBatchCode": null, "TimeStamp.LastChangedBy": "林琛", "Ext_U_APPLICATION_Lv9": null, "SrcType": "ScmSO", "Ext_U_ISEAT_Lv9": null, "PCode": null, "ProjectCode": null, "PickPurpose": null, "IsRed": false, "GenType": "Push", "PSpecs": null, "PVersion": null, "ValState": "None", "WhID": "dc658cd2-bcc0-429e-b5e8-4994753a48f9", "Ext_U_SENDWMSSTATUS_Lv9": "3", "SrcDept": "普陀分公司经理部", "AttachmentCnt": 0, "ProductID": null, "PNote": null, "WOZID": null, "ApproveFlowID": null, "Ext_U_TAKEORDERSTATE_Lv9": null, "SecLevel": 0, "WbsID": null, "ExContentID": null } } ], "extendedProperties": { "isMaster": true } }, { "tableName": "GIItem", "columns": [ { "columnName": "ID", "caption": "ID", "type": "System.String" }, { "columnName": "ParentID", "caption": "单据ID", "type": "System.String" }, { "columnName": "RowNo", "caption": "行号", "type": "System.String" }, { "columnName": "MTypeID", "caption": "物料类型ID", "type": "System.String" }, { "columnName": "MType", "caption": "物料类型", "type": "System.String" }, { "columnName": "MaterialID", "caption": "物料ID", "type": "System.String" }, { "columnName": "MVersion", "caption": "物料版本", "type": "System.String" }, { "columnName": "MCode", "caption": "物料编号", "type": "System.String" }, { "columnName": "MName", "caption": "物料名称", "type": "System.String" }, { "columnName": "MSpecs", "caption": "物料规格", "type": "System.String" }, { "columnName": "MModel", "caption": "物料型号", "type": "System.String" }, { "columnName": "MNote", "caption": "物料描述", "type": "System.String" }, { "columnName": "MExContentID", "caption": "物料辅助ID", "type": "System.String" }, { "columnName": "MExContent", "caption": "物料辅助描述", "type": "System.String" }, { "columnName": "MFeatureID", "caption": "物料特征ID", "type": "System.String" }, { "columnName": "MFeature", "caption": "物料特征描述", "type": "System.String" }, { "columnName": "TargQty", "caption": "应收数量", "type": "System.Decimal" }, { "columnName": "Qty", "caption": "主数量", "type": "System.Decimal" }, { "columnName": "UnitID", "caption": "主计量单位ID", "type": "System.String" }, { "columnName": "Unit", "caption": "主计量单位", "type": "System.String" }, { "columnName": "UPrecision", "caption": "主计量精度", "type": "System.Int32" }, { "columnName": "TargSecQty", "caption": "应收辅数量", "type": "System.Decimal" }, { "columnName": "SecQty", "caption": "辅数量", "type": "System.Decimal" }, { "columnName": "SecUnitID", "caption": "辅计量单位ID", "type": "System.String" }, { "columnName": "SecUnit", "caption": "辅计量单位", "type": "System.String" }, { "columnName": "SecPrecision", "caption": "辅计量精度", "type": "System.Int32" }, { "columnName": "TargSecQty2", "caption": "应收辅数量2", "type": "System.Decimal" }, { "columnName": "SecQty2", "caption": "辅数量2", "type": "System.Decimal" }, { "columnName": "SecUnitID2", "caption": "辅计量单位2ID", "type": "System.String" }, { "columnName": "SecUnit2", "caption": "辅计量单位2", "type": "System.String" }, { "columnName": "SecPrecision2", "caption": "辅计量精度2", "type": "System.Int32" }, { "columnName": "ConvRule", "caption": "换算规则", "type": "System.String" }, { "columnName": "ConvRatio", "caption": "主辅换算率", "type": "System.String" }, { "columnName": "BatchMgr", "caption": "是否管理批次", "type": "System.Boolean" }, { "columnName": "BatchID", "caption": "批次ID", "type": "System.String" }, { "columnName": "BatchCode", "caption": "批次编号", "type": "System.String" }, { "columnName": "QLevelMgr", "caption": "是否管理质量等级", "type": "System.Boolean" }, { "columnName": "QLevelID", "caption": "质量等级ID", "type": "System.String" }, { "columnName": "QLevel", "caption": "质量等级", "type": "System.String" }, { "columnName": "SNMgr", "caption": "是否管理单件", "type": "System.Boolean" }, { "columnName": "SNCnt", "caption": "单件数", "type": "System.Int32" }, { "columnName": "SNUnitID", "caption": "单件计量单位ID", "type": "System.String" }, { "columnName": "SNUnit", "caption": "单件计量单位", "type": "System.String" }, { "columnName": "SNConvRatio", "caption": "单件计量换算率", "type": "System.String" }, { "columnName": "AccountTypeID", "caption": "账户类型ID", "type": "System.String" }, { "columnName": "AccountType", "caption": "账户类型", "type": "System.String" }, { "columnName": "StockStateID", "caption": "库存状态ID", "type": "System.String" }, { "columnName": "StockState", "caption": "库存状态", "type": "System.String" }, { "columnName": "StockTypeID.StockTypeUDT_StockTypeCode", "caption": "库存类型.库存类型.库存类型编号", "type": "System.String" }, { "columnName": "StockTypeID.StockTypeUDT_StockTypeName", "caption": "库存类型.库存类型.库存类型名称", "type": "System.String" }, { "columnName": "StockTypeID.StockTypeUDT_IsSub", "caption": "库存类型.库存类型.委外加工商", "type": "System.Boolean" }, { "columnName": "StockTypeID.StockTypeUDT_IsVC", "caption": "库存类型.库存类型.寄存供应商", "type": "System.Boolean" }, { "columnName": "StockTypeID.StockTypeUDT_IsCC", "caption": "库存类型.库存类型.寄售客户", "type": "System.Boolean" }, { "columnName": "StockTypeID.StockTypeUDT_IsSO", "caption": "库存类型.库存类型.销售订单", "type": "System.Boolean" }, { "columnName": "StockTypeID.StockTypeUDT_IsProject", "caption": "库存类型.库存类型.项目", "type": "System.Boolean" }, { "columnName": "StockTypeID.StockTypeUDT_IsOC", "caption": "库存类型.库存类型.代储货主客户", "type": "System.Boolean" }, { "columnName": "StockTypeID.StockTypeUDT_IsWBS", "caption": "库存类型.库存类型.WBS", "type": "System.Boolean" }, { "columnName": "StockTypeID.StockTypeUDT_IsDept", "caption": "库存类型.库存类型.部门", "type": "System.Boolean" }, { "columnName": "StockTypeID.StockTypeUDT_IsAsset", "caption": "库存类型.库存类型.资产", "type": "System.Boolean" }, { "columnName": "VendorID", "caption": "寄存供应商ID", "type": "System.String" }, { "columnName": "Vendor", "caption": "寄存供应商", "type": "System.String" }, { "columnName": "SubVendorID", "caption": "委外供应商ID", "type": "System.String" }, { "columnName": "SubVendor", "caption": "委外供应商", "type": "System.String" }, { "columnName": "CustomerID", "caption": "客户ID", "type": "System.String" }, { "columnName": "Customer", "caption": "客户", "type": "System.String" }, { "columnName": "OwnerCustID", "caption": "代储货主客户ID", "type": "System.String" }, { "columnName": "OwnerCust", "caption": "代储货主客户", "type": "System.String" }, { "columnName": "SalesOrderID", "caption": "销售订单ID", "type": "System.String" }, { "columnName": "SalesOrderCode", "caption": "销售订单编号", "type": "System.String" }, { "columnName": "ProjectID", "caption": "项目ID", "type": "System.String" }, { "columnName": "ProjectCode", "caption": "项目编号", "type": "System.String" }, { "columnName": "Project", "caption": "项目", "type": "System.String" }, { "columnName": "WbsID", "caption": "项目任务ID", "type": "System.String" }, { "columnName": "WbsName", "caption": "项目任务", "type": "System.String" }, { "columnName": "DeptID", "caption": "部门ID", "type": "System.String" }, { "columnName": "Dept", "caption": "部门", "type": "System.String" }, { "columnName": "AssetID", "caption": "资产ID", "type": "System.String" }, { "columnName": "Asset", "caption": "资产", "type": "System.String" }, { "columnName": "ContractID", "caption": "合同ID", "type": "System.String" }, { "columnName": "ContractCode", "caption": "合同编号", "type": "System.String" }, { "columnName": "IMWhID", "caption": "库存仓库设置ID", "type": "System.String" }, { "columnName": "WhID", "caption": "仓库ID", "type": "System.String" }, { "columnName": "WhName", "caption": "仓库", "type": "System.String" }, { "columnName": "BinID", "caption": "货位ID", "type": "System.String" }, { "columnName": "BinMgr", "caption": "是否管理货位", "type": "System.Boolean" }, { "columnName": "PileMgr", "caption": "是否管理垛号", "type": "System.Boolean" }, { "columnName": "BinCode", "caption": "货位编号", "type": "System.String" }, { "columnName": "BinName", "caption": "货位", "type": "System.String" }, { "columnName": "PileCode", "caption": "垛号", "type": "System.String" }, { "columnName": "MovementTypeID", "caption": "移动类型ID", "type": "System.String" }, { "columnName": "IsAccount", "caption": "库存记账", "type": "System.Boolean" }, { "columnName": "OppAccount", "caption": "关联类型库存管理", "type": "System.Boolean" }, { "columnName": "IsMVMgr", "caption": "存货核算", "type": "System.Boolean" }, { "columnName": "OppMVMgr", "caption": "关联类型存货核算", "type": "System.Boolean" }, { "columnName": "OppWhID", "caption": "关联仓库ID", "type": "System.String" }, { "columnName": "OppIMWhID", "caption": "关联库存仓库设置ID", "type": "System.String" }, { "columnName": "KeepDirection", "caption": "记账方向.记账方向", "type": "System.String" }, { "columnName": "OppStockType", "caption": "关联库存类型", "type": "System.String" }, { "columnName": "IsStrict", "caption": "严格控制", "type": "System.Boolean" }, { "columnName": "AccOrgID.AccountingOrganization_Code", "caption": "物权组织ID.核算组织.组织编号", "type": "System.String" }, { "columnName": "AccOrgID.AccountingOrganization_Name", "caption": "物权组织ID.核算组织.组织名称", "type": "System.String" }, { "columnName": "SrcAccOrg", "caption": "来源核算组织", "type": "System.String" }, { "columnName": "SrcAccOrgID", "caption": "来源核算组织ID", "type": "System.String" }, { "columnName": "KeyID", "caption": "记账对象ID", "type": "System.String" }, { "columnName": "AssKeyID", "caption": "辅助记账对象", "type": "System.String" }, { "columnName": "OriType", "caption": "原始来源类型", "type": "System.String" }, { "columnName": "OriID", "caption": "原始来源ID", "type": "System.String" }, { "columnName": "OriCode", "caption": "原始来源单号", "type": "System.String" }, { "columnName": "OriItemID", "caption": "原始来源行ID", "type": "System.String" }, { "columnName": "OriItemCode", "caption": "原始来源行号", "type": "System.String" }, { "columnName": "OriNote", "caption": "原始来源摘要", "type": "System.String" }, { "columnName": "SrcType", "caption": "来源类型", "type": "System.String" }, { "columnName": "SrcBizType", "caption": "来源业务类型", "type": "System.String" }, { "columnName": "SrcID", "caption": "来源ID", "type": "System.String" }, { "columnName": "SrcCode", "caption": "来源单号", "type": "System.String" }, { "columnName": "SrcItemID", "caption": "来源行ID", "type": "System.String" }, { "columnName": "SrcItemCode", "caption": "来源行号", "type": "System.String" }, { "columnName": "SrcNote", "caption": "来源摘要", "type": "System.String" }, { "columnName": "SrcTaskID", "caption": "来源任务ID", "type": "System.String" }, { "columnName": "BlueGIID", "caption": "原蓝单ID", "type": "System.String" }, { "columnName": "BlueGICode", "caption": "原蓝单号", "type": "System.String" }, { "columnName": "BlueGIItemID", "caption": "原蓝单行ID", "type": "System.String" }, { "columnName": "BlueGIItemCode", "caption": "原蓝单行号", "type": "System.String" }, { "columnName": "POID", "caption": "采购订单ID", "type": "System.String" }, { "columnName": "POCode", "caption": "采购订单号", "type": "System.String" }, { "columnName": "POItemID", "caption": "采购订单行ID", "type": "System.String" }, { "columnName": "POItemCode", "caption": "采购订单行号", "type": "System.String" }, { "columnName": "SOID", "caption": "来源销售订单ID", "type": "System.String" }, { "columnName": "SOCode", "caption": "来源销售订单号", "type": "System.String" }, { "columnName": "SOItemID", "caption": "来源销售订单行ID", "type": "System.String" }, { "columnName": "SOItemCode", "caption": "来源销售订单行号", "type": "System.String" }, { "columnName": "WOZID", "caption": "生产订单ID", "type": "System.String" }, { "columnName": "WOZCode", "caption": "生产订单编号", "type": "System.String" }, { "columnName": "WOID", "caption": "生产订单行ID", "type": "System.String" }, { "columnName": "WOCode", "caption": "生产订单行号", "type": "System.String" }, { "columnName": "ORItemID", "caption": "产出记录行ID", "type": "System.String" }, { "columnName": "IsVerify", "caption": "是否发票校验", "type": "System.Boolean" }, { "columnName": "InterSPathID", "caption": "结算路径ID", "type": "System.String" }, { "columnName": "InterSPath", "caption": "结算路径", "type": "System.String" }, { "columnName": "ClearQty", "caption": "核销数量", "type": "System.Decimal" }, { "columnName": "ClearFlag", "caption": "核销标志.核销标志", "type": "System.String" }, { "columnName": "NeedClearQty", "caption": "需核销数量", "type": "System.Decimal" }, { "columnName": "RecptState", "caption": "回执状态", "type": "System.String" }, { "columnName": "ValState", "caption": "暂估状态.暂估状态", "type": "System.String" }, { "columnName": "ReturnQty", "caption": "退货数量", "type": "System.Decimal" }, { "columnName": "ReturnState", "caption": "退货状态.退货状态", "type": "System.String" }, { "columnName": "MVState", "caption": "存货状态.存货状态", "type": "System.String" }, { "columnName": "VCQty", "caption": "寄存消耗汇总数量", "type": "System.Decimal" }, { "columnName": "VCState", "caption": "寄存消耗汇总状态", "type": "System.String" }, { "columnName": "AssCnt", "caption": "辅助行数量", "type": "System.Int32" }, { "columnName": "ExContentID", "caption": "辅助信息ID", "type": "System.String" }, { "columnName": "ExContent", "caption": "辅助信息描述", "type": "System.String" }, { "columnName": "ExChg", "caption": "辅助信息变更", "type": "System.String" }, { "columnName": "Price", "caption": "单价", "type": "System.Decimal" }, { "columnName": "Amount", "caption": "金额", "type": "System.Decimal" }, { "columnName": "CurrencyID", "caption": "币种", "type": "System.String" }, { "columnName": "Remarks", "caption": "备注", "type": "System.String" }, { "columnName": "SN", "caption": "单件信息", "type": "System.String" }, { "columnName": "ITODState", "caption": "内部交易状态.内部交易状态", "type": "System.String" }, { "columnName": "Ext_U_FACTFREIGHTCHARGE_Lv9", "caption": "Ext_实际运费_Lv9", "type": "System.Decimal" }, { "columnName": "Ext_U_DIFFSHAREAMT_Lv9", "caption": "Ext_运费结算差异分摊金额_Lv9", "type": "System.Decimal" }, { "columnName": "Ext_U_FOBOMID_Lv9", "caption": "Ext_发运单明细内码_Lv9", "type": "System.String" }, { "columnName": "TranQty", "caption": "已运输数量", "type": "System.Decimal" }, { "columnName": "TranFlag", "caption": "运输标志.运输标志", "type": "System.String" }, { "columnName": "Ext_U_HANDLINGCHARGE_Lv9", "caption": "Ext_装卸费分摊金额_Lv9", "type": "System.Decimal" }, { "columnName": "Ext_U_FONO_Lv9", "caption": "Ext_发运单编号_Lv9", "type": "System.String" }, { "columnName": "Ext_U_PRICE_Lv9", "caption": "Ext_出库含税单价_Lv9", "type": "System.Decimal" }, { "columnName": "Ext_U_TAXINVALUE_Lv9", "caption": "Ext_出库含税金额_Lv9", "type": "System.Decimal" }, { "columnName": "Ext_U_EXPRICE_Lv9", "caption": "Ext_出库不含税单价_Lv9", "type": "System.Decimal" }, { "columnName": "Ext_U_TAXEXVALUE_Lv9", "caption": "Ext_出库不含税金额_Lv9", "type": "System.Decimal" }, { "columnName": "Ext_U_TAXRATE_Lv9", "caption": "Ext_税率_Lv9", "type": "System.Decimal" }, { "columnName": "Ext_U_TAXVALUE_Lv9", "caption": "Ext_税额_Lv9", "type": "System.Decimal" }, { "columnName": "Ext_U_ENQUIRYQTY_Lv9", "caption": "Ext_要货数量_Lv9", "type": "System.Decimal" }, { "columnName": "Ext_U_BALANCEQTY_Lv9", "caption": "Ext_库存余额_Lv9", "type": "System.Decimal" }, { "columnName": "Ext_U_ISSUEDQTY_Lv9", "caption": "Ext_实发数量_Lv9", "type": "System.Decimal" }, { "columnName": "Ext_U_APPLICATION_Lv9", "caption": "Ext_采购申请单编号_Lv9", "type": "System.String" }, { "columnName": "CompQty", "caption": "复合计量数量", "type": "System.String" }, { "columnName": "CompUnit", "caption": "复合计量单位", "type": "System.String" }, { "columnName": "Ext_U_SENDCARSTATE_Lv9", "caption": "Ext_派车状态_Lv9", "type": "System.String" }, { "columnName": "Ext_U_ADJUSTPRICE_Lv9", "caption": "Ext_调整单价_Lv9", "type": "System.Decimal" }, { "columnName": "Ext_U_ORIPRICE_Lv9", "caption": "Ext_原含税单价_Lv9", "type": "System.Decimal" }, { "columnName": "Ext_U_CARNO_Lv9", "caption": "Ext_车牌号_Lv9", "type": "System.String" } ], "newColumns": [], "rows": [ { "row": { "SalesOrderCode": null, "Customer": "10-麦德龙（食用油、米面）普陀商场", "IMWhID": "358b7c14-d04e-689d-8446-4b39d214ae50", "ReturnState": "None", "MModel": null, "SecUnitID2": null, "WOCode": null, "SNMgr": false, "CustomerID": "44ca86a3-d033-4cb8-bc40-a1552a9a4842", "SNConvRatio": null, "StockTypeID.StockTypeUDT_IsAsset": false, "SrcCode": "SO202307071173", "ContractCode": null, "VCQty": 0, "AccOrgID.AccountingOrganization_Code": "0018001", "SrcNote": null, "Ext_U_EXPRICE_Lv9": 433.02752294, "QLevelMgr": false, "Asset": null, "SrcID": "e619aa81-d13c-4e12-82a9-1f4d4e793ae7", "MName": "压榨一级花生油", "ID": "6d850967-4e24-4790-b3da-1dc4c22a6e8a", "Ext_U_PRICE_Lv9": 472, "OriItemID": "cbc31d4d-de73-463d-963a-7ad41fb383cf", "MVersion": null, "QLevel": null, "Ext_U_DIFFSHAREAMT_Lv9": 0, "StockTypeID.StockTypeUDT_IsProject": false, "PileMgr": false, "SrcTaskID": null, "StockTypeID.StockTypeUDT_IsDept": false, "BinMgr": false, "Ext_U_TAXINVALUE_Lv9": 472, "BlueGICode": null, "StockTypeID.StockTypeUDT_StockTypeName": "普通库存", "StockTypeID.StockTypeUDT_IsSub": false, "Project": null, "BatchCode": null, "IsAccount": true, "StockTypeID.StockTypeUDT_IsVC": false, "SubVendor": null, "Ext_U_HANDLINGCHARGE_Lv9": 0, "OppMVMgr": true, "AssCnt": 0, "BatchMgr": false, "MType": "5S压榨一级花生油类（常规）", "IsVerify": true, "Dept": "普陀分公司KAOTO业务2分部", "Ext_U_ADJUSTPRICE_Lv9": 0, "CompUnit": "箱.瓶", "WhName": "上海分公司凯东源物流仓库", "TranFlag": "None", "SrcBizType": "分公司销售订单", "SOID": "e619aa81-d13c-4e12-82a9-1f4d4e793ae7", "Ext_U_CARNO_Lv9": null, "OwnerCustID": null, "BlueGIItemCode": null, "OriNote": null, "SN": "", "TargQty": 0, "StockStateID": "UR", "WbsName": null, "Ext_U_ISSUEDQTY_Lv9": 0, "UPrecision": 6, "StockTypeID.StockTypeUDT_IsSO": false, "VendorID": null, "Amount": 0, "SNUnit": null, "SecUnitID": "4a6705c5-416d-4660-8165-8a0437c9728e", "OppIMWhID": "00540aae-c125-c873-3ee5-2d16d767a3d8", "ConvRule": "HXHS", "SubVendorID": null, "Ext_U_ORIPRICE_Lv9": 0, "ORItemID": null, "IsStrict": false, "BlueGIID": null, "POCode": null, "SOCode": "SO202307071173", "RecptState": null, "ReturnQty": 0, "ITODState": "None", "StockTypeID.StockTypeUDT_IsCC": false, "Ext_U_SENDCARSTATE_Lv9": null, "MExContent": null, "MFeature": null, "BlueGIItemID": null, "POID": null, "ParentID": "aaac298c-e252-413e-838c-da16656286ef", "Ext_U_FACTFREIGHTCHARGE_Lv9": 0, "Ext_U_TAXVALUE_Lv9": 38.97, "SecPrecision2": 8, "MCode": "CP000007", "TargSecQty": 0, "Unit": "箱", "SrcAccOrg": "商贸上海销售分公司", "DeptID": "0018150A10102", "VCState": "None", "ConvRatio": "8/1", "BinID": null, "AccountTypeID": "36907c80-4254-6166-358c-109ce496fab4", "ClearFlag": "None", "SecQty2": 0, "Remarks": null, "StockTypeID.StockTypeUDT_StockTypeCode": "10", "Qty": 1, "Ext_U_FONO_Lv9": null, "PileCode": null, "SecQty": 8, "Ext_U_FOBOMID_Lv9": null, "MVState": "None", "OriType": "Input", "OppWhID": "bb7764ac-b194-39af-0151-f1ed9195ca74", "OppStockType": "4", "SNUnitID": null, "BinName": null, "InterSPath": null, "MovementTypeID": "IM241", "RowNo": "0001", "POItemCode": null, "QLevelID": null, "WOZCode": null, "OriCode": "SO202307071173", "OppAccount": false, "Price": 0, "SNCnt": 0, "MFeatureID": null, "ClearQty": 0, "MNote": null, "KeepDirection": "cred", "AccOrgID.AccountingOrganization_Name": "山东鲁花集团商贸有限公司", "Ext_U_TAXRATE_Lv9": 0.09, "MaterialID": "d9ae4e52-d34d-4e09-81e8-1a622e6cd88a", "TargSecQty2": 0, "BinCode": null, "POItemID": null, "BatchID": null, "InterSPathID": null, "ProjectID": null, "ExContent": null, "Ext_U_TAXEXVALUE_Lv9": 433.03, "KeyID": "747e6d61-b4d6-4634-85c6-5aee998bd74d", "ContractID": null, "ExChg": "", "SecUnit": "瓶", "Ext_U_APPLICATION_Lv9": null, "SecUnit2": null, "SrcType": "ScmSO", "SrcItemCode": "0001", "CompQty": "1.0", "ProjectCode": null, "SOItemID": "cbc31d4d-de73-463d-963a-7ad41fb383cf", "WOID": null, "AssetID": null, "OriItemCode": "0001", "MSpecs": "1.8L*8", "StockState": "自由", "ValState": "None", "WhID": "dc658cd2-bcc0-429e-b5e8-4994753a48f9", "SrcAccOrgID": "0018187", "SecPrecision": 0, "StockTypeID.StockTypeUDT_IsWBS": false, "Vendor": null, "Ext_U_BALANCEQTY_Lv9": 0, "StockTypeID.StockTypeUDT_IsOC": false, "IsMVMgr": true, "SOItemCode": "0001", "AccountType": "产成品", "CurrencyID": null, "OriID": "e619aa81-d13c-4e12-82a9-1f4d4e793ae7", "SrcItemID": "cbc31d4d-de73-463d-963a-7ad41fb383cf", "Ext_U_ENQUIRYQTY_Lv9": 0, "OwnerCust": null, "WOZID": null, "UnitID": "8c54f656-9d40-4b74-bbb1-d3a468bc3e03", "SalesOrderID": null, "TranQty": 0, "MTypeID": "535f31d9-145a-473a-b115-84cf0f726c23", "MExContentID": null, "NeedClearQty": 0, "WbsID": null, "ExContentID": null, "AssKeyID": "336abe7d-ce09-4dbc-a177-12a5c194e009" } }, { "row": { "SalesOrderCode": null, "Customer": "10-麦德龙（食用油、米面）普陀商场", "IMWhID": "358b7c14-d04e-689d-8446-4b39d214ae50", "ReturnState": "None", "MModel": null, "SecUnitID2": null, "WOCode": null, "SNMgr": false, "CustomerID": "44ca86a3-d033-4cb8-bc40-a1552a9a4842", "SNConvRatio": null, "StockTypeID.StockTypeUDT_IsAsset": false, "SrcCode": "SO202307071156", "ContractCode": null, "VCQty": 0, "AccOrgID.AccountingOrganization_Code": "0018001", "SrcNote": null, "Ext_U_EXPRICE_Lv9": 363.30275229, "QLevelMgr": false, "Asset": null, "SrcID": "6dce3a33-b5ab-4934-8355-34678e17c315", "MName": "低芥酸特香菜籽油", "ID": "c4ebf558-d0f8-42a6-be95-c1b3ec3019d7", "Ext_U_PRICE_Lv9": 396, "OriItemID": "f661a142-b451-4fad-9e4a-e046435a7305", "MVersion": null, "QLevel": null, "Ext_U_DIFFSHAREAMT_Lv9": 0, "StockTypeID.StockTypeUDT_IsProject": false, "PileMgr": false, "SrcTaskID": null, "StockTypeID.StockTypeUDT_IsDept": false, "BinMgr": false, "Ext_U_TAXINVALUE_Lv9": 396, "BlueGICode": null, "StockTypeID.StockTypeUDT_StockTypeName": "普通库存", "StockTypeID.StockTypeUDT_IsSub": false, "Project": null, "BatchCode": null, "IsAccount": true, "StockTypeID.StockTypeUDT_IsVC": false, "SubVendor": null, "Ext_U_HANDLINGCHARGE_Lv9": 0, "OppMVMgr": true, "AssCnt": 0, "BatchMgr": false, "MType": "低芥酸特香菜籽油类（常规）", "IsVerify": true, "Dept": "普陀分公司KAOTO业务2分部", "Ext_U_ADJUSTPRICE_Lv9": 0, "CompUnit": "箱.瓶", "WhName": "上海分公司凯东源物流仓库", "TranFlag": "None", "SrcBizType": "分公司销售订单", "SOID": "6dce3a33-b5ab-4934-8355-34678e17c315", "Ext_U_CARNO_Lv9": null, "OwnerCustID": null, "BlueGIItemCode": null, "OriNote": null, "SN": "", "TargQty": 0, "StockStateID": "UR", "WbsName": null, "Ext_U_ISSUEDQTY_Lv9": 0, "UPrecision": 6, "StockTypeID.StockTypeUDT_IsSO": false, "VendorID": null, "Amount": 0, "SNUnit": null, "SecUnitID": "4a6705c5-416d-4660-8165-8a0437c9728e", "OppIMWhID": "00540aae-c125-c873-3ee5-2d16d767a3d8", "ConvRule": "HXHS", "SubVendorID": null, "Ext_U_ORIPRICE_Lv9": 0, "ORItemID": null, "IsStrict": false, "BlueGIID": null, "POCode": null, "SOCode": "SO202307071156", "RecptState": null, "ReturnQty": 0, "ITODState": "None", "StockTypeID.StockTypeUDT_IsCC": false, "Ext_U_SENDCARSTATE_Lv9": null, "MExContent": null, "MFeature": null, "BlueGIItemID": null, "POID": null, "ParentID": "f112ca3f-4c4c-4bdf-9677-92cd3c860441", "Ext_U_FACTFREIGHTCHARGE_Lv9": 0, "Ext_U_TAXVALUE_Lv9": 32.69, "SecPrecision2": 8, "MCode": "CP004927", "TargSecQty": 0, "Unit": "箱", "SrcAccOrg": "商贸上海销售分公司", "DeptID": "0018150A10102", "VCState": "None", "ConvRatio": "4/1", "BinID": null, "AccountTypeID": "36907c80-4254-6166-358c-109ce496fab4", "ClearFlag": "None", "SecQty2": 0, "Remarks": null, "StockTypeID.StockTypeUDT_StockTypeCode": "10", "Qty": 1, "Ext_U_FONO_Lv9": null, "PileCode": null, "SecQty": 4, "Ext_U_FOBOMID_Lv9": null, "MVState": "None", "OriType": "Input", "OppWhID": "bb7764ac-b194-39af-0151-f1ed9195ca74", "OppStockType": "4", "SNUnitID": null, "BinName": null, "InterSPath": null, "MovementTypeID": "IM241", "RowNo": "0001", "POItemCode": null, "QLevelID": null, "WOZCode": null, "OriCode": "SO202307071156", "OppAccount": false, "Price": 0, "SNCnt": 0, "MFeatureID": null, "ClearQty": 0, "MNote": null, "KeepDirection": "cred", "AccOrgID.AccountingOrganization_Name": "山东鲁花集团商贸有限公司", "Ext_U_TAXRATE_Lv9": 0.09, "MaterialID": "9335a7f9-ad76-4498-a827-662e21e02462", "TargSecQty2": 0, "BinCode": null, "POItemID": null, "BatchID": null, "InterSPathID": null, "ProjectID": null, "ExContent": null, "Ext_U_TAXEXVALUE_Lv9": 363.31, "KeyID": "efd315b0-1995-49e0-a532-abb020207e56", "ContractID": null, "ExChg": "", "SecUnit": "瓶", "Ext_U_APPLICATION_Lv9": null, "SecUnit2": null, "SrcType": "ScmSO", "SrcItemCode": "0001", "CompQty": "1.0", "ProjectCode": null, "SOItemID": "f661a142-b451-4fad-9e4a-e046435a7305", "WOID": null, "AssetID": null, "OriItemCode": "0001", "MSpecs": "5L*4", "StockState": "自由", "ValState": "None", "WhID": "dc658cd2-bcc0-429e-b5e8-4994753a48f9", "SrcAccOrgID": "0018187", "SecPrecision": 0, "StockTypeID.StockTypeUDT_IsWBS": false, "Vendor": null, "Ext_U_BALANCEQTY_Lv9": 0, "StockTypeID.StockTypeUDT_IsOC": false, "IsMVMgr": true, "SOItemCode": "0001", "AccountType": "产成品", "CurrencyID": null, "OriID": "6dce3a33-b5ab-4934-8355-34678e17c315", "SrcItemID": "f661a142-b451-4fad-9e4a-e046435a7305", "Ext_U_ENQUIRYQTY_Lv9": 0, "OwnerCust": null, "WOZID": null, "UnitID": "8c54f656-9d40-4b74-bbb1-d3a468bc3e03", "SalesOrderID": null, "TranQty": 0, "MTypeID": "37bd495a-8c4c-4cc5-8bb2-0f232c117732", "MExContentID": null, "NeedClearQty": 0, "WbsID": null, "ExContentID": null, "AssKeyID": "336abe7d-ce09-4dbc-a177-12a5c194e009" } }, { "row": { "SalesOrderCode": null, "Customer": "上海永辉超市有限公司（昆山大仓）", "IMWhID": "358b7c14-d04e-689d-8446-4b39d214ae50", "ReturnState": "None", "MModel": null, "SecUnitID2": null, "WOCode": null, "SNMgr": false, "CustomerID": "b8d06cd5-b394-4a60-92e1-516ad3ab31b9", "SNConvRatio": null, "StockTypeID.StockTypeUDT_IsAsset": false, "SrcCode": "SO202307070568", "ContractCode": null, "VCQty": 0, "AccOrgID.AccountingOrganization_Code": "0018001", "SrcNote": null, "Ext_U_EXPRICE_Lv9": 180.53097345, "QLevelMgr": false, "Asset": null, "SrcID": "e75f27ec-8837-4da5-aeae-0c027495a5e5", "MName": "酱香酱油", "ID": "f825119d-f977-4bd4-ba8e-3ee96d8aa743", "Ext_U_PRICE_Lv9": 204, "OriItemID": "f459763e-63b6-4813-ae13-ad774c4f0d40", "MVersion": null, "QLevel": null, "Ext_U_DIFFSHAREAMT_Lv9": 0, "StockTypeID.StockTypeUDT_IsProject": false, "PileMgr": false, "SrcTaskID": null, "StockTypeID.StockTypeUDT_IsDept": false, "BinMgr": false, "Ext_U_TAXINVALUE_Lv9": 408, "BlueGICode": null, "StockTypeID.StockTypeUDT_StockTypeName": "普通库存", "StockTypeID.StockTypeUDT_IsSub": false, "Project": null, "BatchCode": null, "IsAccount": true, "StockTypeID.StockTypeUDT_IsVC": false, "SubVendor": null, "Ext_U_HANDLINGCHARGE_Lv9": 0, "OppMVMgr": true, "AssCnt": 0, "BatchMgr": false, "MType": "PET瓶装酱油类", "IsVerify": true, "Dept": "普陀分公司经理部", "Ext_U_ADJUSTPRICE_Lv9": 0, "CompUnit": "箱.瓶", "WhName": "上海分公司凯东源物流仓库", "TranFlag": "None", "SrcBizType": "分公司销售订单", "SOID": "e75f27ec-8837-4da5-aeae-0c027495a5e5", "Ext_U_CARNO_Lv9": null, "OwnerCustID": null, "BlueGIItemCode": null, "OriNote": null, "SN": "", "TargQty": 0, "StockStateID": "UR", "WbsName": null, "Ext_U_ISSUEDQTY_Lv9": 0, "UPrecision": 6, "StockTypeID.StockTypeUDT_IsSO": false, "VendorID": null, "Amount": 0, "SNUnit": null, "SecUnitID": "4a6705c5-416d-4660-8165-8a0437c9728e", "OppIMWhID": "00540aae-c125-c873-3ee5-2d16d767a3d8", "ConvRule": "HXHS", "SubVendorID": null, "Ext_U_ORIPRICE_Lv9": 0, "ORItemID": null, "IsStrict": false, "BlueGIID": null, "POCode": null, "SOCode": "SO202307070568", "RecptState": null, "ReturnQty": 0, "ITODState": "None", "StockTypeID.StockTypeUDT_IsCC": false, "Ext_U_SENDCARSTATE_Lv9": null, "MExContent": null, "MFeature": null, "BlueGIItemID": null, "POID": null, "ParentID": "b56a9518-5d74-4c4f-bf6f-bdc7ebebbfbb", "Ext_U_FACTFREIGHTCHARGE_Lv9": 0, "Ext_U_TAXVALUE_Lv9": 46.93, "SecPrecision2": 8, "MCode": "CP003564", "TargSecQty": 0, "Unit": "箱", "SrcAccOrg": "商贸上海分公司", "DeptID": "0018150A10701", "VCState": "None", "ConvRatio": "12/1", "BinID": null, "AccountTypeID": "36907c80-4254-6166-358c-109ce496fab4", "ClearFlag": "None", "SecQty2": 0, "Remarks": null, "StockTypeID.StockTypeUDT_StockTypeCode": "10", "Qty": 2, "Ext_U_FONO_Lv9": null, "PileCode": null, "SecQty": 24, "Ext_U_FOBOMID_Lv9": null, "MVState": "None", "OriType": "Input", "OppWhID": "bb7764ac-b194-39af-0151-f1ed9195ca74", "OppStockType": "4", "SNUnitID": null, "BinName": null, "InterSPath": null, "MovementTypeID": "IM241", "RowNo": "0021", "POItemCode": null, "QLevelID": null, "WOZCode": null, "OriCode": "SO202307070568", "OppAccount": false, "Price": 0, "SNCnt": 0, "MFeatureID": null, "ClearQty": 0, "MNote": null, "KeepDirection": "cred", "AccOrgID.AccountingOrganization_Name": "山东鲁花集团商贸有限公司", "Ext_U_TAXRATE_Lv9": 0.13, "MaterialID": "edc83873-6d9a-4b28-9539-d45f64071dab", "TargSecQty2": 0, "BinCode": null, "POItemID": null, "BatchID": null, "InterSPathID": null, "ProjectID": null, "ExContent": null, "Ext_U_TAXEXVALUE_Lv9": 361.07, "KeyID": "e5c22f0f-1450-48b4-87c2-76c3248773e9", "ContractID": null, "ExChg": "", "SecUnit": "瓶", "Ext_U_APPLICATION_Lv9": null, "SecUnit2": null, "SrcType": "ScmSO", "SrcItemCode": "0013", "CompQty": "2.0", "ProjectCode": null, "SOItemID": "f459763e-63b6-4813-ae13-ad774c4f0d40", "WOID": null, "AssetID": null, "OriItemCode": "0013", "MSpecs": "1L*12", "StockState": "自由", "ValState": "None", "WhID": "dc658cd2-bcc0-429e-b5e8-4994753a48f9", "SrcAccOrgID": "0018150", "SecPrecision": 0, "StockTypeID.StockTypeUDT_IsWBS": false, "Vendor": null, "Ext_U_BALANCEQTY_Lv9": 0, "StockTypeID.StockTypeUDT_IsOC": false, "IsMVMgr": true, "SOItemCode": "0013", "AccountType": "产成品", "CurrencyID": null, "OriID": "e75f27ec-8837-4da5-aeae-0c027495a5e5", "SrcItemID": "f459763e-63b6-4813-ae13-ad774c4f0d40", "Ext_U_ENQUIRYQTY_Lv9": 0, "OwnerCust": null, "WOZID": null, "UnitID": "8c54f656-9d40-4b74-bbb1-d3a468bc3e03", "SalesOrderID": null, "TranQty": 0, "MTypeID": "580a1ea3-7792-4d13-9153-af4f56b6e27b", "MExContentID": null, "NeedClearQty": 0, "WbsID": null, "ExContentID": null, "AssKeyID": "336abe7d-ce09-4dbc-a177-12a5c194e009" } } ], "extendedProperties": { "isMaster": false } } ] }