APINVOICE

⚠️ 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	231,029
Columns	177

Columns

#	Column	Type	Nullable	Default	Description
1	_FIVETRAN_SYNCED	TIMESTAMP_TZ	✅	—	—
2	PAY_LOCATION_ID	NUMBER	✅	—	—
3	EXTERNAL_TAXES_IMPORT_IN_PROGRESS	BOOLEAN	✅	—	—
4	DISC_TAKEN	FLOAT	✅	—	—
5	PRINT_CEG_THIRD_PARTY_TYPE	TEXT	✅	—	—
6	INTERNAL_DOC_TYPE	TEXT	✅	—	—
7	RECLASSIFIED	BOOLEAN	✅	—	—
8	DOCUMENT_KEY	TEXT	✅	—	—
9	IS_RETAINAGE_REVERSING	BOOLEAN	✅	—	—
10	APPROVED	BOOLEAN	✅	—	—
11	HAS_PPDTAXES	BOOLEAN	✅	—	—
12	CURY_ORDER_DISC_TOTAL	FLOAT	✅	—	—
13	BATCH_NBR	TEXT	✅	—	—
14	LINE_RETAINAGE_TOTAL	FLOAT	✅	—	—
15	CURY_ORIG_DOC_AMT	FLOAT	✅	—	—
16	DOC_DESC	TEXT	✅	—	—
17	RELEASED	BOOLEAN	✅	—	—
18	DOC_DISC	FLOAT	✅	—	—
19	SEPARATE_CHECK	BOOLEAN	✅	—	—
20	IS_RETAINAGE_DOCUMENT	BOOLEAN	✅	—	—
21	DISC_BAL	FLOAT	✅	—	—
22	CURY_TAX_WHELD	FLOAT	✅	—	—
23	RETAINAGE_UNRELEASED_AMT	FLOAT	✅	—	—
24	CURY_TAX_TOTAL	FLOAT	✅	—	—
25	CURY_ORIG_DISC_AMT	FLOAT	✅	—	—
26	LINE_DISC_TOTAL	FLOAT	✅	—	—
27	WH_TAX_BAL	FLOAT	✅	—	—
28	LAST_MODIFIED_BY_SCREEN_ID	TEXT	✅	—	—
29	RGOLAMT	FLOAT	✅	—	—
30	RETAINAGE_ACCT_ID	NUMBER	✅	—	—
31	PRINTED	BOOLEAN	✅	—	—
32	OPEN_DOC	BOOLEAN	✅	—	—
33	RETAINAGE_SUB_ID	NUMBER	✅	—	—
34	IS_MIGRATED_RECORD	BOOLEAN	✅	—	—
35	TRAN_PERIOD_ID	NUMBER	✅	—	—
36	CURY_ORIG_DOC_AMT_WITH_RETAINAGE_TOTAL	FLOAT	✅	—	—
37	RETAINAGE_PAID_TOTAL	FLOAT	✅	—	—
38	CHARGE_AMT	FLOAT	✅	—	—
39	VENDOR_ID	NUMBER	✅	—	—
40	REF_NBR	TEXT	✅	—	—
41	CURY_DETAIL_EXT_PRICE_TOTAL	FLOAT	✅	—	—
42	USR_ACQUITTE	BOOLEAN	✅	—	—
43	PREBOOKED	BOOLEAN	✅	—	—
44	STATUS	TEXT	✅	—	—
45	DISPLAY_CURY_INIT_DOC_BAL	FLOAT	✅	—	—
46	PAY_DATE	TIMESTAMP_TZ	✅	—	—
47	TAX_TOTAL	FLOAT	✅	—	—
48	CURY_LINE_TOTAL	FLOAT	✅	—	—
49	RETAINED_DISC_TOTAL	FLOAT	✅	—	—
50	TERMS_ID	TEXT	✅	—	—
51	ORDER_DISC_TOTAL	FLOAT	✅	—	—
52	ADJ_CNTR	NUMBER	✅	—	—
53	CURY_DOC_BAL	FLOAT	✅	—	—
54	ORIG_DOC_AMT	FLOAT	✅	—	—
55	CEG_CREDIT_TOTAL	FLOAT	✅	—	—
56	INVOICE_DATE	TIMESTAMP_TZ	✅	—	—
57	DISCOUNTED_PRICE	FLOAT	✅	—	—
58	DEF_RETAINAGE_PCT	FLOAT	✅	—	—
59	CREATED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
60	RETAINAGE_RELEASED	FLOAT	✅	—	—
61	ROUND_DIFF	FLOAT	✅	—	—
62	VAT_EXEMPT_TOTAL	FLOAT	✅	—	—
63	ORIG_REF_NBR	TEXT	✅	—	—
64	PAY_SEL	BOOLEAN	✅	—	—
65	CURY_WH_TAX_BAL	FLOAT	✅	—	—
66	PAY_TYPE_ID	TEXT	✅	—	—
67	CURY_LINE_RETAINAGE_TOTAL	FLOAT	✅	—	—
68	CURY_DISCOUNTED_DOC_TOTAL	FLOAT	✅	—	—
69	CURY_TAX_AMT	FLOAT	✅	—	—
70	EST_PAY_DATE	TIMESTAMP_TZ	✅	—	—
71	ORIG_DOC_DATE	TIMESTAMP_TZ	✅	—	—
72	CEG_CURY_DEBIT_TOTAL	FLOAT	✅	—	—
73	NOTE_ID	TEXT	✅	—	—
74	CLOSED_FIN_PERIOD_ID	NUMBER	✅	—	—
75	RETAINAGE_UNPAID_TOTAL	FLOAT	✅	—	—
76	CURY_RETAINED_TAX_TOTAL	FLOAT	✅	—	—
77	CURY_DISC_TAKEN	FLOAT	✅	—	—
78	CEG_THIRD_PARTY_TYPE	TEXT	✅	—	—
79	CURY_RETAINAGE_UNPAID_TOTAL	FLOAT	✅	—	—
80	PRINT_DOC_TYPE	TEXT	✅	—	—
81	LINE_TOTAL	FLOAT	✅	—	—
82	ORIG_MODULE	TEXT	✅	—	—
83	VENDOR_LOCATION_ID	NUMBER	✅	—	—
84	IS_TAX_VALID	BOOLEAN	✅	—	—
85	CURY_DOC_DISC	FLOAT	✅	—	—
86	CURY_RETAINED_DISC_TOTAL	FLOAT	✅	—	—
87	CURY_CHARGE_AMT	FLOAT	✅	—	—
88	DISCOUNTED_TAXABLE_TOTAL	FLOAT	✅	—	—
89	DR_CR	TEXT	✅	—	—
90	DOC_DATE	TIMESTAMP_TZ	✅	—	—
91	CURY_ROUND_DIFF	FLOAT	✅	—	—
92	FIN_PERIOD_ID	NUMBER	✅	—	—
93	CURY_LINE_DISC_TOTAL	FLOAT	✅	—	—
94	NOTE_TEXT	TEXT	✅	—	—
95	DOC_BAL	FLOAT	✅	—	—
96	LINE_CNTR	NUMBER	✅	—	—
97	CLOSED_DATE	TIMESTAMP_TZ	✅	—	—
98	TAX_ZONE_ID	TEXT	✅	—	—
99	ORIG_DOC_AMT_WITH_RETAINAGE_TOTAL	FLOAT	✅	—	—
100	TAX_WHELD	FLOAT	✅	—	—
101	IS_TAX_POSTED	BOOLEAN	✅	—	—
102	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
103	USR_DWREFERENCE_DOC	TEXT	✅	—	—
104	RETAINAGE_APPLY	BOOLEAN	✅	—	—
105	CURY_ORIG_WH_TAX_AMT	FLOAT	✅	—	—
106	USR_DWSUJET	TEXT	✅	—	—
107	RETAINED_TAX_TOTAL	FLOAT	✅	—	—
108	APSUB_ID	NUMBER	✅	—	—
109	HOLD	BOOLEAN	✅	—	—
110	USR_IDDOCUWARE	NUMBER	✅	—	—
111	INVOICE_NBR	TEXT	✅	—	—
112	CURY_INFO_ID	NUMBER	✅	—	—
113	CURY_DISCOUNTED_PRICE	FLOAT	✅	—	—
114	TAX_AMT	FLOAT	✅	—	—
115	LAST_MODIFIED_BY_ID	TEXT	✅	—	—
116	ORIG_WH_TAX_AMT	FLOAT	✅	—	—
117	DOC_CLASS	TEXT	✅	—	—
118	VOIDED	BOOLEAN	✅	—	—
119	INIT_DOC_BAL	FLOAT	✅	—	—
120	CEG_CURY_CREDIT_TOTAL	FLOAT	✅	—	—
121	HAS_MULTIPLE_PROJECTS	BOOLEAN	✅	—	—
122	LAST_MODIFIED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
123	ATTRIBUTE_NOTE	TEXT	✅	—	—
124	ENTITY_USAGE_TYPE	TEXT	✅	—	—
125	TAX_ROUND_DIFF	FLOAT	✅	—	—
126	NON_TAXABLE	BOOLEAN	✅	—	—
127	APACCOUNT_ID	NUMBER	✅	—	—
128	IS_TAX_SAVED	BOOLEAN	✅	—	—
129	INTERCOMPANY_INVOICE_NOTE_ID	TEXT	✅	—	—
130	IS_EXPECTED_PPVVALID	BOOLEAN	✅	—	—
131	USR_DWNUM_AFFAIRE	TEXT	✅	—	—
132	IS_TAX_DOCUMENT	BOOLEAN	✅	—	—
133	TSTAMP	TEXT	✅	—	—
134	DELETED_DATABASE_RECORD	BOOLEAN	✅	—	—
135	DISABLE_AUTOMATIC_DISCOUNT_CALCULATION	BOOLEAN	✅	—	—
136	ORIG_DISC_AMT	FLOAT	✅	—	—
137	CURY_DISC_BAL	FLOAT	✅	—	—
138	USR_DWNUM_BDC	TEXT	✅	—	—
139	CREATED_BY_ID	TEXT	✅	—	—
140	CURY_RETAINAGE_RELEASED	FLOAT	✅	—	—
141	SCHEDULE_ID	TEXT	✅	—	—
142	CURY_RETAINAGE_TOTAL	FLOAT	✅	—	—
143	RELEASED_OR_PREBOOKED	BOOLEAN	✅	—	—
144	ATTRIBUTE_NDFJENJI	NUMBER	✅	—	—
145	DISC_DATE	TIMESTAMP_TZ	✅	—	—
146	PAY_ACCOUNT_ID	NUMBER	✅	—	—
147	REJECTED	BOOLEAN	✅	—	—
148	CREATED_BY_SCREEN_ID	TEXT	✅	—	—
149	SCHEDULED	BOOLEAN	✅	—	—
150	CURY_RETAINAGE_UNRELEASED_AMT	FLOAT	✅	—	—
151	PAYMENT_INFO_LOCATION_ID	NUMBER	✅	—	—
152	USR_DWIMMATRICULATION	TEXT	✅	—	—
153	DOC_TYPE	TEXT	✅	—	—
154	ORIG_DOC_TYPE	TEXT	✅	—	—
155	MANUAL_ENTRY	BOOLEAN	✅	—	—
156	CURY_INIT_DOC_BAL	FLOAT	✅	—	—
157	CLOSED_TRAN_PERIOD_ID	NUMBER	✅	—	—
158	CURY_RETAINAGE_PAID_TOTAL	FLOAT	✅	—	—
159	RETAINAGE_TOTAL	FLOAT	✅	—	—
160	VAT_TAXABLE_TOTAL	FLOAT	✅	—	—
161	CURY_ID	TEXT	✅	—	—
162	CURY_TAX_ROUND_DIFF	FLOAT	✅	—	—
163	TAX_CALC_MODE	TEXT	✅	—	—
164	DISCOUNTED_DOC_TOTAL	FLOAT	✅	—	—
165	CEG_VENDOR_DOC_DATE	TIMESTAMP_TZ	✅	—	—
166	CEG_DEBIT_TOTAL	FLOAT	✅	—	—
167	BRANCH_ID	NUMBER	✅	—	—
168	USR_URLDOCUWARE	TEXT	✅	—	—
169	PENDING_PPD	BOOLEAN	✅	—	—
170	CURY_DISC_TOT	FLOAT	✅	—	—
171	LCENABLED	BOOLEAN	✅	—	—
172	DUE_DATE	TIMESTAMP_TZ	✅	—	—
173	CURY_VAT_EXEMPT_TOTAL	FLOAT	✅	—	—
174	DISC_TOT	FLOAT	✅	—	—
175	DONT_APPROVE	BOOLEAN	✅	—	—
176	CURY_VAT_TAXABLE_TOTAL	FLOAT	✅	—	—
177	CURY_DISCOUNTED_TAXABLE_TOTAL	FLOAT	✅	—	—