Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица GL06 — General Ledger Transactions — О системах планирования ресурсов предприятия Scala, iScala

Таблица: GL06 — «Transactions». Маска имени таблицы: «GL06%cc%yy»

Поле	Тип поля	Тип поля Scala	Длина поля	Точность	Длина Scala	Комментарий	Расширенный комментарий	Дополнительное описание	Позиция в индексе	Первичный ключ?
GL06001	NVARCHAR	ACCSTR	50	0	50	AccStrLCU	Accounting String
GL06002	NCHAR	STRING	9	0	9	TransactionNo	Transaction Number
GL06003	DATETIME	DATE	0	0	8	TransactionDate	Transaction Date
GL06004	NUMERIC	MONEY	28	8	20	AmountLCU	Amount (Local Currency)
GL06005	NVARCHAR	VSTRING	36	0	36	TransactTxt	Transaction Text
GL06006	NVARCHAR	VSTRING	10	0	10	CustCode	Customer/Supplier Code	Information depends on GL06012: 3 or 4 — Customer Code 5 or 6 — Supplier Code
GL06007	NVARCHAR	VSTRING	25	0	25	CodeString	Document Number	Information depends on GL06012: 3 or 4 — Customer Invoice Number 5 or 6 — Supplier Invoice Number Other — Document Number
GL06008	NVARCHAR	VSTRING	6	0	6	JournalCode	Journal Code
GL06009	NCHAR	STRING	1	0	1	PeriodAlloc	Period Allocation	0 — Period allocation has not been executed for the transaction line 1 — Period allocation has been executed for the transaction line 2 — (used with analytical ledger) 3 — (used with analytical ledger)
GL06010	NCHAR	STRING	1	0	1	ProjectUpd	Project Updated	0 — Project Management has not been updated with the transaction line (GL06028 holds a project activity line) 1 — Project Management has been updated with the transaction line (GL06028 holds a project activity line) 2 — Project Management has not been updated with the transaction line (GL06028 holds an activity code) 3 — Project Management has been updated with the transaction line (GL06028 holds an activity code)
GL06011	NCHAR	STRING	1	0	1	CurrTrans	Currency Transaction	0 — Standard value 1 — Transaction line is a currency revaluation transaction line 2 — Transaction line is in closing period
GL06012	BINARY	BINSTRING	1	0	1	TransType	Transaction Type	/ — Opening Balances 0 — Manual Transaction in General Ledger 1 — Reversal Transaction in General Ledger 2 — Accrued Transaction (Periodic Allocation) 3 — Customer Invoice (From Sales Ledger) 4 — Customer Payment (From Sales Ledger) 5 — Supplier Invoice (From Purchase Ledger) 6 — Supplier Payment (From Purchase Ledger) 7 — Depreciation Transaction (From Asset Management) 8 — Automatic Period Allocation 9 — Transaction from Project Management A — Transaction from Payroll B — Transaction from Stock Journal C — Transaction from Promissory Notes D — Petty Cash Transaction K — Fixed Assets Revaluation Transaction L — Cash-Books Transaction M — Transaction from MPC WIP Journal S — Transaction from Source Company (Consolidation) T — Temporary Cheques Transactions (Day-Book Journal) U — Budget Alternative 1 V — Budget Alternative 2 W — Budget Alternative 3 X — Budget Alternative 4 Y — Budget Alternative 5 Z — Budget Previous Year \ — Reporting Level Transaction Opening balances a — Reporting Level Transaction c — Reporting Level Transaction Budget Alternative 1 d — Reporting Level Transaction Budget Alternative 2 e — Reporting Level Transaction Budget Alternative 3 f — Reporting Level Transaction Budget Alternative 4 g — Reporting Level Transaction Budget Alternative 5 h — Reporting Level Transaction Budget Previous Year i — Closing Period Transaction j — Reporting Level Closing Period Transaction k — Year End Closing Transaction \| — Transferred Open Balances of Currency Accounts
GL06013	NVARCHAR	VSTRING	8	0	8	UserIDUpdatedBy	User Id for Update
GL06014	DATETIME	DATE	0	0	8	EntryDate	Date Entered
GL06015	NCHAR	STRING	13	0	13	ContraAccount	Contra Account
GL06016	NCHAR	STRING	9	0	9	RunningCount	Index Key		1	Да
GL06017	NCHAR	STRING	1	0	1	TransactSign	Transaction Sign	0 — Normal Sign (+ debit, — credit) 1 — Reversed Sign (+ credit, — debit)
GL06018	NUMERIC	MONEY	28	8	20	AmountOCU	Amount (Document Currency)
GL06019	NCHAR	STRING	2	0	2	CurrencyCode	Currency Code
GL06020	NUMERIC	X_NUMERIC	28	8	20	Quantity	Quantity
GL06021	INT	INTEGER	0	0	4	UnitCode	Unit Code
GL06022	NUMERIC	MONEY	28	8	20	AmountCCU	Amount (Alternative Currency)
GL06023	NVARCHAR	VSTRING	9	0	9	JournalNumber	Journal Number
GL06024	NCHAR	STRING	9	0	9	PLReference	Purchase Invoice Reference Number
GL06025	NCHAR	STRING	8	0	8	EntByUser	Name of Entry User
GL06026	DATETIME	DATE	0	0	8	DateOfUpdate	Date Updated
GL06027	NCHAR	STRING	6	0	6	SubProjectCode	Sub-project Code
GL06028	NCHAR	STRING	6	0	6	ActivityCode	Activity Code
GL06029	NCHAR	STRING	9	0	9	LegalTransNo	Legal Transaction Number
GL06030	NCHAR	STRING	8	0	8	ConsolidFlags	Compound Allocation Flags	A string of 8 characters where each character is a flag between 0 and 3 and it’s used to select if the transaction line shall be selected when running the compound allocation.
GL06031	NCHAR	STRING	9	0	9	LinkdRecCnt	Linked Transaction Line (EMU Conversion)
GL06032	NVARCHAR	VSTRING	12	0	12	ConsSourceAccount	Consolidation Source Account
GL06033	NUMERIC	MONEY	28	8	20	ConsSourceAmount	Consolidation Source Amount
GL06034	NCHAR	STRING	3	0	3	ConsSourceCurrName	Consolidation Source Currency Name
GL06035	NVARCHAR	VSTRING	15	0	15	GLDrillDownInformation	General Ledger Drill Down Information	Link to journal transaction number in stock control (SCGL)
GL06036	INT	INTEGER	0	0	1	GLExportFlag	GL Export Flag
GL06037	NCHAR	STRING	2	0	2	SourceCompany	Source Company
GL06038	NCHAR	STRING	2	0	2	SourceModule	Source Module
GL06039	NCHAR	STRING	8	0	8	UserIDPrintedBy	Printed By
GL06040	DATETIME	DATE	0	0	8	DateOfPrint	Date Printed
GL06041	NVARCHAR	VSTRING	6	0	6	TaxCode	TaxCode
GL06042	DATETIME	X_DATETIME	0	0	17	PostingDateTime	Posting Date/Time

История изменения структуры таблицы / Table structure changes history:

Поле / Field	iScala 2.2 HF 2.3318		iScala 2.3		iScala 2.3 SR1		iScala 2.3 SR2		iScala 2.3 SR3		iScala 3.0 FSP2		iScala 3.0 FSP4
Поле / Field	Длина поля / Field length	Длина iScala / iScala length	Длина поля / Field length	Длина iScala / iScala length	Длина поля / Field length	Длина iScala / iScala length	Длина поля / Field length	Длина iScala / iScala length	Длина поля / Field length	Длина iScala / iScala length	Длина поля / Field length	Длина iScala / iScala length	Длина поля / Field length	Длина iScala / iScala length
GL06002	6	6	6	6	6	6	9	9	9	9	9	9	9	9
GL06005	25	25	25	25	25	25	25	25	25	25	36	36	36	36
GL06007	23	23	23	23	23	23	23	23	23	23	25	25	25	25
GL06016	8	8	8	8	8	8	9	9	9	9	9	9	9	9
GL06021	2	2	2	2	0	4	0	4	0	4	0	4	0	4
GL06023	6	6	6	6	6	6	9	9	9	9	9	9	9	9
GL06024	6	6	6	6	6	6	6	6	9	9	9	9	9	9
GL06029	6	6	6	6	6	6	9	9	9	9	9	9	9	9
GL06031	8	8	8	8	8	8	9	9	9	9	9	9	9	9
GL06036	—	—	0	1	0	1	0	1	0	1	0	1	0	1
GL06037	—	—	2	2	2	2	2	2	2	2	2	2	2	2
GL06038	—	—	2	2	2	2	2	2	2	2	2	2	2	2
GL06039	—	—	8	8	8	8	8	8	8	8	8	8	8	8
GL06040	—	—	0	8	0	8	0	8	0	8	0	8	0	8
GL06041	—	—	—	—	—	—	—	—	—	—	6	6	6	6
GL06042	—	—	—	—	—	—	—	—	—	—	0	17	0	17

Навигация:

Изменение полей в таблицах БД iScala 3.4 по сравнению с iScala 3.2 / Difference between DB structure of iScala 3.4 and iScala 3.2
Изменение полей в таблицах БД iScala 3.5 по сравнению с iScala 2.2 / Difference between DB structure of iScala 3.5 and iScala 2.2
Изменение структуры таблиц iScala 3.1 по сравнению с iScala 3.0 FSP4 / Table structure changes between iScala 3.0 FSP4 and iScala 3.1
История изменения структуры таблиц разных версий iScala / Tables structure changes history from iScala 2.2 SR2 to iScala 3.0 FSP4
Структура таблиц / Table structure Epicor iScala 3.0 FSP4 — 3.0.4267
Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419
Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399
Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0.0429