Billing Contact This file contains the information for an active facility billing contact including billing contact name, title, phone, mailing address, customer number, customer name, and attention. This file only includes active contacts with the billing contact role. Columns Table Field Description 1 5 PA_IHW_FAC.SWR_NUM_TXT Solid Waste Registration number – 6 55 AC_CONT.LAST_NAME_TXT Billing Contact name (individual’s last name) – 56 85 AC_CONT.FIRST_NAME_TXT Billing Contact optional name (individual’s first name) – 86 110 Billing Contact – 111 140 AD_ELECTR_COMMU.CNTRY_CD Billing Contact’s phone number – and AREA_CD and ELECTR_COMMU_NUM and EXT_NUM 141 183 AD_ADDRESS.DELIV_TXT Billing Contact’s mailing address. – 184 223 AD_ADDRESS.DELIV_2_TXT Billing Contact’s mailing building name address line. – 224 259 AD_ADDRESS.CITY_NAME Billing Contact’s mailing address city name – 260 261 AD_ADDRESS.USPS_STATE_CD Billing Contact’s mailing address state abbreviation – 262 266 AD_ADDRESS.ZIP_CD Billing Contact’s mailing address five digit zip code – 267 270 AD_ADDRESS.ZIP_PLUS4_CD Billing Contact’s mailing address post four digit zip code – 271 280 BT_ARS.AR_NUM Customer Number. Includes only the AR numeric portion, – does not include the prefix of the number. Left pad “AR” with leading zeros.
Billing Contact This file contains the information for an active facility billing contact including billing contact name, title, phone, mailing address, customer number, customer name, and attention. This file only includes active contacts with the billing contact role. Columns Table Field Description 1 – 5 PA_IHW_FAC.SWR_NUM_TXT Solid Waste Registration number 6 – 55 AC_CONT.LAST_NAME_TXT Billing Contact name (individual’s last name) 56 – 85 AC_CONT.FIRST_NAME_TXT Billing Contact optional name (individual’s first name) 86 – 110 Billing Contact 111 – 140 AD_ELECTR_COMMU.CNTRY_CD and AREA_CD and ELECTR_COMMU_NUM and EXT_NUM Billing Contact’s phone number 141 – 183 AD_ADDRESS.DELIV_TXT Billing Contact’s mailing address. 184 – 223 AD_ADDRESS.DELIV_2_TXT Billing Contact’s mailing building name address line. 224 – 259 AD_ADDRESS.CITY_NAME Billing Contact’s mailing address city name 260 – 261 AD_ADDRESS.USPS_STATE_CD Billing Contact’s mailing address state abbreviation 262 – 266 AD_ADDRESS.ZIP_CD Billing Contact’s mailing address five digit zip code 267 – 270 AD_ADDRESS.ZIP_PLUS4_CD Billing Contact’s mailing address post four digit zip code 271 – 280 BT_ARS.AR_NUM Customer Number. Includes only the AR numeric portion, does not include the “AR” prefix of the number. Left pad with leading zeros.
17_Texas_Solid_Waste_System_Activity_File.docx