GetSchedAreas

Input XML Tags

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

 

Output XML Tags

XML Tag

Column Name

Data Type

Nullable

Definition

sa_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

schedulegroup

     

Beginning schedulegroup delimiter

area

     

Beginning area delimiter

sa_schdes

SCHDES

CHAR(6)

N

Schedule area designator (F/T, mgt, zip)2 positions if f/t,3 if mgt,6 if zip-left justify. Valid Values:

sa_schnam

SCHNAM

CHAR(19)

N

Name of schedule area. Valid Values:

sa_schwip

SCHWIP

CHAR(1)

N

Schedule area for quota for WIP orders. Valid Values: 1-9, A-Z

sa_cyc

CYC

CHAR(1)

N

Cycle default for accounts in this schedule area. Valid Values: A-H

sa_schtc

SCHTC

CHAR(1)

N

Schedule area for quota for trouble calls. Valid Values: 1-9,A-Z

sa_schsro

SCHSRO

CHAR(1)

N

Schedule area for quota for sro's. Valid Values: 1-9,A-Z

sa_schhub

SCHHUB

SMALLINT UNSIGNED

N

Default hub number for certain box types in this schedule area. Valid Values:

/area

     

Ending area delimiter

/schedulegroup

     

Ending schedulegroup delimiter

 

Source Tables