KS_DEPARTMENTS

Ordinal

Description

Data
Type

Data
Length

Required

Check
Constraints

Comments

1

Business Unit Number

string

30

Y

 

This is the internal business unit code which is used to lookup the KS key

2

Business Unit Name

string

60

 

 

A descriptive name for the business unit.

3

Business Unit Class

string

4

Y

 

This field declares what type of business unit such as 'DEPT' for department or 'DIV' for division. There are no edits on this field.

4

Parent Business Unit

string

30

Y

 

If this business unit is subordinate to a higher level unit, the parent unit can be put into this field. The internal parent business unit code is used as a lookup for the actual KS key row. Since this is a foreign key to the same table, the parent business unit referenced must also be included in the set of data being sent.