Изменение структуры таблиц iScala 3.1 по сравнению с iScala 3.0 FSP4 / Table structure changes between iScala 3.0 FSP4 and iScala 3.1

Таблица / Table
Название таблицы / Table name
Поле / Field
Название поля / Field name
Тип данных / Data type Тип данных iScala / iScala data type Новая длина поля / New field length Точность / Precision Новая длина iScala / New iScala length Старая длина поля / Old field length Точность / Precision Старая длина iScala / Old iScala length
CMH3 Contract Line History File CMH3118 Taxation Reason Code NCHAR STRING 3 0 3
CMHI Invoicing Plan History CMHI024 Taxation Reason Code NCHAR STRING 3 0 3
CMIP Invoicing Plan CMIP024 Taxation Reason Code NCHAR STRING 3 0 3
DI11 Invoice Lines DI11014 Taxation Reason Code NCHAR STRING 3 0 3
DIH1 Direct Invoice Header History DIH1014 Taxation Reason Code NCHAR STRING 3 0 3
GL19 Transaction Workfile D GL19004 InvoiceNo NVARCHAR VSTRING 25 0 25 15 0 15
GL5S SPED parameters GL5S002 SPED Account Number NVARCHAR VSTRING 13 0 13 12 0 12
GL5S SPED parameters GL5S004 FCONT Account Number NVARCHAR VSTRING 13 0 13 12 0 12
OR03 Sales Order Lines OR03141 Tax Reason Code NCHAR STRING 3 0 3
OR05 Order Parameters OR05173 Tax Reason Code NCHAR STRING 3 0 3
OR21 History Sales Order Lines OR21141 Tax Reason Code NCHAR STRING 3 0 3
OR41 Sales Order Lines Historical Versions OR41141 Tax Reason Code NCHAR STRING 3 0 3
PC01 Purchase Order Head PC01017 Our Reference NVARCHAR VSTRING 35 0 35 20 0 20
PC01 Purchase Order Head PC01018 Your Reference NVARCHAR VSTRING 35 0 35 20 0 20
PC14 Order Line Del. PC14053 Customs Dispatch Note Number NVARCHAR VSTRING 30 0 30 25 0 25
PC41 Purchase Order Head History PC41017 Our Reference NVARCHAR VSTRING 35 0 35 20 0 20
PC41 Purchase Order Head History PC41018 Your Reference NVARCHAR VSTRING 35 0 35 20 0 20
PL01 Suppliers PL01011 Customer Code at Supplier NVARCHAR VSTRING 20 0 20 10 0 10
PL07 Payment Proposal PL07010 Amount to Pay (Payment Currency) NUMERIC MONEY 28 8 20 20 0 20
PL07 Payment Proposal PL07011 Discount Amount (Payment Currency) NUMERIC MONEY 28 8 20 20 0 20
PL07 Payment Proposal PL07012 With-holding Tax (Payment Currency) NUMERIC MONEY 28 8 20 20 0 20
PL15 Payment Methods PL15015 SEPA Sub Types NVARCHAR VSTRING 20 0 20
PL15 Payment Methods PL15016 Parameter 10 NCHAR STRING 3 0 3
PL15 Payment Methods PL15017 Parameter 11 NCHAR STRING 3 0 3
PL19 Standard Suppliers PL19011 Customer Code at Supplier NVARCHAR VSTRING 20 0 20 10 0 10
PL45 Extended Bank Info PL45030 Clearing System ID (BBAN) NCHAR STRING 5 0 5
PL45 Extended Bank Info PL45031 Clearing Member ID (BBAN) NVARCHAR VSTRING 35 0 35
PL45 Extended Bank Info PL45032 Corr Clearing System ID (BBAN) NCHAR STRING 5 0 5
PL45 Extended Bank Info PL45033 Corr Clearing Member ID (BBAN) NVARCHAR VSTRING 35 0 35
PLC0 Import information from customs certificates or invoices PLC0001 Supplier Code NVARCHAR VSTRING 10 0 10
PLC0 Import information from customs certificates or invoices PLC0002 Invoice No NVARCHAR VSTRING 25 0 25
PLC0 Import information from customs certificates or invoices PLC0003 Customs Declar No NVARCHAR VSTRING 25 0 25
PLC0 Import information from customs certificates or invoices PLC0004 Customs Inv/Certif No NVARCHAR VSTRING 25 0 25
PLC0 Import information from customs certificates or invoices PLC0005 Customs Value NUMERIC MONEY 28 8 20
PLC0 Import information from customs certificates or invoices PLC0006 Registr. No NVARCHAR VSTRING 15 0 15
PLC0 Import information from customs certificates or invoices PLC0007 Date of Decision DATETIME DATE 0 0 8
PLDA SEPA Debtor Accounts PLDA001 SEPA CRT Bank Template NCHAR STRING 2 0 2
PLDA SEPA Debtor Accounts PLDA002 Sub-Type NCHAR STRING 2 0 2
PLDA SEPA Debtor Accounts PLDA003 Currency NCHAR STRING 2 0 2
PLDA SEPA Debtor Accounts PLDA004 Type of Account INT INTEGER 0 0 2
PLDA SEPA Debtor Accounts PLDA005 Bank Account NVARCHAR VSTRING 34 0 34
PLDA SEPA Debtor Accounts PLDA006 PM AAS Reference INT INTEGER 0 0 1
PLDA SEPA Debtor Accounts PLDA007 GL Account NVARCHAR ACCSTR 50 0 50
PLPU Payment Proposal unique parameters PLPU099 Payment Currency Sub-type 1 NCHAR SWITCH 1 0 1
PLPU Payment Proposal unique parameters PLPU100 Payment Currency Sub-type 2 NCHAR SWITCH 1 0 1
PLPU Payment Proposal unique parameters PLPU101 Payment Currency Sub-type 3 NCHAR SWITCH 1 0 1
PLPU Payment Proposal unique parameters PLPU102 Payment Currency Sub-type 4 NCHAR SWITCH 1 0 1
PLPU Payment Proposal unique parameters PLPU103 Payment Currency Sub-type 5 NCHAR SWITCH 1 0 1
PLPU Payment Proposal unique parameters PLPU104 Payment Currency Sub-type 6 NCHAR SWITCH 1 0 1
PLPU Payment Proposal unique parameters PLPU105 Payment Currency Sub-type 7 NCHAR SWITCH 1 0 1
PLPU Payment Proposal unique parameters PLPU106 Payment Currency Sub-type 8 NCHAR SWITCH 1 0 1
PLPU Payment Proposal unique parameters PLPU107 Payment Currency Sub-type 9 NCHAR SWITCH 1 0 1
PLPU Payment Proposal unique parameters PLPU108 Payment Currency Sub-type 10 NCHAR SWITCH 1 0 1
PLPU Payment Proposal unique parameters PLPU109 Currency Code Sub-type 1 INT INTEGER 0 0 2
PLPU Payment Proposal unique parameters PLPU110 Currency Code Sub-type 2 INT INTEGER 0 0 2
PLPU Payment Proposal unique parameters PLPU111 Currency Code Sub-type 3 INT INTEGER 0 0 2
PLPU Payment Proposal unique parameters PLPU112 Currency Code Sub-type 4 INT INTEGER 0 0 2
PLPU Payment Proposal unique parameters PLPU113 Currency Code Sub-type 5 INT INTEGER 0 0 2
PLPU Payment Proposal unique parameters PLPU114 Currency Code Sub-type 6 INT INTEGER 0 0 2
PLPU Payment Proposal unique parameters PLPU115 Currency Code Sub-type 7 INT INTEGER 0 0 2
PLPU Payment Proposal unique parameters PLPU116 Currency Code Sub-type 8 INT INTEGER 0 0 2
PLPU Payment Proposal unique parameters PLPU117 Currency Code Sub-type 9 INT INTEGER 0 0 2
PLPU Payment Proposal unique parameters PLPU118 Currency Code Sub-type 10 INT INTEGER 0 0 2
PLSE SEPA CRT payments and receipts PLSE010 AmoPaidPaymentCurr NUMERIC MONEY 28 8 20 20 0 20
PLSE SEPA CRT payments and receipts PLSE011 DscAmoPaymentCurr NUMERIC MONEY 28 8 20 20 0 20
PLSE SEPA CRT payments and receipts PLSE012 WHoldTaxPayCurrency NUMERIC MONEY 28 8 20 20 0 20
PLSE SEPA CRT payments and receipts PLSE041 Payment ID NVARCHAR VSTRING 35 0 35
PLSE SEPA CRT payments and receipts PLSE042 Debtor Account Type INT INTEGER 0 0 2
PLSE SEPA CRT payments and receipts PLSE043 Sub-Type NCHAR STRING 2 0 2
PLSE SEPA CRT payments and receipts PLSE044 BIC — Creditor Account?s Bank NVARCHAR VSTRING 11 0 11
PLSE SEPA CRT payments and receipts PLSE045 Creditor Account NVARCHAR VSTRING 35 0 35
PLSE SEPA CRT payments and receipts PLSE046 Creditor Account Type NCHAR STRING 2 0 2
PLSE SEPA CRT payments and receipts PLSE047 Payment Priority INT INTEGER 0 0 1
PLSE SEPA CRT payments and receipts PLSE048 Central Bank Code NCHAR STRING 4 0 4
PLSE SEPA CRT payments and receipts PLSE049 Invoice Comment NVARCHAR VSTRING 50 0 50
PLSE SEPA CRT payments and receipts PLSE050 Clearing System ID ? Creditor Bank NCHAR STRING 5 0 5
PLSE SEPA CRT payments and receipts PLSE051 Clearing Member ID ? Creditor Bank NVARCHAR VSTRING 35 0 35
PLSE SEPA CRT payments and receipts PLSE052 Credit Split Status INT INTEGER 0 0 1
PLSE SEPA CRT payments and receipts PLSE053 PM AAS Reference INT INTEGER 0 0 1
PLSE SEPA CRT payments and receipts PLSE054 GL Account NVARCHAR ACCSTR 50 0 50
PLSE SEPA CRT payments and receipts PLSE055 Alt Grouping 1 NVARCHAR VSTRING 10 0 10
PLSE SEPA CRT payments and receipts PLSE056 Alt Grouping 2 NVARCHAR VSTRING 10 0 10
PLSG SEPA Grouping Parameters PLSG001 SEPA CRT Bank Template NCHAR STRING 2 0 2
PLSG SEPA Grouping Parameters PLSG002 Sub-Type NCHAR STRING 2 0 2
PLSG SEPA Grouping Parameters PLSG003 Max Number (Cr.Gr) INT INTEGER 0 0 3
PLSG SEPA Grouping Parameters PLSG004 Min Coin (Cr.Gr.) NCHAR SWITCH 1 0 1
PLSG SEPA Grouping Parameters PLSG005 One Invoice ? N Credits (Cr.Gr.) INT INTEGER 0 0 1
PLSG SEPA Grouping Parameters PLSG006 One Credit ? N Invoices (Cr.Gr.) INT INTEGER 0 0 1
PLSG SEPA Grouping Parameters PLSG007 Split Credit (Cr.Gr.) NCHAR SWITCH 1 0 1
PLSG SEPA Grouping Parameters PLSG008 Merge (Cr.Gr.) NCHAR SWITCH 1 0 1
PLSG SEPA Grouping Parameters PLSG009 Fill Group (Cr.Gr.) NCHAR SWITCH 1 0 1
PLSG SEPA Grouping Parameters PLSG010 Max Number (In.Gr.) INT INTEGER 0 0 3
PLSG SEPA Grouping Parameters PLSG011 Only Without Ref. (In.Gr.) NCHAR SWITCH 1 0 1
PLSG SEPA Grouping Parameters PLSG012 Property 1 NCHAR SWITCH 1 0 1
PLSG SEPA Grouping Parameters PLSG013 Property 2 NCHAR SWITCH 1 0 1
PR02 Project Activities PR02075 Taxation Reason Code NCHAR STRING 3 0 3
PR03 Project Activity Transactions PR03056 Taxation Reason Code NCHAR STRING 3 0 3
PR10 Project Activity File PR10049 Taxation Reason Code NCHAR STRING 3 0 3
PR29 Project Invoice History File PR29053 Taxation Reason Code NCHAR STRING 3 0 3
PR31 Project Invoice Plan File PR31040 Taxation Reason Code Material NCHAR STRING 3 0 3
PR31 Project Invoice Plan File PR31041 Taxation Reason Code Cost NCHAR STRING 3 0 3
PR31 Project Invoice Plan File PR31042 Taxation Reason Code Time NCHAR STRING 3 0 3
PR31 Project Invoice Plan File PR31043 Taxation Reason Code NCHAR STRING 3 0 3
PR38 Project Invoice History Details File PR38032 Taxation Reason Code NCHAR STRING 3 0 3
PR41 Transaction Journal PR41045 Taxation Reason Code NCHAR STRING 3 0 3
PR44 Project Delivered Material PR44048 Taxation Reason Code NCHAR STRING 3 0 3
PRX5 Ed.Inv.Prop.wr1 PRX5044 Taxation Reason Code NCHAR STRING 3 0 3
SC01 Stock Item File SC01266 Tax Reason Code NCHAR STRING 3 0 3
SC33 Batch Information SC33051 Customs Dispatch Number NVARCHAR VSTRING 30 0 30 25 0 25
SC37 Standard Stock Items SC37266 Tax Reason Code NCHAR STRING 3 0 3
SL01 Customer File SL01254 Tax Reason Code NCHAR STRING 3 0 3
SL08 Sales Ledger Parameters SL08021 Deduct Grace Period NCHAR SWITCH 1 0 1 9 8 1
SL19 Standard Customers SL19254 Tax Reason Code NCHAR STRING 3 0 3
SL21 Sales Ledger Payments SL21010 Check Number NVARCHAR VSTRING 25 0 25 15 0 15
SLH6 Invoice Lines Details History SLH6070 Spare NVARCHAR VSTRING 10 0 10
SLH6 Invoice Lines Details History SLH6071 Spare NVARCHAR VSTRING 10 0 10
SLH7 Invoice Texts Linked to Generic Invoices SLH7001 Customer Code NVARCHAR VSTRING 10 0 10
SLH7 Invoice Texts Linked to Generic Invoices SLH7002 Invoice No NVARCHAR VSTRING 15 0 15
SLH7 Invoice Texts Linked to Generic Invoices SLH7003 Invoice Line Number NVARCHAR VSTRING 6 0 6
SLH7 Invoice Texts Linked to Generic Invoices SLH7004 Text Line Number NVARCHAR VSTRING 6 0 6
SLH7 Invoice Texts Linked to Generic Invoices SLH7005 Text Type NVARCHAR VSTRING 2 0 2
SLH7 Invoice Texts Linked to Generic Invoices SLH7006 Text NVARCHAR VSTRING 4000 0 4000
SLH7 Invoice Texts Linked to Generic Invoices SLH7007 Original Reference NVARCHAR VSTRING 8 0 8
SM03 Service Order Activity File I/O SM03079 Taxation Reason Code NCHAR STRING 3 0 3
SM04 Service Order Invoice Customer File SM04128 Taxation Reason Code Fixed Price NCHAR STRING 3 0 3
SM04 Service Order Invoice Customer File SM04129 Taxation Reason Code On-Account NCHAR STRING 3 0 3
SM05 Service Order Cost File I/O SM05088 Taxation Reason Code NCHAR STRING 3 0 3
SM06 Service Order Line Delivery Definition SM06039 Return Note Number NVARCHAR VSTRING 20 0 20 10 0 10
SM07 Service Order Material File I/O SM07089 Return Note Number NVARCHAR VSTRING 20 0 20 10 0 10
SM07 Service Order Material File I/O SM07149 Taxation Reason Code NCHAR STRING 3 0 3
SM13 Service Contract Line File I/O SM13118 Taxation Reason Code NCHAR STRING 3 0 3
SM24 Service Order Activity Files Descriptions SM24027 Taxation Reason Code NCHAR STRING 3 0 3
SM43 Service Order Activity History File I/O SM43079 Taxation Reason Code NCHAR STRING 3 0 3
SM44 Service Order Cost History File I/O SM44088 Taxation Reason Code NCHAR STRING 3 0 3
SM45 Service Order Material History File I/O SM45089 Return Note Number NVARCHAR VSTRING 20 0 20 10 0 10
SM45 Service Order Material History File I/O SM45149 Taxation Reason Code NCHAR STRING 3 0 3
SM47 Service Order Line Delivery History File SM47039 Return Note Number NVARCHAR VSTRING 20 0 20 10 0 10
SM48 Service Order Invoice Customer File History SM48128 Taxation Reason Code Fixed Price NCHAR STRING 3 0 3
SM48 Service Order Invoice Customer File History SM48129 Taxation Reason Code On-Account NCHAR STRING 3 0 3
SM69 Contract Codes SM69051 Line Entry Mask NVARCHAR VSTRING 150 0 150 100 0 100
SM69 Contract Codes SM69087 Mask for Lease Asset Lines NVARCHAR VSTRING 150 0 150 100 0 100
SM69 Contract Codes SM69088 Mask for Lease Accessory Lines NVARCHAR VSTRING 150 0 150 100 0 100
SM69 Contract Codes SM69089 Mask for Service Asset Lines NVARCHAR VSTRING 150 0 150 100 0 100
SM69 Contract Codes SM69138 Taxation Reason Code NCHAR STRING 3 0 3
SY24 General Code File SY24003 Description NVARCHAR VSTRING 60 0 60 50 0 50
SY29 VAT Codes SY29044 Tax Reason Necessity NCHAR STRING 1 0 1
SY42 Multilingual Code File SY42004 Description NVARCHAR VSTRING 60 0 60 50 0 50
SY7R Common Ranges SY7R007 Column P2 NVARCHAR VSTRING 128 0 128
SY7R Common Ranges SY7R008 Link ID P2 INT INTEGER 0 0 3
SY7R Common Ranges SY7R009 Intermediate Link ID P2 INT INTEGER 0 0 3
SY7R Common Ranges SY7R010 Column P3 NVARCHAR VSTRING 128 0 128
SY7R Common Ranges SY7R011 Link ID P3 INT INTEGER 0 0 3
SY7R Common Ranges SY7R012 Intermediate Link ID P3 INT INTEGER 0 0 3
SY7R Common Ranges SY7R013 Column P4 NVARCHAR VSTRING 128 0 128
SY7R Common Ranges SY7R014 Link ID P4 INT INTEGER 0 0 3
SY7R Common Ranges SY7R015 Intermediate Link ID P4 INT INTEGER 0 0 3
SY7R Common Ranges SY7R016 Column P5 NVARCHAR VSTRING 128 0 128
SY7R Common Ranges SY7R017 Link ID P5 INT INTEGER 0 0 3
SY7R Common Ranges SY7R018 Intermediate Link ID P5 INT INTEGER 0 0 3
SY7R Common Ranges SY7R019 Column P6 NVARCHAR VSTRING 128 0 128
SY7R Common Ranges SY7R020 Link ID P6 INT INTEGER 0 0 3
SY7R Common Ranges SY7R021 Intermediate Link ID P6 INT INTEGER 0 0 3
SY7R Common Ranges SY7R022 Column P7 NVARCHAR VSTRING 128 0 128
SY7R Common Ranges SY7R023 Link ID P7 INT INTEGER 0 0 3
SY7R Common Ranges SY7R024 Intermediate Link ID P7 INT INTEGER 0 0 3
SY7S UDDB Default Values SY7S006 Field Property INT INTEGER 0 0 1
SY7S UDDB Default Values SY7S007 Use Current Date As Default NCHAR SWITCH 1 0 1