Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: GLHI - «FA Transaction History». Маска имени таблицы: «GLHI%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
GLHI001 | NVARCHAR | VSTRING | 3 | 0 | 3 | TransCod | NULL | 1 | Да | |
GLHI002 | DATETIME | DATE | 0 | 0 | 8 | TransDate | NULL | 2 | Да | |
GLHI003 | NVARCHAR | VSTRING | 9 | 0 | 9 | TransTime | NULL | 3 | Да | |
GLHI004 | NVARCHAR | VSTRING | 10 | 0 | 10 | InventoryCod | NULL | 4 | Да | |
GLHI005 | NVARCHAR | VSTRING | 10 | 0 | 10 | TransCode | NULL | 5 | Да | |
GLHI006 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurrencyCod | NULL | 6 | Да | |
GLHI007 | NVARCHAR | VSTRING | 8 | 0 | 8 | UserId | NULL | 7 | Да | |
GLHI008 | NVARCHAR | VSTRING | 30 | 0 | 30 | DescrLine1 | NULL | |||
GLHI009 | NVARCHAR | VSTRING | 30 | 0 | 30 | DescrLine2 | NULL | |||
GLHI010 | NVARCHAR | VSTRING | 10 | 0 | 10 | InventGroup | NULL | |||
GLHI011 | NVARCHAR | VSTRING | 50 | 0 | 50 | AccString | NULL | |||
GLHI012 | NVARCHAR | VSTRING | 12 | 0 | 12 | Spare | NULL | |||
GLHI013 | NVARCHAR | VSTRING | 12 | 0 | 12 | Spare | NULL | |||
GLHI014 | NVARCHAR | VSTRING | 12 | 0 | 12 | Spare | NULL | |||
GLHI015 | NVARCHAR | VSTRING | 12 | 0 | 12 | Spare | NULL | |||
GLHI016 | NVARCHAR | VSTRING | 1 | 0 | 1 | RetrDeprec | NULL | |||
GLHI017 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | NULL | |||
GLHI018 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | NULL | |||
GLHI019 | NVARCHAR | VSTRING | 3 | 0 | 3 | NoteNo | NULL | |||
GLHI020 | NVARCHAR | VSTRING | 4 | 0 | 4 | CategoryA | NULL | |||
GLHI021 | NVARCHAR | VSTRING | 4 | 0 | 4 | CategoryB | NULL | |||
GLHI022 | NVARCHAR | VSTRING | 15 | 0 | 15 | Location | NULL | |||
GLHI023 | NVARCHAR | VSTRING | 10 | 0 | 10 | SuplCode | NULL | |||
GLHI024 | NVARCHAR | VSTRING | 32 | 0 | 32 | SupNameAddr1 | NULL | |||
GLHI025 | NVARCHAR | VSTRING | 32 | 0 | 32 | SupNameAddr2 | NULL | |||
GLHI026 | NVARCHAR | VSTRING | 32 | 0 | 32 | SupNameAddr3 | NULL | |||
GLHI027 | NVARCHAR | VSTRING | 32 | 0 | 32 | SupNameAddr4 | NULL | |||
GLHI028 | NVARCHAR | VSTRING | 25 | 0 | 25 | NameContact | NULL | |||
GLHI029 | NVARCHAR | VSTRING | 15 | 0 | 15 | Telephone | NULL | |||
GLHI030 | NVARCHAR | VSTRING | 15 | 0 | 15 | SupplInv | NULL | |||
GLHI031 | NVARCHAR | VSTRING | 6 | 0 | 6 | TransactNo | NULL | |||
GLHI032 | DATETIME | DATE | 0 | 0 | 8 | WarrExpDate | NULL | |||
GLHI033 | NVARCHAR | VSTRING | 25 | 0 | 25 | InsuranceComp | NULL | |||
GLHI034 | NVARCHAR | VSTRING | 20 | 0 | 20 | InsuranceNo | NULL | |||
GLHI035 | NUMERIC | MONEY | 28 | 8 | 20 | InsuredAm | NULL | |||
GLHI036 | NVARCHAR | VSTRING | 20 | 0 | 20 | PurchPrice | NULL | |||
GLHI037 | NVARCHAR | VSTRING | 20 | 0 | 20 | RePurchPr | NULL | |||
GLHI038 | NVARCHAR | VSTRING | 20 | 0 | 20 | AccRepairs | NULL | |||
GLHI039 | NVARCHAR | VSTRING | 20 | 0 | 20 | AccAddons | NULL | |||
GLHI040 | DATETIME | DATE | 0 | 0 | 8 | DatePurch | NULL | |||
GLHI041 | DATETIME | DATE | 0 | 0 | 8 | DateScrapped | NULL | |||
GLHI042 | NVARCHAR | VSTRING | 4 | 0 | 4 | ScrSoldCode | NULL | |||
GLHI043 | NVARCHAR | VSTRING | 6 | 0 | 6 | IndexValue | NULL | |||
GLHI044 | NCHAR | STRING | 4 | 0 | 4 | LUpdDepr | NULL | |||
GLHI045 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | NULL | |||
GLHI046 | NVARCHAR | VSTRING | 2 | 0 | 2 | Spare | NULL | |||
GLHI047 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | NULL | |||
GLHI048 | NUMERIC | MONEY | 28 | 8 | 20 | Spare | NULL | |||
GLHI049 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | NULL | |||
GLHI050 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | NULL | |||
GLHI051 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | NULL | |||
GLHI052 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | NULL | |||
GLHI053 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | NULL | |||
GLHI054 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | NULL | |||
GLHI055 | NVARCHAR | VSTRING | 2 | 0 | 2 | Spare | NULL | |||
GLHI056 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | NULL | |||
GLHI057 | NUMERIC | MONEY | 28 | 8 | 20 | Spare | NULL | |||
GLHI058 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | NULL | |||
GLHI059 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | NULL | |||
GLHI060 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | NULL | |||
GLHI061 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | NULL | |||
GLHI062 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | NULL | |||
GLHI063 | NVARCHAR | VSTRING | 2 | 0 | 2 | Spare | NULL | |||
GLHI064 | NVARCHAR | VSTRING | 2 | 0 | 2 | Spare | NULL | |||
GLHI065 | NVARCHAR | VSTRING | 2 | 0 | 2 | Spare | NULL | |||
GLHI066 | NVARCHAR | VSTRING | 30 | 0 | 30 | InternRem1 | NULL | |||
GLHI067 | NVARCHAR | VSTRING | 30 | 0 | 30 | InternRem2 | NULL | |||
GLHI068 | NVARCHAR | VSTRING | 5 | 0 | 5 | InsuranCode | NULL | |||
GLHI069 | NVARCHAR | VSTRING | 1 | 0 | 1 | DocFlag | NULL | |||
GLHI070 | NVARCHAR | VSTRING | 20 | 0 | 20 | ServContract | NULL | |||
GLHI071 | NVARCHAR | VSTRING | 1 | 0 | 1 | GenBudget | NULL | |||
GLHI072 | NVARCHAR | VSTRING | 1 | 0 | 1 | GenTrans | NULL | |||
GLHI073 | NVARCHAR | VSTRING | 15 | 0 | 15 | UserDefDat1 | NULL | |||
GLHI074 | NVARCHAR | VSTRING | 10 | 0 | 10 | UserDefDat2 | NULL | |||
GLHI075 | NVARCHAR | VSTRING | 10 | 0 | 10 | UserDefDat3 | NULL | |||
GLHI076 | NVARCHAR | VSTRING | 5 | 0 | 5 | UserDefDat4 | NULL | |||
GLHI077 | NVARCHAR | VSTRING | 1 | 0 | 1 | DeprMetC | NULL | |||
GLHI078 | NVARCHAR | VSTRING | 2 | 0 | 2 | DeprPerC | NULL | |||
GLHI079 | NVARCHAR | VSTRING | 6 | 0 | 6 | DeprCalc | NULL | |||
GLHI080 | NUMERIC | MONEY | 28 | 8 | 20 | DeprAmC | NULL | |||
GLHI081 | NVARCHAR | VSTRING | 20 | 0 | 20 | DeprBaseC | NULL | |||
GLHI082 | NVARCHAR | VSTRING | 20 | 0 | 20 | ScrapValC | NULL | |||
GLHI083 | NVARCHAR | VSTRING | 20 | 0 | 20 | AccDeprC | NULL | |||
GLHI084 | NVARCHAR | VSTRING | 20 | 0 | 20 | DeprecC | NULL | |||
GLHI085 | NVARCHAR | VSTRING | 20 | 0 | 20 | ExtraDeprC | NULL | |||
GLHI086 | NVARCHAR | VSTRING | 6 | 0 | 6 | IndexValueC | NULL | |||
GLHI087 | DATETIME | DATE | 0 | 0 | 8 | DeprStrtDate | NULL | |||
GLHI088 | NVARCHAR | VSTRING | 1 | 0 | 1 | NatSwitch1 | NULL | |||
GLHI089 | NVARCHAR | VSTRING | 1 | 0 | 1 | NatSwitch2 | NULL | |||
GLHI090 | NVARCHAR | VSTRING | 1 | 0 | 1 | NatSwitch3 | NULL | |||
GLHI091 | DATETIME | DATE | 0 | 0 | 8 | NationDate1 | NULL | |||
GLHI092 | DATETIME | DATE | 0 | 0 | 8 | NationDate2 | NULL | |||
GLHI093 | DATETIME | DATE | 0 | 0 | 8 | NationDate3 | NULL | |||
GLHI094 | NUMERIC | MONEY | 28 | 8 | 20 | NatAmount1 | NULL | |||
GLHI095 | NUMERIC | MONEY | 28 | 8 | 20 | NatAmount2 | NULL | |||
GLHI096 | NUMERIC | MONEY | 28 | 8 | 20 | NatAmount3 | NULL | |||
GLHI097 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | NULL | |||
GLHI098 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | NULL | |||
GLHI099 | NVARCHAR | VSTRING | 6 | 0 | 6 | Deprec2Calc | NULL | |||
GLHI100 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | NULL | |||
GLHI101 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | NULL | |||
GLHI102 | NVARCHAR | VSTRING | 1 | 0 | 1 | DeprSwCalc | NULL | |||
GLHI103 | NVARCHAR | VSTRING | 2 | 0 | 2 | DepMethodTax | NULL | |||
GLHI104 | NVARCHAR | VSTRING | 12 | 0 | 12 | NLBalAccTax | NULL | |||
GLHI105 | NVARCHAR | VSTRING | 12 | 0 | 12 | NLPLAccTax | NULL | |||
GLHI106 | NVARCHAR | VSTRING | 3 | 0 | 3 | DepPerYrTax | NULL | |||
GLHI107 | NVARCHAR | VSTRING | 6 | 0 | 6 | DeprTax | NULL | |||
GLHI108 | NUMERIC | MONEY | 28 | 8 | 20 | DeprAmTax | NULL | |||
GLHI109 | NVARCHAR | VSTRING | 20 | 0 | 20 | DeprBaseTax | NULL | |||
GLHI110 | NVARCHAR | VSTRING | 20 | 0 | 20 | ScrapValTax | NULL | |||
GLHI111 | NVARCHAR | VSTRING | 20 | 0 | 20 | AccDeprTax | NULL | |||
GLHI112 | NVARCHAR | VSTRING | 20 | 0 | 20 | DeprYearTax | NULL | |||
GLHI113 | NVARCHAR | VSTRING | 20 | 0 | 20 | ExtraDeprTax | NULL | |||
GLHI114 | NVARCHAR | VSTRING | 6 | 0 | 6 | Depr2Tax | NULL | |||
GLHI115 | NVARCHAR | VSTRING | 1 | 0 | 1 | DeprSwTax | NULL | |||
GLHI116 | NVARCHAR | VSTRING | 2 | 0 | 2 | DepMethodPln | NULL | |||
GLHI117 | NVARCHAR | VSTRING | 12 | 0 | 12 | NLBalAccPln | NULL | |||
GLHI118 | NVARCHAR | VSTRING | 12 | 0 | 12 | NLPLAccPln | NULL | |||
GLHI119 | NVARCHAR | VSTRING | 3 | 0 | 3 | DepPerYrPln | NULL | |||
GLHI120 | NVARCHAR | VSTRING | 6 | 0 | 6 | DeprPln | NULL | |||
GLHI121 | NUMERIC | MONEY | 28 | 8 | 20 | DeprAmPln | NULL | |||
GLHI122 | NVARCHAR | VSTRING | 20 | 0 | 20 | DeprBasePln | NULL | |||
GLHI123 | NVARCHAR | VSTRING | 20 | 0 | 20 | ScrapValPln | NULL | |||
GLHI124 | NVARCHAR | VSTRING | 20 | 0 | 20 | AccDeprPln | NULL | |||
GLHI125 | NVARCHAR | VSTRING | 20 | 0 | 20 | DeprYearPln | NULL | |||
GLHI126 | NVARCHAR | VSTRING | 20 | 0 | 20 | ExtraDeprPln | NULL | |||
GLHI127 | NVARCHAR | VSTRING | 2 | 0 | 2 | Per1WoDepr | NULL | |||
GLHI128 | NVARCHAR | VSTRING | 2 | 0 | 2 | Per2WoDepr | NULL | |||
GLHI129 | NVARCHAR | VSTRING | 2 | 0 | 2 | Per3WoDepr | NULL | |||
GLHI130 | NVARCHAR | VSTRING | 6 | 0 | 6 | Depr2Pln | NULL | |||
GLHI131 | NVARCHAR | VSTRING | 1 | 0 | 1 | DeprSwPln | NULL | |||
GLHI132 | NVARCHAR | VSTRING | 20 | 0 | 20 | PurchaseCost | NULL | |||
GLHI133 | NVARCHAR | VSTRING | 1 | 0 | 1 | DailyDeprPln | NULL | |||
GLHI134 | NVARCHAR | VSTRING | 1 | 0 | 1 | DailyDeprTax | NULL | |||
GLHI135 | NVARCHAR | VSTRING | 1 | 0 | 1 | Dummy | NULL | |||
GLHI136 | NCHAR | STRING | 1 | 0 | 1 | DepPerUnitTx | NULL | |||
GLHI137 | NCHAR | STRING | 1 | 0 | 1 | DepPerUnitPn | NULL | |||
GLHI138 | NUMERIC | MONEY | 28 | 8 | 20 | SalesRevenue | NULL | |||
GLHI139 | INT | INTEGER | 0 | 0 | 1 | YearReducDeprTax | NULL | |||
GLHI140 | DATETIME | DATE | 0 | 0 | 8 | DeprStartTax | NULL | |||
GLHI141 | INT | INTEGER | 0 | 0 | 1 | YearReducDeprPlan | NULL | |||
GLHI142 | DATETIME | DATE | 0 | 0 | 8 | DeprStartPlan | NULL | |||
GLHI143 | NVARCHAR | VSTRING | 1 | 0 | 1 | LockFlag | NULL | |||
GLHI144 | NVARCHAR | VSTRING | 1 | 0 | 1 | SummaryLevel | NULL | |||
GLHI145 | NVARCHAR | VSTRING | 12 | 0 | 12 | ReportingLevel1 | NULL | |||
GLHI146 | NVARCHAR | VSTRING | 12 | 0 | 12 | ReportingLevel2 | NULL | |||
GLHI147 | NVARCHAR | VSTRING | 12 | 0 | 12 | ReportingLevel3 | NULL | |||
GLHI148 | NVARCHAR | VSTRING | 12 | 0 | 12 | ReportingLevel4 | NULL | |||
GLHI149 | NVARCHAR | VSTRING | 12 | 0 | 12 | ReportingLevel5 | NULL | |||
GLHI150 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodePUR | NULL | |||
GLHI151 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeTAX | NULL | |||
GLHI152 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodePLA | NULL | |||
GLHI153 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeSAL | NULL | |||
GLHI154 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeSCR | NULL | |||
GLHI155 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeREV | NULL | |||
GLHI156 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeETX | NULL | |||
GLHI157 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeFUS | NULL | |||
GLHI158 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeICT | NULL | |||
GLHI159 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodePLP | NULL | |||
GLHI160 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeACT | NULL | |||
GLHI161 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE1 | NULL | |||
GLHI162 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE2 | NULL | |||
GLHI163 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE3 | NULL | |||
GLHI164 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE4 | NULL | |||
GLHI165 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE5 | NULL | |||
GLHI166 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE6 | NULL | |||
GLHI167 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE7 | NULL | |||
GLHI168 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE8 | NULL | |||
GLHI169 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE9 | NULL | |||
GLHI170 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE10 | NULL | |||
GLHI171 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE11 | NULL | |||
GLHI172 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE12 | NULL | |||
GLHI173 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE13 | NULL | |||
GLHI174 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE14 | NULL | |||
GLHI175 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE15 | NULL | |||
GLHI176 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE16 | NULL | |||
GLHI177 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE17 | NULL | |||
GLHI178 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE18 | NULL | |||
GLHI179 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE19 | NULL | |||
GLHI180 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCodeRE20 | NULL |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | General Ledger | FA Transaction History