Optional Fields

These fields in the F0101Z2 table are optional. You can use these fields to provide additional information about a transaction.

Field Name	Alias	Type	Length	Definition
Type - Transaction	SZTYTN	Alpha	8	A value that identifies the type of transaction. If you leave this field blank, the system uses the value in the transaction type processing option in the Address Book MBF (P0100041), if it is set up. This field is required if you use outbound processing.
Direction Indicator	SZDRIN	Alpha	1	A number that identifies whether a batch job is inbound or outbound processing. For inbound processing, enter 0. For outbound processing, leave this field blank. The system updates this field with 1 if the record is a "before image" and 2 if the record is an "after image." A processing option in the Address Book MBF (P0100041) determines whether a before image is written to the table.
EDI - Detail Lines Processed	SZEDDL	Number	5	The number of detail lines included in a specific transaction. This field is informational only.
Trading Partner ID	SZPNID	Alpha	15	A value used in an Electronic Data Interchange (EDI) transaction to identify who is trading documents with you.
Address Number	SZAN8	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 does not process it. Note: This field is required when the SZTNAC field is C, which indicates a change to an existing record.
Long Address Number	SZALKY	Alpha	20	A value that identifies an address book record in a format other than that assigned by the system. Typically, you enter an address number from a legacy system to use as a cross-reference to the address book number assigned by the JD Edwards EnterpriseOne system. If you enter a value in this field, the value cannot exist in any other address book record or the system will consider it a duplicate record and not process it.
Industry Classification Code	SZSIC	Alpha	10	A code that classifies goods and services such as the standard industry code (SIC).
Language	SZLNGP	Alpha	2	A code that indicates the language to use on forms and for reports. If you enter a value in this field, the value must exist in UDC table 01/LP (Language Preference). If you leave this field blank, the system uses the language specified in the user profile of the person who runs the process. If that is blank, the system uses the default language for the system.
Credit Message	SZCM	Alpha	2	A code that displays specific information about a customer or supplier. The value that you enter in this field must exist in UDC table 00/CM (Credit Messages).
Person/ Corporation Code	SZTAXC	Alpha	1	A code that designates the type of taxpayer. For U.S. clients, use one of these codes in conjunction with the SZTAX field: C: Corporate entity P: Individual N: Noncorporate entity The system chooses suppliers with codes P and N for 1099 reporting. For non-U.S. clients, use one of these codes in conjunction with the SZTAX field: 1: Individual 2: Corporate entity
AR/AP Netting Indicator	SZAT2	Alpha	1	An option that indicates whether customers and suppliers are eligible for AR/AP netting. Values are: Y: Eligible for AR/AP netting. The system updates invoices and vouchers that are entered for the address number with a value of 1 (Eligible for Netting) in the Netting Status field. N: Ineligible for AR/AP netting. The system updates invoices and vouchers that are entered for the address number with a value of 0 (Ineligible for Netting) in the Netting Status field.
Address Type 3	SZAT3	Alpha	1	A code that is reserved for future use.
Address Type 4	SZAT4	Alpha	1	A code that is reserved for future use.
Address Type - Receivables	SZATR	Alpha	1	A code that indicates whether the address book record is a customer. Values are Y and N.
Address Type 5	SZAT5	Alpha	1	A code that is reserved for future use.
Address Type - Payables	SZATP	Alpha	1	A code that indicates whether the address book record is a supplier. Values are: Y (yes), N (no), M (miscellaneous, one-time supplier), and F (foreign supplier). The value that you enter in this field must exist in UDC table H01/AS (Address Type-Payables).
Address Type - Code, Purchaser	SZATPR	Alpha	1	A code that can be defined in the data dictionary to reference the address book record.
Miscellaneous Code	SZAB3	Alpha	1	A code that is reserved for future use.
Address Type - Employee	SZATE	Alpha	1	A code that indicates whether the address book record is an employee. Values are: Y and N.
Subledger Inactive Code	SZSBLI	Alpha	1	A blank indicates that the address book number can be used as a subledger.
Beginning Effective Date	SZEFTB	Date	6	The date that the address book record first becomes effective. Use a format that your database accepts. Some databases allow you to enter the date in a Gregorian date format (mmddyy or yymmdd), while other databases require a Julian date format. The Julian date format is cyyddd (where c = century). Enter 1 for transactions in the 21st century. For example, the date 6/1/2005 corresponds to a Julian date 105152. For 6/1/04, the corresponding Julian date is 104153 (because the year 2000 has a leap day, 2/29/00).
Address Number - 1st	SZAN81	Number	8	A related address book number (salesperson, law firm, accountant, and so on). Many address book programs allow you to inquire on records based on a related address number. The value that you enter in this field must exist in the table before you run the batch process. Therefore, if you enter a related address book number, you must process the related address records first.
Address Number - 2nd	SZAN82	Number	8	See the description for the SZAN81 field.
Address Number - 3rd	SZAN83	Number	8	See the description for the SZAN81 field.
Address Number - 4th	SZAN84	Number	8	See the description for the SZAN81 field.
Address Number - 5th	SZAN86	Number	8	See the description for the SZAN81 field.
Factor Special Payee	SZAN85	Number	8	An address book number that identifies a special payment address in accounts payable. The value that you enter in this field must exist in the F0101 table before you run the batch process.
Address Book Category Codes 01 through 30	SZAC01 through SZAC30	Alpha	3	A category code. The values that you enter in the category code fields must exist in the corresponding UDC table 01/01-01/30. Category code 7 is used for 1099 reporting in the Accounts Payable system.
G/L Bank Account	SZGLBA	Alpha	8	A value that identifies the bank account in the general ledger that is associated with the address book record. This field is informational only and is not used in any JD Edwards EnterpriseOne financial transactions. Bank accounts associated with financial transactions are updated based on automatic accounting instructions (AAIs).
Time - Scheduled In	SZPTI	Number	6	The specific time when a person is scheduled to return. The format required is HH.MM.
Date - Scheduled In	SZPDI	Date	6	The date when a person is scheduled to return. Use a format that your database accepts. Some databases allow you to enter the date in a Gregorian date format while other databases require a Julian date format. See the description for the SZEBDT field for more information.
Action - Message Control	SZMSGA	Alpha	1	A code that indicates whether the system displays messages in workflow. The value Y indicates that the system displays all messages, including messages that have been cleared or processed. A value other than Y indicates that the system displays only current messages.
Remark	SZRMK	Alpha	30	An informational field that you can use for a remark, description, or name. The system does not display this field on any forms in the Address Book system.
Certificate - Tax Exemption	SZTXCT	Alpha	20	A number that identifies a license or certificate that tax authorities issue to tax-exempt individuals and companies.
Additional Tax ID - Individual	SZTX2	Alpha	20	An additional identification number that a tax authority assigns to an individual.
Secondary Alpha Name	SZALP1	Alpha	40	An alternate name to accommodate double-byte coding.
Mailing Name	SZMLNM	Alpha	40	The name that appears on reports and labels for mailing purposes. If you leave this field blank, the value entered in the SZALPH field is used.
Secondary Mailing Name	SZMLN1	Alpha	40	An alternate name to accommodate double-byte coding.
Address Line 1, Address Line 2, Address Line 3, Address Line 4	SZADD1 SZADD2 SZADD3 SZADD4	Alpha	40	Alphanumeric values that identify the mailing address for the address book record.
Postal Code	SZADDZ	Alpha	12	A code assigned by the postal service of a country that is attached to the address to facilitate mail delivery.
City	SZCTY1	Alpha	25	The city associated with an address.
Country	SZCTR	Alpha	3	The country associated with an address. The value that you enter in this field must exist in UDC table 00/CN (Country Codes).
State	SZADDS	Alpha	3	The state or province associated with an address. The value that you enter in this field must exist in the UDC table 00/S (State or Province).
County	SZCOUN	Alpha	25	The county, parish, or other political district associated with an address for mail delivery or for tax purposes.
Phone Prefix	SZAR1	Alpha	6	The area code in the U.S. or the prefix in another country for a telephone number. The required format for the U.S. is three characters in parentheses. If an alternate format is required for non-U.S. area codes, the Display Rules field in the Data Dictionary for item AR1 must be changed.
Phone Number	SZPH1	Alpha	20	The telephone number associated with the address book record.
Phone Number Type 1	SZPHT1	Alpha	4	A code that designates the type of phone number associated with the SZPH1 field. For example, FAX, CELL, HOME, WORK. The value entered in this field must exist in the UDC table 01/PH (Phone Type).
Phone Prefix 2	SZAR2	Alpha	6	The area code in the U.S. or the prefix in another country for a telephone number. The required format for the U.S. is three characters in parentheses. If an alternate format is required for non-U.S. area codes, the Display Rules field in the Data Dictionary for item AR1 must be changed.
Phone Number 2	SZPH2	Alpha	20	A second telephone number associated with the address book record.
Phone Number Type 2	SZPHT2	Alpha	4	A code that designates the type of phone number associated with the SZPH2 field. For example, FAX, CELL, HOME, WORK. The value entered in this field must exist in the UDC table 01/PH (Phone Type).
Ticker	SZTICKER	Alpha	10	A code that designates the stock ticker for the company.
Stock Exchange	SZEXCHG	Alpha	10	A code that designates the exchange on which the company's stock is traded.
DUNS Number	SZDUNS	Alpha	13	A code used to designate the DUNS number for the company. This number is the Dun and Bradstreet identifier that is used to get credit reports on companies.
CLASS01	SZCLASS01	Alpha	3	A code used to classify companies. Enter a valid value from UDC 01/CA.
CLASS02	SZCLASS02	Alpha	3	A code used to classify companies. Enter a valid value from UDC 01/CB.
CLASS03	SZCLASS03	Alpha	3	A code used to classify companies. Enter a valid value from UDC 01/CC.
CLASS04	SZCLASS04	Alpha	3	A code used to classify companies. Enter a valid value from UDC 01/CD.
CLASS05	SZCLASS05	Alpha	3	A code used to classify companies. Enter a valid value from UDC 01/CE.
Number of Employees	SZNOE	Number	15	A number used to designate the number of employees employed by the customer or supplier.
Growth Rate	SZGROWTHR	Number	8	A code used to designate the growth rate for a company.
Year Started	SZYEARSTAR	Alpha	15	A code that designates the year a company became a customer.
Employee Group Approvals	SZAEMPGP	Alpha	5	A code that indicates the group for the employee for approval processing. This field is used only in Requisition Self Service.
Future Use Indicator	SZACTIN	Character	1	This field is reserved for future use.
Revenue Range	SZREVRNG	Alpha	5	An amount used to designate the revenue range for a company. Enter a valid value from UDC 01/RR.