Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: SC01 - «Stock Item File» («Файл Поз.Запасов»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| SC01001 | VSTRING | 35 | StockCode | Да |
| SC01002 | VSTRING | 25 | Description1 | |
| SC01003 | VSTRING | 25 | Description2 | |
| SC01004 | MONEY | 20 | PriceLocCurr | |
| SC01005 | MONEY | 20 | NewPriceLCU | |
| SC01006 | DATE | 8 | DateNewPrice | |
| SC01007 | X_NUMERIC | 10 | Lenght | |
| SC01008 | X_NUMERIC | 10 | Width | |
| SC01009 | X_NUMERIC | 10 | Height | |
| SC01010 | VSTRING | 10 | UserDefined1 | |
| SC01011 | VSTRING | 10 | UserDefined2 | |
| SC01012 | VSTRING | 8 | UserDefined3 | |
| SC01013 | VSTRING | 6 | UserDefined4 | |
| SC01014 | VSTRING | 4 | UserDefined5 | |
| SC01015 | VSTRING | 4 | UserDefined6 | |
| SC01016 | VSTRING | 2 | UserDefined7 | |
| SC01017 | VSTRING | 2 | UserDefined8 | |
| SC01018 | VSTRING | 2 | UserDefined9 | |
| SC01019 | VSTRING | 2 | UserDefine10 | |
| SC01020 | SWITCH | 1 | AllowNegQty | |
| SC01021 | INTEGER | 1 | TestSNqty | |
| SC01022 | SWITCH | 1 | AllwAlphaSN | |
| SC01023 | VSTRING | 20 | ExtProdGroup | |
| SC01024 | VSTRING | 25 | AlphSerchKey | |
| SC01025 | VSTRING | 10 | UnConvSalPr | |
| SC01026 | VSTRING | 3 | Purchaser | |
| SC01027 | VSTRING | 3 | Planner | |
| SC01028 | VSTRING | 27 | SC0128SPARE | |
| SC01029 | VSTRING | 8 | SC0129SPARE | |
| SC01030 | VSTRING | 1 | ReplacemItem | |
| SC01031 | INTEGER | 2 | DiscountCode | |
| SC01032 | SWITCH | 1 | FLAGusesBatc | |
| SC01033 | INTEGER | 1 | ExtraTaxCode | |
| SC01034 | INTEGER | 1 | DistCharCode | |
| SC01035 | STRING | 2 | AccountCode | |
| SC01036 | VSTRING | 4 | DelCalenCode | |
| SC01037 | VSTRING | 4 | ProductGroup | |
| SC01038 | VSTRING | 4 | AltProdGroup | |
| SC01039 | ACCSTR | 50 | AccCodeStrg | |
| SC01040 | X_NUMERIC | 12 | MinPurchQty | |
| SC01041 | X_NUMERIC | 12 | MaxPurchQty | |
| SC01042 | X_NUMERIC | 12 | StockBalance | |
| SC01043 | X_NUMERIC | 12 | ReservedQty | |
| SC01044 | X_NUMERIC | 12 | BackOrdeQty | |
| SC01045 | X_NUMERIC | 12 | SCQtyOrder | |
| SC01046 | X_NUMERIC | 12 | StockTakDiff | |
| SC01047 | VSTRING | 2 | UnitCodSalPr | |
| SC01048 | DATE | 8 | StockTakDate | |
| SC01049 | DATE | 8 | DelDateSuppl | |
| SC01050 | DATE | 8 | DelDateCust | |
| SC01051 | DATE | 8 | OrdDateSuppl | |
| SC01052 | X_NUMERIC | 20 | AverCostPri1 | |
| SC01053 | MONEY | 20 | StdCostPric1 | |
| SC01054 | X_NUMERIC | 12 | QtyRecSuppl | |
| SC01055 | MONEY | 20 | PurchasePric | |
| SC01056 | VSTRING | 2 | CurrCodePurc | |
| SC01057 | X_NUMERIC | 6 | CalcSurcharg | |
| SC01058 | VSTRING | 10 | SupplierCode | |
| SC01059 | VSTRING | 10 | AlternSuppl | |
| SC01060 | VSTRING | 35 | SupplStockCo | |
| SC01061 | X_NUMERIC | 12 | ReOrdLevel | |
| SC01062 | INTEGER | 3 | DelTimeWeek | |
| SC01063 | X_NUMERIC | 12 | OptPurchQty | |
| SC01064 | X_NUMERIC | 12 | BudgQTYYear | |
| SC01065 | INTEGER | 1 | BudgetModel | |
| SC01066 | INTEGER | 1 | ArticlStatus | |
| SC01067 | VSTRING | 3 | CountOfOrgin | |
| SC01068 | INTEGER | 1 | DelTimeUnit | |
| SC01069 | X_NUMERIC | 10 | NetWeight | |
| SC01070 | X_NUMERIC | 10 | GrossWeight | |
| SC01071 | X_NUMERIC | 10 | Volume | |
| SC01072 | X_NUMERIC | 10 | QtyUnitInDel | |
| SC01073 | X_NUMERIC | 10 | QtyUniOutDel | |
| SC01074 | VSTRING | 1 | ABCCode | |
| SC01075 | VSTRING | 1 | FrequenCode | |
| SC01076 | SWITCH | 1 | AttachedFlag | |
| SC01077 | MONEY | 20 | ProfitLCUPer | |
| SC01078 | MONEY | 20 | ProfitLCUYTD | |
| SC01079 | MONEY | 20 | ProYTDPrevYr | |
| SC01080 | MONEY | 20 | ProfYTDPrYr1 | |
| SC01081 | MONEY | 20 | SalesLCUPer | |
| SC01082 | MONEY | 20 | SalesLCUYTD | |
| SC01083 | MONEY | 20 | SalYTDPrevYr | |
| SC01084 | MONEY | 20 | SaleYTDPrYr1 | |
| SC01085 | X_NUMERIC | 12 | QtyLCUPeriod | |
| SC01086 | X_NUMERIC | 12 | QtyLCUYTD | |
| SC01087 | X_NUMERIC | 12 | QtyYTDPreYr | |
| SC01088 | X_NUMERIC | 12 | QtyYTDPrYr1 | |
| SC01089 | VSTRING | 35 | ReplStocCode | |
| SC01090 | INTEGER | 1 | PurchRoule | |
| SC01091 | INTEGER | 1 | ShipmRoule | |
| SC01092 | DATE | 8 | DesNewPrice | |
| SC01093 | VSTRING | 25 | InternRem1 | |
| SC01094 | VSTRING | 25 | InternRem2 | |
| SC01095 | INTEGER | 1 | CommissCode | |
| SC01096 | INTEGER | 1 | StructurFlag | |
| SC01097 | INTEGER | 1 | QueryQueNo | |
| SC01098 | X_NUMERIC | 10 | SellPricMult | |
| SC01099 | X_NUMERIC | 10 | PurcPricMult | |
| SC01100 | VSTRING | 14 | StatCodeExte | |
| SC01101 | INTEGER | 3 | CustWarrMont | |
| SC01102 | STRING | 4 | InspecInterv | |
| SC01103 | STRING | 4 | MaintenInter | |
| SC01104 | INTEGER | 2 | AccrualCode | |
| SC01105 | INTEGER | 2 | CommisCode2 | |
| SC01106 | MONEY | 20 | LandedCost | |
| SC01107 | VSTRING | 1 | ServiceLevel | |
| SC01108 | MONEY | 20 | PrfLCUNxtPer | |
| SC01109 | MONEY | 20 | PrfLCUNetYTD | |
| SC01110 | MONEY | 20 | SalLCUNxtPer | |
| SC01111 | MONEY | 20 | SalLCUNxtYTD | |
| SC01112 | X_NUMERIC | 12 | QtyLCUNxtPer | |
| SC01113 | X_NUMERIC | 12 | QtyLCUNxtYTD | |
| SC01114 | VSTRING | 6 | DefaultBinNo | |
| SC01115 | VSTRING | 1 | MaintContCod | |
| SC01116 | DATE | 8 | RecCreatDate | |
| SC01117 | SWITCH | 1 | ContrDistrib | |
| SC01118 | DATE | 8 | StarContDist | |
| SC01119 | DATE | 8 | EndContDist | |
| SC01120 | SWITCH | 1 | HoldStatus | |
| SC01121 | DATE | 8 | HldStaSrtDat | |
| SC01122 | DATE | 8 | HldStaEndDat | |
| SC01123 | DATE | 8 | EndOfLifeDat | |
| SC01124 | DATE | 8 | ObsoleteDate | |
| SC01125 | DATE | 8 | ReplacemDate | |
| SC01126 | VSTRING | 35 | EquiStckCode | |
| SC01127 | INTEGER | 1 | SerNoStatus | |
| SC01128 | VSTRING | 10 | ProductCateg | |
| SC01129 | INTEGER | 1 | BudgetMode | |
| SC01130 | VSTRING | 2 | ApplicCode1 | |
| SC01131 | VSTRING | 2 | ApplicCode2 | |
| SC01132 | VSTRING | 35 | EANCode | |
| SC01133 | INTEGER | 2 | UnitCodeStoc | |
| SC01134 | INTEGER | 2 | UnitCodePurc | |
| SC01135 | INTEGER | 2 | UnitCodeSale | |
| SC01136 | INTEGER | 2 | UnitCodeMPC | |
| SC01137 | INTEGER | 2 | UnitCodeSpar | |
| SC01138 | VSTRING | 4 | SPARE | |
| SC01139 | X_NUMERIC | 10 | UnitConvStoc | |
| SC01140 | X_NUMERIC | 10 | UnitConvPurc | |
| SC01141 | X_NUMERIC | 10 | UnitConvSale | |
| SC01142 | X_NUMERIC | 10 | UnitConvMPC | |
| SC01143 | X_NUMERIC | 10 | UnitConvSpar | |
| SC01144 | INTEGER | 2 | VATCode1 | |
| SC01145 | INTEGER | 2 | VATCode2 | |
| SC01146 | MONEY | 20 | StandRepCost | |
| SC01147 | SWITCH | 1 | FlagReparab | |
| SC01148 | MONEY | 20 | StanCostPric | |
| SC01149 | MONEY | 20 | AverCostPric | |
| SC01150 | VSTRING | 35 | ComplStockIt | |
| SC01151 | INTEGER | 1 | FlagExchRule | |
| SC01152 | STRING | 2 | BatcNoPrefix | |
| SC01153 | NUMBER | 6 | BatchNumber | |
| SC01154 | NUMBER | 3 | BatcNOSuffix | |
| SC01155 | X_NUMERIC | 12 | QC_OnHand | |
| SC01156 | STRING | 3 | BOA_Number | |
| SC01157 | MONEY | 20 | ABC_Cost1 | |
| SC01158 | MONEY | 20 | ABC_Cost2 | |
| SC01159 | MONEY | 20 | DirectCost | |
| SC01160 | STRING | 2 | DistrComp01 | |
| SC01161 | STRING | 2 | DistrComp02 | |
| SC01162 | STRING | 2 | DistrComp03 | |
| SC01163 | STRING | 2 | DistrComp04 | |
| SC01164 | STRING | 2 | DistrComp05 | |
| SC01165 | STRING | 2 | DistrComp06 | |
| SC01166 | STRING | 2 | DistrComp07 | |
| SC01167 | STRING | 2 | DistrComp08 | |
| SC01168 | STRING | 2 | DistrComp09 | |
| SC01169 | STRING | 2 | DistrComp10 | |
| SC01170 | STRING | 2 | DistrComp11 | |
| SC01171 | STRING | 2 | DistrComp12 | |
| SC01172 | STRING | 2 | DistrComp13 | |
| SC01173 | STRING | 2 | DistrComp14 | |
| SC01174 | STRING | 2 | DistrComp15 | |
| SC01175 | STRING | 2 | DistrComp16 | |
| SC01176 | STRING | 2 | DistrComp17 | |
| SC01177 | STRING | 2 | DistrComp18 | |
| SC01178 | STRING | 2 | DistrComp19 | |
| SC01179 | STRING | 2 | DistrComp20 | |
| SC01180 | STRING | 1 | OverDeliveryContr | |
| SC01181 | X_NUMERIC | 6 | OverDeliveryPerc | |
| SC01182 | X_NUMERIC | 12 | OverDeliveryQTY |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Stock Control (Управление Запасами) | Stock Item File (Файл Поз.Запасов)
/* */