Required Fields

The table lists fields in the F0111Z1 that are required. For some fields, blank is a valid value.

Field Name

Alias

Type

Length

Definition

EDI - User ID

CBEDUS

Alpha

10

A number that identifies the user. 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 CBEDTN and CBEDBT fields, uniquely identifies a specific transaction.

EDI - Batch Number

CBEDBT

Alpha

15

A number that identifies a particular batch of data. This field, in conjunction with the CBEDTN and CBEDUS fields, uniquely identifies a transaction within a specific batch.

This field also serves as a level break and assigns a new batch number each time that the value changes. You must assign a unique batch number for each new transaction being processed to correspond and maintain integrity with the EDI-Batch Number field in F01151Z1 (EBEDBT), F01161Z1 (LBEDBT), or F01112Z1 (PBEDBT).

EDI - Transaction Number

CBEDTN

Alpha

22

A number that identifies each transaction. A new transaction number indicates a different address book 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 the sender can readily identify the transaction.

EDI - Line Number

CBEDLN

Number

7

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

EDI - Successfully Processed

CBEDSP

Alpha

1

A value that indicates whether a transaction 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 after the transaction is successfully processed.

Transaction Action

CBTNAC

Alpha

2

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.

For outbound processing, the system updates the value in this field with either after image (UA) or before image (UB). The system uses UB only if the processing option in the Address Book MBF (P0100041) is activated.

For outbound processing, you can also enter A for additions and D for deletions.

Alpha Name

CBALPH

Alpha

40

A name typically entered in the format of last name, first name to optimize search capabilities. The Word Search program (P01BDWRD) uses this field.

Address Number

CBAN8

Number

8

A value that uniquely identifies a customer.

The value in this field must exist in the Address Book Master table (F0101) or the record will not process.

Who's Who Line

CBIDLN

Number

5

A value that connects a who's who entry to an address book number.

Mailing Name

CBMLNM

Alpha

40

An alphanumeric value representing the name of the company or the person to whom correspondence is sent.