Customer activation file - available columns

The Customer Activation File (CAF) contains the following columns:

Column	Mandatory	Description
account_name	Y	This is the name of the account responsible for paying invoices.  Can be an individual, a husband and wife or a company/business name.
account_number	N	If you would like to link the account to an existing account number (eg add a water account to an existing power account) populate the existing account number here.
sales_cust_number	N	If migrating data from a legacy system or have a separate sales system and want to keep a cross-reference to that account number, enter it here. Please note that if this matches an existing sales customer number in Utilmate, this will do a move in to the site for the existing customer; it will not create a new account.
customer_type_code	Y	Use RESIDENT, COMPANY, OCCUPIER or SUNDRY
customer_sub_type_code	Y	Use DEFAULT for all except ones with a RESIDENT type.  For these, use OWNER or TENANT. Use DEVELOPER to exclude the customer from move in fees. This can be used when loading a 'Holding' type account for multiple new sites for a new building. Please note that this customer sub type may not be configured. Contact Utilmate support to confirm.
account_manager	Y	If the customer has a dedicated account manager enter it here.
district_code	N	NZL, VIC, NSW, SA, QLD, WA, ACT, TAX, NT
bill_cycle_code	Y	MONTHLY, QUARTERLY or HOLD
promo_allowed	N	Y or N
payment_method_type	Y	CHEQUE, DIRECT or CRDCARD
dd_bank_account_name	N	Joe Bloggs
dd_bank_account_number	N	00-0000-000000-00 in NZ or 000000-000000 in AUS
dd_credit_card_name	N	Joe Bloggs
dd_credit_card_number	N	0000 0000 0000 0000 (or use a third party token).
dd_credit_card_expiry	N	00/00
invoice_delivery_class	Y	EMAIL or POST
bond_amount	N	Please enter the amount of the bond being held eg 150.
customer_notes	N
contact1_first_name	Y
contact1_last_name	Y
contact1_phone_std	N	The area code eg 03, 06 etc (remember, excel often strips off leading zero's!)
contact1_phone_no	N	The landline phone number.
contact1_mobile_std	N
contact1_mobile_no	N	The mobile phone number (remember, excel often strips off leading zero's!)
contact1_date_of_birth	N	DD/MM/YYYY format
contact1_drivers_licence	N	Maximum 20 alphanumeric characters
contact1_drivers_expiry	N	DD/MM/YYYY format
contact1_abn_number	N
contact1_acn_number	N
contact1_email_address	N	Mandatory if the delivery preference is EMAIL.
post_addr_desc	N
post_addr_1	Y
post_addr_2	Y
post_addr_3	N
post_post_code	Y
product_type_code	Y	POWER, WATER, GAS, ISP or TELCO
site_status_code	Y	A = Active, D = De-energised
site_identifier	Y
network_node_code	Y	Must match a network node/ building code already in the system.
site_property_name	N
site_unit_type	N	Refer to the List Values tab in the CAF Example for the complete list of valid unit types.
site_unit_no	N
site_street_no	N
site_street_no_suffix	N
site_street_name	Y
site_street_type_code	Y	Refer to the List Values tab in the CAF Example for the complete list of valid street types.
site_suburb	Y
site_post_code	Y
site_state	Y	NZL, VIC, NSW, SA, QLD, WA, ACT, TAX, NT
site_location_desc	N
metering_type	Y	TOU or DEEMED
site_classification_code	N	RES or BUS
price_plan_code	Y	Must match a price plan code already in the system.
offering_code	Y	STANDARD, or must match an offering code already in the system.
move_in_date	Y	DD/MM/YYYY format

Unit Type		Street Type
Code		Code
APT	Apartment	ACCS	Access
BBQ	Barbeque	ALLY	Alley
BLCK	Block	ALWY	Alleyway
BLDG	Building	AMBL	Amble
BNGW	Bungalow	ANCG	Anchorage
CTGE	Cottage	ANT	Antenna
DUP	Duplex	APP	Approach
DUPL	Duplex	ARC	Arcade
F	Flat	ART	Artery
FCTY	Factory	ATM	Automated Teller Machine
FLAT	Flat	AV	Avenue2
FY	Factory	AVE	Avenue
GRGE	Garage	BASN	Basin
HSE	House	BBQ	Barbeque
KSK	Kiosk	BCH	Beach
LOT	Lot	BDGE	Bridge
LSE	Lease	BDWY	Broadway
OFF	Office	BEND	Bende
OFFC	Office	BLCK	Block
REAR	Rear	BLDG	Building
RESV	Reserve	BLK	Blank
SE	Suite	BNGW	Bungalow
SEC	Section	BOWL	Bowl
SHED	Shed	BRAE	Brae
SHOP	Shop	BRCE	Brace
SITE	Site	BRK	Break
TNCY	Tenancy	BROW	Brow
TNHS	Townhouse	BTSD	Boatshed
TWR	Tower	BVD	Boulevard
U	Unit	BVDE	BOULEVARDE
UNIT	Unit	BYPA	Bypass
VLLA	Villa	BYWY	Byway
WARD	Ward	CAGE	Cage
		CARP	Carpark
		CARS	Carspace
		CAUS	Causeway
		CCT	Circuit
		CDS	Cul-De-Sac
		CH	Chase
		CIR	Circle
		CL	Close
		CLDE	Colonnade
		CLT	Circlet
		CLUB	Club
		CMMN	Common
		CNR	Corner
		CNWY	Centreway
		CON	Concourse
		COOL	Coolroom
		COVE	Cove
		COWY	Cowy
		COWY	Crossway
		CPS	Copse
		CR	Crescent2
		CRCS	Cicrcus
		CRD	Crossroad
		CRES	Crescent
		CRSE	Course
		CRSG	Crossing
		CRSS	Cross
		CRST	Crest
		CSO	Corso
		CT	Court
		CTR	Centre
		CTTG	Cutting
		CTYD	Courtyard
		CUWY	Cruiseway
		DALE	Dale
		DELL	Dell
		DEVN	Deviation
		DIP	Dip
		DR	Drive
		DRWY	Driveway
		DSTR	Distributor
		DUPL	Duplex
		DWNS	DOWNS
		EDGE	Edge
		ELB	Elbow
		END	End
		ENT	Entrance
		ESP	Esplanade
		EST	Estate
		EXP	Expressway
		EXTN	Extension
		FAWY	Fairway
		FCTY	Factory
		FITR	Firetrail
		FLAT	Flat
		FOLW	Follow
		FORM	Formation
		FRNT	Front
		FRTG	Frontage
		FSHR	Foreshore
		FTRK	Fire Track
		FTWY	Footway
		FWY	Freeway
		GAP	Gap
		GDN	Garden
		GDNS	Gardens
		GLD	Glade
		GLEN	Glen
		GLY	Gully
		GR	Grove
		GRA	Grange
		GRGE	Garage
		GRN	Green
		GRND	Ground
		GTE	Gate
		GTES	Gates
		GTWY	Gateway
		HALL	Hall
		HETH	Heath
		HILL	Hill
		HRD	Highroad
		HTS	Heights
		HUB	Hub
		HWY	Highway
		INTG	Interchange
		INTN	Intersection
		ISLD	Island
		JNC	Junction
		KEY	Key
		KEYS	KEYS
		LANE	Lane
		LBBY	Lobby
		LDG	Landing
		LEES	Lees
		LINE	Line
		LINK	Link
		LKT	Lookout
		LNWY	Laneway
		LOFT	Loft
		LOOP	Loop
		LOT	Lot
		LSE	Lease
		LT	Little
		LWR	Lower
		MALL	Mall
		MBTH	Marine Berth
		MEW	Mew
		MEWS	Mews
		MILE	MILE
		MNDR	Meander
		MT	Mount
		MWY	Motorway
		NOOK	Nook
		OFFC	Office
		OTLK	Outlook
		OTLT	OUTLET
		PARK	Park
		PART	Part
		PASS	Pass
		PATH	Path
		PDE	Parade
		PHWY	Pathway
		PIAZ	Piazza
		PKLD	Parklands
		PKT	Pocket
		PKWY	Parkway
		PL	Place
		PLAT	Plateau
		PLM	Palms
		PLZA	Plaza
		PNT	Point
		PORT	Port
		PROM	Promenade
		PRST	Pursuit
		PSGE	Passage
		QDGL	Quadrangle
		QDRT	Quadrant
		QUAD	Quad
		QY	Quay
		QYS	Quays
		RAMP	Ramp
		RCH	Reach
		RD	Road
		RDGE	Ridge
		RDS	Roads
		RDSD	Roadside
		RDWY	Roadway
		REAR	Rear
		RES	Reserve
		REST	Rest
		RESV	Reserve
		RGWY	Ridgeway
		RIDE	Ride
		RING	Ring
		RISE	Rise
		RMBL	Ramble
		RND	Round
		RNDE	Ronde
		RNGE	Range
		ROOM	Room
		ROW	Row
		ROWY	Right Of Way
		RSBL	Rosebowl
		RTE	Route
		RTRN	Return
		RTT	Retreat
		RTY	Rotary
		RUE	Rue
		RUN	Run
		RVR	River
		RVRA	Riviera
		RVWY	Riverway
		SBWY	Subway
		SDNG	Siding
		SEC	Section
		SHRM	Showroom
		SHWY	State Highway
		SIGN	Sign
		SLPE	Slope
		SND	Sound
		SPUR	Spur
		SQ	Square
		ST	Street
		STH	SOUTH
		STLL	Stall
		STOR	Store
		STPS	Steps
		STR	Strata Unit
		STRA	Strand
		STRP	Strip
		STRS	Stairs
		STRT	STRAIGHT
		SUBS	Substation
		SWY	Service Way
		TARN	Tarn
		TCE	Terrace
		THOR	Thoroughfare
		TKWY	Trunkway
		TLWY	Tollway
		TNCY	Tenancy
		TOP	Top
		TOR	Tor
		TRI	Triangle
		TRK	Track
		TRL	Trail
		TRLR	Trailer
		TURN	Turn
		TWR	Tower
		TWRS	Towers
		UNIT	Unit
		UPAS	Underpass
		UPR	Upper
		VALE	Vale
		VDCT	Viaduct
		VIEW	Views
		VIEW	View
		VLGE	VILLAGE
		VLL	Villa
		VLLA	VILLA
		VLLS	Villa
		VLT	Vault
		VSTA	Vista
		WADE	Wade
		WALK	Walk
		WAY	Way
		WHRF	Whrf
		WHSE	Warehouse
		WKSH	Workshop
		WKWY	Walkway
		WOOD	Wood
		WTRS	Waters
		WYND	Wynd
		YARD	Yard
		BWLK	BOARDWALK
		CNN	CONNECTION
		FK	FORK
		MANR	MANOR
		TMWY	TRAMWAY
		WTWY	WATERWAY
		NA
		STW	Street West
		STE	Street East