APREGISTER

⚠️ 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	RAW_DBO
Layer	🟤 Raw
Type	BASE TABLE
Rows	356,273
Columns	132

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	IS_RETAINAGE_REVERSING	BOOLEAN	✅	—	—
6	APPROVED	BOOLEAN	✅	—	—
7	HAS_PPDTAXES	BOOLEAN	✅	—	—
8	BATCH_NBR	TEXT	✅	—	—
9	LINE_RETAINAGE_TOTAL	FLOAT	✅	—	—
10	CURY_ORIG_DOC_AMT	FLOAT	✅	—	—
11	DOC_DESC	TEXT	✅	—	—
12	RELEASED	BOOLEAN	✅	—	—
13	DOC_DISC	FLOAT	✅	—	—
14	IS_RETAINAGE_DOCUMENT	BOOLEAN	✅	—	—
15	DISC_BAL	FLOAT	✅	—	—
16	CURY_TAX_WHELD	FLOAT	✅	—	—
17	RETAINAGE_UNRELEASED_AMT	FLOAT	✅	—	—
18	CURY_ORIG_DISC_AMT	FLOAT	✅	—	—
19	WH_TAX_BAL	FLOAT	✅	—	—
20	LAST_MODIFIED_BY_SCREEN_ID	TEXT	✅	—	—
21	RGOLAMT	FLOAT	✅	—	—
22	RETAINAGE_ACCT_ID	NUMBER	✅	—	—
23	PRINTED	BOOLEAN	✅	—	—
24	OPEN_DOC	BOOLEAN	✅	—	—
25	RETAINAGE_SUB_ID	NUMBER	✅	—	—
26	IS_MIGRATED_RECORD	BOOLEAN	✅	—	—
27	CHARGE_AMT	FLOAT	✅	—	—
28	TRAN_PERIOD_ID	NUMBER	✅	—	—
29	CURY_ORIG_DOC_AMT_WITH_RETAINAGE_TOTAL	FLOAT	✅	—	—
30	RETAINAGE_PAID_TOTAL	FLOAT	✅	—	—
31	VENDOR_ID	NUMBER	✅	—	—
32	REF_NBR	TEXT	✅	—	—
33	USR_ACQUITTE	BOOLEAN	✅	—	—
34	PREBOOKED	BOOLEAN	✅	—	—
35	STATUS	TEXT	✅	—	—
36	DISPLAY_CURY_INIT_DOC_BAL	FLOAT	✅	—	—
37	RETAINED_DISC_TOTAL	FLOAT	✅	—	—
38	ADJ_CNTR	NUMBER	✅	—	—
39	CURY_DOC_BAL	FLOAT	✅	—	—
40	ORIG_DOC_AMT	FLOAT	✅	—	—
41	DISCOUNTED_PRICE	FLOAT	✅	—	—
42	CREATED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
43	DEF_RETAINAGE_PCT	FLOAT	✅	—	—
44	REF_NOTE_ID	TEXT	✅	—	—
45	ROUND_DIFF	FLOAT	✅	—	—
46	RETAINAGE_RELEASED	FLOAT	✅	—	—
47	ORIG_REF_NBR	TEXT	✅	—	—
48	CURY_WH_TAX_BAL	FLOAT	✅	—	—
49	CURY_LINE_RETAINAGE_TOTAL	FLOAT	✅	—	—
50	CURY_DISCOUNTED_DOC_TOTAL	FLOAT	✅	—	—
51	ORIG_DOC_DATE	TIMESTAMP_TZ	✅	—	—
52	NOTE_ID	TEXT	✅	—	—
53	CLOSED_FIN_PERIOD_ID	NUMBER	✅	—	—
54	RETAINAGE_UNPAID_TOTAL	FLOAT	✅	—	—
55	CURY_RETAINED_TAX_TOTAL	FLOAT	✅	—	—
56	CURY_DISC_TAKEN	FLOAT	✅	—	—
57	CEG_THIRD_PARTY_TYPE	TEXT	✅	—	—
58	CURY_RETAINAGE_UNPAID_TOTAL	FLOAT	✅	—	—
59	PRINT_DOC_TYPE	TEXT	✅	—	—
60	ORIG_MODULE	TEXT	✅	—	—
61	VENDOR_LOCATION_ID	NUMBER	✅	—	—
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	CURY_ROUND_DIFF	FLOAT	✅	—	—
69	FIN_PERIOD_ID	NUMBER	✅	—	—
70	NOTE_TEXT	TEXT	✅	—	—
71	DOC_BAL	FLOAT	✅	—	—
72	LINE_CNTR	NUMBER	✅	—	—
73	CLOSED_DATE	TIMESTAMP_TZ	✅	—	—
74	ORIG_DOC_AMT_WITH_RETAINAGE_TOTAL	FLOAT	✅	—	—
75	TAX_WHELD	FLOAT	✅	—	—
76	IS_TAX_POSTED	BOOLEAN	✅	—	—
77	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
78	USR_DWREFERENCE_DOC	TEXT	✅	—	—
79	RETAINAGE_APPLY	BOOLEAN	✅	—	—
80	CURY_ORIG_WH_TAX_AMT	FLOAT	✅	—	—
81	RETAINED_TAX_TOTAL	FLOAT	✅	—	—
82	APSUB_ID	NUMBER	✅	—	—
83	USR_DWSUJET	TEXT	✅	—	—
84	CURY_INFO_ID	NUMBER	✅	—	—
85	HOLD	BOOLEAN	✅	—	—
86	USR_IDDOCUWARE	NUMBER	✅	—	—
87	CURY_DISCOUNTED_PRICE	FLOAT	✅	—	—
88	LAST_MODIFIED_BY_ID	TEXT	✅	—	—
89	ORIG_WH_TAX_AMT	FLOAT	✅	—	—
90	DOC_CLASS	TEXT	✅	—	—
91	VOIDED	BOOLEAN	✅	—	—
92	INIT_DOC_BAL	FLOAT	✅	—	—
93	HAS_MULTIPLE_PROJECTS	BOOLEAN	✅	—	—
94	LAST_MODIFIED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
95	TAX_ROUND_DIFF	FLOAT	✅	—	—
96	NON_TAXABLE	BOOLEAN	✅	—	—
97	APACCOUNT_ID	NUMBER	✅	—	—
98	IS_TAX_SAVED	BOOLEAN	✅	—	—
99	IS_EXPECTED_PPVVALID	BOOLEAN	✅	—	—
100	USR_DWNUM_AFFAIRE	TEXT	✅	—	—
101	TSTAMP	TEXT	✅	—	—
102	DELETED_DATABASE_RECORD	BOOLEAN	✅	—	—
103	ORIG_DISC_AMT	FLOAT	✅	—	—
104	CURY_DISC_BAL	FLOAT	✅	—	—
105	USR_DWNUM_BDC	TEXT	✅	—	—
106	CREATED_BY_ID	TEXT	✅	—	—
107	CURY_RETAINAGE_RELEASED	FLOAT	✅	—	—
108	SCHEDULE_ID	TEXT	✅	—	—
109	CURY_RETAINAGE_TOTAL	FLOAT	✅	—	—
110	RELEASED_OR_PREBOOKED	BOOLEAN	✅	—	—
111	REJECTED	BOOLEAN	✅	—	—
112	CREATED_BY_SCREEN_ID	TEXT	✅	—	—
113	SCHEDULED	BOOLEAN	✅	—	—
114	CURY_RETAINAGE_UNRELEASED_AMT	FLOAT	✅	—	—
115	USR_DWIMMATRICULATION	TEXT	✅	—	—
116	DOC_TYPE	TEXT	✅	—	—
117	ORIG_DOC_TYPE	TEXT	✅	—	—
118	CLOSED_TRAN_PERIOD_ID	NUMBER	✅	—	—
119	CURY_INIT_DOC_BAL	FLOAT	✅	—	—
120	CURY_RETAINAGE_PAID_TOTAL	FLOAT	✅	—	—
121	CURY_ID	TEXT	✅	—	—
122	RETAINAGE_TOTAL	FLOAT	✅	—	—
123	CURY_TAX_ROUND_DIFF	FLOAT	✅	—	—
124	TAX_CALC_MODE	TEXT	✅	—	—
125	DISCOUNTED_DOC_TOTAL	FLOAT	✅	—	—
126	BRANCH_ID	NUMBER	✅	—	—
127	USR_URLDOCUWARE	TEXT	✅	—	—
128	PENDING_PPD	BOOLEAN	✅	—	—
129	CURY_DISC_TOT	FLOAT	✅	—	—
130	DISC_TOT	FLOAT	✅	—	—
131	DONT_APPROVE	BOOLEAN	✅	—	—
132	CURY_DISCOUNTED_TAXABLE_TOTAL	FLOAT	✅	—	—