ARINVOICE

⚠️ 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	192,385
Columns	235

Columns

#	Column	Type	Nullable	Default	Description
1	_FIVETRAN_SYNCED	TIMESTAMP_TZ	✅	—	—
2	PRINT_CEG_THIRD_PARTY_TYPE	TEXT	✅	—	—
3	FROM_SCHEDULE	BOOLEAN	✅	—	—
4	PAYMENT_TOTAL	FLOAT	✅	—	—
5	PENDING_PROCESSING_CNTR	NUMBER	✅	—	—
6	IS_RETAINAGE_REVERSING	BOOLEAN	✅	—	—
7	CURY_COMMN_AMT	FLOAT	✅	—	—
8	APPROVED	BOOLEAN	✅	—	—
9	HAS_PPDTAXES	BOOLEAN	✅	—	—
10	CURY_ORDER_DISC_TOTAL	FLOAT	✅	—	—
11	LINE_RETAINAGE_TOTAL	FLOAT	✅	—	—
12	CURY_ORIG_DOC_AMT	FLOAT	✅	—	—
13	FREIGHT_AMT	FLOAT	✅	—	—
14	CASH_ACCOUNT_ID	NUMBER	✅	—	—
15	RELEASED	BOOLEAN	✅	—	—
16	DOC_DISC	FLOAT	✅	—	—
17	IS_RETAINAGE_DOCUMENT	BOOLEAN	✅	—	—
18	DONT_EMAIL	BOOLEAN	✅	—	—
19	DISC_BAL	FLOAT	✅	—	—
20	CURY_FREIGHT_COST	FLOAT	✅	—	—
21	ATTRIBUTE_REFRAPPRO	TEXT	✅	—	—
22	RETAINAGE_UNRELEASED_AMT	FLOAT	✅	—	—
23	CURY_TAX_TOTAL	FLOAT	✅	—	—
24	CURY_DOCUMENT_DISC_TOTAL	FLOAT	✅	—	—
25	LINE_DISC_TOTAL	FLOAT	✅	—	—
26	CANCELED	BOOLEAN	✅	—	—
27	OPEN_DOC	BOOLEAN	✅	—	—
28	IS_MIGRATED_RECORD	BOOLEAN	✅	—	—
29	TRAN_PERIOD_ID	NUMBER	✅	—	—
30	CURY_CCAUTHORIZED_AMT	FLOAT	✅	—	—
31	RETAINAGE_PAID_TOTAL	FLOAT	✅	—	—
32	CURY_ORIG_DOC_AMT_WITH_RETAINAGE_TOTAL	FLOAT	✅	—	—
33	TAX_TOTAL	FLOAT	✅	—	—
34	CURY_DOC_BAL	FLOAT	✅	—	—
35	ADJ_CNTR	NUMBER	✅	—	—
36	CURY_COMMNBL_AMT	FLOAT	✅	—	—
37	INVOICE_DATE	TIMESTAMP_TZ	✅	—	—
38	DEF_RETAINAGE_PCT	FLOAT	✅	—	—
39	RETAINAGE_RELEASED	FLOAT	✅	—	—
40	VAT_EXEMPT_TOTAL	FLOAT	✅	—	—
41	CURY_WH_TAX_BAL	NUMBER	✅	—	—
42	CURY_DISCOUNTED_DOC_TOTAL	FLOAT	✅	—	—
43	ORIG_DOC_DATE	TIMESTAMP_TZ	✅	—	—
44	NOTE_ID	TEXT	✅	—	—
45	CLOSED_FIN_PERIOD_ID	NUMBER	✅	—	—
46	CEG_PRINTED_DATE	TIMESTAMP_TZ	✅	—	—
47	APPLICATION_BALANCE	FLOAT	✅	—	—
48	CURY_DISC_TAKEN	FLOAT	✅	—	—
49	CEG_THIRD_PARTY_TYPE	TEXT	✅	—	—
50	CURY_GOODS_EXT_PRICE_TOTAL	FLOAT	✅	—	—
51	CURY_RETAINAGE_UNPAID_TOTAL	FLOAT	✅	—	—
52	LINE_TOTAL	FLOAT	✅	—	—
53	PREMIUM_FREIGHT_AMT	FLOAT	✅	—	—
54	IS_TAX_VALID	BOOLEAN	✅	—	—
55	CURY_PAID_AMT	FLOAT	✅	—	—
56	CURY_FREIGHT_TOT	FLOAT	✅	—	—
57	UNRELEASED_PAYMENT_AMT	FLOAT	✅	—	—
58	CURY_RETAINED_DISC_TOTAL	FLOAT	✅	—	—
59	DR_CR	TEXT	✅	—	—
60	DOC_DATE	TIMESTAMP_TZ	✅	—	—
61	BATCH_SEQ	NUMBER	✅	—	—
62	GROUP_DISC_TOTAL	FLOAT	✅	—	—
63	CURY_ROUND_DIFF	FLOAT	✅	—	—
64	CURY_MISC_EXT_PRICE_TOTAL	FLOAT	✅	—	—
65	FIN_PERIOD_ID	NUMBER	✅	—	—
66	DOC_BAL	FLOAT	✅	—	—
67	GOODS_EXT_PRICE_TOTAL	FLOAT	✅	—	—
68	TAX_ZONE_ID	TEXT	✅	—	—
69	ORIG_DOC_AMT_WITH_RETAINAGE_TOTAL	FLOAT	✅	—	—
70	CLOSED_DATE	TIMESTAMP_TZ	✅	—	—
71	BILL_ADDRESS_ID	NUMBER	✅	—	—
72	FREIGHT_TOT	FLOAT	✅	—	—
73	CCAUTHORIZED_AMT	FLOAT	✅	—	—
74	GOODS_TOTAL	FLOAT	✅	—	—
75	IS_CANCELLATION	BOOLEAN	✅	—	—
76	CURY_GROUP_DISC_TOTAL	FLOAT	✅	—	—
77	CURY_PAYMENT_TOTAL	FLOAT	✅	—	—
78	HOLD	BOOLEAN	✅	—	—
79	PROJECT_ID	NUMBER	✅	—	—
80	VOIDED	BOOLEAN	✅	—	—
81	IS_PAYMENTS_TRANSFERRED	BOOLEAN	✅	—	—
82	INIT_DOC_BAL	FLOAT	✅	—	—
83	APPROVED_CAPTURE_FAILED	BOOLEAN	✅	—	—
84	NON_TAXABLE	BOOLEAN	✅	—	—
85	IS_HIDDEN_IN_INTERCOMPANY_SALES	BOOLEAN	✅	—	—
86	MISC_TOT	FLOAT	✅	—	—
87	DRSCHED_CNTR	NUMBER	✅	—	—
88	DELETED_DATABASE_RECORD	BOOLEAN	✅	—	—
89	ORIG_DISC_AMT	FLOAT	✅	—	—
90	CURY_DISC_BAL	FLOAT	✅	—	—
91	PENDING_PROCESSING	BOOLEAN	✅	—	—
92	HIDDEN	BOOLEAN	✅	—	—
93	SHIP_ADDRESS_ID	NUMBER	✅	—	—
94	CREATED_BY_SCREEN_ID	TEXT	✅	—	—
95	SCHEDULED	BOOLEAN	✅	—	—
96	CURY_DOC_UNPAID_BAL	FLOAT	✅	—	—
97	ORIG_DOC_TYPE	TEXT	✅	—	—
98	CURY_INIT_DOC_BAL	FLOAT	✅	—	—
99	CURY_RETAINAGE_PAID_TOTAL	FLOAT	✅	—	—
100	RETAINAGE_TOTAL	FLOAT	✅	—	—
101	BALANCE_WOTOTAL	FLOAT	✅	—	—
102	SELF_VOIDING_DOC	BOOLEAN	✅	—	—
103	CURY_FREIGHT_AMT	FLOAT	✅	—	—
104	CEG_DOUBTFUL_DEBT	BOOLEAN	✅	—	—
105	EMAIL_INVOICE	BOOLEAN	✅	—	—
106	ATTRIBUTE_FACTCLT_05	TEXT	✅	—	—
107	PAYMENT_METHOD_ID	TEXT	✅	—	—
108	DONT_APPROVE	BOOLEAN	✅	—	—
109	CURY_DISC_APPLIED_AMT	FLOAT	✅	—	—
110	CURY_VAT_TAXABLE_TOTAL	FLOAT	✅	—	—
111	ATTRIBUTE_FACTCLT_02	TEXT	✅	—	—
112	AVALARA_CUSTOMER_USAGE_TYPE	NUMBER	✅	—	—
113	ATTRIBUTE_FACTCLT_01	TEXT	✅	—	—
114	CURY_DISCOUNTED_TAXABLE_TOTAL	FLOAT	✅	—	—
115	ATTRIBUTE_FACTCLT_04	TEXT	✅	—	—
116	ATTRIBUTE_FACTCLT_03	TEXT	✅	—	—
117	EXTERNAL_TAXES_IMPORT_IN_PROGRESS	BOOLEAN	✅	—	—
118	DISC_TAKEN	FLOAT	✅	—	—
119	INTERNAL_DOC_TYPE	TEXT	✅	—	—
120	REVOKED	BOOLEAN	✅	—	—
121	IS_UNDER_CORRECTION	BOOLEAN	✅	—	—
122	DOCUMENT_KEY	TEXT	✅	—	—
123	MULTI_SHIP_ADDRESS	BOOLEAN	✅	—	—
124	BATCH_NBR	TEXT	✅	—	—
125	DOC_DESC	TEXT	✅	—	—
126	ARACCOUNT_ID	NUMBER	✅	—	—
127	CURY_ORIG_DISC_AMT	FLOAT	✅	—	—
128	COMMNBL_AMT	FLOAT	✅	—	—
129	SHIP_CONTACT_ID	NUMBER	✅	—	—
130	WH_TAX_BAL	NUMBER	✅	—	—
131	LAST_MODIFIED_BY_SCREEN_ID	TEXT	✅	—	—
132	RGOLAMT	FLOAT	✅	—	—
133	PRINTED	BOOLEAN	✅	—	—
134	MISC_EXT_PRICE_TOTAL	FLOAT	✅	—	—
135	CHARGE_AMT	FLOAT	✅	—	—
136	CURY_MISC_TOT	FLOAT	✅	—	—
137	REF_NBR	TEXT	✅	—	—
138	CURY_DETAIL_EXT_PRICE_TOTAL	FLOAT	✅	—	—
139	DISC_APPLIED_AMT	FLOAT	✅	—	—
140	CEG_DOUBTFUL_DEBT_DISPLAY	BOOLEAN	✅	—	—
141	STATUS	TEXT	✅	—	—
142	DISPLAY_CURY_INIT_DOC_BAL	FLOAT	✅	—	—
143	CURY_LINE_TOTAL	FLOAT	✅	—	—
144	RETAINED_DISC_TOTAL	FLOAT	✅	—	—
145	CURY_UNRELEASED_PAYMENT_AMT	FLOAT	✅	—	—
146	TERMS_ID	TEXT	✅	—	—
147	ORDER_DISC_TOTAL	FLOAT	✅	—	—
148	ORIG_DOC_AMT	FLOAT	✅	—	—
149	CEG_CREDIT_TOTAL	FLOAT	✅	—	—
150	DISCOUNTED_PRICE	FLOAT	✅	—	—
151	PAID_AMT	FLOAT	✅	—	—
152	CURY_APPLICATION_BALANCE	FLOAT	✅	—	—
153	CREATED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
154	ROUND_DIFF	FLOAT	✅	—	—
155	ORIG_REF_NBR	TEXT	✅	—	—
156	APPROVED_CREDIT_AMT	FLOAT	✅	—	—
157	HIDDEN_BY_SHIPMENT	BOOLEAN	✅	—	—
158	CUSTOMER_LOCATION_ID	NUMBER	✅	—	—
159	CAPTURE_FAILED_CNTR	NUMBER	✅	—	—
160	CURY_LINE_RETAINAGE_TOTAL	FLOAT	✅	—	—
161	CEG_CURY_DEBIT_TOTAL	FLOAT	✅	—	—
162	CEG_SALES_TRADE_CLASS	NUMBER	✅	—	—
163	COMMN_PCT	FLOAT	✅	—	—
164	ARSUB_ID	NUMBER	✅	—	—
165	RETAINAGE_UNPAID_TOTAL	FLOAT	✅	—	—
166	CURY_RETAINED_TAX_TOTAL	FLOAT	✅	—	—
167	EMAILED	BOOLEAN	✅	—	—
168	CURY_PREMIUM_FREIGHT_AMT	FLOAT	✅	—	—
169	PRINT_DOC_TYPE	TEXT	✅	—	—
170	APPLY_OVERDUE_CHARGE	BOOLEAN	✅	—	—
171	ORIG_MODULE	TEXT	✅	—	—
172	FREIGHT_COST	FLOAT	✅	—	—
173	CURY_DOC_DISC	FLOAT	✅	—	—
174	CURY_CHARGE_AMT	FLOAT	✅	—	—
175	DISCOUNTED_TAXABLE_TOTAL	FLOAT	✅	—	—
176	CURY_LINE_DISC_TOTAL	FLOAT	✅	—	—
177	CUSTOMER_ID	NUMBER	✅	—	—
178	NOTE_TEXT	TEXT	✅	—	—
179	LINE_CNTR	NUMBER	✅	—	—
180	IS_TAX_POSTED	BOOLEAN	✅	—	—
181	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
182	RETAINAGE_APPLY	BOOLEAN	✅	—	—
183	RETAINED_TAX_TOTAL	FLOAT	✅	—	—
184	INVOICE_NBR	TEXT	✅	—	—
185	CURY_INFO_ID	NUMBER	✅	—	—
186	CURY_DISCOUNTED_PRICE	FLOAT	✅	—	—
187	DONT_PRINT	BOOLEAN	✅	—	—
188	LAST_MODIFIED_BY_ID	TEXT	✅	—	—
189	CURY_UNPAID_BALANCE	FLOAT	✅	—	—
190	DOC_CLASS	TEXT	✅	—	—
191	CEG_CURY_CREDIT_TOTAL	FLOAT	✅	—	—
192	DETAIL_EXT_PRICE_TOTAL	FLOAT	✅	—	—
193	LAST_MODIFIED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
194	PENDING_PAYMENT	BOOLEAN	✅	—	—
195	CREDIT_HOLD	BOOLEAN	✅	—	—
196	IS_TAX_SAVED	BOOLEAN	✅	—	—
197	PROFORMA_EXISTS	BOOLEAN	✅	—	—
198	PRINT_INVOICE	BOOLEAN	✅	—	—
199	CEG_REC_TRANS	BOOLEAN	✅	—	—
200	COMMN_AMT	FLOAT	✅	—	—
201	BILL_CONTACT_ID	NUMBER	✅	—	—
202	TSTAMP	TEXT	✅	—	—
203	CURY_BALANCE_WOTOTAL	FLOAT	✅	—	—
204	DISABLE_AUTOMATIC_DISCOUNT_CALCULATION	BOOLEAN	✅	—	—
205	CREATED_BY_ID	TEXT	✅	—	—
206	CURY_RETAINAGE_RELEASED	FLOAT	✅	—	—
207	UNPAID_BALANCE	FLOAT	✅	—	—
208	CURY_RETAINAGE_TOTAL	FLOAT	✅	—	—
209	DISC_DATE	TIMESTAMP_TZ	✅	—	—
210	REJECTED	BOOLEAN	✅	—	—
211	CURY_RETAINAGE_UNRELEASED_AMT	FLOAT	✅	—	—
212	DOC_TYPE	TEXT	✅	—	—
213	AUTHORIZED_PAYMENT_CNTR	NUMBER	✅	—	—
214	CLOSED_TRAN_PERIOD_ID	NUMBER	✅	—	—
215	VAT_TAXABLE_TOTAL	FLOAT	✅	—	—
216	CURY_ID	TEXT	✅	—	—
217	TAX_CALC_MODE	BOOLEAN	✅	—	—
218	DISCOUNTED_DOC_TOTAL	FLOAT	✅	—	—
219	CEG_DEBIT_TOTAL	FLOAT	✅	—	—
220	BRANCH_ID	NUMBER	✅	—	—
221	DOCUMENT_DISC_TOTAL	FLOAT	✅	—	—
222	IS_CORRECTION	BOOLEAN	✅	—	—
223	PENDING_PPD	BOOLEAN	✅	—	—
224	APPROVED_PREPAYMENT_REQUIRED	BOOLEAN	✅	—	—
225	CURY_DISC_TOT	FLOAT	✅	—	—
226	DUE_DATE	TIMESTAMP_TZ	✅	—	—
227	CURY_VAT_EXEMPT_TOTAL	FLOAT	✅	—	—
228	APPROVED_CREDIT	BOOLEAN	✅	—	—
229	DISC_TOT	FLOAT	✅	—	—
230	IS_PRICE_AND_DISCOUNTS_VALID	BOOLEAN	✅	—	—
231	CEG_THIRD_PARTY_TYPE_PRINT	TEXT	✅	—	—
232	CEG_OPT_PAY_TAX_BASED_ON_DEBITS	BOOLEAN	✅	—	—
233	CURY_GOODS_TOTAL	FLOAT	✅	—	—
234	CEG_EMAILED_DATE	TIMESTAMP_TZ	✅	—	—
235	CEG_INVOICING_FRAMEWORK	NUMBER	✅	—	—