SSIS Components for Kingdee K3 WISE

Build 24.0.9062

SaleOrder

Query SEOrder in Kingdee.

Columns

Name Type Description
UUID [KEY] String Unique identifier of the record.Mapping to field SEOrder.UUID
BillNo String Mapping to field SEOrder.FBillNo.
CurrencyUUID String Mapping to field t_Currency.UUID join with SEOrder.FCurrencyID.
CurrencyNumber String Mapping to field t_Currency.FNumber join with SEOrder.FCurrencyID.
CurrencyName String Mapping to field t_Currency.FName join with SEOrder.FCurrencyID.
CustomerUUID String Mapping to field t_Item.UUID join with SEOrder.FCustID.
CustomerNumber String Mapping to field t_Item.FNumber join with SEOrder.FCustID.
CustomerName String Mapping to field t_Item.FName join with SEOrder.FCustID.
Date Date Mapping to field SEOrder.FDate.
DepartmentUUID String Mapping to field t_Item.UUID join with SEOrder.FDeptID.
DepartmentNumber String Mapping to field t_Item.FNumber join with SEOrder.FDeptID.
DepartmentName String Mapping to field t_Item.FName join with SEOrder.FDeptID.
EmployeeUUID String Mapping to field t_Item.UUID join with SEOrder.FEmpID.
EmployeeNumber String Mapping to field t_Item.FNumber join with SEOrder.FEmpID.
EmployeeName String Mapping to field t_Item.FName join with SEOrder.FEmpID.
FetchAdd String Mapping to field SEOrder.FFetchAdd.
MangerUUID String Mapping to field t_Item.UUID join with SEOrder.FMangerID.
MangerNumber String Mapping to field t_Item.FNumber join with SEOrder.FMangerID.
MangerName String Mapping to field t_Item.FName join with SEOrder.FMangerID.
SaleStyleUUID String Mapping to field t_SubMessage.UUID join with SEOrder.FSaleStyle.
SaleStyleNumber String Mapping to field t_SubMessage.FID join with SEOrder.FSaleStyle.
SaleStyleName String Mapping to field t_SubMessage.FName join with SEOrder.FSaleStyle.
SettleStyleUUID String Mapping to field t_SubMessage.UUID join with SEOrder.FSettleID.
SettleStyleNumber String Mapping to field t_SubMessage.FID join with SEOrder.FSettleID.
SettleStyleName String Mapping to field t_SubMessage.FName join with SEOrder.FSettleID.
DiscountType String Mapping to field SEOrder.FDiscountType.
BillerUUID String Mapping to field t_User.UUID join with SEOrder.FBillerID.
BillerNumber String Mapping to field t_User.FUserID join with SEOrder.FBillerID.
BillerName String Mapping to field t_User.FName join with SEOrder.FBillerID.

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