Master Table

Field Name

Description

Length

Data Type

Parent Table and Field

Import Types

SH_RequestID

Code that identifies a vendor service request for the account.

4

Integer

ServiceHistory/RequestID

NB, M

Number

Code that Latitude assigns to identify the account. For new business records, leave this field blank and let Latitude assign the number. For financial, maintenance, and final recall records, provide the code that Latitude assigned previously.

4

Integer

None

NB, F, M, R

Account

Code that the customer assigned to identify the account.

30

VarChar

None

NB, F, M, R

Customer

Name of the customer.

7

VarChar

None

NB, F, M, R

CustDivision

Customer's division.

15

VarChar

None

NB, M

CustDistrict

Customer's district.

15

VarChar

None

NB, M

CustBranch

Customer's branch.

15

VarChar

None

NB, M

Desk

Code that identifies the desk to assign to the account. The code must exist in Latitude.

10

VarChar

None

NB, F, M, R

Desk1

Field used under the direction of Latitude by Genesys.

10

VarChar

None

NB, M

Desk2

Field used under the direction of Latitude by Genesys.

10

VarChar

None

NB, M

Branch

Code that identifies the agency branch. The code must exist in Latitude.

5

VarChar

None

NB, M

Status

Code that identifies the status of the account, such as open or closed. The code must exist in Latitude.

5

VarChar

None

NB, F, M, R

ClaimType

Code that identifies the claim type used to determine the statute of limitations. The code must exist in Latitude.

5

VarChar

None

NB, M

ClassOfBusiness

Code that identifies the class of business to which the account belongs. The code must exist in Latitude.

5

VarChar

None

NB, M

ID1

Custom identification code that your organization assigns.

40

VarChar

None

NB, F, M, R

ID2

Custom identification code that your organization assigns.

40

VarChar

None

NB, F, M, R

Score

Credit score for the account.

2

SmallInt

None

NB, F, M

OriginalCreditor

Original creditor on the account.

50

VarChar

None

NB, M

PreviousCreditor

Previous owner of account (usually for purchased debt).  

50

VarChar

None

NB, M

FeeCode

Latitude code that identifies the fee assigned to the account. If blank, Latitude uses the customer's default fee schedule.

30

VarChar

None

NB, F, M, R

PurchasedPortfolioName

Name of the purchased portfolio.

50

VarChar

Portfolio/PortfolioName

R

PurchasedPortfolio

Code that identifies a purchased portfolio.  

7

VarChar

None

NB, M, R

SoldPortfolioName

Name of the sold portfolio.

50

VarChar

Portfolio/PortfolioName

R

SoldPortfolio

Code that identifies a sold portfolio.

7

VarChar

None

NB, M, R

Name

Debtor name in "lastname, firstname MI suffix" format. 

30

VarChar

Debtors/Name

NB, M

Other

Debtor's alternate or alias name.

30

VarChar

Debtors/Othername

NB, M

Street1

Primary debtor's address line 1.  

128

VarChar

Debtors/Street1

NB, M

Street2

Primary debtor's address line 2. 

128

VarChar

Debtors/Street2

NB, M

City

Primary debtor's city.  

30

VarChar

Debtors/City

NB, M

State

Primary debtor's state.   

3

VarChar

Debtors/State

NB, M

ZIPCode

Primary debtor's ZIP Code.  

10

VarChar

Debtors/Zipcode

NB, M

MR

Flag that indicates whether the primary address is good.

Y = Yes, address is good

N = No, address is bad or unknown

1

VarChar

Debtors/MR

NB, M

HomePhone

Primary debtor's home phone number.

30

VarChar

Debtors/Homephone

NB, M

WorkPhone

Primary debtor's work phone number.  

30

VarChar

Debtors/Workphone

NB, M

SSN

Primary debtor's social security number.  

15

VarChar

Debtors/SSN

NB, M

DOB

Primary debtor's date of birth.

8

DateTime

Debtors/DOB

NB

Received

Date your organization received the account. If blank, Exchange populates this field with the current date. 

8

DateTime

None

NB, M

Closed

Date and time your organization closed the account.

8

DateTime

None

NB, M

Returned

Date and time your organization returned the account.

8

DateTime

None

NB, M

Archived

Date and time your organization archived the account.

8

DateTime

None

NB, M

Viewed

Date and time a user last viewed the account.

8

DateTime

None

NB, M

Worked

Date and time a user last worked the account.

8

DateTime

None

NB, M

Contacted

Date and time a user last contacted the account.

8

DateTime

None

NB, M

StatuteDate

Date the statute of limitations expires for the account.

8

DateTime

None

NB, M

ContractDate

Date the debtor started the account with the customer.

8

DateTime

None

NB, M

CLIDLC

Last date your organization charged the customer.

8

DateTime

None

NB, M

CLIDLP

Last date the customer paid your organization.

8

DateTime

None

NB, M

ChargeOffDate

Date the customer charged off the account.

8

DateTime

None

NB, M

LastPaid

Date the customer last received payment on the account.

8

DateTime

None

NB, M

BPDate

Broken promise date.

8

DateTime

None

NB, M

FeeSchedule

Not used.

5

VarChar

None

NB, M

DelinquencyDate

Date the customer flagged the account as delinquent.

8

DateTime

None

NB, M

LastInterest

Date interest last accrued.

8

DateTime

None

NB, F, M

UserDate1

Custom date field.

8

DateTime

None

NB, F, M, R

UserDate2

Custom date field.

8

DateTime

None

NB, F, M, R

UserDate3

Custom date field.

8

DateTime

None

NB, F, M, R

CLIALC

Last amount your organization charged the customer.

8

Money

None

NB

CLIALP

Last amount the customer paid your organization.

8

Money

None

NB

LastPaidAmount

Last payment amount received on the account.

8

Money

None

NB, M

InterestRate

Simple interest rate used to calculate interest on the account. Formatted as 00.00 (for example, 15.5% interest rate shows as 15.50).

8

Money

None

NB, F, M

Current0

Total current balance (sum of Current1 through Current10 money buckets).

8

Money

None

NB, M

Current1

Current principal balance in money bucket 1.

8

Money

None

NB, M

Current2

Current interest balance in money bucket 2.

8

Money

None

NB, M

Current3

Current balance in money bucket 3.

8

Money

None

NB, M

Current4

Current balance in money bucket 4.

8

Money

None

NB, M

Current5

Current balance in money bucket 5.

8

Money

None

NB, M

Current6

Current balance in money bucket 6.

8

Money

None

NB, M

Current7

Current balance in money bucket 7.

8

Money

None

NB, M

Current8

Current balance in money bucket 8.

8

Money

None

NB, M

Current9

Current balance in money bucket 9.

8

Money

None

NB, M

Current10

Current balance in money bucket 10.

8

Money

None

NB, M

Original

Total original balance (sum of Original1 through Original10 money buckets).

8

Money

None

NB, M

Original1

Original principal balance in money bucket 1.

8

Money

None

NB, M

Original2

Original interest balance in money bucket 2.

8

Money

None

NB, M

Original3

Original balance in money bucket 3.

8

Money

None

NB, M

Original4

Original balance in money bucket 4.

8

Money

None

NB, M

Original5

Original balance in money bucket 5.

8

Money

None

NB, M

Original6

Original balance in money bucket 6.

8

Money

None

NB, M

Original7

Original balance in money bucket 7.

8

Money

None

NB, M

Original8

Original balance in money bucket 8.

8

Money

None

NB, M

Original9

Original balance in money bucket 9.

8

Money

None

NB, M

Original10

Original balance in money bucket 10.

8

Money

None

NB, M

Paid

Total amount paid (sum of Paid1 through Paid10 money buckets).

8

Money

None

NB, M

Paid1

Principal amount paid against money bucket 1.

8

Money

None

NB, M

Paid2

Interest amount paid toward money bucket 2.

8

Money

None

NB, M

Paid3

Amount paid against money bucket 3.

8

Money

None

NB, M

Paid4

Amount paid against money bucket 4.

8

Money

None

NB, M

Paid5

Amount paid against money bucket 5.

8

Money

None

NB, M

Paid6

Amount paid against money bucket 6.

8

Money

None

NB, M

Paid7

Amount paid against money bucket 7.

8

Money

None

NB, M

Paid8

Amount paid against money bucket 8.

8

Money

None

NB, M

Paid9

Amount paid against money bucket 9.

8

Money

None

NB, M

Paid10

Amount paid against money bucket 10.

8

Money

None

NB, M

QLevel

Code that identifies the account queue level. The code must exist in Latitude.

3

VarChar

None

NB, F, M, R

QDate

Date for the account to appear in the Collector queue.

8

DateTime

None

NB, M

QTime

Time for the account to appear in the Collector queue.

4

VarChar

None

NB, M

QFlag

Flag that indicates whether to display the account in a queue.  

1 = Yes

0 = No

1

VarChar

None

NB, M

Queue

Not used.

26

VarChar

None

NB, M

QueueHold

Not used.

8

DateTime

None

NB, M

Accrued2

Interest accrued against the account since placement.

8

Money

None

NB, M

Accrued10

Transaction surcharges applied against the account since placement.

8

Money

None

NB, M

AgencyCode

Not used.

5

VarChar

None

NB, M

AgencyFlag

Not used.

1

TinyInt

None

NB, M

AIMAgency

Code that identifies the outside agency to which a user assigned the account. The code must exist in AIM.

4

Integer

None

NB, M

AIMAssigned

Date the customer assigned the account to an outside agency.

8

DateTime

None

NB, M

AssignedAttorney

Date the customer assigned the account to an attorney.

8

DateTime

None

NB, M

Attorney

Not used.

5

VarChar

None

NB, M

AttorneyAccountID

Not used.

30

VarChar

None

NB, M

AttorneyID

Code that identifies the attorney to which the customer assigned the account. The code must exist in AIM.

4

Integer

None

NB, M

AttorneyLawList

"You Got Claims" ID.

5

VarChar

None

NB, M

AttorneyStatus

Indicates whether the customer placed the account with an attorney.

Placed = Customer placed the account. 

NULL = Not placed.

15

VarChar

None

NB, M

BlanketSIFOverride

Blanket settlement percentage set for the customer.

8

Float

None

NB, M

CBRException

Exception that prevents reporting the debtor to the credit bureaus.

2

Smallint

None

NB, M

CBRExtendDays

Number of days from normal credit bureau reporting date to delay reporting.

4

Integer

None

NB, M

CBROverride

Flag that indicates whether to override the automated credit bureau reporting evaluation.

1 = Yes

0 = No

1

Bit

None

NB, M

CBRPrevent

Flag that indicates whether to prevent reporting of the account to the credit bureaus.

1 = Yes

0 = No

1

Bit

None

NB, M

Complete1

Not used.

8

DateTime

None

NB, M

Complete2

Not used.

8

DateTime

None

NB, M

CTL

General-purpose flag. Used for things such as converting records to Latitude or flagging records from certain programs  

3

VarChar

None

NB, M

CurrencyType

Not used.

20

VarChar

None

NB, M

DMDateStamp

Not used.

10

VarChar

None

NB, M

ExtraCodes

Not used.

40

VarChar

None

NB, M

Finders

Not used.

8

DateTime

None

NB, M

FirstDesk

Not used.

10

VarChar

None

NB, M

FirstReceived

Not used.

8

DateTime

None

NB, M

Full0

Not used.

8

DateTime

None

NB, M

HasBigNote

Not used.

1

VarChar

None

NB, M

InterestBuckets

Account-level override to specify which money buckets to use as the principal value when calculating interest. This field overrides the same field on the Customer table, which overrides the system default of only using the principal bucket Current1. 

Interest accrues based on the values of Current1 and Current3. Exchange doesn't support Current2 as Latitude doesn't calculate compounded interest. 

2

Smallint

None

NB, M

Link

Code that identifies the linked accounts group to which the account belongs. The code must exist in Latitude.

4

Integer

None

NB, M

LinkDriver

Flag that indicates whether the account is the link driver.

1 = Yes

0 = No

1

Bit

None

NB, M

NSF

Flag that indicates whether the account had insufficient funds posted.

Default = NULL (no NSF)

T = Yes

1

VarChar

None

NB, M

NSFDate

Date the last NSF posted on the account.

8

DateTime

None

NB, M

PromAmt

Not used.

8

Money

None

NB, M

PromDue

Not used.

8

DateTime

None

NB, M

PSEQ

Sequence number of the primary debtor on the account. Most programs assume that the primary debtor is sequence zero, so this field is always zero.

4

Integer

None

NB, M

RestrictedAccess

Flag that indicates whether the account has restricted access and requires permission to access the account.

1 = Yes

0 = No

1

Bit

None

NB, M

Salary

Not used.

8

Money

None

NB, M

Salesman1ID

Not used.

4

Integer

None

NB, M

Salesman2ID

Not used.

4

Integer

None

NB, M

Salesman3ID

Not used.

4

Integer

None

NB, M

SEQ

Not used.

4

Integer

None

NB, M

SIFPct

Not used.

8

Money

None

NB, M

SysMonth

System processing month.

1

TinyInt

None

NB, M

SysYear

System processing year.

2

SmallInt

None

NB, M

TotalContacted

Number of times agents contacted the debtor.

4

Integer

None

NB, M

TotalViewed

Number of times agents viewed the account.

4

Integer

None

NB, M

TotalWorked

Number of times that agents worked the account.

4

Integer

None

NB, M

Secured

Flag that indicates whether the account is for a secured loan.

1 = Yes

0 = No

1

Bit

None

NB, M

ShouldQueue

Flag that indicates whether to display the account in a user's queue.

1 = Yes
0 = No

1

Bit

None

NB, M