- Contents
Exchange Manager Help
DCC Table
The Debtor Credit Cards (DCC) table contains customer credit card payments for accounts. Each account can have multiple credit card payment records.
Field Name |
Description |
Length |
Data Type |
Parent Table and Field |
Import Types |
Number |
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 |
Amount |
Payment amount. |
8 |
Money |
None |
NB, M |
Approved |
Transaction approval date. |
8 |
DateTime |
None |
NB, M |
ApprovedBy |
User who approved the transaction. |
10 |
VarChar |
None |
NB, M |
CardNumber |
Credit card number. |
30 |
VarChar |
None |
NB, M |
City |
Credit card holder's city. |
25 |
VarChar |
None |
NB, M |
Code |
Credit card security code. |
10 |
VarChar |
None |
NB, M |
CollectorFee |
Credit card transaction fee. |
8 |
Money |
None |
NB, M |
CreditCard |
Code that identifies the credit card
type. |
4 |
VarChar |
None |
NB, M |
DateEntered |
Transaction date. |
4 |
SmallDate |
None |
NB, M |
DebtorID |
Code that Latitude assigned to identify the customer associated to the credit card transaction. |
4 |
Integer |
Debtors/DebtorID |
NB, M |
DepositDate |
Scheduled deposit date. |
4 |
SmallDate |
None |
NB, M |
ExpMonth |
Credit card expiration month. |
2 |
VarChar |
None |
NB, M |
ExpYear |
Credit card expiration year. |
2 |
VarChar |
None |
NB, M |
IsActive |
Flag that indicates whether the credit card is active. 1 = Yes |
1 |
Bit |
None |
NB, M |
LetterCode |
Code that identifies the Notice of Intention to Deposit (NITD) letter in Latitude. |
5 |
VarChar |
None |
NB, M |
Name |
Name on the credit card. |
30 |
VarChar |
None |
NB, M |
NITDSendDate |
Date to send NITD letter. |
4 |
SmallDate |
None |
NB, M |
NITDSentDate |
Date user sent the NITD letter. |
8 |
DateTime |
None |
NB, M |
NSFCount |
Number of insufficient funds transactions. |
4 |
Integer |
None |
NB, M |
OnHoldDate |
Date the agent placed the transaction on hold. |
4 |
SmallDate |
None |
NB, M |
Printed |
Flag that indicates whether the transaction printed. 1 = Yes 0 = No |
1 |
VarChar |
None |
NB, M |
PrintedDate |
Transaction printed date. |
8 |
DateTime |
None |
NB, M |
ProcessStatus |
Transaction processing status. Closed = Processed |
25 |
VarChar |
None |
NB, M |
ProjectedFee |
Fee to apply to the transaction. |
8 |
Money |
None |
NB, M |
PromiseMode |
Payment arrangement type. 1 = Single payment |
1 |
TinyInt |
None |
NB, M |
State |
Code that identifies the credit card holder's state of residence. |
3 |
VarChar |
None |
NB, M |
Street1 |
Credit card holder's address line 1. |
128 |
VarChar |
None |
NB, M |
Street2 |
Credit card holder's address line 2. |
128 |
VarChar |
None |
NB, M |
Surcharge |
Surcharge amount applied to the transaction. |
8 |
Money |
None |
NB, M |
UseProjectedFee |
Not used. |
1 |
Bit |
None |
NB, M |
ZIPCode |
Credit card holder's ZIP Code. |
10 |
VarChar |
None |
NB, M |