Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: SC03 - «Warehouse File» («Файл Складов»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| SC03001 | VSTRING | 35 | StockCode | Да |
| SC03002 | VSTRING | 6 | LocationID | Да |
| SC03003 | X_NUMERIC | 12 | StockBalance | |
| SC03004 | X_NUMERIC | 12 | ReservedQty | |
| SC03005 | X_NUMERIC | 12 | BackOrdQty | |
| SC03006 | X_NUMERIC | 12 | QtyOrdered1 | |
| SC03007 | X_NUMERIC | 12 | StockTakDiff | |
| SC03008 | INTEGER | 3 | DelTimeToWH | |
| SC03009 | DATE | 8 | StockTakDate | |
| SC03010 | X_NUMERIC | 12 | ReOrderLevel | |
| SC03011 | X_NUMERIC | 12 | OptPurchQty | |
| SC03012 | X_NUMERIC | 12 | BudgQtyYear | |
| SC03013 | VSTRING | 6 | DefaultBinNo | |
| SC03014 | MONEY | 20 | LowesPurchPr | |
| SC03015 | X_NUMERIC | 12 | LockedQty | |
| SC03016 | X_NUMERIC | 12 | AllocQty | |
| SC03017 | MONEY | 20 | StockTakDiff | |
| SC03018 | X_NUMERIC | 12 | MinPurchQty | |
| SC03019 | X_NUMERIC | 12 | MaxPurchQty | |
| SC03020 | INTEGER | 1 | DelTimeUnit | |
| SC03021 | VSTRING | 4 | DelCalenCode | |
| SC03022 | VSTRING | 10 | Supplier | |
| SC03023 | VSTRING | 10 | AlternSuppli | |
| SC03024 | VSTRING | 35 | SuppStocCode | |
| SC03025 | MONEY | 20 | StockTakDiffCCU | |
| SC03026 | VSTRING | 2 | CurrCodPurch | |
| SC03027 | VSTRING | 3 | CountOfOrig | |
| SC03028 | SWITCH | 1 | FLAGDiffSupp | |
| SC03029 | MONEY | 20 | FIFOValue1 | |
| SC03030 | VSTRING | 5 | Spare | |
| SC03031 | VSTRING | 5 | Spare | |
| SC03032 | VSTRING | 10 | Spare | |
| SC03033 | DATE | 8 | StdCostLaCaD | |
| SC03034 | VSTRING | 8 | Spare | |
| SC03035 | VSTRING | 8 | Spare | |
| SC03036 | VSTRING | 8 | Spare | |
| SC03037 | VSTRING | 6 | Spare | |
| SC03038 | VSTRING | 6 | Spare | |
| SC03039 | VSTRING | 6 | Spare | |
| SC03040 | VSTRING | 4 | Spare | |
| SC03041 | VSTRING | 4 | Spare | |
| SC03042 | VSTRING | 4 | Spare | |
| SC03043 | VSTRING | 4 | Spare | |
| SC03044 | VSTRING | 2 | Spare | |
| SC03045 | VSTRING | 2 | Spare | |
| SC03046 | VSTRING | 2 | Spare | |
| SC03047 | VSTRING | 2 | Spare | |
| SC03048 | VSTRING | 2 | Spare | |
| SC03049 | VSTRING | 1 | Spare | |
| SC03050 | VSTRING | 1 | Spare | |
| SC03051 | VSTRING | 1 | Spare | |
| SC03052 | VSTRING | 1 | Spare | |
| SC03053 | VSTRING | 1 | Spare | |
| SC03054 | DATE | 8 | DelDateSuppl | |
| SC03055 | DATE | 8 | DelDateCust | |
| SC03056 | DATE | 8 | OrdDateSuppl | |
| SC03057 | X_NUMERIC | 20 | AverCostPrc2 | |
| SC03058 | MONEY | 20 | StdCostPrc2 | |
| SC03059 | MONEY | 20 | LandedCost | |
| SC03060 | X_NUMERIC | 6 | PurchSurchar | |
| SC03061 | INTEGER | 1 | BudgetModel | |
| SC03062 | X_NUMERIC | 12 | QtyOrdered2 | |
| SC03063 | VSTRING | 20 | UnAllocCosts | |
| SC03064 | X_NUMERIC | 20 | AverCostPric | |
| SC03065 | MONEY | 20 | StdCostPrice | |
| SC03066 | MONEY | 20 | FIFOValue2 | |
| SC03067 | MONEY | 20 | LowesPurchPr | |
| SC03068 | STRING | 2 | BatcNoPrefix | |
| SC03069 | NUMBER | 6 | BatchNumber | |
| SC03070 | NUMBER | 3 | BatcNoSuffix | |
| SC03071 | STRING | 1 | FixBinLocat | |
| SC03072 | NUMBER | 12 | QC_OnHand | |
| SC03073 | STRING | 1 | ABC_Categ | |
| SC03074 | STRING | 3 | ABC_Group | |
| SC03075 | STRING | 3 | BOA_Number | |
| SC03076 | MONEY | 20 | ABC_Cost1 | |
| SC03077 | MONEY | 20 | ABC_Cost2 | |
| SC03078 | MONEY | 20 | DirectCost | |
| SC03079 | MONEY | 20 | PrevStdCost | |
| SC03080 | MONEY | 20 | NxtYrStdCost | |
| SC03081 | MONEY | 20 | SimuStdCost | |
| SC03082 | X_NUMERIC | 12 | CostingQty | |
| SC03083 | STRING | 1 | MPS_Planned | |
| SC03084 | STRING | 1 | MRP_Planned | |
| SC03085 | STRING | 1 | MRPNeed | |
| SC03086 | INTEGER | 3 | NoOfDays | |
| SC03087 | INTEGER | 3 | TimeBucket | |
| SC03088 | STRING | 1 | PlanMethod | |
| SC03089 | VSTRING | 15 | Planner | |
| SC03090 | STRING | 1 | LotSizeMeth | |
| SC03091 | STRING | 6 | Multiple | |
| SC03092 | X_NUMERIC | 12 | SafetyStock | |
| SC03093 | X_NUMERIC | 12 | Forecast1 | |
| SC03094 | X_NUMERIC | 12 | Forecast2 | |
| SC03095 | X_NUMERIC | 12 | Forecast3 | |
| SC03096 | X_NUMERIC | 12 | Forecast4 | |
| SC03097 | DATE | 8 | LatestConsol | |
| SC03098 | X_NUMERIC | 12 | MaxStockQty | |
| SC03099 | X_NUMERIC | 12 | Turnover | |
| SC03100 | STRING | 1 | SettPricType | |
| SC03101 | STRING | 3 | SettPricList | |
| SC03102 | STRING | 3 | CurrencyCode | |
| SC03103 | X_NUMERIC | 12 | QtyOnPickLis | |
| SC03104 | STRING | 3 | Spare | |
| SC03105 | STRING | 3 | Spare | |
| SC03106 | STRING | 3 | Spare | |
| SC03107 | STRING | 1 | Spare | |
| SC03108 | STRING | 1 | Spare | |
| SC03109 | VSTRING | 8 | Spare | |
| SC03110 | X_NUMERIC | 12 | Spare | |
| SC03111 | MONEY | 20 | Spare |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Stock Control (Управление Запасами) | Warehouse File (Файл Складов)
/* */