GLTRAN

⚠️ Auto-generated — do not edit this file directly. Re-run python scripts/generate_docs.py to refresh it.

Info

Property	Value
Source	CEGID
Database	RESILIANS_CEGID_DB
Schema	STG_DBO
Layer	🪙 Staging
Type	BASE TABLE
Rows	4,160,420
Columns	73

Columns

#	Column	Type	Nullable	Default	Description
1	BATCH_NBR	TEXT	✅	—	—
2	LINE_NBR	NUMBER	❌	—	—
3	MODULE	TEXT	✅	—	—
4	_FIVETRAN_SYNCED	TIMESTAMP_TZ	✅	—	—
5	REFERENCE_ID	NUMBER	✅	—	—
6	DEBIT_AMT	FLOAT	✅	—	—
7	TRAN_DESC	TEXT	✅	—	—
8	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
9	RECLASSIFIED	BOOLEAN	✅	—	—
10	CURY_CREDIT_AMT	FLOAT	✅	—	—
11	CURY_INFO_ID	NUMBER	✅	—	—
12	UOM	TEXT	✅	—	—
13	PROJECT_ID	NUMBER	✅	—	—
14	RECLASS_SOURCE_TRAN_BATCH_NBR	TEXT	✅	—	—
15	LAST_MODIFIED_BY_ID	TEXT	✅	—	—
16	POST_YEAR	NUMBER	✅	—	—
17	RECLASS_TYPE	TEXT	✅	—	—
18	LEDGER_ID	NUMBER	✅	—	—
19	TAX_CATEGORY_ID	TEXT	✅	—	—
20	LAST_MODIFIED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
21	RELEASED	BOOLEAN	✅	—	—
22	SUMM_POST	BOOLEAN	✅	—	—
23	CURY_RECLASS_REMAINING_AMT	FLOAT	✅	—	—
24	RECLASSIFICATION_PROHIBITED	BOOLEAN	✅	—	—
25	RECLASS_BATCH_NBR	TEXT	✅	—	—
26	INVENTORY_ID	NUMBER	✅	—	—
27	SUB_ID	NUMBER	✅	—	—
28	TRAN_CLASS	TEXT	✅	—	—
29	IS_RECLASS_REVERSE	BOOLEAN	✅	—	—
30	LAST_MODIFIED_BY_SCREEN_ID	TEXT	✅	—	—
31	RECLASS_ORIG_TRAN_DATE	TIMESTAMP_TZ	✅	—	—
32	ORIG_ACCOUNT_ID	NUMBER	✅	—	—
33	TSTAMP	TEXT	✅	—	—
34	RECLASS_SEQ_NBR	NUMBER	✅	—	—
35	TRAN_PERIOD_ID	NUMBER	✅	—	—
36	QTY	FLOAT	✅	—	—
37	REF_NBR	TEXT	✅	—	—
38	ORIG_LINE_NBR	NUMBER	✅	—	—
39	NEXT_POST_YEAR	NUMBER	✅	—	—
40	CREATED_BY_ID	TEXT	✅	—	—
41	CATRAN_ID	NUMBER	✅	—	—
42	RECLASS_RELEASED_COUNT	NUMBER	✅	—	—
43	CREATED_BY_SCREEN_ID	TEXT	✅	—	—
44	IS_NON_PM	BOOLEAN	✅	—	—
45	TRAN_ID	NUMBER	✅	—	—
46	MATCHING	TEXT	✅	—	—
47	POSTED	BOOLEAN	✅	—	—
48	CREATED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
49	MATCHING_DATE	TIMESTAMP_TZ	✅	—	—
50	BRANCH_ID	NUMBER	✅	—	—
51	IS_INTER_COMPANY	BOOLEAN	✅	—	—
52	CEG_ADDITIONAL_REFERENCE	TEXT	✅	—	—
53	NEXT_TRAN_YEAR	NUMBER	✅	—	—
54	RECLASS_TOTAL_COUNT	NUMBER	✅	—	—
55	CREDIT_AMT	FLOAT	✅	—	—
56	NOTE_ID	TEXT	✅	—	—
57	TRAN_DATE	TIMESTAMP_TZ	✅	—	—
58	CURY_DEBIT_AMT	FLOAT	✅	—	—
59	TRAN_TYPE	TEXT	✅	—	—
60	RECLASS_SOURCE_TRAN_MODULE	TEXT	✅	—	—
61	ORIG_BATCH_NBR	TEXT	✅	—	—
62	ORIG_SUB_ID	NUMBER	✅	—	—
63	ORIG_MODULE	TEXT	✅	—	—
64	RECLASS_SOURCE_TRAN_LINE_NBR	NUMBER	✅	—	—
65	TRAN_LINE_NBR	NUMBER	✅	—	—
66	ACCOUNT_ID	NUMBER	✅	—	—
67	FIN_PERIOD_ID	NUMBER	✅	—	—
68	RECLASS_BATCH_MODULE	TEXT	✅	—	—
69	MATCHING_PARTIAL	BOOLEAN	✅	—	—
70	RECLASS_REMAINING_AMT	FLOAT	✅	—	—
71	TRAN_YEAR	NUMBER	✅	—	—
72	NOTE_TEXT	TEXT	✅	—	—
73	TAX_ID	TEXT	✅	—	—