Supplier
Query t_supplier 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_supplier.FShortName |
Address | String | Mapping to t_supplier.FAddress |
StatusNumber | String | Mapping to field t_SubMessage.FID join with t_supplier.FStatus |
StatusName | String | Mapping to field t_SubMessage.FName join with t_supplier.FStatus |
StatusUUID | String | Mapping to t_SubMessage.UUID join with t_supplier.FStatus |
RegionNumber | String | Mapping to field t_SubMessage.FID join with t_supplier.FRegionID |
RegionName | String | Mapping to field t_SubMessage.FName join with t_supplier.FRegionID |
RegionUUID | String | Mapping to t_SubMessage.UUID join with t_supplier.FRegionID |
TradeNumber | String | Mapping to field t_SubMessage.FID join with t_supplier.FTrade |
TradeName | String | Mapping to field t_SubMessage.FName join with t_supplier.FTrade |
TradeUUID | String | Mapping to t_SubMessage.UUID join with t_supplier.FTrade |
LinkMan | String | Mapping to field t_supplier.FContact |
Phone | String | Mapping to field t_supplier.FPhone |
Fax | String | Mapping to field t_supplier.FFax |
PostalCode | String | Mapping to field t_supplier.FPostalCode |
String | Mapping to field t_supplier.FEmail | |
SettleCurrencyNumber | String | Mapping to t_Currency.FNumber join with t_supplier.FCyID |
SettleCurrencyName | String | Mapping to t_Currency.FName join with t_supplier.FCyID |
SettleCurrencyUUID | String | Mapping to t_Currency.UUID join with t_supplier.FCyID |
SettleModeNumber | String | Mapping to field t_Settle.FNumber join with t_supplier.FSetID |
SettleModeName | String | Mapping to field t_Settle.FName join with t_supplier.FSetID |
SettleModeUUID | String | Mapping to field t_Settle.UUID join with t_supplier.FSetID |
Bank | String | Mapping to field t_supplier.FBank |
BankNo | String | Mapping to field t_supplier.FAccount |
TaxNum | String | Mapping to field t_supplier.FTaxNum |
Discount | Double | Mapping to field t_supplier.FDiscount |
SupplierClassTypeNumber | String | Mapping to field t_SubMessage.FID join with t_dl_Supplier_Supplier.SupplierClass_Number |
SupplierClassTypeName | String | Mapping to field t_SubMessage.FName join with t_dl_Supplier_Supplier.SupplierClass_Number |
SupplierClassTypeUUID | String | Mapping to t_SubMessage.UUID join with t_dl_Supplier_Supplier.SupplierClass_Number |
Regmark | String | Mapping to field t_supplier.FRegmark |
Licence | String | Mapping to field t_Supplier.FLicence |
Permit | String | Mapping to field t_dl_Supplier_Supplier.Permit |
Country | String | Mapping to field t_supplier.FCountry |
Province | String | Mapping to field t_supplier.FProvince |
Corperate | String | Mapping to field t_supplier.Fcorperate |
StockAssigneeNumber | String | Mapping to field vwAssigneeStock.FNumber join with t_supplier.FStockIDAssignee |
StockAssigneeName | String | Mapping to field vwAssigneeStock.FName join with t_supplier.FStockIDAssignee |
StockAssigneeUUID | String | |
ARAccountNumber | String | Mapping to field t_Account.FNumber join with t_supplier.FARAccountID |
ARAccountName | String | Mapping to field t_Account.FName join with t_supplier.FARAccountID |
ARAccountUUID | String | Mapping to t_Account.UUID join with t_supplier.FARAccountID |
PreAccountNumber | String | Mapping to field t_Account.FNumber join with t_supplier.FpreAcctID |
PreAccountName | String | Mapping to field t_Account.FName join with t_supplier.FpreAcctID |
PreAccountUUID | String | Mapping to t_Account.UUID join with t_supplier.FpreAcctID |
FavorPolicy | String | Mapping to field t_supplier.FFavorPolicy |
DepartmentNumber | String | Mapping to field t_Item.FNumber join with t_supplier.FDepartment |
DepartmentName | String | Mapping to field t_Item.FName join with t_supplier.FDepartment |
DepartmentUUID | String | Mapping to t_Item.UUID join with t_supplier.FDepartment |
EmployeeNumber | String | Mapping to field t_Item.FNumber join with t_supplier.Femployee |
EmployeeName | String | Mapping to field t_Item.FName join with t_supplier.Femployee |
EmployeeUUID | String | Mapping to t_Item.UUID join with t_supplier.Femployee |
LastTradeDate | Date | Mapping to field t_supplier.FlastTradeDate |
LastTradeAmount | Double | Mapping to field t_supplier.FlastTradeAmount |
LastReceiveDate | Date | Mapping to field t_supplier.FlastReceiveDate |
LastRPAmount | Double | Mapping to field t_supplier.FlastRPAmount |
MaxDealAmount | Double | Mapping to field t_supplier.FmaxDealAmount |
MinForeReceiveRate | Double | Mapping to field t_supplier.FminForeReceiveRate |
CreditAmount | Double | Mapping to t_Item.UUID join with t_supplier.FCreditAmount |
CreditDays | Long | Mapping to field t_Item.FNumber join with t_supplier.FCreditDays |
CreditLevel | String | Mapping to field t_Item.FName join with t_supplier.FCreditLevel |
CreditLimit | String | Mapping to t_Item.UUID join with t_supplier.FCreditLimit |
City | String | Mapping to field t_supplier.FCity |
HomePage | String | Mapping to field t_supplier.FHomePage |
PaperPeriod | Date | Mapping to field t_supplier.FPaperPeriod |
AlarmPeriod | Long | Mapping to field t_supplier.FAlarmPeriod |
Branch | String | Mapping to field t_supplier.FBr |
ValueAddRate | Decimal | Mapping to field t_supplier.FValueAddRate |
PayTaxAcctIDNumber | String | Mapping to field t_Account.FNumber join with t_supplier.FPayTaxAcctID |
PayTaxAcctIDName | String | Mapping to field t_Account.FName join with t_supplier.FPayTaxAcctID |
PayTaxAcctIDUUID | String | Mapping to t_Account.UUID join with t_supplier.FPayTaxAcctID |
OtherARAcctIDNumber | String | Mapping to field t_Account.FNumber join with t_supplier.FOtherARAcctID |
OtherARAcctIDName | String | Mapping to field t_Account.FName join with t_supplier.FOtherARAcctID |
OtherARAcctIDUUID | String | Mapping to t_Account.UUID join with t_supplier.FOtherARAcctID |
OtherAPAcctIDNumber | String | Mapping to field t_Account.FNumber join with t_supplier.FOtherAPAcctID |
OtherAPAcctIDName | String | Mapping to field t_Account.FName join with t_supplier.FOtherAPAcctID |
OtherAPAcctIDUUID | String | Mapping to t_Account.UUID join with t_supplier.FOtherAPAcctID |
PreARAcctIDNumber | String | Mapping to field t_Account.FNumber join with t_supplier.FPreARAcctID |
PreARAcctIDName | String | Mapping to field t_Account.FName join with t_supplier.FPreARAcctID |
PreARAcctIDUUID | String | Mapping to t_Account.UUID join with t_supplier.FPreARAcctID |
ARAccountIDNumber | String | Mapping to field t_Account.FNumber join with t_supplier.FARAccountID |
ARAccountIDName | String | Mapping to field t_Account.FName join with t_supplier.FARAccountID |
ARAccountIDUUID | String | Mapping to t_Account.UUID join with t_supplier.FARAccountID |