Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...

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

Изменения структуры таблиц модуля «Главная Книга» / General Ledger 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?
GL03 Segment Codes GL03003 Dimension Name NVARCHAR 100   25  
GL03 Segment Codes GL03004 Description 1 NVARCHAR 100   35  
GL03 Segment Codes GL03005 Description 2 NVARCHAR 100   35  
GL03 Segment Codes GL03021 Extended User defined field 1 NVARCHAR 150   +
GL03 Segment Codes GL03022 Extended User defined field 2 NVARCHAR 150   +
GL03 Segment Codes GL03023 Extended User defined field 3 NVARCHAR 150   +
GL03 Segment Codes GL03024 Extended User defined field 4 NVARCHAR 150   +
GL03 Segment Codes GL03025 Extended User defined field 5 NVARCHAR 150   +
GL03 Segment Codes GL03026 Extended User defined field 6 NVARCHAR 150   +
GL03 Segment Codes GL03027 Extended User defined field 7 NVARCHAR 150   +
GL03 Segment Codes GL03028 Extended User defined field 8 NVARCHAR 150   +
GL03 Segment Codes GL03029 Extended User defined field 9 NVARCHAR 150   +
GL03 Segment Codes GL03030 Extended User defined field 10 NVARCHAR 150   +
GL03 Segment Codes GL03031 Extended User defined field 11 NVARCHAR 150   +
GL03 Segment Codes GL03032 Extended User defined field 12 NVARCHAR 150   +
GL03 Segment Codes GL03033 Extended User defined field 13 NVARCHAR 150   +
GL03 Segment Codes GL03034 Extended User defined field 14 NVARCHAR 150   +
GL03 Segment Codes GL03035 Extended User defined field 15 NVARCHAR 150   +
GL03 Segment Codes GL03036 Extended User defined field 16 NVARCHAR 150   +
GL03 Segment Codes GL03037 Extended User defined field 17 NVARCHAR 150   +
GL03 Segment Codes GL03038 Extended User defined field 18 NVARCHAR 150   +
GL03 Segment Codes GL03039 Extended User defined field 19 NVARCHAR 150   +
GL03 Segment Codes GL03040 Extended User defined field 20 NVARCHAR 150   +
GL06 Transactions GL06001 Accounting String NVARCHAR 120   50  
GL06 Transactions GL06002 Transaction Number NCHAR 9   6  
GL06 Transactions GL06005 Transaction Text NVARCHAR 100   25  
GL06 Transactions GL06007 Document Number NVARCHAR 25   23  
GL06 Transactions GL06016 Index Key NCHAR 9   8  
GL06 Transactions GL06021 Unit Code INT 4   2  
GL06 Transactions GL06023 Journal Number NVARCHAR 9   6  
GL06 Transactions GL06024 Purchase Invoice Reference Number NCHAR 9   6  
GL06 Transactions GL06029 Legal Transaction Number NCHAR 9   6  
GL06 Transactions GL06031 Linked Transaction Line (EMU Conversion) NCHAR 9   8  
GL06 Transactions GL06036 GL Export Flag INT 1   +
GL06 Transactions GL06037 Source Company NCHAR 2   +
GL06 Transactions GL06038 Source Module NCHAR 2   +
GL06 Transactions GL06039 Printed By NCHAR 8   +
GL06 Transactions GL06040 Date Printed DATETIME 8   +
GL06 Transactions GL06041 TaxCode NVARCHAR 6   +
GL06 Transactions GL06042 Posting Date/Time DATETIME 17   +
GL07 Daybook Transactions GL07001 Record Counter NUMERIC 9   8  
GL07 Daybook Transactions GL07002 Transaction Number NCHAR 9   6  
GL07 Daybook Transactions GL07003 Line Number NCHAR 7   5  
GL07 Daybook Transactions GL07006 Accounting String NVARCHAR 120   50  
GL07 Daybook Transactions GL07009 Accounting String Line Currency NVARCHAR 120   50  
GL07 Daybook Transactions GL07011 Transaction Line Text NVARCHAR 100   25  
GL07 Daybook Transactions GL07013 Document Number NVARCHAR 25   23  
GL07 Daybook Transactions GL07024 Link Code NCHAR 8   5  
GL07 Daybook Transactions GL07026 Unit Code INT 4   2  
GL07 Daybook Transactions GL07030 PL Reference NCHAR 9   6  
GL07 Daybook Transactions GL07037 Transaction Text Line Currency NVARCHAR 100   25  
GL07 Daybook Transactions GL07038 Source Company NCHAR 2   +
GL07 Daybook Transactions GL07039 Source Module NCHAR 2   +
GL07 Daybook Transactions GL07040 Printed By NCHAR 8   +
GL07 Daybook Transactions GL07041 Date Printed DATETIME 8   +
GL07 Daybook Transactions GL07042 PrintedStatus NCHAR 1   +
GL07 Daybook Transactions GL07043 AAS code NVARCHAR 25   +
GL07 Daybook Transactions GL07044 TaxCode NVARCHAR 6   +
GL08 Opening Balances GL08001 Record Counter NUMERIC 9   8  
GL08 Opening Balances GL08002 Transaction Number NCHAR 9   6  
GL08 Opening Balances GL08003 Line Number NCHAR 7   5  
GL08 Opening Balances GL08006 Accounting String NVARCHAR 120   50  
GL08 Opening Balances GL08009 Accounting String Line Currency NVARCHAR 120   50  
GL08 Opening Balances GL08011 Transaction Line Text NVARCHAR 100   25  
GL08 Opening Balances GL08013 Consolidation Amount NVARCHAR 25   23  
GL08 Opening Balances GL08024 Link Code NCHAR 8   5  
GL08 Opening Balances GL08026 Unit Code INT 4   2  
GL08 Opening Balances GL08030 PL Reference NCHAR 9   6  
GL08 Opening Balances GL08037 Transaction Text Line Currency NVARCHAR 100   25  
GL08 Opening Balances GL08038 Printed By NCHAR 8   +
GL08 Opening Balances GL08039 Date Printed DATETIME 8   +
GL10 GL Parameters GL10063 Close GL NCHAR 1   +
GL10 GL Parameters GL10064 Close PL NCHAR 1   +
GL10 GL Parameters GL10065 Close SL NCHAR 1   +
GL10 GL Parameters GL10066 Close PA NCHAR 1   +
GL10 GL Parameters GL10067 Close PR NCHAR 1   +
GL10 GL Parameters GL10068 Close SC NCHAR 1   +
GL10 GL Parameters GL10069 Close SM NCHAR 1   +
GL10 GL Parameters GL10070 Close MP NCHAR 1   +
GL10 GL Parameters GL10071 GL Transactions File Path (Hospitality) NVARCHAR 256   +
GL10 GL Parameters GL10072 Journal Line Counter INT 9   +
GL10 GL Parameters GL10073 Journal Running Total Amount NUMERIC 20 8 +
GL10 GL Parameters GL10074 Opening Journal Printed NCHAR 1   +
GL10 GL Parameters GL10075 Closing Journal Printed NCHAR 1   +
GL10 GL Parameters GL10076 Journal Closing Date DATETIME 8   +
GL10 GL Parameters GL10077 Use GL Transaction Number (Revenue Recognition) NCHAR 1   +
GL10 GL Parameters GL10078 Auto. transformation at journal update NCHAR 1   +
GL10 GL Parameters GL10079 Use system rules at auto. transformation NCHAR 1   +
GL10 GL Parameters GL10080 Allocation sorting flag NCHAR 1   +
GL10 GL Parameters GL10081 Taxonomy Code Flag NCHAR 1   +
GL10 GL Parameters GL10082 Apply Partial Posting NCHAR 1   +
GL10 GL Parameters GL10083 Group Category Flag NCHAR 1   +
GL10 GL Parameters GL10084 One Account Per Cash Office NCHAR 1   +
GL10 GL Parameters GL10085 Late Assignment Of Transaction Number NCHAR 1   +
GL10 GL Parameters GL10086 Bank Statement Amount Validation NCHAR 1   +
GL11 Automatic Allocations GL11099 Accounting Dimension Line 48 NVARCHAR 12   +
GL11 Automatic Allocations GL11100 Percentage Line 48 NCHAR 11   +
GL11 Automatic Allocations GL11101 Accounting Dimension Line 49 NVARCHAR 12   +
GL11 Automatic Allocations GL11102 Percentage Line 49 NCHAR 11   +
GL11 Automatic Allocations GL11103 Accounting Dimension Line 50 NVARCHAR 12   +
GL11 Automatic Allocations GL11104 Percentage Line 50 NCHAR 11   +
GL11 Automatic Allocations GL11105 Accounting Dimension Line 51 NVARCHAR 12   +
GL11 Automatic Allocations GL11106 Percentage Line 51 NCHAR 11   +
GL11 Automatic Allocations GL11107 Accounting Dimension Line 52 NVARCHAR 12   +
GL11 Automatic Allocations GL11108 Percentage Line 52 NCHAR 11   +
GL11 Automatic Allocations GL11109 Accounting Dimension Line 53 NVARCHAR 12   +
GL11 Automatic Allocations GL11110 Percentage Line 53 NCHAR 11   +
GL11 Automatic Allocations GL11111 Accounting Dimension Line 54 NVARCHAR 12   +
GL11 Automatic Allocations GL11112 Percentage Line 54 NCHAR 11   +
GL11 Automatic Allocations GL11113 Accounting Dimension Line 55 NVARCHAR 12   +
GL11 Automatic Allocations GL11114 Percentage Line 55 NCHAR 11   +
GL11 Automatic Allocations GL11115 Accounting Dimension Line 56 NVARCHAR 12   +
GL11 Automatic Allocations GL11116 Percentage Line 56 NCHAR 11   +
GL11 Automatic Allocations GL11117 Accounting Dimension Line 57 NVARCHAR 12   +
GL11 Automatic Allocations GL11118 Percentage Line 57 NCHAR 11   +
GL11 Automatic Allocations GL11119 Accounting Dimension Line 58 NVARCHAR 12   +
GL11 Automatic Allocations GL11120 Percentage Line 58 NCHAR 11   +
GL11 Automatic Allocations GL11121 Accounting Dimension Line 59 NVARCHAR 12   +
GL11 Automatic Allocations GL11122 Percentage Line 59 NCHAR 11   +
GL11 Automatic Allocations GL11123 Accounting Dimension Line 60 NVARCHAR 12   +
GL11 Automatic Allocations GL11124 Percentage Line 60 NCHAR 11   +
GL11 Automatic Allocations GL11125 Accounting Dimension Line 61 NVARCHAR 12   +
GL11 Automatic Allocations GL11126 Percentage Line 61 NCHAR 11   +
GL11 Automatic Allocations GL11127 Accounting Dimension Line 62 NVARCHAR 12   +
GL11 Automatic Allocations GL11128 Percentage Line 62 NCHAR 11   +
GL11 Automatic Allocations GL11129 Accounting Dimension Line 63 NVARCHAR 12   +
GL11 Automatic Allocations GL11130 Percentage Line 63 NCHAR 11   +
GL11 Automatic Allocations GL11131 Accounting Dimension Line 64 NVARCHAR 12   +
GL11 Automatic Allocations GL11132 Percentage Line 64 NCHAR 11   +
GL11 Automatic Allocations GL11133 Accounting Dimension Line 65 NVARCHAR 12   +
GL11 Automatic Allocations GL11134 Percentage Line 65 NCHAR 11   +
GL11 Automatic Allocations GL11135 Accounting Dimension Line 66 NVARCHAR 12   +
GL11 Automatic Allocations GL11136 Percentage Line 66 NCHAR 11   +
GL11 Automatic Allocations GL11137 Accounting Dimension Line 67 NVARCHAR 12   +
GL11 Automatic Allocations GL11138 Percentage Line 67 NCHAR 11   +
GL11 Automatic Allocations GL11139 Accounting Dimension Line 68 NVARCHAR 12   +
GL11 Automatic Allocations GL11140 Percentage Line 68 NCHAR 11   +
GL11 Automatic Allocations GL11141 Accounting Dimension Line 69 NVARCHAR 12   +
GL11 Automatic Allocations GL11142 Percentage Line 69 NCHAR 11   +
GL11 Automatic Allocations GL11143 Accounting Dimension Line 70 NVARCHAR 12   +
GL11 Automatic Allocations GL11144 Percentage Line 70 NCHAR 11   +
GL11 Automatic Allocations GL11145 Accounting Dimension Line 71 NVARCHAR 12   +
GL11 Automatic Allocations GL11146 Percentage Line 71 NCHAR 11   +
GL11 Automatic Allocations GL11147 Accounting Dimension Line 72 NVARCHAR 12   +
GL11 Automatic Allocations GL11148 Percentage Line 72 NCHAR 11   +
GL11 Automatic Allocations GL11149 Accounting Dimension Line 73 NVARCHAR 12   +
GL11 Automatic Allocations GL11150 Percentage Line 73 NCHAR 11   +
GL11 Automatic Allocations GL11151 Accounting Dimension Line 74 NVARCHAR 12   +
GL11 Automatic Allocations GL11152 Percentage Line 74 NCHAR 11   +
GL11 Automatic Allocations GL11153 Accounting Dimension Line 75 NVARCHAR 12   +
GL11 Automatic Allocations GL11154 Percentage Line 75 NCHAR 11   +
GL11 Automatic Allocations GL11155 Accounting Dimension Line 76 NVARCHAR 12   +
GL11 Automatic Allocations GL11156 Percentage Line 76 NCHAR 11   +
GL11 Automatic Allocations GL11157 Accounting Dimension Line 77 NVARCHAR 12   +
GL11 Automatic Allocations GL11158 Percentage Line 77 NCHAR 11   +
GL11 Automatic Allocations GL11159 Accounting Dimension Line 78 NVARCHAR 12   +
GL11 Automatic Allocations GL11160 Percentage Line 78 NCHAR 11   +
GL11 Automatic Allocations GL11161 Accounting Dimension Line 79 NVARCHAR 12   +
GL11 Automatic Allocations GL11162 Percentage Line 79 NCHAR 11   +
GL11 Automatic Allocations GL11163 Accounting Dimension Line 80 NVARCHAR 12   +
GL11 Automatic Allocations GL11164 Percentage Line 80 NCHAR 11   +
GL11 Automatic Allocations GL11165 Accounting Dimension Line 81 NVARCHAR 12   +
GL11 Automatic Allocations GL11166 Percentage Line 81 NCHAR 11   +
GL11 Automatic Allocations GL11167 Accounting Dimension Line 82 NVARCHAR 12   +
GL11 Automatic Allocations GL11168 Percentage Line 82 NCHAR 11   +
GL11 Automatic Allocations GL11169 Accounting Dimension Line 83 NVARCHAR 12   +
GL11 Automatic Allocations GL11170 Percentage Line 83 NCHAR 11   +
GL11 Automatic Allocations GL11171 Accounting Dimension Line 84 NVARCHAR 12   +
GL11 Automatic Allocations GL11172 Percentage Line 84 NCHAR 11   +
GL11 Automatic Allocations GL11173 Accounting Dimension Line 85 NVARCHAR 12   +
GL11 Automatic Allocations GL11174 Percentage Line 85 NCHAR 11   +
GL11 Automatic Allocations GL11175 Accounting Dimension Line 86 NVARCHAR 12   +
GL11 Automatic Allocations GL11176 Percentage Line 86 NCHAR 11   +
GL11 Automatic Allocations GL11177 Accounting Dimension Line 87 NVARCHAR 12   +
GL11 Automatic Allocations GL11178 Percentage Line 87 NCHAR 11   +
GL11 Automatic Allocations GL11179 Accounting Dimension Line 88 NVARCHAR 12   +
GL11 Automatic Allocations GL11180 Percentage Line 88 NCHAR 11   +
GL11 Automatic Allocations GL11181 Accounting Dimension Line 89 NVARCHAR 12   +
GL11 Automatic Allocations GL11182 Percentage Line 89 NCHAR 11   +
GL11 Automatic Allocations GL11183 Accounting Dimension Line 90 NVARCHAR 12   +
GL11 Automatic Allocations GL11184 Percentage Line 90 NCHAR 11   +
GL11 Automatic Allocations GL11185 Accounting Dimension Line 91 NVARCHAR 12   +
GL11 Automatic Allocations GL11186 Percentage Line 91 NCHAR 11   +
GL11 Automatic Allocations GL11187 Accounting Dimension Line 92 NVARCHAR 12   +
GL11 Automatic Allocations GL11188 Percentage Line 92 NCHAR 11   +
GL11 Automatic Allocations GL11189 Accounting Dimension Line 93 NVARCHAR 12   +
GL11 Automatic Allocations GL11190 Percentage Line 93 NCHAR 11   +
GL11 Automatic Allocations GL11191 Accounting Dimension Line 94 NVARCHAR 12   +
GL11 Automatic Allocations GL11192 Percentage Line 94 NCHAR 11   +
GL11 Automatic Allocations GL11193 Accounting Dimension Line 95 NVARCHAR 12   +
GL11 Automatic Allocations GL11194 Percentage Line 95 NCHAR 11   +
GL11 Automatic Allocations GL11195 Accounting Dimension Line 96 NVARCHAR 12   +
GL11 Automatic Allocations GL11196 Percentage Line 96 NCHAR 11   +
GL11 Automatic Allocations GL11197 Accounting Dimension Line 97 NVARCHAR 12   +
GL11 Automatic Allocations GL11198 Percentage Line 97 NCHAR 11   +
GL11 Automatic Allocations GL11199 Accounting Dimension Line 98 NVARCHAR 12   +
GL11 Automatic Allocations GL11200 Percentage Line 98 NCHAR 11   +
GL11 Automatic Allocations GL11201 Accounting Dimension Line 99 NVARCHAR 12   +
GL11 Automatic Allocations GL11202 Percentage Line 99 NCHAR 11   +
GL11 Automatic Allocations GL11203 SPARE NVARCHAR 12   +
GL11 Automatic Allocations GL11204 SPARE NCHAR 11   +
GL12 Chart of Account Headings GL12004 Default Account Type NCHAR 1   +
GL12 Chart of Account Headings GL12005 Account Grouping Category NCHAR 6   +
GL14 Closing Simulation GL14002 Accounting String NVARCHAR 120   50  
GL14 Closing Simulation GL14004 Text NVARCHAR 100   25  
GL15 Transaction Workfile C GL15003 ICTCodeStr NVARCHAR 120   50  
GL15 Transaction Workfile C GL15004 OwnCodeStr NVARCHAR 120   50  
GL15 Transaction Workfile C GL15006 TransactTxt NVARCHAR 100   25  
GL19 Transaction Workfile D GL19004 InvoiceNo NVARCHAR 25   15  
GL19 Transaction Workfile D GL19016 Link NVARCHAR 7   +
GL19 Transaction Workfile D GL19017 Tax Registration Country NCHAR 3   +
GL21 Project History GL21004 Transaction Number NVARCHAR 9   6  
GL21 Project History GL21006 Text NVARCHAR 100   25  
GL21 Project History GL21008 Invoice Number NVARCHAR 25   16  
GL22 Transaction Workfile A GL22005 InvoiceNo NVARCHAR 25   18  
GL22 Transaction Workfile A GL22013 AccString NVARCHAR 120   50  
GL22 Transaction Workfile A GL22027 PaidInvoceNo NVARCHAR 25   +
GL22 Transaction Workfile A GL22028 PaidInvoiceCustomerCode NVARCHAR 10   +
GL22 Transaction Workfile A GL22029 AAS code NVARCHAR 25   +
GL22 Transaction Workfile A GL22030 Instalment Number INT 3   +
GL30 Transaction Workfile B GL30005 AccountNo NVARCHAR 120   50  
GL30 Transaction Workfile B GL30058 Allocation Type NCHAR 1   +
GL30 Transaction Workfile B GL30059 AmField15 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30060 AmField16 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30061 AmField17 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30062 AmField18 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30063 AmField19 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30064 AmField20 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30065 AmField21 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30066 AmField22 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30067 AmField23 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30068 AmField24 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30069 AmField25 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30070 AmField26 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30071 AmField27 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30072 AmField28 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30073 AmField29 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30074 AmField30 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30075 AmField31 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30076 AmField32 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30077 AmField33 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30078 AmField34 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30079 AmField35 NUMERIC 20 8 +
GL30 Transaction Workfile B GL30080 AmField36 NUMERIC 20 8 +
GL34 WrkDepreciation GL34001 CodeString NVARCHAR 120   50  
GL43 Reconciliations GL43004 Accounting String (First Currency) NVARCHAR 120   50  
GL43 Reconciliations GL43005 Transaction Number NVARCHAR 9   6  
GL43 Reconciliations GL43010 Text (First Currency) NVARCHAR 100   25  
GL43 Reconciliations GL43012 Document Number NVARCHAR 25   10  
GL43 Reconciliations GL43017 Accounting String (Second Currency) NVARCHAR 120   50  
GL43 Reconciliations GL43019 Text (Second Currency) NVARCHAR 100   25  
GL43 Reconciliations GL43021 Supplier NCHAR 10   +
GL44 Workfile Cheques GL44003 ChequeNo NVARCHAR 15   6  
GL44 Workfile Cheques GL44013 CodeString1 NVARCHAR 120   50  
GL44 Workfile Cheques GL44014 CodeString2 NVARCHAR 120   50  
GL44 Workfile Cheques GL44015 CodeString3 NVARCHAR 120   50  
GL44 Workfile Cheques GL44016 CodeString4 NVARCHAR 120   50  
GL44 Workfile Cheques GL44017 CodeString5 NVARCHAR 120   50  
GL44 Workfile Cheques GL44025 ChequeLayout INT 2   1  
GL44 Workfile Cheques GL44027 InvoiceNo NVARCHAR 25   15  
GL44 Workfile Cheques GL44030 Address 5 NVARCHAR 35   +
GL44 Workfile Cheques GL44031 Address 6 NVARCHAR 35   +
GL44 Workfile Cheques GL44032 Address 7 NVARCHAR 35   +
GL44 Workfile Cheques GL44033 Country Code NVARCHAR 3   +
GL45 Transaction Text GL45001 Transaction Number NVARCHAR 9   6  
GL46 Coding Combinations GL46003 Accounting String Maximum NVARCHAR 120   50  
GL46 Coding Combinations GL46004 Accounting String Minimum NVARCHAR 120   50  
GL53 Account Shedule GL53002 Account Name NVARCHAR 100   25  
GL53 Account Shedule GL53010 Account Description Line 1 NVARCHAR 100   40  
GL53 Account Shedule GL53011 Account Description Line 2 NVARCHAR 100   40  
GL53 Account Shedule GL53012 Account Description Line 3 NVARCHAR 100   40  
GL53 Account Shedule GL53013 Default Segment NVARCHAR 120   50  
GL53 Account Shedule GL53020 Sub-Ledger Parameter 7 NVARCHAR 25   10  
GL53 Account Shedule GL53023 External Report Code NVARCHAR 20   10  
GL53 Account Shedule GL53028 Account Sub-Type NVARCHAR 1   +
GL53 Account Shedule GL53029 Extended User defined field 1 NVARCHAR 150   +
GL53 Account Shedule GL53030 Extended User defined field 2 NVARCHAR 150   +
GL53 Account Shedule GL53031 Extended User defined field 3 NVARCHAR 150   +
GL53 Account Shedule GL53032 Extended User defined field 4 NVARCHAR 150   +
GL53 Account Shedule GL53033 Extended User defined field 5 NVARCHAR 150   +
GL53 Account Shedule GL53034 Extended User defined field 6 NVARCHAR 150   +
GL53 Account Shedule GL53035 Extended User defined field 7 NVARCHAR 150   +
GL53 Account Shedule GL53036 Extended User defined field 8 NVARCHAR 150   +
GL53 Account Shedule GL53037 Extended User defined field 9 NVARCHAR 150   +
GL53 Account Shedule GL53038 Extended User defined field 10 NVARCHAR 150   +
GL53 Account Shedule GL53039 Extended User defined field 11 NVARCHAR 150   +
GL53 Account Shedule GL53040 Extended User defined field 12 NVARCHAR 150   +
GL53 Account Shedule GL53041 Extended User defined field 13 NVARCHAR 150   +
GL53 Account Shedule GL53042 Extended User defined field 14 NVARCHAR 150   +
GL53 Account Shedule GL53043 Extended User defined field 15 NVARCHAR 150   +
GL53 Account Shedule GL53044 Extended User defined field 16 NVARCHAR 150   +
GL53 Account Shedule GL53045 Extended User defined field 17 NVARCHAR 150   +
GL53 Account Shedule GL53046 Extended User defined field 18 NVARCHAR 150   +
GL53 Account Shedule GL53047 Extended User defined field 19 NVARCHAR 150   +
GL53 Account Shedule GL53048 Extended User defined field 20 NVARCHAR 150   +
GL53 Account Shedule GL53049 Taxonomy code for account NCHAR 3   +
GL53 Account Shedule GL53050 Account Grouping Category NCHAR 6   +
GL53 Account Shedule GL53051 Balance Type INT 1   +
GL55 Foreign Descriptions GL55004 Name NVARCHAR 100   25  
GL55 Foreign Descriptions GL55005 Description Line 1 NVARCHAR 100   40  
GL55 Foreign Descriptions GL55006 Description Line 2 NVARCHAR 100   40  
GL55 Foreign Descriptions GL55007 Description Line 3 NVARCHAR 100   40  
GL56 Commitments GL56002 Accounting String NVARCHAR 120   50  
GL56 Commitments GL56010 AAS code NVARCHAR 25   +
GL57 Bank Statement Header GL57001 BankCode NVARCHAR 10   +
GL57 Bank Statement Header GL57002 Account NVARCHAR 34   +
GL57 Bank Statement Header GL57003 StatementNo NVARCHAR 35   +
GL57 Bank Statement Header GL57004 StatementStartDate DATETIME 8   +
GL57 Bank Statement Header GL57005 StatementEndDate DATETIME 8   +
GL57 Bank Statement Header GL57006 StatementId INT 10   +
GL57 Bank Statement Header GL57007 CurrencyCd INT 2   +
GL57 Bank Statement Header GL57008 StartBalance NUMERIC 20 8 +
GL57 Bank Statement Header GL57009 NoOfTrans INT 4   +
GL57 Bank Statement Header GL57010 DebitTurnover NUMERIC 20 8 +
GL57 Bank Statement Header GL57011 CreditTurnover NUMERIC 20 8 +
GL57 Bank Statement Header GL57012 EndBalance NUMERIC 20 8 +
GL57 Bank Statement Header GL57013 Status INT 1   +
GL58 Bank Statement Transactions GL58001 StatementId INT 10   +
GL58 Bank Statement Transactions GL58002 TransactionId INT 10   +
GL58 Bank Statement Transactions GL58003 TransactionNo NVARCHAR 10   +
GL58 Bank Statement Transactions GL58004 PaymentId NCHAR 10   +
GL58 Bank Statement Transactions GL58005 ParnterBankCode NVARCHAR 35   +
GL58 Bank Statement Transactions GL58006 PartnerAccount NVARCHAR 35   +
GL58 Bank Statement Transactions GL58007 InvoiceNo NVARCHAR 25   +
GL58 Bank Statement Transactions GL58008 InvBankRefer NVARCHAR 25   +
GL58 Bank Statement Transactions GL58009 BillingCode INT 1   +
GL58 Bank Statement Transactions GL58010 AmountPCU NUMERIC 20 8 +
GL58 Bank Statement Transactions GL58011 AmountACU NUMERIC 20 8 +
GL58 Bank Statement Transactions GL58012 TransferCurrency INT 2   +
GL58 Bank Statement Transactions GL58013 ExchgRatePCU/ACU NUMERIC 10 8 +
GL58 Bank Statement Transactions GL58014 PayDate DATETIME 8   +
GL58 Bank Statement Transactions GL58015 PostingDate DATETIME 8   +
GL58 Bank Statement Transactions GL58016 TransText NVARCHAR 140   +
GL58 Bank Statement Transactions GL58017 AllocAmtPCU NUMERIC 20 8 +
GL58 Bank Statement Transactions GL58018 AllocAmtLCU NUMERIC 20 8 +
GL58 Bank Statement Transactions GL58019 GLTransNo1 NVARCHAR 9   +
GL58 Bank Statement Transactions GL58020 Status INT 1   +
GL58 Bank Statement Transactions GL58021 AllocAmtACU NUMERIC 20 8 +
GL58 Bank Statement Transactions GL58022 GLTransNo2 NVARCHAR 9   +
GL59 Reconcilation Proposal GL59001 ProposalId INT 10   +
GL59 Reconcilation Proposal GL59002 StatementId INT 10   +
GL59 Reconcilation Proposal GL59003 TransactionId INT 10   +
GL59 Reconcilation Proposal GL59004 LineId INT 3   +
GL59 Reconcilation Proposal GL59005 Source INT 1   +
GL59 Reconcilation Proposal GL59006 PartnerCode NVARCHAR 10   +
GL59 Reconcilation Proposal GL59007 InvoiceNo NVARCHAR 25   +
GL59 Reconcilation Proposal GL59008 Installment INT 3   +
GL59 Reconcilation Proposal GL59009 InvBankRef NVARCHAR 25   +
GL59 Reconcilation Proposal GL59010 PaymentId NCHAR 10   +
GL59 Reconcilation Proposal GL59011 AllocAmtPCU NUMERIC 20 8 +
GL59 Reconcilation Proposal GL59012 AllocAmtLCU NUMERIC 20 8 +
GL59 Reconcilation Proposal GL59013 AccString NVARCHAR 120   +
GL59 Reconcilation Proposal GL59014 AAS code NVARCHAR 25   +
GL59 Reconcilation Proposal GL59015 Status INT 1   +
GL59 Reconcilation Proposal GL59016 TransferCurrency INT 2   +
GL59 Reconcilation Proposal GL59017 21Line NVARCHAR 6   +
GL59 Reconcilation Proposal GL59018 TransText NVARCHAR 100   +
GL59 Reconcilation Proposal GL59019 EffExchageRate NUMERIC 10 8 +
GL59 Reconcilation Proposal GL59020 Payment Date DATETIME 8   +
GL5A Multi-Currency Links GL5A005 Rate Options NCHAR 25   10  
GL5C Bank Definition GL5C001 BankCode NVARCHAR 10   +
GL5C Bank Definition GL5C002 Account NVARCHAR 34   +
GL5C Bank Definition GL5C003 Currency INT 2   +
GL5C Bank Definition GL5C004 AccString1 NVARCHAR 120   +
GL5C Bank Definition GL5C005 AccString2 NVARCHAR 120   +
GL5C Bank Definition GL5C006 Path NVARCHAR 256   +
GL5C Bank Definition GL5C007 FileName NVARCHAR 256   +
GL5C Bank Definition GL5C008 ExtraTrans NCHAR 1   +
GL5C Bank Definition GL5C009 FlagInvNo NCHAR 1   +
GL5C Bank Definition GL5C010 FlagInvRef NCHAR 1   +
GL5C Bank Definition GL5C011 FlagPayId NCHAR 1   +
GL5C Bank Definition GL5C012 FlagPayDate NCHAR 1   +
GL5C Bank Definition GL5C013 FlagAmnt NCHAR 1   +
GL5C Bank Definition GL5C014 Difference NUMERIC 5 8 +
GL5C Bank Definition GL5C015 AccString3 NVARCHAR 120   +
GL5C Bank Definition GL5C016 JournalCode NVARCHAR 6   +
GL5D Multi-Link Statistical Account Balances GL5D001 Statistical Account Number NCHAR 12   +
GL5D Multi-Link Statistical Account Balances GL5D002 Linked Account Number NCHAR 12   +
GL5D Multi-Link Statistical Account Balances GL5D003 Currency Code INT 2   +
GL5D Multi-Link Statistical Account Balances GL5D004 Year Opening Balance NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D005 Period 1 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D006 Period 2 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D007 Period 3 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D008 Period 4 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D009 Period 5 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D010 Period 6 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D011 Period 7 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D012 Period 8 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D013 Period 9 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D014 Period 10 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D015 Period 11 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D016 Period 12 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D017 Period 13 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D018 Period 14 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D019 Period 15 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D020 Period 16 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D021 Period 17 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D022 Period 18 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D023 Period 19 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D024 Period 20 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D025 Period 21 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D026 Period 22 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D027 Period 23 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D028 Period 24 Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D029 Closing Period Debit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D030 Period 1 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D031 Period 2 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D032 Period 3 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D033 Period 4 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D034 Period 5 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D035 Period 6 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D036 Period 7 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D037 Period 8 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D038 Period 9 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D039 Period 10 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D040 Period 11 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D041 Period 12 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D042 Period 13 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D043 Period 14 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D044 Period 15 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D045 Period 16 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D046 Period 17 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D047 Period 18 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D048 Period 19 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D049 Period 20 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D050 Period 21 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D051 Period 22 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D052 Period 23 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D053 Period 24 Credit Amount NUMERIC 20 8 +
GL5D Multi-Link Statistical Account Balances GL5D054 Closing Period Credit Amount NUMERIC 20 8 +
GL5S SPED parameters GL5S001 Account Number NVARCHAR 12   +
GL5S SPED parameters GL5S002 SPED Account Number NVARCHAR 13   +
GL5S SPED parameters GL5S003 SPED Account Nature Code NVARCHAR 6   +
GL5S SPED parameters GL5S004 FCONT Account Number NVARCHAR 13   +
GL5S SPED parameters GL5S005 FCONT Account Nature Code NVARCHAR 6   +
GL5S SPED parameters GL5S006 Account Date DATETIME 8   +
GL60 Allocation Description File GL60025 Accounting Dimensions (4-9) NVARCHAR 120   50  
GL60 Allocation Description File GL60030 Minimum Accounting Dimension 4 NVARCHAR 12   +
GL60 Allocation Description File GL60031 Maximum Accounting Dimension 4 NVARCHAR 12   +
GL60 Allocation Description File GL60032 Minimum Accounting Dimension 5 NVARCHAR 12   +
GL60 Allocation Description File GL60033 Maximum Accounting Dimension 5 NVARCHAR 12   +
GL60 Allocation Description File GL60034 Minimum Accounting Dimension 6 NVARCHAR 12   +
GL60 Allocation Description File GL60035 Maximum Accounting Dimension 6 NVARCHAR 12   +
GL60 Allocation Description File GL60036 Minimum Accounting Dimension7 NVARCHAR 12   +
GL60 Allocation Description File GL60037 Maximum Accounting Dimension 7 NVARCHAR 12   +
GL60 Allocation Description File GL60038 Minimum Accounting Dimension 8 NVARCHAR 12   +
GL60 Allocation Description File GL60039 Maximum Accounting Dimension 8 NVARCHAR 12   +
GL60 Allocation Description File GL60040 Minimum Accounting Dimension 9 NVARCHAR 12   +
GL60 Allocation Description File GL60041 Maximum Accounting Dimension 9 NVARCHAR 12   +
GL60 Allocation Description File GL60042 Selection Type Accounting Dimension 4 NCHAR 1   +
GL60 Allocation Description File GL60043 Selection Type Accounting Dimension 5 NCHAR 1   +
GL60 Allocation Description File GL60044 Selection Type Accounting Dimension 6 NCHAR 1   +
GL60 Allocation Description File GL60045 Selection Type Accounting Dimension 7 NCHAR 1   +
GL60 Allocation Description File GL60046 Selection Type Accounting Dimension 8 NCHAR 1   +
GL60 Allocation Description File GL60047 Selection Type Accounting Dimension 9 NCHAR 1   +
GL60 Allocation Description File GL60048 Condensed Text NVARCHAR 100   +
GL62 Allocation Transaction File GL62010 Text NVARCHAR 100   25  
GL62 Allocation Transaction File GL62011 Accounting Dimension 4 NVARCHAR 12   +
GL62 Allocation Transaction File GL62012 Accounting Dimension 5 NVARCHAR 12   +
GL62 Allocation Transaction File GL62013 Accounting Dimension 6 NVARCHAR 12   +
GL62 Allocation Transaction File GL62014 Accounting Dimension 7 NVARCHAR 12   +
GL62 Allocation Transaction File GL62015 Accounting dimension 8 NVARCHAR 12   +
GL62 Allocation Transaction File GL62016 Accounting dimension 9 NVARCHAR 12   +
GL65 Allocation Trans. remeasure File GL65002 Transaction Number (Source) INT 9   6  
GL65 Allocation Trans. remeasure File GL65008 Accounting String Source NVARCHAR 120   50  
GL65 Allocation Trans. remeasure File GL65013 Accounting String Target NVARCHAR 120   50  
GL65 Allocation Trans. remeasure File GL65028 Transaction Number Target NCHAR 9   6  
GL65 Allocation Trans. remeasure File GL65029 Line Number NCHAR 7   5  
GL67 Consolidation sel. history File GL67002 Transaction Number INT 9   6  
GL80 Un-Authorized Transactions (Greece) GL80001 Record Counter NUMERIC 9   8  
GL80 Un-Authorized Transactions (Greece) GL80002 Transaction Number NCHAR 9   6  
GL80 Un-Authorized Transactions (Greece) GL80003 Line Number NCHAR 7   5  
GL80 Un-Authorized Transactions (Greece) GL80006 Accounting String NVARCHAR 120   50  
GL80 Un-Authorized Transactions (Greece) GL80009 Accounting String Line Currency NVARCHAR 120   50  
GL80 Un-Authorized Transactions (Greece) GL80011 Transaction Line Text NVARCHAR 100   25  
GL80 Un-Authorized Transactions (Greece) GL80013 Document Number NVARCHAR 25   23  
GL80 Un-Authorized Transactions (Greece) GL80024 Link Code NCHAR 8   5  
GL80 Un-Authorized Transactions (Greece) GL80026 Unit Code INT 4   2  
GL80 Un-Authorized Transactions (Greece) GL80030 PL Reference NCHAR 9   6  
GL80 Un-Authorized Transactions (Greece) GL80037 Transaction Text Line Currency NVARCHAR 100   25  
GL80 Un-Authorized Transactions (Greece) GL80038 Printed By NCHAR 8   +
GL80 Un-Authorized Transactions (Greece) GL80039 Date Printed DATETIME 8   +
GLB2 Operation Details GLB2001 Group Number NVARCHAR 3   +
GLB2 Operation Details GLB2002 Tax Type NCHAR 1   +
GLB2 Operation Details GLB2003 Operation Date DATETIME 8   +
GLB2 Operation Details GLB2004 OperationNumber NVARCHAR 4   +
GLB2 Operation Details GLB2005 Detail Description 1 NVARCHAR 50   +
GLB2 Operation Details GLB2006 Detail Description 2 NVARCHAR 50   +
GLB2 Operation Details GLB2007 Operation Amount NUMERIC 20 8 +
GLB3 Receipt Information GLB3001 Tax Type NCHAR 1   +
GLB3 Receipt Information GLB3002 Receipt Number NVARCHAR 20   +
GLB3 Receipt Information GLB3003 Receipt Date DATETIME 8   +
GLB3 Receipt Information GLB3004 Receipt Amount NUMERIC 20 8 +
GLB3 Receipt Information GLB3005 Department Name NVARCHAR 50   +
GLB3 Receipt Information GLB3006 Department Address NVARCHAR 50   +
GLB3 Receipt Information GLB3007 Delivery Date DATETIME 8   +
GLBT BLiner Transaction GLBT001 Transaction Number NCHAR 9   +
GLBT BLiner Transaction GLBT002 Pair Number NCHAR 7   +
GLBT BLiner Transaction GLBT003 Line Type NCHAR 1   +
GLBT BLiner Transaction GLBT004 GL Transaction Line Link 1 NCHAR 9   +
GLBT BLiner Transaction GLBT005 GL Transaction Line Link 2 NCHAR 9   +
GLBT BLiner Transaction GLBT006 Amount LCU NUMERIC 20 8 +
GLBT BLiner Transaction GLBT007 Rule ID NCHAR 4   +
GLBT BLiner Transaction GLBT008 Rule Type NCHAR 1   +
GLC1 Statement- or Debit/Credit Notification Message GLC1001 Message ID NCHAR 35   +
GLC1 Statement- or Debit/Credit Notification Message GLC1002 Creation Date DATETIME 17   +
GLC1 Statement- or Debit/Credit Notification Message GLC1003 Description NVARCHAR 50   +
GLC1 Statement- or Debit/Credit Notification Message GLC1004 Template NCHAR 4   +
GLC1 Statement- or Debit/Credit Notification Message GLC1005 Received Date DATETIME 17   +
GLC1 Statement- or Debit/Credit Notification Message GLC1006 Paginated (0/1) NCHAR 1   +
GLC1 Statement- or Debit/Credit Notification Message GLC1007 All Pages Received NCHAR 1   +
GLC1 Statement- or Debit/Credit Notification Message GLC1008 Processing Flag NCHAR 1   +
GLC1 Statement- or Debit/Credit Notification Message GLC1009 Type of Message NCHAR 1   +
GLC2 Statement- or Debit/Credit Notification Message Page GLC2001 Message ID NCHAR 35   +
GLC2 Statement- or Debit/Credit Notification Message Page GLC2002 Page Number NCHAR 4   +
GLC2 Statement- or Debit/Credit Notification Message Page GLC2003 Received Date DATETIME 17   +
GLC3 Statement- or Debit/Credit Notification GLC3001 Message ID NCHAR 35   +
GLC3 Statement- or Debit/Credit Notification GLC3002 Page Number NCHAR 4   +
GLC3 Statement- or Debit/Credit Notification GLC3003 Statement/Notification ID NCHAR 35   +
GLC3 Statement- or Debit/Credit Notification GLC3004 Net Total NUMERIC 20 8 +
GLC3 Statement- or Debit/Credit Notification GLC3005 Debit or Credit NCHAR 4   +
GLC3 Statement- or Debit/Credit Notification GLC3006 Account Number NVARCHAR 34   +
GLC3 Statement- or Debit/Credit Notification GLC3007 BIC NVARCHAR 15   +
GLC3 Statement- or Debit/Credit Notification GLC3008 Account Owner NVARCHAR 140   +
GLC3 Statement- or Debit/Credit Notification GLC3009 Account Owner org. ID NVARCHAR 35   +
GLC4 Statement- or Debit/Credit Notification Entry GLC4001 Message ID NCHAR 35   +
GLC4 Statement- or Debit/Credit Notification Entry GLC4002 Page Number NCHAR 4   +
GLC4 Statement- or Debit/Credit Notification Entry GLC4003 Statement/Notification ID NCHAR 35   +
GLC4 Statement- or Debit/Credit Notification Entry GLC4004 Entry ID NCHAR 35   +
GLC4 Statement- or Debit/Credit Notification Entry GLC4005 Total trans. amount NUMERIC 20 8 +
GLC4 Statement- or Debit/Credit Notification Entry GLC4006 Currency NCHAR 3   +
GLC4 Statement- or Debit/Credit Notification Entry GLC4007 Debit or Credit NCHAR 4   +
GLC4 Statement- or Debit/Credit Notification Entry GLC4008 Booking Date DATETIME 8   +
GLC4 Statement- or Debit/Credit Notification Entry GLC4009 Value Date DATETIME 8   +
GLC4 Statement- or Debit/Credit Notification Entry GLC4010 Account service ID NVARCHAR 35   +
GLC4 Statement- or Debit/Credit Notification Entry GLC4011 Status NCHAR 4   +
GLC5 Statement- or Debit/Credit Notification Entry Detail GLC5001 Message ID NCHAR 35   +
GLC5 Statement- or Debit/Credit Notification Entry Detail GLC5002 Page Number NCHAR 4   +
GLC5 Statement- or Debit/Credit Notification Entry Detail GLC5003 Statement/Notification ID NCHAR 35   +
GLC5 Statement- or Debit/Credit Notification Entry Detail GLC5004 Entry ID NCHAR 35   +
GLC5 Statement- or Debit/Credit Notification Entry Detail GLC5005 Entry detail No NCHAR 6   +
GLC5 Statement- or Debit/Credit Notification Entry Detail GLC5006 Message ID (Orig. MsgID) NVARCHAR 35   +
GLC5 Statement- or Debit/Credit Notification Entry Detail GLC5007 Payment Information ID NVARCHAR 35   +
GLC5 Statement- or Debit/Credit Notification Entry Detail GLC5008 Number of transactions INT 6   +
GLC5 Statement- or Debit/Credit Notification Entry Detail GLC5009 Total Amount NUMERIC 20 8 +
GLC5 Statement- or Debit/Credit Notification Entry Detail GLC5010 Currency NCHAR 3   +
GLC5 Statement- or Debit/Credit Notification Entry Detail GLC5011 Debit or Credit NCHAR 4   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6001 Message ID NCHAR 35   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6002 Page Number NCHAR 4   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6003 Statement/Notification ID NCHAR 35   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6004 Entry ID NCHAR 35   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6005 Entry detail No NCHAR 6   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6006 Transaction No NCHAR 6   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6007 Message ID NVARCHAR 35   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6008 Account Service Reference NVARCHAR 35   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6009 Payment Information ID NVARCHAR 35   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6010 Instruction ID NVARCHAR 35   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6011 End-to-End ID NVARCHAR 35   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6012 Mandate ID NVARCHAR 35   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6013 Transaction Amount NUMERIC 20 8 +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6014 Transaction Currency NCHAR 3   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6015 Instructed Amount NUMERIC 20 8 +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6016 Instructed Currency NCHAR 3   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6017 Name of Initiator NVARCHAR 140   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6018 Name of Debtor NVARCHAR 140   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6019 Debtor Account Number NVARCHAR 34   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6020 Name of Creditor NVARCHAR 140   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6021 Creditor Account Number NVARCHAR 34   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6022 Ultimate Creditor NVARCHAR 140   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6023 Exchange Rate Source Currency NCHAR 3   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6024 Exchange Rate Target Currency NCHAR 3   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6025 Exchange Rate Unit Currency NCHAR 3   +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6026 Exchange Rate NUMERIC 15 8 +
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction GLC6027 Exchange Rate Unit Factor NUMERIC 5 8 +
GLC7 Statement- or Debit/Credit Notification Entry Detail Transaction Unstructured Remittance GLC7001 Message ID NCHAR 35   +
GLC7 Statement- or Debit/Credit Notification Entry Detail Transaction Unstructured Remittance GLC7002 Page Number NCHAR 4   +
GLC7 Statement- or Debit/Credit Notification Entry Detail Transaction Unstructured Remittance GLC7003 Statement/Notification ID NCHAR 35   +
GLC7 Statement- or Debit/Credit Notification Entry Detail Transaction Unstructured Remittance GLC7004 Entry ID NCHAR 35   +
GLC7 Statement- or Debit/Credit Notification Entry Detail Transaction Unstructured Remittance GLC7005 Entry detail No NCHAR 6   +
GLC7 Statement- or Debit/Credit Notification Entry Detail Transaction Unstructured Remittance GLC7006 Transaction No NCHAR 6   +
GLC7 Statement- or Debit/Credit Notification Entry Detail Transaction Unstructured Remittance GLC7007 Remittance No NCHAR 6   +
GLC7 Statement- or Debit/Credit Notification Entry Detail Transaction Unstructured Remittance GLC7008 Unstructured Remittance NVARCHAR 459   +
GLC7 Statement- or Debit/Credit Notification Entry Detail Transaction Unstructured Remittance GLC7009 Processing flag NCHAR 1   +
GLC7 Statement- or Debit/Credit Notification Entry Detail Transaction Unstructured Remittance GLC7010 Reference GUID NVARCHAR 38   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8001 Message ID NCHAR 35   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8002 Page Number NCHAR 4   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8003 Statement/Notification ID NCHAR 35   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8004 Entry ID NCHAR 35   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8005 Entry detail No NCHAR 6   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8006 Transaction No NCHAR 6   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8007 Remittance No NCHAR 6   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8008 Document Reference NVARCHAR 35   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8009 Document Reference Type NCHAR 4   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8010 Remittance Amount NUMERIC 20 8 +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8011 Currency NCHAR 3   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8012 Credit Note Amount NUMERIC 20 8 +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8013 Currency NCHAR 3   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8014 Creditor Reference NVARCHAR 35   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8015 Creditor Reference Type NCHAR 4   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8016 Remittance Info 1 NVARCHAR 140   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8017 Remittance Info 2 NVARCHAR 140   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8018 Remittance Info 3 NVARCHAR 140   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8019 Processing status NCHAR 1   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8020 Created from unstructured NCHAR 1   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8021 GUID — link to GLC7 NVARCHAR 38   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8022 Reference GUID NVARCHAR 38   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8023 Payment Module (PL, SL) NCHAR 2   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8024 Supplier-/Customer Code NVARCHAR 10   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8025 Invoice Number NVARCHAR 50   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8026 Instalment Number INT 3   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8027 Link status NCHAR 1   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8028 GL Account (Bank) NVARCHAR 12   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8029 Transaction Number NVARCHAR 9   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8030 Original Remittance Amount NUMERIC 20 8 +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8031 Reference to the original structured remittance NVARCHAR 6   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8032 Statistical GL Currency Account NVARCHAR 12   +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8033 Remittance Amount LCU NUMERIC 20 8 +
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance GLC8034 Use Prepayment Account NCHAR 1   +
GLC9 Charges GLC9001 Message ID NCHAR 35   +
GLC9 Charges GLC9002 Page Number NCHAR 4   +
GLC9 Charges GLC9003 Statement/Notification ID NCHAR 35   +
GLC9 Charges GLC9004 Entry ID NCHAR 35   +
GLC9 Charges GLC9005 Entry detail No NCHAR 6   +
GLC9 Charges GLC9006 Transaction No NCHAR 6   +
GLC9 Charges GLC9007 Charge No NCHAR 6   +
GLC9 Charges GLC9008 Charge Amount NUMERIC 20 8 +
GLC9 Charges GLC9009 Charge Amount Currency NCHAR 3   +
GLC9 Charges GLC9010 Debit or Credit NCHAR 4   +
GLC9 Charges GLC9011 Type of Charge NCHAR 4   +
GLC9 Charges GLC9012 Processing status NCHAR 1   +
GLCB Petty Cash Master File GLCB024 Transaction Number NCHAR 9   6  
GLCB Petty Cash Master File GLCB025 Accounting String NVARCHAR 120   50  
GLCB Petty Cash Master File GLCB032 Recipient/Payer Address Line 5 NVARCHAR 35   +
GLCB Petty Cash Master File GLCB033 Recipient/Payer Address Line 6 NVARCHAR 35   +
GLCB Petty Cash Master File GLCB034 Recipient/Payer Address Line 7 NVARCHAR 35   +
GLCB Petty Cash Master File GLCB035 Recipient/Payer Country Code NVARCHAR 3   +
GLCD Petty Cash Desk Parameters GLCD003 Accounting String NVARCHAR 120   50  
GLCE Cash Office GLCE001 Cash Office Code NCHAR 8   +
GLCE Cash Office GLCE002 Description NVARCHAR 25   +
GLCE Cash Office GLCE003 User Group Code NCHAR 8   +
GLCF Cash Office Language Dependent Description GLCF001 Language Code NCHAR 3   +
GLCF Cash Office Language Dependent Description GLCF002 Cash Office Code NCHAR 8   +
GLCF Cash Office Language Dependent Description GLCF003 Description NVARCHAR 25   +
GLCG Reason Code GLCG001 Reason Code NCHAR 2   +
GLCG Reason Code GLCG002 Description NVARCHAR 25   +
GLCG Reason Code GLCG003 Ledger Code INT 1   +
GLCH Notification processing template header GLCH001 Template ID NCHAR 4   +
GLCH Notification processing template header GLCH002 Description NVARCHAR 50   +
GLCH Notification processing template header GLCH003 Horizontal Scroll NCHAR 1   +
GLCH Notification processing template header GLCH004 Frozen Columns INT 2   +
GLCH Notification processing template header GLCH005 Property 1 NCHAR 1   +
GLCH Notification processing template header GLCH006 Property 2 NCHAR 1   +
GLCH Notification processing template header GLCH007 Property 3 NCHAR 1   +
GLCH Notification processing template header GLCH008 Property 4 NCHAR 1   +
GLCH Notification processing template header GLCH009 Property 5 NCHAR 1   +
GLCH Notification processing template header GLCH010 Property 6 NCHAR 1   +
GLCH Notification processing template header GLCH011 Foreground RW INT 10   +
GLCH Notification processing template header GLCH012 Background RW INT 10   +
GLCH Notification processing template header GLCH013 Foreground RO INT 10   +
GLCH Notification processing template header GLCH014 Background RO INT 10   +
GLCH Notification processing template header GLCH015 Foreground RO+C INT 10   +
GLCH Notification processing template header GLCH016 Background RO+C INT 10   +
GLCH Notification processing template header GLCH017 Foreground Linked INT 10   +
GLCH Notification processing template header GLCH018 Background Linked INT 10   +
GLCH Notification processing template header GLCH019 Foreground NULL INT 10   +
GLCH Notification processing template header GLCH020 Background NULL INT 10   +
GLCI Reason Code Language Dependent Description GLCI001 Language Code NCHAR 3   +
GLCI Reason Code Language Dependent Description GLCI002 Reason Code NCHAR 2   +
GLCI Reason Code Language Dependent Description GLCI003 Description NVARCHAR 25   +
GLCL Notification processing template Line GLCL001 Template ID NCHAR 4   +
GLCL Notification processing template Line GLCL002 Column INT 3   +
GLCL Notification processing template Line GLCL003 Field Number INT 3   +
GLCL Notification processing template Line GLCL004 Property 1 NCHAR 1   +
GLCL Notification processing template Line GLCL005 Property 2 NCHAR 1   +
GLCL Notification processing template Line GLCL006 Property 3 NCHAR 1   +
GLCL Notification processing template Line GLCL007 Property 4 NCHAR 1   +
GLCL Notification processing template Line GLCL008 Property 5 NCHAR 1   +
GLCL Notification processing template Line GLCL009 Property 6 NCHAR 1   +
GLCW Compound Periodic Allocation Work File GLCW005 TransactionNumber NVARCHAR 9   6  
GLCW Compound Periodic Allocation Work File GLCW006 LineNumber NVARCHAR 7   5  
GLCW Compound Periodic Allocation Work File GLCW007 CodeString NVARCHAR 120   50  
GLCW Compound Periodic Allocation Work File GLCW010 Text NVARCHAR 100   25  
GLCW Compound Periodic Allocation Work File GLCW032 Running NCHAR 9   8  
GLCX Petty Cash Extension File GLCX007 Invoice Number NVARCHAR 25   15  
GLCX Petty Cash Extension File GLCX015 Accounting String NVARCHAR 120   50  
GLCX Petty Cash Extension File GLCX029 Instalment Number INT 3   +
GLCY Petty Cash Transaction File GLCY005 Record Number NUMERIC 9   8  
GLCY Petty Cash Transaction File GLCY006 Transaction Number NCHAR 9   6  
GLCY Petty Cash Transaction File GLCY007 Line Number NCHAR 7   5  
GLCY Petty Cash Transaction File GLCY010 Accounting String NVARCHAR 120   50  
GLCY Petty Cash Transaction File GLCY013 Accounting String Line Currency NVARCHAR 120   50  
GLCY Petty Cash Transaction File GLCY015 Transaction Line Text NVARCHAR 100   25  
GLCY Petty Cash Transaction File GLCY017 Document Number NVARCHAR 25   23  
GLCY Petty Cash Transaction File GLCY028 Link Code NCHAR 8   5  
GLCY Petty Cash Transaction File GLCY030 Unit Code INT 4   2  
GLCY Petty Cash Transaction File GLCY034 PL Reference NCHAR 9   6  
GLCY Petty Cash Transaction File GLCY041 Transaction Text Line Currency NVARCHAR 100   25  
GLEB Extended General Ledger Balance GLEB001 Type NCHAR 1   +
GLEB Extended General Ledger Balance GLEB002 Account NVARCHAR 12   +
GLEB Extended General Ledger Balance GLEB003 Segment 1 NVARCHAR 12   +
GLEB Extended General Ledger Balance GLEB004 Segment 2 NVARCHAR 12   +
GLEB Extended General Ledger Balance GLEB005 Segment 3 NVARCHAR 12   +
GLEB Extended General Ledger Balance GLEB006 Segment 4 NVARCHAR 12   +
GLEB Extended General Ledger Balance GLEB007 Segment 5 NVARCHAR 12   +
GLEB Extended General Ledger Balance GLEB008 Segment 6 NVARCHAR 12   +
GLEB Extended General Ledger Balance GLEB009 Segment 7 NVARCHAR 12   +
GLEB Extended General Ledger Balance GLEB010 Segment 8 NVARCHAR 12   +
GLEB Extended General Ledger Balance GLEB011 Segment 9 NVARCHAR 12   +
GLEB Extended General Ledger Balance GLEB012 Reporting Level NCHAR 1   +
GLEB Extended General Ledger Balance GLEB013 FY Opening Balance NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB014 Debit Period 1 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB015 Debit Period 2 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB016 Debit Period 3 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB017 Debit Period 4 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB018 Debit Period 5 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB019 Debit Period 6 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB020 Debit Period 7 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB021 Debit Period 8 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB022 Debit Period 9 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB023 Debit Period 10 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB024 Debit Period 11 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB025 Debit Period 12 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB026 Debit Period 13 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB027 Debit Period 14 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB028 Debit Period 15 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB029 Debit Period 16 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB030 Debit Period 17 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB031 Debit Period 18 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB032 Debit Period 19 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB033 Debit Period 20 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB034 Debit Period 21 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB035 Debit Period 22 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB036 Debit Period 23 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB037 Debit Period 24 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB038 Debit Closing Period NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB039 Credit Period 1 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB040 Credit Period 2 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB041 Credit Period 3 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB042 Credit Period 4 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB043 Credit Period 5 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB044 Credit Period 6 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB045 Credit Period 7 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB046 Credit Period 8 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB047 Credit Period 9 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB048 Credit Period 10 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB049 Credit Period 11 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB050 Credit Period 12 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB051 Credit Period 13 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB052 Credit Period 14 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB053 Credit Period 15 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB054 Credit Period 16 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB055 Credit Period 17 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB056 Credit Period 18 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB057 Credit Period 19 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB058 Credit Period 20 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB059 Credit Period 21 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB060 Credit Period 22 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB061 Credit Period 23 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB062 Credit Period 24 NUMERIC 20 8 +
GLEB Extended General Ledger Balance GLEB063 Credit Closing Period NUMERIC 20 8 +
GLF1 Financial Reporting Report Definition GLF1001 Report Number INT 6   +
GLF1 Financial Reporting Report Definition GLF1002 DataSet Name NVARCHAR 100   +
GLF1 Financial Reporting Report Definition GLF1003 RowSet Number INT 6   +
GLF1 Financial Reporting Report Definition GLF1004 ColumnSet Number INT 6   +
GLF1 Financial Reporting Report Definition GLF1005 Is System INT 1   +
GLF1 Financial Reporting Report Definition GLF1006 Permission Id UNIQUEIDENTIFIER 36   +
GLF2 Financial Reporting RowSet GLF2001 RowSet Number INT 6   +
GLF2 Financial Reporting RowSet GLF2002 Is System INT 1   +
GLF3 Financial Reporting Row GLF3001 RowSet Number INT 6   +
GLF3 Financial Reporting Row GLF3002 Row Number INT 6   +
GLF3 Financial Reporting Row GLF3003 Parent Row Number INT 6   +
GLF3 Financial Reporting Row GLF3004 Sort Order INT 6   +
GLF3 Financial Reporting Row GLF3005 Hidden NVARCHAR 1   +
GLF3 Financial Reporting Row GLF3006 Is System INT 1   +
GLF4 Financial Reporting Leaf Row Properties GLF4001 RowSet Number INT 6   +
GLF4 Financial Reporting Leaf Row Properties GLF4002 Row Number INT 6   +
GLF4 Financial Reporting Leaf Row Properties GLF4003 Sign INT 1   +
GLF4 Financial Reporting Leaf Row Properties GLF4004 Account Operator INT 1   +
GLF4 Financial Reporting Leaf Row Properties GLF4005 Account Expression NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4006 Account Expression 2 NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4007 Segment1 Operator INT 1   +
GLF4 Financial Reporting Leaf Row Properties GLF4008 Segment1 Expression NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4009 Segment1 Expression 2 NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4010 Segment2 Operator INT 1   +
GLF4 Financial Reporting Leaf Row Properties GLF4011 Segment2 Expression NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4012 Segment2 Expression 2 NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4013 Segment3 Operator INT 1   +
GLF4 Financial Reporting Leaf Row Properties GLF4014 Segment3 Expression NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4015 Segment3 Expression 2 NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4016 Segment4 Operator INT 1   +
GLF4 Financial Reporting Leaf Row Properties GLF4017 Segment4 Expression NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4018 Segment4 Expression 2 NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4019 Segment5 Operator INT 1   +
GLF4 Financial Reporting Leaf Row Properties GLF4020 Segment5 Expression NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4021 Segment5 Expression 2 NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4022 Segment6 Operator INT 1   +
GLF4 Financial Reporting Leaf Row Properties GLF4023 Segment6 Expression NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4024 Segment6 Expression 2 NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4025 Segment7 Operator INT 1   +
GLF4 Financial Reporting Leaf Row Properties GLF4026 Segment7 Expression NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4027 Segment7 Expression 2 NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4028 Segment8 Operator INT 1   +
GLF4 Financial Reporting Leaf Row Properties GLF4029 Segment8 Expression NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4030 Segment8 Expression 2 NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4031 Segment9 Operator INT 1   +
GLF4 Financial Reporting Leaf Row Properties GLF4032 Segment9 Expression NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4033 Segment9 Expression 2 NVARCHAR 12   +
GLF4 Financial Reporting Leaf Row Properties GLF4034 Balance Type Source INT 1   +
GLF4 Financial Reporting Leaf Row Properties GLF4035 Balance Type INT 1   +
GLF4 Financial Reporting Leaf Row Properties GLF4036 Is System INT 1   +
GLF5 Financial Reporting ColumnSet GLF5001 ColumnSet Number INT 6   +
GLF5 Financial Reporting ColumnSet GLF5002 Is System INT 1   +
GLF6 Financial Reporting Column GLF6001 ColumnSet Number INT 6   +
GLF6 Financial Reporting Column GLF6002 Column Number INT 6   +
GLF6 Financial Reporting Column GLF6003 Sort Order INT 6   +
GLF6 Financial Reporting Column GLF6004 DataSet Column Name NVARCHAR 100   +
GLF6 Financial Reporting Column GLF6005 Year INT 1   +
GLF6 Financial Reporting Column GLF6006 Transaction Type INT 1   +
GLF6 Financial Reporting Column GLF6007 Budget Alternative INT 1   +
GLF6 Financial Reporting Column GLF6008 Time Span INT 2   +
GLF6 Financial Reporting Column GLF6009 Amount Type INT 2   +
GLF6 Financial Reporting Column GLF6010 Is System INT 1   +
GLF7 Accounting Dimension Categories GLF7001 Dimension Number INT 1   +
GLF7 Accounting Dimension Categories GLF7002 Category Number INT 6   +
GLF7 Accounting Dimension Categories GLF7003 Parent Category Number INT 6   +
GLF7 Accounting Dimension Categories GLF7004 Sort Order INT 6   +
GLF8 Accounting Dimension Categories Leaf Properties GLF8001 Dimension Number INT 1   +
GLF8 Accounting Dimension Categories Leaf Properties GLF8002 Category Number INT 6   +
GLF8 Accounting Dimension Categories Leaf Properties GLF8003 Operator INT 1   +
GLF8 Accounting Dimension Categories Leaf Properties GLF8004 Expression 1 NVARCHAR 12   +
GLF8 Accounting Dimension Categories Leaf Properties GLF8005 Expression 2 NVARCHAR 12   +
GLFA Financial Reporting Report Definition Descriptions GLFA001 Report Number INT 6   +
GLFA Financial Reporting Report Definition Descriptions GLFA002 LanCode NCHAR 3   +
GLFA Financial Reporting Report Definition Descriptions GLFA003 Description NVARCHAR 250   +
GLFA Financial Reporting Report Definition Descriptions GLFA004 Is System INT 1   +
GLFB Financial Reporting RowSet Descriptions GLFB001 RowSet Number INT 6   +
GLFB Financial Reporting RowSet Descriptions GLFB002 LanCode NCHAR 3   +
GLFB Financial Reporting RowSet Descriptions GLFB003 Description NVARCHAR 250   +
GLFB Financial Reporting RowSet Descriptions GLFB004 Is System INT 1   +
GLFC Financial Reporting Row Descriptions GLFC001 RowSet Number INT 6   +
GLFC Financial Reporting Row Descriptions GLFC002 Row Number INT 6   +
GLFC Financial Reporting Row Descriptions GLFC003 LanCode NCHAR 3   +
GLFC Financial Reporting Row Descriptions GLFC004 Description NVARCHAR 250   +
GLFC Financial Reporting Row Descriptions GLFC005 Is System INT 1   +
GLFD Financial Reporting ColumnSet Descriptions GLFD001 ColumnSet Number INT 6   +
GLFD Financial Reporting ColumnSet Descriptions GLFD002 LanCode NCHAR 3   +
GLFD Financial Reporting ColumnSet Descriptions GLFD003 Description NVARCHAR 250   +
GLFD Financial Reporting ColumnSet Descriptions GLFD004 Is System INT 1   +
GLFE Financial Reporting Column Descriptions GLFE001 ColumnSet Number INT 6   +
GLFE Financial Reporting Column Descriptions GLFE002 Column Number INT 6   +
GLFE Financial Reporting Column Descriptions GLFE003 LanCode NCHAR 3   +
GLFE Financial Reporting Column Descriptions GLFE004 Description NVARCHAR 250   +
GLFE Financial Reporting Column Descriptions GLFE005 Is System INT 1   +
GLFF Accounting Dimension Categories Descriptions GLFF001 Dimension Number INT 1   +
GLFF Accounting Dimension Categories Descriptions GLFF002 Category Number INT 6   +
GLFF Accounting Dimension Categories Descriptions GLFF003 LanCode NCHAR 3   +
GLFF Accounting Dimension Categories Descriptions GLFF004 Description NVARCHAR 250   +
GLGL GL Consolidation GLGL002 Record Counter NUMERIC 9   8  
GLGL GL Consolidation GLGL003 Transaction Number NCHAR 9   6  
GLGL GL Consolidation GLGL004 Line Number NCHAR 7   5  
GLGL GL Consolidation GLGL007 Accounting String NVARCHAR 120   50  
GLGL GL Consolidation GLGL010 Accounting String Line Currency NVARCHAR 120   50  
GLGL GL Consolidation GLGL012 Transaction Line Text NVARCHAR 100   25  
GLGL GL Consolidation GLGL014 Document Number NVARCHAR 25   23  
GLGL GL Consolidation GLGL025 Link Code NCHAR 8   5  
GLGL GL Consolidation GLGL031 PL Reference NCHAR 9   6  
GLGL GL Consolidation GLGL038 Transaction Text Line Currency NVARCHAR 100   25  
GLH2 PMS Interface Mapping File GLH2007 Accounting String 1 NVARCHAR 120   50  
GLH2 PMS Interface Mapping File GLH2014 Accounting String 2 NVARCHAR 120   50  
GLH2 PMS Interface Mapping File GLH2015 Tax line no INT 2   +
GLH2 PMS Interface Mapping File GLH2016 Tax Code NVARCHAR 6   +
GLHI FA Transaction History GLHI011 AccString NVARCHAR 120   50  
GLHI FA Transaction History GLHI031 TransactNo NVARCHAR 9   6  
GLII Company Fiscal Parameters GLII001 Parameter Code NVARCHAR 10   +
GLII Company Fiscal Parameters GLII002 Parameter Value NVARCHAR 50   +
GLR1 Revenue Recognition, History GLR1001 Object Type INT 2   +
GLR1 Revenue Recognition, History GLR1002 Object ID NVARCHAR 12   +
GLR1 Revenue Recognition, History GLR1003 Object Extended ID NVARCHAR 50   +
GLR1 Revenue Recognition, History GLR1004 Recognition Number NCHAR 10   +
GLR1 Revenue Recognition, History GLR1005 Revision INT 1   +
GLR1 Revenue Recognition, History GLR1006 Recognition Date DATETIME 8   +
GLR1 Revenue Recognition, History GLR1007 Model Type NCHAR 3   +
GLR1 Revenue Recognition, History GLR1008 Book Entry Date DATETIME 8   +
GLR1 Revenue Recognition, History GLR1009 Currency Code NCHAR 2   +
GLR1 Revenue Recognition, History GLR1010 Value Total, OCU NUMERIC 20 8 +
GLR1 Revenue Recognition, History GLR1011 Value Total, LCU NUMERIC 20 8 +
GLR1 Revenue Recognition, History GLR1012 Recognized Revenue, OCU NUMERIC 20 8 +
GLR1 Revenue Recognition, History GLR1013 Recognized Revenue, LCU NUMERIC 20 8 +
GLR1 Revenue Recognition, History GLR1014 Billing Total, OCU NUMERIC 20 8 +
GLR1 Revenue Recognition, History GLR1015 Billing Total, LCU NUMERIC 20 8 +
GLR1 Revenue Recognition, History GLR1016 Cost Total, LCU NUMERIC 20 8 +
GLR1 Revenue Recognition, History GLR1017 Recognized Cost, LCU NUMERIC 20 8 +
GLR1 Revenue Recognition, History GLR1018 Unearned Revenue Total, LCU NUMERIC 20 8 +
GLR1 Revenue Recognition, History GLR1019 Unbilled Revenue Total, LCU NUMERIC 20 8 +
GLR1 Revenue Recognition, History GLR1020 Total Duration NUMERIC 14 8 +
GLR1 Revenue Recognition, History GLR1021 Current Duration NUMERIC 14 8 +
GLR1 Revenue Recognition, History GLR1022 Duration Unit INT 1   +
GLR1 Revenue Recognition, History GLR1023 GL Accounting Period NCHAR 4   +
GLR1 Revenue Recognition, History GLR1024 Date-time stamp DATETIME 17   +
GLR1 Revenue Recognition, History GLR1025 User ID NCHAR 8   +
GLR1 Revenue Recognition, History GLR1026 GL Transaction Number NCHAR 9   +
GLR1 Revenue Recognition, History GLR1027 GL Transaction Date DATETIME 8   +
GLR1 Revenue Recognition, History GLR1028 Expected Gross Profit, LCU NUMERIC 20 8 +
GLR1 Revenue Recognition, History GLR1029 Warranty Estimated Cost, LCU NUMERIC 20 8 +
GLR1 Revenue Recognition, History GLR1030 Warranty Actual Cost, LCU NUMERIC 20 8 +
GLR1 Revenue Recognition, History GLR1031 Warranty Reserve, LCU NUMERIC 20 8 +
GLR2 Revenue Recognition Details, History GLR2001 Object Type INT 2   +
GLR2 Revenue Recognition Details, History GLR2002 Object ID NVARCHAR 12   +
GLR2 Revenue Recognition Details, History GLR2003 Object Extended ID NVARCHAR 50   +
GLR2 Revenue Recognition Details, History GLR2004 Recognition Number NCHAR 10   +
GLR2 Revenue Recognition Details, History GLR2005 Revision INT 1   +
GLR2 Revenue Recognition Details, History GLR2006 Record Type INT 2   +
GLR2 Revenue Recognition Details, History GLR2007 Reference Type INT 2   +
GLR2 Revenue Recognition Details, History GLR2008 Reference ID NVARCHAR 70   +
GLR2 Revenue Recognition Details, History GLR2009 Internal Line Counter INT 6   +
GLR2 Revenue Recognition Details, History GLR2010 Amount, OCU NUMERIC 20 8 +
GLR2 Revenue Recognition Details, History GLR2011 Amount, LCU NUMERIC 20 8 +
GLR2 Revenue Recognition Details, History GLR2012 AAS Level INT 1   +
GLR2 Revenue Recognition Details, History GLR2013 Accounting String NVARCHAR 120   +
GLR2 Revenue Recognition Details, History GLR2014 AAS Code NVARCHAR 25   +
GLR2 Revenue Recognition Details, History GLR2015 GL Reference NCHAR 9   +
GLR2 Revenue Recognition Details, History GLR2016 Transaction number NCHAR 9   +
GLR2 Revenue Recognition Details, History GLR2017 Transaction line NCHAR 7   +
GLR6 GL Reversed Transactions GLR6001 Original Transaction Number NCHAR 9   +
GLR6 GL Reversed Transactions GLR6002 Reversed Transaction Number NCHAR 9   +
GLR6 GL Reversed Transactions GLR6003 Journal Number Original Transaction NVARCHAR 9   +
GLR6 GL Reversed Transactions GLR6004 Journal Number Reversed Transaction NVARCHAR 9   +
GLR7 GL Reversed Transactions GLR7001 Original Transaction Number NCHAR 9   +
GLR7 GL Reversed Transactions GLR7002 Reversed Transaction Number NCHAR 9   +
GLR7 GL Reversed Transactions GLR7003 Journal Number Original Transaction NVARCHAR 9   +
GLR7 GL Reversed Transactions GLR7004 Journal Number Reversed Transaction NVARCHAR 9   +
GLRD Revenue Recognition Details GLRD001 Object Type INT 2   +
GLRD Revenue Recognition Details GLRD002 Object ID NVARCHAR 12   +
GLRD Revenue Recognition Details GLRD003 Object Extended ID NVARCHAR 50   +
GLRD Revenue Recognition Details GLRD004 Recognition Number NCHAR 10   +
GLRD Revenue Recognition Details GLRD005 Revision INT 1   +
GLRD Revenue Recognition Details GLRD006 Record Type INT 2   +
GLRD Revenue Recognition Details GLRD007 Reference Type INT 2   +
GLRD Revenue Recognition Details GLRD008 Reference ID NVARCHAR 70   +
GLRD Revenue Recognition Details GLRD009 Internal Line Counter INT 6   +
GLRD Revenue Recognition Details GLRD010 Amount, OCU NUMERIC 20 8 +
GLRD Revenue Recognition Details GLRD011 Amount, LCU NUMERIC 20 8 +
GLRD Revenue Recognition Details GLRD012 AAS Level INT 1   +
GLRD Revenue Recognition Details GLRD013 Accounting String NVARCHAR 120   +
GLRD Revenue Recognition Details GLRD014 AAS Code NVARCHAR 25   +
GLRD Revenue Recognition Details GLRD015 GL Reference NCHAR 9   +
GLRD Revenue Recognition Details GLRD016 Transaction number NCHAR 9   +
GLRD Revenue Recognition Details GLRD017 Transaction line NCHAR 7   +
GLRH Revenue Recognition History WIP Journal GLRH001 RecCounter NUMERIC 9   +
GLRH Revenue Recognition History WIP Journal GLRH002 TransactionNo NCHAR 9   +
GLRH Revenue Recognition History WIP Journal GLRH003 LineNumber NCHAR 7   +
GLRH Revenue Recognition History WIP Journal GLRH004 TransactionDate DATETIME 8   +
GLRH Revenue Recognition History WIP Journal GLRH005 Flag NCHAR 1   +
GLRH Revenue Recognition History WIP Journal GLRH006 AccountingString NVARCHAR 120   +
GLRH Revenue Recognition History WIP Journal GLRH007 AmountLCU NUMERIC 20 8 +
GLRH Revenue Recognition History WIP Journal GLRH008 CurrencyCode INT 2   +
GLRH Revenue Recognition History WIP Journal GLRH009 AccountingStringLCU NVARCHAR 120   +
GLRH Revenue Recognition History WIP Journal GLRH010 AmountLCU NUMERIC 20 8 +
GLRH Revenue Recognition History WIP Journal GLRH011 TransactionText NVARCHAR 100   +
GLRH Revenue Recognition History WIP Journal GLRH012 Code1Engineer NCHAR 10   +
GLRH Revenue Recognition History WIP Journal GLRH013 Code2Project NVARCHAR 25   +
GLRH Revenue Recognition History WIP Journal GLRH014 Code3ActivityStructLineNum NCHAR 6   +
GLRH Revenue Recognition History WIP Journal GLRH015 Code4 NCHAR 2   +
GLRH Revenue Recognition History WIP Journal GLRH016 Code5 NVARCHAR 35   +
GLRH Revenue Recognition History WIP Journal GLRH017 Code6TransLineNumber NCHAR 8   +
GLRH Revenue Recognition History WIP Journal GLRH018 Tag1 NCHAR 1   +
GLRH Revenue Recognition History WIP Journal GLRH019 Tag2 NCHAR 1   +
GLRH Revenue Recognition History WIP Journal GLRH020 Tag3 NCHAR 1   +
GLRH Revenue Recognition History WIP Journal GLRH021 TransLineType NCHAR 1   +
GLRH Revenue Recognition History WIP Journal GLRH022 TransLineSign NCHAR 1   +
GLRH Revenue Recognition History WIP Journal GLRH023 NumberOfDecimals NUMERIC 1   +
GLRH Revenue Recognition History WIP Journal GLRH024 LinkCode NCHAR 8   +
GLRH Revenue Recognition History WIP Journal GLRH025 Quantity NUMERIC 20 8 +
GLRH Revenue Recognition History WIP Journal GLRH026 UnitCode INT 4   +
GLRH Revenue Recognition History WIP Journal GLRH027 AmountCCU NUMERIC 20 8 +
GLRH Revenue Recognition History WIP Journal GLRH028 ContraAcc NCHAR 13   +
GLRH Revenue Recognition History WIP Journal GLRH029 JournalNo NUMERIC 6   +
GLRH Revenue Recognition History WIP Journal GLRH030 PLReference NCHAR 9   +
GLRH Revenue Recognition History WIP Journal GLRH031 SubProjectNum NCHAR 6   +
GLRH Revenue Recognition History WIP Journal GLRH032 ActivityLineNum NCHAR 6   +
GLRH Revenue Recognition History WIP Journal GLRH033 UserIDEnteredBy NCHAR 8   +
GLRH Revenue Recognition History WIP Journal GLRH034 DateOfEntry DATETIME 8   +
GLRH Revenue Recognition History WIP Journal GLRH035 UserIDUpdatedBy NCHAR 8   +
GLRH Revenue Recognition History WIP Journal GLRH036 DateOfUpdate DATETIME 8   +
GLRH Revenue Recognition History WIP Journal GLRH037 TransactionTextOCU NVARCHAR 100   +
GLRH Revenue Recognition History WIP Journal GLRH038 SourceCompany NCHAR 2   +
GLRH Revenue Recognition History WIP Journal GLRH039 SourceModule NCHAR 2   +
GLRH Revenue Recognition History WIP Journal GLRH040 UserIDPrintedBy NCHAR 8   +
GLRH Revenue Recognition History WIP Journal GLRH041 DateOfPrint DATETIME 8   +
GLRH Revenue Recognition History WIP Journal GLRH042 PrintStatus NCHAR 1   +
GLRH Revenue Recognition History WIP Journal GLRH043 GLTransactionNum NCHAR 9   +
GLRJ Revenue Recognition Day Book Journal GLRJ001 Reccounter NUMERIC 9   +
GLRJ Revenue Recognition Day Book Journal GLRJ002 TransactNo NCHAR 9   +
GLRJ Revenue Recognition Day Book Journal GLRJ003 Linenumber NCHAR 7   +
GLRJ Revenue Recognition Day Book Journal GLRJ004 Trandate DATETIME 8   +
GLRJ Revenue Recognition Day Book Journal GLRJ005 Flag NCHAR 1   +
GLRJ Revenue Recognition Day Book Journal GLRJ006 Accstring NVARCHAR 120   +
GLRJ Revenue Recognition Day Book Journal GLRJ007 Amountlcu NUMERIC 20 8 +
GLRJ Revenue Recognition Day Book Journal GLRJ008 Currcode INT 2   +
GLRJ Revenue Recognition Day Book Journal GLRJ009 Accstringocu NVARCHAR 120   +
GLRJ Revenue Recognition Day Book Journal GLRJ010 Amountocu NUMERIC 20 8 +
GLRJ Revenue Recognition Day Book Journal GLRJ011 Trantext NVARCHAR 100   +
GLRJ Revenue Recognition Day Book Journal GLRJ012 Code1 NCHAR 10   +
GLRJ Revenue Recognition Day Book Journal GLRJ013 Code2 NVARCHAR 25   +
GLRJ Revenue Recognition Day Book Journal GLRJ014 Code3 NCHAR 6   +
GLRJ Revenue Recognition Day Book Journal GLRJ015 Code4 NCHAR 2   +
GLRJ Revenue Recognition Day Book Journal GLRJ016 Code5 NVARCHAR 35   +
GLRJ Revenue Recognition Day Book Journal GLRJ017 Code6 NCHAR 8   +
GLRJ Revenue Recognition Day Book Journal GLRJ018 Tag1 NCHAR 1   +
GLRJ Revenue Recognition Day Book Journal GLRJ019 Tag2 NCHAR 1   +
GLRJ Revenue Recognition Day Book Journal GLRJ020 Tag3 NCHAR 1   +
GLRJ Revenue Recognition Day Book Journal GLRJ021 Tranlinetype NCHAR 1   +
GLRJ Revenue Recognition Day Book Journal GLRJ022 Tranlinesign NCHAR 1   +
GLRJ Revenue Recognition Day Book Journal GLRJ023 Noofdecimals NUMERIC 1   +
GLRJ Revenue Recognition Day Book Journal GLRJ024 Linkcode NCHAR 8   +
GLRJ Revenue Recognition Day Book Journal GLRJ025 Quantity NUMERIC 20 8 +
GLRJ Revenue Recognition Day Book Journal GLRJ026 Unitcode INT 4   +
GLRJ Revenue Recognition Day Book Journal GLRJ027 Amountccu NUMERIC 20 8 +
GLRJ Revenue Recognition Day Book Journal GLRJ028 Contraacc NCHAR 13   +
GLRJ Revenue Recognition Day Book Journal GLRJ029 Journalno NUMERIC 6   +
GLRJ Revenue Recognition Day Book Journal GLRJ030 Plreference NCHAR 9   +
GLRJ Revenue Recognition Day Book Journal GLRJ031 Subprjcode NCHAR 6   +
GLRJ Revenue Recognition Day Book Journal GLRJ032 Activitycode NCHAR 6   +
GLRJ Revenue Recognition Day Book Journal GLRJ033 Usridupdby NCHAR 8   +
GLRJ Revenue Recognition Day Book Journal GLRJ034 Dateofentry DATETIME 8   +
GLRJ Revenue Recognition Day Book Journal GLRJ035 Usridentby NCHAR 8   +
GLRJ Revenue Recognition Day Book Journal GLRJ036 Dateofupd DATETIME 8   +
GLRJ Revenue Recognition Day Book Journal GLRJ037 Trantxtocu NVARCHAR 100   +
GLRJ Revenue Recognition Day Book Journal GLRJ038 SourceCompany NCHAR 2   +
GLRJ Revenue Recognition Day Book Journal GLRJ039 Source Module NCHAR 2   +
GLRJ Revenue Recognition Day Book Journal GLRJ040 Usridprnby NCHAR 8   +
GLRJ Revenue Recognition Day Book Journal GLRJ041 Dateofprn DATETIME 8   +
GLRJ Revenue Recognition Day Book Journal GLRJ042 PrnStatus NCHAR 1   +
GLRJ Revenue Recognition Day Book Journal GLRJ043 AAScode NVARCHAR 25   +
GLRM Revenue Recognition Model Codes GLRM001 Revenue Recognition Model NCHAR 3   +
GLRM Revenue Recognition Model Codes GLRM002 Description NVARCHAR 50   +
GLRM Revenue Recognition Model Codes GLRM003 Type INT 1   +
GLRM Revenue Recognition Model Codes GLRM004 Module NCHAR 2   +
GLRM Revenue Recognition Model Codes GLRM005 Revenue Distribution Rule INT 1   +
GLRM Revenue Recognition Model Codes GLRM006 Revenue Calculation Algorithm INT 1   +
GLRM Revenue Recognition Model Codes GLRM007 Cost Model INT 1   +
GLRM Revenue Recognition Model Codes GLRM008 Period Unit INT 1   +
GLRM Revenue Recognition Model Codes GLRM009 Switch5 (reserved) INT 1   +
GLRM Revenue Recognition Model Codes GLRM010 Switch6 (reserved) INT 1   +
GLRM Revenue Recognition Model Codes GLRM011 Threshold NUMERIC 14 8 +
GLRM Revenue Recognition Model Codes GLRM012 Price List NCHAR 2   +
GLRR Revenue Recognition GLRR001 Object Type INT 2   +
GLRR Revenue Recognition GLRR002 Object ID NVARCHAR 12   +
GLRR Revenue Recognition GLRR003 Object Extended ID NVARCHAR 50   +
GLRR Revenue Recognition GLRR004 Recognition Number NCHAR 10   +
GLRR Revenue Recognition GLRR005 Revision INT 1   +
GLRR Revenue Recognition GLRR006 Recognition Date DATETIME 8   +
GLRR Revenue Recognition GLRR007 Model Type NCHAR 3   +
GLRR Revenue Recognition GLRR008 Book Entry Date DATETIME 8   +
GLRR Revenue Recognition GLRR009 Currency Code NCHAR 2   +
GLRR Revenue Recognition GLRR010 Value Total, OCU NUMERIC 20 8 +
GLRR Revenue Recognition GLRR011 Value Total, LCU NUMERIC 20 8 +
GLRR Revenue Recognition GLRR012 Recognized Revenue, OCU NUMERIC 20 8 +
GLRR Revenue Recognition GLRR013 Recognized Revenue, LCU NUMERIC 20 8 +
GLRR Revenue Recognition GLRR014 Billing Total, OCU NUMERIC 20 8 +
GLRR Revenue Recognition GLRR015 Billing Total, LCU NUMERIC 20 8 +
GLRR Revenue Recognition GLRR016 Cost Total, LCU NUMERIC 20 8 +
GLRR Revenue Recognition GLRR017 Recognized Cost, LCU NUMERIC 20 8 +
GLRR Revenue Recognition GLRR018 Unearned Revenue Total, LCU NUMERIC 20 8 +
GLRR Revenue Recognition GLRR019 Unbilled Revenue Total, LCU NUMERIC 20 8 +
GLRR Revenue Recognition GLRR020 Total Duration NUMERIC 14 8 +
GLRR Revenue Recognition GLRR021 Current Duration NUMERIC 14 8 +
GLRR Revenue Recognition GLRR022 Duration Unit INT 1   +
GLRR Revenue Recognition GLRR023 GL Accounting Period NCHAR 4   +
GLRR Revenue Recognition GLRR024 Date-time stamp DATETIME 17   +
GLRR Revenue Recognition GLRR025 User ID NCHAR 8   +
GLRR Revenue Recognition GLRR026 GL Transaction Number NCHAR 9   +
GLRR Revenue Recognition GLRR027 GL Transaction Date DATETIME 8   +
GLRR Revenue Recognition GLRR028 Expected Gross Profit, LCU NUMERIC 20 8 +
GLRR Revenue Recognition GLRR029 Warranty Estimated Cost, LCU NUMERIC 20 8 +
GLRR Revenue Recognition GLRR030 Warranty Actual Cost, LCU NUMERIC 20 8 +
GLRR Revenue Recognition GLRR031 Warranty Reserve, LCU NUMERIC 20 8 +
GLTH GL Transaction Header GLTH001 Transaction Number NCHAR 9   +
GLTH GL Transaction Header GLTH002 Transformation status NCHAR 1   +
GLTM Transaction Mapping GLTM001 Transaction Code NVARCHAR 10   +
GLTM Transaction Mapping GLTM002 Transaction Sub Code NVARCHAR 10   +
GLTM Transaction Mapping GLTM003 Debit Acc String NVARCHAR 120   +
GLTM Transaction Mapping GLTM004 Credit Acc String NVARCHAR 120   +
GLTR GL Transformation Rule GLTR001 Rule ID NCHAR 4   +
GLTR GL Transformation Rule GLTR002 Description NVARCHAR 50   +
GLTR GL Transformation Rule GLTR003 Acc String 1 NVARCHAR 120   +
GLTR GL Transformation Rule GLTR004 Acc String 2 NVARCHAR 120   +
GLTR GL Transformation Rule GLTR005 Sort Order INT 4   +
GLTR GL Transformation Rule GLTR006 Transaction Types NVARCHAR 100   +
GLTR GL Transformation Rule GLTR007 Source Modules NVARCHAR 100   +
GLTR GL Transformation Rule GLTR008 Journal Code NVARCHAR 6   +
GLXX Wrk. Acc.Spec. GLXX004 CodingString NVARCHAR 120   50  
GLXX Wrk. Acc.Spec. GLXX005 RunningCount NVARCHAR 9   8  
GLXX Wrk. Acc.Spec. GLXX006 TransactNo NVARCHAR 9   6  
GLXX Wrk. Acc.Spec. GLXX007 TransactText NVARCHAR 100   25  
GLXX Wrk. Acc.Spec. GLXX009 ContraAcc NVARCHAR 13   12  
GLXX Wrk. Acc.Spec. GLXX012 OfficialTransactNo NCHAR 9   +
GLXX Wrk. Acc.Spec. GLXX013 Customer/Supplier Code NCHAR 10   +
GLXX Wrk. Acc.Spec. GLXX014 Invoice Number NCHAR 25   +
GLZZ Hyperion Export Parameters GLZZ001 Report Type NCHAR 1   +
GLZZ Hyperion Export Parameters GLZZ002 Layout NCHAR 1   +
GLZZ Hyperion Export Parameters GLZZ003 Parameter ID INT 4   +
GLZZ Hyperion Export Parameters GLZZ004 Parameter Value NVARCHAR 50   +