泰特预留关系查询成品预留库存情况-明细表

select 

--t1.FID as "内码",

--FFORMID as "事务标识",

--FDEMANDFORMID as "需求来源类型",

--FDEMANDINTERID as "需求来源内码",

--FDEMANDENTRYID as "需求来源分录号",

FDEMANDBILLNO as "销售订单单号",

--FPARENTFORMID as "父级需求来源类型",

--FPARENTINTERID as "父级需求来源内码",

--FPARENTENTRYID as "父级需求来源分录号",

FPARENTBILLNO as "上级需求来源单号",

--FSRCFORMID as "顶级需求来源类型",

--FSRCINTERID as "顶级需求来源内码",

--FSRCENTRYID as "顶级需求来源分录号",

--FSRCBILLNO as "顶级需求来源单号",

t3.FNUMBER as 成品编码,

t4.FNAME as 成品名称,

T4.FSPECIFICATION AS 成品规格,

--FRESERVETYPE as "预留类型",

--FPRIORITY as "优先级",

--FDEMANDORGID as "需求组织",

--t1.FMATERIALID as "物料代码",

--FBASEDEMANDUNITID as "基本单位",

FBASEDEMANDQTY as "基本单位需求数量",

--FDEMANDDATE as "需求日期",

--t1.FBOMENTRYID as "bom分录内码",

--t1.FBASENUMERATOR as "基本单位分子",

--t1.FBASEDENOMINATOR as "基本单位分母",

--FBASEFIXSCRAPQTY as "基本单位固定损耗",

--FSCRAPRATE as "变动损耗率",

--t1.FGENERATEID as "生成标识",

--T1.FPKID as "mrp订单标识",

--FCOMPUTEID as "mrp计算标识",

--FISSKIP as "是否虚拟件或跳层",

--FDOSAGETYPE as "用量类型",

--FSUPRATE as "供应比例",

--FBASEOPENSTOCKQTY as "基本单位期初数量",

--FBASECLOSESTOCKQTY as "基本单位期末数量",

--FSRCFORMIDPRIORITY as "根需求单据类型优先级",

--FINTDEMANDID as "需求来源内码整形",

--FINTPARENTID as "父项需求来源内码整形",

--FINTSRCID as "顶级需求来源内码整形",

--FINTDEMANDENTRYID as "需求来源分录内码整形",

--FINTPARENTENTRYID as "父项需求来源分录内码整形",

--FINTSRCENTRYID as "顶级需求来源分录内码整形",

--t1.FREMARK as "备注" ,

--t2 表

--t2.FENTRYID as "主键",

--t2.FID as "外键",

--t2.FSUPPLYFORMID as "供给类型",

--t2.FSUPPLYINTERID as "供给单内码",

--FSUPPLYBILLNO as "供给单编号",

--FSUPPLYENTRYID as "供给单分录号",

--FSUPPLYENTITYKEY as "供应表单实体标识",

--t2.FMATERIALID as "物料内码",

--FDATE as "供应日期",

--FBASEUNITID as "基本计量单位",

FBASEQTY as "基本预留数量",

--FISMTO as "是否mto预留关系",

--FLINKTYPE as "创建类型",

--FSUPPLYORGID as "供给组织内码",

--FBOMID as "bom单内码",

--t2.FSTOCKID as "仓库",

t5.FNAME as "仓库名称",

--FSTOCKLOCID as "仓位",

--FLOT as "批号",

t2.FLOT_TEXT as "批号文本"

--FMTONO as "计划跟踪号",

--FPROJECTNO as "项目编号",

--FAUXPROPID as "辅助属性内码"

--FRESERVEBILLINTERID as "预留单内码",

--FRESERVEBILLNO as "预留单单据号",

--FRESERVEBILLIENTRYID as "预留单分录号",

--FSUPPLYPRIORITY as "供应优先级",

--FSTOCKFORMID as "库存单据类型",

--FSTOCKINTERID as "库存单据内码",

--FSTOCKENTRYID as "库存单据分录内码",

--FPARENTBOMID as "替代料所在bom内码",

--t2.FBOMENTRYID as "替代料分录内码",

--FREPLACEGROUP as "替代料项次号",

--t2.FBASENUMERATOR as "替代料分子",

--t2.FBASEDENOMINATOR as "替代料分母",

--FCONSUMPRIORITY as "消耗顺序",

--FSECUNITID as "辅库存单位",

--FSECQTY as "辅库存单位数量",

--t2.FGENERATEID as "生成标识",

--FYIELDRATE as "成品率",

--FENTRYPKID as "分录标识码",

--FINTSUPPLYID as "供给单内码整形",

--FINTSUPPLYENTRYID as "供给单分录内码整形",

--FRESERVEDATE as "预留日期",

--FRESERVEDAYS as "预留天数",

--FRELEASEDATE as "预计解锁日期",

--t2.FREMARK as "备注" ,

from T_PLN_RESERVELINK t1--T_PLN_RESERVELINK

left join T_PLN_RESERVELINKENTRY t2 on t1.fid=t2.fid

left join T_BD_MATERIAL t3 on t1.FMATERIALID=t3.FMATERIALID

left join T_BD_MATERIAL_l t4 on t3.FMATERIALID=t4.FMATERIALID

left join T_BD_STOCK_L t5 on t5.FSTOCKID=t2.FSTOCKID

where t2.FMATERIALID in (select FMATERIALID from T_BD_MATERIAL where FNUMBER like '1%') and t2.FSUPPLYFORMID='STK_Inventory'