版权声明：本文为CSDN博主「维C°」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/MM2286088551/article/details/129839984
版权侵删
————————————————————————————————————————————————
自由项： 系统提供的用来描述物料特殊属性的工具。只有商品属性的物料可以设置自由项。
料品表：CBO_ItemMaster
MainItemCategory 主分类 CBO_Category表
Code 料号
Name 品名
SPECS 规格
CreatedBy 创建人
CreatedOn 创建时间
Modified By 修改 人
ModifiedOn 修改时间
org 组织
【基本】页签
【料品】
图号
分组领料码
销售产品分类 DescFlexField_PubDescSeg4
参考料号1 code1
参考料号2 code2
描述 Description
目录编号 CatalogNO
版本数量控制 IsVersionQtyControl
当前版本 Version
图片 Picture
【料品形态】
状态码 Status—— CBO_ItemStatus表
料品形态 ItemForm
ItemFormAttribute 料品形态属性
10 制造件
9 采购件
4 委外加工件
IsInventoryEnable 可库存交易
IsPurchaseEnable 可采购
IsSalesEnable 可销售
IsBuildEnable 可生产
IsOutsideOperationEnable 可委外
IsMRPEnable 可MRP
IsBOMEnable 可BOM
IsMFGConfigEnable 可选配
IsVMIEnable VMI标志
IsTrademark 厂牌管理—— CBO_ItemTradeMark表
厂牌（从料品厂牌表取）
可流向统计
【计量单位】
双数量
双单位
多单位
IsVarRatio 固定转换率
InventoryUOM 库存主单位
库存单位 InventorySecondUOM
销售单位 SalesUOM
采购单位 PurchaseUOM
计价单位 PriceUOM
生产单位 ManufactureUOM
领料单位 MaterialOutUOM
成本单位 CostUOM
成本币种 CostCurrency
参考成本 RefrenceCost
重量单位 WeightUom
库存单位重量 Weight
面积单位 BulkUom
库存单位面积 ItemBulk
【状态】
State 料品状态 0：待核准/1：核准中/2：已核准：
Effective_IsEffective 有效性 0：失效/1：有效
Effective_EffectiveDate 生效日期
Effective_DisableDate 失效日期
【库存】页签 CBO_InventoryInfo（料品库存相关信息表）
【存储地点】
存储地点限制 IsLimitWarehouse
存储地点 Warehouse CBO_Wh表
业务员 WarehouseManager
库位限制 IsLimitBin
库位 Bin
拣货规则 PickingRule
理货规则 PutawayRule
【库存控制】
允许负库存 IsNegativeInventory
预留 IsReservable
预留方式 ReserveMode
预留天数 ReserveDays
成套收发货 IsKitMustWholeSet
采购控制方法 PurchaseControlMode
周转率 TurnOverRate
平均用量天数 AvgUsageQtyCalDays
周转天数 TurnOverDays
渠道库存滞销检查 IsCanalBinUnMarkCheck
库存单位标箱 StandardBox
项目存活核算 IsBalanceByProject
专用料 IsSpecialItem,--料品表中的字段展示在库存信息页签中
厂牌存货核算 IsInvCalculateByTradeMark
番号存货核算 IsInvCalculateBySeiban
版本存货核算 IsInvCalculateByVersion
配送计价分组 DeliveryPriceGroup
转换率加权 ConvertRatio
加权转换率取值时机 TakeConvertRatioWhen
库存单位结存数量为0时成本单位结存数量必须为0 InvCostUOMSettleNumberZero
包装方案 PackagingScheme
【批号序列号】
批号参数 LotControlMode
批号有效期天数 LotValidDate
过期批号领料/出货 IsLotOverdueTransOut
批号允许过期天数 LotOverdueDays
序列号参数 SnParam
批号影响成本 IsCostCalByLot
【盘点方案】
零账存盘点 IsIncZeroQty
核准允差原则 ApprDiffRule
允差数量 ApprDiffQty
数量允差比 ApprDiffQtyRate
允差金额 ApprDiffAmt
金额允差比 ApprDiffAmtRate
【采购】页签 CBO_PurchaseInfo表
【采购】
PurchaseDepartment 部门
Buyer 业务员
PurchaseTaxSchedule 税组合
IsNeedRequest 请购
核准供应商
Supplier 主供应商
IsConfirmOnFinished 可事后定价
IsPriceByQuality 以质论价
PurchaseBatchQty 采购倍量
MinRcvQty 最小叫货量
MaxLimitPriceSource 最高限价来源
MaxLimitPrice 最高限价
MaxlimitCurrency 限价币种
QuotaLimitValue 配额阀值
IsReceiptSourceControl 进货货源控管
IsReturnSourceControl 退货货源控管
ReturnPriceSource 退货取价来源
【询价】
IsNeedInquire 询价
InquireRule 询价策略
InquireFixedPeriod 间隔期
RFQType 询价类
PurchaseQuotaMode 配额方式
IsSupplierConfirm 供应商确认
QuotaSupplier 配额供应商
PriceSource 取价来源
IsTotalAgreementPurchase 一揽子协议采购
StatisticPeriod 配额统计期间
QuotaStatisticsPeriodRule 配额统计期间规则
StatRule 统计期间规则
【收货】
ReceiptMode 收货程序
ReceiptModeAllowModify 收货程序可改
ReceiptType 收货方式
ReceiptRule 收货原则
ChargeAssignMode 费用分配
ChargeProcessMode 费用料处理
破坏性检验数量
【预算】
BudgetControlType 预算控制方式
【销售】页签 CBO_SaleInfo 表
【基本】
SalesDepartment 部门
SalesPerson 业务员
SaleTaxSchedule 税组合
SalePriceList 价目表 --SPR_SalePriceList_Trl 销售价表 SPR_SalePriceLine 销售价表行
SaleBatchQty 订货批量
MinSaleQty 最小订购量
MaxSaleQty 最大订购量
IsATPCheck ATP检查
ATPRule ATP规则
IsAvailableQtyCheck 可用量检查
AvailableQtyRule 可用量规则
IsCTP CTP检查
GrossRate 毛利率
BOMOrg BOM组织
开票组织
NameForInvoice 开票品名
CommodityTaxCode 税收分类编码
AllowAutoGetNum 允许自动生成番号
【系列件】
FamilyLayer 系列件层级
FamilyAdscription 所属系列件
【限价】
LimitPriceMode 限价方式
LimitPriceBy 限价依据
MinLimitPrice 最低限价
MaxLimitPrice 最高限价
MinLimitPriceRate 最低限价百分比
MaxLimitPriceRate 最高限价百分比
SaleLimitCurrency 限价币种
SaleMinDiscount 销售最低扣率
IsDiscount 是否折扣
IsAdjustPriceAfterShip 出货后续调价
【供应】
SupplySource 供应来源
SupplyOrg 供应组织
Supplier 供应商
DemandTransType 供应类型
ShipmentWarehouse 出货地点
【退货】
IsReturnable 可退换
IsRMAAllowModify 退货可改
【库存规划】页签 CBO_InventoryInfo 表
【库存规划】
InventoryPlanningMethod 规划方法
InventoryPlanTime 规划时机
IsRequiredShipperSupply 按需求货主补货
SupplyMethod 补货方法
InvToPurMode 规划转采购方式
SafetyStockType 安全存量法
SafetyStockPeriod 安全库存期
SafetyStockRate 安全库存量百分比
SafetyStockQty 安全库存量
InventoryMaxLimitQty 库存上限
InventoryMinLimitQty 库存下限
ReorderQty 再订货量
FixPeriod 固定期间（天）
NextSupplyDate 下次补货日
WastageRate 损耗率
OrderCost 订单成本
InventoryCostRate 持货成本百分比
EconomyOrderQty 经济订购量
TimeBucket 时格
【计划】页签 CBO_MrpInfo 表
【MRP方法】
MRPPlanningType 计划方法
ForecastContorlType 预测控制
IsTraceRequirement 需求追溯
RearrangeTimeFence 重排时界
OverRunRatio 超量百分比
IsReduceMPS 减少MPS
【计划时界】
PlanningTimeFenceRuleType 计划时界原则
PlanningTimeFence 计划时界类型
PlanningTimeFenceDays 计划时界天数
【需求时界】
DemandTimeFenceRuleType 需求时界原则
DemandTimeFence 需求时界类型
DemandTimeFenceDays 需求时界天数
【发放时界】
ReleaseTimeFence 发放时界类型
ReleaseTimeFenceDays 发放时界天数
FirmPlannedMOTimeFence 计划订单天数
Planer 默认计划员
【BOM】 （ CBO_MfgInfo表中 ）
CommonRoutingMaterial 共享工艺物料
CommonBOMMaterial 共享BOM物料
IsECNControl ECN控制
BomControlMode BOM控制方式
LowLevelCode 低阶码
PictureCode 图号
【纬度配置】
番号 IsInheritBomMasterNo继承母项番号
DesignationRule 番号比对规则
IsControlByDC 需求分类
DemandRule 需求分类对比规则
【前置时间（天）】
PurForwardProcessLT 采购预提前期（天）
PurProcessLT 采购处理提前期（天）
PurBackwardProcessLT 采购后提前期（天）
FixedLT 固定提前期（天）
VarietyLT 变动提前期（天）
LTBatch 提前期批量
SumManufactureLT 制造提前期（天）
SumLT 汇总提前期（天）
SaleForwardProcessLT 销售预提前期（天）
SaleProcessLT 销售处理提前期（天）
SaleBackwardProcessLT 销售后提前期（天）
【生产】页签 CBO_MfgInfo 表
【生产量】
BuildQuanSelectType 生产数量选择
BuildBatch 生产批量
BuildMultiplier 生产倍量
BuildShrinkageRate 产出率
IsOutputControlFlag 产出控制
ProduceWasteRateType 生产损耗类型
ImmovableWaste 固定损耗
OperateType 排产方式
【发料】
IssueMaterialBatchQty 发料倍量
MinSupplyMaterialQty 最小发料量
SupplementMaterialBatchQty 补货倍量
IssueMaterialSafeStockQty 安全库存量
IssueMaterialSafeStockPeriod 安全库存期
IsAllowExcessMaterial 允许超额领料
IsSueOverType 备料超额类型
StandardMaterialScale 标准备料超额比例
StandardMaterialQty 备料标准超额量
IsMixLotControl 混批控制
【生产控制】
贵金属
PurchasePartMakeMode 采购件自制模式
PreOffsetTime 提前期偏置时间
TimeUom 时间单位
ProductDepartment 生产部门
OverFinishType 可超量完工类型
OverQty 完工超额量
OverRate 完工超额比例
MultiHierarchyExpandFlag 配套展开阶数
DefaultExpandLevel 默认展开阶数
KanbanDrive 看板驱动
CostElement 成本要素
MixTradeMark 混厂牌控制
【质检方案】页签 CBO_InspectionInfo表
信息描述
ReceiptInspectRule 进货质检
ShipInspectRule 出货质检
SaleReturnCheckupRule 退货质检
BuildCompleteCheckUpRule 完工质检
InStockInspectRule 在库质检
InspectPeriod 质检周期（天）
【贸易】页签 CBO_SaleInfo 表
【贸易路径】
SDTradePath 销售贸易路径
IsSDTradePathModify 销售贸易路径可改
SDRtnTradePath 销售退货贸易路径
IsSDRtnTradePathModify 销售退货贸易路径可改
采购贸易路径
采购贸易路径可改
采购退货贸易路径
采购退货贸易路径可改
【料品描述】 CBO_ItemMaster 表中
CustomNumber 海关编码
DrawbackRate 退税率
包装方式
货描中文
货描英文
【等级自由项】页签 CBO_ItemMaster 表中
【等级成分】
IsGradeControl 等级控制
StandardGrade 标准等级
StartGrade 起始等级
EndGrade 结束等级
IsCostCalByGrade 等级影响成本
IsPotencyControl 成分控制
StandardPotency 标准成分
StartPotency 起始成分
EndPotency 结束成分
IsCostCalByPotency 成分影响成本
【自由项】
ItemFreeDefs 自由项
影响价格
影响成本
影响应收
影响应付
影响发票
select A.[ID],a.Org,
A.[MasterOrg] AS [控制组织],
A.[StateUser] AS [提交人],
A.[StateTime] AS [提交日期],
-- A.[MrpInfo] AS [料品MRP相关信息],
-- A.[SaleInfo] AS [料品销售相关信息],
-- A.[PurchaseInfo] AS [料品采购相关信息],
-- A.[InventoryInfo] AS [料品库存相关信息],
-- A.[MfgInfo] AS [料品生产相关信息],
-- A.[InspectionInfo] AS [料品质量相关信息],
a.MainItemCategory as 主分类,
A42.[Code] AS [主分类_Code],
A43.[Name] AS [主分类_Name],
A44.[IsMain] AS [主分类体系],
A44.[IsShowItemByTree] AS [料品左树右表],
A44.[IsItemSegmentRule] AS [料品段使用规则],
a.code as 料号,a.Name as 料名,
a.SPECS as 规格,
a.CreatedBy as 创建人,a.CreatedOn as 创建时间,a.ModifiedBy as 修改人,a.ModifiedOn as 修改时间,
--【基本】页签
--【基本】页签-【料品】
--图号
--分组领料码
--A18.[AliasName] as [别名],A18.[DescFlexField_CombineName],
--A19.[Code] as [料品状态码], A20.[Name] as [料品状态码_Name],
a.DescFlexField_PubDescSeg4 as 销售产品分类,
a.Code2 as 参考料号,
a.SearchCode as 搜索码,
A18.[Description] as 描述,
a.CatalogNO as 目录编号,
CASE a.IsVersionQtyControl
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 版本数量控制,
a.VersionID,a.Version as 当前版本,
a.Picture as 照片,
--【基本】页签-【料品形态】
--A.[Status] AS [状态码],
-- A19.[Code] AS [状态码_Code],
-- A20.[Name] AS [状态码_Name],
--A.StatusLastModify AS [状态日期],
--a.ItemForm as 料品形态,
CASE a.ItemFormAttribute
WHEN 0 THEN '模型'
WHEN 1 THEN '按订单拣货'
WHEN 2 THEN '按订单装配'
WHEN 3 THEN '可选类'
WHEN 4 THEN '委外加工件'
WHEN 5 THEN '工序委外件'
WHEN 6 THEN '虚拟'
WHEN 7 THEN '计划'
WHEN 8 THEN '系列'
WHEN 9 THEN '采购件'
WHEN 10 THEN '制造件'
WHEN 11 THEN '最终装配件'
WHEN 12 THEN '套件'
WHEN 13 THEN '工艺'
WHEN 14 THEN '低值易耗品'
WHEN 15 THEN '商品'
WHEN 16 THEN '杂项料品'
WHEN 17 THEN '服务'
WHEN 18 THEN '资产'
WHEN 19 THEN '备件'
WHEN 20 THEN '配方'
WHEN 21 THEN '重复'
WHEN 22 THEN '费用性料品'
ELSE ''
END as 料品形态属性,
CASE a.IsInventoryEnable
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 可库存交易,
CASE a.IsPurchaseEnable
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 可采购,
CASE a.IsSalesEnable
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 可销售,
CASE a.IsBuildEnable
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 可生产,
CASE a.IsOutsideOperationEnable
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 可委外,
CASE a.IsMRPEnable
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 可MRP,
CASE a.IsBOMEnable
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 可BOM,
CASE a.IsMFGConfigEnable
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 可选配,
CASE a.IsVMIEnable
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as VMI标志,
CASE a.IsTrademark
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 厂牌管理,
A38.[Code] as [厂牌_Code], A39.[Name] as [厂牌],
CASE A.[IsCanFlowStat]
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as [可流向控制],
--【基本】页签-【计量单位】
A.[IsDualQuantity] AS 双数量,
A.[IsDualUOM] AS 双单位,
A.[IsMultyUOM] AS 多单位,
CASE A.[ConverRatioRule]
WHEN 0 THEN '标准转换率'
WHEN 1 THEN '特定转换率'
WHEN 2 THEN '先找特定再找标准'
ELSE ''
END AS [转换率策略],
a.IsVarRatio as 固定转换率,
a.InventoryUOM as 库存主单位,
A21.[Code] AS [库存主单位_Code],
A22.[Name] AS [库存主单位_Name],
A21.[Round_Precision] AS [库存主单位_精度],
A21.[Round_RoundType] AS [库存主单位_舍入类型],
A21.[Round_RoundValue] AS [库存主单位_舍入值],
A21.[UOMClass] AS [库存主单位_单位组],
a.InventorySecondUOM as 库存单位,
a.SalesUOM as 销售单位,
A8.[Code] AS [销售单位_Code],
A9.[Name] AS [销售单位_Name],
A8.[Round_Precision] AS [销售单位_精度],
A8.[Round_RoundType] AS [销售单位_舍入类型],
A8.[Round_RoundValue] AS [销售单位_舍入值],
A8.[UOMClass] AS [销售单位_单位组],
a.PurchaseUOM as 采购单位,
A6.[Code] AS [采购单位_Code],
A7.[Name] AS [采购单位_Name],
A6.[Round_Precision] AS [采购单位_精度],
A6.[Round_RoundType] AS [采购单位_舍入类型],
A6.[Round_RoundValue] AS [采购单位_舍入值],
A6.[UOMClass] AS [采购单位_单位组],
a.PriceUOM as 计价单位,
A14.[Code] AS [计价单位_Code],
A15.[Name] AS [计价单位_Name],
A14.[Round_Precision] AS [计价单位_精度],
A14.[Round_RoundType] AS [计价单位_舍入类型],
A14.[Round_RoundValue] AS [计价单位_舍入值],
A14.[UOMClass] AS [计价单位_单位组],
a.ManufactureUOM as 生产单位,
A10.[Code] AS [生产单位_Code],
A11.[Name] AS [生产单位_Name],
A10.[Round_Precision] AS [生产单位_精度],
A10.[Round_RoundType] AS [生产单位_舍入类型],
A10.[Round_RoundValue] AS [生产单位_舍入值],
A10.[UOMClass] AS [生产单位_单位组],
A10.RatioToBase AS [主副单位转换率],
A25.[ID] AS [ManufactureUOM_BaseUOM_ID],
A25.[Code] AS [ManufactureUOM_BaseUOM_Code],
A26.[Name] AS [ManufactureUOM_BaseUOM_Name],
a.MaterialOutUOM as 领料单位,
A12.[Code] AS [领料单位_Code],
A13.[Name] AS [领料单位_Name],
A12.[Round_Precision] AS [领料单位_精度],
A12.[Round_RoundType] AS [领料单位_舍入类型],
A12.[Round_RoundValue] AS [领料单位_舍入值],
A12.[UOMClass] AS [领料单位_单位组],
a.CostUOM as 成本单位,
A23.[Code] AS [成本单位_Code],
A24.[Name] AS [成本单位_Name],
A23.[Round_Precision] AS [成本单位_精度],
A23.[Round_RoundType] AS [成本单位_舍入类型],
A23.[Round_RoundValue] AS [成本单位_舍入值],
A23.[UOMClass] AS [成本单位_单位组],
A.[StandardBatchQty] AS [标准批量],
A.[StandardCost] AS [标准成本],
a.RefrenceCost as 参考成本,
A.[InternalTransCost] AS [内部转移成本],
A.[RecentlyCost] AS [最新成本],
A.[IsIncludedStockAsset] AS [存货资产],
A.[IsIncludedCostCa] AS [成本卷算],
A.[PlanCost] AS [计划价],
a.CostCurrency as 成本币种,
A16.[Code] AS [成本币种_Code],
A17.[Name] AS [成本币种_Name],
A16.[PriceRound_Precision] AS [成本币种_精度],
A16.[PriceRound_RoundType] AS [成本币种_舍入类型],
A16.[PriceRound_RoundValue] AS [成本币种_舍入值],
A16.[Symbol] AS [成本币种_货币符号],
a.WeightUom as 重量单位,
A4.[Round_Precision] AS [重量单位_精度],
A4.[Round_RoundType] AS [重量单位_舍入类型],
A4.[Round_RoundValue] AS [重量单位_舍入值],
A4.[UOMClass] AS [重量单位_单位组],
a.Weight as 库存单位重量,
A4.[Code] AS [库存单位重量_Code],
A5.[Name] AS [库存单位重量_Name],
a.BulkUom as 面积单位,
A1.[Code] AS [面积单位_Code],
A2.[Name] AS [面积单位_Name],
a.ItemBulk as 库存单位面积,
--【基本】页签-【状态】
a.State as 料品状态,
a.Effective_IsEffective as 有效性,
a.Effective_EffectiveDate as 生效日期,
a.Effective_DisableDate as 失效日期,
--【库存】页签
--【库存】页签-【存储地点】
CASE inv.IsLimitWarehouse
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 存储地点限制,
inv.Warehouse as 存储地点,
wh.Code as 存储地点_Code,
wh2.Name as 存储地点_Name,
inv.WarehouseManager as 仓库业务员,
ope.Code as 仓库业务员_Code,
ope2.Name as 仓库业务员_Name,
CASE inv.IsLimitBin
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 库位限制,
inv.Bin as 库位,
bin.Code as 库位_Code,
bin2.Name as 库位_Name,
inv.PickingRule as 拣货规则,
inv.PutawayRule as 理货规则,
--【库存】页签-【库存控制】
CASE inv.IsNegativeInventory
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 允许负库存,
CASE inv.IsReservable
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 预留,
CASE inv.ReserveMode
WHEN 0 THEN '硬预留'
WHEN 1 THEN '软预留'
ELSE ''
END as 预留方式,
inv.ReserveDays as 预留天数,
CASE inv.IsKitMustWholeSet
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 成套收发货,
CASE inv.PurchaseControlMode
WHEN 0 THEN '料品周转率'
WHEN 1 THEN '最高存量限制'
WHEN 2 THEN '料品周转期'
ELSE ''
END as 采购控制方法,
inv.TurnOverRate as 周转率,
inv.AvgUsageQty as 平均用量,
inv.AvgUsageQtyCalDays as 平均用量天数,
inv.TurnOverDays as 周转天数,
CASE inv.IsCanalBinUnMarkCheck
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 渠道库存滞销检查,
inv.StandardBox as 库存单位标箱,
CASE inv.IsBalanceByProject
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 项目存活核算,
CASE a.IsSpecialItem
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 专用料,--料品表中的字段展示在库存信息页签中
CASE inv.IsInvCalculateByTradeMark
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 厂牌存货核算,
CASE inv.IsInvCalculateBySeiban
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 番号存货核算,
CASE inv.IsInvCalculateByVersion
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 版本存货核算,
inv.DeliveryPriceGroup as 配送计价分组,
CASE inv.ConvertRatio
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 转换率加权,
CASE inv.TakeConvertRatioWhen
WHEN 0 THEN '保存'
WHEN 1 THEN '审核'
ELSE ''
END as 加权转换率取值时机,
CASE inv.InvCostUOMSettleNumberZero
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 库存单位结存数量为零时成本单位结存数量必须为零,
inv.PackagingScheme as 包装方案,
pac.Code as 包装方案_Code,
pac2.Name as 包装方案_Name,
--【库存】页签-【批号序列号】
CASE inv.LotControlMode
WHEN 0 THEN '全部控制'
WHEN 1 THEN '部分控制'
WHEN 2 THEN '无'
ELSE ''
END as 批号参数,
inv.LotValidDate as 批号有效期天数,
CASE inv.IsLotOverdueTransOut
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 过期批号领料出货,
inv.LotOverdueDays as 批号允许过期天数,
inv.SnParam as 序列号参数,
snp.code as 序列号参数_Code,
snp.name as 序列号参数_Name,
CASE inv.IsCostCalByLot
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 批号影响成本,
----【库存】页签-【盘点方案】
CASE inv.IsIncZeroQty
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 零账存盘点,
CASE inv.ApprDiffRule
WHEN 0 THEN '不检查允差'
WHEN 1 THEN '检查允差比率和绝对允差值'
WHEN 1 THEN '检查允差比率或绝对允差值'
ELSE ''
END as 核准允差原则,
inv.ApprDiffQty as 允差数量,
inv.ApprDiffQtyRate as 数量允差比,
inv.ApprDiffAmt as 允差金额,
inv.ApprDiffAmtRate as 金额允差比,
--【采购】页签
--【采购】页签-【采购】
pur.PurchaseDepartment as 部门,
dep.Code as 部门_Code,
dep2.Name as 部门_Name,
pur.Buyer as 采购业务员,
ope3.Code as 采购业务员_Code,
ope4.Name as 采购业务员_Name,
pur.PurchaseTaxSchedule as 税组合,
tax.Code as 税组合_Code,
tax2.Name as 税组合_Name,
CASE pur.IsNeedRequest
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 请购,
CASE pur.IsUseApproveSupplier
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 核准供货商,
pur.Supplier as 主供应商,
sup.Code as 采购主供应商_Code,
sup2.Name as 采购主供应商_Name,
CASE pur.IsConfirmOnFinished
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 可事后定价,
CASE pur.IsPriceByQuality
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 以质论价,
pur.PurchaseBatchQty as 采购倍量,
pur.MinRcvQty as 最小叫货量,
CASE pur.MaxLimitPriceSource
WHEN 0 THEN '手工'
WHEN 1 THEN '标准成本'
WHEN 2 THEN '最新一次采购价'
WHEN 3 THEN '最新询价'
ELSE ''
END as 最高限价来源,
pur.MaxLimitPrice as 最高限价,
pur.MaxlimitCurrency as 限价币种,
cur.Code as 限价币种_Code,
cur2.Name as 限价币种_Name,
pur.QuotaLimitValue as 配额阀值,
CASE pur.IsReceiptSourceControl
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 进货货源控管,
CASE pur.IsReturnSourceControl
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 退货货源控管,
CASE pur.ReturnPriceSource
WHEN 0 THEN '最近一次采购价'
WHEN 1 THEN '市价'
WHEN 2 THEN '手工录入'
WHEN 3 THEN '最新询价'
WHEN 4 THEN '参考成本'
ELSE ''
END as 退货取价来源,
--【采购】页签-【询价】
CASE pur.IsNeedInquire
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 询价,
CASE pur.InquireRule
WHEN 0 THEN '定期'
WHEN 1 THEN '每次'
ELSE ''
END as 询价策略,
pur.InquireFixedPeriod as 间隔期,
pur.RFQType as 询价类,
CASE pur.PurchaseQuotaMode
WHEN 0 THEN '主供应商优先'
WHEN 1 THEN '主供应商'
WHEN 2 THEN '顺序轮流分配'
WHEN 3 THEN '按消耗量分配'
WHEN 4 THEN '按固定比例分配'
WHEN 5 THEN '按动态比例分配'
WHEN 6 THEN '建议供应商'
WHEN 7 THEN '期间均衡动态比例'
ELSE ''
END as 配额方式,
CASE pur.IsSupplierConfirm
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 供应商确认,
CASE pur.QuotaSupplier
WHEN 0 THEN '全部'
WHEN 1 THEN '仅大批量采购'
WHEN 2 THEN '除小批量'
WHEN 3 THEN '除新开发'
ELSE ''
END as 配额供应商,
CASE pur.PriceSource
WHEN 0 THEN '最近一次采购价'
WHEN 1 THEN '市价'
WHEN 2 THEN '手工录入'
WHEN 3 THEN '最新询价'
ELSE ''
END as 取价来源,
CASE pur.IsTotalAgreementPurchase
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 一揽子协议采购,
CASE pur.StatisticPeriod
WHEN 0 THEN '上月'
WHEN 1 THEN '本月'
WHEN 2 THEN '近30天'
WHEN 3 THEN '上年'
WHEN 4 THEN '本年'
ELSE ''
END as 配额统计期间,
pur.QuotaStatisticsPeriodRule as 配额统计期间规则,
per.Code as 配额统计期间规则_Code,
per2.Name as 配额统计期间规则_Name,
pur.StatRule as 统计期间规则,
per3.Code as 统计期间规则_Code,
per4.Name as 统计期间规则_Name,
--【采购】页签-【收货】
CASE pur.ReceiptMode
WHEN 0 THEN '收货-入库'
WHEN 1 THEN '收货-点收-入库'
WHEN 2 THEN '收货-检验-入库'
WHEN 3 THEN '收货-点收-检验-入库'
WHEN 4 THEN '收货-入库-检验'
WHEN 5 THEN '收货-点收-入库-检验'
WHEN 6 THEN '收货-检验-点收-入库'
ELSE ''
END as 收货程序,
CASE pur.ReceiptModeAllowModify
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 收货程序可改,
CASE pur.ReceiptType
WHEN 0 THEN '收货至仓库'
WHEN 1 THEN '收货至线上仓'
WHEN 2 THEN '收货至工序'
WHEN 3 THEN '收货至固定资产'
WHEN 4 THEN '收货至费用'
ELSE ''
END as 收货方式,
pur.ReceiptRule as 收货原则,
rec.Code as 收货原则_Code,
rec2.Name as 收货原则_Name,
CASE pur.ChargeAssignMode
WHEN 0 THEN '数量'
WHEN 1 THEN '金额'
WHEN 2 THEN '重量'
WHEN 3 THEN '体积'
ELSE ''
END as 费用分配,
CASE pur.ChargeProcessMode
WHEN 0 THEN '领用进费用'
WHEN 1 THEN '收货一次进费用'
ELSE ''
END as 费用料处理,
--as 破坏性检验数量（没找到）,
--【采购】页签-【预算】
CASE pur.BudgetControlType
WHEN 0 THEN '自动控制'
WHEN 1 THEN '手工执行'
ELSE ''
END as 预算控制方式,
--【销售】页签-【基本】
sal.SalesDepartment as 销售部门,
dep3.Code as 销售部门_Code,
dep4.Name as 销售部门_Name,
sal.SalesPerson as 销售业务员,
ope5.Code as 销售业务员_Code,
ope6.Name as 销售业务员_Name,
sal.SaleTaxSchedule as 销售税组合,
tax3.Code as 销售税组合_Code,
tax4.Name as 销售税组合_Name,
sal.SalePriceList as 价目表, --SPR_SalePriceList_Trl 销售价表 SPR_SalePriceLine 销售价表行
sal.SaleBatchQty as 订货批量,
sal.MinSaleQty as 最小订购量,
sal.MaxSaleQty as 最大订购量,
CASE sal.IsATPCheck
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as ATP检查,
sal.ATPRule as ATP规则,
atp2.Name as ATP规则_Name,
CASE sal.IsAvailableQtyCheck
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 可用量检查,
sal.AvailableQtyRule as 可用量规则,
CASE sal.IsCTP
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as CTP检查,
sal.GrossRate as 毛利率,
sal.BOMOrg as BOM组织,
dep6.Name as BOM组织_Name,
sal.ItemForInvoice as 开票物料,
sal.NameForInvoice as 开票品名,
sal.CommodityTaxCode as 税收分类编码,
CASE sal.AllowAutoGetNum
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 允许自动生成番号,
--【销售】页签-【系列件】
CASE sal.FamilyLayer
WHEN 0 THEN '产品线'
WHEN 1 THEN '品牌'
WHEN 2 THEN '子品牌'
ELSE ''
END as 系列件层级,
sal.FamilyAdscription as 所属系列件, --CBO_ItemMaster 表
--【销售】页签-【限价】
CASE sal.LimitPriceMode
WHEN 0 THEN '定义绝对价格'
WHEN 1 THEN '按成本定义百分比'
ELSE ''
END as 限价方式,
CASE sal.LimitPriceBy
WHEN 0 THEN '参考成本'
WHEN 1 THEN '最新结存成本'
WHEN 2 THEN '最新采购成本'
ELSE ''
END as 限价依据,
sal.MinLimitPrice as 最低限价,
sal.MaxLimitPrice as 最高限价,
sal.MinLimitPriceRate as 最低限价百分比,
sal.MaxLimitPriceRate as 最高限价百分比,
sal.SaleLimitCurrency as 销售限价币种,
cur4.Name as 销售限价币种,
sal.SaleMinDiscount as 销售最低扣率,
CASE sal.IsDiscount
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 是否折扣,
CASE sal.IsAdjustPriceAfterShip
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 出货后续调价,
--【销售】页签-【供应】
CASE sal.SupplySource
WHEN 0 THEN '供应商'
WHEN 1 THEN '内部组织'
WHEN 2 THEN '关系企业'
WHEN 3 THEN '转生产制造'
WHEN 4 THEN '当前组织'
ELSE ''
END as 供应来源,
sal.SupplyOrg as 供应组织,
org2.Name as 供应组织_Name,
sal.Supplier as 供应商,
sup3.Code as 供应商_Code,
sup4.Name as 供应商_Name,
CASE sal.DemandTransType
WHEN 0 THEN '转当前组织采购'
WHEN 1 THEN '跨组织出货'
WHEN 2 THEN '转跨组织采购'
WHEN 3 THEN '转制令'
WHEN 4 THEN '当前组织出货'
WHEN 5 THEN '转外协'
ELSE ''
END as 供应类型,
sal.ShipmentWarehouse as 出货地点,
wh4.Name as 出货地点_Name,
--【销售】页签-【退货】
CASE sal.IsReturnable
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 可退换,
CASE sal.IsRMAAllowModify
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 退货可改,
--【库存规划】页签 CBO_InventoryInfo
--【库存规划】页签-【库存规划】
CASE inv.InventoryPlanningMethod
WHEN 0 THEN '最高最低点法'
WHEN 1 THEN '再订货点法'
WHEN 2 THEN '盘点补货法'
WHEN 3 THEN '固定期间法'
WHEN 4 THEN 'MRP规划'
WHEN 5 THEN '经济批量法'
WHEN 6 THEN '不使用物料规划'
ELSE ''
END as 规划方法,
CASE inv.InventoryPlanTime
WHEN 0 THEN '即时规划'
WHEN 1 THEN '批次规划'
ELSE ''
END as 规划时机,
CASE inv.IsRequiredShipperSupply
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 按需求货主补货,
CASE inv.SupplyMethod
WHEN 0 THEN '按上限/再订货量补货'
WHEN 1 THEN '按需求补货'
WHEN 2 THEN '按需求和上限/再订货量的较大量补货'
ELSE ''
END as 补货方法,
CASE inv.InvToPurMode
WHEN 0 THEN ''
WHEN 1 THEN ''
ELSE ''
END as 规划转采购方式,
CASE inv.SafetyStockType
WHEN 0 THEN ''
WHEN 1 THEN ''
ELSE ''
END as 安全存量法,
inv.SafetyStockPeriod as 安全库存期,
inv.SafetyStockRate as 安全库存量百分比,
inv.SafetyStockQty as 安全库存量,
inv.InventoryMaxLimitQty as 库存上限,
inv.InventoryMinLimitQty as 库存下限,
inv.ReorderQty as 再订货量,
inv.FixPeriod as 固定期间,
inv.NextSupplyDate as 下次补货日,
inv.WastageRate as 损耗率,
inv.OrderCost as 订单成本,
inv.InventoryCostRate as 持货成本百分比,
inv.EconomyOrderQty as 经济订购量,
inv.TimeBucket as 时格,
tim2.Name as 时格_Name,
--【计划】页签 CBO_MrpInfo 表
--【计划】页签-【MRP方法】
CASE mrp.MRPPlanningType
WHEN 0 THEN 'MPS(主生产计划)'
WHEN 1 THEN 'MRP'
WHEN 2 THEN 'LRP(批次需求计划)'
WHEN 3 THEN 'DRP'
WHEN 4 THEN 'DRP+MPS'
WHEN 5 THEN 'DRP+MRP'
ELSE ''
END as 计划方法,
CASE mrp.ForecastContorlType
WHEN 0 THEN '独立'
WHEN 1 THEN '独立与相关'
WHEN 2 THEN '无'
ELSE ''
END as 预测控制,
CASE mrp.IsTraceRequirement
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 需求追溯,
mrp.RearrangeTimeFence as 重排时界,
mrp.OverRunRatio as 超量百分比,
CASE mrp.IsReduceMPS
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 减少MPS,
--【计划】页签-【计划时界】
CASE mrp.PlanningTimeFenceRuleType
WHEN 0 THEN '客户订单'
WHEN 1 THEN '预测'
WHEN 2 THEN '订单或预测最大值'
WHEN 3 THEN '订单加预测'
ELSE ''
END as 计划时界原则,
CASE mrp.PlanningTimeFence
WHEN 0 THEN '累计汇总提前期'
WHEN 1 THEN '累计制造提前期'
WHEN 2 THEN '本层制造提前期'
WHEN 3 THEN '使用者定义'
ELSE ''
END as 计划时界类型,
mrp.PlanningTimeFenceDays as 计划时界天数,
--【计划】页签-【需求时界】
CASE mrp.DemandTimeFenceRuleType
WHEN 0 THEN '客户订单'
WHEN 1 THEN '预测'
ELSE ''
END as 需求时界原则,
CASE mrp.DemandTimeFence
WHEN 0 THEN '累计汇总提前期'
WHEN 1 THEN '累计制造提前期'
WHEN 2 THEN '本层制造提前期'
WHEN 3 THEN '使用者定义'
ELSE ''
END as 需求时界类型,
mrp.DemandTimeFenceDays as 需求时界天数,
--【计划】页签-【发放时界】
CASE mrp.ReleaseTimeFence
WHEN 0 THEN '累计汇总提前期'
WHEN 1 THEN '累计制造提前期'
WHEN 2 THEN '本层制造提前期'
WHEN 3 THEN '使用者定义'
WHEN 4 THEN '人工发放'
WHEN 5 THEN '使用看板'
ELSE ''
END as 发放时界类型,
mrp.ReleaseTimeFenceDays as 发放时界天数,
mrp.FirmPlannedMOTimeFence as 计划订单天数,
mrp.Planer as 默认计划员,
ope8.Name as 默认计划员_Name,
--【计划】页签-【BOM】（ CBO_MfgInfo as 表中）
mfg.CommonRoutingMaterial as 共享工艺物料, --对应CBO_ItemMaster表的ID
mfg.CommonBOMMaterial as 共享BOM物料, --对应CBO_ItemMaster表的ID
CASE mfg.IsECNControl
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as ECN控制,
CASE mfg.BomControlMode
WHEN 0 THEN '有效期'
WHEN 1 THEN '数量控制'
ELSE ''
END as BOM控制方式,
mfg.LowLevelCode as 低阶码,
mfg.PictureCode as 图号,
--【计划】页签-【纬度配置】
--mrp.番号 IsInheritBomMasterNo as 继承母项番号,
--mrp.DesignationRule as 番号比对规则,
CASE mrp.IsControlByDC
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 需求分类,
CASE mrp.DemandRule
WHEN 0 THEN '严格'
WHEN 1 THEN '非严格'
ELSE ''
END as 需求分类对比规则,
--【计划】页签-【前置时间（天）】,
mrp.PurForwardProcessLT as 采购预提前期,
mrp.PurProcessLT as 采购处理提前期,
mrp.PurBackwardProcessLT as 采购后提前期,
mrp.FixedLT as 固定提前期,
mrp.VarietyLT as 变动提前期,
mrp.LTBatch as 提前期批量,
mrp.SumManufactureLT as 制造提前期,
mrp.SumLT as 汇总提前期,
mrp.SaleForwardProcessLT as 销售提前期,
mrp.SaleProcessLT as 销售处理提前期,
mrp.SaleBackwardProcessLT as 销售后提前期,
--【生产】页签 CBO_MfgInfo
--【生产】页签-【生产量】
CASE mfg.BuildQuanSelectType
WHEN 0 THEN '依需求量'
WHEN 1 THEN '依生产批量'
ELSE ''
END as 生产数量选择,
mfg.BuildBatch as 生产批量,
mfg.BuildMultiplier as 生产倍量,
mfg.BuildShrinkageRate as 产出率,
CASE mfg.IsOutputControlFlag
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 产出控制,
CASE mfg.ProduceWasteRateType
WHEN 0 THEN '单一损耗率'
WHEN 1 THEN '阶梯损耗率'
ELSE ''
END as 生产损耗类型,
mfg.ImmovableWaste as 固定损耗,
mfg.FluctuantWaste as 变动损耗,
CASE mfg.OperateType
WHEN 0 THEN '倒排'
WHEN 1 THEN '正排'
WHEN 2 THEN '瓶颈排'
ELSE ''
END as 排产方式,
--【生产】页签-【发料】,
mfg.IssueMaterialBatchQty as 发料倍量,
mfg.MinSupplyMaterialQty as 最小发料量,
mfg.SupplementMaterialBatchQty as 补货倍量,
mfg.IssueMaterialSafeStockQty as 安全库存量,
mfg.IssueMaterialSafeStockPeriod as 安全库存期,
CASE mfg.IsAllowExcessMaterial
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 允许超额领料,
CASE mfg.IsSueOverType
WHEN 0 THEN '比例'
WHEN 1 THEN '数量'
WHEN 2 THEN '不控制'
ELSE ''
END as 备料超额类型,
mfg.StandardMaterialScale as 标准备料超额比例,
mfg.StandardMaterialQty as 备料标准超额量,
CASE mfg.IsMixLotControl
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 混批控制,
--【生产】页签-【生产控制】,
CASE mfg.IsByproduct
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 贵重金属,
CASE mfg.PurchasePartMakeMode
WHEN 0 THEN '制造件'
WHEN 1 THEN '虚拟件'
ELSE ''
END as 采购件自制模式,
mfg.PreOffsetTime as 提前期偏置时间,
mfg.TimeUom as 时间单位,
uom2.Name as 时间单位_Name,
mfg.ProductDepartment as 生产部门,
dep8.Name as 生产部门_Name,
CASE mfg.OverFinishType
WHEN 0 THEN '不可超量'
WHEN 1 THEN '固定数量'
WHEN 2 THEN '比例'
ELSE ''
END as 可超量完工类型,
mfg.OverQty as 完工超额量,
mfg.OverRate as 完工超额比例,
mfg.MultiHierarchyExpandFlag as 配套展开阶数,
mfg.DefaultExpandLevel as 默认展开阶数,
CASE mfg.KanbanDrive
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 看板驱动,
mfg.CostElement as 成本要素, --CBO_CostElement 成本要素表
CASE mfg.MixTradeMark
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 混厂牌控制,
--【质检方案】页签 CBO_InspectionInfo
--ins.QualityDescription as 质量信息描述,
ins.ReceiptInspectRule as 进货质检,
ins.ShipInspectRule as 出货质检,
ins.SaleReturnCheckupRule as 退货质检,
ins.BuildCompleteCheckUpRule as 完工质检,
ins.InStockInspectRule as 在库质检,
ins.InspectPeriod as 质检周期,
--【贸易】页签 CBO_SaleInfo表,
--【贸易】页签-【贸易路径】,
sal.SDTradePath as 销售贸易路径, --CBO_TradePath 贸易路径表
tra2.Name as 销售贸易路径_Name,
CASE sal.IsSDTradePathModify
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 销售贸易路径可改,
sal.SDRtnTradePath as 销售退货贸易路径,
tra4.Name as 销售退货贸易路径_Name,
CASE sal.IsSDRtnTradePathModify
WHEN 0 THEN '否'
WHEN 1 THEN '是'
ELSE ''
END as 销售退货贸易路径可改,
--采购贸易路径,
--采购贸易路径可改,
--采购退货贸易路径,
--采购退货贸易路径可改,
--【贸易】页签-【料品描述】 CBO_ItemMaster 表中,
A.[EntranceInfo] AS [进出口信息],--CBO_EntranceInfo表
a.CustomNumber as 海关编码,
a.DrawbackRate as 退税率,
A.[CustomTaxRate] AS [海关征税率],
A.[IsNeedLicence] AS [需许可证],
A.[NeedInspect] AS [需商检],
ent.PackType as 包装方式,
ent.DecriptionByChinese as 货描中文,
ent.DecriptionByEnglish as 货描英文,
--【等级自由项】页签 CBO_ItemMaster表中,
--【等级自由项】页签-【等级成分】,
a.IsGradeControl as 等级控制,
a.StandardGrade as 标准等级,
a.StartGrade as 起始等级,
a.EndGrade as 结束等级,
a.IsCostCalByGrade as 等级影响成本,
a.IsPotencyControl as 成分控制,
a.StandardPotency as 标准成分,
a.StartPotency as 起始成分,
a.EndPotency as 结束成分,
a.IsCostCalByPotency as 成分影响成本,
--【等级自由项】页签-【自由项】--(自由项目前没有存储)
--a.ItemFreeDefs as 自由项,
-- fre.IsEffectPrice as 影响价格,
-- fre.IsEffectCost as 影响成本,
-- fre.IsEffectAR as 影响应收,
-- fre.IsEffectAP as 影响应付,
-- fre.IsEffectTicket as 影响发票,
--【实体扩展字段】DescFlexField
--CombineName 组合名称
--ContextValue 上下文值
--PrivateDescSeg1 私有字段1
--PubDescSeg1 公共字段1
A.[DescFlexField_PubDescSeg1] AS [公共字段1],
--编码机构
A.[KeyFlexFieldStru] AS [编码机构],
A37.[Separator] AS [编码机构_分隔符],
A.[NameKeyFlexFieldStru] AS [名称关键性弹性域结构],
--
A.[IsSyncQuantity] AS [单位相同时数量同步],
--分类
A.[StockCategory] AS [库存分类],
A45.[Code] AS [库存分类_Code],
A46.[Name] AS [库存分类_Name],
A.[ProductionCategory] AS [生产分类],
A47.[Code] AS [生产分类_Code],
A48.[Name] AS [生产分类_Name],
A.[SaleCategory] AS [销售分类],
A49.[Code] AS [销售分类_Code],
A50.[Name] AS [销售分类_Name],
A.[PurchaseCategory] AS [采购分类],
A51.[Code] AS [采购分类_Code],
A52.[Name] AS [采购分类_Name],
A.[MRPCategory] AS [MRP分类],
A53.[Code] AS [MRP分类_Code],
A54.[Name] AS [MRP分类_Name],
A.[CostCategory] AS [成本分类],
A55.[Code] AS [成本分类_Code],
A56.[Name] AS [成本分类_Name],
A.[PriceCategory] AS [价格分类],
A57.[Code] AS [价格分类_Code],
A58.[Name] AS [价格分类_Name],
A.[AssetCategory] AS [财务分类],
A59.[Code] AS [财务分类_Code],
A60.[Name] AS [财务分类_Name],
A.[CreditCategory] AS [信用分类],
A61.[Code] AS [信用分类_Code],
A62.[Name] AS [信用分类_Name],
A.[IsMFGConfigEnable] AS [IsMFGConfigEnable],
A.[PictureRef] AS [图片Ref]
from CBO_ItemMaster as A
left join [Base_UOM] as A1 on (A.[BulkUom] = A1.[ID])
left join Base_Language as A3 on (A3.Effective_IsEffective = 1)
left join [CBO_ItemMaster_Trl] as A18 on (A18.SysMlFlag = A3.Code) and (A.[ID] = A18.[ID])
left join [CBO_ItemStatus] as A19 on (A.[Status] = A19.[ID])
left join [CBO_ItemStatus_Trl] as A20 on (A20.SysMlFlag = A3.Code) and (A19.[ID] = A20.[ID])
left join [Base_UOM_Trl] as A2 on (A2.SysMlFlag = A3.Code) and (A1.[ID] = A2.[ID])
left join [Base_UOM] as A4 on (A.[WeightUom] = A4.[ID])
left join [Base_UOM_Trl] as A5 on (A5.SysMlFlag = A3.Code) and (A4.[ID] = A5.[ID])
left join [Base_UOM] as A6 on (A.[PurchaseUOM] = A6.[ID])
left join [Base_UOM_Trl] as A7 on (A7.SysMlFlag = A3.Code) and (A6.[ID] = A7.[ID])
left join [Base_UOM] as A8 on (A.[SalesUOM] = A8.[ID])
left join [Base_UOM_Trl] as A9 on (A9.SysMlFlag = A3.Code) and (A8.[ID] = A9.[ID])
left join [Base_UOM] as A10 on (A.[ManufactureUOM] = A10.[ID])
left join [Base_UOM_Trl] as A11 on (A11.SysMlFlag = A3.Code) and (A10.[ID] = A11.[ID])
left join [Base_UOM] as A12 on (A.[MaterialOutUOM] = A12.[ID])
left join [Base_UOM_Trl] as A13 on (A13.SysMlFlag = A3.Code) and (A12.[ID] = A13.[ID])
left join [Base_UOM] as A14 on (A.[PriceUOM] = A14.[ID])
left join [Base_UOM_Trl] as A15 on (A15.SysMlFlag = A3.Code) and (A14.[ID] = A15.[ID])
left join [Base_Currency] as A16 on (A.[CostCurrency] = A16.[ID])
left join [Base_Currency_Trl] as A17 on (A17.SysMlFlag = A3.Code) and (A16.[ID] = A17.[ID])
left join [Base_UOM] as A21 on (A.[InventoryUOM] = A21.[ID])
left join [Base_UOM_Trl] as A22 on (A22.SysMlFlag = A3.Code) and (A21.[ID] = A22.[ID])
left join [Base_UOM] as A23 on (A.[CostUOM] = A23.[ID])
left join [Base_UOM_Trl] as A24 on (A24.SysMlFlag = A3.Code) and (A23.[ID] = A24.[ID])
left join [Base_UOM] as A25 on (A10.[BaseUOM] = A25.[ID])
left join [Base_UOM_Trl] as A26 on (A26.SysMlFlag = A3.Code) and (A25.[ID] = A26.[ID])
left join [Base_UOM] as A27 on (A12.[BaseUOM] = A27.[ID])
left join [Base_UOM_Trl] as A28 on (A28.SysMlFlag = A3.Code) and (A27.[ID] = A28.[ID])
left join [Base_UOM] as A29 on (A6.[BaseUOM] = A29.[ID])
left join [Base_UOM_Trl] as A30 on (A30.SysMlFlag = A3.Code) and (A29.[ID] = A30.[ID])
left join [Base_UOM] as A31 on (A14.[BaseUOM] = A31.[ID])
left join [Base_UOM_Trl] as A32 on (A32.SysMlFlag = A3.Code) and (A31.[ID] = A32.[ID])
left join [Base_UOM] as A33 on (A8.[BaseUOM] = A33.[ID])
left join [Base_UOM_Trl] as A34 on (A34.SysMlFlag = A3.Code) and (A33.[ID] = A34.[ID])
left join [Base_UOM] as A35 on (A21.[BaseUOM] = A35.[ID])
left join [Base_UOM_Trl] as A36 on (A36.SysMlFlag = A3.Code) and (A35.[ID] = A36.[ID])
left join [Base_KeyFlexFieldStru] as A37 on (A.[KeyFlexFieldStru] = A37.[ID])
left join [CBO_Supplier] as A38 on (A.[TradeMark] = A38.[ID])
left join [CBO_Supplier_Trl] as A39 on (A39.SysMlFlag = A3.Code) and (A38.[ID] = A39.[ID])
left join [Base_UOM] as A40 on (A.[InventorySecondUOM] = A40.[ID])
left join [Base_UOM_Trl] as A41 on (A41.SysMlFlag = A3.Code) and (A40.[ID] = A41.[ID])
left join [CBO_Category] as A42 on (A.[MainItemCategory] = A42.[ID])
left join [CBO_Category_Trl] as A43 on (A43.SysMlFlag = A3.Code) and (A42.[ID] = A43.[ID])
left join [CBO_CategoryType] as A44 on (A42.[CategorySystem] = A44.[ID])
left join [CBO_Category] as A45 on (A.[StockCategory] = A45.[ID])
left join [CBO_Category_Trl] as A46 on (A46.SysMlFlag = A3.Code) and (A45.[ID] = A46.[ID])
left join [CBO_Category] as A47 on (A.[ProductionCategory] = A47.[ID])
left join [CBO_Category_Trl] as A48 on (A48.SysMlFlag = A3.Code) and (A47.[ID] = A48.[ID])
left join [CBO_Category] as A49 on (A.[SaleCategory] = A49.[ID])
left join [CBO_Category_Trl] as A50 on (A50.SysMlFlag = A3.Code) and (A49.[ID] = A50.[ID])
left join [CBO_Category] as A51 on (A.[PurchaseCategory] = A51.[ID])
left join [CBO_Category_Trl] as A52 on (A52.SysMlFlag = A3.Code) and (A51.[ID] = A52.[ID])
left join [CBO_Category] as A53 on (A.[MRPCategory] = A53.[ID])
left join [CBO_Category_Trl] as A54 on (A54.SysMlFlag = A3.Code) and (A53.[ID] = A54.[ID])
left join [CBO_Category] as A55 on (A.[CostCategory] = A55.[ID])
left join [CBO_Category_Trl] as A56 on (A56.SysMlFlag = A3.Code) and (A55.[ID] = A56.[ID])
left join [CBO_Category] as A57 on (A.[PriceCategory] = A57.[ID])
left join [CBO_Category_Trl] as A58 on (A58.SysMlFlag = A3.Code) and (A57.[ID] = A58.[ID])
left join [CBO_Category] as A59 on (A.[AssetCategory] = A59.[ID])
left join [CBO_Category_Trl] as A60 on (A60.SysMlFlag = A3.Code) and (A59.[ID] = A60.[ID])
left join [CBO_Category] as A61 on (A.[CreditCategory] = A61.[ID])
left join [CBO_Category_Trl] as A62 on (A62.SysMlFlag = A3.Code) and (A61.[ID] = A62.[ID])
--相关信息表
--库存相关信息表
--left join [CBO_InventoryInfo] as inv on (A.[ID] = inv.[ItemMaster])
left join [CBO_InventoryInfo] as inv on (A.[InventoryInfo] = inv.[ID])
left join [CBO_Wh] as wh on (inv.[Warehouse] = inv.[ID])
left join [CBO_Wh_Trl] as wh2 on (wh2.SysMlFlag = A3.Code) and (wh.[ID] = wh2.[ID])
left join [CBO_Operators] as ope on (inv.[WarehouseManager] = ope.[ID])
left join [CBO_Operators_Trl] as ope2 on (ope2.SysMlFlag = A3.Code) and (ope.[ID] = ope2.[ID])
left join [CBO_Bin] as bin on (inv.[Bin] = bin.[ID])
left join [CBO_Bin_Trl] as bin2 on (bin2.SysMlFlag = A3.Code) and (bin.[ID] = bin2.[ID])
left join [CBO_PackageSchema] as pac on (inv.[PackagingScheme] = pac.[ID])
left join [CBO_PackageSchema_Trl] as pac2 on (pac2.SysMlFlag = A3.Code) and (pac.[ID] = pac2.[ID])
left join [CBO_SnParameter] as snp on (inv.[SnParam] = snp.[ID])
--库存规划相关信息
left join [CBO_TimeBucket] as tim on (inv.[TimeBucket] = tim.[ID])
left join [CBO_TimeBucket_Trl] as tim2 on (tim2.SysMlFlag = A3.Code) and (tim.[ID] = tim2.[ID])
--采购相关信息表
--left join [CBO_PurchaseInfo] as pur on (A.[ID] = pur.[ItemMaster])
left join [CBO_PurchaseInfo] as pur on (A.[PurchaseInfo] = pur.[ID])
left join [CBO_PurchaseInfo_Trl] as pur2 on (pur2.SysMlFlag = A3.Code) and (pur.[ID] = pur2.[ID])
left join [CBO_Department] as dep on (pur.[PurchaseDepartment] = dep.[ID])
left join [CBO_Department_Trl] as dep2 on (dep2.SysMlFlag = A3.Code) and (dep.[ID] = dep2.[ID])
left join [CBO_Operators] as ope3 on (pur.[Buyer] = ope3.[ID])
left join [CBO_Operators_Trl] as ope4 on (ope4.SysMlFlag = A3.Code) and (ope3.[ID] = ope4.[ID])
left join [CBO_TaxSchedule] as tax on (pur.[PurchaseTaxSchedule] = tax.[ID])
left join [CBO_TaxSchedule_Trl] as tax2 on (tax2.SysMlFlag = A3.Code) and (tax.[ID] = tax2.[ID])
left join [CBO_Supplier] as sup on (pur.[Supplier] = sup.[ID])
left join [CBO_Supplier_Trl] as sup2 on (sup2.SysMlFlag = A3.Code) and (sup.[ID] = sup2.[ID])
left join [Base_Currency] as cur on (pur.[MaxlimitCurrency] = cur.[ID])
left join [Base_Currency_Trl] as cur2 on (cur2.SysMlFlag = A3.Code) and (cur.[ID] = cur2.[ID])
left join [CBO_StatPeriodRule] as per on (pur.[QuotaStatisticsPeriodRule] = per.[ID])
left join [CBO_StatPeriodRule_Trl] as per2 on (per2.SysMlFlag = A3.Code) and (per.[ID] = per2.[ID])
left join [CBO_StatPeriodRule] as per3 on (pur.[StatRule] = per3.[ID])
left join [CBO_StatPeriodRule_Trl] as per4 on (per4.SysMlFlag = A3.Code) and (per3.[ID] = per4.[ID])
left join [CBO_ReceiptRule] as rec on (pur.[ReceiptRule] = rec.[ID])
left join [CBO_ReceiptRule_Trl] as rec2 on (rec2.SysMlFlag = A3.Code) and (rec.[ID] = rec2.[ID])
--销售相关信息表
left join [CBO_SaleInfo] as sal on (A.[SaleInfo] = sal.[ID])
left join [CBO_Department] as dep3 on (sal.[SalesDepartment] = dep3.[ID])
left join [CBO_Department_Trl] as dep4 on (dep4.SysMlFlag = A3.Code) and (dep3.[ID] = dep4.[ID])
left join [CBO_Operators] as ope5 on (sal.[SalesPerson] = ope5.[ID])
left join [CBO_Operators_Trl] as ope6 on (ope6.SysMlFlag = A3.Code) and (ope5.[ID] = ope6.[ID])
left join [CBO_TaxSchedule] as tax3 on (sal.[SaleTaxSchedule] = tax3.[ID])
left join [CBO_TaxSchedule_Trl] as tax4 on (tax4.SysMlFlag = A3.Code) and (tax3.[ID] = tax4.[ID])
left join [SPR_SalePriceList] as spl on (sal.[SalePriceList] = spl.[ID])
--left join [SPR_SalePriceList_Trl] as spl2 on (spl.SysMlFlag = A3.Code) and (spl.[ID] = spl2.[ID])
left join [CBO_ATPRule] as atp on (sal.[ATPRule] = atp.[ID])
left join [CBO_ATPRule_Trl] as atp2 on (atp2.SysMlFlag = A3.Code) and (atp.[ID] = atp2.[ID])
left join [CBO_Department] as dep5 on (sal.[BOMOrg] = dep5.[ID])
left join [CBO_Department_Trl] as dep6 on (dep6.SysMlFlag = A3.Code) and (dep5.[ID] = dep6.[ID])
left join [Base_Currency] as cur3 on (sal.[SaleLimitCurrency] = cur3.[ID])
left join [Base_Currency_Trl] as cur4 on (cur4.SysMlFlag = A3.Code) and (cur3.[ID] = cur4.[ID])
left join [Base_Organization] as org on (sal.[SupplyOrg] = org.[ID])
left join [Base_Organization_Trl] as org2 on (org2.SysMlFlag = A3.Code) and (org.[ID] = org2.[ID])
left join [CBO_Supplier] as sup3 on (sal.[Supplier] = sup3.[ID])
left join [CBO_Supplier_Trl] as sup4 on (sup4.SysMlFlag = A3.Code) and (sup3.[ID] = sup4.[ID])
left join [CBO_Wh] as wh3 on (sal.[ShipmentWarehouse] = wh3.[ID])
left join [CBO_Wh_Trl] as wh4 on (wh4.SysMlFlag = A3.Code) and (wh3.[ID] = wh4.[ID])
--贸易相关信息
left join [CBO_TradePath] as tra on (sal.[SDTradePath] = tra.[ID])
left join [CBO_TradePath_Trl] as tra2 on (tra2.SysMlFlag = A3.Code) and (tra.[ID] = tra2.[ID])
left join [CBO_TradePath] as tra3 on (sal.[SDRtnTradePath] = tra3.[ID])
left join [CBO_TradePath_Trl] as tra4 on (tra4.SysMlFlag = A3.Code) and (tra3.[ID] = tra4.[ID])
--MRP相关信息表
left join [CBO_MrpInfo] as mrp on (A.[MrpInfo] = mrp.[ID])
left join [CBO_Operators] as ope7 on (mrp.[Planer] = ope7.[ID])
left join [CBO_Operators_Trl] as ope8 on (ope8.SysMlFlag = A3.Code) and (ope7.[ID] = ope8.[ID])
--生产相关信息表
left join [CBO_MfgInfo] as mfg on (A.[MfgInfo] = mfg.[ID])
left join [Base_UOM] as uom on (mfg.[TimeUom] = uom.[ID])
left join [Base_UOM_Trl] as uom2 on (uom2.SysMlFlag = A3.Code) and (uom.[ID] = uom2.[ID])
left join [CBO_Department] as dep7 on (mfg.[ProductDepartment] = dep7.[ID])
left join [CBO_Department_Trl] as dep8 on (dep8.SysMlFlag = A3.Code) and (dep7.[ID] = dep8.[ID])
--质检相关信息表
left join [CBO_InspectionInfo] as ins on (A.[InspectionInfo] = ins.[ID])
left join [CBO_InspectionInfo_Trl] as ins2 on (ins2.SysMlFlag = A3.Code) and (ins.[ID] = ins2.[ID])
left join [CBO_EntranceInfo] as ent on (A.[EntranceInfo] = ent.[ID])
--自由项表
--left join [CBO_ItemFreeDef] as fre on (A.[ItemFreeDefs] = fre.[ID])
where (A.[Code] = '1603BC-35-2') --料品表的料号
and a.org = 1002009150000328
————————————————
版权声明：本文为CSDN博主「维C°」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/MM2286088551/article/details/129839984