- Contents
Exchange Manager Help
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 |
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. 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 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 |