XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

at_code

2 character adj reason; blank = full table request

XML Tag

Column Name

Data Type

Nullable

Definition

at_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

at_required

REQUIRED

CHAR(1)

N

Y = Entry required, N = Not Required

adjtblgroup

Beginning adjtblgroup delimiter

code

Beginning code delimiter

at_code

CODE

CHAR(2)

N

Valid code for this table; 00 - ZZ

at_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 ADJ CODE

at_shortdesc

SHORTDES

CHAR(8)

N

Short description, not returned on full table request

at_longdesc

LONGDESC

CHAR(20)

N

Long description, not returned on full table reques.

at_sortflag

SORTFLAG

CHAR(1)

N

Sort Option/value. Valid Values: 1=name,2=addrs,3=zip/str,4=acct#,5=locCDW Daily 1=installer, 2=salesman; not returned on full table request

at_aging

AGING

CHAR(1)

N

Aging of the adjustment. Valid Values: Blank=current, 3=30 day aging, 6=60 day aging, 9=90 day aging, X=120 day aging; not returned on full table request

at_rptctr

RPTCTR

CHAR(2)

N

Reporting center OR rept center associated with the adjustment reason; not returned on full table request

at_tallycode

TALLYCODE

SMALLINT SIGNED

N

1=aging 2=mnths on cable 3=open to collctns 4=NPDcreated 5=NPD routed 6=NPD cmpltd 7=NSF checks 8=. Valid Values: Late fees 9=Writeoffs 10=Date ext 11=Partials 12=#Pymt 13=times at 120 14=times 90 15=a t 60 16=at; not returned on full table request

at_msocode

MSO CODE

CHAR(2)

N

Code to use in MSO Reporting; valid values 00-ZZ; not returned on full table request

/code

Ending code delimiter

/adjtblgroup

Ending adjtblgroup delimiter

5/10/01

Changed position of at_shortdesc and at_longdesc.

Changed tag from at_shortdes to at_shortdesc

Moved at_code within the code delimiter tags.