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