Name: ar_assets_accts_rcvbl
Creator: Forest Gregg
License: https://creativecommons.org/publicdomain/mark/1.0/

Accounts receivable detail — receivables by debtor name, including aging (past due 90/180 days) and write-offs.

acct_type: Account type code. FK to ar_erds_codes (ACCT_CODE).
liquidated: Amount liquidated during the period.
name: Debtor name.
oid: Primary key.
past_due_180: Amount past due 180 days.
past_due_90: Amount past due 90 days.
rpt_id: Foreign key to lm_data.rpt_id.
total: Total receivable balance.

117,424 rows

descending

✎ View and edit SQL

This data as json, CSV (advanced)

oid ▼	acct_type	name	past_due_90	past_due_180	liquidated	total	rpt_id
6	ITEMIZED 101	NONE	0	0	0	0	224377 224377
7	OTHER 102	All Other Accounts	0	0	0	0	224377 224377
8	OTHER 102	All Other Accounts	0	0	0	0	225864 225864
9	OTHER 102	All Other Accounts	0	0	0	0	226358 226358
10	OTHER 102	All Other Accounts	0	0	0	0	226359 226359
14	ITEMIZED 101	National Mail Handlers Union	0	0	0	36581	227102 227102
15	OTHER 102	All Other Accounts	0	0	0	0	227102 227102
16	ITEMIZED 101	None	0	0	0	0	227525 227525
17	OTHER 102	All Other Accounts	0	0	0	0	227525 227525
20	OTHER 102	All Other Accounts	0	0	0	0	227926 227926
21	OTHER 102	All Other Accounts	0	0	0	667	228680 228680
23	ITEMIZED 101	VARIOUS MEMBERS	0	0	0	8102	228746 228746
24	OTHER 102	All Other Accounts	0	0	0	0	228746 228746
26	ITEMIZED 101	LABORERS LOCAL #366	0	0	0	18527	228895 228895
27	ITEMIZED 101	LABORERS LOCAL #559	0	0	0	12731	228895 228895
28	ITEMIZED 101	LABORERS LOCAL #767	0	0	0	9478	228895 228895
29	ITEMIZED 101	LABORERS LOCAL #818	0	0	0	11024	228895 228895
30	ITEMIZED 101	PIPELINE CONSTRUCTION LOCAL #692	0	0	0	6420	228895 228895
31	OTHER 102	All Other Accounts	0	0	0	43078	228895 228895
32	OTHER 102	All Other Accounts	0	0	0	0	228896 228896
33	OTHER 102	All Other Accounts	0	0	0	5135	229016 229016
34	ITEMIZED 101		0	0	0	0	229081 229081
35	OTHER 102	All Other Accounts	0	0	0	0	229081 229081
36	OTHER 102	All Other Accounts	0	0	0	0	229116 229116
37	ITEMIZED 101	AFSCME Local 552	135	115	0	7869	229128 229128
38	OTHER 102	All Other Accounts	26835	2006	0	191688	229128 229128
39	OTHER 102	All Other Accounts	0	0	0	0	229173 229173
40	OTHER 102	All Other Accounts	0	0	0	0	229197 229197
41	ITEMIZED 101	WORKING ASSESSMENTS AND MEMBER ASSESSMENTS	0	0	0	27009	229199 229199
42	OTHER 102	All Other Accounts	0	0	0	0	229199 229199
43	OTHER 102	All Other Accounts	0	0	0	0	229200 229200
44	OTHER 102	All Other Accounts	0	0	0	0	229614 229614
45	OTHER 102	All Other Accounts	0	0	0	0	229933 229933
47	OTHER 102	All Other Accounts	0	0	0	5759	230586 230586
48	OTHER 102	All Other Accounts	0	0	0	0	232348 232348
49	OTHER 102	All Other Accounts	0	0	0	0	232727 232727
56	OTHER 102	All Other Accounts	0	0	0	0	234362 234362
57	OTHER 102	All Other Accounts	0	0	0	0	236434 236434
58	OTHER 102	All Other Accounts	0	0	0	0	238611 238611
59	ITEMIZED 101	Working dues receivable	0	0	0	90502	240415 240415
60	ITEMIZED 101	Member dues receivable	0	0	0	199538	240415 240415
61	OTHER 102	All Other Accounts	0	0	0	0	240415 240415
62	OTHER 102	All Other Accounts	0	0	0	0	241304 241304
71	OTHER 102	All Other Accounts	0	0	0	0	241927 241927
74	OTHER 102	All Other Accounts	0	0	0	0	241929 241929
76	OTHER 102	All Other Accounts	0	0	0	4952751	243726 243726
77	ITEMIZED 101	AFTRA National	0	0	0	137906	243727 243727
78	OTHER 102	All Other Accounts	0	0	0	0	243727 243727
79	OTHER 102	All Other Accounts	0	0	0	9079	244341 244341
80	OTHER 102	All Other Accounts	0	0	0	28261	244710 244710
81	OTHER 102	All Other Accounts	0	0	0	10045	244732 244732
82	OTHER 102	All Other Accounts	0	0	0	7241	244952 244952
83	OTHER 102	All Other Accounts	0	0	0	0	245119 245119
84	OTHER 102	All Other Accounts	17258	0	0	46495	245236 245236
87	ITEMIZED 101	Contractor - Boiler Tek Inc., Saraland, Al	0	0	0	10268	245604 245604
88	OTHER 102	All Other Accounts	0	0	69	1814	245604 245604
89	OTHER 102	All Other Accounts	0	0	0	209857	245608 245608
93	OTHER 102	All Other Accounts	0	0	0	177	245618 245618
94	ITEMIZED 101	ORION CONSTRUCTION GROUP L.L.C.	0	7604	0	7604	245643 245643
95	OTHER 102	All Other Accounts	0	0	0	0	245643 245643
96	OTHER 102	All Other Accounts	0	0	0	12840	245699 245699
97	ITEMIZED 101	MICHAEL MCGULLAM	7000	0	0	7000	245705 245705
98	ITEMIZED 101	TONY GENTRY	0	9500	0	9500	245705 245705
99	ITEMIZED 101	NICOLAS ELIAS	0	5000	0	5000	245705 245705
100	ITEMIZED 101	JESUS CORTEZ	0	5000	0	5000	245705 245705
101	OTHER 102	All Other Accounts	0	0	0	0	245705 245705
102	OTHER 102	All Other Accounts	0	0	0	13894	245761 245761
104	ITEMIZED 101	Calif Field Iron Workers Vacation Fund	0	0	0	66995	245992 245992
105	OTHER 102	All Other Accounts	5156	0	0	40754	245992 245992
106	ITEMIZED 101	Hudson Boiler	0	0	0	1902	246536 246536
107	ITEMIZED 101	Joilet Boiler	0	0	0	1321	246536 246536
108	ITEMIZED 101	International Chimney	0	0	0	233	246536 246536
109	ITEMIZED 101	National Transient Lodge	0	0	0	2050	246536 246536
110	ITEMIZED 101	Common Arc Corporation	0	0	0	6463	246536 246536
111	OTHER 102	All Other Accounts	0	0	0	0	246536 246536
112	OTHER 102	All Other Accounts	0	0	0	13581	246601 246601
114	ITEMIZED 101	Pat A Nees	0	0	2337	2337	246633 246633
115	OTHER 102	All Other Accounts	0	0	0	0	246633 246633
116	OTHER 102	All Other Accounts	3065	0	0	37444	246650 246650
117	ITEMIZED 101		0	0	0	0	246839 246839
118	OTHER 102	All Other Accounts	0	0	0	10729	246839 246839
119	OTHER 102	All Other Accounts	0	0	0	16205	247057 247057
120	OTHER 102	All Other Accounts	0	0	0	4951	247075 247075
121	ITEMIZED 101	DUES AND FEES RECEIVABLE FROM MEMBERS (ESTIMATED)	0	0	0	19071	247076 247076
122	OTHER 102	All Other Accounts	0	0	0	0	247076 247076
123	ITEMIZED 101	Welfare Relief	0	0	0	1854	247078 247078
124	ITEMIZED 101	Pension receivable	0	0	0	1742	247078 247078
125	OTHER 102	All Other Accounts	0	0	0	0	247078 247078
126	OTHER 102	All Other Accounts	0	0	0	705763	247085 247085
127	ITEMIZED 101	Southern Benefits-Work Assessments	165907	0	0	165907	247087 247087
128	ITEMIZED 101	Southern Benefits-PAC Assessments	1416	0	0	1416	247087 247087
129	ITEMIZED 101	Local Union 283-Work Assessments	241	0	0	241	247087 247087
130	ITEMIZED 101	United Brotherhood of Carpenters-Reimbursements	13535	0	0	13535	247087 247087
131	ITEMIZED 101	Intercompany-due from General Fund	595	0	0	595	247087 247087
132	OTHER 102	All Other Accounts	0	0	0	0	247087 247087
133	OTHER 102	All Other Accounts	0	0	0	771725	247098 247098
134	ITEMIZED 101	DELINQUENT DUES	1515	1465	0	18505	247161 247161
135	ITEMIZED 101	EDWARD JOYCE	0	0	0	14650	247161 247161
136	OTHER 102	All Other Accounts	0	0	0	0	247161 247161
137	ITEMIZED 101	MEMBERSHIP DUES	41425	10276	0	74842	247206 247206

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE "ar_assets_accts_rcvbl" (
   [oid] INTEGER PRIMARY KEY NOT NULL,
   [acct_type] INTEGER NOT NULL REFERENCES [ar_erds_codes]([code]),
   [name] TEXT,
   [past_due_90] INTEGER,
   [past_due_180] INTEGER,
   [liquidated] INTEGER,
   [total] INTEGER,
   [rpt_id] INTEGER REFERENCES [lm_data]([rpt_id])
);