Feedback

  • Contents
 

Payment Table

The Payment table contains payments for accounts. Each account can have multiple payment records. This table corresponds to the Payhistory table in the Latitude database.

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 financial and maintenance imports, you must map this field to ensure that Exchange Manager locates the correct account.

4

Integer

Master/Number

NB, F, M

Amount

Payment amount.

Maps to TotalPaid field.

8

Money

None

NB, F, M

AdjustmentAmount1

Amount paid against the principle balance.

Maps to Paid1 field.

8

Money

None

NB, F, M

AdjustmentAmount2

Amount paid against the interest balance.

Maps to Paid2 field.

8

Money

None

NB, F, M

AdjustmentAmount3

Amount paid against money bucket 3.

Maps to Paid3 field.

8

Money

None

NB, F, M

AdjustmentAmount4

Amount paid against money bucket 4.

Maps to Paid4 field.

8

Money

None

NB, F, M

AdjustmentAmount5

Amount paid against money bucket 5.

Maps to Paid5 field.

8

Money

None

NB, F, M

AdjustmentAmount6

Amount paid against money bucket 6.

Maps to Paid6 field.

8

Money

None

NB, F, M

AdjustmentAmount7

Amount paid against money bucket 7.

Maps to Paid7 field.

8

Money

None

NB, F, M

AdjustmentAmount8

Amount paid against money bucket 8.

Maps to Paid8 field.

8

Money

None

NB, F, M

AdjustmentAmount9

Amount paid against money bucket 9.

Maps to Paid9 field.

8

Money

None

NB, F, M

AdjustmentAmount10

Amount paid against money bucket 10.

Maps to Paid10 field.

8

Money

None

NB, F, M

PaymentDate

Payment date.

Maps to DatePaid field.

8

DateTime

None

NB, F, M

PaymentType

Type of payment batch (BatchType field in the Latitude table).

3

VarChar

None

NB, F, M

AdjustmentBucket

Bucket number to which to apply the payment.

 

 

None

NB, F, M

PaymentID

Code that identifies a payment transaction that an AIM agency or attorney returned (PAIdentifier field in the Latitude table).

30

VarChar

None

NB, F, M

Comments

Comments regarding the payment.

30

Char

None

NB, F, M

PayMethod

Payment method (for example, check, money order).

30

VarChar

None

NB, F, M

CheckNumber

Check number associated to the payment.

30

VarChar

None

NB, F, M

Desk

Desk that receives credit for the payment. You must have already created this code in Latitude.

10

VarChar

None

NB, F, M

SubBatchType

(Optional) Secondary code that identifies a batch.

3

Char

None

NB, F, M

IsSettlement

Flag that indicates whether the payment settles the account.

1 = Yes, sets account to SIF after processing
0 = No, doesn't set account to SIF

1

Bit

None

NB, F, M

IsCorrection

Flag for PUR and PCR payment types that indicates whether the payment reversal is a correction.

1 = Yes, doesn't set NSF flag on account
0 = No, sets NSF flag on account

1

Bit

None

NB, F, M

IsFreeDemand

Flag that indicates whether to apply the fee schedule to the payment (within the customer's free demand period).

1 = Yes
0 = No

1

Bit

None

NB, F, M

PostDateUID

Not used.

4

Integer

None

NB, F, M

FeeCode

Code that identifies the fee to apply to the payment (FeeSched field in the Latitude table). You must have already created this code in Latitude.

30

VarChar

None

NB, F, M

IsEchoBack

Flag that indicates whether the payment is valid.

1 = Yes, payment exists and debtor is just verifying

0 = No, payment wasn't entered

Maps to Echo field.

1

Bit

None

NB, F, M

AIMAgencyID

Latitude code that identifies the outside collection agency or attorney where the customer placed the account.

4

Integer

None

NB, F, M

AIMDueAgency

Amount owed to the outside collection agency or attorney.

8

Money

None

NB, F, M

AIMAgencyFee

Outside collection agency's or attorney's fee amount.

8

Money

None

NB, F, M

AIMBatchID

Code that identifies the AIM payment batch.

4

Integer

None

NB, F, M

AIMSendingID

Code that identifies the outside collection agency or attorney sending the payment.

4

Integer

None

NB

LatitudeReceivedAIMGracePeriod

Not used.

 

 

None

F, M

AIMPlacedGracePeriod

Not used.

 

 

None

F, M

OverrideAIMProperties

Not used.

 

 

None

F, M

SetAIMProperties

Not used.

 

 

None

NB, F, M

Related Topics

Destination Fields