Feedback

  • Contents
 

Bankruptcy Table

The Bankruptcy table contains bankruptcy information for accounts. Each account can have one bankruptcy record for one debtor only. To ensure that Exchange locates the correct debtor on the account, you must map the debtor field that you specified as unique criteria in the Unique Debtor Criteria section of the General tab. For more information, see Specify Unique Debtor Criteria.

Field Name

Description

Length

Data Type

Parent Table and Field

Import Types

AccountID

Code that Latitude assigned to identify the account. For new business imports, don't map this field. For maintenance imports, you must map this field to ensure that Exchange Manager locates the correct account.

4

Integer

Master/Number

NB, M

DebtorID

Code that Latitude assigned to identify the debtor associated to the bankruptcy. If you selected "Debtor ID" as the unique debtor criteria.

4

Integer

Debtors/DebtorID

NB, M

Seq

Code that indicates whether the debtor is the primary or secondary debtor on the account. If you selected "Seq" as the unique debtor criteria, you must map this field.

0 = Primary debtor
1 or greater = Secondary debtor

4

Integer

Debtors/Seq

NB, M

Relationship

Person's relationship to the account. If you selected "Relationship" as the unique debtor criteria, you must map this field.

30

VarChar

Debtors/Relationship

NB, M

Name

Debtor name. If you selected "Name" as the unique debtor criteria, you must map this field.

300

VarChar

Debtors/Name

NB, M

Chapter

Bankruptcy chapter. Values are 7, 11, 12, or 13.

1

TinyInt

None

NB, M

DateFiled

Bankruptcy filed date.

8

DateTime

None

NB, M

CaseNumber

Bankruptcy case number.

20

VarChar

None

NB, M

CourtCity

Bankruptcy court city.

50

VarChar

None

NB, M

CourtDistrict

Bankruptcy court district.

200

VarChar

None

NB, M

CourtDivision

Bankruptcy court division.

100

VarChar

None

NB, M

CourtPhone

Bankruptcy court phone number.

50

VarChar

None

NB, M

CourtStreet1

Bankruptcy court address line 1.

128

VarChar

None

NB, M

CourtStreet2

Bankruptcy court address line 2.

128

VarChar

None

NB, M

CourtState

Bankruptcy court state.

3

VarChar

None

NB, M

CourtZIPCode

Bankruptcy court ZIP Code.

15

VarChar

None

NB, M

Trustee

Trustee's name.

50

VarChar

None

NB, M

TrusteeStreet1

Trustee's address line 1.

128

VarChar

None

NB, M

TrusteeStreet2

Trustee's address line 2.

128

VarChar

None

NB, M

TrusteeCity

Trustee's city.

100

VarChar

None

NB, M

TrusteeState

Trustee's state.

3

VarChar

None

NB, M

TrusteeZIPCode

Trustee's ZIP Code.

10

VarChar

None

NB, M

TrusteePhone

Trustee's phone number.

30

VarChar

None

NB, M

Has341Info

Flag that indicates whether the customer set the creditors meeting. 
1 = Yes

0 = No

1

Bit

None

NB, M

DateTime341

Date and time of the meeting of creditors.

8

DateTime

None

NB, M

Location341

Meeting of creditors location.

200

VarChar

None

NB, M

Comments

Bankruptcy comments.

500

VarChar

None

NB, M

Status

Bankruptcy status.

100

VarChar

None

NB, M

TransmittedDate

Date AIM or another interface transmitted the bankruptcy information. If you map to this field, the system doesn't populate it in the table unless you also map AIM information in Exchange.

4

SmallDate

None

NB, M

AuctionAmount

Amount the auction house received for the surrendered item. Available for bankruptcy chapter 7 where method = "Surrender" only. 

8

Money

None

NB, M

AuctionAmountApplied

Amount of the auction funds applied to the account. Available for bankruptcy chapter 7 where method = "Surrender" only.

8

Money

None

NB, M

AuctionDate

Date the auction house auctioned the surrendered item. Available for bankruptcy chapter 7 where method = "Surrender" only.

8

DateTime

None

NB, M

AuctionFee

Fee the auction house charged for auctioning the surrendered item. Available for bankruptcy chapter 7 where method = "Surrender" only.

8

Money

None

NB, M

AuctionHouse

Name of the auction house that auctioned the surrendered item. Available for bankruptcy chapter 7 where method = "Surrender" only.

50

VarChar

None

NB, M

BankruptcyID

Code that Latitude assigns to identify the bankruptcy record. Don't map this field.

4

Integer

None

NB

ConfirmationHearingDate

Confirmation hearing date.

8

DateTime

None

NB, M

ConvertedFrom

Original bankruptcy chapter number.

1

TinyInt

None

NB, M

CTL

Do not use (reserved for AIM).

3

VarChar

None

NB, M

DateNotice

Date the client received a notice that the debtor filed for bankruptcy.

8

DateTime

None

NB, M

DischargeDate

Date the court discharged the bankruptcy. 

8

DateTime

None

NB, M

DismissalDate

Date the court dismissed the bankruptcy.

8

DateTime

None

NB, M

HasAsset

Indicates whether the debtor has assets to secure the debt. Available for bankruptcy chapter 7 only.

1 = Yes

0 = No

1

Bit

None

NB, M

ProofFiled

Date the client sent a proof of claim to the court.

8

DateTime

None

NB, M

Reaffirm

Indicates whether the debtor reaffirmed the debt under new terms.

R = Reaffirmation
S = Surrender
V = Voluntary payments

Blank = No intention to reaffirm

1

Char

None

NB, M

ReaffirmAmount

Amount that the debtor reaffirmed to pay.

8

Money

None

NB, M

ReaffirmDateFiled

Date the debtor filed the reaffirmation with the court.

8

DateTime

None

NB, M

ReaffirmTerms

Reaffirmation terms.

50

VarChar

None

NB, M

SecuredAmount

Amount of the debt that is secured. Available for bankruptcy chapters 11, 12, and 13 only.

8

Money

None

NB, M

SecuredPercentage

Percentage of the secured amount for which the debtor remains responsible. Available for bankruptcy chapters 11, 12, and 13 only.

4

SmallMon

None

NB, M

SurrenderDate

Date the debtor surrendered the item. Available for bankruptcy chapter 7 only.

8

DateTime

None

NB, M

SurrenderMethod

Method the debtor used to surrender the item (shipped or picked up). Available for bankruptcy chapter 7 only.

50

VarChar

None

NB, M

UnsecuredAmount

Amount of the debt that is unsecured. Available for chapters 11, 12, and 13 only.

8

Money

None

NB, M

UnsecuredPercentage

Percentage of the unsecured amount for which the debtor remains responsible. Available for chapters 11, 12, and 13 only.

4

SmallMon

None

NB, M

VoluntaryAmount

Amount the debtor volunteered to pay. Available for bankruptcy chapter7, voluntary payment method only.

8

Money

None

NB, M

VoluntaryDate

Date the debtor volunteered to pay off the debt. Available for bankruptcy chapter7, voluntary payment method only.

8

DateTime

None

NB, M

VoluntaryTerms

Terms of the voluntary payment agreement. Available for bankruptcy chapter 7, voluntary payment method only.

50

VarChar

None

NB, M

Related Topics

Destination Fields