Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: SC37 - «Standard Stock Items» («Станд.Поз. Запасов»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| SC37001 | VSTRING | 35 | StockCode | Да |
| SC37002 | VSTRING | 25 | Description1 | |
| SC37003 | VSTRING | 25 | Description2 | |
| SC37004 | MONEY | 20 | PriceLocCurr | |
| SC37005 | MONEY | 20 | NewPriceLCU | |
| SC37006 | DATE | 8 | DateNewPrice | |
| SC37007 | X_NUMERIC | 10 | Lenght | |
| SC37008 | X_NUMERIC | 10 | Width | |
| SC37009 | X_NUMERIC | 10 | Height | |
| SC37010 | VSTRING | 10 | UserDefin1 | |
| SC37011 | VSTRING | 10 | UserDefin2 | |
| SC37012 | VSTRING | 8 | UserDefin3 | |
| SC37013 | VSTRING | 6 | UserDefin4 | |
| SC37014 | VSTRING | 4 | UserDefin5 | |
| SC37015 | VSTRING | 4 | UserDefin6 | |
| SC37016 | VSTRING | 2 | UserDefin7 | |
| SC37017 | VSTRING | 2 | UserDefin8 | |
| SC37018 | VSTRING | 2 | UserDefin9 | |
| SC37019 | VSTRING | 2 | UserDefin10 | |
| SC37020 | SWITCH | 1 | AllowNegQty | |
| SC37021 | INTEGER | 1 | FLAGTstSNqty | |
| SC37022 | SWITCH | 1 | FLAGAlphanSN | |
| SC37023 | VSTRING | 20 | ExtProdGroup | |
| SC37024 | VSTRING | 25 | Spare | |
| SC37025 | VSTRING | 10 | Spare | |
| SC37026 | VSTRING | 3 | Spare | |
| SC37027 | VSTRING | 3 | Spare | |
| SC37028 | VSTRING | 27 | Spare | |
| SC37029 | VSTRING | 8 | Spare | |
| SC37030 | SWITCH | 1 | Spare | |
| SC37031 | INTEGER | 2 | DiscountCode | |
| SC37032 | SWITCH | 1 | FLAGusesBatc | |
| SC37033 | INTEGER | 1 | ExtraTaxCode | |
| SC37034 | INTEGER | 1 | DistChargCod | |
| SC37035 | STRING | 2 | AccountCode | |
| SC37036 | VSTRING | 4 | DelCalenCode | |
| SC37037 | VSTRING | 4 | ProductGroup | |
| SC37038 | VSTRING | 4 | AltProdGroup | |
| SC37039 | ACCSTR | 50 | AccCodeStrin | |
| SC37040 | X_NUMERIC | 12 | MinPurchQty | |
| SC37041 | X_NUMERIC | 12 | MaxPurchQty | |
| SC37042 | X_NUMERIC | 12 | StockBalance | |
| SC37043 | X_NUMERIC | 12 | ReservedQty | |
| SC37044 | X_NUMERIC | 12 | BackOrdQty | |
| SC37045 | X_NUMERIC | 12 | SCQtyOrd | |
| SC37046 | X_NUMERIC | 12 | StockTakDiff | |
| SC37047 | INTEGER | 2 | Spare | |
| SC37048 | DATE | 8 | StockTakDate | |
| SC37049 | DATE | 8 | DelDateSuppl | |
| SC37050 | DATE | 8 | DelDateCust | |
| SC37051 | DATE | 8 | OrdDateSuppl | |
| SC37052 | MONEY | 20 | AverCostPrc1 | |
| SC37053 | MONEY | 20 | StdCostPric1 | |
| SC37054 | X_NUMERIC | 12 | QtyRecSuppl | |
| SC37055 | MONEY | 20 | PurchasPrice | |
| SC37056 | VSTRING | 2 | CurrCodePurc | |
| SC37057 | X_NUMERIC | 6 | CalcSurcharg | |
| SC37058 | VSTRING | 10 | SupplierCode | |
| SC37059 | VSTRING | 10 | AlternSuppl | |
| SC37060 | VSTRING | 35 | SuppStocCod | |
| SC37061 | VSTRING | 12 | ReOrderLevel | |
| SC37062 | VSTRING | 3 | DelTimeWeek | |
| SC37063 | X_NUMERIC | 12 | OptPurchQty | |
| SC37064 | X_NUMERIC | 12 | BudgQtyYear | |
| SC37065 | INTEGER | 1 | BudgetModel | |
| SC37066 | INTEGER | 1 | ArticleStatus | |
| SC37067 | VSTRING | 3 | CountOfOrgin | |
| SC37068 | INTEGER | 1 | DelTimeUnit | |
| SC37069 | X_NUMERIC | 10 | NetWeight | |
| SC37070 | X_NUMERIC | 10 | GrossWeight | |
| SC37071 | X_NUMERIC | 10 | Volume | |
| SC37072 | X_NUMERIC | 10 | QtyUnitInDel | |
| SC37073 | X_NUMERIC | 10 | QtyUniOutDel | |
| SC37074 | VSTRING | 1 | ABCCode | |
| SC37075 | VSTRING | 1 | FrequeCode | |
| SC37076 | SWITCH | 1 | AttachedFlag | |
| SC37077 | MONEY | 20 | ProfitLCUPer | |
| SC37078 | MONEY | 20 | ProfitLCUYTD | |
| SC37079 | MONEY | 20 | ProfYTDPreYr | |
| SC37080 | MONEY | 20 | ProfYTDPrYr1 | |
| SC37081 | MONEY | 20 | SalesLCUPer | |
| SC37082 | MONEY | 20 | SalesLCUYTD | |
| SC37083 | MONEY | 20 | SalYTDPrevYr | |
| SC37084 | MONEY | 20 | SalYTDPrYr1 | |
| SC37085 | X_NUMERIC | 12 | QtyLCUPeriod | |
| SC37086 | X_NUMERIC | 12 | QtyLCUYTD | |
| SC37087 | X_NUMERIC | 12 | QtyYTDPreYer | |
| SC37088 | X_NUMERIC | 12 | QtyYTDPrYr1 | |
| SC37089 | VSTRING | 35 | ReplStocCode | |
| SC37090 | VSTRING | 1 | PurchasRoule | |
| SC37091 | VSTRING | 1 | ShipmenRoule | |
| SC37092 | DATE | 8 | DesacNewPric | |
| SC37093 | VSTRING | 25 | InternRemar1 | |
| SC37094 | VSTRING | 25 | InternRemar2 | |
| SC37095 | INTEGER | 1 | CommissCode | |
| SC37096 | INTEGER | 1 | StructurFlag | |
| SC37097 | INTEGER | 1 | QueryQueNo | |
| SC37098 | X_NUMERIC | 10 | SellPricMult | |
| SC37099 | X_NUMERIC | 10 | PurcPricMult | |
| SC37100 | VSTRING | 14 | StatCodeExte | |
| SC37101 | VSTRING | 3 | CustWarrMont | |
| SC37102 | VSTRING | 4 | InspecInterv | |
| SC37103 | VSTRING | 4 | MaintenInterl | |
| SC37104 | INTEGER | 2 | AccrualCode | |
| SC37105 | INTEGER | 2 | CommissCode2 | |
| SC37106 | MONEY | 20 | LandedCost | |
| SC37107 | VSTRING | 1 | ServiceLevel | |
| SC37108 | MONEY | 20 | ProLCUNexPer | |
| SC37109 | MONEY | 20 | ProLCUNexYTD | |
| SC37110 | MONEY | 20 | SalLCUNexPer | |
| SC37111 | MONEY | 20 | SalLCUNexYTD | |
| SC37112 | X_NUMERIC | 12 | QtyLCUNexPer | |
| SC37113 | X_NUMERIC | 12 | QtyLCUNexYTD | |
| SC37114 | VSTRING | 6 | DefaultBinNo | |
| SC37115 | VSTRING | 1 | MainContrCod | |
| SC37116 | DATE | 8 | RecCreatDate | |
| SC37117 | VSTRING | 1 | ContrDistrib | |
| SC37118 | DATE | 8 | StarContDist | |
| SC37119 | DATE | 8 | EndContDist | |
| SC37120 | VSTRING | 1 | HoldStatus | |
| SC37121 | DATE | 8 | HldStaSrtDat | |
| SC37122 | DATE | 8 | HldStaEndDat | |
| SC37123 | DATE | 8 | EndOfLifeDat | |
| SC37124 | DATE | 8 | ObsoleteDate | |
| SC37125 | DATE | 8 | ReplacemDate | |
| SC37126 | VSTRING | 35 | EquStocCode | |
| SC37127 | INTEGER | 1 | SerialNoStat | |
| SC37128 | VSTRING | 10 | ProductCateg | |
| SC37129 | INTEGER | 1 | BudgetMode | |
| SC37130 | VSTRING | 2 | ApplicCode1 | |
| SC37131 | VSTRING | 2 | ApplicCode2 | |
| SC37132 | VSTRING | 35 | EANCode | |
| SC37133 | INTEGER | 2 | UnitCodeStoc | |
| SC37134 | INTEGER | 2 | UnitCodePurc | |
| SC37135 | INTEGER | 2 | UnitCodeSale | |
| SC37136 | INTEGER | 2 | UnitCodeMPC | |
| SC37137 | INTEGER | 2 | UnitCodeSpar | |
| SC37138 | VSTRING | 4 | Spare | |
| SC37139 | VSTRING | 10 | UnitConvStoc | |
| SC37140 | VSTRING | 10 | UnitConvPurc | |
| SC37141 | VSTRING | 10 | UnitConvSale | |
| SC37142 | VSTRING | 10 | UnitConvMPC | |
| SC37143 | VSTRING | 10 | UnitConvSpar | |
| SC37144 | INTEGER | 2 | VATCode1 | |
| SC37145 | INTEGER | 2 | VATCode2 | |
| SC37146 | MONEY | 20 | StdRepaiCost | |
| SC37147 | SWITCH | 1 | FlagReparab | |
| SC37148 | MONEY | 20 | StdCostPrice | |
| SC37149 | MONEY | 20 | AverCostPric | |
| SC37150 | VSTRING | 35 | CompStocItem | |
| SC37151 | INTEGER | 1 | ExchangeRule | |
| SC37152 | STRING | 2 | BatcNoPrefix | |
| SC37153 | NUMBER | 6 | BatchNumber | |
| SC37154 | NUMBER | 3 | BatcNoSuffix | |
| SC37155 | X_NUMERIC | 12 | QC_OnHand | |
| SC37156 | STRING | 3 | BOA_Number | |
| SC37157 | MONEY | 20 | ABC_Cost1 | |
| SC37158 | MONEY | 20 | ABC_Cost2 | |
| SC37159 | MONEY | 20 | DirectCost | |
| SC37160 | STRING | 2 | DistriComp01 | |
| SC37161 | STRING | 2 | DistriComp02 | |
| SC37162 | STRING | 2 | DistriComp03 | |
| SC37163 | STRING | 2 | DistriComp04 | |
| SC37164 | STRING | 2 | DistriComp05 | |
| SC37165 | STRING | 2 | DistriComp06 | |
| SC37166 | STRING | 2 | DistriComp07 | |
| SC37167 | STRING | 2 | DistriComp08 | |
| SC37168 | STRING | 2 | DistriComp09 | |
| SC37169 | STRING | 2 | DistriComp10 | |
| SC37170 | STRING | 2 | DistriComp11 | |
| SC37171 | STRING | 2 | DistriComp12 | |
| SC37172 | STRING | 2 | DistriComp13 | |
| SC37173 | STRING | 2 | DistriComp14 | |
| SC37174 | STRING | 2 | DistriComp15 | |
| SC37175 | STRING | 2 | DistriComp16 | |
| SC37176 | STRING | 2 | DistriComp17 | |
| SC37177 | STRING | 2 | DistriComp18 | |
| SC37178 | STRING | 2 | DistriComp19 | |
| SC37179 | STRING | 2 | DistriComp20 | |
| SC37180 | STRING | 1 | OverDeliveryContr | |
| SC37181 | X_NUMERIC | 6 | OverDeliveryPerc | |
| SC37182 | X_NUMERIC | 12 | OverDeliveryQTY |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Stock Control (Управление Запасами) | Standard Stock Items (Станд.Поз. Запасов)
/* */