One level Up / One level Up: Изменение полей в таблицах БД iScala 3.5 по сравнению с iScala 2.2 / Difference between DB structure of iScala 3.5 and iScala 2.2

Изменения структуры таблиц модуля «Управление Проектами» / Project Management tables structure changes

Название Таблицы / 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