GetLedgerInfo

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

house

Six digit house number

cust

Two digit customer number

XML Tag

Column Name

Data Type

Nullable

Definition

cl_corp

CORP

INT UNSIGNED

N

Two digit system number assigned to each corp.Thecorp # is unique only within one Tandem system..

cl_partition

PARTITION

CHAR(2)

N

Data hashing value for database management - equals the last 2 digits of the house #.

cl_house

HOUSE

CHAR(6)

N

House number. Valid Values: Alpha/Numeric

cl_cust

CUST

CHAR(2)

N

Customer number.

ledgergroup

Beginning ledgergroup delimiter

ledger

Beginning ledger delimiter

cl_item

ITEM

SMALLINT UNSIGNED

N

Ledger item number (new). (See Usage section)

cl_ldgrdate

LDGRDATE

CHAR(5)

N

Date of this item. (MM/DD)

cl_ldtype

Beginning cl_ldtype delimiter

code

LDTYPE

CHAR(1)

N

Ledger type. Valid Values: 1=regular,2=collection,3=current adj,4=30 day adj,5=60 day adj,6=90 day adj,7=120 day adj

description

CHAR(30)

Ledger type description

cl_ldtype

Ending cl_ldtype delimiter

cl_amt

AMT

NUMERIC SIGNED

N

Dollar amount.

cl_colevent

COLEVENT

CHAR(7)

N

Collection event from the collections table/schemefor the last event processed for this customer. Valid Values: a-z

cl_sumcode

Beginning cl_sumcode delimiter

code

SUMCODE

CHAR(3)

N

Sum code for this ledger item. Valid Values: Range from 0 to +4094, excluding 46, 63, 832,845,2944, 2990, and 4032.

shortdescription

CHAR(8)

Sum code short description

longdescription

CHAR(30)

Sum code long description

/cl_sumcode

Ending cl_sumcode delimiter

cl_commentcnt

COMMENTCNT

SMALLINT UNSIGNED

N

Comment count tied to this ledger item.

cl_adjrsn

Beginning cl_adjrsn delimiter

code

ADJRSN

CHAR(1)

N

Adjustment reason. Valid Values: "00"-"ZZ"

shortdescription

CHAR(8)

Adjustment reason short description

longdescription

CHAR(30)

Adjustment reason long description

/cl_adjrsn

Ending cl_adjrsn delimiter

cl_collctevt

COLLCTEVT

CHAR(1)

N

Ledger collection event.

cl_newsumcode

Beginning cl_newsumcode delimiter

code

NEWSUMCODE

SMALLINT SIGNED

N

Numeric sum code column used to store sum codesfor all ledger items created after conversionto version 4.1.. Valid Values: Range from -1 to +4094, excluding 46, 63, 832,845,2944, 2990, and 4032. -1 mea ns the old SUMCODEcolumn is populated.

shortdescription

CHAR(8)

new adjustment reason short description

longdescription

CHAR(30)

new adjustment reason long description

/cl_newsumcode

Ending cl_newsumcode delimiter

cl_newadjrsn

Beginning cl_newadjrsn delimiter

code

NEWADJRSN

CHAR(2)

N

Two position adjustment reason column foradjustment reasons in custledger rows createdafter conversion to version 4.1.. Valid Values: "00" - "ZZ"

shortdescription

CHAR(8)

Adjustment reason short description

longdescription

CHAR(30)

Adjustment reason long description

/cl_newadjrsn

Ending cl_newadjrsn delimiter

cl_adjlditemtype

Beginning cl_adjlditemtype delimiter

code

ADJLDITEMTYPE

CHAR(1)

N

Adjustment ledger item type.. Valid Values: " " = adjustment only item, "+" = tax onadjustment item, "-" = adjustment with tax item.

description

CHAR(20)

N

Description

/cl_adjlditemtype

Ending cl_adjlditemtype delimiter

/ledger

Ending ledger delimiter

/ledgergroup

Ending ledgergroup delimiter

6/18/01

Added ledgergroup, ledger and cl_adjlditemtype delimiter tags to match server output