|
XML Tag |
Definition |
|
comcorp |
Five digit system number assigned to each corp. |
|
house |
Six digit house number |
|
cust |
Two digit customer number |
|
XML Tag |
Column Name |
Data Type |
Nullable |
Definition |
|
cr_corp |
CORP |
INT UNSIGNED |
N |
Two digit system number assigned to each corp.Thecorp # is unique only within one Tandem system. |
|
cr_house |
HOUSE |
CHAR(6) |
N |
House number. Valid Values: Alpha/Numeric |
|
cr_cust |
CUST |
CHAR(2) |
N |
Customer number. |
|
custservicegroup |
Beginning custservicegroup delimiter |
|||
|
custservice |
Beginning custservice delimiter |
|||
|
cr_flag |
Beginning cr_flag delimiter |
|||
|
code |
CHAR(1) |
N |
Flag indicating the type of Service. Valid Values: C = current, P = Pending, W = WIP Rate |
|
|
description |
CHAR(20) |
Service type description. |
||
|
/cr_flag |
Ending cr_flag delimiter |
|||
|
cr_serv |
SERV |
CHAR(2) |
N |
Rate code. |
|
cr_rtcnt |
RTCNT |
SMALLINT UNSIGNED |
N |
Rate code count. |
|
rcd_ramt |
RAMT |
NUMERIC UNSIGNED |
N |
Dollar amount to charge for this rate code. |
|
rcd_rdesc |
RDESC |
CHAR(8) |
||
|
rcd_rname |
RNAME |
CHAR(16) |
N |
Rate code description. |
|
wcr_ratesign |
RATESIGN |
CHAR(1) |
N |
Sign for rate code,adding or subtracting. 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 |
|
svcnet_outlets |
CHAR(200) |
N |
List of outlets that contain this service. Comma delimited. |
|
|
custservice |
Ending custservice delimiter |
|||
|
custservicegroup |
Ending custservicegroup delimiter |