Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: GL32 - «Fixed Assets Standard» («Стандарт осн. средств»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| GL32001 | VSTRING | 10 | InventCode | Да |
| GL32002 | VSTRING | 30 | DescrLine1 | |
| GL32003 | VSTRING | 30 | DescrLine2 | |
| GL32004 | VSTRING | 10 | InventGrCode | |
| GL32005 | VSTRING | 50 | BalAccAssets | |
| GL32006 | VSTRING | 12 | BalAccDepr | |
| GL32007 | VSTRING | 12 | PLAccDepr | |
| GL32008 | VSTRING | 12 | BalAccDepr2 | |
| GL32009 | VSTRING | 12 | PLAccDepr2 | |
| GL32010 | STRING | 1 | CostCenter | |
| GL32011 | VSTRING | 1 | ProductCode | |
| GL32012 | VSTRING | 1 | Project | |
| GL32013 | STRING | 3 | NoteNumber | |
| GL32014 | VSTRING | 4 | CategoryA | |
| GL32015 | VSTRING | 4 | CategoryB | |
| GL32016 | VSTRING | 15 | Location | |
| GL32017 | VSTRING | 10 | SupplierCode | |
| GL32018 | VSTRING | 32 | SupplierName | |
| GL32019 | VSTRING | 32 | SupplierAdd1 | |
| GL32020 | VSTRING | 32 | SupplierAdd2 | |
| GL32021 | VSTRING | 32 | SupplierAdd3 | |
| GL32022 | VSTRING | 25 | TechContact | |
| GL32023 | VSTRING | 15 | TelephNumber | |
| GL32024 | VSTRING | 15 | SupplInvNo | |
| GL32025 | VSTRING | 6 | NLTransNo | |
| GL32026 | DATE | 8 | WarrExpDate | |
| GL32027 | VSTRING | 25 | InsurancComp | |
| GL32028 | VSTRING | 20 | InsuranceNo | |
| GL32029 | MONEY | 20 | InsureAmount | |
| GL32030 | MONEY | 20 | PurchPrice | |
| GL32031 | MONEY | 20 | RePurchPri | |
| GL32032 | MONEY | 20 | AccRepairs | |
| GL32033 | MONEY | 20 | AccAddons | |
| GL32034 | DATE | 8 | DatePurchase | |
| GL32035 | DATE | 8 | DateScraSold | |
| GL32036 | VSTRING | 4 | ScraSoldCode | |
| GL32037 | X_NUMERIC | 6 | IndexValue | |
| GL32038 | VSTRING | 4 | LastUpdDepr | |
| GL32039 | STRING | 1 | TaxDeprMeth | |
| GL32040 | INTEGER | 2 | TaxDeprPerYr | |
| GL32041 | X_NUMERIC | 6 | TaxDeprec | |
| GL32042 | MONEY | 20 | TaxDeprAm | |
| GL32043 | MONEY | 20 | TaxDeprBase | |
| GL32044 | MONEY | 20 | TaxScrapVal | |
| GL32045 | MONEY | 20 | TaxAccumDepr | |
| GL32046 | MONEY | 20 | TaxDeprYear | |
| GL32047 | MONEY | 20 | TaxExtraDepr | |
| GL32048 | STRING | 1 | PlanDeprMeth | |
| GL32049 | INTEGER | 2 | PlanDeprPerY | |
| GL32050 | X_NUMERIC | 6 | PlanDeprec | |
| GL32051 | MONEY | 20 | PlanDeprAm | |
| GL32052 | MONEY | 20 | PlanDeprBase | |
| GL32053 | MONEY | 20 | PlanScrapVal | |
| GL32054 | MONEY | 20 | PlanAccDepr | |
| GL32055 | MONEY | 20 | PlanDeprYear | |
| GL32056 | MONEY | 20 | PlanExtraDep | |
| GL32057 | STRING | 2 | PlanPeriodN1 | |
| GL32058 | STRING | 2 | PlanPeriodN2 | |
| GL32059 | STRING | 2 | PlanPeriodN3 | |
| GL32060 | VSTRING | 30 | InternalRem1 | |
| GL32061 | VSTRING | 30 | InternalRem2 | |
| GL32062 | VSTRING | 5 | InsurancCode | |
| GL32063 | STRING | 1 | DocumentFlag | |
| GL32064 | VSTRING | 20 | ServContract | |
| GL32065 | STRING | 1 | GenerateBudg | |
| GL32066 | STRING | 1 | GenerateTran | |
| GL32067 | VSTRING | 15 | UserDefData1 | |
| GL32068 | VSTRING | 10 | UserDefData2 | |
| GL32069 | VSTRING | 10 | UserDefData3 | |
| GL32070 | VSTRING | 5 | UserDefData4 | |
| GL32071 | INTEGER | 1 | CalcDeprMeth | |
| GL32072 | INTEGER | 2 | CalcDeprPerY | |
| GL32073 | X_NUMERIC | 6 | CalcDeprec | |
| GL32074 | MONEY | 20 | CalcDeprAm | |
| GL32075 | MONEY | 20 | CalcDeprBase | |
| GL32076 | MONEY | 20 | CalcScrapVal | |
| GL32077 | MONEY | 20 | CalcAccDepr | |
| GL32078 | MONEY | 20 | CalcDeprYear | |
| GL32079 | MONEY | 20 | CalcExtraDep | |
| GL32080 | X_NUMERIC | 6 | CalcIndexVal | |
| GL32081 | DATE | 8 | DepStartDate | |
| GL32082 | INTEGER | 1 | NationalSw1 | |
| GL32083 | INTEGER | 1 | NationalSw2 | |
| GL32084 | INTEGER | 1 | NationalSw3 | |
| GL32085 | DATE | 8 | NationDate1 | |
| GL32086 | DATE | 8 | NationDate2 | |
| GL32087 | DATE | 8 | NationDate3 | |
| GL32088 | MONEY | 20 | NationalAm1 | |
| GL32089 | MONEY | 20 | NationalAm2 | |
| GL32090 | MONEY | 20 | NationalAm3 | |
| GL32091 | X_NUMERIC | 6 | DepreciatTAX | |
| GL32092 | X_NUMERIC | 6 | DeprecPlan | |
| GL32093 | X_NUMERIC | 6 | DeprecCalc | |
| GL32094 | INTEGER | 1 | DepSwitcTask | |
| GL32095 | INTEGER | 1 | DepSwitcPlan | |
| GL32096 | INTEGER | 1 | DepSwitchCalc |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | General Ledger (Главная Книга) | Fixed Assets Standard (Стандарт осн. средств)
/* */