Material
Query t_ICItem 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 |
| Model | String | Mapping to field t_ICItem.FModel |
| AuxClassNumber | String | Mapping to field vwItemAuxProp.FNumber join with t_ICItem.FAuxClassID |
| AuxClassName | String | Mapping to field vwItemAuxProp.FName join with t_ICItem.FAuxClassID |
| AuxClassItemAuxProp | String | |
| ErpClsNumber | String | Mapping to field t_SubMessage.FID join with t_ICItem.FErpClsID |
| ErpClsName | String | Mapping to field t_SubMessage.FName join with t_ICItem.FErpClsID |
| ErpClsUUID | String | Mapping to t_SubMessage.UUID join with t_ICItem.FErpClsID |
| HelpCode | String | Mapping to field t_ICItem.FHelpCode |
| AuxTypeNumber | String | Mapping to field t_SubMessage.FID join with t_ICItem.FTypeID |
| AuxTypeName | String | Mapping to field t_SubMessage.FName join with t_ICItem.FTypeID |
| AuxTypeUUID | String | Mapping to t_SubMessage.UUID join with t_ICItem.FTypeID |
| UnitNumber | String | Mapping to field t_SubMessage.FID join with t_ICItem.FUnitID |
| UnitName | String | Mapping to field t_SubMessage.FName join with t_ICItem.FUnitID |
| UnitUUID | String | Mapping to t_SubMessage.UUID join with t_ICItem.FUnitID |
| CUUnitNumber | String | Mapping to field t_SubMessage.FID join with t_ICItem.FCUUnitID |
| CUUnitName | String | Mapping to field t_SubMessage.FName join with t_ICItem.FCUUnitID |
| CUUnitUUID | String | Mapping to t_SubMessage.UUID join with t_ICItem.FCUUnitID |
| DefaultLocNumber | String | Mapping to field t_Item.FNumber join with t_ICItem.FDefaultLoc |
| DefaultLocName | String | Mapping to field t_Item.FName join with t_ICItem.FDefaultLoc |
| DefaultLocUUID | String | Mapping to t_Item.UUID join with t_ICItem.FDefaultLoc |
| StockPlaceNumber | String | Mapping to field t_StockPlace.FNumber join with t_ICItem.FSPID |
| StockPlaceName | String | Mapping to field t_StockPlace.FName join with t_ICItem.FSPID |
| StockPlaceUUID | String | Mapping to field t_StockPlace.UUID join with t_ICItem.FSPID |
| SourceNumber | String | Mapping to field t_Item.FNumber join with t_ICItem.FSource |
| SourceName | String | Mapping to field t_Item.FName join with t_ICItem.FSource |
| SourceUUID | String | Mapping to t_Item.UUID join with t_ICItem.FSource |
| QtyDecimal | Long | Mapping to field t_ICItem.FQtyDecimal |
| LowLimit | Double | Mapping to field t_ICItem.FLowLimit |
| HighLimit | Double | Mapping to field t_ICItem.FHighLimit |
| DailyConsume | Double | Mapping to field t_ICItem.FDailyConsume |
| SecInv | Double | Mapping to field t_ICItem.FSecInv |
| UseStateNumber | String | Mapping to field t_SubMessage.FID join with t_ICItem.FUseState |
| UseStateName | String | Mapping to field t_SubMessage.FName join with t_ICItem.FUseState |
| UseStateUUID | String | Mapping to t_SubMessage.UUID join with t_ICItem.FUseState |
| OrderRectorNumber | String | Mapping to field t_Item.FNumber join with t_ICItem.FOrderRector |
| OrderRectorName | String | Mapping to field t_Item.FName join with t_ICItem.FOrderRector |
| OrderRectorUUID | String | Mapping to t_Item.UUID join with t_ICItem.FOrderRector |
| POHighPrice | Double | Mapping to field t_ICItem.FPOHighPrice |
| IsSale | Boolean | Mapping to field t_ICItem.FIsSale |
| SalePrice | Double | Mapping to field t_ICItem.FSalePrice |
| InspectionLevelNumber | String | Mapping to field t_SubMessage.FID join with t_ICItem.FInspectionLevel |
| InspectionLevelName | String | Mapping to field t_SubMessage.FName join with t_ICItem.FInspectionLevel |
| InspectionLevelUUID | String | Mapping to t_SubMessage.UUID join with t_ICItem.FInspectionLevel |
| ProChkMdeNumber | String | Mapping to field t_SubMessage.FID join with t_ICItem.FProChkMde |
| ProChkMdeName | String | Mapping to field t_SubMessage.FName join with t_ICItem.FProChkMde |
| ProChkMdeUUID | String | Mapping to t_SubMessage.UUID join with t_ICItem.FProChkMde |
| WWChkMdeNumber | String | Mapping to field t_SubMessage.FID join with t_ICItem.FWWChkMde |
| WWChkMdeName | String | Mapping to field t_SubMessage.FName join with t_ICItem.FWWChkMde |
| WWChkMdeUUID | String | Mapping to t_SubMessage.UUID join with t_ICItem.FWWChkMde |
| SOChkMdeNumber | String | Mapping to field t_SubMessage.FID join with t_ICItem.FSOChkMde |
| SOChkMdeName | String | Mapping to field t_SubMessage.FName join with t_ICItem.FSOChkMde |
| SOChkMdeUUID | String | Mapping to t_SubMessage.UUID join with t_ICItem.FSOChkMde |
| WthDrwChkMdeNumber | String | Mapping to field t_SubMessage.FID join with t_ICItem.FWthDrwChkMde |
| WthDrwChkMdeName | String | Mapping to field t_SubMessage.FName join with t_ICItem.FWthDrwChkMde |
| WthDrwChkMdeUUID | String | Mapping to t_SubMessage.UUID join with t_ICItem.FWthDrwChkMde |
| StkChkMdeNumber | String | Mapping to field t_SubMessage.FID join with t_ICItem.FStkChkMde |
| StkChkMdeName | String | Mapping to field t_SubMessage.FName join with t_ICItem.FStkChkMde |
| StkChkMdeUUID | String | Mapping to t_SubMessage.UUID join with t_ICItem.FStkChkMde |
| OtherChkMdeNumber | String | Mapping to field t_SubMessage.FID join with t_ICItem.FOtherChkMde |
| OtherChkMdeName | String | Mapping to field t_SubMessage.FName join with t_ICItem.FOtherChkMde |
| OtherChkMdeUUID | String | Mapping to t_SubMessage.UUID join with t_ICItem.FOtherChkMde |
| InspectionProjectNumber | String | Mapping to field ICQCScheme.FBillNo join with t_ICItem.FInspectionProject |
| InspectionProjectName | String | Mapping to field ICQCScheme.FSchemeName join with t_ICItem.FInspectionProject |
| InspectionProjectUUID | String | Mapping to ICQCScheme.UUID join with t_ICItem.FInspectionProject |
| IdentifierProjectNumber | String | Mapping to field t_Item.FNumber join with t_ICItem.FIdentifier |
| IdentifierProjectName | String | Mapping to field t_Item.FName join with t_ICItem.FIdentifier |
| IdentifierProjectUUID | String | Mapping to t_Item.UUID join with t_ICItem.FIdentifier |
| IsListControl | Boolean | Mapping to field t_ICItem.FIsListControl |
| IsBatch | Boolean | Mapping to field t_ICItem.FBatchManager |
| IsKeepTime | Boolean | Mapping to field t_ICItem.FISKFPeriod |
| KeepQualityDays | Long | Mapping to field t_ICItem.FKFPeriod |
| TrackNumber | String | Mapping to field t_SubMessage.FID join with t_ICItem.FTrack |
| TrackName | String | Mapping to field t_SubMessage.FName join with t_ICItem.FTrack |
| TrackUUID | String | Mapping to t_SubMessage.UUID join with t_ICItem.FTrack |
| PlanPrice | Double | Mapping to field t_ICItem.FPlanPrice |
| StandardCost | Double | Mapping to field t_ICItem.FStandardCost |
| PriceDecimal | Long | Mapping to field t_ICItem.FPriceDecimal |
| AcctNumber | String | Mapping to field t_Account.FNumber join with t_ICItem.FAcctID |
| AcctName | String | Mapping to field t_Account.FName join with t_ICItem.FAcctID |
| AcctUUID | String | Mapping to t_Account.UUID join with t_ICItem.FAcctID |
| SaleAcctNumber | String | Mapping to field t_Account.FNumber join with t_ICItem.FSaleAcctID |
| SaleAcctName | String | Mapping to field t_Account.FName join with t_ICItem.FSaleAcctID |
| SaleAcctUUID | String | Mapping to t_Account.UUID join with t_ICItem.FSaleAcctID |
| CostAcctNumber | String | Mapping to field t_Account.FNumber join with t_ICItem.FCostAcctID |
| CostAcctName | String | Mapping to field t_Account.FName join with t_ICItem.FCostAcctID |
| CostAcctUUID | String | Mapping to t_Account.UUID join with t_ICItem.FCostAcctID |
| APAcctNumber | String | Mapping to field t_Account.FNumber join with t_ICItem.FAPAcctID |
| APAcctName | String | Mapping to field t_Account.FName join with t_ICItem.FAPAcctID |
| APAcctUUID | String | Mapping to t_Account.UUID join with t_ICItem.FAPAcctID |
| CostItemNumber | String | Mapping to field t_Item.FNumber join with t_ICItem.FCostProject |
| CostItemName | String | Mapping to field t_Item.FName join with t_ICItem.FCostProject |
| CostItemUUID | String | Mapping to t_Item.UUID join with t_ICItem.FCostProject |
| StandardManHour | Double | Mapping to field t_ICItem.FStandardManHour |
| PlanTrategyNumber | String | Mapping to field t_SubMessage.FID join with t_ICItem.FPlanTrategy |
| PlanTrategyName | String | Mapping to field t_SubMessage.FName join with t_ICItem.FPlanTrategy |
| PlanTrategyUUID | String | Mapping to t_SubMessage.UUID join with t_ICItem.FPlanTrategy |
| OrderTrategyNumber | String | Mapping to field t_SubMessage.FID join with t_ICItem.FOrderTrategy |
| OrderTrategyName | String | Mapping to field t_SubMessage.FName join with t_ICItem.FOrderTrategy |
| OrderTrategyUUID | String | Mapping to t_SubMessage.UUID join with t_ICItem.FOrderTrategy |
| LeadTime | Double | Mapping to field t_ICItem.FLeadTime |
| TotalLeadTime | Double | Mapping to field t_ICItem.FTotalTQQ |
| OrderInterVal | Long | Mapping to field t_ICItem.FOrderInterVal |
| QtyMax | Double | Mapping to field t_ICItem.FQtyMax |
| QtyMin | Double | Mapping to field t_ICItem.FQtyMin |
| BatchIncrement | Long | Mapping to field t_ICItem.FBatchAppendQty |
| OrderPoint | Long | Mapping to field t_ICItem.FOrderPoint |
| BatFixEconomy | Long | Mapping to field t_ICItem.FBatFixEconomy |
| RequirePoint | Long | Mapping to field t_ICItem.FRequirePoint |
| PlanPoint | Long | Mapping to field t_ICItem.FPlanPoint |
| DefaultRoutingNumber | String | Mapping to field t_Routing.FBillNo join with t_ICItem.FDefaultRoutingID |
| DefaultRoutingName | String | Mapping to field t_Routing.FRoutingName join with t_ICItem.FDefaultRoutingID |
| DefaultRoutingUUID | String | Mapping to t_Routing.UUID join with t_ICItem.FDefaultRoutingID |
| DefaultWorkTypeNumber | String | Mapping to field t_WorkType.FNumber join with t_ICItem.FDefaultWorkTypeID |
| DefaultWorkTypeName | String | Mapping to field t_WorkType.FName join with t_ICItem.FDefaultWorkTypeID |
| DefaultWorkTypeUUID | String | Mapping to field t_WorkType.UUID join with t_ICItem.FDefaultWorkTypeID |
| ProductPrincipalNumber | String | Mapping to field t_Item.FNumber join with t_ICItem.FProductPrincipal |
| ProductPrincipalName | String | Mapping to field t_Item.FName join with t_ICItem.FProductPrincipal |
| ProductPrincipalUUID | String | Mapping to t_Item.UUID join with t_ICItem.FProductPrincipal |
| ChartNumber | String | Mapping to field t_ICItem.FChartNumber |
| IsKeyItem | Boolean | Mapping to field t_ICItem.FIsKeyItem |
| GrossWeight | Double | Mapping to field t_ICItem.FGrossWeight |
| NetWeight | Double | Mapping to field t_ICItem.FNetWeight |
| WeightMeasureNumber | String | Mapping to field t_Item.FNumber join with t_ICItem.FMaund |
| WeightMeasureName | String | Mapping to field t_Item.FName join with t_ICItem.FMaund |
| WeightMeasureUUID | String | Mapping to t_Item.UUID join with t_ICItem.FMaund |
| LengthMeasureNumber | String | Mapping to field t_Item.FNumber join with t_ICItem.FCubicMeasure |
| LengthMeasureName | String | Mapping to field t_Item.FName join with t_ICItem.FCubicMeasure |
| LengthMeasureUUID | String | Mapping to t_Item.UUID join with t_ICItem.FCubicMeasure |
| IsSpecialTax | Boolean | Mapping to field t_ICItem.FIsSpecialTax |
| IsStockTime | Boolean | Mapping to field t_ICItem.FStockTime |
| BeforeExpire | Long | Mapping to field t_ICItem.FBeforeExpire |
| ApproveNo | String | Mapping to field t_ICItem.FApproveNo |
| Alias | String | Mapping to field t_ICItem.FAlias |
| GoodSpecNumber | String | Mapping to field t_Item.FNumber join with t_ICItem.FGoodSpec |
| GoodSpecName | String | Mapping to field t_Item.FName join with t_ICItem.FGoodSpec |
| GoodSpecUUID | String | Mapping to t_Item.UUID join with t_ICItem.FGoodSpec |
| TaxRate | String | Mapping to field t_ICItem.FTaxRate |
| Note | String | Mapping to field t_ICItem.FNote |
| AdminAcctNumber | String | Mapping to field t_Account.FNumber join with t_ICItem.FAdminAcctID |
| AdminAcctName | String | Mapping to field t_Account.FName join with t_ICItem.FAdminAcctID |
| AdminAcctUUID | String | Mapping to t_Account.UUID join with t_ICItem.FAdminAcctID |
| Length | Double | Mapping to field t_ICItem.FLength |
| Width | Double | Mapping to field t_ICItem.FWidth |
| Height | Double | Mapping to field t_ICItem.FHeight |
| Size | Double | Mapping to field t_ICItem.FSize |
| IsMRPCon | Boolean | Mapping to field t_ICItem.FMRPCon |
| IsBookPlan | Boolean | Mapping to field t_ICItem.FBookPlan |
| UnitGroupNumber | String | Mapping to field t_UnitGroup.FUnitGroupID join with t_ICItem.FUnitGroupID |
| UnitGroupName | String | Mapping to field t_UnitGroup.FName join with t_ICItem.FUnitGroupID |
| UnitGroupUUID | String | Mapping to t_UnitGroup.UUID join with t_ICItem.FUnitGroupID |
| FixLeadTime | Double | Mapping to field t_ICItem.FFixLeadTime |
| BatChangeEconomy | Decimal | Mapping to field t_ICItem.FBatChangeEconomy |
| StdPayRate | Decimal | Mapping to field t_ICItem.FStdPayRate |
| ChgFeeRate | Decimal | Mapping to field t_ICItem.FChgFeeRate |
| StdFixFeeRate | Decimal | Mapping to field t_ICItem.FStdFixFeeRate |
| OutMachFee | Decimal | Mapping to field t_ICItem.FOutMachFee |
| ProfitRate | Double | Mapping to field t_ICItem.FProfitRate |
| StkChkPrd | Long | Mapping to field t_ICItem.FStkChkPrd |
| StkChkAlrm | Long | Mapping to field t_ICItem.FStkChkAlrm |
| SOLowPrc | Decimal | Mapping to field t_ICItem.FSOLowPrc |
| WWHghPrc | Decimal | Mapping to field t_ICItem.FWWHghPrc |
| IsEquipment | Boolean | Mapping to field t_ICItem.FIsEquipment |
| IsSparePart | Boolean | Mapping to field t_ICItem.FIsSparePart |
| EquipmentNum | String | Mapping to field t_ICItem.FEquipmentNum |
| POHghPrcMnyTypeNumber | String | Mapping to field t_Currency.FNumber join with t_ICItem.FPOHghPrcMnyType |
| POHghPrcMnyTypeName | String | Mapping to field t_Currency.FName join with t_ICItem.FPOHghPrcMnyType |
| POHghPrcMnyTypeUUID | String | Mapping to t_Currency.UUID join with t_ICItem.FPOHghPrcMnyType |
| WWHghPrcMnyTypeNumber | String | Mapping to field t_Currency.FNumber join with t_ICItem.FWWHghPrcMnyType |
| WWHghPrcMnyTypeName | String | Mapping to field t_Currency.FName join with t_ICItem.FWWHghPrcMnyType |
| WWHghPrcMnyTypeUUID | String | Mapping to t_Currency.UUID join with t_ICItem.FWWHghPrcMnyType |
| SOLowPrcMnyTypeNumber | String | Mapping to field t_Currency.FNumber join with t_ICItem.FSOLowPrcMnyType |
| SOLowPrcMnyTypeName | String | Mapping to field t_Currency.FName join with t_ICItem.FSOLowPrcMnyType |
| SOLowPrcMnyTypeUUID | String | Mapping to t_Currency.UUID join with t_ICItem.FSOLowPrcMnyType |
| FOrderUnitIDNumber | String | Mapping to field t_MeasureUnit.FNumber join with t_ICItem.FOrderUnitID |
| FOrderUnitIDName | String | Mapping to field t_MeasureUnit.FName join with t_ICItem.FOrderUnitID |
| FOrderUnitIDUUID | String | Mapping to t_MeasureUnit.UUID join with t_ICItem.FOrderUnitID |
| FSaleUnitIDNumber | String | Mapping to field t_MeasureUnit.FNumber join with t_ICItem.FSaleUnitID |
| FSaleUnitIDName | String | Mapping to field t_MeasureUnit.FName join with t_ICItem.FSaleUnitID |
| FSaleUnitIDUUID | String | Mapping to t_MeasureUnit.UUID join with t_ICItem.FSaleUnitID |
| FStoreUnitIDNumber | String | Mapping to field t_MeasureUnit.FNumber join with t_ICItem.FStoreUnitID |
| FStoreUnitIDName | String | Mapping to field t_MeasureUnit.FName join with t_ICItem.FStoreUnitID |
| FStoreUnitIDUUID | String | Mapping to t_MeasureUnit.UUID join with t_ICItem.FStoreUnitID |
| FProductUnitIDNumber | String | Mapping to field t_MeasureUnit.FNumber join with t_ICItem.FProductUnitID |
| FProductUnitIDName | String | Mapping to field t_MeasureUnit.FName join with t_ICItem.FProductUnitID |
| FProductUnitIDUUID | String | Mapping to t_MeasureUnit.UUID join with t_ICItem.FProductUnitID |
| FOrderPrice | Double | Mapping to field t_ICItem.FOrderPrice |
| FSecUnitIDNumber | String | Mapping to field t_MeasureUnit.FNumber join with t_ICItem.FSecUnitID |
| FSecUnitIDName | String | Mapping to field t_MeasureUnit.FName join with t_ICItem.FSecUnitID |
| FSecUnitIDUUID | String | Mapping to t_MeasureUnit.UUID join with t_ICItem.FSecUnitID |
| FSecUnitDecimal | Int | Mapping to field t_ICItem.FSecUnitDecimal |
| FSecCoefficient | Double | Mapping to field t_ICItem.FSecCoefficient |
| FInHighLimit | Double | Mapping to field t_ICItem.FInHighLimit |
| FInLowLimit | Double | Mapping to field t_ICItem.FInLowLimit |
| FPutInteger | Boolean | Mapping to field t_ICItem.FPutInteger |
| FPieceRate | Double | Mapping to field t_ICItem.FPieceRate |
| FplannerNumber | String | Mapping to field t_Item.FNumber join with t_ICItem.Fplanner |
| FplannerName | String | Mapping to field t_Item.FName join with t_ICItem.Fplanner |
| FplannerUUID | String | Mapping to t_Item.UUID join with t_ICItem.Fplanner |
| FLastCheckDate | DateTime | Mapping to field t_ICItem.FLastCheckDate |
| FCheckCycle | Int | Mapping to field t_ICItem.FCheckCycle |
| FCheckCycUnitNumber | String | Mapping to field t_SubMessage.FID join with t_ICItem.FCheckCycUnit |
| FCheckCycUnitName | String | Mapping to field t_SubMessage.FName join with t_ICItem.FCheckCycUnit |
| FCheckCycUnitUUID | String | Mapping to t_SubMessage.UUID join with t_ICItem.FCheckCycUnit |
| FDaysPer | Int | Mapping to field t_ICItem.FDaysPer |
| FOIHighLimit | Double | Mapping to field t_ICItem.FOIHighLimit |
| FOILowLimit | Double | Mapping to field t_ICItem.FOILowLimit |
| FSOHighLimit | Double | Mapping to field t_ICItem.FSOHighLimit |
| FSOLowLimit | Double | Mapping to field t_ICItem.FSOLowLimit |
| Version | String | Mapping to field t_ICItem.FVersion |
| IsSNManage | Boolean | Mapping to field t_ICItem.FIsSnManage |