Название Таблицы / Table Name | Описание Таблицы / Table Description | Поле / Field | Расширенный комментарий / Extended Comment | Тип данных / Data Type | Длина поля iScala 3.5/ iScala 3.5 Length | Точность iScala 3.5/ iScala 3.5 Precision | Длина поля iScala 2.2/ iScala 2.2 Length | Точность iScala 2.2/ iScala 2.2 Precision | Новое поле? / is a New Field? |
PR01 | Main Project File | PR01015 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PR01 | Main Project File | PR01106 | Customer Purchase Order Number | NVARCHAR | 30 | 20 | — | ||
PR01 | Main Project File | PR01127 | Invoice Issuer Code | NCHAR | 6 | 4 | — | ||
PR01 | Main Project File | PR01131 | Operation Type (Project level) | NVARCHAR | 10 | — | — | + | |
PR01 | Main Project File | PR01132 | Financial Operation Code (Project level) | NVARCHAR | 10 | — | — | + | |
PR01 | Main Project File | PR01133 | Operation Type (Time activities level default) | NVARCHAR | 10 | — | — | + | |
PR01 | Main Project File | PR01134 | Financial Operation Code (Time activities level default) | NVARCHAR | 10 | — | — | + | |
PR01 | Main Project File | PR01135 | Operation Type (Cost activities level default) | NVARCHAR | 10 | — | — | + | |
PR01 | Main Project File | PR01136 | Financial Operation Code (Cost activities level default) | NVARCHAR | 10 | — | — | + | |
PR01 | Main Project File | PR01137 | Operation Type (Material activities level default) | NVARCHAR | 10 | — | — | + | |
PR01 | Main Project File | PR01138 | Financial Operation Code (Material activities level default) | NVARCHAR | 10 | — | — | + | |
PR01 | Main Project File | PR01139 | Instalment | NCHAR | 1 | — | — | + | |
PR01 | Main Project File | PR01140 | Interest% | NVARCHAR | 6 | — | — | + | |
PR01 | Main Project File | PR01141 | New Interest% | NVARCHAR | 6 | — | — | + | |
PR01 | Main Project File | PR01142 | Activate New Interest Date | DATETIME | 8 | — | — | + | |
PR01 | Main Project File | PR01143 | Financial Chage | NUMERIC | 20 | 8 | — | — | + |
PR01 | Main Project File | PR01144 | Interest Tax Code | NCHAR | 6 | — | — | + | |
PR01 | Main Project File | PR01145 | Financial Tax Code | NCHAR | 6 | — | — | + | |
PR01 | Main Project File | PR01146 | District | NCHAR | 2 | — | — | + | |
PR01 | Main Project File | PR01147 | Advertising Code | NCHAR | 2 | — | — | + | |
PR01 | Main Project File | PR01148 | City Code | NCHAR | 4 | — | — | + | |
PR01 | Main Project File | PR01149 | SNI Code | NCHAR | 5 | — | — | + | |
PR01 | Main Project File | PR01150 | Commission Distribution Method | NCHAR | 1 | — | — | + | |
PR01 | Main Project File | PR01151 | Bank Code | NVARCHAR | 10 | — | — | + | |
PR01 | Main Project File | PR01152 | Payment Address Code | NVARCHAR | 2 | — | — | + | |
PR01 | Main Project File | PR01153 | Extended Commission Code | NCHAR | 2 | — | — | + | |
PR01 | Main Project File | PR01154 | External Commission Code | NVARCHAR | 10 | — | — | + | |
PR01 | Main Project File | PR01155 | External Comission Amount | NUMERIC | 20 | 8 | — | — | + |
PR01 | Main Project File | PR01156 | Flag Electonic Project | INT | 1 | — | — | + | |
PR01 | Main Project File | PR01157 | Flag Doc XML Invoice | INT | 1 | — | — | + | |
PR01 | Main Project File | PR01158 | E-Mail Address | NVARCHAR | 200 | — | — | + | |
PR01 | Main Project File | PR01159 | Last Invoice Time | DATETIME | 17 | — | — | + | |
PR01 | Main Project File | PR01160 | Master Project | NVARCHAR | 12 | — | — | + | |
PR01 | Main Project File | PR01161 | Recognition Model | NCHAR | 3 | — | — | + | |
PR01 | Main Project File | PR01162 | Rec model from master project | NCHAR | 1 | — | — | + | |
PR01 | Main Project File | PR01163 | Cost Reallocation | NCHAR | 1 | — | — | + | |
PR01 | Main Project File | PR01164 | Closing rule | NCHAR | 1 | — | — | + | |
PR01 | Main Project File | PR01165 | Warranty SubProject | NVARCHAR | 6 | — | — | + | |
PR01 | Main Project File | PR01166 | Warranty Activity Line | NVARCHAR | 6 | — | — | + | |
PR01 | Main Project File | PR01167 | Project Revenue PCU | NUMERIC | 20 | 8 | — | — | + |
PR01 | Main Project File | PR01168 | Credit Check Passed | NCHAR | 1 | — | — | + | |
PR01 | Main Project File | PR01169 | Spesometro Forms | NVARCHAR | 12 | — | — | + | |
PR01 | Main Project File | PR01170 | Public Procurement Code 1 | NVARCHAR | 20 | — | — | + | |
PR01 | Main Project File | PR01171 | Public Procurement Code 2 | NVARCHAR | 20 | — | — | + | |
PR01 | Main Project File | PR01172 | Operation Type (Linked activities level default) | NVARCHAR | 10 | — | — | + | |
PR01 | Main Project File | PR01173 | Financial Operation Code (Linked activities level default) | NVARCHAR | 10 | — | — | + | |
PR01 | Main Project File | PR01174 | Tax Registration Country | NCHAR | 3 | — | — | + | |
PR02 | Project Activities | PR02013 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PR02 | Project Activities | PR02066 | External ID | NVARCHAR | 36 | — | — | + | |
PR02 | Project Activities | PR02067 | Fixed Revenue | NCHAR | 1 | — | — | + | |
PR02 | Project Activities | PR02068 | Included into Revenue Recognition | NCHAR | 1 | — | — | + | |
PR02 | Project Activities | PR02069 | Activity Revenue PCU | NUMERIC | 20 | 8 | — | — | + |
PR02 | Project Activities | PR02070 | Approved Credit Limit | NCHAR | 1 | — | — | + | |
PR02 | Project Activities | PR02071 | Operation Type | NVARCHAR | 10 | — | — | + | |
PR02 | Project Activities | PR02072 | Financial Operation Code | NVARCHAR | 10 | — | — | + | |
PR02 | Project Activities | PR02073 | NCM Code | NVARCHAR | 25 | — | — | + | |
PR02 | Project Activities | PR02074 | Product Tax Type | NVARCHAR | 10 | — | — | + | |
PR02 | Project Activities | PR02075 | Taxation Reason Code | NCHAR | 3 | — | — | + | |
PR03 | Project Activity Transactions | PR03007 | Transaction Line Number | NVARCHAR | 6 | 3 | — | ||
PR03 | Project Activity Transactions | PR03020 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PR03 | Project Activity Transactions | PR03031 | General Ledger Transaction Number | NVARCHAR | 9 | 6 | — | ||
PR03 | Project Activity Transactions | PR03037 | WIP Transaction Number | NVARCHAR | 9 | 6 | — | ||
PR03 | Project Activity Transactions | PR03043 | WIP Return Transaction Number | NCHAR | 9 | 6 | — | ||
PR03 | Project Activity Transactions | PR03048 | General Ledger Transaction Line Reference | NCHAR | 9 | 8 | — | ||
PR03 | Project Activity Transactions | PR03050 | Included into Revenue Recognition | NCHAR | 1 | — | — | + | |
PR03 | Project Activity Transactions | PR03051 | Close Date | DATETIME | 8 | — | — | + | |
PR03 | Project Activity Transactions | PR03052 | Operation Type | NVARCHAR | 10 | — | — | + | |
PR03 | Project Activity Transactions | PR03053 | Financial Operation Code | NVARCHAR | 10 | — | — | + | |
PR03 | Project Activity Transactions | PR03054 | NCM Code | NVARCHAR | 25 | — | — | + | |
PR03 | Project Activity Transactions | PR03055 | Product Tax Type | NVARCHAR | 10 | — | — | + | |
PR03 | Project Activity Transactions | PR03056 | Taxation Reason Code | NCHAR | 3 | — | — | + | |
PR10 | Project Activity File | PR10027 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PR10 | Project Activity File | PR10040 | Operation Type | NVARCHAR | 10 | — | — | + | |
PR10 | Project Activity File | PR10041 | Financial Operation Code | NVARCHAR | 10 | — | — | + | |
PR10 | Project Activity File | PR10042 | Extended Commission Code | NCHAR | 2 | — | — | + | |
PR10 | Project Activity File | PR10043 | Fixed Revenue | NCHAR | 1 | — | — | + | |
PR10 | Project Activity File | PR10044 | Included into Revenue Recognition | NCHAR | 1 | — | — | + | |
PR10 | Project Activity File | PR10045 | Operation Type (Default Value) | NVARCHAR | 10 | — | — | + | |
PR10 | Project Activity File | PR10046 | Financial Operation Code (Default Value) | NVARCHAR | 10 | — | — | + | |
PR10 | Project Activity File | PR10047 | NCM Code (Default Value) | NVARCHAR | 25 | — | — | + | |
PR10 | Project Activity File | PR10048 | Product Tax Type (Default Value) | NVARCHAR | 10 | — | — | + | |
PR10 | Project Activity File | PR10049 | Taxation Reason Code | NCHAR | 3 | — | — | + | |
PR13 | Project Module Parameters | PR13172 | Resource Planning Level | NCHAR | 1 | — | — | + | |
PR13 | Project Module Parameters | PR13173 | Credit Check Line | NCHAR | 1 | — | — | + | |
PR13 | Project Module Parameters | PR13174 | Credit Check Skip Additional | NCHAR | 1 | — | — | + | |
PR13 | Project Module Parameters | PR13175 | Credit Check Exit | NCHAR | 1 | — | — | + | |
PR13 | Project Module Parameters | PR13176 | Credit Limit Block Quotation | NCHAR | 1 | — | — | + | |
PR13 | Project Module Parameters | PR13177 | Credit Limit Block Entry | NCHAR | 1 | — | — | + | |
PR13 | Project Module Parameters | PR13178 | Credit Limit Block Transaction | NCHAR | 1 | — | — | + | |
PR13 | Project Module Parameters | PR13179 | Credit Limit Block Linked Object | NCHAR | 1 | — | — | + | |
PR15 | Project Delivery Addresses | PR15012 | City Code | NVARCHAR | 10 | — | — | + | |
PR15 | Project Delivery Addresses | PR15013 | Country code | NVARCHAR | 3 | — | — | + | |
PR15 | Project Delivery Addresses | PR15014 | E-Mail Address | NVARCHAR | 200 | — | — | + | |
PR15 | Project Delivery Addresses | PR15015 | Address Line 5 | NVARCHAR | 35 | — | — | + | |
PR15 | Project Delivery Addresses | PR15016 | Address Line 6 | NVARCHAR | 35 | — | — | + | |
PR15 | Project Delivery Addresses | PR15017 | Address Line 7 | NVARCHAR | 35 | — | — | + | |
PR15 | Project Delivery Addresses | PR15018 | Region Code | NVARCHAR | 10 | — | — | + | |
PR15 | Project Delivery Addresses | PR15019 | State/Province | NVARCHAR | 10 | — | — | + | |
PR15 | Project Delivery Addresses | PR15020 | County Code | NVARCHAR | 10 | — | — | + | |
PR17 | Project Text Lines | PR17007 | Transaction Line Number | NVARCHAR | 6 | 3 | — | ||
PR17 | Project Text Lines | PR17009 | Text Line Number | NVARCHAR | 3 | 2 | — | ||
PR17 | Project Text Lines | PR17011 | Serial Number flag | NCHAR | 1 | — | — | + | |
PR27 | Project Invoice Proposal Transaction File | PR27004 | Invoice Sort Key | NVARCHAR | 46 | 43 | — | ||
PR27 | Project Invoice Proposal Transaction File | PR27011 | Transact Line Number | NVARCHAR | 6 | 3 | — | ||
PR27 | Project Invoice Proposal Transaction File | PR27022 | Invoice Number to be Credited | NCHAR | 15 | 10 | — | ||
PR28 | Project Invoice Proposal Total File | PR28026 | Invoice Number to be Credited | NCHAR | 15 | 10 | — | ||
PR28 | Project Invoice Proposal Total File | PR28029 | Invoice Copy Number | INT | 4 | — | — | + | |
PR28 | Project Invoice Proposal Total File | PR28030 | Language Code | NCHAR | 3 | — | — | + | |
PR28 | Project Invoice Proposal Total File | PR28031 | Document Code | NCHAR | 1 | — | — | + | |
PR28 | Project Invoice Proposal Total File | PR28032 | Invoice Prefix | NCHAR | 4 | — | — | + | |
PR28 | Project Invoice Proposal Total File | PR28033 | Invoice Issuer Code | NVARCHAR | 6 | — | — | + | |
PR28 | Project Invoice Proposal Total File | PR28034 | Invoice Category | NCHAR | 1 | — | — | + | |
PR28 | Project Invoice Proposal Total File | PR28035 | OCU Exchange Rate 1 | NUMERIC | 10 | 8 | — | — | + |
PR28 | Project Invoice Proposal Total File | PR28036 | OCU Exchange Rate 2 | NUMERIC | 10 | 8 | — | — | + |
PR28 | Project Invoice Proposal Total File | PR28037 | OCU Exchange Algorithm | NCHAR | 3 | — | — | + | |
PR28 | Project Invoice Proposal Total File | PR28038 | ICU Exchange Rate 1 | NUMERIC | 10 | 8 | — | — | + |
PR28 | Project Invoice Proposal Total File | PR28039 | ICU Exchange Rate 2 | NUMERIC | 10 | 8 | — | — | + |
PR28 | Project Invoice Proposal Total File | PR28040 | ICU Exchange Algorithm | NCHAR | 3 | — | — | + | |
PR29 | Project Invoice History File | PR29041 | Payment Term | NCHAR | 2 | — | — | + | |
PR29 | Project Invoice History File | PR29042 | Invoice Due Date | DATETIME | 8 | — | — | + | |
PR29 | Project Invoice History File | PR29043 | Invoice Copy Number | INT | 4 | — | — | + | |
PR29 | Project Invoice History File | PR29044 | Flag Doc XML Invoice | INT | 1 | — | — | + | |
PR29 | Project Invoice History File | PR29045 | Invoice Time | DATETIME | 17 | — | — | + | |
PR29 | Project Invoice History File | PR29046 | Language Code | NCHAR | 3 | — | — | + | |
PR29 | Project Invoice History File | PR29047 | Document Code | NCHAR | 1 | — | — | + | |
PR29 | Project Invoice History File | PR29048 | Revenue Is Booked As Billing | NCHAR | 1 | — | — | + | |
PR29 | Project Invoice History File | PR29049 | Tax Point | NCHAR | 1 | — | — | + | |
PR29 | Project Invoice History File | PR29050 | Invoice Issuer Code | NVARCHAR | 6 | — | — | + | |
PR29 | Project Invoice History File | PR29051 | Invoice Category | NCHAR | 1 | — | — | + | |
PR29 | Project Invoice History File | PR29052 | Tax Amount included into selling price | NUMERIC | 20 | 8 | — | — | + |
PR29 | Project Invoice History File | PR29053 | Taxation Reason Code | NCHAR | 3 | — | — | + | |
PR29 | Project Invoice History File | PR29054 | ICU Exchange Rate 1 | NUMERIC | 10 | 8 | — | — | + |
PR29 | Project Invoice History File | PR29055 | ICU Exchange Rate 2 | NUMERIC | 10 | 8 | — | — | + |
PR29 | Project Invoice History File | PR29056 | ICU Exchange Algorithm | NCHAR | 3 | — | — | + | |
PR31 | Project Invoice Plan File | PR31037 | Payment Term | NCHAR | 2 | — | — | + | |
PR31 | Project Invoice Plan File | PR31038 | Tax Code | NVARCHAR | 6 | — | — | + | |
PR31 | Project Invoice Plan File | PR31039 | Deducted Amount PCU | NUMERIC | 20 | 8 | — | — | + |
PR31 | Project Invoice Plan File | PR31040 | Taxation Reason Code Material | NCHAR | 3 | — | — | + | |
PR31 | Project Invoice Plan File | PR31041 | Taxation Reason Code Cost | NCHAR | 3 | — | — | + | |
PR31 | Project Invoice Plan File | PR31042 | Taxation Reason Code Time | NCHAR | 3 | — | — | + | |
PR31 | Project Invoice Plan File | PR31043 | Taxation Reason Code | NCHAR | 3 | — | — | + | |
PR32 | Project/GL Transaction File | PR32001 | Record Counter | NUMERIC | 9 | 8 | — | ||
PR32 | Project/GL Transaction File | PR32002 | Transaction Number | NCHAR | 9 | 6 | — | ||
PR32 | Project/GL Transaction File | PR32003 | Line Number | NCHAR | 7 | 5 | — | ||
PR32 | Project/GL Transaction File | PR32006 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PR32 | Project/GL Transaction File | PR32009 | Accounting String Line Currency | NVARCHAR | 120 | 50 | — | ||
PR32 | Project/GL Transaction File | PR32011 | Transaction Line Text | NVARCHAR | 100 | 25 | — | ||
PR32 | Project/GL Transaction File | PR32013 | Project Number | NVARCHAR | 25 | 23 | — | ||
PR32 | Project/GL Transaction File | PR32024 | Link Code | NCHAR | 8 | 5 | — | ||
PR32 | Project/GL Transaction File | PR32026 | Unit Code | INT | 4 | 2 | — | ||
PR32 | Project/GL Transaction File | PR32030 | PL Reference | NCHAR | 9 | 6 | — | ||
PR32 | Project/GL Transaction File | PR32037 | Transaction Text Line Currency | NVARCHAR | 100 | 25 | — | ||
PR32 | Project/GL Transaction File | PR32038 | SourceCompany | NCHAR | 2 | — | — | + | |
PR32 | Project/GL Transaction File | PR32039 | Printed By | NCHAR | 8 | — | — | + | |
PR32 | Project/GL Transaction File | PR32040 | Date Printed | DATETIME | 8 | — | — | + | |
PR32 | Project/GL Transaction File | PR32041 | Printed Status | NCHAR | 1 | — | — | + | |
PR32 | Project/GL Transaction File | PR32042 | AAS code | NVARCHAR | 25 | — | — | + | |
PR34 | Project Budget/Forecast File | PR34114 | Reason Code of Estimate Locking | NCHAR | 3 | — | — | + | |
PR35 | Project Sub-projects File | PR35009 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PR35 | Project Sub-projects File | PR35043 | Accounting String (Internal Customer) | NVARCHAR | 120 | 50 | — | ||
PR35 | Project Sub-projects File | PR35044 | InvoiceIssuer | NVARCHAR | 6 | 4 | — | ||
PR35 | Project Sub-projects File | PR35048 | Operation Type (Sub-Project level) | NVARCHAR | 10 | — | — | + | |
PR35 | Project Sub-projects File | PR35049 | Financial Operation Code (Sub-Project level) | NVARCHAR | 10 | — | — | + | |
PR35 | Project Sub-projects File | PR35050 | Operation Type (Time activities level) | NVARCHAR | 10 | — | — | + | |
PR35 | Project Sub-projects File | PR35051 | Financial Operation Code (Time activities level) | NVARCHAR | 10 | — | — | + | |
PR35 | Project Sub-projects File | PR35052 | Operation Type (Cost activities level) | NVARCHAR | 10 | — | — | + | |
PR35 | Project Sub-projects File | PR35053 | Financial Operation Code (Cost activities level) | NVARCHAR | 10 | — | — | + | |
PR35 | Project Sub-projects File | PR35054 | Operation Type (Material activities level) | NVARCHAR | 10 | — | — | + | |
PR35 | Project Sub-projects File | PR35055 | Financial Operation Code (Material activities level) | NVARCHAR | 10 | — | — | + | |
PR35 | Project Sub-projects File | PR35056 | External ID | NVARCHAR | 36 | — | — | + | |
PR35 | Project Sub-projects File | PR35057 | Book-Entry Date | DATETIME | 8 | — | — | + | |
PR35 | Project Sub-projects File | PR35058 | Flag Doc XML Invoice | INT | 1 | — | — | + | |
PR35 | Project Sub-projects File | PR35059 | Invoice Time | DATETIME | 17 | — | — | + | |
PR35 | Project Sub-projects File | PR35060 | Operation Type (Linked activities level) | NVARCHAR | 10 | — | — | + | |
PR35 | Project Sub-projects File | PR35061 | Financial Operation Code (Linked activities level) | NVARCHAR | 10 | — | — | + | |
PR35 | Project Sub-projects File | PR35062 | Latest Invoice Date | DATETIME | 8 | — | — | + | |
PR37 | Project Templates | PR37054 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PR37 | Project Templates | PR37062 | Invoice Issuer Code | NCHAR | 6 | 4 | — | ||
PR37 | Project Templates | PR37065 | Operation Type (Time activities level default) | NVARCHAR | 10 | — | — | + | |
PR37 | Project Templates | PR37066 | Financial Operation Code (Time activities level default) | NVARCHAR | 10 | — | — | + | |
PR37 | Project Templates | PR37067 | Operation Type (Cost activities level default) | NVARCHAR | 10 | — | — | + | |
PR37 | Project Templates | PR37068 | Financial Operation Code (Cost activities level default) | NVARCHAR | 10 | — | — | + | |
PR37 | Project Templates | PR37069 | Operation Type (Material activities level default) | NVARCHAR | 10 | — | — | + | |
PR37 | Project Templates | PR37070 | Financial Operation Code (Material activities level default) | NVARCHAR | 10 | — | — | + | |
PR37 | Project Templates | PR37071 | Recognition model | NCHAR | 3 | — | — | + | |
PR37 | Project Templates | PR37072 | Cost Reallocation | NCHAR | 1 | — | — | + | |
PR37 | Project Templates | PR37073 | Closing Rule | NCHAR | 1 | — | — | + | |
PR37 | Project Templates | PR37074 | Warranty SubProject | NVARCHAR | 6 | — | — | + | |
PR37 | Project Templates | PR37075 | Warranty Activity Line | NVARCHAR | 6 | — | — | + | |
PR37 | Project Templates | PR37076 | Operation Type (Linked activities level default) | NVARCHAR | 10 | — | — | + | |
PR37 | Project Templates | PR37077 | Financial Operation Code (Linked activities level default) | NVARCHAR | 10 | — | — | + | |
PR38 | Project Invoice History Details File | PR38006 | Invoice Sort Key | NVARCHAR | 46 | 43 | — | ||
PR38 | Project Invoice History Details File | PR38013 | Transaction Line Number | NVARCHAR | 6 | 3 | — | ||
PR38 | Project Invoice History Details File | PR38024 | Invoice Number to be Credited | NCHAR | 15 | 10 | — | ||
PR38 | Project Invoice History Details File | PR38030 | Operation Type | NVARCHAR | 10 | — | — | + | |
PR38 | Project Invoice History Details File | PR38031 | Financial Operation Code | NVARCHAR | 10 | — | — | + | |
PR38 | Project Invoice History Details File | PR38032 | Taxation Reason Code | NCHAR | 3 | — | — | + | |
PR39 | Project Management Automatic Accounting Coding Schedule | PR39001 | Customer Accounting Code | NCHAR | 2 | — | — | + | |
PR39 | Project Management Automatic Accounting Coding Schedule | PR39002 | Project Accounting Code | NCHAR | 2 | — | — | + | |
PR39 | Project Management Automatic Accounting Coding Schedule | PR39003 | Activity Accounting Code | NCHAR | 2 | — | — | + | |
PR39 | Project Management Automatic Accounting Coding Schedule | PR39004 | Activity Type | NCHAR | 1 | — | — | + | |
PR39 | Project Management Automatic Accounting Coding Schedule | PR39005 | Resource Type | NCHAR | 1 | — | — | + | |
PR39 | Project Management Automatic Accounting Coding Schedule | PR39006 | Schedule Type | NCHAR | 2 | — | — | + | |
PR39 | Project Management Automatic Accounting Coding Schedule | PR39007 | Group | NCHAR | 2 | — | — | + | |
PR39 | Project Management Automatic Accounting Coding Schedule | PR39008 | Meta-Account | NCHAR | 2 | — | — | + | |
PR39 | Project Management Automatic Accounting Coding Schedule | PR39009 | Account | NVARCHAR | 12 | — | — | + | |
PR41 | Transaction Journal | PR41007 | Transaction Line Number | NVARCHAR | 6 | 3 | — | ||
PR41 | Transaction Journal | PR41010 | Text | NVARCHAR | 100 | 35 | — | ||
PR41 | Transaction Journal | PR41018 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PR41 | Transaction Journal | PR41026 | General Ledger Transaction Number | NVARCHAR | 9 | 6 | — | ||
PR41 | Transaction Journal | PR41034 | General Ledger Transaction Line Reference | NCHAR | 9 | 8 | — | ||
PR41 | Transaction Journal | PR41039 | Journal Line Number | NCHAR | 7 | 5 | — | ||
PR41 | Transaction Journal | PR41040 | General Ledger Line Counter | NCHAR | 9 | 8 | — | ||
PR41 | Transaction Journal | PR41041 | Operation Type | NVARCHAR | 10 | — | — | + | |
PR41 | Transaction Journal | PR41042 | Financial Operation Code | NVARCHAR | 10 | — | — | + | |
PR41 | Transaction Journal | PR41043 | NCM Code | NVARCHAR | 25 | — | — | + | |
PR41 | Transaction Journal | PR41044 | Product Tax Type | NVARCHAR | 10 | — | — | + | |
PR41 | Transaction Journal | PR41045 | Taxation Reason Code | NCHAR | 3 | — | — | + | |
PR42 | Transaction Journal Text Lines | PR42007 | Transaction Line Number | NVARCHAR | 6 | 3 | — | ||
PR42 | Transaction Journal Text Lines | PR42009 | Text Line Number | NVARCHAR | 3 | 2 | — | ||
PR42 | Transaction Journal Text Lines | PR42011 | Serial Number flag | NCHAR | 1 | — | — | + | |
PR44 | Project Delivered Material | PR44007 | Transaction Line Number | NVARCHAR | 6 | 3 | — | ||
PR44 | Project Delivered Material | PR44010 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PR44 | Project Delivered Material | PR44046 | Item Type | NCHAR | 1 | — | — | + | |
PR44 | Project Delivered Material | PR44047 | Close Date | DATETIME | 8 | — | — | + | |
PR44 | Project Delivered Material | PR44048 | Taxation Reason Code | NCHAR | 3 | — | — | + | |
PR45 | Invoice Statistics Head | PR45008 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PR45 | Invoice Statistics Head | PR45027 | Customer Purchase Order Number | NVARCHAR | 30 | 20 | — | ||
PR46 | Invoice Statistics Lines | PR46023 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PR46 | Invoice Statistics Lines | PR46029 | Activity Transaction Line | NCHAR | 6 | 3 | — | ||
PR47 | Invoice Statistics Material | PR47006 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PR49 | WIP History | PR49017 | Accounting String | NVARCHAR | 120 | — | — | + | |
PR49 | WIP History | PR49018 | WIP Transaction Number | NVARCHAR | 9 | — | — | + | |
PR49 | WIP History | PR49019 | WIP Transaction Line | NVARCHAR | 7 | — | — | + | |
PR49 | WIP History | PR49020 | Project Transaction Date | DATETIME | 8 | — | — | + | |
PR49 | WIP History | PR49021 | Project Transaction Line Number | NVARCHAR | 6 | — | — | + | |
PR49 | WIP History | PR49022 | AAScode | NVARCHAR | 25 | — | — | + | |
PR52 | Invoice Specification | PR52007 | Transaction No | NVARCHAR | 9 | 6 | — | ||
PR52 | Invoice Specification | PR52015 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PR53 | Project Capitalization history | PR53001 | Project | NCHAR | 12 | — | — | + | |
PR53 | Project Capitalization history | PR53002 | Subproject | NCHAR | 6 | — | — | + | |
PR53 | Project Capitalization history | PR53003 | Activity Line | NCHAR | 6 | — | — | + | |
PR53 | Project Capitalization history | PR53004 | Activity Struct Line | NCHAR | 6 | — | — | + | |
PR53 | Project Capitalization history | PR53005 | Master Asset Code | NVARCHAR | 35 | — | — | + | |
PR53 | Project Capitalization history | PR53006 | Value Component Code | NVARCHAR | 10 | — | — | + | |
PR53 | Project Capitalization history | PR53007 | Capitalization No | NCHAR | 6 | — | — | + | |
PR53 | Project Capitalization history | PR53008 | Capitalization Date | DATETIME | 8 | — | — | + | |
PR53 | Project Capitalization history | PR53009 | Amount LCU | NUMERIC | 20 | 8 | — | — | + |
PR53 | Project Capitalization history | PR53010 | User ID | NCHAR | 8 | — | — | + | |
PR53 | Project Capitalization history | PR53011 | TimeStamp | DATETIME | 17 | — | — | + | |
PR53 | Project Capitalization history | PR53012 | GL transaction No | NCHAR | 9 | — | — | + | |
PRGL | Project History WIP Journal | PRGL001 | RecCounter | NUMERIC | 9 | — | — | + | |
PRGL | Project History WIP Journal | PRGL002 | TransactionNo | NCHAR | 9 | — | — | + | |
PRGL | Project History WIP Journal | PRGL003 | LineNumber | NCHAR | 7 | — | — | + | |
PRGL | Project History WIP Journal | PRGL004 | TransactionDate | DATETIME | 8 | — | — | + | |
PRGL | Project History WIP Journal | PRGL005 | Flag | NCHAR | 1 | — | — | + | |
PRGL | Project History WIP Journal | PRGL006 | AccountingString | NVARCHAR | 120 | — | — | + | |
PRGL | Project History WIP Journal | PRGL007 | AmountLCU | NUMERIC | 20 | 8 | — | — | + |
PRGL | Project History WIP Journal | PRGL008 | CurrencyCode | INT | 2 | — | — | + | |
PRGL | Project History WIP Journal | PRGL009 | AccountingStringLCU | NVARCHAR | 120 | — | — | + | |
PRGL | Project History WIP Journal | PRGL010 | AmountOCU | NUMERIC | 20 | 8 | — | — | + |
PRGL | Project History WIP Journal | PRGL011 | TransactionText | NVARCHAR | 100 | — | — | + | |
PRGL | Project History WIP Journal | PRGL012 | Code1Engineer | NCHAR | 10 | — | — | + | |
PRGL | Project History WIP Journal | PRGL013 | Code2Project | NVARCHAR | 25 | — | — | + | |
PRGL | Project History WIP Journal | PRGL014 | Code3ActivityStructLineNum | NCHAR | 6 | — | — | + | |
PRGL | Project History WIP Journal | PRGL015 | Code4 | NCHAR | 2 | — | — | + | |
PRGL | Project History WIP Journal | PRGL016 | Code5 | NVARCHAR | 35 | — | — | + | |
PRGL | Project History WIP Journal | PRGL017 | Code6TransLineNumber | NCHAR | 8 | — | — | + | |
PRGL | Project History WIP Journal | PRGL018 | Tag1 | NCHAR | 1 | — | — | + | |
PRGL | Project History WIP Journal | PRGL019 | Tag2 | NCHAR | 1 | — | — | + | |
PRGL | Project History WIP Journal | PRGL020 | Tag3 | NCHAR | 1 | — | — | + | |
PRGL | Project History WIP Journal | PRGL021 | TransLineType | NCHAR | 1 | — | — | + | |
PRGL | Project History WIP Journal | PRGL022 | TransLineSign | NCHAR | 1 | — | — | + | |
PRGL | Project History WIP Journal | PRGL023 | NumberOfDecimals | NUMERIC | 1 | — | — | + | |
PRGL | Project History WIP Journal | PRGL024 | LinkCode | NCHAR | 8 | — | — | + | |
PRGL | Project History WIP Journal | PRGL025 | Quantity | NUMERIC | 20 | 8 | — | — | + |
PRGL | Project History WIP Journal | PRGL026 | UnitCode | INT | 4 | — | — | + | |
PRGL | Project History WIP Journal | PRGL027 | AmountCCU | NUMERIC | 20 | 8 | — | — | + |
PRGL | Project History WIP Journal | PRGL028 | ContraAcc | NCHAR | 13 | — | — | + | |
PRGL | Project History WIP Journal | PRGL029 | JournalNo | NUMERIC | 6 | — | — | + | |
PRGL | Project History WIP Journal | PRGL030 | PLReference | NCHAR | 9 | — | — | + | |
PRGL | Project History WIP Journal | PRGL031 | SubprojectNum | NCHAR | 6 | — | — | + | |
PRGL | Project History WIP Journal | PRGL032 | ActivityLineNum | NCHAR | 6 | — | — | + | |
PRGL | Project History WIP Journal | PRGL033 | UserIDEnteredBy | NCHAR | 8 | — | — | + | |
PRGL | Project History WIP Journal | PRGL034 | DateOfEntry | DATETIME | 8 | — | — | + | |
PRGL | Project History WIP Journal | PRGL035 | UserIDUpdatedBy | NCHAR | 8 | — | — | + | |
PRGL | Project History WIP Journal | PRGL036 | DateOfUpdate | DATETIME | 8 | — | — | + | |
PRGL | Project History WIP Journal | PRGL037 | TransactionTextOCU | NVARCHAR | 100 | — | — | + | |
PRGL | Project History WIP Journal | PRGL038 | SourceCompany | NCHAR | 2 | — | — | + | |
PRGL | Project History WIP Journal | PRGL039 | UserIDPrintedBy | NCHAR | 8 | — | — | + | |
PRGL | Project History WIP Journal | PRGL040 | DateOfPrint | DATETIME | 8 | — | — | + | |
PRGL | Project History WIP Journal | PRGL041 | PrintStatus | NCHAR | 1 | — | — | + | |
PRGL | Project History WIP Journal | PRGL042 | GLTransactionNum | NCHAR | 9 | — | — | + | |
PRI0 | Project Instalments | PRI0001 | Project Number | NVARCHAR | 12 | — | — | + | |
PRI0 | Project Instalments | PRI0002 | SubProject Number | NVARCHAR | 6 | — | — | + | |
PRI0 | Project Instalments | PRI0003 | Invoice Event Line Number | NVARCHAR | 4 | — | — | + | |
PRI0 | Project Instalments | PRI0004 | Payment Term | NVARCHAR | 2 | — | — | + | |
PRI0 | Project Instalments | PRI0005 | Use Instalment | NCHAR | 1 | — | — | + | |
PRI0 | Project Instalments | PRI0006 | Interest% | NVARCHAR | 6 | — | — | + | |
PRI0 | Project Instalments | PRI0007 | New Interest% | NVARCHAR | 6 | — | — | + | |
PRI0 | Project Instalments | PRI0008 | Activate New Interest Date | DATETIME | 8 | — | — | + | |
PRI0 | Project Instalments | PRI0009 | Financial Charge | NUMERIC | 20 | 8 | — | — | + |
PRI0 | Project Instalments | PRI0010 | Interest Tax Code | NCHAR | 6 | — | — | + | |
PRI0 | Project Instalments | PRI0011 | Financial Charge Code | NCHAR | 6 | — | — | + | |
PRI2 | Project Instalment Lines | PRI2001 | Project No | NVARCHAR | 12 | — | — | + | |
PRI2 | Project Instalment Lines | PRI2002 | Instalment Number | INT | 3 | — | — | + | |
PRI2 | Project Instalment Lines | PRI2003 | Due Date Shift | INT | 3 | — | — | + | |
PRI2 | Project Instalment Lines | PRI2004 | Percentage% | NVARCHAR | 6 | — | — | + | |
PRI2 | Project Instalment Lines | PRI2005 | Invoice Number | NVARCHAR | 15 | — | — | + | |
PRI2 | Project Instalment Lines | PRI2006 | Way Of Payment | NVARCHAR | 2 | — | — | + | |
PRI2 | Project Instalment Lines | PRI2007 | Payment Term | NVARCHAR | 2 | — | — | + | |
PRI4 | Project Instalment Lines History | PRI4001 | Project No | NVARCHAR | 12 | — | — | + | |
PRI4 | Project Instalment Lines History | PRI4002 | Instalment Number | INT | 3 | — | — | + | |
PRI4 | Project Instalment Lines History | PRI4003 | Due Date Shift | INT | 3 | — | — | + | |
PRI4 | Project Instalment Lines History | PRI4004 | Percentage% | NVARCHAR | 6 | — | — | + | |
PRI4 | Project Instalment Lines History | PRI4005 | Invoice Number | NVARCHAR | 15 | — | — | + | |
PRI4 | Project Instalment Lines History | PRI4006 | Way Of Payment | NVARCHAR | 2 | — | — | + | |
PRI4 | Project Instalment Lines History | PRI4007 | Payment Term | NVARCHAR | 2 | — | — | + | |
PRX1 | Wrk. PR0162 | PRX1011 | ActivityTransNum | NCHAR | 6 | 3 | — | ||
PRX3 | Cl.Pj.Inv. wrk. | PRX3001 | AcctngString | NVARCHAR | 120 | 50 | — | ||
PRX3 | Cl.Pj.Inv. wrk. | PRX3007 | Flags | NCHAR | 10 | — | — | + | |
PRX3 | Cl.Pj.Inv. wrk. | PRX3008 | Rate/VAT Code | NVARCHAR | 6 | — | — | + | |
PRX3 | Cl.Pj.Inv. wrk. | PRX3009 | Tax Type | NVARCHAR | 6 | — | — | + | |
PRX3 | Cl.Pj.Inv. wrk. | PRX3010 | AAS Position | NVARCHAR | 25 | — | — | + | |
PRX3 | Cl.Pj.Inv. wrk. | PRX3011 | Text | NVARCHAR | 50 | — | — | + | |
PRX3 | Cl.Pj.Inv. wrk. | PRX3012 | Tax Base Amount | NUMERIC | 20 | 8 | — | — | + |
PRX4 | Ed.Inv.Prop.wrk | PRX4005 | Inv_SortCode | NVARCHAR | 46 | 43 | — | ||
PRX4 | Ed.Inv.Prop.wrk | PRX4012 | Transactline | NVARCHAR | 6 | 3 | — | ||
PRX5 | Ed.Inv.Prop.wr1 | PRX5009 | AccounString | NVARCHAR | 120 | 50 | — | ||
PRX5 | Ed.Inv.Prop.wr1 | PRX5035 | VAT_Code | NVARCHAR | 6 | 2 | — | ||
PRX5 | Ed.Inv.Prop.wr1 | PRX5039 | Item Type | NCHAR | 1 | — | — | + | |
PRX5 | Ed.Inv.Prop.wr1 | PRX5040 | Operation Type | NVARCHAR | 10 | — | — | + | |
PRX5 | Ed.Inv.Prop.wr1 | PRX5041 | Financial Operation Code | NVARCHAR | 10 | — | — | + | |
PRX5 | Ed.Inv.Prop.wr1 | PRX5042 | Nomenclature Number | NVARCHAR | 25 | — | — | + | |
PRX5 | Ed.Inv.Prop.wr1 | PRX5043 | Product Tax Type | NVARCHAR | 10 | — | — | + | |
PRX5 | Ed.Inv.Prop.wr1 | PRX5044 | Taxation Reason Code | NCHAR | 3 | — | — | + | |
PRX6 | Invoice History Enquiry Table | PRX6005 | InvoiceNo | NVARCHAR | 15 | 10 | — | ||
PRX6 | Invoice History Enquiry Table | PRX6011 | InvoiceNo_Original\CreditNoteNo | NCHAR | 15 | 10 | — | ||
PRX6 | Invoice History Enquiry Table | PRX6012 | Invoice Prefix | NVARCHAR | 4 | — | — | + | |
PRX7 | Ed.Inv.Hist.wr1 | PRX7007 | TransactLine | NVARCHAR | 6 | 3 | — | ||
PRX8 | View Activites | PRX8005 | ActivStrLine | NVARCHAR | 6 | 3 | — | ||
PRX9 | Pj.Int.Debit w. | PRX9012 | AccounString | NVARCHAR | 120 | 50 | — | ||
PRX9 | Pj.Int.Debit w. | PRX9018 | TransactLine | NVARCHAR | 6 | 3 | — | ||
PRXX | Tr.Entries wrk. | PRXX012 | Text | NVARCHAR | 100 | 35 | — | ||
PRXX | Tr.Entries wrk. | PRXX020 | AccounString | NVARCHAR | 120 | 50 | — | ||
PRXX | Tr.Entries wrk. | PRXX031 | Voucher_No | NVARCHAR | 9 | 6 | — |
Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
На один уровень вверх / One level Up: Изменение полей в таблицах БД iScala 3.5 по сравнению с iScala 2.2 / Difference between DB structure of iScala 3.5 and iScala 2.2