ARREGISTER

⚠️ 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	387,618
Columns	126

Columns

#	Column	Type	Nullable	Default	Description
1	_FIVETRAN_SYNCED	TIMESTAMP_TZ	✅	—	—
2	DISC_TAKEN	FLOAT	✅	—	—
3	PRINT_CEG_THIRD_PARTY_TYPE	TEXT	✅	—	—
4	INTERNAL_DOC_TYPE	TEXT	✅	—	—
5	FROM_SCHEDULE	BOOLEAN	✅	—	—
6	IS_UNDER_CORRECTION	BOOLEAN	✅	—	—
7	DOCUMENT_KEY	TEXT	✅	—	—
8	IS_RETAINAGE_REVERSING	BOOLEAN	✅	—	—
9	APPROVED	BOOLEAN	✅	—	—
10	HAS_PPDTAXES	BOOLEAN	✅	—	—
11	BATCH_NBR	TEXT	✅	—	—
12	LINE_RETAINAGE_TOTAL	FLOAT	✅	—	—
13	CURY_ORIG_DOC_AMT	FLOAT	✅	—	—
14	DOC_DESC	TEXT	✅	—	—
15	ARACCOUNT_ID	NUMBER	✅	—	—
16	RELEASED	BOOLEAN	✅	—	—
17	DOC_DISC	FLOAT	✅	—	—
18	IS_RETAINAGE_DOCUMENT	BOOLEAN	✅	—	—
19	DONT_EMAIL	BOOLEAN	✅	—	—
20	DISC_BAL	FLOAT	✅	—	—
21	RETAINAGE_UNRELEASED_AMT	FLOAT	✅	—	—
22	CURY_ORIG_DISC_AMT	FLOAT	✅	—	—
23	LAST_MODIFIED_BY_SCREEN_ID	TEXT	✅	—	—
24	RGOLAMT	FLOAT	✅	—	—
25	CANCELED	BOOLEAN	✅	—	—
26	PRINTED	BOOLEAN	✅	—	—
27	OPEN_DOC	BOOLEAN	✅	—	—
28	IS_MIGRATED_RECORD	BOOLEAN	✅	—	—
29	CHARGE_AMT	FLOAT	✅	—	—
30	TRAN_PERIOD_ID	NUMBER	✅	—	—
31	CURY_ORIG_DOC_AMT_WITH_RETAINAGE_TOTAL	FLOAT	✅	—	—
32	RETAINAGE_PAID_TOTAL	FLOAT	✅	—	—
33	REF_NBR	TEXT	✅	—	—
34	STATUS	TEXT	✅	—	—
35	DISPLAY_CURY_INIT_DOC_BAL	FLOAT	✅	—	—
36	RETAINED_DISC_TOTAL	FLOAT	✅	—	—
37	ADJ_CNTR	NUMBER	✅	—	—
38	CURY_DOC_BAL	FLOAT	✅	—	—
39	ORIG_DOC_AMT	FLOAT	✅	—	—
40	DISCOUNTED_PRICE	FLOAT	✅	—	—
41	CREATED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
42	DEF_RETAINAGE_PCT	FLOAT	✅	—	—
43	REF_NOTE_ID	TEXT	✅	—	—
44	ROUND_DIFF	FLOAT	✅	—	—
45	RETAINAGE_RELEASED	FLOAT	✅	—	—
46	ORIG_REF_NBR	TEXT	✅	—	—
47	CUSTOMER_LOCATION_ID	NUMBER	✅	—	—
48	CURY_LINE_RETAINAGE_TOTAL	FLOAT	✅	—	—
49	CURY_DISCOUNTED_DOC_TOTAL	FLOAT	✅	—	—
50	ORIG_DOC_DATE	TIMESTAMP_TZ	✅	—	—
51	ARSUB_ID	NUMBER	✅	—	—
52	NOTE_ID	TEXT	✅	—	—
53	CLOSED_FIN_PERIOD_ID	NUMBER	✅	—	—
54	RETAINAGE_UNPAID_TOTAL	FLOAT	✅	—	—
55	CURY_RETAINED_TAX_TOTAL	FLOAT	✅	—	—
56	EMAILED	BOOLEAN	✅	—	—
57	CURY_DISC_TAKEN	FLOAT	✅	—	—
58	CEG_THIRD_PARTY_TYPE	TEXT	✅	—	—
59	CURY_RETAINAGE_UNPAID_TOTAL	FLOAT	✅	—	—
60	PRINT_DOC_TYPE	TEXT	✅	—	—
61	ORIG_MODULE	TEXT	✅	—	—
62	CURY_DOC_DISC	FLOAT	✅	—	—
63	IS_TAX_VALID	BOOLEAN	✅	—	—
64	CURY_RETAINED_DISC_TOTAL	FLOAT	✅	—	—
65	CURY_CHARGE_AMT	FLOAT	✅	—	—
66	DISCOUNTED_TAXABLE_TOTAL	FLOAT	✅	—	—
67	DOC_DATE	TIMESTAMP_TZ	✅	—	—
68	BATCH_SEQ	NUMBER	✅	—	—
69	CURY_ROUND_DIFF	FLOAT	✅	—	—
70	FIN_PERIOD_ID	NUMBER	✅	—	—
71	CUSTOMER_ID	NUMBER	✅	—	—
72	NOTE_TEXT	TEXT	✅	—	—
73	DOC_BAL	FLOAT	✅	—	—
74	LINE_CNTR	NUMBER	✅	—	—
75	CLOSED_DATE	TIMESTAMP_TZ	✅	—	—
76	ORIG_DOC_AMT_WITH_RETAINAGE_TOTAL	FLOAT	✅	—	—
77	IS_TAX_POSTED	BOOLEAN	✅	—	—
78	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
79	IS_CANCELLATION	BOOLEAN	✅	—	—
80	RETAINAGE_APPLY	BOOLEAN	✅	—	—
81	RETAINED_TAX_TOTAL	FLOAT	✅	—	—
82	CURY_INFO_ID	NUMBER	✅	—	—
83	HOLD	BOOLEAN	✅	—	—
84	CURY_DISCOUNTED_PRICE	FLOAT	✅	—	—
85	DONT_PRINT	BOOLEAN	✅	—	—
86	LAST_MODIFIED_BY_ID	TEXT	✅	—	—
87	DOC_CLASS	TEXT	✅	—	—
88	VOIDED	BOOLEAN	✅	—	—
89	INIT_DOC_BAL	FLOAT	✅	—	—
90	PENDING_PAYMENT	BOOLEAN	✅	—	—
91	LAST_MODIFIED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
92	NON_TAXABLE	BOOLEAN	✅	—	—
93	IS_TAX_SAVED	BOOLEAN	✅	—	—
94	PRINT_INVOICE	BOOLEAN	✅	—	—
95	DRSCHED_CNTR	NUMBER	✅	—	—
96	TSTAMP	TEXT	✅	—	—
97	DELETED_DATABASE_RECORD	BOOLEAN	✅	—	—
98	ORIG_DISC_AMT	FLOAT	✅	—	—
99	CURY_DISC_BAL	FLOAT	✅	—	—
100	CREATED_BY_ID	TEXT	✅	—	—
101	PENDING_PROCESSING	BOOLEAN	✅	—	—
102	CURY_RETAINAGE_RELEASED	FLOAT	✅	—	—
103	CURY_RETAINAGE_TOTAL	FLOAT	✅	—	—
104	REJECTED	BOOLEAN	✅	—	—
105	CREATED_BY_SCREEN_ID	TEXT	✅	—	—
106	SCHEDULED	BOOLEAN	✅	—	—
107	CURY_RETAINAGE_UNRELEASED_AMT	FLOAT	✅	—	—
108	CURY_DOC_UNPAID_BAL	FLOAT	✅	—	—
109	DOC_TYPE	TEXT	✅	—	—
110	ORIG_DOC_TYPE	TEXT	✅	—	—
111	CLOSED_TRAN_PERIOD_ID	NUMBER	✅	—	—
112	CURY_INIT_DOC_BAL	FLOAT	✅	—	—
113	CURY_RETAINAGE_PAID_TOTAL	FLOAT	✅	—	—
114	CURY_ID	TEXT	✅	—	—
115	RETAINAGE_TOTAL	FLOAT	✅	—	—
116	TAX_CALC_MODE	BOOLEAN	✅	—	—
117	DISCOUNTED_DOC_TOTAL	FLOAT	✅	—	—
118	BRANCH_ID	NUMBER	✅	—	—
119	IS_CORRECTION	BOOLEAN	✅	—	—
120	SELF_VOIDING_DOC	BOOLEAN	✅	—	—
121	PENDING_PPD	BOOLEAN	✅	—	—
122	DUE_DATE	TIMESTAMP_TZ	✅	—	—
123	EMAIL_INVOICE	BOOLEAN	✅	—	—
124	CEG_THIRD_PARTY_TYPE_PRINT	TEXT	✅	—	—
125	DONT_APPROVE	BOOLEAN	✅	—	—
126	CURY_DISCOUNTED_TAXABLE_TOTAL	FLOAT	✅	—	—