APPAYMENT

⚠️ 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	135,730
Columns	162

Columns

#	Column	Type	Nullable	Default	Description
1	_FIVETRAN_SYNCED	TIMESTAMP_TZ	✅	—	—
2	BILL_CNTR	NUMBER	✅	—	—
3	DISC_TAKEN	FLOAT	✅	—	—
4	PRINT_CEG_THIRD_PARTY_TYPE	TEXT	✅	—	—
5	INTERNAL_DOC_TYPE	TEXT	✅	—	—
6	CHARGE_CNTR	NUMBER	✅	—	—
7	IS_RETAINAGE_REVERSING	BOOLEAN	✅	—	—
8	APPROVED	BOOLEAN	✅	—	—
9	HAS_PPDTAXES	BOOLEAN	✅	—	—
10	BATCH_NBR	TEXT	✅	—	—
11	LINE_RETAINAGE_TOTAL	FLOAT	✅	—	—
12	CURY_ORIG_DOC_AMT	FLOAT	✅	—	—
13	DOC_DESC	TEXT	✅	—	—
14	CASH_ACCOUNT_ID	NUMBER	✅	—	—
15	RELEASED	BOOLEAN	✅	—	—
16	DOC_DISC	FLOAT	✅	—	—
17	IS_RETAINAGE_DOCUMENT	BOOLEAN	✅	—	—
18	CURY_APPL_AMT	FLOAT	✅	—	—
19	DISC_BAL	FLOAT	✅	—	—
20	CURY_TAX_WHELD	FLOAT	✅	—	—
21	RETAINAGE_UNRELEASED_AMT	FLOAT	✅	—	—
22	CURY_ORIG_DISC_AMT	FLOAT	✅	—	—
23	CLEAR_DATE	TIMESTAMP_TZ	✅	—	—
24	WH_TAX_BAL	FLOAT	✅	—	—
25	LAST_MODIFIED_BY_SCREEN_ID	TEXT	✅	—	—
26	RGOLAMT	FLOAT	✅	—	—
27	RETAINAGE_ACCT_ID	NUMBER	✅	—	—
28	PRINTED	BOOLEAN	✅	—	—
29	OPEN_DOC	BOOLEAN	✅	—	—
30	RETAINAGE_SUB_ID	NUMBER	✅	—	—
31	IS_MIGRATED_RECORD	BOOLEAN	✅	—	—
32	TRAN_PERIOD_ID	NUMBER	✅	—	—
33	CURY_ORIG_DOC_AMT_WITH_RETAINAGE_TOTAL	FLOAT	✅	—	—
34	RETAINAGE_PAID_TOTAL	FLOAT	✅	—	—
35	CHARGE_AMT	FLOAT	✅	—	—
36	VENDOR_ID	NUMBER	✅	—	—
37	REF_NBR	TEXT	✅	—	—
38	USR_ACQUITTE	BOOLEAN	✅	—	—
39	ADJ_TRAN_PERIOD_ID	NUMBER	✅	—	—
40	PREBOOKED	BOOLEAN	✅	—	—
41	STATUS	TEXT	✅	—	—
42	DISPLAY_CURY_INIT_DOC_BAL	FLOAT	✅	—	—
43	RETAINED_DISC_TOTAL	FLOAT	✅	—	—
44	ADJ_CNTR	NUMBER	✅	—	—
45	CURY_DOC_BAL	FLOAT	✅	—	—
46	ORIG_DOC_AMT	FLOAT	✅	—	—
47	DISCOUNTED_PRICE	FLOAT	✅	—	—
48	DEF_RETAINAGE_PCT	FLOAT	✅	—	—
49	CREATED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
50	ADJ_FIN_PERIOD_ID	NUMBER	✅	—	—
51	REF_NOTE_ID	TEXT	✅	—	—
52	RETAINAGE_RELEASED	FLOAT	✅	—	—
53	ROUND_DIFF	FLOAT	✅	—	—
54	ORIG_REF_NBR	TEXT	✅	—	—
55	CURY_WH_TAX_BAL	FLOAT	✅	—	—
56	CURY_LINE_RETAINAGE_TOTAL	FLOAT	✅	—	—
57	CURY_DISCOUNTED_DOC_TOTAL	FLOAT	✅	—	—
58	ORIG_DOC_DATE	TIMESTAMP_TZ	✅	—	—
59	PRINT_CHECK	BOOLEAN	✅	—	—
60	NOTE_ID	TEXT	✅	—	—
61	CLOSED_FIN_PERIOD_ID	NUMBER	✅	—	—
62	RETAINAGE_UNPAID_TOTAL	FLOAT	✅	—	—
63	CURY_RETAINED_TAX_TOTAL	FLOAT	✅	—	—
64	CURY_DISC_TAKEN	FLOAT	✅	—	—
65	CEG_THIRD_PARTY_TYPE	TEXT	✅	—	—
66	CAN_HAVE_BALANCE	BOOLEAN	✅	—	—
67	CURY_RETAINAGE_UNPAID_TOTAL	FLOAT	✅	—	—
68	PRINT_DOC_TYPE	TEXT	✅	—	—
69	ORIG_MODULE	TEXT	✅	—	—
70	VENDOR_LOCATION_ID	NUMBER	✅	—	—
71	IS_TAX_VALID	BOOLEAN	✅	—	—
72	CURY_DOC_DISC	FLOAT	✅	—	—
73	CURY_RETAINED_DISC_TOTAL	FLOAT	✅	—	—
74	CURY_CHARGE_AMT	FLOAT	✅	—	—
75	DISCOUNTED_TAXABLE_TOTAL	FLOAT	✅	—	—
76	CURY_POFULL_APPL_AMT	FLOAT	✅	—	—
77	DEPOSIT_AS_BATCH	BOOLEAN	✅	—	—
78	DR_CR	TEXT	✅	—	—
79	DOC_DATE	TIMESTAMP_TZ	✅	—	—
80	CURY_ROUND_DIFF	FLOAT	✅	—	—
81	FIN_PERIOD_ID	NUMBER	✅	—	—
82	NOTE_TEXT	TEXT	✅	—	—
83	REMIT_ADDRESS_ID	NUMBER	✅	—	—
84	DOC_BAL	FLOAT	✅	—	—
85	LINE_CNTR	NUMBER	✅	—	—
86	CLOSED_DATE	TIMESTAMP_TZ	✅	—	—
87	ORIG_DOC_AMT_WITH_RETAINAGE_TOTAL	FLOAT	✅	—	—
88	TAX_WHELD	FLOAT	✅	—	—
89	IS_TAX_POSTED	BOOLEAN	✅	—	—
90	DEPOSITED	BOOLEAN	✅	—	—
91	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
92	USR_DWREFERENCE_DOC	TEXT	✅	—	—
93	RETAINAGE_APPLY	BOOLEAN	✅	—	—
94	CURY_POUNRELEASED_APPL_AMT	FLOAT	✅	—	—
95	CURY_ORIG_WH_TAX_AMT	FLOAT	✅	—	—
96	USR_DWSUJET	TEXT	✅	—	—
97	RETAINED_TAX_TOTAL	FLOAT	✅	—	—
98	APSUB_ID	NUMBER	✅	—	—
99	HOLD	BOOLEAN	✅	—	—
100	USR_IDDOCUWARE	NUMBER	✅	—	—
101	CURY_INFO_ID	NUMBER	✅	—	—
102	CURY_DISCOUNTED_PRICE	FLOAT	✅	—	—
103	LAST_MODIFIED_BY_ID	TEXT	✅	—	—
104	EXT_REF_NBR	TEXT	✅	—	—
105	ORIG_WH_TAX_AMT	FLOAT	✅	—	—
106	DOC_CLASS	TEXT	✅	—	—
107	VOIDED	BOOLEAN	✅	—	—
108	INIT_DOC_BAL	FLOAT	✅	—	—
109	HAS_MULTIPLE_PROJECTS	BOOLEAN	✅	—	—
110	LAST_MODIFIED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
111	VOID_APPL	BOOLEAN	✅	—	—
112	TAX_ROUND_DIFF	FLOAT	✅	—	—
113	NON_TAXABLE	BOOLEAN	✅	—	—
114	APACCOUNT_ID	NUMBER	✅	—	—
115	IS_TAX_SAVED	BOOLEAN	✅	—	—
116	IS_EXPECTED_PPVVALID	BOOLEAN	✅	—	—
117	USR_DWNUM_AFFAIRE	TEXT	✅	—	—
118	REMIT_CONTACT_ID	NUMBER	✅	—	—
119	TSTAMP	TEXT	✅	—	—
120	DELETED_DATABASE_RECORD	BOOLEAN	✅	—	—
121	ORIG_DISC_AMT	FLOAT	✅	—	—
122	CURY_DISC_BAL	FLOAT	✅	—	—
123	STUB_CNTR	NUMBER	✅	—	—
124	USR_DWNUM_BDC	TEXT	✅	—	—
125	CREATED_BY_ID	TEXT	✅	—	—
126	CURY_RETAINAGE_RELEASED	FLOAT	✅	—	—
127	CLEARED	BOOLEAN	✅	—	—
128	CATRAN_ID	NUMBER	✅	—	—
129	CURY_RETAINAGE_TOTAL	FLOAT	✅	—	—
130	RELEASED_OR_PREBOOKED	BOOLEAN	✅	—	—
131	CEG_ORGANIZATION_HISTORY_ID	NUMBER	✅	—	—
132	CURY_POAPPL_AMT	FLOAT	✅	—	—
133	REJECTED	BOOLEAN	✅	—	—
134	CREATED_BY_SCREEN_ID	TEXT	✅	—	—
135	SCHEDULED	BOOLEAN	✅	—	—
136	CURY_RETAINAGE_UNRELEASED_AMT	FLOAT	✅	—	—
137	ADJ_DATE	TIMESTAMP_TZ	✅	—	—
138	USR_DWIMMATRICULATION	TEXT	✅	—	—
139	DOC_TYPE	TEXT	✅	—	—
140	ORIG_DOC_TYPE	TEXT	✅	—	—
141	CURY_INIT_DOC_BAL	FLOAT	✅	—	—
142	CLOSED_TRAN_PERIOD_ID	NUMBER	✅	—	—
143	CURY_RETAINAGE_PAID_TOTAL	FLOAT	✅	—	—
144	RETAINAGE_TOTAL	FLOAT	✅	—	—
145	CURY_ID	TEXT	✅	—	—
146	CURY_TAX_ROUND_DIFF	FLOAT	✅	—	—
147	TAX_CALC_MODE	TEXT	✅	—	—
148	DISCOUNTED_DOC_TOTAL	FLOAT	✅	—	—
149	BRANCH_ID	NUMBER	✅	—	—
150	USR_URLDOCUWARE	TEXT	✅	—	—
151	PENDING_PPD	BOOLEAN	✅	—	—
152	ORIG_TAX_DISC_AMT	FLOAT	✅	—	—
153	CURY_ORIG_TAX_DISC_AMT	FLOAT	✅	—	—
154	CURY_DISC_TOT	FLOAT	✅	—	—
155	DISC_TOT	FLOAT	✅	—	—
156	ATTRIBUTE_FACTCLT_05	TEXT	✅	—	—
157	ATTRIBUTE_NUMVIAREN	TEXT	✅	—	—
158	PAYMENT_METHOD_ID	TEXT	✅	—	—
159	DONT_APPROVE	BOOLEAN	✅	—	—
160	CURY_DISCOUNTED_TAXABLE_TOTAL	FLOAT	✅	—	—
161	CEG_VENDOR_ADDRESS_HISTORY_ID	NUMBER	✅	—	—
162	ATTRIBUTE_FACTCLT_03	TEXT	✅	—	—