SSIS Components for Kingdee K3 WISE

Build 24.0.9062

Customer

Query t_organization 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
Level Long Mapping to field t_Item.FLevel
ParentNumber String Mapping to field t_Item.FNumber join with t_Item.FParentID
ParentName String Mapping to field t_Item.FName join with t_Item.FParentID
ParentUUID String Mapping to t_Item.UUID join with t_Item.FParentID
IsDetail Boolean Mapping to field t_Item.FDetail
ShortName String Mapping to field t_Organization.FShortName
Address String Mapping to t_Organization.FAddress
StatusNumber String Mapping to field t_SubMessage.FID join with t_Organization.FStatus
StatusName String Mapping to field t_SubMessage.FName join with t_Organization.FStatus
StatusUUID String Mapping to t_SubMessage.UUID join with t_Organization.FStatus
RegionNumber String Mapping to field t_SubMessage.FID join with t_Organization.FRegionID
RegionName String Mapping to field t_SubMessage.FName join with t_Organization.FRegionID
RegionUUID String Mapping to t_SubMessage.UUID join with t_Organization.FRegionID
TradeNumber String Mapping to field t_SubMessage.FID join with t_Organization.FTrade
TradeName String Mapping to field t_SubMessage.FName join with t_Organization.FTrade
TradeUUID String Mapping to t_SubMessage.UUID join with t_Organization.FTrade
LinkMan String Mapping to field t_Organization.FContact
Phone String Mapping to field t_Organization.FPhone
Fax String Mapping to field t_Organization.FFax
PostalCode String Mapping to field t_Organization.FPostalCode
Email String Mapping to field t_Organization.FEmail
SettleCurrencyNumber String Mapping to t_Currency.FNumber join with t_organization.FCyID
SettleCurrencyName String Mapping to t_Currency.FName join with t_organization.FCyID
SettleCurrencyUUID String Mapping to t_Currency.UUID join with t_organization.FCyID
SettleModeNumber String Mapping to field t_Settle.FNumber join with t_organization.FSetID
SettleModeName String Mapping to field t_Settle.FName join with t_organization.FSetID
SettleModeUUID String Mapping to field t_Settle.UUID join with t_organization.FSetID
Bank String Mapping to field t_Organization.FBank
Account String Mapping to field t_Organization.FAccount
TaxNum String Mapping to field t_Organization.FTaxNum
CustomerTypeNumber String Mapping to field t_SubMessage.FID join with t_Organization.FCustType
CustomerTypeName String Mapping to field t_SubMessage.FName join with t_Organization.FCustType
CustomerTypeUUID String Mapping to t_SubMessage.UUID join with t_Organization.FCustType
IsCreditMgr Boolean Mapping to field t_Organization.FIsCreditMgr
SaleModeNumber String Mapping to field t_SubMessage.FID join with t_Organization.FSaleMode
SaleModeName String Mapping to field t_SubMessage.FName join with t_Organization.FSaleMode
SaleModeUUID String Mapping to t_SubMessage.UUID join with t_Organization.FSaleMode
LicAndPermit Boolean Mapping to field t_Organization.FLicAndPermit
Licence String Mapping to field t_Supplier.FLicence or t_dl_Customer_Customer.Licence or t_dl_Supplier_Supplier.Licence
Permit String Mapping to field t_dl_Customer_Customer.Permit or t_dl_Supplier_Supplier.Permit
Certify String Mapping to field t_dl_Customer_Customer.Certify or t_dl_Supplier_Supplier.Certify
City String Mapping to field t_Organization.FCity
Province String Mapping to field t_Organization.FProvince
Country String Mapping to field t_Organization.FCountry
HomePage String Mapping to field t_Organization.FHomePage
Corperate String Mapping to field t_Organization.Fcorperate
CIQNumber String Mapping to field t_Organization.FCIQNumber
ARAccountNumber String Mapping to field t_Account.FNumber join with t_Organization.FARAccountID
ARAccountName String Mapping to field t_Account.FName join with t_Organization.FARAccountID
ARAccountUUID String Mapping to t_Account.UUID join with t_Organization.FARAccountID
PreAccountNumber String Mapping to field t_Account.FNumber join with t_Organization.FpreAcctID
PreAccountName String Mapping to field t_Account.FName join with t_Organization.FpreAcctID
PreAccountUUID String Mapping to t_Account.UUID join with t_Organization.FpreAcctID
FavorPolicy String Mapping to field t_Organization.FFavorPolicy
DepartmentNumber String Mapping to field t_Item.FNumber join with t_Organization.FDepartment
DepartmentName String Mapping to field t_Item.FName join with t_Organization.FDepartment
DepartmentUUID String Mapping to t_Item.UUID join with t_Organization.FDepartment
EmployeeNumber String Mapping to field t_Item.FNumber join with t_Organization.Femployee
EmployeeName String Mapping to field t_Item.FName join with t_Organization.Femployee
EmployeeUUID String Mapping to t_Item.UUID join with t_Organization.Femployee
LastTradeDate Date Mapping to field t_Organization.FlastTradeDate
LastTradeAmount Double Mapping to field t_Organization.FlastTradeAmount
LastReceiveDate Date Mapping to field t_Organization.FlastReceiveDate
LastRPAmount Double Mapping to field t_Organization.FlastRPAmount
MaxDealAmount Double Mapping to field t_Organization.FmaxDealAmount
MinForeReceiveRate Double Mapping to field t_Organization.FminForeReceiveRate
MinReserverate Double Mapping to field t_Organization.FminReserverate
DebtLevelNumber String Mapping to field t_SubMessage.FID join with t_Organization.FDebtLevel
DebtLevelName String Mapping to field t_SubMessage.FName join with t_Organization.FDebtLevel
DebtLevelUUID String Mapping to t_SubMessage.UUID join with t_Organization.FDebtLevel
BeforeHandDay Double Mapping to field t_dl_Customer_Customer.BeforeHandDay
PaperPeriod Date Mapping to field t_Organization.FPaperPeriod
AlarmPeriod Long Mapping to field t_Organization.FAlarmPeriod
ValueAddRate Decimal Mapping to field t_Organization.FValueAddRate
PayTaxAcctIDNumber String Mapping to field t_Account.FNumber join with t_Organization.FPayTaxAcctID
PayTaxAcctIDName String Mapping to field t_Account.FName join with t_Organization.FPayTaxAcctID
PayTaxAcctIDUUID String Mapping to t_Account.UUID join with t_Organization.FPayTaxAcctID
FSaleIDNumber String Mapping to field t_SubMessage.FID join with t_Organization.FSaleID
FSaleIDName String Mapping to field t_SubMessage.FName join with t_Organization.FSaleID
FSaleIDUUID String Mapping to t_SubMessage.UUID join with t_Organization.FSaleID
StockIDKeepNumber String Mapping to field vwKeepStock.FID join with t_Organization.FStockIDKeep
StockIDKeepName String Mapping to field vwKeepStock.FName join with t_Organization.FStockIDKeep
StockIDKeepUUID String Mapping to vwKeepStock.UUID join with t_Organization.FStockIDKeep
HelpCode String Mapping to field t_Organization.FHelpCode
OtherARAcctIDNumber String Mapping to field t_Account.FNumber join with t_Organization.FOtherARAcctID
OtherARAcctIDName String Mapping to field t_Account.FName join with t_Organization.FOtherARAcctID
OtherARAcctIDUUID String Mapping to t_Account.UUID join with t_Organization.FOtherARAcctID
OtherAPAcctIDNumber String Mapping to field t_Account.FNumber join with t_Organization.FOtherAPAcctID
OtherAPAcctIDName String Mapping to field t_Account.FName join with t_Organization.FOtherAPAcctID
OtherAPAcctIDUUID String Mapping to t_Account.UUID join with t_Organization.FOtherAPAcctID
PreAPAcctIDNumber String Mapping to field t_Account.FNumber join with t_Organization.FPreAPAcctID
PreAPAcctIDName String Mapping to field t_Account.FName join with t_Organization.FPreAPAcctID
PreAPAcctIDUUID String Mapping to t_Account.UUID join with t_Organization.FPreAPAcctID
APAccountIDNumber String Mapping to field t_Account.FNumber join with t_Organization.FAPAccountID
APAccountIDName String Mapping to field t_Account.FName join with t_Organization.FAPAccountID
APAccountIDUUID String Mapping to t_Account.UUID join with t_Organization.FAPAccountID

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