DCC Table

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.
0001 = Master Card or Visa
0002 = American Express
0003 = Discover Card

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
0 = No

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
Active = Not 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
2 = Monthly payments
3 = Bi-weekly payments
4 = Twice per month payments
5 = Weekly payments
6 = Settlement
7 = Multi-part settlement
8 = Promise payoff
9 = Every 28 days
10 = Monthly on last day

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