Required Fields

This table lists the fields in the F01151Z1 table that are required.

Field Name

Alias

Type

Length

Definition

EDI-User ID

PIEDUS

Alpha

10

A user-defined identification number. Enter the user ID of the person running the process or the person who is to receive workflow messages. This field, in conjunction with the PIEDTN and PIEDBT fields, uniquely identifies a specific transaction.

If you are uploading phone numbers for a who's who record, enter the value used to upload the who's who record.

EDI-Batch Number

PIEDBT

Alpha

15

A code that, in conjunction with the PIEDTN and PIEDUS fields, uniquely identifies a transaction within a specific batch.

This field also serves as a level break and causes the system to assign a new batch number each time that the value changes. You can significantly increase performance by assigning one batch number for each group of transactions.

If you are uploading phone numbers for a who's who record, enter the value used to upload the who's who record.

EDI-Transaction Number

PIEDTN

Alpha

22

A code that identifies each transaction. Each new transaction number indicates a different who's who record. You cannot have more than one transaction with the same number in a batch. Typically, this field contains the document number of the source system so that a transaction can be readily identified.

If you are uploading phone numbers for a who's who record, enter the value used for the who's who record.

EDI-Line Number

PIEDLN

Number

7

A number used to uniquely identify a record. Each transaction can have multiple, consecutive line numbers.

If you are uploading a phone number for a who's who record, enter 0. If you are uploading a phone number for a related person record, enter the value in the EDLN number field that was used to upload the related person record.

EDI -Transaction Line

PIEDTL

String

20

A number used to identify phone number records. Enter a unique number for each phone number record.

Transaction Action

PITNAC

Alpha

1

A value that indicates the transaction to be performed. The value A indicates a new transaction. The value C indicates a change to an existing document. The value D indicates a deletion for an existing record. You must process changes and deletions after you process additions.

Successfully Processed

PIEDSP

Alpha

1

A value that indicates whether a transaction was successfully processed. Leave this field blank. The value N indicates that the transaction was not processed or was processed in error.

The system changes the value to Y when the transaction is successfully processed

Address Number

PIAN8

Number

8

A value that uniquely identifies a supplier, customer, employee, and so on.

Enter the Address Book number of the customer or supplier for which you are uploading phone information.

Phone Number

PIPH1

Number

20

A number that indicates the phone number for the contact person for which you are uploading phone information.