Таблица: AMH6 - «Spare». Маска имени таблицы: «AMH6%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
AMH6001 | NCHAR | STRING | 3 | 0 | 3 | Transaction Type | Transaction Type | 1 | Да | |
AMH6002 | DATETIME | DATE | 0 | 0 | 8 | Transaction Date | Transaction Date | 2 | Да | |
AMH6003 | NCHAR | STRING | 9 | 0 | 9 | Transaction Time | Transaction Time | 3 | Да | |
AMH6004 | NVARCHAR | VSTRING | 35 | 0 | 35 | Inventory Code | Asset Code | 4 | Да | |
AMH6005 | NCHAR | STRING | 10 | 0 | 10 | Transaction Code | Transaction Code | 5 | Да | |
AMH6006 | NCHAR | STRING | 8 | 0 | 8 | UserID | User ID | 6 | Да | |
AMH6007 | INT | INTEGER | 0 | 0 | 10 | Transaction Counter | Transaction Number | 7 | Да | |
AMH6008 | NCHAR | STRING | 2 | 0 | 2 | CurrCode | Currency Code Depreciation | 8 | Да | |
AMH6009 | NVARCHAR | VSTRING | 2 | 0 | 2 | DepMethodTax | [Tax] Depreciation Method | Depreciation methods:
0 - No depreciation. 1 - As percentage of the depreciation basis (Straight Line). 2 - As percentage of the balance (Reducing Balance) 3 - Fixed Amount per Financial Year. 4 - Sum for the Year (SOY. 5 - Proportional Depreciation 6 - The method is designed for Assets with the economic life more than a year. 7 - Double Declining 8 - As percentage of the depreciation basis (Straight Line). 9 - The assets are depreciated by 50% at acquisition and 50% when the Asset is no longer used. 10 - Percentage of the remaining amount. 11 - The depreciation amount is calculated as a product of the residual value of the Asset and the rate of depreciation determined for the given asset. |
||
AMH6010 | NVARCHAR | VSTRING | 12 | 0 | 12 | NLBalAccTax | [Tax] Balance Account Over/Under Depreciations | |||
AMH6011 | NVARCHAR | VSTRING | 12 | 0 | 12 | NLPLAccTax | [Tax] P&L Account Over/Under Depreciations | |||
AMH6012 | NVARCHAR | VSTRING | 3 | 0 | 3 | DepPerYrTax | [Tax] Depreciation Periods/Years | |||
AMH6013 | NVARCHAR | VSTRING | 6 | 0 | 6 | DeprTax | [Tax] Depreciation % | |||
AMH6014 | NUMERIC | MONEY | 28 | 8 | 20 | DeprAmTax | [Tax] Depreciation Amount | |||
AMH6015 | NUMERIC | MONEY | 28 | 8 | 20 | DeprBaseTax | [Tax] Depreciation Base | |||
AMH6016 | NVARCHAR | VSTRING | 20 | 0 | 20 | Residual Value TAX | [Tax] Residual Value | |||
AMH6017 | NVARCHAR | VSTRING | 20 | 0 | 20 | AccDeprTax | [Tax] Accumulated Depreciations | |||
AMH6018 | NVARCHAR | VSTRING | 20 | 0 | 20 | DeprYearTax | [Tax] Depreciations Current Year | |||
AMH6019 | NVARCHAR | VSTRING | 20 | 0 | 20 | ExtraDeprTax | [Tax] Extra Depreciations | |||
AMH6020 | NVARCHAR | VSTRING | 6 | 0 | 6 | Depr2Tax | [Tax] Depreciation % 2 | |||
AMH6021 | NVARCHAR | VSTRING | 1 | 0 | 1 | DeprSwTax | [Tax] Depreciation Switch | |||
AMH6022 | NVARCHAR | VSTRING | 2 | 0 | 2 | DepMethodPln | [Plan] Depreciation Method | |||
AMH6023 | NVARCHAR | VSTRING | 12 | 0 | 12 | NLBalAccPln | [Plan] Balance Account Depreciations | |||
AMH6024 | NVARCHAR | VSTRING | 12 | 0 | 12 | NLPLAccPln | [Plan] P&L Account Depreciations | |||
AMH6025 | NVARCHAR | VSTRING | 3 | 0 | 3 | DepPerYrPln | [Plan] Depreciation Periods/Years | |||
AMH6026 | NVARCHAR | VSTRING | 6 | 0 | 6 | DeprPln | [Plan] Depreciation % | |||
AMH6027 | NUMERIC | MONEY | 28 | 8 | 20 | DeprAmPln | [Plan] Depreciation Amount | |||
AMH6028 | NUMERIC | MONEY | 28 | 8 | 20 | DeprBasePln | [Plan] Depreciation Base | |||
AMH6029 | NVARCHAR | VSTRING | 20 | 0 | 20 | Residual Value PLAN | [Plan] Residual Value | |||
AMH6030 | NVARCHAR | VSTRING | 20 | 0 | 20 | AccDeprPln | [Plan] Accumulated Depreciations | |||
AMH6031 | NVARCHAR | VSTRING | 20 | 0 | 20 | DeprYearPln | [Plan] Depreciations this year | |||
AMH6032 | NVARCHAR | VSTRING | 20 | 0 | 20 | ExtraDeprPln | [Plan] Extra Depreciations | |||
AMH6033 | NVARCHAR | VSTRING | 2 | 0 | 2 | Per1WoDepr | [Plan] Period Without Depreciations 1 | |||
AMH6034 | NVARCHAR | VSTRING | 2 | 0 | 2 | Per2WoDepr | [Plan] Period Without Depreciations 2 | |||
AMH6035 | NVARCHAR | VSTRING | 2 | 0 | 2 | Per3WoDepr | [Plan] Period Without Depreciations 3 | |||
AMH6036 | NVARCHAR | VSTRING | 6 | 0 | 6 | Depr2Pln | [Plan] Depreciation % 2 | |||
AMH6037 | NVARCHAR | VSTRING | 1 | 0 | 1 | DeprSwPln | [Plan] Depreciation Switch | |||
AMH6038 | NUMERIC | MONEY | 28 | 8 | 20 | PurchaseCost | Purchase Cost | |||
AMH6039 | NVARCHAR | VSTRING | 1 | 0 | 1 | DailyDeprPln | [Plan] Depreciate on Daily Basis | |||
AMH6040 | NVARCHAR | VSTRING | 1 | 0 | 1 | DailyDeprTax | [Tax] Depreciate on Daily Basis | |||
AMH6041 | NVARCHAR | VSTRING | 1 | 0 | 1 | Dummy | (obsolete) | |||
AMH6042 | NCHAR | STRING | 1 | 0 | 1 | DepPerUnitTx | [Tax] Depreciation Period Unit | |||
AMH6043 | NCHAR | STRING | 1 | 0 | 1 | DepPerUnitPn | [Plan] Depreciation Period Unit | |||
AMH6044 | NUMERIC | MONEY | 28 | 8 | 20 | SalesRevenue | Sales Revenue | |||
AMH6045 | INT | INTEGER | 0 | 0 | 1 | YearReducDeprTax | [Tax] Yearly Reducing Depreciation | |||
AMH6046 | DATETIME | DATE | 0 | 0 | 8 | DeprStartTax | [Tax] Depreciation Start Date | |||
AMH6047 | INT | INTEGER | 0 | 0 | 1 | YearReducDeprPlan | [Plan] Yearly Reducing Depreciation | |||
AMH6048 | DATETIME | DATE | 0 | 0 | 8 | DeprStartPlan | [Plan] Depreciation Start Date | |||
AMH6049 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
AMH6050 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
AMH6051 | NVARCHAR | VSTRING | 35 | 0 | 35 | Spare | (obsolete) | |||
AMH6052 | NVARCHAR | VSTRING | 35 | 0 | 35 | Spare | (obsolete) | |||
AMH6053 | NVARCHAR | VSTRING | 35 | 0 | 35 | Spare | (obsolete) | |||
AMH6054 | NVARCHAR | VSTRING | 35 | 0 | 35 | Spare | (obsolete) | |||
AMH6055 | NVARCHAR | VSTRING | 35 | 0 | 35 | Spare | (obsolete) | |||
AMH6056 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code PUR | [PUR] Accounting Code Purchase Transactions | |||
AMH6057 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code TAX | [TAX] Accounting Code Tax Depreciation Transactions | |||
AMH6058 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code PLA | [PLA] Accounting Code Plan Depreciation Transactions | |||
AMH6059 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code SAL | [SAL] Accounting Code Sales Transactions | |||
AMH6060 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code SCR | [SCR] Accounting Code Scrap Transactions | |||
AMH6061 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code REV | [REV] Accounting Code Revaluation Transactions | |||
AMH6062 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code ETX | [ETX] Accounting Code Extra Tax Transactions | |||
AMH6063 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code FUS | [FUS] Accounting Code Fusion Transactions | |||
AMH6064 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code ICT | [ICT] Accounting Code IC Transfer Transactions | |||
AMH6065 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code PLP | [PLP] Accounting Code Purchasing from PL | |||
AMH6066 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code ACT | [ACT] Accounting Code Activation from SM | |||
AMH6067 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code OLD | [OLD] Accounting Code Take Over from Old System | |||
AMH6068 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code TRA | [TRA] Accounting Code Transfer | |||
AMH6069 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES3 | [RES] Accounting Code spare 3 | |||
AMH6070 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES4 | [RES] Accounting Code spare 4 | |||
AMH6071 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES5 | [RES] Accounting Code spare 5 | |||
AMH6072 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES6 | [RES] Accounting Code spare 6 | |||
AMH6073 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES7 | [RES] Accounting Code spare 7 | |||
AMH6074 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code SFA | [SFA] Accounting Code Transfer from Stock | |||
AMH6075 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code STO | [STO] Accounting Code Return to Stock | |||
AMH6076 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code REA | [REA] Accounting Code Automatic Revaluation | |||
AMH6077 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES11 | [RES] Accounting Code spare 11 | |||
AMH6078 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES12 | [RES] Accounting Code spare 12 | |||
AMH6079 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES13 | [RES] Accounting Code spare 13 | |||
AMH6080 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES14 | [RES] Accounting Code spare 14 | |||
AMH6081 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES15 | [RES] Accounting Code spare 15 | |||
AMH6082 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES16 | [RES] Accounting Code spare 16 | |||
AMH6083 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES17 | [RES] Accounting Code spare 17 | |||
AMH6084 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES18 | [RES] Accounting Code spare 18 | |||
AMH6085 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES19 | [RES] Accounting Code spare 19 | |||
AMH6086 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES20 | [RES] Accounting Code spare 20 | |||
AMH6087 | NUMERIC | MONEY | 28 | 8 | 20 | Scrap Value Booked | Scrap Value Booked | |||
AMH6088 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Accel Factor Plan | Acceleration Factor (Plan) | |||
AMH6089 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Accel Factor Tax | Acceleration Factor (Tax) |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Asset Management | Depreciation per Currency History