Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: GL31 - «Fixed Assets File» («Файл осн. средств»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| GL31001 | VSTRING | 10 | InventoryCod | Да |
| GL31002 | VSTRING | 30 | DescrLine1 | |
| GL31003 | VSTRING | 30 | DescrLine2 | |
| GL31004 | VSTRING | 10 | InventGroup | |
| GL31005 | VSTRING | 50 | AccString | |
| GL31006 | VSTRING | 12 | Spare | |
| GL31007 | VSTRING | 12 | Spare | |
| GL31008 | VSTRING | 12 | Spare | |
| GL31009 | VSTRING | 12 | Spare | |
| GL31010 | VSTRING | 1 | RetrDeprec | |
| GL31011 | VSTRING | 1 | Spare | |
| GL31012 | VSTRING | 1 | Spare | |
| GL31013 | VSTRING | 3 | NoteNo | |
| GL31014 | VSTRING | 4 | CategoryA | |
| GL31015 | VSTRING | 4 | CategoryB | |
| GL31016 | VSTRING | 15 | Location | |
| GL31017 | VSTRING | 10 | SuplCode | |
| GL31018 | VSTRING | 32 | SupNameAddr1 | |
| GL31019 | VSTRING | 32 | SupNameAddr2 | |
| GL31020 | VSTRING | 32 | SupNameAddr3 | |
| GL31021 | VSTRING | 32 | SupNameAddr4 | |
| GL31022 | VSTRING | 25 | NameContact | |
| GL31023 | VSTRING | 15 | Telephone | |
| GL31024 | VSTRING | 15 | SupplInv | |
| GL31025 | VSTRING | 6 | TransactNo | |
| GL31026 | DATE | 8 | WarrExpDate | |
| GL31027 | VSTRING | 25 | InsuranceComp | |
| GL31028 | VSTRING | 20 | InsuranceNo | |
| GL31029 | MONEY | 20 | InsuredAm | |
| GL31030 | VSTRING | 20 | PurchPrice | |
| GL31031 | VSTRING | 20 | RePurchPr | |
| GL31032 | VSTRING | 20 | AccRepairs | |
| GL31033 | VSTRING | 20 | AccAddons | |
| GL31034 | DATE | 8 | DatePurch | |
| GL31035 | DATE | 8 | DateScrapped | |
| GL31036 | VSTRING | 4 | ScrSoldCode | |
| GL31037 | VSTRING | 6 | IndexValue | |
| GL31038 | STRING | 4 | LUpdDepr | |
| GL31039 | VSTRING | 1 | Spare | |
| GL31040 | VSTRING | 2 | Spare | |
| GL31041 | VSTRING | 6 | Spare | |
| GL31042 | MONEY | 20 | Spare | |
| GL31043 | VSTRING | 20 | Spare | |
| GL31044 | VSTRING | 20 | Spare | |
| GL31045 | VSTRING | 20 | Spare | |
| GL31046 | VSTRING | 20 | Spare | |
| GL31047 | VSTRING | 20 | Spare | |
| GL31048 | VSTRING | 1 | Spare | |
| GL31049 | VSTRING | 2 | Spare | |
| GL31050 | VSTRING | 6 | Spare | |
| GL31051 | MONEY | 20 | Spare | |
| GL31052 | VSTRING | 20 | Spare | |
| GL31053 | VSTRING | 20 | Spare | |
| GL31054 | VSTRING | 20 | Spare | |
| GL31055 | VSTRING | 20 | Spare | |
| GL31056 | VSTRING | 20 | Spare | |
| GL31057 | VSTRING | 2 | Spare | |
| GL31058 | VSTRING | 2 | Spare | |
| GL31059 | VSTRING | 2 | Spare | |
| GL31060 | VSTRING | 30 | InternRem1 | |
| GL31061 | VSTRING | 30 | InternRem2 | |
| GL31062 | VSTRING | 5 | InsuranCode | |
| GL31063 | VSTRING | 1 | DocFlag | |
| GL31064 | VSTRING | 20 | ServContract | |
| GL31065 | VSTRING | 1 | GenBudget | |
| GL31066 | VSTRING | 1 | GenTrans | |
| GL31067 | VSTRING | 15 | UserDefDat1 | |
| GL31068 | VSTRING | 10 | UserDefDat2 | |
| GL31069 | VSTRING | 10 | UserDefDat3 | |
| GL31070 | VSTRING | 5 | UserDefDat4 | |
| GL31071 | VSTRING | 1 | DeprMetC | |
| GL31072 | VSTRING | 2 | DeprPerC | |
| GL31073 | VSTRING | 6 | DeprCalc | |
| GL31074 | MONEY | 20 | DeprAmC | |
| GL31075 | VSTRING | 20 | DeprBaseC | |
| GL31076 | VSTRING | 20 | ScrapValC | |
| GL31077 | VSTRING | 20 | AccDeprC | |
| GL31078 | VSTRING | 20 | DeprecC | |
| GL31079 | VSTRING | 20 | ExtraDeprC | |
| GL31080 | VSTRING | 6 | IndexValueC | |
| GL31081 | DATE | 8 | DeprStrtDate | |
| GL31082 | VSTRING | 1 | NatSwitch1 | |
| GL31083 | VSTRING | 1 | NatSwitch2 | |
| GL31084 | VSTRING | 1 | NatSwitch3 | |
| GL31085 | DATE | 8 | NationDate1 | |
| GL31086 | DATE | 8 | NationDate2 | |
| GL31087 | DATE | 8 | NationDate3 | |
| GL31088 | MONEY | 20 | NatAmount1 | |
| GL31089 | MONEY | 20 | NatAmount2 | |
| GL31090 | MONEY | 20 | NatAmount3 | |
| GL31091 | VSTRING | 6 | Spare | |
| GL31092 | VSTRING | 6 | Spare | |
| GL31093 | VSTRING | 6 | Deprec2Calc | |
| GL31094 | VSTRING | 1 | Spare | |
| GL31095 | VSTRING | 1 | Spare | |
| GL31096 | VSTRING | 1 | DeprSwCalc |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | General Ledger (Главная Книга) | Fixed Assets File (Файл осн. средств)
/* */