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