BATCH

⚠️ 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	1,460,331
Columns	52

Columns

#	Column	Type	Nullable	Default	Description
1	BATCH_NBR	TEXT	✅	—	—
2	MODULE	TEXT	✅	—	—
3	_FIVETRAN_SYNCED	TIMESTAMP_TZ	✅	—	—
4	REQUIRE_POST	BOOLEAN	✅	—	—
5	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
6	HOLD	BOOLEAN	✅	—	—
7	CURY_INFO_ID	NUMBER	✅	—	—
8	APPROVED	BOOLEAN	✅	—	—
9	LAST_MODIFIED_BY_ID	TEXT	✅	—	—
10	DRAFT	BOOLEAN	✅	—	—
11	DATE_ENTERED	TIMESTAMP_TZ	✅	—	—
12	CURY_DEBIT_TOTAL	FLOAT	✅	—	—
13	BATCH_TYPE	TEXT	✅	—	—
14	VOIDED	BOOLEAN	✅	—	—
15	LEDGER_ID	NUMBER	✅	—	—
16	LAST_MODIFIED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
17	RELEASED	BOOLEAN	✅	—	—
18	AUTO_REVERSE_COPY	BOOLEAN	✅	—	—
19	CREATE_TAX_TRANS	BOOLEAN	✅	—	—
20	LAST_MODIFIED_BY_SCREEN_ID	TEXT	✅	—	—
21	CEG_IS_SOYEAR_CLOSING_BATCH_ENTRY	BOOLEAN	✅	—	—
22	TSTAMP	TEXT	✅	—	—
23	AUTO_REVERSE	BOOLEAN	✅	—	—
24	DELETED_DATABASE_RECORD	BOOLEAN	✅	—	—
25	TRAN_PERIOD_ID	NUMBER	✅	—	—
26	CREATED_BY_ID	TEXT	✅	—	—
27	STATUS	TEXT	✅	—	—
28	REJECTED	BOOLEAN	✅	—	—
29	SCHEDULED	BOOLEAN	✅	—	—
30	CREATED_BY_SCREEN_ID	TEXT	✅	—	—
31	DESCRIPTION	TEXT	✅	—	—
32	POST_ERROR_COUNT	NUMBER	✅	—	—
33	CONTROL_TOTAL	FLOAT	✅	—	—
34	CURY_ID	TEXT	✅	—	—
35	POSTED	BOOLEAN	✅	—	—
36	CREATED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
37	SKIP_TAX_VALIDATION	BOOLEAN	✅	—	—
38	DEBIT_TOTAL	FLOAT	✅	—	—
39	CEG_IS_POYEAR_CLOSING_BATCH_ENTRY	BOOLEAN	✅	—	—
40	BRANCH_ID	NUMBER	✅	—	—
41	CREDIT_TOTAL	FLOAT	✅	—	—
42	NOTE_ID	TEXT	✅	—	—
43	CURY_CREDIT_TOTAL	FLOAT	✅	—	—
44	ATTRIBUTE_NUMFEC	TEXT	✅	—	—
45	ORIG_BATCH_NBR	TEXT	✅	—	—
46	ORIG_MODULE	TEXT	✅	—	—
47	CURY_CONTROL_TOTAL	FLOAT	✅	—	—
48	CEG_SUBLEDGER	NUMBER	✅	—	—
49	DONT_APPROVE	BOOLEAN	✅	—	—
50	FIN_PERIOD_ID	NUMBER	✅	—	—
51	NOTE_TEXT	TEXT	✅	—	—
52	LINE_CNTR	NUMBER	✅	—	—