| | |
|---|
| | | package kingdee |
|---|
| | | |
|---|
| | | // 库存查询 |
|---|
| | | |
|---|
| | | type Inventory struct { |
|---|
| | | FNumber string `gorm:"column:FNumber" json:"FNumber"` // 物料代码 |
|---|
| | | FName string `gorm:"column:FName" json:"FName"` // 物料名称 |
|---|
| | |
|---|
| | | TOP (100) PERCENT item.FNumber AS FNumber, |
|---|
| | | item.FName AS FName, |
|---|
| | | item.FModel AS FModel, |
|---|
| | | item.FSource AS FSource, |
|---|
| | | ti1.FNumber AS FSource, |
|---|
| | | i.FBatchNo AS FBatchNo, |
|---|
| | | s.FNumber AS FStockNo, |
|---|
| | | s.FName AS FStockName, |
|---|
| | |
|---|
| | | LEFT OUTER JOIN t_ICItem AS item ON i.FItemID = item.FItemID |
|---|
| | | LEFT OUTER JOIN t_Stock AS s ON i.FStockID = s.FItemID |
|---|
| | | LEFT OUTER JOIN t_Item AS ti ON item.FUnitID = ti.FItemID |
|---|
| | | LEFT OUTER JOIN t_Item AS ti1 ON item.FSource = ti1.FItemID |
|---|
| | | LEFT OUTER JOIN t_Item AS ti2 ON item.FStoreUnitID = ti2.FItemID |
|---|
| | | LEFT OUTER JOIN t_Item AS ti3 ON LEFT (item.FNumber, 5) = ti3.FNumber |
|---|
| | | AND ti3.FItemClassID = 4 |
|---|
