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