Inbound Customer Data (ARI009)
  • 12 Jul 2024
  • 10 Minutes to read
  • Dark
    Light
  • PDF

Inbound Customer Data (ARI009)

  • Dark
    Light
  • PDF

Article summary

Interface Description

Florida PALM provides a customer record structure that allows each agency to maintain its own customer information for tracking receivables and revenues. This structure allows the agencies to capture unique customer information.

Customer records include general information, such as name, addresses, payment term, payment method, collector and credit analyst associated with the customer. Contact information like name, email address, and phone is captured on the customer record. Florida PALM also records important customer information like Taxpayer Identification Number (TIN) or Social Security Number (SSN), and Customer Type, e.g., General and FACTS related Customer Types. Additional fields are also provided to capture agency specific data.

Click below to view the interface file layout and sample data file.

Business Process Model

This interface can be found in the following business process:

Selection Criteria

The interface data selection criteria includes the following:

Data FieldData Field Details
None

File Layout

Field names and descriptions from the interface layout are provided below.

Data Field

Record Type

Data Field Description

Record Code

Customer Header

Record Code identifying the Customer Header information on the record.

Set ID

Customer Header

This field is used to specify Customer Set ID which is agency specific.

Customer ID

Customer Header

Uniquely identifies an individual or entity, that conducts business and/or financial transactions with the State of Florida or otherwise is obligated to pay funds or incurs debt to the State.

Customer Status

Customer Header

Current Status of the Customer.
 
 If updating existing customer to I - Inactive, provide required Customer Header record information only.

Customer Type

Customer Header

Type of Customer. Used to identify customer categories in reports.

Date Added

Customer Header

Enter the date when you established the customer in the system.
 If unknown, populate with a date of 01/01/1901.

Since Date

Customer Header

Specify that the customer has been a customer since a certain date, which may be the date added.
 If unknown, populate with the same date as the ADD_DT field. 

Name 1

Customer Header

Primary Name of the Customer. System will provide a warning in the Process Monitor if the customer’s name is duplicated. Agencies can utilize up to 40 characters to create a unique customer name.

Name 2

Customer Header

This is an overflow of the name of the customer that will be maintained in Florida PALM.

Short Name

Customer Header

Short Name of the Customer. Could be used as a unique identifier if the same customer “Name 1” is used across agency business systems or agency divisions. If left blank, system will default the Short Name to be the first 10 characters of the Name 1 data element.

Agency Customer ID

Customer Header

Agency Customer ID is created or provided by the agency for linking customer numbers.

Corporate Customer Checkbox

Customer Header

This field is used to identify if the customer is Corporate/Parent Customer.
 If left blank, system should default as "Y."

Agency Parent Customer ID

Customer Header

Agency Parent Customer ID is provided for linking Parent and Child relationship.
 
If the Agency Parent Customer ID is invalid, no Parent and Child relationship will be established.

Cust Char30 C

Customer Header

Field for Agency use

Cust Char30 D

Customer Header

Field for Agency use

Cust Char10 A

Customer Header

Field for Agency use

Cust Char10 B

Customer Header

Field for Agency use

Cust Char10 C

Customer Header

Field for Agency use

Cust Char10 D

Customer Header

Field for Agency use

Cust Char2

Customer Header

Field for Agency use

Cust Char4

Customer Header

Field for Agency use

Cust Char6

Customer Header

Field for Agency use

Cust Char8

Customer Header

Field for Agency use

Cust Char1 A

Customer Header

Field for Agency use

Cust Char1 B

Customer Header

Field for Agency use

Cust Char1 C

Customer Header

Field for Agency use

Cust Char1 D

Customer Header

Field for Agency use

Cust N12.3 A

Customer Header

Field for Agency use

Cust N12.3 B

Customer Header

Field for Agency use

Cust N12.3 C

Customer Header

Field for Agency use

Cust N12.3 D

Customer Header

Field for Agency use

Cust Nbr15 A

Customer Header

Field for Agency use

Cust Nbr15 B

Customer Header

Field for Agency use

Cust Nbr15 C

Customer Header

Field for Agency use

Cust Nbr15 D

Customer Header

Field for Agency use

Filler1

Customer Header

This field is reserved for future use in Florida PALM.

Filler2

Customer Header

This field is reserved for future use in Florida PALM.

Filler3

Customer Header

This field is reserved for future use in Florida PALM.

Filler4

Customer Header

This field is reserved for future use in Florida PALM.

Filler5

Customer Header

This field is reserved for future use in Florida PALM.

Record Code

Bill To Customer Option

Record Code identifying the Bill To Customer Option information on the record.

Customer Bill To Options Effective Date 

Bill To Customer Option

Customer Bill To Options are needed to save a customer.  
 Indicates the date the billing options are available for AR item transactions.
 
 If updating other Record Codes for an existing customer record, e.g., Customer Header, Customer Address Detail, these fields are not required.

Customer Bill To Options Effective Status

Bill To Customer Option

Customer Bill To Options are needed to save a customer.  
 This field is used to indicate Status of billing options available for AR item transactions.
 
 If updating other Record Codes for an existing customer record, e.g., Customer Header, Customer Address Detail, these fields are not required.

Filler1

Bill To Customer Option

This field is reserved for future use in Florida PALM.

Filler2

Bill To Customer Option

This field is reserved for future use in Florida PALM.

Filler3

Bill To Customer Option

This field is reserved for future use in Florida PALM.

Filler4

Bill To Customer Option

This field is reserved for future use in Florida PALM.

Filler5

Bill To Customer Option

This field is reserved for future use in Florida PALM.

Filler6

Bill To Customer Option

This field is reserved for future use in Florida PALM.

Filler7

Bill To Customer Option

This field is reserved for future use in Florida PALM.

Filler8

Bill To Customer Option

This field is reserved for future use in Florida PALM.

Filler9

Bill To Customer Option

This field is reserved for future use in Florida PALM.

Filler10

Bill To Customer Option

This field is reserved for future use in Florida PALM.

Record Code

Customer Address Detail

Record Code identifying the Customer Address Detail information on the record.

Address Sequence Number 

Customer Address Detail

Represents a unique, sequential identifier for a customer billing address. A customer can have multiple addresses associated with it.  
 
 For each new customer, start the address sequence with the number 1 and increment for each additional address.
 
 For updating existing customer address, provide the current Address Sequence Number which is equal to the Location online.

Effective Date 

Customer Address Detail

Indicates the date the address is available for transactions.
 In case of update to existing customer address, new effective dated row should be provided.

Effective Status

Customer Address Detail

This field is used to indicate Status of address.
 In case of update to existing customers, if Status changed from A to I then there has to be one Active row present with latest effective date for the customer address.

Description

Customer Address Detail

Agencies will provide an Address Description to help identify the location.
 Description will be mentioned for each unique address sequence numbers. 

Primary Bill To

Customer Address Detail

Indicates whether the address is a Primary Bill To address for the customer.
 Only one address must be designated as the primary/default billing address for the customer.

Primary Ship To

Customer Address Detail

Indicates whether address is the Primary Ship To address for the customer.
 Only one address must be designated as the primary/default ship to address for the customer.

Primary Sold To

Customer Address Detail

Indicates whether address is the Primary Sold To address for the customer.
 Only one address must be designated as the primary/default sold to address for the customer.

Address 1

Customer Address Detail

First Line of the Address

Address 2

Customer Address Detail

Second Line of the Address

Address 3

Customer Address Detail

Third Line of the Address

Address 4

Customer Address Detail

Fourth Line of the Address

City

Customer Address Detail

City for the customer address

County

Customer Address Detail

County

State

Customer Address Detail

State for the customer address

Postal

Customer Address Detail

Postal code for the customers address

Country

Customer Address Detail

Country Code

Filler1

Customer Address Detail

This field is reserved for future use in Florida PALM.

Filler2

Customer Address Detail

This field is reserved for future use in Florida PALM.

Filler3

Customer Address Detail

This field is reserved for future use in Florida PALM.

Filler4

Customer Address Detail

This field is reserved for future use in Florida PALM.

Filler5

Customer Address Detail

This field is reserved for future use in Florida PALM.

Filler6

Customer Address Detail

This field is reserved for future use in Florida PALM.

Filler7

Customer Address Detail

This field is reserved for future use in Florida PALM.

Filler8

Customer Address Detail

This field is reserved for future use in Florida PALM.

Filler9

Customer Address Detail

This field is reserved for future use in Florida PALM.

Filler10

Customer Address Detail

This field is reserved for future use in Florida PALM.

Record Code

Customer
 Contact

Record Code identifying the Customer Contact information on the record.
 This record is applicable only when customer have contacts.

Contact ID

Customer
 Contact

Assigning contacts to a customer is optional.
 
 A Customer can have more than one Address.
 A Contact can only be associated with one Address per Customer.
 A Contact can be associated with multiple Customers.
 A Contact associated with multiple Customers will have their own Contact/Address relationship.

Effective Date

Customer
 Contact

Indicates the date the contact is available for transactions.
 In case of update to existing customer contact, new effective dated row should be provided.

Effective Status

Customer
 Contact

This field is used to indicate Status of contact.
 In case of update to existing customers, if Status changed from A to I then there has to be one Active row present with latest effective date for the customer contact.

Contact Flag

Customer
 Contact

An attribute that describes the specific purpose of a given bank/counterparty contact person. 

Salutation Code

Customer
 Contact

Salutation for the contact

Address Sequence Number 

Customer
 Contact

Customer address that the contact must be linked to by using the Address Sequence Number or Location online.

Primary Bill Contact

Customer
 Contact

Indicates whether the contact is the Primary Bill To contact for the customer.

Primary Ship Contact

Customer
 Contact

Indicates whether the contact is the Primary Ship To contact for the customer.

Primary Sold Contact

Customer
 Contact

Indicates whether the contact is the Primary Sold To contact for the customer.

Title

Customer
 Contact

Title of the contact

Name

Customer
 Contact

Name of the contact

Communication Method

Customer
 Contact

Preferred Communication

Email ID

Customer
 Contact

A User's Email ID

Filler1

Customer
 Contact

This field is reserved for future use in Florida PALM.

Filler2

Customer
 Contact

This field is reserved for future use in Florida PALM.

Filler3

Customer
 Contact

This field is reserved for future use in Florida PALM.

Filler4

Customer
 Contact

This field is reserved for future use in Florida PALM.

Filler5

Customer
 Contact

This field is reserved for future use in Florida PALM.

Filler6

Customer
 Contact

This field is reserved for future use in Florida PALM.

Filler7

Customer
 Contact

This field is reserved for future use in Florida PALM.

Filler8

Customer
 Contact

This field is reserved for future use in Florida PALM.

Filler9

Customer
 Contact

This field is reserved for future use in Florida PALM.

Filler10

Customer
 Contact

This field is reserved for future use in Florida PALM.

Record Code

Customer Phone
 Contact

Record Code identifying the Customer Contact phone information on the record.

Phone Type

Customer Phone
 Contact

Phone number type, i.e., Business Phone, Cell Phone, etc. associated with the contact. 

Phone 

Customer Phone
 Contact

Telephone number.

Extension

Customer Phone
 Contact

Extension to the phone number associated with the contact.

Primary Phone

Customer Phone
 Contact

Indicate if the phone number represents the primary number for the contact. 

Filler1

Customer Phone
 Contact

This field is reserved for future use in Florida PALM.

Filler2

Customer Phone
 Contact

This field is reserved for future use in Florida PALM.

Filler3

Customer Phone
 Contact

This field is reserved for future use in Florida PALM.

Filler4

Customer Phone
 Contact

This field is reserved for future use in Florida PALM.

Filler5

Customer Phone
 Contact

This field is reserved for future use in Florida PALM.

Filler6

Customer Phone
 Contact

This field is reserved for future use in Florida PALM.

Filler7

Customer Phone
 Contact

This field is reserved for future use in Florida PALM.

Filler8

Customer Phone
 Contact

This field is reserved for future use in Florida PALM.

Filler9

Customer Phone
 Contact

This field is reserved for future use in Florida PALM.

Filler10

Customer Phone
 Contact

This field is reserved for future use in Florida PALM.

Record Code

Customer
 Correspondence

Record Code identifying the Customer Correspondence information on the record.
 At least one record is required for each Customer record.

Effective Date

Customer
 Correspondence

Indicates the date this correspondence options are  available for transactions.

Effective Status

Customer
 Correspondence

This field is used to indicate Status of correspondence.

Dispute Checkbox

Customer
 Correspondence

Indicates whether the customer is in dispute.

Dispute Status

Customer
 Correspondence

Indicates the reason of dispute.

Dispute Date

Customer
 Correspondence

Indicates the date when the customer was in dispute.

Filler1

Customer
 Correspondence

This field is reserved for future use in Florida PALM.

Filler2

Customer
 Correspondence

This field is reserved for future use in Florida PALM.

Filler3

Customer
 Correspondence

This field is reserved for future use in Florida PALM.

Filler4

Customer
 Correspondence

This field is reserved for future use in Florida PALM.

Filler5

Customer
 Correspondence

This field is reserved for future use in Florida PALM.

Filler6

Customer
 Correspondence

This field is reserved for future use in Florida PALM.

Filler7

Customer
 Correspondence

This field is reserved for future use in Florida PALM.

Filler8

Customer
 Correspondence

This field is reserved for future use in Florida PALM.

Filler9

Customer
 Correspondence

This field is reserved for future use in Florida PALM.

Filler10

Customer
 Correspondence

This field is reserved for future use in Florida PALM.

Record Code

Customer Numbers

Record Code identifying the Customer Numbers information on the record.

Standard ID Qualifier

Customer Numbers

Standard ID Qualifier

Standard ID Number 

Customer Numbers

ID number

Filler1

Customer Numbers

This field is reserved for future use in Florida PALM.

Filler2

Customer Numbers

This field is reserved for future use in Florida PALM.

Filler3

Customer Numbers

This field is reserved for future use in Florida PALM.

Filler4

Customer Numbers

This field is reserved for future use in Florida PALM.

Filler5

Customer Numbers

This field is reserved for future use in Florida PALM.

Filler6

Customer Numbers

This field is reserved for future use in Florida PALM.

Filler7

Customer Numbers

This field is reserved for future use in Florida PALM.

Filler8

Customer Numbers

This field is reserved for future use in Florida PALM.

Filler9

Customer Numbers

This field is reserved for future use in Florida PALM.

Filler10

Customer Numbers

This field is reserved for future use in Florida PALM.

Version History

DateRevision Description
12/01/2023Original Version
4/8/2024Updated the Name 1 and Short Name Descriptions in the file layout.

Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.