GetCollStepFlip

Input XML Tags

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

house

Six digit house number

cust

2 digit customer number

 

Output XML Tags

XML Tag

Column Name

Data Type

Nullable

Definition

cc_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

collectstepgroup

     

Beginning collectstepgroup delimiter

collectstep

     

Beginning collectstep delmiter

cc_nextdate

NEXTDATE

CHAR(5)

Y

Date the next collections step will occur MM/DD

cc_nextstep

NEXTSTEP

SMALLINT UNSIGNED

N

Next collection step number (1-99)

cps_description

DESCRIPTION

CHAR(12)

N

Description of Step

cpc_extradays

EXTRADAYS

SMALLINT UNSIGNED

N

Number of days between steps

/collectstep

     

Ending collectstep delmiter

/collectstepgroup

     

Ending collectstepgroup delimiter

         
         

 

Source Tables

 

Change Log

5/15/01

Added date formatting to cc_nextdate description

5/16/01

Changed cpc_extrdays to cpc_extradays

 

 

Usage

 

Associated XML Documents