Required Fields

This table lists fields in the F01161Z1 table that are required. For some fields, blank is a valid value. Values entered in these fields are processed into the Alternate Address table (F01161).

Field Name

Alias

Type

Length

Definition

EDI - User ID

LBEDUS

Alpha

10

A user-defined identification number. Enter the user ID of the person who runs the Contact Information Batch Upload program or the person who is to receive workflow messages. This field, in conjunction with the LBEDTN and LBEDBT fields, uniquely identifies a specific transaction.

EDI - Batch Number

LBEDBT

Alpha

15

A number the person who runs the Contact Information Batch Upload program assigns to each batch. The system assigns a new batch number whenever this field changes. You can significantly increase performance by assigning one batch number for each group of transactions you process.

EDI - Transaction Number

LBEDTN

Alpha

22

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

EDI - Line Number

LBEDLN

Number

7

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

EDI - Successfully Processed

LBEDSP

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

LBTNAC

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 this field with either after image (UA) or before image (UB). The system uses UB only if the processing option in the Contact Information MBF PO is activated.

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

Address Number

LBAN8

Number

8

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

If you leave this field blank, the system assigns a number based on the Next Numbers Automatic table (F0002) for the Address Book system.

If you enter a value in this field, it cannot exist in the Address Book Master table (F0101) unless the SZTNAC field has a value of C, which indicates a change to an existing record. Otherwise, the system considers the transaction a duplicate and will not process it.

Type - Address

LBATYPE

Alpha

5

A code that indicates the type of address, such as a home address or an office address. The value you enter in this field must exist in UDC table 01/AT (Address Type).

Who's Who Line

LBIDLN

Number

5

A value that specifies which who's who entry is associated with an alternative address record.