GetCODTable

Input XML Tags

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

codt_code

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

 

Output XML Tags

XML Tag

Column Name

Data Type

Nullable

Definition

codt_corp

CORP

UNSIGNED INT

N

Five digit accounting corp number assigned to each corp

codt_required

REQUIRED

CHAR(1)

N

Y = Entry required, N = Not Required

codtablegroup

Beginning codtablegroup delimiter

codcode

Beginning codcode delimiter

codt_code

CODE

CHAR(1)

N

Valid code for this table; 0-9, A-Z

codt_desc

DESC

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

codt_shortdes

SHORTDES

CHAR(8)

N

Short Description, not returned on full table request

codt_longdesc

LONGDESC

CHAR(20)

N

Long Description; not returned on full table request

codt_sortflag

SORTFLAG

CHAR(1)

N

Sort option/value; not returned on full table request

codt_codcat

CODCAT

CHAR(6)

N

COD category. Valid values: 1=install, 2=service, 3=rent, 4=deposit, 5=pay, 6=prorate; not returned on full table request

/codcode

Ending codcode delimiter

/codtablegroup

Ending codtablegroup delimiter

 

Source Tables