GetRateInfo

Input XML Tags

XML Tag	Column Name	Data Type	Nullable	Definition
comcorp	Five digit system number assigned to each corp.
ratecode	2 character rate code	CHAR(2)	N	Rate code - to charge for a service or combo of services. Valid Values: Any two alpha characters. AZ-HZ are non-standard rates and codes beginning with 'X' are free rates.

Output XML Tags

XML Tag	Column Name	Data Type	Nullable	Definition
rcd_corp	CORP	INT UNSIGNED	N	Five digit accounting corp number assigned to each corp
rcd_rcode	RCODE	CHAR(2)	N	Rate code - to charge for a service or combo of services. Valid Values: Any two alpha characters. AZ-HZ are non-standard rates and codes beginning with 'X' are free rates.
rcd_rname	RNAME	CHAR(16)	N	Rate code description. Valid Values:
rcd_rdesc	RDESC	CHAR(8)	N	Rate code short description. Valid Values:
rcd_rmult	RMULT	CHAR(1)	N	Flag indicating whether this rate code is charged by customer or by outlet. Valid Values: 1=charge by outlet, =charge by customer
rcd_ramt	RAMT	CHAR(7)	N	Dollar amount to charge for this rate code formatted with decimal point.
rcd_ractv	RACTV	CHAR(1)	N	Flag indicating whether or not this rate code is currently active. Valid Values: 1=rate code is inactive =rate code active
rcd_rtype	RTYPE	CHAR(1)	N	Flag identifying this rate code as a primary or additional basic rate code. Valid Values: 1=primary rate code, 2=additional rate code =normal rate code
rcd_rcatg	RCATG	CHAR(1)	N	Rate code category. Valid Values: D=deposit, R=rent, S=service, I=install
rcd_rcarry	RCARRY	CHAR(1)	N	Flag indicating whether this rate code should be carried to additional outlets. Valid Values: 1=carry =don't carry
rcd_rbox	RBOX	CHAR(2)	N	Equipment code for this rate. Valid Values: or 0 - 99
rcd_rnonstd	RNONSTD	CHAR(1)	N	Non-standard rate code flag. Valid Values: 1=non standard rate code =regular rate code
rcd_rcombo	RCOMBO	CHAR(1)	N	If service is standalone but combo's with others -this will be the supplier code.. Valid Values: Supplier code for the standalone service
rcd_rdiscod1	RDISCOD1	CHAR(2)	N	Rate code number one for multiple outlet discounting. Valid Values:Any two alpha characters. AZ-HZ are non-standard rates and codes beginning with 'X' are free rates
rcd_rdiscod2	RDISCOD2	CHAR(2)	N	Rate code number one for multiple outlet discounting. Valid Values:Any two alpha characters. AZ-HZ are non-standard rates and codes beginning with 'X' are free rates
rcd_rdiscod3	RDISCOD3	CHAR(2)	N	Rate code number one for multiple outlet discounting. Valid Values:Any two alpha characters. AZ-HZ are non-standard rates and codes beginning with 'X' are free rates
rcd_rdiscod4	RDISCOD4	CHAR(2)	N	Rate code number one for multiple outlet discounting. Valid Values:Any two alpha characters. AZ-HZ are non-standard rates and codes beginning with 'X' are free rates
rcd_rdiscod5	RDISCOD5	CHAR(2)	N	Rate code number one for multiple outlet discounting. Valid Values:Any two alpha characters. AZ-HZ are non-standard rates and codes beginning with 'X' are free rates
rcd_rdiscod6	RDISCOD6	CHAR(2)	N	Rate code number one for multiple outlet discounting. Valid Values:Any two alpha characters. AZ-HZ are non-standard rates and codes beginning with 'X' are free rates
rcd_rsrvgrp	RSRVGRP	CHAR(1)	N	Rate code service group, used for reporting. Valid Values: 1-9
rcd_ract1strt	RACT1STRT	CHAR(2)	N	Accounting area range number one start value. Valid Values:
rcd_ract1stop	RACT1STOP	CHAR(2)	N	Accounting area range number 1 stop value. Valid Values:
rcd_ract2strt	RACT2STRT	CHAR(2)	N	Accounting area range number two start value. Valid Values:
rcd_ract2stop	RACT2STOP	CHAR(2)	N	Accounting area range number two stop value. Valid Values:
rcd_ract3strt	RACT3STRT	CHAR(2)	N	Rate code accounting area range 3: start value. Valid Values:
rcd_ract3stop	RACT3STOP	CHAR(2)	N	Accounting area range number three stop value. Valid Values:
rcd_rpays	RPAYS	SMALLINT UNSIGNED	N	The number of pay services this rate code represents. Valid Values:
rcd_rprcode	RPRCODE	CHAR(2)	N	New rate code that will be swapped over to when the promo code (rcode for this row) expires. Valid Values:
rcd_rcombos	RCOMBOS	CHAR(15)	N	List of supplier codes that indicates the servicescombined to make this combo code. Table 104.. Valid Values: 0-9, A-Z
rcd_prioramt	PRIORAMT	NUMERIC SIGNED	N	The dollar amount for this rate code prior to the new rate being put into RAMT. Valid Values:
rcd_effdate	EFFDATE	DATETIME	Y	The effective date for a rate change on this rate code OR MSO tables arc effective date. Valid Values:
rcd_actvoncyc	ACTVONCYC	CHAR(1)	N	Flags when Prorate Run is effective.. Valid Values: Y=Prorate Run effective on cycle N=Prorate Runeffective on date Prorate Run was run.
rcd_prorateoncyc	PRORATEONCYC	CHAR(1)	N	Flag that indicates how to handle a customer who had prorate with this rate code during a R/I. Valid Values: Y=Prorate at old amount N=Charge new rate in prorate from R/I eff . date
rcd_rprmonth	RPRMONTH	SMALLINT UNSIGNED	N	Number of months this promo code lasts. Valid Values: 1-95
rcd_format	FORMAT	CHAR(1)	N	Vendor box format OR mass corrections format OR MSO data rate code format. Valid Values: if MSO then - 0,1,3,4,5,7,9
rcd_digital	DIGITAL	SMALLINT SIGNED	N	Indicator value for digital rate codeor Indicates whether or not equipment is digitalfor =SUPPORTED_EQUIPMENT.. Valid Values: 0=analog event 1=digitalor0=not digital 1=digital
rcd_deliverysysid	DELIVERYSYSID	CHAR(20)	N	External system identifier. Each delivery systemis responsible for provisioning and/or deliveringa specific data service.. Valid Values: Alphanumeric character string
rcd_addressable	ADDRESSABLE	SMALLINT UNSIGNED	N	External system identifier. Each delivery systemis responsible for provisioning and/or deliveringa specific data service.. Valid Values: Alphanumeric character string