ビュー
ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。
クエリは、ビューに対して通常のテーブルと同様に実行することができます。
CData Excel Add-In for Kingdee K3 WISE ビュー
Name | Description |
Account | Query t_Account in Kingdee. |
AccountItemClass | Query t_ItemClass join in t_ItemDetailV and t_Account in Kingdee. |
Currency | Query t_Currency entities in Kingdee. |
Customer | Query t_organization in Kingdee. |
CustomerBarCodes | Query t_barcode join in t_orgnazition in Kingdee. |
Department | Query t_Department in Kingdee. |
DepartmentBarCodes | Query t_barcode join in t_orgnazition in Kingdee. |
Material | Query t_ICItem in Kingdee. |
MaterialBarCodes | Query t_barcode join in t_ICItem in Kingdee. |
MeasureUnit | Query t_MeasureUnit entities in Kingdee. |
SaleOrder | Query SEOrder in Kingdee. |
SaleOrderEntry | Query SEorderEntry join with SEorder.FInterId in Kingdee. |
Stock | Query t_Stock in Kingdee. |
StockBarCodes | Query t_barcode join in t_Stock in Kingdee. |
StockBill | Query StockBill entities in Kingdee. |
StockBillEntry | Query StockBill entities in Kingdee. |
Supplier | Query t_supplier in Kingdee. |
SupplierBarCodes | Query t_barcode join in t_supplier in Kingdee. |
WorkCenter | Query t_WorkCenter in Kingdee. |
WorkCenterBarCodes | Query t_barcode join in t_WorkCenter in Kingdee. |