This appendix contains the following topics:
Section A.1, "Mapping Fields in the Address Book - Interoperability Table (F0101Z2)"
Section A.2, "Mapping Fields in the Customer Master LOB-Batch Table (F03012Z1)"
Section A.3, "Mapping Fields in the Supplier Master - Batch Table (F0401Z1)"
Section A.4, "Mapping Fields in the Batch Who's Who Information Table (F0111Z1)"
Section A.5, "Mapping Fields in the Batch - Related Person Table (F01112Z1)"
Section A.6, "Mapping Fields in the Phones - Interoperability Table (F0115Z1)"
Section A.7, "Mapping Fields in the Batch - Electronic Address Table (F01151Z1)"
Section A.8, "Mapping Fields in the Batch - Alternative Address Table (F01161Z1)"
This section contains a list of the fields in the F0101Z2 table. Some of the fields are required to run the Address Book Batch Upload program (R01010Z), while others are not. Not all fields are displayed on address book forms or used by the Address Book system.
This table lists the required fields for the F0101Z2 table:
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
EDI - User ID | SZEDUS | Alpha | 10 | A user-defined identification number. Enter the user ID of the person who runs the R01010Z program or the person who is to receive messages in the Employee Work Center. This field, in conjunction with SZEDTN and SZEDBT, uniquely identifies a specific transaction. |
EDI - Batch Number | SZEDBT | Alpha | 15 | A number assigned by the person who runs the Address Book Batch Upload program 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 that you process. |
EDI - Transaction Number | SZEDTN | 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. This field often contains the document number of the source system so that the sender can readily identify the transaction. |
EDI - Line Number | SZEDLN | Number | 7 | A number used to uniquely identify a record. Each transaction can have multiple, consecutive line numbers. |
EDI - Successfully Processed | SZEDSP | 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. |
Transaction Action | SZTNAC | Alpha | 1 | A value that indicates the transaction to be performed. The value A indicates a new transaction. The value D indicates a deletion. The value A indicates an add. The value C indicates a change to an existing document. You must process changes after you process additions.
For outbound processing, the system updates the value in this field with 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. |
Business Unit | SZMCU | Alpha | 12 | A value that identifies the business unit that is used for security purposes. The value in this field is also used by transaction entry programs and can be concatenated with the object account of certain automatic accounting instructions (AAIs) to derive an account number. If you leave this field blank, the system assigns a value of 1.
The value must exist in the Business Unit Master table (F0006). |
Tax ID | SZTAX | Alpha | 20 | The identification code required by various tax authorities. This might be a social security number, federal or state corporate tax ID, or sales tax number.
This field is required only if the value of the Search Type field (SZAT1) is E and the country code is US or CAN. |
Alpha Name | SZALPH | 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. |
Search Type | SZAT1 | Alpha | 3 | A value that identifies a record as part of a specific group, such as suppliers, customers, employees, and companies. The value that you enter in this field must exist in UDC table 01/ST (Search Type). |
These fields in the F0101Z2 table are optional. You can use these fields to provide additional information about a transaction.
This table lists fields in the F0101Z2 table that are ignored. The system does not use the values in these fields.
Field Name | Alias | Type | Length |
---|---|---|---|
EDI - Document Type | SZEDCT | Alpha | 2 |
EDI - Translation Format | SZEDFT | Alpha | 10 |
EDI - Transmission Date | SZEDDT | Date | 6 |
Description - Compressed | SZDC | Alpha | 40 |
Transaction Originator | SZTORG | Alpha | 10 |
User ID | SZUSER | Alpha | 10 |
Program ID | SZPID | Alpha | 10 |
Work Station ID | SZJOBN | Alpha | 10 |
Date Updated | SZUPMJ | Date | 6 |
Time of Day | SZTDAY | Date | 6 |
Time Last Updated | SZUPMT | Number | 6 |
This table lists fields in the F0101Z2 table that are reserved for users. These fields are not updated by any JD Edwards EnterpriseOne programs. The Address Book system does not display them on any forms.
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
User Reserved Code | SZURCD | Alpha | 3 | A user-defined alphanumeric value up to three characters. |
User Reserved Date | SZURDT | Date | 6 | A user-defined date that uses a format that your database accepts. |
User Reserved Amount | SZURAT | Number | 15 | A user-defined amount that uses a format that your database accepts. |
User Reserved Number | SZURAB | Number | 8 | A user-defined number up to eight digits. |
User Reserved Reference | SZURRF | Alpha | 15 | A user-defined alphanumeric value up to 15 characters. |
This section contains a list of the fields in the F03012Z1 table. Some of the fields are required to run the Customer Master Batch Upload program (R03010Z), while others are not.
This table lists fields in the F03012Z1 table that are required. For some fields, blank is a valid value.
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
EDI - User ID | VOEDUS | Alpha | 10 | A user-defined identification number. Enter the user ID of the person running the process or the person who is to receive messages in the Employee Work Center program (P012501). This field, in conjunction with the VOEDTN and VOEDBT fields, uniquely identifies a specific transaction. |
EDI - Batch Number | VOEDBT | Alpha | 15 | A code that, in conjunction with the VOEDTN and VOEDUS fields, uniquely identifies a transaction within a specific batch. This field also serves as a level break and causes the assignment of a new JD Edwards EnterpriseOne batch number each time that the value changes. You can significantly increase performance by assigning one batch number for each group of transactions. |
EDI - Transaction Number | VOEDTN | Number | 22 | A code that identifies each transaction. Each new transaction number indicates a different address book record. You cannot have more than one transaction with the same number in a batch. This field often contains the document number of the source system so that the transaction can be readily identified. |
EDI - Line Number | VOEDLN | Number | 7 | A number used to uniquely identify a record. Each transaction can have multiple, consecutive line numbers. |
EDI - Successfully Processed | VOEDSP | Alpha | 1 | Leave this field blank. The system populates this field to indicate whether the transaction was successfully processed. The value N indicates that the transaction was not processed or was processed in error. After the transaction is successfully processed, the system changes the value to Y.
For outbound processing, the system updates the value to N. |
Transaction Action | VOTNAC | Alpha | 2 | If you are processing new transactions, enter A in this field. If you are processing a change for an existing record, enter C. If you are processing a deletion for an existing record, enter D. Process all changes and deletions after additions.
For outbound processing, the system updates this field with either after image (UA) or before image (UB). The system updates the table with UB only if the processing option in the Customer Master MBF (P0100042) is activated. For outbound processing, you can also enter A for additions and D for deletions. |
Address Number | VOAN8 | Number | 8 | A numeric value that uniquely identifies a customer.
The value in this field must exist in the F0101 table or the record will not process. |
Company | VOCO | Alpha | 5 | A value that indicates the company associated with the customer. The company number is used in line of business processing. The system processes a record for company 00000 in addition to any company entered for the customer. If you leave this field blank, the system uses company 00000. |
Currency Code - A/B Amounts | VOCRCA | Alpha | 3 | This field is displayed only if multicurrency is activated.
A value that indicates the currency of the VOASTY and VOSPYE fields. The value entered in this field must exist in the Currency Code table (F0013). If you leave this field blank, the value entered in the processing option for the Customer Master (P03013) is used. If the processing option is blank, the field is updated with the currency code associated with the company of the business unit entered in F0101 table. |
This table lists fields in the F03012Z1 that are optional and are used by the Accounts Receivable system. You can use these fields to provide additional information about a transaction.
These fields are optional in the F03012Z1 table and are used by the Sales Order Management system. You can use these fields to provide additional information about a transaction.
This table lists fields in the F03012Z1 table that are ignored. Leave these fields blank. The system does not use the values in these fields.
Field Name | Alias | Type | Length |
---|---|---|---|
Transaction Originator | VOTORG | Alpha | 10 |
User ID | VOUSER | Alpha | 10 |
Program ID | VOPID | Alpha | 10 |
Work Station ID | VOJOBN | Alpha | 10 |
Time Last Updated | VOUPMT | Number | 6 |
Date Updated | VOUPMJ | Date | 6 |
Time of Day | VOTDAY | Date | 6 |
EDI - Document Type | VOEDCT | Alpha | 2 |
EDI -Translation Format | VOEDFT | Alpha | 10 |
EDI - Transmission Date | VOEDDT | Date | 6 |
Ledger Inquiry Sequence | VOSQNL | Alpha | 1 |
Auto Receipt Algorithm | VOALGM | Alpha | 2 |
Balance Forward/ Open Item | VOBO | Alpha | 1 |
Credit Check Handling Code | VOCKHC | Alpha | 1 |
Days Sales Outstanding | VODSO | Number | 5 |
Dunning Letters Sent | VODLQT | Number | 3 |
Date of Last Dunning Letter | VODLQJ | Date | 6 |
Number of Reminders to Send | VONBRR | Alpha | 1 |
Number of Sent Reminders - 1 | VONBR1 | Number | 3 |
Number of Sent Reminders - 2 | VONBR2 | Number | 3 |
Number of Sent Reminders - 3 | VONBR3 | Number | 3 |
Finance Charge Days | VOFD | Number | 3 |
Finance Charge - Create Entries Y/N | VOCFCE | Alpha | 1 |
Pending Cash Receipts | VOAB2 | Alpha | 1 |
Date - Financial Statements on Hand | VOFNDJ | Date | 6 |
Average Days Late | VOAVD | Number | 3 |
Amount of High Balance | VOAHB | Number | 15 |
Send Method | VOCRMD | Alpha | 1 |
Amount of High Balance | VOAHB | Number | 15 |
Administration Credit Limit | VOAMCR | Number | 15 |
This table lists additional fields that are used by the CRM system. If you are using CRM, you can populate these fields.
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
Tier 1 | VOTIER1 | String | 45 | Enter a value from user-defined code table 01/T1 to specify the number of the tier associated with the customer. This number represent a subjective ranking of customer value. |
Override Sales Team Assignment | VOSTOF | Character | 1 | Select this option if you do not want the system to automatically assign sales team members to the customer based on the industry grouping and territory. If you select this option, you must manually assign sales team members to the customer. If you do not select this option, the system assigns all of the sales team members who are active in both the territory and industry grouping associated with the customer when the customer record is added or changed. |
Territory ID | VOTERRID | Numeric | 15 | Enter the area in which the customer resides. The system uses this field, in conjunction with the Customer Industry Group field to determine which sales team members to add to the customer's sales team. For a sales team member to be automatically assigned to a customer, the sales team member must be active in both the Territory and the Industry Grouping associated with the customer record. If you have selected the Override Sales Team Assignment option, this field is informational only, and is not used to assign sales team members to the customer. |
Customer Industry Group | VOCIG | Numeric | 15 | Enter the industry with which the customer is associated. The system uses this field, in conjunction with the Territory ID field to determine which sales team members to add to the customer's sales team. For a sales team member to be automatically assigned to a customer, the sales team member must be active in both the Territory and the Industry Grouping associated with the customer record. If you have selected the Override Sales Team Assignment option, this field is informational only. |
This table lists fields in the F03012Z1 table that are reserved for users. These fields are not updated by any JD Edwards EnterpriseOne program. The Address Book, Accounts Receivable, and Sales Order Management systems do not display them on any forms.
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
Amount - Address Book | VOABAM | Number | 15 | A user-defined amount field. Use a format that your database accepts. |
Amount - Address Book | VOABA1 | Number | 15 | A user-defined amount field. Use a format that your database accepts. |
User Reserved Code | VOURCD | Alpha | 3 | A code that is user-defined. You can use any alphanumeric value up to three characters. |
User Reserved Date | VOURDT | Date | 6 | A value for a date. Use a format that your database accepts.
See the data item VOEBDT for more information. |
User Reserved Amount | VOURAT | Number | 15 | A user-defined amount field. Use a format that your database accepts. |
User Reserved Number | VOURAB | Number | 8 | A user-defined numeric field that can contain up to eight digits. |
User Reserved Reference | VOURRF | Alpha | 15 | A user-defined alphanumeric field that can contain up to 15 characters. |
This section contains a list of the fields in the F0401Z1 table. Some of the fields are required to run the Supplier Master Batch Upload program (R04010Z), while others are not. Not all fields are displayed or used by the Address Book, Accounts Payable, or Procurement system.
This table lists fields that are required in the F0401Z1. For some fields, blank is a valid value.
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
EDI - User ID | VOEDUS | Alpha | 10 | A user-defined identification number. Enter the user ID of the person who runs the Supplier Master Batch Upload program or the person who is to receive workflow messages. This field, in conjunction with the VOEDTN and VOEDBT fields, uniquely identifies a specific transaction. |
EDI - Batch Number | VOEDBT | Alpha | 15 | A number the person who runs the Supplier Master 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 | VOEDTN | 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 number so that the sender can readily identify the transaction. |
EDI - Line Number | VOEDLN | Number | 7 | A number that uniquely identifies a transaction. Each transaction can have multiple, consecutive lines. |
EDI - Successfully Processed | VOEDSP | 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 | VOTNAC | Alpha | 2 | If you are processing new transactions, enter A in this field. If you are processing a change for an existing record, enter C. If you are processing a deletion for an existing record, enter D. Process all changes and deletions after additions.
For outbound processing, the system updates this field with either after image (UA) or before image (UB). The system updates the table with UB only if the processing option in the Supplier Master MBF (P00400047) is activated. For outbound processing, you can also enter A for additions and D for deletions. |
Address Number | VOAN8 | Number | 8 | A number that uniquely identifies the supplier. The value in this field must exist in the F0101 table, or the system does not process the record. |
Currency Code - A/B Amounts | VOCRCA | Alpha | 3 | This field displays only if multicurrency is activated.
An alphabetic code that represents the address book currency. The value that you enter in this field indicates the currency of the VOAYPD and OAPPD fields. The value you enter in this field must exist in the Currency Code table (F0013). If you leave this field blank, the system uses the value entered in the processing option for the Supplier Master program (P04012). If the processing option is blank, the system updates the field with the currency code of the company of the business unit in the F0101 table. |
This table lists fields in the F0401Z1 table that are optional and are used by the Accounts Payable system. You can use these fields to provide additional information about a transaction.
This table lists fields in the F0401Z1 table that are optional and are used by the Procurement system. You can use these fields to provide additional information about a transaction.
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
Price Pick List (Y,N,2) | VOPLST | Alpha | 1 | A code that indicates whether net price information appears on the purchase order. Values are:
Y: Print net prices. N: Do not print prices. 2: Print base price adjustments and net prices. |
Amount - Open Order | VOAPRC | Number | 15 | A number that indicates the total amount of open orders for a supplier. The system adjusts the list price in the Item Location File (F41021) by the discount tables or any override price. |
Minimum Order Value | VOMINO | Number | 15 | A number that indicates the lowest amount that can be entered for an order. If the amount of the order is less than the amount in this field, the system issues an error. |
Maximum Order Value | VOMAXO | Number | 15 | A number that indicates the highest amount that can be entered for an order. If the amount of the order is greater than the amount in this field, the system issues an error. |
Related Address Number | VOAN8R | Number | 8 | This field is not used in the Procurement system and does not appear on any form. |
Billing Address Type | VOBADT | Number | 8 | This field is not used in the Procurement system and does not appear on any form. |
Customer Price Group | VOCPGP | Number | 8 | This field is not used in the Procurement system and does not appear on any form. |
Order Template | VOORTP | Alpha | 8 | A code that indicates a list of items that you frequently order. The value that you enter in this field must exist in UDC table 40/OT (Order Templates). |
Print Message | VOINMG | Alpha | 10 | A code that indicates a message that prints on the purchase order. The value that you enter in this field must exist in UDC table 40/PM (Print Message). |
Hold Orders Code | VOHOLD | Alpha | 2 | A code that indicates the reason an order is on hold. The value that you enter in this field must exist in UDC table 42/HC (Hold Codes). |
Route Code | VOROUT | Alpha | 3 | This field is not used in the Procurement system and does not appear on any form. |
Stop Code | VOSTOP | Alpha | 3 | This field is not used in the Procurement system and does not appear on any form. |
Zone Number | VOZON | Alpha | 3 | This field is not used in the Procurement system and does not appear on any form. |
Carrier Number | VOCARS | Number | 8 | A value that represents the address book number of the carrier specified by the customer or your organization. Use this field for route and special handling requirements. The value in this field must exist in the F0101 table. |
Delivery Instructions Line 1 | VODEL1 | Alpha | 30 | An informational field to enter delivery instructions. |
Delivery Instructions Line 2 | VODEL2 | Alpha | 30 | An informational field to enter delivery instructions. |
Transit Days | VOLTDT | Number | 5 | This field is not used in the Procurement system and does not appear on any form. |
Freight Handling Code | VOFRTH | Alpha | 5 | A code that indicates either the method to use when delivering shipments to a supplier or who has responsibility for freight charges. The value you enter in this field must exist in UDC table 42/FR (Freight Handling Code). |
Purchase Order Copies | VOINVC | Number | 2 | A number specifying the number of purchase orders to print for this supplier. |
Unit of Measure - Weight Display | VOWUMD | Alpha | 2 | A code that specifies the unit of measure to display for the weight of an order. The value you enter in this field must exist in UDC table 00/UM (Unit of Measure). If you leave this field blank, the system updates it with the value entered in the Inventory Constants table (F41001). |
Unit of Measure - Volume Display | VOVUMD | Alpha | 2 | A code that identifies the unit of measure to display for the volume of an order. The value you enter in this field must exist in UDC table 00/UM (Unit of Measure). If you leave this field blank, the system updates it with the value entered in the F41001 table. |
Landed Cost Rule | VOPRP5 | Alpha | 3 | A code that indicates purchasing costs that exceed the price of an item, for example, broker fees and commissions. Landed cost rules are set up in the Landed Cost Revisions program (P41291). The value that you enter in this field must exist in UDC table 41/P5 (Landed Cost Rule). |
Batch Processing Mode | VOEDPM | Alpha | 1 | A code that indicates whether the supplier is excluded from batch processing or whether the supplier is in a test or production mode. Values are:
I: Inhibited. The supplier is not available for batch processing T: Test mode. Only reports are produced when the record is processed. P: Production mode. Reports and orders are produced when the record is processed. |
Supplier Type Identifier | VOEDCI | Alpha | 1 | A code that specifies the type of number to be sent to an EDI transaction, for example, a DUNS or telephone number. The value that you enter in this field must exist in UDC table 40/CI (Customer Type Identifier). |
Item Type Identifier | VOEDII | Alpha | 1 | A code that specifies the type of item number to be sent in an EDI transaction, for example, UPC code or supplier part number. The value that you enter in this field must exist in UDC table 40/II (Item Type Identifier). |
Quantity Decimals | VOEDQD | Number | 1 | A number that specifies the number of positions to the right of the decimal point to use for all quantity fields in an EDI transaction for this supplier. |
Amount Decimals | VOEDAD | Number | 1 | A number that specifies the number of positions to the right of the decimal point to use for all amount fields in an EDI transaction for this supplier. |
Delivery Note | VOEDF1 | Alpha | 1 | This field is not used in the Procurement system and does not appear on any form. |
Item Restrictions | VOEDF2 | Alpha | 2 | A code that indicates whether restrictions are placed on ordering items from this supplier. Values are:
Blank: No restrictions. I: An item can be purchased only if it is on the Item Restrictions form. E: An item cannot be purchased if it is on the Item Restrictions form. |
Supplier/ Parent Rebate Level | VOVI01 | Alpha | 1 | A code that indicates the organizational level that the rebate system is based upon. The value in this field must exist in UDC table 43/RL (Rebate Level). |
Supplier Rebate Code | VOVI02 | Alpha | 1 | A code that indicates whether rebates are active for this supplier. The value that you enter in this field must exist in UDC table 43/RA (Supplier Rebate Code). |
Special Instruction 3 | VOVI03 | Alpha | 1 | Reserved for future use. |
Special Instruction 4 | VOVI04 | Alpha | 1 | Reserved for future use. |
Special Instruction 5 | VOVI05 | Alpha | 1 | Reserved for future use. |
Minimum Check Amount Code | VOMNSC | Alpha | 1 | This field is not used in the Procurement system and does not appear on any form. |
Address Type Code 5 | VOATO | Alpha | 1 | This field is not used in the Procurement system and does not appear on any form. |
Revenue Netted (Y/N) | VORVNT | Alpha | 1 | This field is not used in the Procurement system and does not appear on any form. |
Price and Adjustment Schedule | VOASN | Alpha | 8 | This field is not used in the Procurement system and does not appear on any form. |
Send Method | VOCRMD | Alpha | 1 | This field is not used in the Procurement system and does not appear on any form. |
Evaluated Receipt Settlement | VOAVCH | Alpha | 1 | A code that indicates whether you and the supplier have an agreement that you submit a voucher based on what is received. The supplier does not send an invoice and you can bypass the Payment with Voucher Match program. The system uses the Evaluated Receipt Settlement program (R43800) instead. Values are:
N: Not eligible for evaluated receipt settlement processing. Y: Eligible for evaluated receipt settlement processing. T: Eligible for evaluated receipt settlement processing but a tolerance error occurred during the receipt process. R: Eligible for evaluated receipt settlement processing but the receipt is currently in the receipt routing process. V: The receipt transaction has been vouchered using the evaluated receipt settlement process. |
This table lists fields in the F0401Z1 table that are ignored. Leave these fields blank. The system does not use the values in these fields.
Field Name | Alias | Type | Length |
---|---|---|---|
Transaction Originator | VOTORG | Alpha | 10 |
User ID | VOUSER | Alpha | 10 |
Program ID | VOPID | Alpha | 10 |
Work Station ID | VOJOBN | Alpha | 10 |
Date Updated | VOUPMJ | Date | 6 |
Time Last Updated | VOUPMT | Number | 6 |
Time of Day | VOTDAY | Date | 6 |
EDI - Document Type | VOEDCT | Alpha | 2 |
EDI Translation Format | VOEDFT | Alpha | 10 |
EDI - Transmission Date | VOEDDT | Date | 6 |
This table lists fields in the F0401Z1 table that are reserved for users.
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
Amount - Address Book | VOABAM | Number | 15 | A user-defined number that represents an amount. Use a format that your database accepts. |
Amount - Address Book | VOABA1 | Number | 15 | A user-defined number that represents an amount. Use a format that your database accepts. |
User Reserved Code | VOURCD | Alpha | 3 | A user-defined code that represents any alphanumeric value up to three characters. |
User Reserved Date | VOURDT | Date | 6 | A user-defined value that represents a date. Use a format that your database accepts.
See the data item for VOEBDT for more information. |
User Reserved Amount | VOURAT | Number | 15 | A user-defined value that represents an amount. Use a format that your database accepts. |
User Reserved Number | VOURAB | Number | 8 | A user-defined number up to eight digits. |
User Reserved Reference | VOURRF | Alpha | 15 | A user-defined alphanumeric value up to 15 characters. |
This section contains a list of the fields in the F0111Z1 table. Some of the fields are required to run the Who's Who Information Batch Upload program (R011110Z), while others are not. Not all fields are displayed on address book forms or used by the Address Book system.
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 | BWEDUS | 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 | BWEDBT | 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 | BWEDTN | 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 | BWEDLN | Number | 7 | A number used to uniquely identify a record. Each transaction can have multiple, consecutive line numbers. |
EDI - Successfully Processed | BWEDSP | 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 | BWTNAC | 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 | BWALPH | 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 | BWAN8 | 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 | BWIDLN | Number | 5 | A value that connects a who's who entry to an address book number. |
Mailing Name | BWMLNM | Alpha | 40 | An alphanumeric value representing the name of the company or the person to whom correspondence is sent. |
This table lists fields in the F0111Z1 table that are optional. You can use these fields to provide additional information about a transaction.
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
Type - Transaction | BWTYTN | 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 of the Who's Who MBF (P0100087), if set up.
This field is required if you use outbound processing. |
Direction Indicator | BWDRIN | Alpha | 1 | A value that specifies whether the transaction is inbound or outbound. Leave this field blank if the transaction is inbound. Enter 2 if the transaction is outbound. |
EDI - Detail Lines Processed | BWEDDL | Number | 5 | The number of detail lines included in a specific transaction. This field is informational only. |
Trading Partner ID | BWPNID | Alpha | 15 | A value used in an Electronic Data Interchange (EDI) transaction to identify who is trading documents with you. |
Display Sequence | BWDSS5 | Number | 5 | A code that specifies the order in which a group of records displays. You can specify a display sequence for each of your contact entries. |
Contact Title | BWATTL | Alpha | 40 | A code that indicates the professional title for a contact. |
Remark | BWREM1 | Alpha | 40 | 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. |
Salutation Name | BWSLNM | Alpha | 40 | An informational code that represents a title of courtesy used before a surname. It is used as a greeting word in correspondence. |
Secondary Alpha Name | BWALP1 | Alpha | 30 | An alternate name field to accommodate double-byte coding. |
Given Name | BWGNNM | Alpha | 25 | The first name of a person. This field is informational. |
Middle Name | BWMDNM | Alpha | 25 | The middle name of a person. This field is informational. |
Surname | BWSRNM | Alpha | 25 | The surname of a person. This field is informational only. |
Type Code | BWTYC | Alpha | 1 | A user-defined code that identifies the function of a contact (who's who) entry. Examples of type codes are:
A: Attention name B: Billing C: Contact E: Emergency contact O: Other T: 1099 legal name The value that you enter in this field must exist in UDC table 01/WO (Type Code). |
Nickname | BWNICK | Alpha | 40 | An informational field to use for the nickname for a person. The nickname is connected to a who's who line of an address book number. |
Gender | BWGEND | Alpha | 1 | A code that indicates the gender of a person. Values are:
M: Male F: Female |
Effective Date for Address | BWEFTW | Date | 8 | The date the address that is identified in the Alternate Address table (F01161) becomes active.
You must select the Address by Effective Date option in the Address Book constants if you want to enter effective dates. |
Date of Birth | BWDDATE | Number | 2 | A number that indicates the day portion for a person's date of birth. |
Month of Birth | BWDMON | Number | 2 | A number that indicates the month portion for a person's date of birth. |
Year of Birth | BWDYR | Number | 4 | A number that indicates the year portion for a person's date of birth. |
Who's Who Category Codes 01 through 10 | BWW001 through BWW010 | Alpha | 3 | A category code. The values that you enter in the category code fields must exist in the corresponding UDC tables 01/W0-01/WT. |
Who's Who Information Category Codes 01 through 10 | BWWN001 through BWWN010 | Alpha | 3 | A category code. The values that you enter in the category code fields must exist in the corresponding UDC tables 01/N1-01/NA. |
Preferred Contact Method | BWPCM | Alpha | 10 | A user-defined code (01/CQ) that defines the desired contact method for the contact. |
Primary Contact | BWPCF | Alpha | 1 | A code used to designate primary contacts for an address book entity. You can have only one primary contact per contact type. Enter 1 to designate a record as a primary contact. |
Indicator Flag | BWACTIN | Character | 1 | This field is reserved for future use. |
Unique Identifier | BWCFRGUID | Alpha | 36 | This field is used for synchronization with Domino or Exchange to uniquely identify a who's who record. |
Function Code | BWFUCO | Alpha | 10 | A user-defined code that indicates the function the contact plays in the company. Enter a value from UDC 01/FC. |
Reference Name | BWREFNAME | Alpha | 40 | This field is used for synchronization with Domino and Exchange. Enter the company name from Domino or Exchange. The system uses this value to search for a duplicate entry. |
Child Successfully Processed | BWCHPROC | Character | 1 | A code used to designate whether child records for the F0111Z1 record have processed successfully. Child records include records from these tables:
F01161Z1 F0115Z1 F01151Z1 F01112Z1 Child records are associated with the parent F0111Z1 field using EDI-User, EDI-Batch Number, and EDI-Transaction number. |
This table lists fields in the F0111Z1 table that are ignored. The system does not use the values in these fields.
Field Name | Alias | Type | Length |
---|---|---|---|
EDI - Document Type | BWEDCT | Alpha | 2 |
EDI - Translation Format | BWEDFT | Alpha | 10 |
EDI - Transmission Date | BWEDDT | Date | 6 |
Description - Compressed | BWDC | Alpha | 40 |
Transaction Originator | BWTORG | Alpha | 10 |
User ID | BWUSER | Alpha | 10 |
Program ID | BWPID | Alpha | 10 |
Work Station ID | BWJOBN | Alpha | 10 |
Date Updated | BWUPMJ | Date | 6 |
Time of Day | BWTDAY | Date | 6 |
Time Last Updated | BWUPMT | Number | 6 |
This table lists fields in the F0111Z1 table that are reserved for users. The system does not use the values in these fields.
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
Secondary Mailing Name | BWMLN1 | Alpha | 1 | An alternate mailing name field to accommodate double-byte coding. |
Search Type | BWAT1 | Alpha | 3 | A value that identifies a record as part of a specific group, such as suppliers, customers, employees, and companies. The value that you enter in this field must exist in UDC table 01/ST (Search Type). |
Active/ Inactive Flag | BWCCAI | Alpha | 1 | An indicator that specifies a currency relation as active or inactive. |
Contact Type | BWNTYP | Alpha | 3 | A user-defined value that indicates the role of the contact, such as an influencer, a competitor, and so on. The value that you enter in this field must exist in UDC table 01/CT (Contact Type). |
This section contains a list of the fields in the F01112Z1 table. Some of the fields are required to run the Contact Information Batch Upload program (R011110Z), while others are not. Not all fields are displayed on address book forms or used by the Address Book system.
This table lists fields in the F01112Z1 table that are required. For some fields, blank is a valid value.
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
EDI - User ID | PBEDUS | Alpha | 10 | A number that identifies a particular user who is running the process or who is to receive workflow messages. This field, used in conjunction with the PBEDTN and PBEDBT fields, uniquely identifies a transaction within a specific batch. |
EDI - Batch Number | PBEDBT | Alpha | 15 | A value that identifies a batch. This field, used in conjunction with the PBEDUS and PBEDTN fields, uniquely identifies a transaction within that batch. Each time the value changes, the system assigns a new batch number. You can significantly improve performance by assigning one batch number for each group of records. |
EDI - Transaction Number | PBEDTN | Alpha | 22 | A value that identifies each transaction. Each new transaction number indicates a new related person record. A batch cannot contain more than one transaction with the same number. Typically, this field typically contains the document number of the source system so that a record can be readily identified. |
EDI - Line Number | PBEDLN | Number | 7 | A number used to uniquely identify a record. Each transaction can have multiple, consecutive line numbers. |
EDI - Successfully Processed | PBEDSP | Alpha | 1 | A system-provided value that indicates whether the transaction processed successfully. Values are:
N: The transaction did not process or processed in error. Y: The transaction processed successfully. For outbound processing, system updates the value to N. |
Transaction Action | PBTNAC | Alpha | 2 | For inbound processing, a value that specifies the type of transaction. Values are:
A: The record is new. C: The record is a change for an existing document. Process changes after additions. D: The record is a deletion for an existing document. Process deletions after additions. For outbound processing, values are: UA: After image UB: Before image The system updates the table with UB only if the processing option in the Who's Who MBF (P0100087) is activated. For outbound processing, you can also enter A for additions and D for deletions. |
Address Number | PBAN8 | Number | 8 | A value that connects the related person to a unique address book record. The value in this field must exist in the Address Book Master table (F0101) or the record will not process. |
Who's Who Line | PBIDLN | Number | 5 | A value that connects a who's who entry to an address book record. |
Related Person | PBRALP | Alpha | 40 | A value that connects a related person entry to address book record. |
This table lists fields in the F01112Z1 table that are optional. You can use these fields to provide additional information about a transaction.
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
Type - Transaction | PBTYTN | Alpha | 8 | A value that identifies the type of transaction being processed.
If you leave this field blank, the system uses the value in the transaction type processing option of the Who's Who MBF (P0100087), if set up. You must complete this field if you are using outbound processing. |
Direction Indicator | PBDRIN | Alpha | 1 | A value that indicates whether a transaction is inbound or outbound. Values are:
Blank: Inbound 2: Outbound |
EDI - Detail Lines Processed | PBEDDL | Number | 5 | A value used in an Electronic Data Interchange (EDI) transaction to specify the number of detail lines included in a specific transaction. This field is informational only. |
Trading Partner ID | PBPNID | Alpha | 15 | A value used in an EDI transaction to identify who is trading documents with you. |
Related Person ID | PBCNLN | Number | 5 | A value used to connect a who's who or contact record with a related person. Each related person record must have a unique value in this field.
If you are changing or deleting records, this field is required. |
Relation Type | PBRELY | Alpha | 5 | A value that identifies the relationship between the contact the related person. The value that you enter in this field must exist in UDC table 01/RT. |
Day of Birth | PBDDATE | Number | 2 | A numeric value that specifies the day portion of the date of birth of a related person. |
Month of Birth | PBDMON | Number | 2 | A number that specifies the month portion of the date of birth of a related person. |
Year of Birth | PBDYR | Number | 4 | A number that specifies the year portion of an individual's date of birth. |
Related Person Category Codes 01 through 10 | PBCP001 through PBCP005 | Alpha | 3 | Category codes that are defined in the Address Book system and are used for reporting about related persons.
The values that you enter in these fields must exist in the corresponding UDC tables 01/CP001-01/CP005. |
This table lists fields in the F01112Z1 table that are ignored. The system does not use the values you enter in these fields.
Field Name | Alias | Type | Length |
---|---|---|---|
EDI - Document Type | PBEDCT | Alpha | 2 |
EDI - Translation Format | PBEDFT | Alpha | 10 |
EDI - Transmission Date | PBEDDT | Date | 6 |
Transaction Originator | PBTORG | Alpha | 10 |
User ID | PBUSER | Alpha | 10 |
Program ID | PBPID | Alpha | 10 |
Work Station ID | PBJOBN | Alpha | 10 |
Date Updated | PBUPMJ | Date | 6 |
Time of Day | PBTDAY | Date | 6 |
Time Last Updated | PBUPMT | Number | 6 |
This section contains a list of the fields in the F0115Z1. Some of the fields are required to run the Batch Who's Who Information program (R011110Z), while others are not
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. |
This table lists the fields in the F0115Z1 table that are optional.
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
Type Transaction | PITYTN | Alpha | 8 | A value that identifies the type of transaction. |
Direction Indicator | PIDRIN | Alpha | 1 | A value that specifies whether the transaction is inbound or outbound. Values are:
Blank: Inbound 1: Outbound Outbound processing for phones is not supported. |
Detail Lines Processed | PIEDDL | Number | 5 | The number of detail lines included in a specific transaction. This field is informational only. |
Trading Partner ID | PIPNID | Alpha | 15 | A value used in an Electronic Data Interchange (EDI) transaction to identify who is trading documents with you. |
Who's Who Line Number-ID | PIIDLN | Number | 5 | A code used to identify the line ID number for a Who's Who record. |
Line Number ID–5.0 | PIRCK7 | Number | 5 | A number used to create a unique key within a file. If you are using a program which will allow you to resequence the records, we recommend you use one of these data dictionary items: DSS5, DSS7, DSS9. |
Related Person-ID | PICNLN | Number | 5 | A number that is used to identify related person records. This field is used when you change or delete related person records. Enter the line number of the related person that you want to change or delete. |
Phone Number Type | PIPHTP | Alpha | 4 | A code that indicates either the location or use of a telephone number. Enter a valid code from UDC 01/PH. |
Phone Prefix | PIAR1 | Alpha | 6 | A number that designates the first segment of a telephone number. In the United States, the prefix is the three-digit area code. |
Generic Number 1 | PICFN01 | Number | 8 | This field is reserved for future use. |
General Information–1 | PIGEN1 | Alpha | 10 | This field is reserved for future use. |
Future Flag Use | PIFALGE | Character | 1 | This field is reserved for future use. |
This table lists the fields in the F0115Z1 that are ignored by the system. The system does not use the values in these fields.
Field Name | Alias | Type | Length |
---|---|---|---|
EDI-Translation Format | PIEDFT | Alpha | 10 |
EDI-Transmission Date | PIEDDT | Date | 6 |
EDI-Document Type | PIEDCT | Alpha | 2 |
User ID | PIUSER | Alpha | 10 |
Program ID | PIPID | Alpha | 10 |
Work Station ID | PIJOBN | Alpha | 10 |
Date Updated | PIUPMJ | Date | 6 |
Time Last Updated | PIUPMT | Number | 6 |
This section contains a list of the fields in the F01151Z1 table. Some of the fields are required to run the Batch Who's Who Information program (R011110Z), while others are not. Not all fields are displayed on address book forms or used by the Address Book system.
This table lists fields in the F01151Z1 table that are required. For some fields, blank is a valid value.
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
EDI - User ID | EBEDUS | 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 EBEDTN and EBEDBT fields, uniquely identifies a specific transaction. |
EDI - Batch Number | EBEDBT | Alpha | 15 | A code that, in conjunction with the EBEDTN and EBEDUS 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. |
EDI - Transaction Number | EBEDTN | Alpha | 22 | A code that identifies each transaction. Each 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 a transaction can be readily identified. |
EDI - Line Number | EBEDLN | Number | 7 | A number used to uniquely identify a record. Each transaction can have multiple, consecutive line numbers. |
EDI - Successfully Processed | EBEDSP | Alpha | 1 | A value that indicates whether the transaction has successfully processed. The value N indicates that the transaction was not processed or was processed in error. After the transaction is successfully processed, the system changes the value to Y.
For outbound processing, the value is updated to N. |
Transaction Action | EBTNAC | Alpha | 2 | A value that indicates the type of transaction. For a new entry, enter A in this field. If you are processing a change for an existing document, enter C. All changes must be processed after additions.
For outbound processing, the system updates this field with either UA (after image) or UB (before image). The system updates the table with UB only if the processing option in the Who's Who MBF (P0100087) is activated. For outbound processing, you can also enter D for deletion and A for additions. |
Address Number | EBAN8 | Number | 8 | A value that uniquely identifies the company, customer, supplier, and so on to which the contact (who's who) for the related person is linked. The value in this field must exist in the Address Book Master table (F0101) or the record does not process. |
Who's Who Line | EBIDLN | Number | 5 | A value that connects the electronic address to a particular who's who entry for the address number entered in the EBAN8 field. |
This table lists fields in the F01151Z1 table that are optional. You can use these fields to provide additional information about a transaction.
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
Type - Transaction | EBTYTN | Alpha | 8 | A value that identifies whether the transaction is for the after image only, or the before and after image. If you leave this field blank and the transaction type processing option of the Who's Who MBF (P0100087) is set up, the system updates this field with the value in the processing option.
You must complete this field if you are using outbound processing. |
Direction Indicator | EBDRIN | Alpha | 1 | A value that specifies whether a transaction is inbound or outbound. Values are:
Blank: Inbound 2: Outbound |
EDI - Detail Lines Processed | EBEDDL | Number | 5 | A value indicating the number of detail lines included in a specific transaction. This field is for user verification only. |
Trading Partner ID | EBPNID | Alpha | 15 | A value used in an EDI transaction that identifies the party trading documents with you. |
Line Number ID-5.0 | EBRCK7 | Number | 5 | A value that indicates a unique key field. If you have more than one electronic mail address for a contact or who's who entry, you can use this field to order the entries. |
Electronic Address Type | EBETP | Alpha | 4 | A value that indicates whether an address is an E-mail address or an internet address. |
Electronic Address | EBEMAL | Alpha | 256 | A value that identifies the E-mail or internet address for the contact or who's who individual. |
Messaging Indicator | EBEHIER | Number | 2 | The messaging indicator used by workflow to determine how E-mail addresses will be processed. Enter 00 if E-mail will not be sent to the specified address. Enter 01 if E-mail will be sent to the specified address. |
E-mail Format | EBEFOR | Alpha | 15 | Enter the format of the E-mail address, for example:
HTML Text RTF |
Generic Number 1 | EBCFN01 | Number | 8 | This field is reserved for future use. |
General Information 1 | EBGEN1 | Alpha | 10 | This field is reserved for future use. |
Future Flag Use | EBFALGE | Alpha | 1 | This field is reserved for future use. |
E-mail Classification | EBCLASS | Alpha | 3 | Reserved for future use. |
This table lists fields in the F01151Z1 table that are ignored. The system does not use the values in these fields.
Field Name | Alias | Type | Length |
---|---|---|---|
EDI - Document Type | EBEDCT | Alpha | 2 |
EDI - Translation Format | EBEDFT | Alpha | 10 |
EDI - Transmission Date | EBEDDT | Date | 6 |
Transaction Originator | EBTORG | Alpha | 10 |
User ID | EBUSER | Alpha | 10 |
Program ID | EBPID | Alpha | 10 |
Work Station ID | EBJOBN | Alpha | 10 |
Date Updated | EBUPMJ | Date | 6 |
Time of Day | EBTDAY | Date | 6 |
Time Last Updated | EBUPMT | Number | 6 |
This section contains a list of the fields in the F01161Z1 table. Some of the fields are required to run the Contact Information Batch Upload program (R011110Z), while others are not. Not all fields are displayed on address book forms or used by the Address Book system.
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. |
This table lists fields in the F01161Z1 that are optional. You can use these fields to provide additional information about a transaction.
Field Name | Alias | Type | Length | Definition |
---|---|---|---|---|
Type - Transaction | LBTYTN | Alpha | 8 | A value that identifies the type of transaction. If you leave this field blank and the transaction type processing option of the Who's Who MBF (P0100087) is set up, the system updates this field with the value in the processing option.
This field is required if you use outbound processing. |
Direction Indicator | LBDRIN | Alpha | 1 | A value that specifies whether the transaction is inbound or outbound. Values are:
Blank: Inbound 2: Outbound |
EDI - Detail Lines Processed | LBEDDL | Number | 5 | The number of detail lines included in a specific transaction. This field is informational only. |
Trading Partner ID | LBPNID | Alpha | 15 | A value used in an Electronic Data Interchange (EDI) transaction to identify who is trading documents with you. |
Date - Beginning Effective | LBEFTB | Date | 6 | The date the alternative address 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 Line 1, Address Line 2, Address Line 3, Address Line 4 | LBADD1
LBADD2 LBADD3 LBADD4 |
Alpha | 40 | Alphanumeric values that identify the mailing address for the alternative address record. |
Postal Code | LBADDZ | Alpha | 12 | A code assigned by the postal service of a country that is attached to the address to facilitate mail delivery. |
City | LBCTY1 | Alpha | 25 | The city associated with an alternative address. |
County | LBCOUN | Alpha | 25 | The county, parish, or other political district associated with an address for mail delivery or for tax purposes. |
State | LBADDS | Alpha | 3 | The state or province associated with an address. The value that you enter in this field must exist in UDC table 00/S (State or Province). |
Country | LBCTR | 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). |
Effective Date Existence (I/O) | LBEFTF | Alpha | 1 | A code that indicates whether there is an effective date for an address. |
Main Address Flag | LBMAINA | Alpha | 1 | A code that indicates that the address is the primary address. |
This table lists fields in the F01161Z1 table that are ignored. The system does not use the values in these fields.
Field Name | Alias | Type | Length |
---|---|---|---|
EDI - Document Type | LBEDCT | Alpha | 2 |
EDI - Translation Format | LBEDFT | Alpha | 10 |
EDI - Transmission Date | LBEDDT | Date | 6 |
Transaction Originator | LBTORG | Alpha | 10 |
User ID | LBUSER | Alpha | 10 |
Program ID | LBPID | Alpha | 10 |
Work Station ID | LBJOBN | Alpha | 10 |
Date Updated | LBUPMJ | Date | 6 |
Time of Day | LBTDAY | Date | 6 |
Time Last Updated | LBUPMT | Number | 6 |