@[TOC](云星空开发必备：打造金蝶云星空最全数据库表备注信息，会按模块、按板块持续更新中...)
**(由于内容较多篇幅字数有限制，会分不同篇幅发布)**
# 由于二开常有写SQL找表需求，特地分享整理了相关表,有需要的CTRL+F搜索查看即可，欢迎大家补充纠正
## 篇1已更新如下内容
点击查看【emoji】：[篇1常用查询SQL](https://wenku.my7c.com/article/560480436933997056?productLineId=1&lang=zh-CN)
点击查看【emoji】：[【云星空数据库表结构1】已更新基础资料、生产制造相关表](https://wenku.my7c.com/article/560479083298040320)
点击查看【emoji】：[【云星空数据库表结构2】添加采购管理、库存管理、销售管理相关表](https://wenku.my7c.com/article/560820909930440192?productLineId=1&lang=zh-CN)
点击查看【emoji】：[【云星空数据库表结构】添加供应链协同采购订单、采购申请单相关表](https://wenku.my7c.com/article/562596317575260672)
### 1. 查询辅助资料数据SQL
### 2. 查询即时库存SQL
### 3. 通过物料名称查询物料SQL
### 4. 用户权限、单据类型相关SQL
### 5. 查询枚举值SQL
### 6. 根据仓位id查询仓位编码名称SQL
### 7. 生产订单下查下推单据SQL
### 8. 生产入库单列表SQL
### 9. 生产入库单上查SQL
### 10. 物料列表查询SQL
### 11. 用户员工关系SQL
### 12. 查看临时表数量，占用存储空间情况 SQL
本篇续...
### 13. 生产入库单列表数据查询 （即取即用）SQL
```language
SELECT
*
FROM
(
SELECT
t0.FBILLNO AS FBILLNO,
t0.FDOCUMENTSTATUS AS FDOCUMENTSTATUS,
t0.FSTOCKORGID AS FStockOrgId_Id,
t0.FPRDORGID AS FPrdOrgId_Id,
t1.FAMOUNT AS FAMOUNT,
t1.FPRICE AS FPRICE,
t0.FCREATORID AS FCreatorId_Id,
t0.FCREATEDATE AS FCREATEDATE,
t1.FMATERIALID AS FMaterialId_Id,
t1.FPRODUCTTYPE AS FPRODUCTTYPE,
t1.FUNITID AS FUnitID_Id,
t1.FMUSTQTY AS FMUSTQTY,
t1.FREALQTY AS FREALQTY,
t1.FSTOCKID AS FStockId_Id,
t1.FPRODUCEDATE AS FPRODUCEDATE,
t1.FEXPIRYDATE AS FEXPIRYDATE,
t1.FSECUNITID AS FSecUnitId_Id,
t1.FSECREALQTY AS FSECREALQTY,
t0.F_HXZB_YDDJLX AS F_HXZB_YDDJLX_Id,
t0.FCURRID AS FCurrId_Id,
t0.FCANCELSTATUS AS FCANCELSTATUS,
t0.FBILLTYPE AS FBILLTYPE,
t0.FSTOCKORGID AS FSTOCKORGID,
t0.FFORMID AS FFORMID,
t0.FID AS FID,
t1.FENTRYID AS t1_FENTRYID,
t1.FSeq AS t1_FSeq,
ROW_NUMBER ( ) OVER ( ORDER BY t0.FCREATEDATE DESC, t0.FBILLNO DESC, t1.FSeq ASC ) fidentityid
FROM
T_PRD_INSTOCK t0
LEFT JOIN T_PRD_INSTOCKENTRY t1 ON ( t0.FID = t1.FID )
WHERE
-- ( ( t0.FENTRUSTINSTOCKID = 0 AND t0.FBILLTYPE = N'65b8552a66f7e1' ) )
AND ( t0.FSTOCKORGID = 100206 )
AND t0.FSTOCKORGID IN ( 100206, 0 )
AND t0.FFORMID = 'PRD_INSTOCK'
) TLIST
WHERE
fidentityid >= 1
AND fidentityid <= 500
```
