XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

table_number

Table number of code 36 table

c36_code

legal values, 0-9, A-Z, blank = full table request

XML Tag

Column Name

Data Type

Nullable

Definition

c36_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

c36_tabl

TABL

CHAR(3)

N

Table number

c36_required

REQUIRED

CHAR(1)

N

Y = Entry required, N = Not Required

code36group

Beginning code36group delimiter

code

Beginning code delimiter

c36_code

CODE

CHAR(1)

N

Valid code from the table (0 -9, A-Z)

c36_desc

DESCRIPTION

CHAR(14)

N

Equals long description if long description is 14 characters or less, otherwise equals short description; NOT RETURNED IF "INPUT" INCLUDES SPECIFIC CODE36 CODE

c36_shortdes

SHORTDES

CHAR(8)

N

Short Description, not returned on full table request

c36_longdesc

LONGDESC

CHAR(20)

N

Long Description; not returned on full table request

c36_sortflag

SORTFLAG

CHAR(1)

N

Sort option/value; not returned on full table request

c36_msocode

MSOCODE

CHAR(1)

N

Code to use in MSO reporting (00 - ZZ); not returned on full table request

/code

Ending code delimiter

/code36group

Ending code36group delimiter