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 |