пользователям программных продуктов Scala 5.0, Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0 (и так далее)

Таблица: PLHF - «Recharge Amounts». Маска имени таблицы: «PLHF0000»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PLHF001 NCHAR STRING 2 0 2 OrigCompCode Originating Company   1 Да
PLHF002 NCHAR STRING 10 0 10 Main Inv Suppl Code Main Invoice Supplier Code   2 Да
PLHF003 NCHAR STRING 15 0 15 Main Inv Number Main Invoice Number   3 Да
PLHF004 NCHAR STRING 10 0 10 Target Entity Target Entity Used for target company code 4 Да
PLHF005 NCHAR SWITCH 1 0 1 Updated Flag Is Updated      
PLHF006 NCHAR SWITCH 1 0 1 Created Flag Is Created      
PLHF007 NCHAR STRING 1 0 1 Multiple Entity Multiple Entity      
PLHF008 NCHAR STRING 2 0 2 Target Company Code Target Company Code      
PLHF009 NUMERIC MONEY 28 8 20 Fee OCU Service Fee (Original Currency)      
PLHF010 NUMERIC MONEY 28 8 20 Fee LCU-OC Service Fee (Local Currency, Original Company)      
PLHF011 NUMERIC MONEY 28 8 20 Fee LCU-TC Service Fee (Local Currency, Target Company)      
PLHF012 DATETIME DATE 0 0 8 Fee-Curr Date Service Fee Currency Date      
PLHF013 NVARCHAR VSTRING 15 0 15 Fee Exch Rate LC-OC Service Fee Exchange Rate (Local Currency, Original Company)      
PLHF014 NVARCHAR VSTRING 15 0 15 Fee Exch Rate LC-TC Service Fee Exchange Rate (Local Currency, Target Company)      
PLHF015 NUMERIC MONEY 28 8 20 Amt OCU Recharge Amount (Original Currency)      
PLHF016 NUMERIC MONEY 28 8 20 Amt LCU-OC Recharge Amount (Local Currency, Original Company)      
PLHF017 NUMERIC MONEY 28 8 20 Amt LCU-TC Recharge Amount (Local Currency, Target Company)      
PLHF018 DATETIME DATE 0 0 8 Amt - Curr Date Recharge Amount Currency Date      
PLHF019 NVARCHAR VSTRING 15 0 15 Amt-ExchRate LCU-OC Recharge Amount Exchange Rate (Local Currency, Original Company)      
PLHF020 NVARCHAR VSTRING 15 0 15 Amt ExchRate LCU-TC Recharge Amount Exchange Rate (Local Currency, Target Company)      
PLHF021 NUMERIC MONEY 28 8 20 Actual Expens LCU-OC Actual Expense (Local Currency, Original Company)      
PLHF022 INT INTEGER 0 0 2 CurrencyCode Fee OC Currency Code Service Fee (Original Company)      
PLHF023 INT INTEGER 0 0 2 CurrencyCode Amt OC Currency Code Recharge Amount (Original Company)      
PLHF024 INT INTEGER 0 0 2 CurrencyCode Fee TC Currency Code Service Fee (Target Company)      
PLHF025 INT INTEGER 0 0 2 CurrencyCode Amt TC Currency Code Recharge Amount (Target Company)      
PLHF026 INT INTEGER 0 0 2 TC Curr Code OC-LCU Target Company Currency Code (Original Company, Local Amounts)      
PLHF027 INT INTEGER 0 0 2 OC Curr Code TC-LCU Original Company Currency Code (Target Company, Local Amounts)      
PLHF028 NUMERIC MONEY 28 8 20 Fee Tax OCU Service Fee Tax (Original Currency)      
PLHF029 NUMERIC MONEY 28 8 20 Fee Tax LCU OC Service Fee Tax (Local Currency, Original Company)      
PLHF030 NUMERIC MONEY 28 8 20 Fee Tax LCU TC Service Fee Tax (Local Currency, Target Company)      
PLHF031 NUMERIC MONEY 28 8 20 Amt Total Tax OCU Recharge Total Tax (Original Currency)      
PLHF032 NUMERIC MONEY 28 8 20 Amt Total Tax LCU-OC Recharge Total Tax (Local Currency, Original Company)      
PLHF033 NUMERIC MONEY 28 8 20 Amt Total Tax LCU-TC Recharge Total Tax (Local Currency, Target Company)      
PLHF034 NUMERIC MONEY 28 8 20 Amt Line0 Tax OCU Recharge Tax Amount Line 0 (Original Currency)      
PLHF035 NUMERIC MONEY 28 8 20 Amt Line0 Tax LCU-OC Recharge Tax Amount Line 0 (Local Currency, Original Company)      
PLHF036 NUMERIC MONEY 28 8 20 Amt Line0 Tax LCU-TC Recharge Tax Amount Line 0 (Local Currency, Target Company)      
PLHF037 NUMERIC MONEY 28 8 20 Amt Line1 Tax OCU Recharge Tax Amount Line 1 (Original Currency)      
PLHF038 NUMERIC MONEY 28 8 20 Amt Line1 Tax LCU-OC Recharge Tax Amount Line 1 (Local Currency, Original Company)      
PLHF039 NUMERIC MONEY 28 8 20 Amt Line1 Tax LCU-TC Recharge Tax Amount Line 1 (Local Currency, Target Company)      
PLHF040 NUMERIC MONEY 28 8 20 Amt Line2 Tax OCU Recharge Tax Amount Line 2 (Original Currency)      
PLHF041 NUMERIC MONEY 28 8 20 Amt Line2 Tax LCU-OC Recharge Tax Amount Line 2 (Local Currency, Original Company)      
PLHF042 NUMERIC MONEY 28 8 20 Amt Line2 Tax LCU-TC Recharge Tax Amount Line 2 (Local Currency, Target Company)      
PLHF043 NUMERIC MONEY 28 8 20 Amt Line3 Tax OCU Recharge Tax Amount Line 3 (Original Currency)      
PLHF044 NUMERIC MONEY 28 8 20 Amt Line3 Tax LCU-OC Recharge Tax Amount Line 3 (Local Currency, Original Company)      
PLHF045 NUMERIC MONEY 28 8 20 Amt Line3 Tax LCU-TC Recharge Tax Amount Line 3 (Local Currency, Target Company)      
PLHF046 NUMERIC MONEY 28 8 20 Amt Line4 Tax OCU Recharge Tax Amount Line 4 (Original Currency)      
PLHF047 NUMERIC MONEY 28 8 20 Amt Line4 Tax LCU-OC Recharge Tax Amount Line 4 (Local Currency, Original Company)      
PLHF048 NUMERIC MONEY 28 8 20 Amt Line4 Tax LCU-TC Recharge Tax Amount Line 4 (Local Currency, Target Company)      
PLHF049 NUMERIC MONEY 28 8 20 Amt Line5 Tax OCU Recharge Tax Amount Line 5 (Original Currency)      
PLHF050 NUMERIC MONEY 28 8 20 Amt Line5 Tax LCU-OC Recharge Tax Amount Line 5 (Local Currency, Original Company)      
PLHF051 NUMERIC MONEY 28 8 20 Amt Line5 Tax LCU-TC Recharge Tax Amount Line 5 (Local Currency, Target Company)      
PLHF052 NUMERIC MONEY 28 8 20 Amt Line6 Tax OCU Recharge Tax Amount Line 6 (Original Currency)      
PLHF053 NUMERIC MONEY 28 8 20 Amt Line6 Tax LCU-OC Recharge Tax Amount Line 6 (Local Currency, Original Company)      
PLHF054 NUMERIC MONEY 28 8 20 Amt Line6 Tax LCU-TC Recharge Tax Amount Line 6 (Local Currency, Target Company)      
PLHF055 NUMERIC MONEY 28 8 20 Amt Line7 Tax OCU Recharge Tax Amount Line 7 (Original Currency)      
PLHF056 NUMERIC MONEY 28 8 20 Amt Line7 Tax LCU-OC Recharge Tax Amount Line 7 (Local Currency, Original Company)      
PLHF057 NUMERIC MONEY 28 8 20 Amt Line7 Tax LCU-TC Recharge Tax Amount Line 7 (Local Currency, Target Company)      
PLHF058 NUMERIC MONEY 28 8 20 Amt Line8 Tax OCU Recharge Tax Amount Line 8 (Original Currency)      
PLHF059 NUMERIC MONEY 28 8 20 Amt Line8 Tax LCU-OC Recharge Tax Amount Line 8 (Local Currency, Original Company)      
PLHF060 NUMERIC MONEY 28 8 20 Amt Line8 Tax LCU-TC Recharge Tax Amount Line 8 (Local Currency, Target Company)      
PLHF061 NUMERIC MONEY 28 8 20 Amt Line9 Tax OCU Recharge Tax Amount Line 9 (Original Currency)      
PLHF062 NUMERIC MONEY 28 8 20 Amt Line9 Tax LCU-OC Recharge Tax Amount Line 9 (Local Currency, Original Company)      
PLHF063 NUMERIC MONEY 28 8 20 Amt Line9 Tax LCU-TC Recharge Tax Amount Line 9 (Local Currency, Target Company)      
PLHF064 NUMERIC MONEY 28 8 20 Service Fee OCU-TC Service Fee (Original Currency, Target Company)      
PLHF065 NUMERIC MONEY 28 8 20 Recharge Amt OCU-TC Recharge Amount (Original Currency, Target Company)      
PLHF066 NUMERIC MONEY 28 8 20 Rech.IncSFee OCU-TC Recharge Amount Including Service Fee (Original Currency, Target Company)      
PLHF067 NUMERIC MONEY 28 8 20 Rech.IncSFee LCU-TC Recharge Amount Including Service Fee (Local Currency, Target Company)      
PLHF068 NUMERIC MONEY 28 8 20 Rech TotExpTax OCU Recharge Expense Total Tax (Original Currency)      
PLHF069 NUMERIC MONEY 28 8 20 Rech TotExpTax LCU-OC Recharge Expense Total Tax (Local Currency, Original Company)      
PLHF070 NUMERIC MONEY 28 8 20 Rech TotExpTax LCU-TC Recharge Expense Total Tax (Local Currency, Target Company)      
PLHF071 NUMERIC MONEY 28 8 20 Spare (obsolete)      
PLHF072 NUMERIC MONEY 28 8 20 Spare (obsolete)      
PLHF073 NUMERIC MONEY 28 8 20 Spare (obsolete)      
PLHF074 NUMERIC MONEY 28 8 20 Spare (obsolete)      
PLHF075 NUMERIC MONEY 28 8 20 Spare (obsolete)      
PLHF076 NCHAR STRING 2 0 2 Spare (obsolete)      
PLHF077 NCHAR STRING 2 0 2 Spare (obsolete)      
PLHF078 NCHAR STRING 2 0 2 Spare (obsolete)      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Purchase Ledger | Recharge Amounts

TopList

© Алексей Васильев. 2004-2019. При использовании материалов ссылка обязательна.