Optional Fields Used by the Sales Order Management System

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.

Field Name	Alias	Type	Length	Definition
ABC Code Sales	VOABC1	Alpha	1	A grade that represents the level of sales activity for a customer or for inventory items. This field indicates the use of the 80/20 principle (80 percent of the significant results are attributable to 20 percent of the business effort). The possible grades are A (best) to F (worst). You can leave this field blank and run the ABC Analysis program (R4164), which assigns the code.
ABC Code Inventory	VOABC2	Alpha	1	A code that represents an item's ranking by average investment. Values are: A: Assign this item to the first amount ranking. B: Assign this item to the second amount ranking. C: Assign this item to the third amount ranking D: Skip this item in the ABC Analysis. You can leave this field blank and run the ABC Analysis program, which assigns the code based on an item's value as follows: Total Item Average Investment divided by Business Unit Average Investment equals the Item's Calculated Value Total
ABC Code Average Days	VOABC3	Alpha	1	A code that represents the average number of days that a customer takes to pay an invoice. This field indicates the system is using the 80/20 principle (80 percent of the significant results are attributable to 20 percent of the business effort). The possible grades are A (best) to F (worst). You can leave this field blank and run the ABC Analysis program, which assigns the code.
Open Order Amount	VOAPRC	Number	15	A number that represents the total amount of open orders for this customer. Use a format that your database accepts. Some databases accept a decimal identifier while others do not.
Maximum Order Value	VOMAXO	Number	15	A number that represents the largest order that can be entered. If the amount of the order is greater than the number entered in this field, the system will return an error.
Minimum Order Value	VOMINO	Number	15	A number that represents the lowest amount of an order that can be entered. If the amount of the order is smaller than the amount entered in this field, an error is returned.
Orders Year To Date	VOOYTD	Number	3	The number of orders for the current year.
Orders Prior Year	VOOPY	Number	3	The number of orders for the prior year.
Related Address Number	VOAN8R	Number	8	A value that connects a ship-to address to a sold-to address, or the opposite. For example, if you enter only a ship-to address in sales order entry, the system uses this field to determine which address number to select from the list of related address numbers, which is the value in the Sold-To field. The values for this field are 1 through 7. The value that you enter in this field must exist in UDC table 40/RA (Related Address Number).
Billing Address Type	VOBADT	Alpha	1	A code that directs the system to use this address as a sold-to address, a ship-to address, or both. Values are: X: Indicates a bill-to and a ship-to address. S: Indicates only a ship-to address. B: Indicates only a bill-to address The value that you enter in this field must exist in UDC table H42/BA (Billing Address Type).
Customer Price Group	VOCPGP	Alpha	8	A code that identifies a group of customers. The value that you enter in this field must exist in UDC table 40/PC (Customer Price Groups).
Order Template	VOORTP	Alpha	8	A code that identifies a list of items that are most frequently ordered. The value that you enter in this field must exist in UDC table 40/OT (Order Templates).
Trade Discount	VOTRDC	Number	7	A number that represents the percentage by which the system reduces the price of each item. This percentage is the only discount that will be applied. You can override the discount percentage if you enter a price. Enter the percentage as a whole number (for example, 5 for 5 percent).
Print Message	VOINMG	Alpha	10	A code that is assigned to 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).
Credit Hold Exempt	VOEXHD	Alpha	1	A code that indicates whether the customer is exempt from credit checking in the sales order processing cycle. Values are: Y: This customer is exempt from credit checking. N: This customer is not exempt from credit checking. If credit checking is activated in the Sales Order Entry processing options and the customer exceeds the limit, the order is placed on hold.
Hold Orders Code	VOHOLD	Alpha	2	A code that describes the reason why 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	A code that represents the delivery route for the customer. This field is one of several fields used by the freight summary facility to calculate potential freight charges for an order. For picking, use the route code with the stop and zone codes to group all of the items that are to be loaded onto a delivery vehicle for a specific route. The value that you enter in this field must exist in UDC table 42/RT (Route Code). You set up the default for this field on the Customer Billing Instructions form.
Stop Code	VOSTOP	Alpha	3	A code that represents the stop on a delivery route. This field is one of several fields used by the freight summary facility to calculate potential freight charges for an order. For picking, use the stop code with the route and zone codes to group all of the items that are to be loaded onto a delivery vehicle for a specific route. The value in this field must exist in UDC table 42/SP (Stop Code). You set up the default for this field on the Customer Billing Instructions form.
Zone Number	VOZON	Alpha	3	A code that represents the delivery area where the customer is located. This field is one of several fields used by freight summary facility to calculate potential freight charges for an order. For picking, use the zone code with the route and stop codes to group all items that are to be loaded on to a delivery vehicle for a specific route. The value that you enter in this field must exist in the UDC table 40/ZN (Zone Number). You set up the default for this field on the Customer Billing Instructions 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	Use this field to enter delivery instructions.
Delivery Instructions Line 2	VODEL2	Alpha	30	Use this field to enter delivery instructions.
Transit Days	VOLTDT	Number	5	A value that represents the number of days that goods are in transit. When you enter a number in this field, the Sales Order Detail program (P4210) subtracts the number from the promised delivery date to calculate a pick release date.
Freight Handling code	VOFRTH	Alpha	5	A code that designates the method for a customer to receive shipments. You can use this code to indicate who has responsibility for freight charges. The value you enter in this field must exist in UDC table 42/FR (Freight Handling Code).
Apply Freight (Y/N)	VOAFT	Alpha	1	A code that indicates whether the system performs freight calculations during processing. Values are: Y: The system performs freight calculations during processing. N: The system does not perform freight calculations during processing. If you leave this field blank, the system updates it with Y when the record is processed.
Partial Line Shipments Allowed (Y/N)	VOAPTS	Alpha	1	A code that indicates whether the customer requires that the entire line be shipped at one time or whether the customer accepts multiple partial shipments instead. Values are: Y: The customer requires full shipments. N: The customer permits partial shipments. If you leave this field blank, the system updates it to Y when the record is processed.
Substitutes Allowed (Y/N)	VOSBAL	Alpha	1	A code that indicates whether the customer accepts substitute items. Values are: Y: The customer accepts substitute items. N: The customer does not accept substitute items If you leave this field blank, the system updates it to Y when the record is processed.
Backorders Allowed (Y/N)	VOBACK	Alpha	1	A code that indicates whether the customer allows backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item Branch/Plant (P41012) program, or by customer using the Customer Billing Instructions program (P03013), or by branch/plant using the Branch/Plant Constants program (P41001). Values are: Y: Allow backorders for this item N: Do not allow backorders for this item regardless of the backorders code assigned to the customer.
Customer PO Required (Y/N)	VOPORQ	Alpha	1	A code that indicates whether a purchase order is required for the customer. Values are: Y: A customer purchase order number is required. N: A customer purchase order number is not required.
Priority Processing	VOPRIO	Alpha	1	A code that prioritizes orders for a customer. This value determines the priorities for printing pick slips. In addition, the Backorders to Fill report (R42118) can be sequenced by this code to release orders with the highest priority first. The value that you enter in this field must exist in UDC table H40/PR (Priority Processing Code).
Credit Check Level	VOARTO	Alpha	1	A code that controls how the system performs credit checking. Values are: P: The credit check is based on the customer's parent number C: The credit check is based on the customer number only. S: The credit check is based on the customer number only. If you use method P, the system compares the open accounts receivable and open sales orders for the sum of the children and the parent against the credit limit for the parent number. For example, you can use method P when a customer with multiple offices or branches requests that all credit checking be reflected in a single account. Note: Even though credit checking can be conducted at the parent or customer number level, all accounts receivable transactions are posted to the Customer Number field (SDAN8) when you run the Sales Update program (R42800).
Invoice Copies	VOINVC	Number	2	The number of invoice copies to print.
Invoice Consolidation	VOICON	Alpha	1	A code that indicates whether to consolidate invoices for a customer. Values are: Y: The system generates a single invoice from multiple sales orders. Blank: The system updates this field with N when the record is processed.
Billing Frequency	BOBLFR	Alpha	1	A code that defines the billing frequency to use when determining how often to run invoices. Values are: M: Monthly W: Weekly D: Daily The value that you enter in this field must exist in UDC table H42/BL (Billing Frequency). However, the system recognizes only the values listed above.
Next Invoice Date	VONIVD	Date	6	A date that indicates the next time invoices will be printed for the customer. Use a format that your database accepts. See the date item VODLC for examples. This field is used in conjunction with the VOBLFR field to determine how often and when invoices are printed.
License Expiration Date	VOLEDJ	Date	6	The date a license expires.
Price Pick List (Y/N)	VOPLST	Alpha	1	A code that indicates whether price information appears on the customer pick list, purchase order, or sales order. If you leave this field blank, the system updates it with Y when the record is processed.
Merge Orders (Y/N)	VOMORD	Alpha	1	A code that prevents a customer order from being shipped together and merged by the Warehouse Management system.
Pallet Control	VOPALC	Alpha	1	A code that identifies customers who allow the shipment of pallets. Values are: Y or 1: Customer allows the shipment of pallets N or 0: the customer does not allow the shipment of pallets.
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 that 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 in the Inventory Constants table (F41001).
Unit of Measure - Weight Display	VOWUMD	Alpha	2	A code that identifies the unit of measure to display for the weight of an order. The value that 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 in the F41001 table.
Batch Processing Mode	VOEDPM	Alpha	1	A code that indicates whether the customer is prohibited from batch processing or whether the customer is in a test or production mode. Values are: I: Inhibited. The customer 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
Item Type Identifier	VOEDII	Alpha	1	A code that specifies the type of item number to be sent in an Electronic Data Interchange 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).
Customer Type Identifier	VOEDCI	Alpha	1	A code that specifies the type of number to be sent in 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).
Quantity Decimals	VOEDQD	Number	1	The number of positions to the right of the decimal point that is used for all quantity fields in an EDI transaction for this customer.
Amount Decimals	VOEDAD	Number	1	The number of positions to the right of the decimal point that is used for all amount fields in an EDI transaction for this customer.
Delivery Note	VOEDF1	Alpha	1	A code that indicates whether the system prints delivery notes for a customer. If you leave this field blank, the system updates it with N when the record is processed.
Item Restrictions	VOEDF2	Alpha	2	A code that designates whether restrictions are placed on ordering items from this supplier. Values are: I: An item may only be purchased if it is set up on the Item Restrictions form. E: An item may not be purchased when it is set up on the Item Restrictions form.
Partial Order Shipments Allowed (Y/N)	VOSI01	Alpha	1	A code that indicates whether the customer requires that the entire order be shipped at one time or whether the customer accepts multiple partial shipments. If you leave this field blank, the system updates it with Y when the record is processed. Note: Partial order shipments allowed is activated only when adding orders in the Sales Order Entry program (P4210) with availability checking activated, since this program is the only place that all lines can be grouped together as an order. Availability checking performed at pick slips or shipment confirmation does not guarantee that all lines are together for the order.
COA Print (Y/N)	VOSI02	Alpha	1	A code that indicates the certificate of analysis.
Special Instruction 03	VOSI03	Alpha	10	Reserved for future use.
Special Instruction 04	VOSI04	Alpha	10	Reserved for future use.
Special Instruction 05	VOSI05	Alpha	10	Reserved for future use.
Sales Price Based on Date	VOCP01	Alpha	1	A value that indicates how the system determines the Price Effective Date in the Sales Order Header File (F4201) and Sales Order Detail File (F4211). In Sales Order Management, the system uses the Price Effective Date field (PEFJ) to retrieve the base price from the Item Base Price table (F4106) and the price adjustments from the Price Adjustment Detail table (F4072).
Price and Adjustment Schedule	VOASN	Alpha	8	A code that identifies a price and adjustment schedule. A price and adjustment schedule contains one or more adjustment types for which a customer or an item might be eligible. The system applies the adjustments in the sequence that you specify in the schedule. You connect customers to a price and adjustment schedule through the customer billing instructions. When you enter a sales order, the system copies the schedule that is attached to the sold to address in the order header. You can override the schedule at the detail line level. For the Agreement Management system, this is the Agreement Penalty Schedule. The information in the schedule provides the system with the criteria for an agreement to have penalty conditions. The value that you enter in this field must exist in UDC table 40/AS (Adjustment Schedule).
Price Adjustment on Invoice (Y/N)	VODSPA	Alpha	1	A code that identifies whether the system should print the price adjustment details on the sales invoice. This field is active only if you use the Advanced Price Adjustment system.
Program Name - Shipping Labels	VOSLPG	Alpha	10	The name of the program that is used to print shipping labels for a customer.
Version Name - Shipping Label Program	VOSLDW	Alpha	10	The version of the program used to print shipping labels for a customer.
Configuration Pick and Pack	VOCFPP	Alpha	18	The default pick and pack configuration required by a customer.
Configuration Standard Carton Pack	VOCFSP	Alpha	18	The default configuration for standard carton pack required by a customer.
Default Configuration	VOCFDF	Alpha	1	The default configuration for carton pack required by a customer. Values are: 1: Pick and pack configuration 2: Standard carton configuration Blank: UCC-128 processing is not performed for this customer
Requires Packaging Code	VORQ01	Alpha	1	A value that indicates whether a packaging code is required for a customer. Values are: 1: A packaging code is required for this customer. Blank: A packaging code is not required
Requires Weight Code	VORQ02	Alpha	1	A value that indicates whether a weight code is required for a customer. Values are: 1: A weight code is required for this customer. Blank: a weight code is not required
Requires Identification Code 1	VORQ03	Alpha	1	A value that indicates whether an identification code is required for a customer. Values are: 1: An identification code is required for this customer. If you enter 1 in this field, you must also enter a value in the CODR03 field. Blank: An identification code is not required.
Requires Identification Code 2	VORQ04	Alpha	1	A value that indicates whether an identification code is required for a customer. Values are: 1: An identification code is required for this customer. If you enter 1 in this field, you must also enter a value in the CODR04 field. Blank: An identification code is not required.
Requires Transportation Method	VORQ05	Alpha	1	A value that indicates whether a transportation method is required for a customer. Values are: 1: A transportation method is required for this customer. Blank: A transportation method is not required.
Requires Routing	VORQ06	Alpha	1	A value that indicates whether a routing description is required for a customer. Values are: 1: A routing description is required for this customer. Blank: A routing code is not required
Requires Equipment	VORQ07	Alpha	1	A value that indicates whether an equipment code is required for a customer. Values are: 1: An equipment code is required for this customer. Blank: An equipment code is not required.
Requires Reference Number 1	VORQ08	Alpha	1	A value that indicates whether a reference number is required for a customer. Values are: 1: A reference number is required for this customer. If you enter 1 in this field, you must also complete the VODR08 field with a valid value. Blank: A reference number is not required.
Requires Reference Number 2	VORQ09	Alpha	1	A value that indicates whether a reference number is required for a customer. Values are: 1: A reference number is required for this customer. If you enter 1 in this field, you must also enter a value in the VODR09 field. Blank: A reference number is not required.
Default Identification Code Qualifier 1	VODR03	Alpha	2	The value in the default Identification Code Qualifier that is used for this customer. The code is used in the Inventory Management system. The value that you enter in this field must exist in UDC table 41/X6 (X12 Reference Number Qualifier).
Default Identification Code Qualifier 2	VODR04	Alpha	2	The value in the default Identification Code Qualifier that is used for this customer. The code is used in the Inventory Management system. The value that you enter in this field must exist in UDC table 41/X6 (X12 Reference Number Qualifier).
Default Reference Number Qualifier 1	VODR08	Alpha	2	The value in the default Reference Number Qualifier that is used for this customer. The code is used in the Inventory Management system. The value that you enter in this field must exist in UDC table 41/X6 (X12 Reference Number Qualifier).
Default Identification Code Qualifier 2	VODR09	Alpha	2	The value in the default Reference Number Qualifier that is used for this customer. The code is used in the Inventory Management system. The value that you enter in this field must exist in UDC table 41/X6 (X12 Reference Number Qualifier).