Tableau Connector for Kingdee K3 WISE

Build 24.0.9062

StockBill

Query StockBill entities in Kingdee.

Columns

Name Type Description
UUID [KEY] String Unique identifier of the record.
BillNo String Mapping to field ICStockBill.FBillNo.
Date Date Mapping to field ICStockBill.FDate.
RedOrBlue Int Mapping to field ICStockBill.FROB.
Status Int Mapping to field ICStockBill.FStatus.
TranType Int Mapping to field ICStockBill.FTranType.
Note String Mapping to field ICStockBill.FNote.
InterID Int Mapping to field ICStockBill.FInterID.
BillerUUID String Mapping to field t_User.UUID join with ICStockBill.FBillerID.
BillerNumber String Mapping to field t_User.FUserID join with ICStockBill.FBillerID.
BillerName String Mapping to field t_User.FName join with ICStockBill.FBillerID.
AcceptanceUUID String Mapping to field t_Item.UUID join with ICStockBill.FFManagerId.
AcceptanceNumber String Mapping to field t_Item.FNumber join with ICStockBill.FFManagerId.
AcceptanceName String Mapping to field t_Item.FName join with ICStockBill.FFManagerId.
PosterUUID String Mapping to field t_Item.UUID join with ICStockBill.FPosterID.
PosterNumber String Mapping to field t_Item.FNumber join with ICStockBill.FPosterID.
PosterName String Mapping to field t_Item.FName join with ICStockBill.FPosterID.
RelateBrUUID String Mapping to field t_Item.UUID join with ICStockBill.FRelateBrID.
RelateBrNumber String Mapping to field t_Item.FNumber join with ICStockBill.FRelateBrID.
RelateBrName String Mapping to field t_Item.FName join with ICStockBill.FRelateBrID.
SaleStyleUUID String Mapping to field t_SubMessage.UUID join with ICStockBill.FSaleStyle.
SaleStyleNumber String Mapping to field t_SubMessage.FID join with ICStockBill.FSaleStyle.
SaleStyleName String Mapping to field t_SubMessage.FName join with ICStockBill.FSaleStyle.
POStyleUUID String Mapping to field t_SubMessage.UUID join with ICStockBill.FPOStyle.
POStyleNumber String Mapping to field t_SubMessage.FID join with ICStockBill.FPOStyle.
POStyleleName String Mapping to field t_SubMessage.FName join with ICStockBill.FPOStyle.
TrusteeUUID String Mapping to field t_Item.UUID join with ICStockBill.FSManagerID.
TrusteeNumber String Mapping to field t_Item.FNumber join with ICStockBill.FSManagerID.
TrusteeName String Mapping to field t_Item.FName join with ICStockBill.FSManagerID.
SupplierUUID String Mapping to field t_Item.UUID join with ICStockBill.FSupplyID.
SupplierNumber String Mapping to field t_Item.FNumber join with ICStockBill.FSupplyID.
SupplierName String Mapping to field t_Item.FName join with ICStockBill.FSupplyID.
CurrencyUUID String Mapping to field t_Item.UUID join with ICStockBill.FCurrencyID.
CurrencyNumber String Mapping to field t_Item.FNumber join with ICStockBill.FCurrencyID.
CurrencyName String Mapping to field t_Item.FName join with ICStockBill.FCurrencyID.
DepartmentUUID String Mapping to field t_Item.UUID join with ICStockBill.FDeptID.
DepartmentNumber String Mapping to field t_Item.FNumber join with ICStockBill.FDeptID.
DepartmentName String Mapping to field t_Item.FName join with ICStockBill.FDeptID.
EmployeeUUID String Mapping to field t_Item.UUID join with ICStockBill.FDeptID.
EmployeeNumber String Mapping to field t_Item.FNumber join with ICStockBill.FDeptID.
EmployeeName String Mapping to field t_Item.FName join with ICStockBill.FDeptID.

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