INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within interface request.

CUS_ID

Req

X

A unique Id for the customer.

CURRENCY_ID

Req

C! 3

For multi-currency users, this identifies which currency the customer uses.

ACTIVITY_CD

Req

C! 1

Required for all activity. Possible values are:

• A (Add) – If a record with the same key already exists, PENTA records an error.

• C (Change) – Update an existing record. If PENTA cannot update the column, it records an error.

ACCT_NUM

Req

X

Number of the receivable account.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within interface request.

CUS_ID

Req

X

A unique Id for the customer.

CONTACT_NUM

Req

I 3

PENTA auto assigns the Contact # with the next sequential number for this Customer. For example, if this is the first location you are setting up under the Customer, this column defaults as 1.

ACTIVITY_CD

Req

C! 1

Required for all activity. Possible values:

• A (Add) – If a record with the same key already exists, PENTA records an error.

• C (Change) – Update an existing record. If PENTA cannot update the column, it records an error.

FIRST_NAME

Opt

C 15

The first name of the customer contact.

LAST_NAME

Opt

C 20

The last name of the customer contact.

CONTACT_TYPE_CD

None

C 3

This must be left blank. This classifies the Contact.

CONTACT_TITLE_NUM

Opt

I 4

Enter the title of the contact.

EMAIL_ADDR

Opt

C 50

Enter the email address of the contact.

CUS_LOC_CD

None

C 8

This must be left blank. This is the location of the customer.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within interface request.

CUS_ID

Req

X

A unique Id for the customer.

CONTACT_NUM

Req

I 3

PENTA auto assigns the Contact # with the next sequential number for this Customer. For example, if this is the first location you are setting up under the Customer, this column defaults as 1.

PHONE_NUM_TYPE_
CD

Req

C 8

Categorize the number you will use to reach the contact person (cell, pager, office, etc.).

ACTIVITY_CD

Req

C! 1

Required for all activity. Possible values are:

• A (Add) – If a record with the same key already exists, PENTA records an error.

• C (Change) – Update an existing record. If PENTA cannot update the column, it records an error.

PHONE_AREA_CD

Req

C 3

Enter the area code of the number you will use to reach the contact person.

PHONE_NUM

Req

C 11

Enter the number for the contact person.

PHONE_EXT

Opt

C 5

Enter the extension of the number for the contact person.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within interface request.

CUS_ID

Req

X

A unique Id for the customer.

ACTIVITY_CD

Req

C! 1

Required for all activity. Possible values are:

• A (Add) – If a record with the same key already exists, PENTA records an error.

• C (Change) – Update an existing record. If PENTA cannot update the column, it records an error.

CUS_TYPE_CD

Req

C! 1

Possible values are:

• C (Regular Customer)

• E (Employee)

• I (Intercompany Customer)

NAME_PREFIX

Opt

C 15

Prefix of the Customer’s name.

NAME

Req

C 30

Name of the Customer.

CUS_STAT_CD

Req

C! 1

Indicates whether the customer is available for assignment to new jobs, work orders, and sales orders. If you mark the Customer as inactive, PENTA still lets you process billing for existing jobs and work orders.

PROSPECT_CD

Req

C! 1

A value here indicates that the customer is a prospective customer, as opposed to an actual customer.

EMP_ID

Opt

X

A value here associates the Customer with an employee for the purpose of employee receivables.

PAR_CUS_ID

Opt

X

If the Customer is considered a “child” under a larger “parent” customer, identify that parent customer.

DEF_INVOICE_CUS_
LOC_CD

Opt

C 8

Id of the Customer Location.

PRIMARY_CONTACT_
NUM

Opt

I 3

The Customer’s primary contact person.

CURRENCY_ID

Opt

C! 3

Identify the currency you will use for the Customer’s normal billings. This serves as the default to the job contract line item.

You can only access this column if System Option #44 is N.

CR_LIMIT_AMT

Opt

F 15.2

Enter the dollar amount that represents the maximum amount of open receivables that may exist for this Customer at a point in time.

CR_LIMIT_HOLD_CD

Opt

C! 6

Use the Credit Limit Hold Code column to associate a hold code with the Credit Limit. Apply the hold code logic on work orders, maintenance contracts, and jobs set up for the Customer. If you assign a “hard” Customer Hold Code (below), PENTA prevents set up of new entities. If you assign a “soft” Customer Hold Code, PENTA allows set up of new work orders and assigns a hold status. Soft holds do not apply to Maintenance Contracts and Jobs. If you assign a “no hold” Customer Hold Code, PENTA does nothing in the Work Order, Maintenance Contract, or Job setup windows.

AR_DAYS_OPEN_LIMIT

Opt

I 5

The maximum day limit you allow for open receivables on this Customer at any point in time. Entry or updates to this column do NOT affect existing open work orders or maintenance contracts. PENTA does not analyze the open receivable days outstanding status for this Customer, and places open work orders on a credit hold if the days outstanding of the oldest AR invoice exceed the allowable limit. PENTA applies the entered limit to future work orders, maintenance contracts, and jobs.

AR_DAYS_HOLD_CD

Opt

C! 6

Enter the hold code you want to associate with the AR Days Limit condition. You cannot enter this if the AR Days Outstanding Limit column is null. PENTA applies the hold code logic on Work Orders, Maintenance Contracts, and Jobs set up for the Customer. Available holds are:

• Soft Hold – PENTA allows set up of new work orders and assigns a hold status. Soft holds do not apply to maintenance contracts and jobs.

• Hard Hold – PENTA prevents set up of new entries.

• No Hold – PENTA does nothing in the Work Order, Maintenance Contract, or Job setup windows. PENTA displays the Hold Code description and the Hold Level associated with the Hold Code.

AR_HOLD_CD

Opt

C! 6

Id of the Hold applied to the Customer. PENTA places all work orders on hold for this Customer Location where the Work Order’s status if Unassigned or Ready for Assignment.

• Soft – If you select this and set up a new WO, PENTA allows you to create the WO and assigns a Hold WO Status.

• Hard – If you select this and set up a WO, MC, or Job, PENTA prevents set up.

• No – If you select this and set up a WO, MC, or Job, PENTA takes no action.

AR_STMT_CD

Req

C! 1

Indicates whether you want to print AR statements for the Customer.

CR_RT_CD

Opt

C! 3

Id of the Customer’s Credit Rating.

G_ALL_OU_CD

Req

C! 1

Indicate whether the Customer has authorization for All (A) or Some (S) OUs.

INVOICE_FORM_ID

Opt

C! 8

Identify the form you want to use when printing the Customer’s invoices. PENTA defaults this value to any new job you set up for the Customer.

NUM_COPIES

Opt

I 3

Quantify the invoice copies you must print for the Customer.

PAY_TERM_NUM

Opt

I 3

Designate a payment term as being the default payment term for all projected related invoices billed under this Customer.

INVOICE_CYCLE_NUM

Opt

I 3

Defines the various periods and times at which you wish to generate invoices. PENTA uses invoice cycle numbers to select and group jobs when you request an invoices processing run. PENTA defaults this value to any new job you set up for the Customer.

EQ_RENT_BILL_DISC

Opt

F 7.3

Enter the discount percent you want to apply to equipment rental cost you bill to jobs for the Customer.

OTH_PAY_CD

Req

C! 1

Indicate whether PENTA should use Other Pay costs in the calculation of cost plus billings.

REIMB_CD

Req

C! 1

Indicate whether PENTA should use Reimbursement costs in the calculation of cost plus billings.