APTAX_TRAN

⚠️ 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	149,309
Columns	70

Columns

#	Column	Type	Nullable	Default	Description
1	_FIVETRAN_SYNCED	TIMESTAMP_TZ	✅	—	—
2	ORIG_TRAN_TYPE	TEXT	✅	—	—
3	REPORT_TAXABLE_AMT	FLOAT	✅	—	—
4	TAX_ZONE_ID	TEXT	✅	—	—
5	ORIG_TAXABLE_AMT	FLOAT	✅	—	—
6	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
7	CURY_RETAINED_TAXABLE_AMT	FLOAT	✅	—	—
8	TAXABLE_AMT	FLOAT	✅	—	—
9	TAX_RATE	FLOAT	✅	—	—
10	CURY_INFO_ID	NUMBER	✅	—	—
11	CURY_DISCOUNTED_PRICE	FLOAT	✅	—	—
12	TAX_AMT	FLOAT	✅	—	—
13	LAST_MODIFIED_BY_ID	TEXT	✅	—	—
14	CURY_RETAINED_TAX_AMT_SUMM	FLOAT	✅	—	—
15	REPORT_TAX_AMT	FLOAT	✅	—	—
16	TAX_AMT_SUMM	FLOAT	✅	—	—
17	VOIDED	BOOLEAN	✅	—	—
18	REPORT_CURY_ID	TEXT	✅	—	—
19	RELEASED	BOOLEAN	✅	—	—
20	LAST_MODIFIED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
21	SUB_ID	NUMBER	✅	—	—
22	FIN_DATE	TIMESTAMP_TZ	✅	—	—
23	MODULE	TEXT	✅	—	—
24	CURY_ADJUSTED_TAX_AMT	FLOAT	✅	—	—
25	LAST_MODIFIED_BY_SCREEN_ID	TEXT	✅	—	—
26	TAX_PERIOD_ID	NUMBER	✅	—	—
27	TAX_ID	TEXT	✅	—	—
28	TSTAMP	TEXT	✅	—	—
29	CURY_RETAINED_TAX_AMT	FLOAT	✅	—	—
30	EXPENSE_AMT	FLOAT	✅	—	—
31	CURY_DISCOUNTED_TAXABLE_AMT	FLOAT	✅	—	—
32	TAXABLE_DISCOUNT_AMT	FLOAT	✅	—	—
33	TAX_TYPE	TEXT	✅	—	—
34	TAX_INVOICE_DATE	TIMESTAMP_TZ	✅	—	—
35	CURY_TAX_DISCOUNT_AMT	FLOAT	✅	—	—
36	VENDOR_ID	NUMBER	✅	—	—
37	REF_NBR	TEXT	✅	—	—
38	CREATED_BY_ID	TEXT	✅	—	—
39	ADJUSTED_TAXABLE_AMT	FLOAT	✅	—	—
40	DISCOUNTED_TAXABLE_AMT	FLOAT	✅	—	—
41	CREATED_BY_SCREEN_ID	TEXT	✅	—	—
42	TAX_DISCOUNT_AMT	FLOAT	✅	—	—
43	DESCRIPTION	TEXT	✅	—	—
44	CURY_TAX_AMT_SUMM	FLOAT	✅	—	—
45	REPORT_CURY_MULT_DIV	TEXT	✅	—	—
46	NON_DEDUCTIBLE_TAX_RATE	FLOAT	✅	—	—
47	RETAINED_TAXABLE_AMT	FLOAT	✅	—	—
48	DISCOUNTED_PRICE	FLOAT	✅	—	—
49	CURY_ID	TEXT	✅	—	—
50	CREATED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
51	BRANCH_ID	NUMBER	✅	—	—
52	TAX_BUCKET_ID	NUMBER	✅	—	—
53	CURY_ORIG_TAXABLE_AMT	FLOAT	✅	—	—
54	CURY_TAX_AMT	FLOAT	✅	—	—
55	CURY_TAXABLE_AMT	FLOAT	✅	—	—
56	REVISION_ID	NUMBER	✅	—	—
57	TRAN_DATE	TIMESTAMP_TZ	✅	—	—
58	TRAN_TYPE	TEXT	✅	—	—
59	BACCOUNT_ID	NUMBER	✅	—	—
60	ADJUSTED_TAX_AMT	FLOAT	✅	—	—
61	TAX_INVOICE_NBR	TEXT	✅	—	—
62	RETAINED_TAX_AMT	FLOAT	✅	—	—
63	CURY_TAXABLE_DISCOUNT_AMT	FLOAT	✅	—	—
64	RECORD_ID	NUMBER	✅	—	—
65	ACCOUNT_ID	NUMBER	✅	—	—
66	CURY_ADJUSTED_TAXABLE_AMT	FLOAT	✅	—	—
67	REPORT_CURY_RATE	FLOAT	✅	—	—
68	FIN_PERIOD_ID	NUMBER	✅	—	—
69	RETAINED_TAX_AMT_SUMM	FLOAT	✅	—	—
70	CURY_EXPENSE_AMT	FLOAT	✅	—	—