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

Изменения структуры таблиц модуля «Системные Утилиты» / System Utilities 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?
SY18 Tax Engine Parameters SY18010 Periods for Tax Calculation NCHAR 1   — — +
SY18 Tax Engine Parameters SY18011 Tax Situation Source INT 1   — — +
SY24 General Code File SY24003 Description NVARCHAR 60   25   —
SY24 General Code File SY24004 Code Dependent Field 1 NVARCHAR 18   12   —
SY24 General Code File SY24008 Code Dependent Field 5 NVARCHAR 50   35   —
SY24 General Code File SY24009 Code Dependent Field 6 NVARCHAR 50   35   —
SY24 General Code File SY24010 Code Dependent Field 7 NVARCHAR 50   35   —
SY24 General Code File SY24011 Code Dependent Field 8 NVARCHAR 50   35   —
SY24 General Code File SY24012 Code Dependent Field 9 NVARCHAR 50   — — +
SY24 General Code File SY24013 Code Dependent Field 10 NVARCHAR 50   — — +
SY24 General Code File SY24014 Code Dependent Field 11 NVARCHAR 50   — — +
SY24 General Code File SY24015 Code Dependent Field 12 NVARCHAR 50   — — +
SY24 General Code File SY24016 Code Dependent Field 13 NVARCHAR 50   — — +
SY24 General Code File SY24017 Accounting String NVARCHAR 120   — — +
SY28 Pre-printing form inventory SY28002 Official Form ID (Number) NVARCHAR 20   10   —
SY28 Pre-printing form inventory SY28003 Document Type NCHAR 3   2   —
SY28 Pre-printing form inventory SY28013 Issuer Code NCHAR 6   — — +
SY28 Pre-printing form inventory SY28014 IssuerType NCHAR 1   — — +
SY28 Pre-printing form inventory SY28015 Document Date DATETIME 8   — — +
SY29 VAT Codes SY29034 Rate Rule Code NVARCHAR 10   — — +
SY29 VAT Codes SY29035 Control Account for Output Tax NVARCHAR 12   — — +
SY29 VAT Codes SY29036 Control Account for Input Tax NVARCHAR 12   — — +
SY29 VAT Codes SY29037 Linked Tax Code NVARCHAR 8   — — +
SY29 VAT Codes SY29038 Surcharge Tax Code NVARCHAR 8   — — +
SY29 VAT Codes SY29039 Maximum Tax Amount NUMERIC 20 8 — — +
SY29 VAT Codes SY29040 Cost Account NVARCHAR 12   — — +
SY29 VAT Codes SY29041 Cost Type NCHAR 2   — — +
SY29 VAT Codes SY29042 Cost Accounting NCHAR 1   — — +
SY29 VAT Codes SY29043 Tax Reason Code NCHAR 3   — — +
SY29 VAT Codes SY29044 Tax Reason Necessity NCHAR 1   — — +
SY29 VAT Codes SY29045 Tax Type linked to STE tax NCHAR 6   — — +
SY2D Skipped Counter Values(Year Independent) SY69001 Counter ID NVARCHAR 12   — — +
SY2D Skipped Counter Values(Year Independent) SY69002 Skipped Counter Value NUMERIC 20   — — +
SY31 Accounting Dimensions Defaults SY31002 Module INT 3   2   —
SY40 Scala Parameters Storage SY40004 Parameter Value NVARCHAR 120   50   —
SY42 Multilingual Code File SY42004 Description NVARCHAR 60   25   —
SY45 Tolerance Table SY45003 Measurement Code INT 4   2   —
SY47 Business Destinations SY47003 Document ID NCHAR 3   2   —
SY50 Statistic Currency Rate for Accounting Periods SY50001 Currency Code NCHAR 2   — — +
SY50 Statistic Currency Rate for Accounting Periods SY50002 Curr. Rate forAcc.Per 01 NUMERIC 15 8 — — +
SY50 Statistic Currency Rate for Accounting Periods SY50003 Curr. Rate forAcc.Per 02 NUMERIC 15 8 — — +
SY50 Statistic Currency Rate for Accounting Periods SY50004 Curr. Rate forAcc.Per 03 NUMERIC 15 8 — — +
SY50 Statistic Currency Rate for Accounting Periods SY50005 Curr. Rate forAcc.Per 04 NUMERIC 15 8 — — +
SY50 Statistic Currency Rate for Accounting Periods SY50006 Curr. Rate forAcc.Per 05 NUMERIC 15 8 — — +
SY50 Statistic Currency Rate for Accounting Periods SY50007 Curr. Rate forAcc.Per 06 NUMERIC 15 8 — — +
SY50 Statistic Currency Rate for Accounting Periods SY50008 Curr. Rate forAcc.Per 07 NUMERIC 15 8 — — +
SY50 Statistic Currency Rate for Accounting Periods SY50009 Curr. Rate forAcc.Per 08 NUMERIC 15 8 — — +
SY50 Statistic Currency Rate for Accounting Periods SY50010 Curr. Rate forAcc.Per 09 NUMERIC 15 8 — — +
SY50 Statistic Currency Rate for Accounting Periods SY50011 Curr. Rate forAcc.Per 10 NUMERIC 15 8 — — +
SY50 Statistic Currency Rate for Accounting Periods SY50012 Curr. Rate forAcc.Per 11 NUMERIC 15 8 — — +
SY50 Statistic Currency Rate for Accounting Periods SY50013 Curr. Rate forAcc.Per 12 NUMERIC 15 8 — — +
SY50 Statistic Currency Rate for Accounting Periods SY50014 Curr. Rate forAcc.Per 13 NUMERIC 15 8 — — +
SY50 Statistic Currency Rate for Accounting Periods SY50015 Curr. Rate forAcc.Per 14 NUMERIC 15 8 — — +
SY50 Statistic Currency Rate for Accounting Periods SY50016 Curr. Rate forAcc.Per 15 NUMERIC 15 8 — — +
SY50 Statistic Currency Rate for Accounting Periods SY50017 Curr. Rate forAcc.Per 16 NUMERIC 15 8 — — +
SY50 Statistic Currency Rate for Accounting Periods SY50018 Curr. Rate forAcc.Per 17 NUMERIC 15 8 — — +
SY50 Statistic Currency Rate for Accounting Periods SY50019 Curr. Rate forAcc.Per 18 NUMERIC 15 8 — — +
SY51 Export control audit SY51001 Record ID NVARCHAR 10   — — +
SY51 Export control audit SY51002 Object Type INT 2   — — +
SY51 Export control audit SY51003 Object Number NVARCHAR 10   — — +
SY51 Export control audit SY51004 Line Number NVARCHAR 10   — — +
SY51 Export control audit SY51005 Sub Line Number NVARCHAR 6   — — +
SY51 Export control audit SY51006 Blocking Type INT 2   — — +
SY51 Export control audit SY51007 Action INT 2   — — +
SY51 Export control audit SY51008 Date-time stamp DATETIME 17   — — +
SY51 Export control audit SY51009 User ID NVARCHAR 8   — — +
SY51 Export control audit SY51010 Scala User Full Name NVARCHAR 35   — — +
SY51 Export control audit SY51011 Delivery Customer code NVARCHAR 35   — — +
SY51 Export control audit SY51012 Delivery Customer name NVARCHAR 35   — — +
SY51 Export control audit SY51013 Country code NVARCHAR 35   — — +
SY51 Export control audit SY51014 Stock Item code NVARCHAR 35   — — +
SY51 Export control audit SY51015 Stock Item description NVARCHAR 35   — — +
SY52 Export control action SY52001 Object Type INT 2   — — +
SY52 Export control action SY52002 Order Number NVARCHAR 10   — — +
SY52 Export control action SY52003 Line Number NVARCHAR 10   — — +
SY52 Export control action SY52004 Subline Number NVARCHAR 6   — — +
SY52 Export control action SY52005 Action INT 2   — — +
SY52 Export control action SY52006 Date-time stamp DATETIME 17   — — +
SY52 Export control action SY52007 User ID NVARCHAR 8   — — +
SY52 Export control action SY52008 Del.Cust.Code NVARCHAR 10   — — +
SY52 Export control action SY52009 Del.Cust.Status INT 1   — — +
SY52 Export control action SY52010 Country NVARCHAR 3   — — +
SY52 Export control action SY52011 Country Status INT 1   — — +
SY52 Export control action SY52012 Stock Item Status INT 1   — — +
SY52 Export control action SY52013 Line Status INT 1   — — +
SY53 Export control rules SY53001 Stock Item status INT 1   — — +
SY53 Export control rules SY53002 Country status INT 1   — — +
SY53 Export control rules SY53003 Customer status INT 1   — — +
SY53 Export control rules SY53004 Action INT 1   — — +
SY55 Cheque Transactions SY55001 Record Counter NUMERIC 9   8   —
SY55 Cheque Transactions SY55002 Transaction Number NCHAR 9   6   —
SY55 Cheque Transactions SY55003 Line Number NCHAR 7   5   —
SY55 Cheque Transactions SY55006 Accounting String NVARCHAR 120   50   —
SY55 Cheque Transactions SY55009 Accounting String Line Currency NVARCHAR 120   50   —
SY55 Cheque Transactions SY55011 Transaction Line Text NVARCHAR 100   25   —
SY55 Cheque Transactions SY55013 Document Number NVARCHAR 25   23   —
SY55 Cheque Transactions SY55024 Link Code NCHAR 8   5   —
SY55 Cheque Transactions SY55026 Unit Code INT 4   2   —
SY55 Cheque Transactions SY55030 PL Reference NCHAR 9   6   —
SY55 Cheque Transactions SY55037 Transaction Text Line Currency NVARCHAR 100   25   —
SY55 Cheque Transactions SY55038 Printed By NCHAR 8   — — +
SY55 Cheque Transactions SY55039 Date Printed DATETIME 8   — — +
SY69 Skipped Counter Values SY69001 Counter ID NVARCHAR 12   — — +
SY69 Skipped Counter Values SY69002 Skipped Counter Value NUMERIC 20   — — +
SY7R Common Ranges SY7R007 Column P2 NVARCHAR 128   — — +
SY7R Common Ranges SY7R008 Link ID P2 INT 3   — — +
SY7R Common Ranges SY7R009 Intermediate Link ID P2 INT 3   — — +
SY7R Common Ranges SY7R010 Column P3 NVARCHAR 128   — — +
SY7R Common Ranges SY7R011 Link ID P3 INT 3   — — +
SY7R Common Ranges SY7R012 Intermediate Link ID P3 INT 3   — — +
SY7R Common Ranges SY7R013 Column P4 NVARCHAR 128   — — +
SY7R Common Ranges SY7R014 Link ID P4 INT 3   — — +
SY7R Common Ranges SY7R015 Intermediate Link ID P4 INT 3   — — +
SY7R Common Ranges SY7R016 Column P5 NVARCHAR 128   — — +
SY7R Common Ranges SY7R017 Link ID P5 INT 3   — — +
SY7R Common Ranges SY7R018 Intermediate Link ID P5 INT 3   — — +
SY7R Common Ranges SY7R019 Column P6 NVARCHAR 128   — — +
SY7R Common Ranges SY7R020 Link ID P6 INT 3   — — +
SY7R Common Ranges SY7R021 Intermediate Link ID P6 INT 3   — — +
SY7R Common Ranges SY7R022 Column P7 NVARCHAR 128   — — +
SY7R Common Ranges SY7R023 Link ID P7 INT 3   — — +
SY7R Common Ranges SY7R024 Intermediate Link ID P7 INT 3   — — +
SY7S UDDB Default Values SY7S006 Field Property INT 1   — — +
SY7S UDDB Default Values SY7S007 Use Current Date As Default NCHAR 1   — — +
SY80 Customer Site Address File I/O SY80013 Reference NVARCHAR 35   25   —
SY80 Customer Site Address File I/O SY80035 Accounting String NVARCHAR 120   50   —
SY80 Customer Site Address File I/O SY80045 CityCode NVARCHAR 10   — — +
SY80 Customer Site Address File I/O SY80046 Default Engineer NVARCHAR 10   — — +
SY80 Customer Site Address File I/O SY80047 Order Number NVARCHAR 10   — — +
SY80 Customer Site Address File I/O SY80048 Country Code NVARCHAR 3   — — +
SY80 Customer Site Address File I/O SY80049 Email address NVARCHAR 200   — — +
SY80 Customer Site Address File I/O SY80050 Address Line 5 NVARCHAR 35   — — +
SY80 Customer Site Address File I/O SY80051 Address Line 6 NVARCHAR 35   — — +
SY80 Customer Site Address File I/O SY80052 Address Line 7 NVARCHAR 35   — — +
SY80 Customer Site Address File I/O SY80053 Longitude NUMERIC 28 8 — — +
SY80 Customer Site Address File I/O SY80054 Latitude NUMERIC 28 8 — — +
SY80 Customer Site Address File I/O SY80055 Altitude NUMERIC 28 8 — — +
SY80 Customer Site Address File I/O SY80056 External ID NVARCHAR 36   — — +
SY82 Lead Time Element SY82007 UDMS Code NCHAR 6   — — +
SY82 Lead Time Element SY82008 Link LTE To Order Header INT 1   — — +
SY87 Lead Time Rule Duration SY87010 Collection Calendar ID NCHAR 10   — — +
SY90 User defined milestone SY90001 Milestone Code NCHAR 6   — — +
SY90 User defined milestone SY90002 Milestone Name NVARCHAR 35   — — +
SY91 User defined milestone multilingual SY91001 Milestone Code NCHAR 6   — — +
SY91 User defined milestone multilingual SY91002 Language Code NCHAR 3   — — +
SY91 User defined milestone multilingual SY91003 Milestone Name NVARCHAR 35   — — +
SYA1 Calculation Algorithm Head SYA1001 Calculation Algorithm NVARCHAR 8   — — +
SYA1 Calculation Algorithm Head SYA1002 Calculation Algorithm Description NVARCHAR 35   — — +
SYA1 Calculation Algorithm Head SYA1003 Tax Base NVARCHAR 8   — — +
SYA1 Calculation Algorithm Head SYA1004 Tax Amount NVARCHAR 8   — — +
SYA2 Calculation Algorithm Lines SYA2001 Calculation Algorithm NVARCHAR 8   — — +
SYA2 Calculation Algorithm Lines SYA2002 Algorithm Line Code NVARCHAR 3   — — +
SYA2 Calculation Algorithm Lines SYA2003 Operand1 NVARCHAR 20   — — +
SYA2 Calculation Algorithm Lines SYA2004 Line Operator NVARCHAR 3   — — +
SYA2 Calculation Algorithm Lines SYA2005 Operand2 NVARCHAR 20   — — +
SYA2 Calculation Algorithm Lines SYA2006 Operand3 NVARCHAR 20   — — +
SYA2 Calculation Algorithm Lines SYA2007 Operand4 NVARCHAR 20   — — +
SYAC Accounting String Conversion Control SYAC001 Table NVARCHAR 100   — — +
SYAC Accounting String Conversion Control SYAC002 Converted NCHAR 1   — — +
SYAC Accounting String Conversion Control SYAC003 CurrentLengthD0 INT 2   — — +
SYAC Accounting String Conversion Control SYAC004 CurrentLengthD1 INT 2   — — +
SYAC Accounting String Conversion Control SYAC005 CurrentLengthD2 INT 2   — — +
SYAC Accounting String Conversion Control SYAC006 CurrentLengthD3 INT 2   — — +
SYAC Accounting String Conversion Control SYAC007 CurrentLengthD4 INT 2   — — +
SYAC Accounting String Conversion Control SYAC008 CurrentLengthD5 INT 2   — — +
SYAC Accounting String Conversion Control SYAC009 CurrentLengthD6 INT 2   — — +
SYAC Accounting String Conversion Control SYAC010 CurrentLengthD7 INT 2   — — +
SYAC Accounting String Conversion Control SYAC011 CurrentLengthD8 INT 2   — — +
SYAC Accounting String Conversion Control SYAC012 CurrentLengthD9 INT 2   — — +
SYAC Accounting String Conversion Control SYAC013 NewLengthD0 INT 2   — — +
SYAC Accounting String Conversion Control SYAC014 NewLengthD1 INT 2   — — +
SYAC Accounting String Conversion Control SYAC015 NewLengthD2 INT 2   — — +
SYAC Accounting String Conversion Control SYAC016 NewLengthD3 INT 2   — — +
SYAC Accounting String Conversion Control SYAC017 NewLengthD4 INT 2   — — +
SYAC Accounting String Conversion Control SYAC018 NewLengthD5 INT 2   — — +
SYAC Accounting String Conversion Control SYAC019 NewLengthD6 INT 2   — — +
SYAC Accounting String Conversion Control SYAC020 NewLengthD7 INT 2   — — +
SYAC Accounting String Conversion Control SYAC021 NewLengthD8 INT 2   — — +
SYAC Accounting String Conversion Control SYAC022 NewLengthD9 INT 2   — — +
SYAF Audit Trail File for Monetary restatment utility SYAF004 Counter NUMERIC 9   8   —
SYAF Audit Trail File for Monetary restatment utility SYAF010 Information Line 2 NVARCHAR 120   50   —
SYAF Audit Trail File for Monetary restatment utility SYAF011 Information Line 3 NVARCHAR 120   50   —
SYB1 Tax Rule SYB1003 Administrative Unit NVARCHAR 2   1   —
SYB4 IOGS Report Types SYB4001 Report Code NCHAR 2   — — +
SYB4 IOGS Report Types SYB4002 Report Description NVARCHAR 50   — — +
SYB4 IOGS Report Types SYB4003 Language Code NCHAR 3   — — +
SYB5 IOGS Record Types SYB5001 Record Code NCHAR 3   — — +
SYB5 IOGS Record Types SYB5002 Record Description NVARCHAR 50   — — +
SYB5 IOGS Record Types SYB5003 Language Code NCHAR 3   — — +
SYB6 IOGS Field Types SYB6001 Record Code NCHAR 3   — — +
SYB6 IOGS Field Types SYB6002 Field Code NCHAR 3   — — +
SYB6 IOGS Field Types SYB6003 Field Description NVARCHAR 50   — — +
SYB6 IOGS Field Types SYB6004 Field Alias NVARCHAR 10   — — +
SYB6 IOGS Field Types SYB6005 Language Code NCHAR 3   — — +
SYB7 IOGS Record Structure SYB7001 Report Code NCHAR 2   — — +
SYB7 IOGS Record Structure SYB7002 Record Code NCHAR 3   — — +
SYB7 IOGS Record Structure SYB7003 Field Code NCHAR 3   — — +
SYB7 IOGS Record Structure SYB7004 Width NUMERIC 12   — — +
SYB7 IOGS Record Structure SYB7005 Separator NCHAR 1   — — +
SYB7 IOGS Record Structure SYB7006 Aligment NCHAR 1   — — +
SYB7 IOGS Record Structure SYB7007 Fill Character NCHAR 1   — — +
SYB7 IOGS Record Structure SYB7008 Line Sequence NUMERIC 4   — — +
SYB7 IOGS Record Structure SYB7009 Decimal NUMERIC 2   — — +
SYB7 IOGS Record Structure SYB7010 Data Type NVARCHAR 1   — — +
SYB7 IOGS Record Structure SYB7011 Hand Input NVARCHAR 20   — — +
SYB9 NCM Codes SYB9001 NCM Code NVARCHAR 25   10   —
SYB9 NCM Codes SYB9005 Purchase Tax Code NVARCHAR 6   — — +
SYB9 NCM Codes SYB9006 Service Flag NCHAR 1   — — +
SYB9 NCM Codes SYB9007 SalesFiscalTextCode NVARCHAR 10   — — +
SYB9 NCM Codes SYB9008 PurchaseFiscalTextCode NVARCHAR 10   — — +
SYBD DocumentFiscalText SYBD001 File Name NVARCHAR 4   — — +
SYBD DocumentFiscalText SYBD002 Key Value (Order Number) NVARCHAR 40   — — +
SYBD DocumentFiscalText SYBD003 Line Number NVARCHAR 6   — — +
SYBD DocumentFiscalText SYBD004 Code of Original Fiscal Text NVARCHAR 10   — — +
SYBD DocumentFiscalText SYBD005 Fiscal Text NVARCHAR 250   — — +
SYBE Business Event and Action SYBE001 Business Event NVARCHAR 100   — — +
SYBE Business Event and Action SYBE002 Action NVARCHAR 100   — — +
SYBJ Rule Rate SYBJ005 Product Tax Type NVARCHAR 10   — — +
SYBJ Rule Rate SYBJ006 Origin Code NCHAR 1   — — +
SYBJ Rule Rate SYBJ007 NCM code NVARCHAR 25   — — +
SYBK EDILayoutHeaders SYBK001 Layout Code NVARCHAR 10   — — +
SYBK EDILayoutHeaders SYBK002 Layout Description NVARCHAR 30   — — +
SYBK EDILayoutHeaders SYBK003 Column Delimiter NVARCHAR 10   — — +
SYBK EDILayoutHeaders SYBK004 Row Delimiter NVARCHAR 10   — — +
SYBK EDILayoutHeaders SYBK005 File Type NCHAR 1   — — +
SYBK EDILayoutHeaders SYBK006 Row Length INT 3   — — +
SYBK EDILayoutHeaders SYBK007 Spare NCHAR 1   — — +
SYBK EDILayoutHeaders SYBK008 File Number NVARCHAR 10   — — +
SYBK EDILayoutHeaders SYBK009 Date of Last Report DATETIME 8   — — +
SYBK EDILayoutHeaders SYBK010 File Number NVARCHAR 10   — — +
SYBM EDILayoutLines SYBM001 Layout Code NVARCHAR 10   — — +
SYBM EDILayoutLines SYBM002 Field Code NVARCHAR 10   — — +
SYBM EDILayoutLines SYBM003 Row Number NCHAR 4   — — +
SYBM EDILayoutLines SYBM004 Field Initial Position INT 4   — — +
SYBM EDILayoutLines SYBM005 Field Width INT 4   — — +
SYBM EDILayoutLines SYBM006 Decimal Separator NCHAR 1   — — +
SYBM EDILayoutLines SYBM007 Alignment Type NCHAR 1   — — +
SYBM EDILayoutLines SYBM008 Fill Character NCHAR 1   — — +
SYBM EDILayoutLines SYBM009 Fileld Sequence Number NCHAR 4   — — +
SYBM EDILayoutLines SYBM010 Decimals NCHAR 2   — — +
SYBM EDILayoutLines SYBM011 Row Type NCHAR 1   — — +
SYBM EDILayoutLines SYBM012 Optional Value NVARCHAR 40   — — +
SYBM EDILayoutLines SYBM013 Field Type NCHAR 1   — — +
SYBN OutputFileHeaders SYBN001 EDI Transaction Number NVARCHAR 10   — — +
SYBN OutputFileHeaders SYBN002 Bank Code NVARCHAR 10   — — +
SYBN OutputFileHeaders SYBN003 LayoutCode NVARCHAR 10   — — +
SYBN OutputFileHeaders SYBN004 Date of File Issue DATETIME 8   — — +
SYBN OutputFileHeaders SYBN005 Output File Name NVARCHAR 20   — — +
SYBN OutputFileHeaders SYBN006 Input File Name NVARCHAR 20   — — +
SYBN OutputFileHeaders SYBN007 Reception Date DATETIME 8   — — +
SYBN OutputFileHeaders SYBN008 Spare NVARCHAR 6   — — +
SYBN OutputFileHeaders SYBN009 File Path NVARCHAR 40   — — +
SYBN OutputFileHeaders SYBN010 Accounting String for Bank NVARCHAR 120   — — +
SYBO OutputFileLines SYBO001 EDI Transaction Number NVARCHAR 10   — — +
SYBO OutputFileLines SYBO002 Invoice Number NVARCHAR 25   — — +
SYBO OutputFileLines SYBO003 Processed Amount NUMERIC 20 8 — — +
SYBO OutputFileLines SYBO004 Event Code NVARCHAR 2   — — +
SYBO OutputFileLines SYBO005 Cause Code NVARCHAR 2   — — +
SYBO OutputFileLines SYBO006 Bank Reference NVARCHAR 15   — — +
SYBO OutputFileLines SYBO007 Record Status NCHAR 1   — — +
SYBO OutputFileLines SYBO008 Due Date DATETIME 8   — — +
SYBO OutputFileLines SYBO009 Customer Code NVARCHAR 15   — — +
SYBO OutputFileLines SYBO010 Changed Amount NUMERIC 20 8 — — +
SYBO OutputFileLines SYBO011 Changed Due Date DATETIME 8   — — +
SYBO OutputFileLines SYBO012 Interest Amount NUMERIC 20 8 — — +
SYBQ EDISysFields SYBQ001 Field Code NVARCHAR 10   — — +
SYBQ EDISysFields SYBQ002 Field Description NVARCHAR 30   — — +
SYBQ EDISysFields SYBQ003 Table Name NVARCHAR 10   — — +
SYBQ EDISysFields SYBQ004 Column Name NVARCHAR 10   — — +
SYBQ EDISysFields SYBQ005 Collection Flag NCHAR 1   — — +
SYBQ EDISysFields SYBQ006 Main Table NVARCHAR 30   — — +
SYBQ EDISysFields SYBQ007 SQL Statement NVARCHAR 150   — — +
SYBQ EDISysFields SYBQ008 Optional Flag NCHAR 1   — — +
SYBT EDIEvents SYBT001 Bank Code NVARCHAR 10   — — +
SYBT EDIEvents SYBT002 Event Code NVARCHAR 2   — — +
SYBT EDIEvents SYBT003 Cause Code NVARCHAR 2   — — +
SYBT EDIEvents SYBT004 Cause Descriprion NVARCHAR 80   — — +
SYBT EDIEvents SYBT005 Acceptance Flag NCHAR 1   — — +
SYBU EDI Bank Information SYBU001 Bank Code NVARCHAR 10   — — +
SYBU EDI Bank Information SYBU002 Output Code NVARCHAR 10   — — +
SYBU EDI Bank Information SYBU003 Input Code NVARCHAR 10   — — +
SYBU EDI Bank Information SYBU004 Max Records INT 4   — — +
SYBU EDI Bank Information SYBU005 Accounting String NVARCHAR 120   — — +
SYBY Margin SYBY007 Allowed Price Difference % NUMERIC 7 8 20 8 —
SYCD Currency Dictionary SYCD013 CurrReportCode NCHAR 6   — — +
SYCH Currency History SYCH016 Min Coin NUMERIC 8 8 — — +
SYD0 Document image header SYD0001 Document Type, 14 for Invoice/Credit note NCHAR 2   — — +
SYD0 Document image header SYD0002 Invoice/credit note number NCHAR 20   — — +
SYD0 Document image header SYD0003 Last reprinted date DATETIME 8   — — +
SYD0 Document image header SYD0004 Last reprinted user NCHAR 8   — — +
SYD0 Document image header SYD0005 Created from pgm NCHAR 20   — — +
SYD0 Document image header SYD0006 Status 0 = printed, 1 = order closed NCHAR 1   — — +
SYD1 Document image lines SYD1001 Document Type NCHAR 2   — — +
SYD1 Document image lines SYD1002 Invoice/credit note number NCHAR 20   — — +
SYD1 Document image lines SYD1003 Line Number NUMERIC 6   — — +
SYD1 Document image lines SYD1004 Line Type 0 = line to print, 1 = page break NCHAR 1   — — +
SYD1 Document image lines SYD1005 The line printed NVARCHAR 256   — — +
SYD1 Document image lines SYD1006 Split part NUMERIC 2   — — +
SYDL Signed document lines SYDL001 Document Type NCHAR 2   — — +
SYDL Signed document lines SYDL002 Fiscal Year INT 4   — — +
SYDL Signed document lines SYDL003 Document Number NCHAR 60   — — +
SYDL Signed document lines SYDL004 Line NCHAR 6   — — +
SYDL Signed document lines SYDL005 SubLine NCHAR 6   — — +
SYDL Signed document lines SYDL006 Description NVARCHAR 60   — — +
SYDL Signed document lines SYDL007 Quantity NUMERIC 12 8 — — +
SYDL Signed document lines SYDL008 Unit Code INT 4   — — +
SYDL Signed document lines SYDL009 Line Type INT 1   — — +
SYDL Signed document lines SYDL010 Stock Code NVARCHAR 35   — — +
SYDL Signed document lines SYDL011 Product Description NVARCHAR 25   — — +
SYDL Signed document lines SYDL012 Currency Code OCU INT 2   — — +
SYDL Signed document lines SYDL013 Unit Price LCU NUMERIC 20 8 — — +
SYDL Signed document lines SYDL014 Unit Price OCU NUMERIC 20 8 — — +
SYDL Signed document lines SYDL015 Debit/Credit Amount LCU NUMERIC 20 8 — — +
SYDL Signed document lines SYDL016 Debit/Credit Amount OCU NUMERIC 20 8 — — +
SYDL Signed document lines SYDL017 Tax Type NCHAR 3   — — +
SYDL Signed document lines SYDL018 Tax Country Region NVARCHAR 10   — — +
SYDL Signed document lines SYDL019 Tax Code NVARCHAR 6   — — +
SYDL Signed document lines SYDL020 Tax Percentage NUMERIC 6 8 — — +
SYDL Signed document lines SYDL021 Exemption Reason NVARCHAR 60   — — +
SYDL Signed document lines SYDL022 Settlement Amount LCU NUMERIC 20 8 — — +
SYDL Signed document lines SYDL023 Settlement Amount OCU NUMERIC 20 8 — — +
SYDN Signed Document SYDN001 Document Type NCHAR 2   — — +
SYDN Signed Document SYDN002 Fiscal Year INT 4   — — +
SYDN Signed Document SYDN003 Document Number NCHAR 60   — — +
SYDN Signed Document SYDN004 Module NCHAR 2   — — +
SYDN Signed Document SYDN005 Type INT 1   — — +
SYDN Signed Document SYDN006 Status INT 2   — — +
SYDN Signed Document SYDN007 Document Issuer NVARCHAR 6   — — +
SYDN Signed Document SYDN008 Customer/Supplier Code NVARCHAR 10   — — +
SYDN Signed Document SYDN009 Status Date/Time DATETIME 17   — — +
SYDN Signed Document SYDN010 Move Status NCHAR 1   — — +
SYDN Signed Document SYDN011 User – last status change NVARCHAR 8   — — +
SYDN Signed Document SYDN012 Digital Signature NVARCHAR 200   — — +
SYDN Signed Document SYDN013 Serial Number of Key NVARCHAR 100   — — +
SYDN Signed Document SYDN014 Original String NVARCHAR 300   — — +
SYDN Signed Document SYDN015 Document Creation Date and Time DATETIME 17   — — +
SYDN Signed Document SYDN016 System Date/Time DATETIME 17   — — +
SYDN Signed Document SYDN017 Movement Start date/time DATETIME 17   — — +
SYDN Signed Document SYDN018 Movement End date/time DATETIME 17   — — +
SYDN Signed Document SYDN019 User – document created by NVARCHAR 8   — — +
SYDN Signed Document SYDN020 Movement Type NCHAR 2   — — +
SYDN Signed Document SYDN021 Order Number NVARCHAR 10   — — +
SYDN Signed Document SYDN022 Sequence Number INT 7   — — +
SYDN Signed Document SYDN023 Identification Code NVARCHAR 200   — — +
SYDN Signed Document SYDN024 Message for reject NVARCHAR 200   — — +
SYDN Signed Document SYDN025 Ship To-Address 1 NVARCHAR 35   — — +
SYDN Signed Document SYDN026 Ship To-Address 2 NVARCHAR 35   — — +
SYDN Signed Document SYDN027 Ship To-Address 3 NVARCHAR 35   — — +
SYDN Signed Document SYDN028 Ship To-Address 4 NVARCHAR 35   — — +
SYDN Signed Document SYDN029 Ship To-Address 5 NVARCHAR 35   — — +
SYDN Signed Document SYDN030 Ship To-Address 6 NVARCHAR 35   — — +
SYDN Signed Document SYDN031 Ship To-Address 7 NVARCHAR 35   — — +
SYDN Signed Document SYDN032 Ship To-ZIP code NVARCHAR 10   — — +
SYDN Signed Document SYDN033 Ship To-City Code NVARCHAR 10   — — +
SYDN Signed Document SYDN034 Ship To-Country Code NCHAR 3   — — +
SYDN Signed Document SYDN035 Ship From-Address 1 NVARCHAR 35   — — +
SYDN Signed Document SYDN036 Ship From-Address 2 NVARCHAR 35   — — +
SYDN Signed Document SYDN037 Ship From-Address 3 NVARCHAR 35   — — +
SYDN Signed Document SYDN038 Ship From-Address 4 NVARCHAR 35   — — +
SYDN Signed Document SYDN039 Ship From-Address 5 NVARCHAR 35   — — +
SYDN Signed Document SYDN040 Ship From-Address 6 NVARCHAR 35   — — +
SYDN Signed Document SYDN041 Ship From-Address 7 NVARCHAR 35   — — +
SYDN Signed Document SYDN042 Ship From-ZIP code NVARCHAR 10   — — +
SYDN Signed Document SYDN043 Ship From-City Code NVARCHAR 10   — — +
SYDN Signed Document SYDN044 Ship From-Country Code NCHAR 3   — — +
SYDN Signed Document SYDN045 Invoice Number NVARCHAR 25   — — +
SYDN Signed Document SYDN046 Reason NVARCHAR 50   — — +
SYDN Signed Document SYDN047 Period INT 2   — — +
SYDN Signed Document SYDN048 Transaction ID NVARCHAR 70   — — +
SYDN Signed Document SYDN049 Currency Code OCU INT 2   — — +
SYDN Signed Document SYDN050 Tax Payable LCU NUMERIC 20 8 — — +
SYDN Signed Document SYDN051 Tax Payable OCU NUMERIC 20 8 — — +
SYDN Signed Document SYDN052 Net Total LCU NUMERIC 20 8 — — +
SYDN Signed Document SYDN053 Net Total OCU NUMERIC 20 8 — — +
SYDN Signed Document SYDN054 Gross Total LCU NUMERIC 20 8 — — +
SYDN Signed Document SYDN055 Gross Total OCU NUMERIC 20 8 — — +
SYDS Signed Document Serial Number SYDS001 DocType NCHAR 2   — — +
SYDS Signed Document Serial Number SYDS002 Fiscal Year INT 4   — — +
SYDS Signed Document Serial Number SYDS003 Document Number NVARCHAR 60   — — +
SYDS Signed Document Serial Number SYDS004 Line NCHAR 6   — — +
SYDS Signed Document Serial Number SYDS005 Sub Line NCHAR 6   — — +
SYDS Signed Document Serial Number SYDS006 Serial No Line NCHAR 6   — — +
SYDS Signed Document Serial Number SYDS007 Serial No NVARCHAR 70   — — +
SYDS Signed Document Serial Number SYDS008 Text Line NCHAR 6   — — +
SYEI Excel Import Definition SYEI001 Object Type NCHAR 4   — — +
SYEI Excel Import Definition SYEI002 Import Specification ID NVARCHAR 35   — — +
SYEI Excel Import Definition SYEI003 Excel Import Specification NVARCHAR(MAX) 5000   — — +
SYEI Excel Import Definition SYEI004 Direct Usage from Excel Import NCHAR 1   — — +
SYES Dynamic email setup SYES001 Document ID INT 2   — — +
SYES Dynamic email setup SYES002 Source TO INT 2   — — +
SYES Dynamic email setup SYES003 Source CC INT 2   — — +
SYES Dynamic email setup SYES004 Source BCC INT 2   — — +
SYES Dynamic email setup SYES005 Apply Blank TO NVARCHAR 1   — — +
SYES Dynamic email setup SYES006 Apply Blank CC NVARCHAR 1   — — +
SYES Dynamic email setup SYES007 Apply Blank BCC NVARCHAR 1   — — +
SYES Dynamic email setup SYES008 Source From INT 1   — — +
SYES Dynamic email setup SYES009 Email Address NVARCHAR 100   — — +
SYES Dynamic email setup SYES010 TO address NVARCHAR 200   — — +
SYES Dynamic email setup SYES011 CC address NVARCHAR 200   — — +
SYES Dynamic email setup SYES012 BCC address NVARCHAR 200   — — +
SYES Dynamic email setup SYES013 Option for direct print INT 1   — — +
SYET Entry Types SYET001 Module ID (12-SM,19-CM) INT 3   — — +
SYET Entry Types SYET002 Entry Type Code NCHAR 3   — — +
SYET Entry Types SYET003 Entry Type Description NVARCHAR 100   — — +
SYET Entry Types SYET004 Header Layout Code NVARCHAR 50   — — +
SYET Entry Types SYET005 Line Layout Code NVARCHAR 50   — — +
SYET Entry Types SYET006 Tool Bar Code NVARCHAR 50   — — +
SYET Entry Types SYET007 Action on OK click INT 4   — — +
SYET Entry Types SYET008 Contract Nature NCHAR 1   — — +
SYET Entry Types SYET009 Default Contract/Order Type NCHAR 6   — — +
SYFH View Audit History Filter Header SYFH001 Filter Code NVARCHAR 50   — — +
SYFH View Audit History Filter Header SYFH002 Filter Description NVARCHAR 70   — — +
SYFL View Audit History Filter Fields SYFL001 Filter Code NVARCHAR 50   — — +
SYFL View Audit History Filter Fields SYFL002 Table Prefix NVARCHAR 128   — — +
SYFL View Audit History Filter Fields SYFL003 Field Name NVARCHAR 128   — — +
SYFT View Audit History Filter Tables SYFT001 Filter Code NVARCHAR 50   — — +
SYFT View Audit History Filter Tables SYFT002 Table Prefix NVARCHAR 128   — — +
SYFT View Audit History Filter Tables SYFT003 Operation Type NCHAR 3   — — +
SYFT View Audit History Filter Tables SYFT004 All Fields NCHAR 1   — — +
SYH1 Approval Group SYH1001 Group ID NCHAR 8   — — +
SYH1 Approval Group SYH1002 Group Name NVARCHAR 50   — — +
SYH1 Approval Group SYH1003 Parent Group ID NCHAR 8   — — +
SYH1 Approval Group SYH1004 Group Level INT 1   — — +
SYH1 Approval Group SYH1005 Bypass approval NCHAR 1   — — +
SYH2 User Approval Group SYH2001 Group ID NCHAR 8   — — +
SYH2 User Approval Group SYH2002 User Alias NCHAR 8   — — +
SYH2 User Approval Group SYH2003 Active INT 1   — — +
SYH3 Approval Journal SYH3001 Request Type NCHAR 2   — — +
SYH3 Approval Journal SYH3002 Request ID NCHAR 35   — — +
SYH3 Approval Journal SYH3003 Line No NCHAR 6   — — +
SYH3 Approval Journal SYH3004 Approval Group ID NCHAR 8   — — +
SYH3 Approval Journal SYH3005 Assign Datetime DATETIME 17   — — +
SYH3 Approval Journal SYH3006 Notification Datetime DATETIME 17   — — +
SYH3 Approval Journal SYH3007 Approver NCHAR 8   — — +
SYH3 Approval Journal SYH3008 Result INT 1   — — +
SYH3 Approval Journal SYH3009 Result Comment NVARCHAR 100   — — +
SYH3 Approval Journal SYH3010 Result Datetime DATETIME 17   — — +
SYH3 Approval Journal SYH3011 Requester User Alias NVARCHAR 8   — — +
SYH3 Approval Journal SYH3012 Auto cancelled INT 1   — — +
SYH3 Approval Journal SYH3013 Credit status INT 2   — — +
SYH3 Approval Journal SYH3014 Approved Amount NUMERIC 20 8 — — +
SYH3 Approval Journal SYH3015 Approval process INT 1   — — +
SYH3 Approval Journal SYH3016 Original Request ID NVARCHAR 35   — — +
SYH3 Approval Journal SYH3017 Request Comment NVARCHAR 100   — — +
SYHH Approval template header SYHH001 Template ID NCHAR 4   — — +
SYHH Approval template header SYHH002 Description NVARCHAR 50   — — +
SYHH Approval template header SYHH003 Horizontal Scroll NCHAR 1   — — +
SYHH Approval template header SYHH004 Frozen Columns INT 2   — — +
SYHH Approval template header SYHH005 Request Types NVARCHAR 20   — — +
SYHH Approval template header SYHH006 Property 1 NCHAR 1   — — +
SYHH Approval template header SYHH007 Property 2 NCHAR 1   — — +
SYHH Approval template header SYHH008 Property 3 NCHAR 1   — — +
SYHH Approval template header SYHH009 Property 4 NCHAR 1   — — +
SYHH Approval template header SYHH010 Property 5 NCHAR 1   — — +
SYHH Approval template header SYHH011 Property 6 NCHAR 1   — — +
SYHH Approval template header SYHH012 Foreground RW INT 10   — — +
SYHH Approval template header SYHH013 Background RW INT 10   — — +
SYHH Approval template header SYHH014 Foreground RO INT 10   — — +
SYHH Approval template header SYHH015 Background RO INT 10   — — +
SYHH Approval template header SYHH016 Foreground RO+C INT 10   — — +
SYHH Approval template header SYHH017 Background RO+C INT 10   — — +
SYHH Approval template header SYHH018 Foreground Locked INT 10   — — +
SYHH Approval template header SYHH019 Background Locked INT 10   — — +
SYHH Approval template header SYHH020 Foreground Null INT 10   — — +
SYHH Approval template header SYHH021 Background Null INT 10   — — +
SYHL Approval template line SYHL001 Template ID NCHAR 4   — — +
SYHL Approval template line SYHL002 Column INT 3   — — +
SYHL Approval template line SYHL003 Field set NCHAR 4   — — +
SYHL Approval template line SYHL004 Field Number INT 4   — — +
SYHL Approval template line SYHL005 Property 1 NCHAR 1   — — +
SYHL Approval template line SYHL006 Property 2 NCHAR 1   — — +
SYHL Approval template line SYHL007 Property 3 NCHAR 1   — — +
SYHL Approval template line SYHL008 Property 4 NCHAR 1   — — +
SYHL Approval template line SYHL009 Property 5 NCHAR 1   — — +
SYHL Approval template line SYHL010 Property 6 NCHAR 1   — — +
SYIC Invoice Consolidation Criteria Fields SYIC001 Target Invoice INT 1   — — +
SYIC Invoice Consolidation Criteria Fields SYIC002 Consolidation Key Field NVARCHAR 7   — — +
SYIC Invoice Consolidation Criteria Fields SYIC003 Sort Order INT 3   — — +
SYIF Invoice Consolidation Common Value Fields SYIF001 Target Invoice INT 1   — — +
SYIF Invoice Consolidation Common Value Fields SYIF002 Common Value Field NVARCHAR 7   — — +
SYIF Invoice Consolidation Common Value Fields SYIF003 Selection Field NVARCHAR 7   — — +
SYIF Invoice Consolidation Common Value Fields SYIF004 Condition NCHAR 1   — — +
SYIJ Invoicing jobs interconnection table SYIJ001 Session ID NVARCHAR 42   — — +
SYIJ Invoicing jobs interconnection table SYIJ002 Record Type INT 1   — — +
SYIJ Invoicing jobs interconnection table SYIJ003 Status INT 1   — — +
SYIJ Invoicing jobs interconnection table SYIJ004 Work Item Type INT 2   — — +
SYIJ Invoicing jobs interconnection table SYIJ005 Work Item ID NVARCHAR 50   — — +
SYIJ Invoicing jobs interconnection table SYIJ006 Time Stamp DATETIME 17   — — +
SYIJ Invoicing jobs interconnection table SYIJ007 Message NVARCHAR 250   — — +
SYIJ Invoicing jobs interconnection table SYIJ008 GUID NVARCHAR 38   — — +
SYL1 Tax Types SYL1012 JurisdCode NVARCHAR 6   1   —
SYL1 Tax Types SYL1019 TaxPayer NVARCHAR 1   8 8 —
SYL1 Tax Types SYL1021 Tax included in Invoice Total NVARCHAR 1   — — +
SYL1 Tax Types SYL1022 Price Included Tax NVARCHAR 1   — — +
SYL1 Tax Types SYL1023 Spare NVARCHAR 6   — — +
SYL1 Tax Types SYL1024 Spare NVARCHAR 6   — — +
SYL2 Tax Liability SYL2004 Accounting Code Tax NCHAR 2   1   —
SYL8 Document Issuer SYL8002 Issuer Code NCHAR 6   4   —
SYL8 Document Issuer SYL8011 City Code NCHAR 10   3   —
SYL8 Document Issuer SYL8036 Invoice Serial Code NVARCHAR 10   — — +
SYL8 Document Issuer SYL8037 Prefix Type NCHAR 1   — — +
SYL8 Document Issuer SYL8038 Delimiter NCHAR 1   — — +
SYL8 Document Issuer SYL8039 Counter Reference TaxNote Category A NCHAR 2   — — +
SYL8 Document Issuer SYL8040 Counter Reference TaxNote Category B NCHAR 2   — — +
SYL8 Document Issuer SYL8041 Counter Reference TaxNote Category C NCHAR 2   — — +
SYL8 Document Issuer SYL8042 Counter Reference TaxNote Category E NCHAR 2   — — +
SYL8 Document Issuer SYL8043 Counter Reference TaxNote Category Z NCHAR 2   — — +
SYL8 Document Issuer SYL8044 Issuer Description NCHAR 40   — — +
SYL8 Document Issuer SYL8045 Prefix NCHAR 8   — — +
SYL8 Document Issuer SYL8046 Authorization Date DATETIME 8   — — +
SYL8 Document Issuer SYL8047 Authorization No NVARCHAR 20   — — +
SYL8 Document Issuer SYL8048 ApplyOtherWareh NCHAR 1   — — +
SYL8 Document Issuer SYL8049 UseSuffix NCHAR 1   — — +
SYL8 Document Issuer SYL8050 Address Line 4 NVARCHAR 35   — — +
SYL8 Document Issuer SYL8051 Address Line 5 NVARCHAR 35   — — +
SYL8 Document Issuer SYL8052 Address Line 6 NVARCHAR 35   — — +
SYL8 Document Issuer SYL8053 Address Line 7 NVARCHAR 35   — — +
SYL8 Document Issuer SYL8054 Country Code NVARCHAR 3   — — +
SYLK Attachment Storage Links SYLK001 Object Code NCHAR 4   — — +
SYLK Attachment Storage Links SYLK002 Object Number NVARCHAR 50   — — +
SYLK Attachment Storage Links SYLK003 Documentation Link NVARCHAR 1800   — — +
SYM1 Code Map SYM1001 Map ID INT 4   — — +
SYM1 Code Map SYM1002 Map Type INT 2   — — +
SYM1 Code Map SYM1003 Map Description NVARCHAR 35   — — +
SYM2 Mapping SYM2001 Map ID INT 4   — — +
SYM2 Mapping SYM2002 Internal Code NVARCHAR 35   — — +
SYM2 Mapping SYM2003 External Code NVARCHAR 35   — — +
SYNT Report Naming Template Table SYNT001 Document ID INT 2   — — +
SYNT Report Naming Template Table SYNT002 Name Template NVARCHAR 200   — — +
SYNT Report Naming Template Table SYNT003 Path Template NVARCHAR 200   — — +
SYPC PAC Certification data SYPC001 Customer Code NCHAR 10   — — +
SYPC PAC Certification data SYPC002 Invoice Number NCHAR 25   — — +
SYPC PAC Certification data SYPC003 Version NVARCHAR 4   — — +
SYPC PAC Certification data SYPC004 External ID NVARCHAR 50   — — +
SYPC PAC Certification data SYPC005 Certification Time DATETIME 17   — — +
SYPC PAC Certification data SYPC006 Seal CFD NVARCHAR 256   — — +
SYPC PAC Certification data SYPC007 Certification Number NVARCHAR 256   — — +
SYPC PAC Certification data SYPC008 Seal SAT NVARCHAR 256   — — +
SYPF Print Queue Filters SYPF001 Filter Name NVARCHAR 50   — — +
SYPF Print Queue Filters SYPF002 Filter Description NVARCHAR 150   — — +
SYPF Print Queue Filters SYPF003 Filter Body NVARCHAR 4000   — — +
SYPQ Print Job Queue Table SYPQ001 Priority NVARCHAR 4   — — +
SYPQ Print Job Queue Table SYPQ002 Counter NVARCHAR 10   — — +
SYPQ Print Job Queue Table SYPQ003 Date and Time of Creation DATETIME 17   — — +
SYPQ Print Job Queue Table SYPQ004 User ID NVARCHAR 8   — — +
SYPQ Print Job Queue Table SYPQ005 Document ID INT 3   — — +
SYPQ Print Job Queue Table SYPQ006 Output Channel NVARCHAR 255   — — +
SYPQ Print Job Queue Table SYPQ007 Comment NVARCHAR 255   — — +
SYPQ Print Job Queue Table SYPQ008 Status INT 1   — — +
SYPQ Print Job Queue Table SYPQ009 Scheduled NCHAR 1   — — +
SYPQ Print Job Queue Table SYPQ010 Parameters NVARCHAR 4000   — — +
SYPQ Print Job Queue Table SYPQ011 Result NVARCHAR 4000   — — +
SYPQ Print Job Queue Table SYPQ012 Job Request ID NVARCHAR 36   — — +
SYPQ Print Job Queue Table SYPQ013 Status DateTime DATETIME 17   — — +
SYPQ Print Job Queue Table SYPQ014 Parent Counter NVARCHAR 10   — — +
SYPQ Print Job Queue Table SYPQ015 Resulting Message Group ID NVARCHAR 42   — — +
SYPU Purchaser File SYPU002 Accounting String NVARCHAR 120   50   —
SYPU Purchaser File SYPU003 Email Address NVARCHAR 200   — — +
SYR0 Business Rule Certificate Assignment SYR0001 Business Rule No NVARCHAR 10   — — +
SYR0 Business Rule Certificate Assignment SYR0002 Certificate No NVARCHAR 10   — — +
SYR0 Business Rule Certificate Assignment SYR0003 Activity NCHAR 1   — — +
SYR0 Business Rule Certificate Assignment SYR0004 Order No NCHAR 10   — — +
SYR0 Business Rule Certificate Assignment SYR0005 Line Number NCHAR 6   — — +
SYR0 Business Rule Certificate Assignment SYR0006 Sub Line Number NCHAR 6   — — +
SYR0 Business Rule Certificate Assignment SYR0007 Assigned By NCHAR 8   — — +
SYR0 Business Rule Certificate Assignment SYR0008 Certificate Ctrl Date DATETIME 8   — — +
SYR0 Business Rule Certificate Assignment SYR0009 Business Partner NVARCHAR 10   — — +
SYR0 Business Rule Certificate Assignment SYR0010 Country Code NVARCHAR 3   — — +
SYR0 Business Rule Certificate Assignment SYR0011 Stock Item Code NVARCHAR 35   — — +
SYR4 Transaction Control Parameters SYR4001 Year_Key NCHAR 2   — — +
SYR4 Transaction Control Parameters SYR4002 Certificate Counter NVARCHAR 10   — — +
SYR4 Transaction Control Parameters SYR4003 Check new Business Rules NCHAR 1   — — +
SYR4 Transaction Control Parameters SYR4004 Transaction Control Date NCHAR 1   — — +
SYR4 Transaction Control Parameters SYR4005 Quotations Control NCHAR 1   — — +
SYR5 Control Classes SYR5001 Classifier Code NVARCHAR 15   — — +
SYR5 Control Classes SYR5002 Classifier Type INT 1   — — +
SYR5 Control Classes SYR5003 Classifier Object NVARCHAR 35   — — +
SYR6 Business Rule Certificate SYR6001 Certificate Number NVARCHAR 10   — — +
SYR6 Business Rule Certificate SYR6002 Business Rule No NVARCHAR 10   — — +
SYR6 Business Rule Certificate SYR6003 Certificate Type NCHAR 1   — — +
SYR6 Business Rule Certificate SYR6004 External Code NVARCHAR 50   — — +
SYR6 Business Rule Certificate SYR6005 Name NVARCHAR 100   — — +
SYR6 Business Rule Certificate SYR6006 Source NVARCHAR 50   — — +
SYR6 Business Rule Certificate SYR6007 Confirmed by NVARCHAR 50   — — +
SYR6 Business Rule Certificate SYR6008 Entry Date DATETIME 8   — — +
SYR6 Business Rule Certificate SYR6009 Valid. Start Date DATETIME 8   — — +
SYR6 Business Rule Certificate SYR6010 Valid. Finish Date DATETIME 8   — — +
SYR6 Business Rule Certificate SYR6011 Activity NCHAR 1   — — +
SYR6 Business Rule Certificate SYR6012 Stock Item Code NVARCHAR 35   — — +
SYR6 Business Rule Certificate SYR6013 Stock Item Family NVARCHAR 35   — — +
SYR6 Business Rule Certificate SYR6014 Stock Item Classifier NVARCHAR 15   — — +
SYR6 Business Rule Certificate SYR6015 Business Partner NVARCHAR 10   — — +
SYR6 Business Rule Certificate SYR6016 Business Partner Classifier NVARCHAR 15   — — +
SYR6 Business Rule Certificate SYR6017 Country Code NVARCHAR 3   — — +
SYR6 Business Rule Certificate SYR6018 Country Code Classifier NVARCHAR 15   — — +
SYR6 Business Rule Certificate SYR6019 Document No NVARCHAR 10   — — +
SYR6 Business Rule Certificate SYR6020 Single Delivery NCHAR 1   — — +
SYR6 Business Rule Certificate SYR6021 Delivery Method NCHAR 2   — — +
SYR6 Business Rule Certificate SYR6022 Qty Licensed NUMERIC 12 8 — — +
SYR6 Business Rule Certificate SYR6023 Qty Reserved NUMERIC 12 8 — — +
SYR6 Business Rule Certificate SYR6024 Qty Consumed NUMERIC 12 8 — — +
SYR6 Business Rule Certificate SYR6025 Weight Licensed NUMERIC 10 8 — — +
SYR6 Business Rule Certificate SYR6026 Weight Reserved NUMERIC 10 8 — — +
SYR6 Business Rule Certificate SYR6027 Weight Consumed NUMERIC 10 8 — — +
SYR6 Business Rule Certificate SYR6028 Volume Licensed NUMERIC 10 8 — — +
SYR6 Business Rule Certificate SYR6029 Volume Reserved NUMERIC 10 8 — — +
SYR6 Business Rule Certificate SYR6030 Volume Consumed NUMERIC 10 8 — — +
SYR6 Business Rule Certificate SYR6031 Status NCHAR 1   — — +
SYR7 Business Rules SYR7001 Business Rule No NVARCHAR 10   — — +
SYR7 Business Rules SYR7002 Name NVARCHAR 100   — — +
SYR7 Business Rules SYR7003 Entry Date DATETIME 8   — — +
SYR7 Business Rules SYR7004 Valid. Start Date DATETIME 8   — — +
SYR7 Business Rules SYR7005 Valid. Finish Date DATETIME 8   — — +
SYR7 Business Rules SYR7006 Activity NCHAR 1   — — +
SYR7 Business Rules SYR7007 Stock Item Code NVARCHAR 35   — — +
SYR7 Business Rules SYR7008 Stock Item Family NVARCHAR 35   — — +
SYR7 Business Rules SYR7009 Stock Item Classifier NVARCHAR 15   — — +
SYR7 Business Rules SYR7010 Business Partner NVARCHAR 10   — — +
SYR7 Business Rules SYR7011 Business Partner Classifier NVARCHAR 15   — — +
SYR7 Business Rules SYR7012 Country Code NVARCHAR 3   — — +
SYR7 Business Rules SYR7013 Country Code Classifier NVARCHAR 15   — — +
SYR7 Business Rules SYR7014 Min Allowed Qty NUMERIC 12 8 — — +
SYR7 Business Rules SYR7015 Min Allowed Weight NUMERIC 12 8 — — +
SYR7 Business Rules SYR7016 Min Allowed Volume NUMERIC 12 8 — — +
SYR7 Business Rules SYR7017 Notify Authorities NCHAR 1   — — +
SYR7 Business Rules SYR7018 User Notification NCHAR 1   — — +
SYR7 Business Rules SYR7019 Restriction Action NCHAR 1   — — +
SYR7 Business Rules SYR7020 Certificate UDF Template NVARCHAR 10   — — +
SYR8 Business Rule Certificate UDFs SYR8001 Certificate No NVARCHAR 10   — — +
SYR8 Business Rule Certificate UDFs SYR8002 Language Code NCHAR 3   — — +
SYR8 Business Rule Certificate UDFs SYR8003 User Def. Field No INT 2   — — +
SYR8 Business Rule Certificate UDFs SYR8004 User Def. Field Value NVARCHAR 100   — — +
SYR9 Business Rules Descriptions SYR9001 Business Rule No NVARCHAR 10   — — +
SYR9 Business Rules Descriptions SYR9002 Language Code NCHAR 3   — — +
SYR9 Business Rules Descriptions SYR9003 Description NVARCHAR 100   — — +
SYR9 Business Rules Descriptions SYR9004 User Notification Msg NVARCHAR 35   — — +
SYRA Business Rule Certificate UDF Template SYRA001 Template No NVARCHAR 10   — — +
SYRA Business Rule Certificate UDF Template SYRA002 Description NVARCHAR 50   — — +
SYRB Business Rule Certificate UDF Structure SYRB001 Template No NVARCHAR 10   — — +
SYRB Business Rule Certificate UDF Structure SYRB002 Row No NVARCHAR 10   — — +
SYRB Business Rule Certificate UDF Structure SYRB003 Row Length INT 3   — — +
SYRC Business Rule Certificate UDF Captions SYRC001 Template No NVARCHAR 10   — — +
SYRC Business Rule Certificate UDF Captions SYRC002 Language Code NCHAR 3   — — +
SYRC Business Rule Certificate UDF Captions SYRC003 Row No NVARCHAR 10   — — +
SYRC Business Rule Certificate UDF Captions SYRC004 Caption NVARCHAR 100   — — +
SYRC Business Rule Certificate UDF Captions SYRC005 Query Set Id NCHAR 4   — — +
SYS3 Selection Form Template SYS3001 ProgID NVARCHAR 255   — — +
SYS3 Selection Form Template SYS3002 Template No NCHAR 3   — — +
SYS3 Selection Form Template SYS3003 Name NVARCHAR 255   — — +
SYS3 Selection Form Template SYS3004 Value NVARCHAR 255   — — +
SYS3 Selection Form Template SYS3005 Type INT 1   — — +
SYSM Report 347 format parameters SYSM001 Finansial Year NVARCHAR 4   — — +
SYSM Report 347 format parameters SYSM002 IDFiscal NCHAR 9   — — +
SYSM Report 347 format parameters SYSM003 Name NVARCHAR 40   — — +
SYSM Report 347 format parameters SYSM004 Initial NVARCHAR 2   — — +
SYSM Report 347 format parameters SYSM005 Address NVARCHAR 40   — — +
SYSM Report 347 format parameters SYSM006 Number NVARCHAR 5   — — +
SYSM Report 347 format parameters SYSM007 Ladder NVARCHAR 2   — — +
SYSM Report 347 format parameters SYSM008 Floor NVARCHAR 2   — — +
SYSM Report 347 format parameters SYSM009 Door NVARCHAR 2   — — +
SYSM Report 347 format parameters SYSM010 Zip Code NVARCHAR 5   — — +
SYSM Report 347 format parameters SYSM011 Municipality NVARCHAR 35   — — +
SYSM Report 347 format parameters SYSM012 Province Code NVARCHAR 2   — — +
SYSM Report 347 format parameters SYSM013 Type Support NVARCHAR 1   — — +
SYSM Report 347 format parameters SYSM014 Telephone NVARCHAR 9   — — +
SYSM Report 347 format parameters SYSM015 Person Contact NVARCHAR 40   — — +
SYSM Report 347 format parameters SYSM016 Number Voucher Current NVARCHAR 13   — — +
SYSM Report 347 format parameters SYSM017 Complementary Voucher NVARCHAR 1   — — +
SYSM Report 347 format parameters SYSM018 Substitute Voucher NVARCHAR 1   — — +
SYSM Report 347 format parameters SYSM019 Number Voucher Previous NVARCHAR 13   — — +
SYSM Report 347 format parameters SYSM020 StatusCodeTax (00 to 09) Cust NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM021 StatusCodeTax (10 to 19) Cust NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM022 StatusCodeTax (20 to 29) Cust NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM023 StatusCodeTax (30 to 39) Cust NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM024 StatusCodeTax (40 to 49) Cust NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM025 StatusCodeTax (50 to 59) Cust NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM026 StatusCodeTax (60 to 69)Cust NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM027 StatusCodeTax (70 to 79) Cust NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM028 StatusCodeTax (80 to 89) Cust NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM029 StatusCodeTax (90 to 99) Cust NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM030 StatusCodeTax (00 to 09) Sup NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM031 StatusCodeTax (10 to 19) Sup NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM032 StatusCodeTax (20 to 29) Sup NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM033 StatusCodeTax (30 to 39) Sup NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM034 StatusCodeTax (40 to 49) Sup NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM035 StatusCodeTax (50 to 59) Sup NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM036 StatusCodeTax (60 to 69) Sup NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM037 StatusCodeTax (70 to 79) Sup NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM038 StatusCodeTax (80 to 89) Sup NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM039 StatusCodeTax (90 to 99) Sup NVARCHAR 10   — — +
SYSM Report 347 format parameters SYSM040 Amount Limit NUMERIC 20 8 — — +
SYSM Report 347 format parameters SYSM041 Disc volume NCHAR 1   — — +
SYSM Report 347 format parameters SYSM042 Customer Types to declare NCHAR 10   — — +
SYSM Report 347 format parameters SYSM043 Supplier Types to declare NCHAR 10   — — +
SYSM Report 347 format parameters SYSM044 VAT Statement ID NVARCHAR 16   — — +
SYSM Report 347 format parameters SYSM045 Media Type NVARCHAR 1   — — +
SYSM Report 347 format parameters SYSM046 Additional declaration NVARCHAR 1   — — +
SYSM Report 347 format parameters SYSM047 Replacement declaration NVARCHAR 1   — — +
SYSM Report 347 format parameters SYSM048 Previous declaration number NVARCHAR 13   — — +
SYSM Report 347 format parameters SYSM049 Disc Volume 340 NVARCHAR 1   — — +
SYSM Report 347 format parameters SYSM050 Cash Limit NUMERIC 20 8 — — +
SYSR Report File Replacement Symbols SYSR001 Symbols To Replace NCHAR 1   — — +
SYSR Report File Replacement Symbols SYSR002 Replacement String NVARCHAR 15   — — +
SYTB Tax Box Links SYTB001 Tax Box Code NCHAR 6   — — +
SYTB Tax Box Links SYTB002 Tax Code NCHAR 2   — — +
SYTB Tax Box Links SYTB003 Module INT 1   — — +
SYTB Tax Box Links SYTB004 Amount Type INT 2   — — +
SYTX Free Text SYTX001 Object Type NCHAR 2   — — +
SYTX Free Text SYTX002 Object Reference NCHAR 50   — — +
SYTX Free Text SYTX003 Text No NCHAR 3   — — +
SYTX Free Text SYTX004 Text NVARCHAR 2000   — — +
SYVT Generic Patch SYVT001 Table ID NVARCHAR 30   — — +
SYVT Generic Patch SYVT002 Record ID NVARCHAR 400   — — +
SYVT Generic Patch SYVT003 Column ID NVARCHAR 7   — — +
SYVT Generic Patch SYVT004 Date-value DATETIME 8   — — +
SYVT Generic Patch SYVT005 Date/Time value DATETIME 17   — — +
SYVT Generic Patch SYVT006 String-value NVARCHAR 256   — — +
SYVT Generic Patch SYVT007 Numeric-value (Amount) NUMERIC 20 8 — — +
SYVT Generic Patch SYVT008 Numeric-value (Quantity) NUMERIC 12 8 — — +
SYVT Generic Patch SYVT009 Integer-value INT 9   — — +
SYVT Generic Patch SYVT010 Type (DB Converter) INT 1   — — +
SYVT Generic Patch SYVT011 Unlinked Record INT 1   — — +
SYVT Generic Patch SYVT012 Orphan INT 1   — — +