ARPAYMENT

⚠️ 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	209,898
Columns	169

Columns

#	Column	Type	Nullable	Default	Description
1	_FIVETRAN_SYNCED	TIMESTAMP_TZ	✅	—	—
2	IS_CCAUTHORIZED	BOOLEAN	✅	—	—
3	DISC_TAKEN	FLOAT	✅	—	—
4	PRINT_CEG_THIRD_PARTY_TYPE	TEXT	✅	—	—
5	INTERNAL_DOC_TYPE	TEXT	✅	—	—
6	FROM_SCHEDULE	BOOLEAN	✅	—	—
7	CHARGE_CNTR	NUMBER	✅	—	—
8	IS_UNDER_CORRECTION	BOOLEAN	✅	—	—
9	DOCUMENT_KEY	TEXT	✅	—	—
10	IS_RETAINAGE_REVERSING	BOOLEAN	✅	—	—
11	APPROVED	BOOLEAN	✅	—	—
12	HAS_PPDTAXES	BOOLEAN	✅	—	—
13	BATCH_NBR	TEXT	✅	—	—
14	LINE_RETAINAGE_TOTAL	FLOAT	✅	—	—
15	CURY_ORIG_DOC_AMT	FLOAT	✅	—	—
16	DOC_DESC	TEXT	✅	—	—
17	ARACCOUNT_ID	NUMBER	✅	—	—
18	CASH_ACCOUNT_ID	NUMBER	✅	—	—
19	RELEASED	BOOLEAN	✅	—	—
20	DOC_DISC	FLOAT	✅	—	—
21	IS_RETAINAGE_DOCUMENT	BOOLEAN	✅	—	—
22	DONT_EMAIL	BOOLEAN	✅	—	—
23	CURY_APPL_AMT	FLOAT	✅	—	—
24	DISC_BAL	FLOAT	✅	—	—
25	IS_CCCAPTURED	BOOLEAN	✅	—	—
26	ATTRIBUTE_REFRAPPRO	TEXT	✅	—	—
27	RETAINAGE_UNRELEASED_AMT	FLOAT	✅	—	—
28	SETTLED	BOOLEAN	✅	—	—
29	CURY_ORIG_DISC_AMT	FLOAT	✅	—	—
30	CLEAR_DATE	TIMESTAMP_TZ	✅	—	—
31	LAST_MODIFIED_BY_SCREEN_ID	TEXT	✅	—	—
32	RGOLAMT	FLOAT	✅	—	—
33	CANCELED	BOOLEAN	✅	—	—
34	PRINTED	BOOLEAN	✅	—	—
35	OPEN_DOC	BOOLEAN	✅	—	—
36	IS_MIGRATED_RECORD	BOOLEAN	✅	—	—
37	TRAN_PERIOD_ID	NUMBER	✅	—	—
38	CURY_ORIG_DOC_AMT_WITH_RETAINAGE_TOTAL	FLOAT	✅	—	—
39	RETAINAGE_PAID_TOTAL	FLOAT	✅	—	—
40	CHARGE_AMT	FLOAT	✅	—	—
41	REF_NBR	TEXT	✅	—	—
42	ADJ_TRAN_PERIOD_ID	NUMBER	✅	—	—
43	STATUS	TEXT	✅	—	—
44	DISPLAY_CURY_INIT_DOC_BAL	FLOAT	✅	—	—
45	RETAINED_DISC_TOTAL	FLOAT	✅	—	—
46	IS_CCCAPTURE_FAILED	BOOLEAN	✅	—	—
47	ADJ_CNTR	NUMBER	✅	—	—
48	CURY_DOC_BAL	FLOAT	✅	—	—
49	ORIG_DOC_AMT	FLOAT	✅	—	—
50	CURY_SOAPPL_AMT	FLOAT	✅	—	—
51	DISCOUNTED_PRICE	FLOAT	✅	—	—
52	IS_CCPAYMENT	BOOLEAN	✅	—	—
53	DEF_RETAINAGE_PCT	FLOAT	✅	—	—
54	CREATED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
55	ADJ_FIN_PERIOD_ID	NUMBER	✅	—	—
56	REF_NOTE_ID	TEXT	✅	—	—
57	RETAINAGE_RELEASED	FLOAT	✅	—	—
58	ROUND_DIFF	FLOAT	✅	—	—
59	ORIG_REF_NBR	TEXT	✅	—	—
60	CUSTOMER_LOCATION_ID	NUMBER	✅	—	—
61	CURY_LINE_RETAINAGE_TOTAL	FLOAT	✅	—	—
62	CURY_DISCOUNTED_DOC_TOTAL	FLOAT	✅	—	—
63	ORIG_DOC_DATE	TIMESTAMP_TZ	✅	—	—
64	ARSUB_ID	NUMBER	✅	—	—
65	NOTE_ID	TEXT	✅	—	—
66	CLOSED_FIN_PERIOD_ID	NUMBER	✅	—	—
67	SAVE_CARD	BOOLEAN	✅	—	—
68	RETAINAGE_UNPAID_TOTAL	FLOAT	✅	—	—
69	CURY_RETAINED_TAX_TOTAL	FLOAT	✅	—	—
70	EMAILED	BOOLEAN	✅	—	—
71	CURY_DISC_TAKEN	FLOAT	✅	—	—
72	CEG_THIRD_PARTY_TYPE	TEXT	✅	—	—
73	CAN_HAVE_BALANCE	BOOLEAN	✅	—	—
74	CURY_RETAINAGE_UNPAID_TOTAL	FLOAT	✅	—	—
75	PRINT_DOC_TYPE	TEXT	✅	—	—
76	CEG_CREATION_DATE	TIMESTAMP_TZ	✅	—	—
77	NEED_TASK_VALIDATION	BOOLEAN	✅	—	—
78	ORIG_MODULE	TEXT	✅	—	—
79	IS_TAX_VALID	BOOLEAN	✅	—	—
80	CURY_DOC_DISC	FLOAT	✅	—	—
81	CURY_RETAINED_DISC_TOTAL	FLOAT	✅	—	—
82	CURY_CHARGE_AMT	FLOAT	✅	—	—
83	DISCOUNTED_TAXABLE_TOTAL	FLOAT	✅	—	—
84	CEG_DEBT_UNCOLLECTABLE	BOOLEAN	✅	—	—
85	DEPOSIT_AS_BATCH	BOOLEAN	✅	—	—
86	DR_CR	TEXT	✅	—	—
87	DOC_DATE	TIMESTAMP_TZ	✅	—	—
88	BATCH_SEQ	NUMBER	✅	—	—
89	CURY_ROUND_DIFF	FLOAT	✅	—	—
90	FIN_PERIOD_ID	NUMBER	✅	—	—
91	IS_CCUSER_ATTENTION	BOOLEAN	✅	—	—
92	CUSTOMER_ID	NUMBER	✅	—	—
93	NOTE_TEXT	TEXT	✅	—	—
94	DOC_BAL	FLOAT	✅	—	—
95	LINE_CNTR	NUMBER	✅	—	—
96	CLOSED_DATE	TIMESTAMP_TZ	✅	—	—
97	ORIG_DOC_AMT_WITH_RETAINAGE_TOTAL	FLOAT	✅	—	—
98	IS_TAX_POSTED	BOOLEAN	✅	—	—
99	DEPOSITED	BOOLEAN	✅	—	—
100	IS_CANCELLATION	BOOLEAN	✅	—	—
101	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
102	RETAINAGE_APPLY	BOOLEAN	✅	—	—
103	CONSOLIDATE_CHARGE_TOTAL	FLOAT	✅	—	—
104	RETAINED_TAX_TOTAL	FLOAT	✅	—	—
105	HOLD	BOOLEAN	✅	—	—
106	CURY_INFO_ID	NUMBER	✅	—	—
107	CURY_DISCOUNTED_PRICE	FLOAT	✅	—	—
108	DONT_PRINT	BOOLEAN	✅	—	—
109	LAST_MODIFIED_BY_ID	TEXT	✅	—	—
110	EXT_REF_NBR	TEXT	✅	—	—
111	DOC_CLASS	TEXT	✅	—	—
112	VOIDED	BOOLEAN	✅	—	—
113	INIT_DOC_BAL	FLOAT	✅	—	—
114	PENDING_PAYMENT	BOOLEAN	✅	—	—
115	LAST_MODIFIED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
116	VOID_APPL	BOOLEAN	✅	—	—
117	NON_TAXABLE	BOOLEAN	✅	—	—
118	IS_TAX_SAVED	BOOLEAN	✅	—	—
119	PRINT_INVOICE	BOOLEAN	✅	—	—
120	DRSCHED_CNTR	NUMBER	✅	—	—
121	IS_BILL_OF_EXCHANGE	BOOLEAN	✅	—	—
122	TSTAMP	TEXT	✅	—	—
123	DELETED_DATABASE_RECORD	BOOLEAN	✅	—	—
124	ORIG_DISC_AMT	FLOAT	✅	—	—
125	IS_CCREFUNDED	BOOLEAN	✅	—	—
126	CURY_CONSOLIDATE_CHARGE_TOTAL	FLOAT	✅	—	—
127	CURY_DISC_BAL	FLOAT	✅	—	—
128	PENDING_PROCESSING	BOOLEAN	✅	—	—
129	CEG_PAYMENT_TYPE	TEXT	✅	—	—
130	CREATED_BY_ID	TEXT	✅	—	—
131	CURY_RETAINAGE_RELEASED	FLOAT	✅	—	—
132	CLEARED	BOOLEAN	✅	—	—
133	CATRAN_ID	NUMBER	✅	—	—
134	CURY_RETAINAGE_TOTAL	FLOAT	✅	—	—
135	UPDATE_NEXT_NUMBER	BOOLEAN	✅	—	—
136	REJECTED	BOOLEAN	✅	—	—
137	CREATED_BY_SCREEN_ID	TEXT	✅	—	—
138	SCHEDULED	BOOLEAN	✅	—	—
139	CURY_RETAINAGE_UNRELEASED_AMT	FLOAT	✅	—	—
140	CURY_WOAMT	FLOAT	✅	—	—
141	ADJ_DATE	TIMESTAMP_TZ	✅	—	—
142	CURY_DOC_UNPAID_BAL	FLOAT	✅	—	—
143	DOC_TYPE	TEXT	✅	—	—
144	ORIG_DOC_TYPE	TEXT	✅	—	—
145	CURY_INIT_DOC_BAL	FLOAT	✅	—	—
146	CLOSED_TRAN_PERIOD_ID	NUMBER	✅	—	—
147	CURY_RETAINAGE_PAID_TOTAL	FLOAT	✅	—	—
148	RETAINAGE_TOTAL	FLOAT	✅	—	—
149	CURY_ID	TEXT	✅	—	—
150	ATTRIBUTE_NUMFACTURE	TEXT	✅	—	—
151	TAX_CALC_MODE	BOOLEAN	✅	—	—
152	DISCOUNTED_DOC_TOTAL	FLOAT	✅	—	—
153	BRANCH_ID	NUMBER	✅	—	—
154	IS_CORRECTION	BOOLEAN	✅	—	—
155	SAVE_ACCOUNT	BOOLEAN	✅	—	—
156	SELF_VOIDING_DOC	BOOLEAN	✅	—	—
157	PENDING_PPD	BOOLEAN	✅	—	—
158	ORIG_TAX_DISC_AMT	FLOAT	✅	—	—
159	CURY_ORIG_TAX_DISC_AMT	FLOAT	✅	—	—
160	EMAIL_INVOICE	BOOLEAN	✅	—	—
161	CARD_PRESENT	BOOLEAN	✅	—	—
162	ATTRIBUTE_FACTCLT_05	TEXT	✅	—	—
163	PAYMENT_METHOD_ID	TEXT	✅	—	—
164	CCREAUTH_TRIES_LEFT	NUMBER	✅	—	—
165	DONT_APPROVE	BOOLEAN	✅	—	—
166	CEG_THIRD_PARTY_TYPE_PRINT	TEXT	✅	—	—
167	CCTRANSACTION_REFUND	BOOLEAN	✅	—	—
168	CURY_DISCOUNTED_TAXABLE_TOTAL	FLOAT	✅	—	—
169	ATTRIBUTE_FACTCLT_03	TEXT	✅	—	—