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