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 |
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 |