GetCode95
Input XML Tags
|
XML Tag |
Definition |
|
comcorp |
Five digit system number assigned to each corp. |
|
table_number |
Table number of code 95 table |
|
c95_code |
Legal values; 1 - 95, blank = full table request |
Output XML Tags
|
XML Tag |
Column Name |
Data Type |
Nullable |
Definition |
|
c95_corp |
CORP |
INT UNSIGNED |
N |
Five digit accounting corp number assigned to each corp |
|
c95_tabl |
TABL |
CHAR(3) |
N |
Table number |
|
c95_required |
REQUIRED |
CHAR(1) |
N |
Y = Entry required |
|
code95group |
|
Beginning code95group delimiter |
||
|
code |
|
Beginning code delimiter |
||
|
c95_code |
CODE |
CHAR(2) |
N |
Valid code from the table (1 – 95) |
|
c95_desc |
DESCRIPTION |
CHAR(13) |
N |
Equals long description if long description is 13 characters or less, otherwise equals short description; NOT RETURNED IF "INPUT" INCLUDES SPECIFIC CODE95 CODE |
|
c95_shortdes |
SHORTDES |
CHAR(8) |
N |
Short Description, not returned on full table request |
|
c95_longdesc |
LONGDESC |
CHAR(20) |
N |
Long Description; not returned on full table request |
|
c95_wrkpnts |
WRKPNTS |
CHAR(2) |
N |
Work points tied to this task; not returned on full table request |
|
c95_socgrp |
SOCGRP |
CHAR(2) |
N |
Social group tied to the cluster code; not returned on full table request |
|
c95_countoutage |
COUNTOUTAGE |
CHAR(1) |
N |
Count this type as an outage type N = no, Y = yes; not returned on full table request |
|
c95_nctexempt |
NCTEXEMPT |
CHAR(1) |
N |
Identifies this task code as a custom type task; Y = custom type task, N = not custom; not returned on full table request |
|
c95_msocode |
MSOCODE |
CHAR(1) |
N |
Code to use in MSO reporting (1 – 95); not returned on full table request |
|
/code |
|
Ending code delimiter |
||
|
/code95group |
|
Ending code95group delimiter |
Source Tables
Usage
c95_code thru c95_msocode are repeatable for each code in the database.
Associated XML Documents