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