|
XML Tag |
Column Name |
Data Type |
Nullable |
Definition |
|
comcorp |
5 digit field |
INT UNSIGNED |
N |
Five digit accounting corp number assigned to each corp |
|
house |
6 character field |
CHAR(6) |
N |
House number. Numeric only |
|
opr |
3 character field |
CHAR(3) |
N |
Legal operator id |
|
optn |
short |
short |
N |
Option. Vaild Values 1, 2, 3 |
|
outletgroup |
outletgroup beginning delimiter |
|||
|
outlet |
outlet beginning delimiter |
|||
|
wo_outlet |
2 digit field |
short |
N |
Outlet number. Valid Values: 1-60 |
|
ratecode group |
ratecodegroup beginning delimiter |
|||
|
ratecode |
ratecode beginning delimiter |
|||
|
wor_ratecd |
2 character field |
CHAR(2) |
N |
Rate code associated with this charge level. |
|
wor_cnt |
short |
short |
N |
Rate code count for the service on this outlet Valid Values: |
|
pl_taskgp |
short |
short |
N |
packageline table taskgroup field |
|
non_std_amt |
6 digit field |
long |
N |
This is the non standard amount associated with a nonstandard rate code |
|
/ratecode |
ratecode ending delimiter |
|||
|
/ratecode group |
ratecodegroup ending delimiter |
|||
|
/outlet |
outlet ending delimiter |
|||
|
/outletgroup |
outletgroup ending delimiter |
|||
|
XML Tag |
Column Name |
Data Type |
Nullable |
|
|
comcorp |
5 digit field |
INT UNSIGNED |
N |
Five digit accounting corp number assigned to each corp |
|
house |
6 character field |
CHAR(6) |
N |
House number. Numeric only |
|
cust |
2 character field |
CHAR(2) |
N |
Customer number. Numeric values only. |
|
ratecodegroup |
ratecodegroup beginning delimiter |
|||
|
confirmed_ratecodes |
Beginning confirmed_ratecodes delimiter |
|||
|
ratecode |
ratecode beginning delimiter |
|||
|
wor_ratecd |
2 character field |
CHAR(2) |
N |
Rate code associated with this charge level. |
|
rate_description |
16 characters |
CHAR(16) |
N |
Rate Code Description |
|
wor_cnt |
short |
short |
N |
Rate code count for the service on this outlet Valid Values: |
|
wor_amt |
8 character field |
signed long |
N |
This is the price for the rate code formatted with the "decimal" point. |
|
/ratecode |
ratecode ending delimiter |
|||
|
/confirmed_ratecodes |
Ending confirmed_ratecodes delimiter |
|||
|
removed_ratecodes |
Beginning removed_ratecodes delimiter |
|||
|
ratecode |
ratecode beginning delimiter |
|||
|
wor_ratecd |
2 character field |
CHAR(2) |
N |
Rate code associated with this charge level. |
|
rate_description |
16 characters |
CHAR(16) |
N |
Rate Code Description |
|
wor_cnt |
short |
short |
N |
Rate code count for the service on this outlet Valid Values: |
|
wor_amt |
8 character field |
signed long |
N |
This is the price for the rate code formatted with the "decimal" point. |
|
/ratecode |
ratecode ending delimiter |
|||
|
/removed_ratecodes |
Ending removed_ratecodes delimiter |
|||
|
/ratecodegroup |
ratecodegroup ending delimiter |
|||
|
outletgroup |
outletgroup beginning delimiter |
|||
|
outlet |
outlet beginning delimiter |
|||
|
wo_outlet |
2 digit field |
short |
N |
Outlet number. Valid Values: 1-60 |
|
taskcodegroup |
taskcodegroup beginning delimiter |
|||
|
taskcode |
Beginning taskcode delimiter |
|||
|
wo_taskcode |
2 digit numeric |
CHAR(2) |
N |
This field is populated with the task code associated with the rate code defined in Director maintenance |
|
wo_pts |
short |
short |
N |
This field is populated with the points associated with the wo_tasks set in director maintenance option 20 |
|
/taskcode |
Ending taskcode delimiter |
|||
|
/taskcodegroup |
taskcodegroup ending delimiter |
|||
|
subtotal wo_pts |
short |
short |
N |
this field is populated with the total points of the outlet including the travel points if more than one outlet exists then the points accumulate for all the outlets but only include the travel points once |
|
outlet_hours |
6 character field |
CHAR(6) |
N |
this field is populated with the total hours of the outlet including the travel points if more than one outlet exists then the hours accumulate with all the outlet hours but only include the travel points once |
|
/outlet |
outlet ending delimiter |
|||
|
/outletgroup |
outletgroup ending delimiter |
|||
|
total wo_pts |
short |
short |
N |
this field is populated with the total points of the entire account including the travel points |
|
total_travel |
short |
short |
N |
this field is populated with the travel points |
|
total_hours |
6 character field |
CHAR(6) |
N |
this field is populated with the total hours of the entire account |
|
install_total |
7 character field |
CHAR(7) |
N |
Total of install rate codes on outlet; right-justified, includes decimal point |
|
service_total |
7 character field |
CHAR(7) |
N |
Total of service rate codes on outlet; right-justified, includes decimal point |
|
rent_total |
7 character field |
CHAR(7) |
N |
Total of rental rate codes on outlet; right-justified, includes decimal point |
|
deposit_total |
7 character field |
CHAR(7) |
N |
Total of deposit rate codes on outlet; right-justified, includes decimal point |
|
subscription_total |
7 character field |
CHAR(7) |
N |
Total of subscription rate codes on outlet; right-justified, includes decimal point |
|
confirmed_onetimecharges |
7 character field |
CHAR(7) |
N |
Total of one-time charges for rate codes on outlet; right-justified, includes decimal point (install + deposit) |
|
confirmed_subscriptioncharges |
7 character field |
CHAR(7) |
N |
Total of subscription rate codes on outlet; right-justified, includes decimal point |
|
confirmed_monthlycharges |
7 character field |
CHAR(7) |
N |
Total of monthly charges for rate codes on outlet; right-justified, includes decimal point (service + rent) |
|
6/14/01 |
Added confirmed_ratecodes and removed_ratecodes grouping tags |
|
Removed wor_sign and wor_catg from ratecode grouping |
|
|
6/29/01 |
Added rate_description data tag to supply the rate code description for both rate code groups. |
|
8/26/01 |
Added opr (operator id) tag field to document (Needed for checking of "free or X codes") |
Use GetOperatorId API transaction, oprids_makfree tag to determine if operator is allowed to give free codes.