Power BI Connector for Kingdee K3 WISE

Build 24.0.9062

StockBillEntry

Query StockBill entities in Kingdee.

Columns

Name Type Description
UUID [KEY] String Unique identifier of the StockBill record.
EntryId [KEY] Int Mapping to field ICStockBillEntry.FEntryId join with ICStockBill.FInterId.
Amount Double Mapping to field ICStockBillEntry.FAmount join with ICStockBill.FInterId.
AuxPlanPrice Double Mapping to field ICStockBillEntry.FAuxPlanPrice join with ICStockBill.FInterId.
AuxPrice Double Mapping to field ICStockBillEntry.FAuxPrice join with ICStockBill.FInterId.
AuxQty Double Mapping to field ICStockBillEntry.FAuxQty join with ICStockBill.FInterId.
AuxQtyMust Double Mapping to field ICStockBillEntry.FAuxQtyMust join with ICStockBill.FInterId.
ConsignAmount Double Mapping to field ICStockBillEntry.FConsignAmount join with ICStockBill.FInterId.
ConsignPrice Double Mapping to field ICStockBillEntry.FConsignPrice join with ICStockBill.FInterId.
BatchNo String Mapping to field ICStockBillEntry.FBatchNo join with ICStockBill.FInterId.
DCSPUUID String Mapping to field t_Item.UUID join with ICStockBillEntry.FDCSPID and ICStockBill.FInterId.
DCSPNumber String Mapping to field t_Item.FNumber join with ICStockBillEntry.FDCSPID and ICStockBill.FInterId.
DCSPName String Mapping to field t_Item.FName join with ICStockBillEntry.FDCSPID and ICStockBill.FInterId.
ItemUUID String Mapping to field t_Item.UUID join with ICStockBillEntry.FItemId and ICStockBill.FInterId.
ItemNumber String Mapping to field t_Item.FNumber join with ICStockBillEntry.FItemId and ICStockBill.FInterId.
ItemName String Mapping to field t_Item.FName join with ICStockBillEntry.FItemId and ICStockBill.FInterId.
Date Date Mapping to field ICStockBillEntry.FKFDate join with ICStockBill.FInterId.
Period Int Mapping to field ICStockBillEntry.KFPeriod join with ICStockBill.FInterId.
Note String Mapping to field ICStockBillEntry.FNote join with ICStockBill.FInterId.
MapName String Mapping to field ICStockBillEntry.FMapName join with ICStockBill.FInterId.
MapNumber String Mapping to field ICStockBillEntry.FMapNumber join with ICStockBill.FInterId.
PlanAmount Double Mapping to field ICStockBillEntry.FPlanAmount join with ICStockBill.FInterId.
Qty Double Mapping to field ICStockBillEntry.FQty join with ICStockBill.FInterId.
QtyMust Double Mapping to field ICStockBillEntry.FQtyMust join with ICStockBill.FInterId.
UnitUUID String Mapping to field t_MeasureUnit.UUID join with ICStockBillEntry.FUnitID and ICStockBill.FInterId.
UnitNumber String Mapping to field t_MeasureUnit.FNumber join with ICStockBillEntry.FUnitID and ICStockBill.FInterId.
UnitName String Mapping to field t_MeasureUnit.FName join with ICStockBillEntry.FUnitID and ICStockBill.FInterId.
AuxCommitQty Double Mapping to field ICStockBillEntry.FAuxCommitQty join with ICStockBill.FInterId.
Price Double Mapping to field ICStockBillEntry.FPrice join with ICStockBill.FInterId.
AuxQtyActual Double Mapping to field ICStockBillEntry.FAuxQtyActual join with ICStockBill.FInterId.
CommitQty Double Mapping to field ICStockBillEntry.FCommitQty join with ICStockBill.FInterId.
DCStockUUID String Mapping to field t_Item.UUID join with ICStockBillEntry.FDCStockID and ICStockBill.FInterId.
DCStockNumber String Mapping to field t_Item.FNumber join with ICStockBillEntry.FDCStockID and ICStockBill.FInterId.
DCStockName String Mapping to field t_Item.FName join with ICStockBillEntry.FDCStockID and ICStockBill.FInterId.

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