На один уровень вверх / 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   —