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.

FRNG_CD

Req

C! 1

Indicate whether PENTA includes Taxable Fringe costs in the cost plus billing calculation.

NT_FRNG_CD

Req

C! 1

Indicate whether PENTA should use Non-Taxable Fringe costs in the cost plus billing calculation.

BURDEN_CD

Req

C! 1

Indicate whether PENTA should use Payroll Burden costs in the cost plus billing calculation.

INVOICE_OH_CD

Req

C! 1

Indicate whether PENTA should use Overhead costs in the cost plus billing calculation.

SPLIT_PREM_CD

Opt

C! 1

Indicate how you want PENTA to reflect overtime on the labor support schedule reports:

• C (Complete) – PENTA

LAB_RATE_SCHD_NUM

Opt

I 3

The default rate schedule for all labor items billed for invoices under this Customer. PENTA defaults this value to any new job you set up for this Customer.

EQ_RATE_SCHD_NUM

Opt

I 3

The default rate schedule for all Equipment billed for invoices under this Customer. PENTA defaults this value to any new job you set up for this Customer.

CT_MKUP_SCHD_NUM

Opt

I 3

The default rate schedule for all costs from accounts payable and general journal entries billed for invoices under this Customer. PENTA defaults this value to any new job you set up for this Customer.

INV_MKUP_SCHD_
NUM

Opt

I 3

The default rate schedule for all Inventory Items billed for invoices under this Customer. PENTA defaults this value to any new job you set up for this Customer.

DSCNT_PCT

Opt

F 8.5

A percentage as being the default discount percent given to this Customer when you process a sales order. The value must be a positive number from zero to 100.

INVOICE_DTL_CD

Opt

C! 1

A checkmark indicates you want sales orders for this Customer to include both detail lines and total lines. Not placing a checkmark in this box indicates you want sales orders for this Customer to include only total lines.

TAX_EXEMPT_
REASON_CD

Opt

C! 3

If the Customer is exempt from paying taxes, enter the code for the exemption reason.

TAX_CERTIFICATE

Opt

C 15

If the Customer is exempt from paying sales taxes, use this column to enter the customer’s Tax Exemption Certificate number.

CARRIER_ID

Opt

C! 8

For items sold to this Customer via sales orders, identify the preferred Shipping Carrier (e.g., FedEx, UPS, etc.).

SHIP_METHOD_CD

Opt

C! 8

The Customer has preferred method of shipment. Typically, ground, next day, two day, etc. are usable values in this column. Valid values originate in the Shipping Methods window.

WHSE_ID

Opt

C! 4

Identify the default warehouse from which you pull inventory to fill sales orders for this Customer.

FOB_CD

Req

C! 1

Placing a checkmark in this box indicates you are responsible for the transportation costs of shipping goods to the Customer. Not placing a checkmark in this box indicates the Customer is responsible for shipments.

DEF_SHIP_CUS_LOC_
CD

Opt

C 8

Designate a location as being the default destination for shipments to this Customer.

SO_PROD_PRICE_
SCHD_NUM

Opt

I 3

The default pricing schedule used to process sales orders for the Customer.

WO_INVOICE_
LAYOUT_NUM

Opt

I 3

Designate an invoice format as being the default invoice format you will use for the Customer’s bills.

Note: PENTA first seeks to use the WO Invoice Layout # you established at the Customer/Location level. If there is no WO Invoice Layout # at that level, PENTA instead uses this Customer level WO Invoice Layout #.

WO_SALESPERSON_
EMP_ID

Opt

X

Identify your salesperson for this customer. PENTA defaults this value to each Work Order you assign to this customer.

Note: PENTA first seeks to use the Salesperson Employee Id you established at the Customer/Location level. If there is no Salesperson Employee Id at that level, PENTA instead uses this Customer level Salesperson Employee Id

WO_MIN_INVOICE_
AMT

Opt

F 15.2

Designate the minimum amount for which you want to generate an invoice for this Customer. For example, you might not want to generate and invoice for < $10. If the amount PENTA calculates when processing invoices is less than the specified amount, it does not generate an invoice.

WO_MAX_INVOICE_
AMT

Opt

F 15.2

Designate the maximum amount for which you want to generate an invoice for this Customer. For example, you might not want to generate and invoice for < $10. If the amount PENTA calculates when processing invoices is less than the specified amount, it does not generate an invoice.

WO_PAY_TERM_NUM

Opt

I 3

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

WO_SERVICE_CHARGE_ID

Opt

C! 8

Enter the service charge applicable for this Customer.

WO_INV_MKUP_SCHD_NUM

Opt

I 3

The maximum amount for which you want to generate an invoice for this Customer. For example, you might not want to generate and invoice for < $10. If the amount PENTA calculates when processing invoices is less than the specified amount, it does not generate an invoice.

WO_EQ_RATE_SCHD_NUM

Opt

I 3

Id of the pricing schedule for all equipment billed for the Customer’s work order invoices.

WO_LAB_RATE_SCHD_NUM

Opt

I 3

Id of the pricing schedule for all labor billed for the Customer’s work order invoices.

WO_CT_MKUP_SCHD_NUM

Opt

I 3

Id of the cost type markup-pricing schedule for the Customer’s work order invoices.

WO_LI_STRUCT_NUM

Opt

I 3

The invoice line item structure assigned for all work orders set up for this Customer Location.

CUS_PO_REQD

Opt

C! 1

Indicate whether you want to require the entry of a Customer PO # when setting up Work Orders assigned to this Customer Location

UNIT_BILL_SCHD_
NUM

Opt

I 8

Enter the Unit Billing Rate Schedule used to price unit rate work for your customers. PENTA defaults this value to all Work Orders associated with this Customer Location.

REGION_ID

Opt

C 8

Enter the Regional Unit Billing Rate Schedule used to price unit rate work for your customers. PENTA defaults this value to all Work Orders associated with this Customer Location.

AR_ACCT_NUM

Opt

X

System Option 44 (“Multi-Currency for Accounting”) affects the information you can and cannot enter here.

• If System Option 44 is Y – Enter the default AR Account you want PENTA to use when processing AR transactions for this Customer/Currency. PENTA posts AR entries to this account and creates the appropriate subledger entries. PENTA limits the allowable accounts to those with an edit rule code of AR in Finance & Accounting’s Chart of Accounts window.

• If System Option 44 is N – Enter the default AR Account you want PENTA to use when processing AR transactions for this Customer/Currency. PENTA posts the AR entries to this account and creates the appropriate subledger entries. PENTA charges this account when the accounts receivable transaction involves the Customer/Currency. PENTA limits the allowable accounts to those with an edit rule code of AR in Finance & Accounting’s Chart of Accounts window.

PURCHASES_TAXABLE_INDICATOR

Opt

C! 1

Indicates whether purchases are taxable.

BILLINGS_TAXABLE_
INDICATOR

Opt

C! 1

Indicates whether billings are taxable.

PURCHASES_TAX_
CERTIFICATE

Opt

C 15

If purchases are not taxable, this is the Id of the certificate showing proof of tax exemption.

PURCHASES_TAX_
EXEMPT_REASON_CD

Opt

C! 3

Explanation for why the purchase is tax exempt.

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.

CUS_LOC_CD

Req

C 8

Use the Location column to specify whether the work is for a particular customer site.

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.

DESCR

Req

C 30

Name of the Customer Location.

CUS_LOC_TYPE_CD

Opt

C 8

Id of the categorization for the Customer Location.

NAME_PREFIX

Opt

C 15

Enter the prefix of the customer’s name.

NAME

Opt

C 30

Defaults as the customer’s name unless an explicit null (~) is used.

VALID_INVOICING_
ADDR_CD

Req

C! 1

Indicates if the address is valid for invoicing. Default is Y.

VALID_SHIPPING_
ADDR_CD

Req

C! 1

Indicates if the address is valid for shipping. Default is Y.

PHONE_AREA_CD

Opt

C 3

Enter the area code of the customer location’s number.

PHONE_NUM

Opt

C 11

Enter the customer location’s number.

PHONE_EXT

Opt

C 5

Enter the extension of the customer location’s number.

PRIMARY_CONTACT_
NUM

Opt

I 3

You cannot enter this value on Activity Code A records—as the contact does not exist yet.

BUILDING_MANAGER

Opt

C 30

Identify the Location’s building manager.

ADDR_1

Opt

C 30

First line of the Location’s address.

ADDR_2

Opt

C 30

Second line of the Location’s address.

ADDR_3

Opt

C 30

Third line of the Location’s address.

CITY

Req

C 20

City of the Location.

ST_CD

Req

C! 4

State/province of the Location.

POSTAL_CD

Req

C 10

Postal code of the Location.

COUNTRY_CD

Opt

C! 3

Id of the Location’s country.

G_ALL_OU_CD

Req

C! 1

Indicates which OUs the Location is valid for. Possible values are:

• A (All)

• S (Some)

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

You can only enter this value if there is a value for the Credit Limit Amount.

AR_DAYS_OPEN_LIMIT

Opt

I 5

Quantify 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 column 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:

• 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

You can only enter this value if there is a value for the AR Days Outstanding Limit.

WO_INVOICE_LAYOUT_NUM

Opt

I 3

This value applies to the Location Service Management Parameters.

WO_SALESPERSON_
EMP_ID

Opt

X

This value applies to the Location Service Management Parameters.

WO_SERVICE_ZONE_
CD

Opt

C! 10

This value applies to the Location Service Management Parameters.

WO_SERVICE_CHARGE_ID

Opt

C! 8

This value applies to the Location Service Management Parameters.

WO_INV_MKUP_
SCHD_NUM

Opt

I 3

The maximum amount for which you want to generate an invoice for this Customer. For example, you might not want to generate and invoice for < $10. If the amount PENTA calculates when processing invoices is less than the specified amount, it does not generate an invoice.

WO_EQ_RATE_SCHD_
NUM

Opt

I 3

Id of the pricing schedule for all equipment billed for the Location’s work order invoices.

WO_LAB_RATE_SCHD_NUM

Opt

I 3

Id of the pricing schedule for all labor billed for the Location’s work order invoices.

WO_CT_MKUP_SCHD_
NUM

Opt

I 3

Id of the cost type markup pricing schedule for the Customer’s work order invoices.

WO_LI_STRUCT_NUM

Opt

I 3

The invoice line item structure assigned for all work orders set up for this Customer Location.

CUS_PO_REQD

Req

C! 1

Indicate whether you want to require the entry of a Customer PO # when setting up work orders assigned to this Customer Location

UNIT_BILL_SCHD_
NUM

Opt

I 8

This value applies to the Service Management Parameters.

REGION_ID

Opt

C 8

This value applies to the Service Management Parameters.

PURCHASES_TAXABLE_INDICATOR

Opt

C! 1

Indicates whether purchases are taxable.

BILLINGS_TAXABLE_
INDICATOR

Opt

C! 1

Indicates whether billings are taxable.

PURCHASES_TAX_
CERTIFICATE

Opt

C 15

If purchases are not taxable, this is the Id of the certificate showing proof of tax exemption.

PURCHASES_TAX_
EXEMPT_REASON_CD

Opt

C! 3

Explanation for why the purchase is tax exempt.

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.

CUS_LOC_CD

Opt

C 8

Use the Location column to specify whether the work is for a particular customer site.

D_EFF_DATE

Req

D

The effective date.

WO_CALL_TYPE_CD

Req

C! 8

Use the Call Type column to categorize the nature of the service call.

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.

WO_INVOICE_CUS_ID

Req

X

The Work Order Invoice’s Customer Id.

WO_INVOICE_CUS_
LOC_CD

Req

C 8

The Work Order Invoice’s Customer Location Id.

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.

CUS_LOC_CD

Opt

C 8

Use the Location column to specify whether the work is for a particular customer site.

D_EFF_DATE

Req

D

The effective date.

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, PENTA records an error.

WO_INVOICE_CUS_ID

Opt

X

The Work Order Invoice’s Customer Id.

WO_INVOICE_CUS_
LOC_CD

Opt

C 8

The Work Order Invoice’s Customer Location.

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.

CUS_LOC_CD

Req

C 8

Use the Location column to specify whether the work is for a particular customer site.

D_EFF_DATE

Req

D

The effective date.

WO_SERVICE_TYPE_
CD

Req

C! 8

Id of the Work Order’s Service Type.

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.

WO_INVOICE_CUS_ID

Req

X

The Work Order Invoice’s Customer Id.

WO_INVOICE_CUS_LOC_CD

Req

C 8

The Work Order Invoice’s Customer Location Id.

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.

CUS_LOC_CD

Req

C 8

Use the Location column to specify whether the work is for a particular customer site.

D_EFF_DATE

Req

D

The effective date.

CUS_LOC_STAT_CD

Req

C! 1

Status of the Customer Location.

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.

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.

CUS_LOC_CD

Opt

C 8

Use the Location column to specify whether the work is for a particular customer site.

OU_ID

Req

X

Id of the Organizational Unit.

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.

• D (Delete) – Delete an existing record. If PENTA cannot delete the column, it records an error.

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 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.

CUS_LOC_CD

Opt

C 8

Specifies whether the work is for a particular customer Location. Can be null.

CUS_REF_CD

Req

C 15

ID referring to Customer-specific information.

ACTIVITY_CD

Req

C! 1

Required for all activity. Possible values are:

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

• D (Delete) – Delete an existing record. If PENTA cannot delete the column, it records an error.

CUS_REF_VALUE

Opt

C 30

The value for the associated Customer Reference Code.

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.

CUS_REF_CD

Req

C 15

ID referring to Customer-specific information.

CUS_REF_VALUE

Req

C 30

The value for the associated Customer Reference Code.

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.

DESCR

Req

C 30

A note or comment about the Customer reference.

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.

CUS_LOC_CD

Req

C 8

Use the Location column to specify whether the work is for a particular customer site.

TAX_TYPE_CD

Req

C! 6

Id of the type of taxes that applies to the Customer.

JURIS_ID

Req

C! 10

Id of the taxing authority.

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.

• D (Delete) – Delete an existing record. If PENTA cannot delete the column, it records an error.

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.

CUS_LOC_CD

Opt

C 8

Use the Location column to specify whether the work is for a particular customer site. Can be null.

EMP_ID

Req

X

Employee Id of the preferred technician.

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.

SERV_TECH_PREF_CD

Req

C! 3

Identify the degree to which the technician is preferred.

RANK_NUM

Req

I 3

A 1-3 digit preference rank for the employee.

DO_NOT_ASSIGN_CD

Req

C! 1

Defaults as N.

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.

CUS_LOC_CD

Opt

C 8

Use the Location column to specify whether the work is for a particular customer site. Can be null.

UDF_COLUMN_NAME

Req

C 30

The name of the UDF column.

ACTIVITY_CD

Req

C! 1

Required for all activity. Possible values are:

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

• D (Delete) – Set the value for the UDF to null.

ALPHA_VALUE

Opt

C 2000

The value for the UDF.

D_EFF_DATE

Opt

D

Format YYYYMMDD.

Required if the UDF requires an effective date and does not default as the system date.

This must be null if the UDF does not require an effective date.

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.