Cmdlets for Kingdee K3 WISE

Build 24.0.9062

Stock

Query t_Stock in Kingdee.

Columns

Name Type Description
UUID [KEY] String Mapping to field t_Item.UUID
Number String Mapping to field t_Item.FNumber
Name String Mapping to field t_Item.FName
ParentNumber String Mapping to field t_Item.FName join with t_Item.FParentID
ParentName String Mapping to field t_Item.FNumber join with t_Item.FParentID
ParentUUID String Mapping to field t_Item.UUID join with t_Item.FParentID
Level Long Mapping to field t_Item.FLevel
IsDetail Boolean Mapping to field t_Item.FDetail
StockAdminNumber String Mapping to field t_Item.FNumber join with t_Stock.FEmpID
StockAdminName String Mapping to field t_Item.FName join with t_Stock.FEmpID
StockAdminUUID String Mapping to t_Item.UUID join with t_Stock.FEmpID
Address String Mapping to field t_Stock.FAddress
Phone String Mapping to field t_Stock.FPhone
PropertyNumber String Mapping to field t_SubMessage.FID join with t_Stock.FProperty
PropertyName String Mapping to field t_SubMessage.FName join with t_Stock.FProperty
PropertyUUID String Mapping to t_SubMessage.UUID join with t_Stock.FProperty
TypeNumber String Mapping to field t_SubMessage.FID join with t_Stock.FTypeID
TypeName String Mapping to field t_SubMessage.FName join with t_Stock.FTypeID
TypeUUID String Mapping to t_SubMessage.UUID join with t_Stock.FTypeID
MRPAvail Boolean Mapping to field t_Stock.FMRPAvail
IsStockMgr Boolean Mapping to field t_Stock.FIsStockMgr
StockPlaceGroupNumber String Mapping to field t_StockPlaceGroup.FNumber join with t_Stock.FSPGroupID
StockPlaceGroupName String Mapping to field t_StockPlaceGroup.FName join with t_Stock.FSPGroupID
StockPlaceGroupUUID String Mapping to t_StockPlaceGroup.UUID join with t_Stock.FSPGroupID

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062