NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for changing a record in Customer Change Import.
Customer Code |
Sequence Number (only for bill-to or ship-to address changes) |
Field to change (specify either the name or the number) |
New Data |
Example
Customer Code |
Sequence Number |
Field to change |
New Data |
|
|
|
|
10000 |
|
Customer-Name |
Wal Mart New Name |
10000 |
10 |
20600 |
Ship-to New Name |
If the import file includes a sequence number for a non ship-to or bill-to field, the import process will error out.
The following table lists fields that can be updated. You can indicate a field by either its field name or its number.
Number |
Field |
Maximum Length |
Format |
Description |
Apprise Field |
10200 |
Customer-name |
40 |
Character |
Enter the name of the customer. |
Customer Name field in Customer Maintenance |
10300 |
Search-name |
20 |
Character |
Enter the customer’s alternative search name (such as a short name or acronym for the customer). |
Search Name field in Customer Maintenance |
10400 |
Active |
3 |
YES/NO |
Enter YES if this customer is active and you want the customer to be listed in all Lookup windows. Enter NO if the customer is not active. |
Active check box on the Main tab in Customer Maintenance |
10500 |
Customer-type |
19 |
Character |
Enter one of the following customer types:
|
Type field on the Main tab in Customer Maintenance |
10600 |
Cust-address-1 |
60 |
Character |
Enter the first line of the customer's address. |
Address 1 field on the Main tab in Customer Maintenance |
10700 |
Cust-address-2 |
60 |
Character |
Enter the second line of the customer's address. |
Address 2 field on the Main tab in Customer Maintenance |
10800 |
Cust-address-3 |
60 |
Character |
Enter the third line of the customer's address. |
Address 3 field on the Main tab in Customer Maintenance |
10900 |
Cust-city |
40 |
Character |
Enter the city of the customer's address. If postal codes are being validated, you must enter a valid city for the postal code. |
City field on the Main tab in Customer Maintenance |
11000 |
Cust-state |
3 |
Character |
Enter the state or province of the customer's address. This field is validated. For more information on state and province codes, see State and Province Maintenance. |
State field on the Main tab in Customer Maintenance |
11100 |
Cust-county |
36 |
Character |
Enter the county of the customer's address. |
County field on the Main tab in Customer Maintenance |
11200 |
Cust-country |
10 |
Character |
Enter the country of the customer's address. This field is validated. For more information, see Country Maintenance. |
Country field on the Main tab in Customer Maintenance |
11300 |
Cust-postal-code |
10 |
Character |
Enter the postal code for the customer's address. The format is defined in Country Maintenance. This field is optionally validated if validation is enabled for the country of the address. For more information, see Postal Code Maintenance. |
Postal Code field on the Main tab in Customer Maintenance |
11500 |
Cust-phone |
16 |
Character |
Enter the customer's phone number. The format of the telephone number is set up in Country Maintenance. |
Phone # field on the Main tab in Customer Maintenance |
11600 |
Cust-fax |
16 |
Character |
Enter the customer's fax number. The format of the telephone number is set up in Country Maintenance. |
Fax # field on the Main tab in Customer Maintenance |
11700 |
Cust-email |
60 |
Character |
Enter the customer's email address. |
Email Address field on the Main tab in Customer Maintenance |
11800 |
Cust-attention |
36 |
Character |
Enter the main contact of the customer who should receive invoices. |
Attention field on the Main tab in Customer Maintenance |
11900 |
Shared-shipto-invoice-format |
10 |
Character |
Enter one of the following invoice print formats to use when printing in Invoice Copy Print for a shared ship-to address.
|
Shared Ship-To Invoice Format radio set in Customer Maintenance |
12000 |
Sales-agent-1 |
12 |
Character |
Enter a valid default primary sales representative for the customer's orders. This default is only used if a default primary sales representative is not entered for the customer's ship-to address. For information on setting up sales representatives, see Sales Representative Maintenance. |
Sales Representative 1 field on the Sales tab in Customer Maintenance |
12100 |
Sales-agent-2 |
12 |
Character |
Enter a valid default secondary sales representative for the customer's orders. This default is only used if a default secondary sales representative is not entered for the customer's ship-to address. For information on setting up sales representatives, see Sales Representative Maintenance. |
Sales Representative 2 field on the Sales tab in Customer Maintenance |
12200 |
Ship-location |
3 |
Character |
Enter a valid default shipping location prefix for the customer's orders. Note This default is only used if a default shipping location prefix is not entered for the customer's ship-to address, and if the Shipping or Both radio button is selected for the Use Customer Location for option in Accounts Receivable Control Maintenance. For information on setting up locations, see Location Maintenance. |
Shipping Location field on the Sales tab in Customer Maintenance |
12300 |
Sales-location |
3 |
Character |
Enter a valid default sales location prefix for the customer's orders. Note This default is only used if a default sales location prefix is not entered for the customer's ship-to address, and if the Sales or Both radio button is selected for the Use Customer Location for option in Accounts Receivable Control Maintenance. For information on setting up locations, see Location Maintenance. |
Sales Location field on the Sales tab in Customer Maintenance |
12400 |
Sales-group |
12 |
Character |
Enter a customer group ID for the customer. This field is validated. This data is used to group customers together for the Executive Information Systems module and other inquiries. For more information, see Customer Group Maintenance. |
Sales Group field on the Sales tab in Customer Maintenance |
12450 |
pricing-id |
12 |
Character |
Enter a valid customer code to use for price calculations for the customer. |
Pricing Customer Code field on the Sales tab in Customer Maintenance |
12500 |
Sales-territory |
12 |
Character |
Enter a valid sales territory for the customer. The sales territory is another way to group customers. This data is used in several Executive Information Systems module sales representative analysis programs. For more information on sales territories, see Sales Territory Maintenance. |
Sales Territory field on the Sales tab in Customer Maintenance |
12600 |
Sales-shipper |
12 |
Character |
Enter the default shipper to use in Order Entry. This field is validated. For more information, see Shipper Maintenance. A shipper may or may not be a fleet delivery shipper. |
Default Shipper field on the Sales tab in Customer Maintenance |
12700 |
Sales-pb-hierarchy |
|
Character |
Enter valid price books for the customer. Separate each price book with the following delimiter character: | Example PriceBookA|PriceBookB|PriceBookC A price book is a grouping for price calculations. The order of price books in this field determines the hierarchy for the customer's price books. Prices at the top of the hierarchy are used before prices lower in the hierarchy (unless the system or customer is set up to use the best price). For information on setting up price books, see Price Book Maintenance. |
Selected Price Books grid on the Sales tab in Customer Maintenance |
12800 |
Sales-comm-book |
12 |
Character |
Enter the commission book for the customer. This field is validated. This allows you to set up commissions for groups of customers. For more information on commission books, see Commission Book Maintenance. |
Commission Book field on the Sales tab in Customer Maintenance |
12900 |
Sales-use-best |
7 |
Character |
Enter one of the following to determine if you want the best price from all price matrix entries for the entered customer and product to be selected when using a price matrix during sales order entry:
|
Use Best Price radio set on the Sales tab in Customer Maintenance |
13000 |
Sales-comm-by-line |
3 |
YES/NO |
Enter YES if you want each order line for the customer to be evaluated to determine the sales representative that will receive commission for the line item. Enter NO if you do not want each line item to be evaluated for calculating commissions. |
Sales Representative By Line Item check box on the Sales tab in Customer Maintenance |
13100 |
Remit-to-id |
20 |
Character |
Enter the address where this customer should send payments (this remit-to address is printed on invoices). This field is validated. For more information, see Payment Remit To Address Maintenance. |
Remit-to Address ID field on the A/R tab in Customer Maintenance |
13200 |
Invoice-consolidation |
18 |
Character |
Enter one of the following invoice consolidation methods:
For more information, see Consolidate Invoices Options FAQ. Note You can only change the invoice consolidation method for customers that do not have any open pick demands. |
Invoice Consolidation field on the A/R tab in Customer Maintenance |
13300 |
Invoice-print-method |
6 |
Character |
Enter the method of delivering invoices to the customer. Options are Print, Print/No EDI, or EDI. This field is used during the invoice printing process. |
Invoice Method field on the A/R tab in Customer Maintenance |
13400 |
Invoice-print-freq |
9 |
Character |
Enter one of the following options:
|
Invoice Print Frequency field on the A/R tab in Customer Maintenance |
13500 |
Order-class |
10 |
Character |
Enter the default order class for this customer in Order Entry. This field is validated. For more information, see Order Class Maintenance. |
Default Order Class field on the Options tab in Customer Maintenance |
13600 |
Default-fob |
12 |
Character |
Enter the default Freight on Board (FOB) for this customer in Order Entry. This field is validated. For more information, see Freight On Board Maintenance. |
Default F.O.B. field on the Options tab in Customer Maintenance |
13700 |
Order-priority |
4 |
Integer |
Enter the order priority for the customer. This field is used for backorder priority processing. This is the default used in Order Entry. The higher the number, the higher the priority. |
Order Priority field on the Options tab in Customer Maintenance |
13800 |
Cust-pick-group |
12 |
Character |
Enter the customer pick group for the customer. This field is validated. This field is used for pick demand creation purposes. For more information, see Customer Pick Group Maintenance. |
Customer Pick Group field on the Options tab in Customer Maintenance |
13900 |
Rewards-cust |
12 |
Character |
Enter the rewards customer code for the customer. For information on setting up rewards customers, see Reward Customer Maintenance. |
Rewards Customer field on the Options tab in Customer Maintenance |
14000 |
Campanion-book-id |
12 |
Character |
Enter the companion book ID for the customer. This field is validated. Companion books allow you to group customers for companion product purposes. For more information on companion books, see Companion Book Maintenance. |
Companion Book ID field on the Options tab in Customer Maintenance |
14100 |
Ship-label-format |
20 |
Character |
Enter the shipping label format for the customer. |
Shipping Label Format field on the Options tab in Customer Maintenance |
14200 |
Pallet-label-format |
20 |
Character |
Enter the pallet label format for the customer. |
Pallet Label Format field on the Options tab in Customer Maintenance |
14300 |
Forecast-group |
12 |
Character |
Enter the customer forecast group for the customer. This field is validated. You can use customer forecast groups to group customers for product forecasting. For more information on customer forecast groups, see Customer Forecast Group Maintenance. |
Forecast Group field on the Groups tab in Customer Maintenance |
14400 |
Consignment-location |
3 |
Character |
Enter a valid location prefix of the consignment location for the customer. For more information on customer consignment, see Consignment Order Process Flow. |
Consignment Location field on the Options tab in Customer Maintenance |
14500 |
Ship-orders-complete |
3 |
YES/NO |
Enter YES if you want to only ship complete orders to the customer. If you enter YES, the Ship Complete check box is selected by default for the customer's orders in Order Entry. However, you can still manually clear this check box in Order Entry if you want to ship incomplete orders to the customer. If this check box is selected and any line items on an order have not been allocated due to backorders or future allocations, the order is not shipped until all line items are allocated and ready to be shipped. Enter NO if you want the Ship Complete check box to be cleared by default for the customer's orders in Order Entry. |
Ship Orders Complete check box on the Options tab in Customer Maintenance |
14600 |
Orders-freight-free |
3 |
YES/NO |
Enter YES if you do not want to charge the customer freight on orders. If you enter YES, the Freight Free check box is selected by default for the customer's orders in Order Entry. However, you can still manually clear this check box in Order Entry if you want to charge freight for the customer. This setting may also be overridden by the freight free setting for the order class or freight collection terms on an order. Enter NO if you want the Freight Free check box to be cleared by default for the customer's orders in Order Entry. Note If you do not want to directly bill for freight charges for the customer's orders, enter YES. |
Orders Default As Freight Free check box on the Options tab in Customer Maintenance |
14700 |
Order-ack-required |
3 |
YES/NO |
Enter YES if the order acknowledgment process must take place each time an order is placed for the customer. Enter NO if you do not want the order acknowledgment process to always occur for the customer. |
Require Order Acknowledgment check box on the Options tab in Customer Maintenance |
14800 |
Cancel-BO |
3 |
YES/NO |
Enter YES to select the check box in the Cancel Backorder column in the Items grid in O/E Line Item Entry for products ordered by this customer. If the check box is selected in O/E Line Item Entry for a line item, and the line item is fully backordered, the backordered quantity is cancelled when a pick demand is printed for the order. If the check box is selected in O/E Line Item Entry for a line item, and the line item is partially backordered, the backordered quantity is cancelled when inventory is adjusted for a pick demand for the line item. Enter NO if you do not want to cancel backorder quantities for picked line items. |
Cancel Backorder check box on the Options tab in Customer Maintenance |
14900 |
Require-po-num |
3 |
YES/NO |
Enter YES to require the entry of a customer’s purchase order number during order entry. Enter NO if you do not want to require a customer's purchase order number to be entered during order entry. |
Require PO Number check box on the Options tab in Customer Maintenance |
15000 |
Ship-bo-complete |
3 |
YES/NO |
Enter YES if you want to only ship backorders when goods are allocated in full. If you enter YES, the Ship Backorder Complete check box is selected by default for the customer's orders in Order Entry. However, you can still manually clear this check box in Order Entry if you want to ship incomplete backorders for the customer. If this check box is selected and an order is on partial backorder, the allocated products from the orders are picked for shipment, but the remainder of the backorder is not shipped unless goods are allocated in full. Enter NO if you want the Ship Backorder Complete check box to be cleared by default for the customer's orders in Order Entry. |
Ship Backorders Complete check box on the Options tab in Customer Maintenance |
15100 |
Internal-customer |
3 |
YES/NO |
Enter YES if the customer is an internal customer or department that will be charged for products used. Only internal customers can be entered on an order that uses an order class for which the Use for Internal Requisitions Only check box is selected in Order Class Maintenance. For more information, see Internal Requisitions. Enter NO if the customer is not an internal customer. |
Internal Customer check box on the Options tab in Customer Maintenance |
15200 |
Generate-coop-dollars |
3 |
YES/NO |
Enter YES if you want to allow the customer to accumulate co-op amounts. If you enter YES, each time a co-op product is ordered, the monetary amounts assessed on that product are accumulated for the customer. Enter NO if you do not want to allow the customer to accumulate co-op amounts. |
Generate Co-Op Amounts check box on the Options tab in Customer Maintenance |
15300 |
Ship-label-pick-demand |
3 |
YES/NO |
Enter one of the following options to indicate whether to create packages for the customer during pick demand creation in Pick Demand Create and Print if you use package units of measure:
|
Create Default Packages at Pick Demand Create radio set on the Options tab in Customer Maintenance |
15400 |
Use-pallet-ship-labels |
3 |
YES/NO |
Enter YES if you want the wireless pick program to print pallet labels for this customer during picking based on your zone task options. Enter NO if you do not want to print pallet labels. |
Use Pallet Shipping Labels check box on the Options tab in Customer Maintenance |
15500 |
Consolidated-pick-ticks |
3 |
YES/NO |
Enter YES if you want to allow the customer to elect to have multiple sales orders (with similar criteria, such as shipping address, payment terms, etc.) consolidated onto one pick demand for picking efficiency and shipping cost optimization. For more information, see Pick Demand Logic FAQ. Enter NO if you do not want to consolidate pick demands for the customer. |
Generate Consolidated Pick Demands check box on the Options tab in Customer Maintenance |
15600 |
AR-gl-acct |
29 |
Character |
Enter a valid accounts receivable general ledger account for the customer. |
A/R field on the A/R tab in Customer Maintenance |
15700 |
AR-writeoff-acct |
29 |
Character |
Enter a valid accounts receivable write-off account for the customer. This account is used when an accounts receivable transaction is written off in Payment Apply or Open Item Apply and Resolve. |
A/R Write off Mask field on the A/R tab in Customer Maintenance |
15800 |
Cash-discount-acct |
29 |
Character |
Enter a valid cash discount general ledger account for the customer. |
Cash Discount Mask field on the A/R tab in Customer Maintenance |
15900 |
User-def-1 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
First customer user-defined field on the Other Customer Information tab in Customer Maintenance |
16000 |
User-def-2 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Second customer user-defined field on the Other Customer Information tab in Customer Maintenance |
16100 |
User-def-3 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Third customer user-defined field on the Other Customer Information tab in Customer Maintenance |
16200 |
User-def-4 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Fourth customer user-defined field on the Other Customer Information tab in Customer Maintenance |
16300 |
User-def-5 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Fifth customer user-defined field on the Other Customer Information tab in Customer Maintenance |
16400 |
User-def-6 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Sixth customer user-defined field on the Other Customer Information tab in Customer Maintenance |
16500 |
User-def-7 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Seventh customer user-defined field on the Other Customer Information tab in Customer Maintenance |
16600 |
User-def-8 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Eighth customer user-defined field on the Other Customer Information tab in Customer Maintenance |
16700 |
User-def-9 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Ninth customer user-defined field on the Other Customer Information tab in Customer Maintenance |
16800 |
User-def-10 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Tenth customer user-defined field on the Other Customer Information tab in Customer Maintenance |
16900 |
Default-Trade-id |
25 |
Character |
Enter a valid default EDI trade ID if you are using EDI for this customer. If you import a blank record for this field, no trade ID is set to be the default for the customer. For information on setting up EDI trading partners, see EDI Trading Partner Maintenance. |
Default column in the EDI Trading Partners grid on the Groups tab in Customer Maintenance |
17000 |
Store-id |
20 |
Character |
Enter the store location code used by this EDI trading partner to uniquely identify this location. Note You cannot use the same store ID more than once for the same EDI trading partner. |
Store ID field on the Groups tab in Customer Maintenance |
17100 |
Region-id |
12 |
Character |
Enter a valid point of sale region ID to which the customer belongs for DRP product forecasting. For information on setting up regions, see Point of Sale Region Maintenance. |
Point of Sale Region ID field on the Groups tab in Customer Maintenance |
17200 |
Related-supplier |
15 |
Character |
Enter a valid related supplier code if the customer is also a supplier. By associating a supplier with a customer, you can make invoices for the supplier for supplier allowances. For more information, see Using Supplier Allowances. For information on setting up suppliers, see Supplier Maintenance. |
Related Supplier Code field on the A/R tab in Customer Maintenance |
17300 |
Web-site |
60 |
Character |
Enter the address of the customer's Website. |
Website field on the Main tab in Customer Maintenance |
17400 |
language |
8 |
Character |
Enter the primary language spoken by the customer. |
Language field on the Main tab in Customer Maintenance |
17500 |
history-id |
12 |
Character |
Enter a valid customer code to use for sales history purposes. |
History Customer Code field on the Sales tab in Customer Maintenance |
17600 |
shipping-method |
6 |
Character |
Enter one of the following shipping methods: Air or Ground. |
Shipping Method field on the Options tab in Customer Maintenance |
17650 |
Process-211 |
3 |
YES/NO |
Enter YES if the customer processes EDI bills of lading. A bill of lading is sent if the customer and shipper both process EDI bills of lading. Enter NO if the customer does not process EDI bills of lading. |
Process EDI Bills of Lading check box on the Options tab in Customer Maintenance |
|
|
|
|
|
|
Bill-to Address Fields
|
|
|
|
|
|
18300 |
Billto-name |
40 |
Character |
Enter the name of the customer's bill-to address. |
Name field on the Bill-To tab in Customer Maintenance |
18400 |
Billto-country |
10 |
Character |
Enter a valid country for the bill-to address. The country controls the format and/or validation of the postal code, the format of the phone fields, and the label for the State/Province field. For information on setting up countries, see Country Maintenance. |
Country field on the Bill-To tab in Customer Maintenance |
18500 |
Billto-address-1 |
60 |
Character |
Enter the first line of the bill-to street address. |
Address 1 field on the Bill-To tab in Customer Maintenance |
18600 |
Billto-address-2 |
60 |
Character |
Enter the second line of the bill-to street address. |
Address 2 field on the Bill-To tab in Customer Maintenance |
18700 |
Billto-address-3 |
60 |
Character |
Enter the third line of the bill-to street address. |
Address 3 field on the Bill-To tab in Customer Maintenance |
18800 |
Billto-postal-code |
10 |
Character |
Enter the postal code of the bill-to address. The format of the postal code is set up for the country in Country Maintenance, and can optionally be set up to be validated. For information on setting up postal codes, see Postal Code Maintenance. |
Postal Code field on the Bill-To tab in Customer Maintenance |
19000 |
Billto-county |
36 |
Character |
Enter the county associated with the bill-to address. |
County field on the Bill-To tab in Customer Maintenance |
19100 |
Billto-state |
3 |
Character |
Enter a valid state or province for the bill-to address. |
State or Province field on the Bill-To tab in Customer Maintenance |
19200 |
Billto-phone |
16 |
Character |
Enter the phone number of the bill-to address. The format of the phone number is set up in Country Maintenance. |
Phone field on the Bill-To tab in Customer Maintenance |
19300 |
Billto-fax |
16 |
Character |
Enter the fax number of the bill-to address. |
Fax # field on the Bill-To tab in Customer Maintenance |
19400 |
Billto-email |
60 |
Character |
Enter the main email address for the bill-to address. |
Email field on the Bill-To tab in Customer Maintenance |
19500 |
Billto-attention |
36 |
Character |
Enter the main contact of the customer who should receive invoices for the bill-to address. |
Attention field on the Bill-To tab in Customer Maintenance |
19600 |
Billto-edi-addr-code |
30 |
Character |
Enter the EDI billing address code supplied by the customer on an EDI 850 transaction (incoming purchase order). |
EDI Address Code field on the Bill-To tab in Customer Maintenance |
19700 |
Billto-Primary |
3 |
YES/NO |
Enter YES if the bill-to address is the main bill-to address for the customer that will be the default for sales order entry. There can only be one bill-to address marked as the primary bill-to address for each customer. Enter NO if the bill-to address is not the mail bill-to address for the customer. |
Primary Bill-To check box on the Bill-To tab in Customer Maintenance |
19800 |
Billto-active |
3 |
YES/NO |
Enter YES if the bill-to address is active and you want it to be available in Lookup windows and during sales order entry. Enter NO if the bill-to address is not active. |
Active check box on the Bill-To tab in Customer Maintenance |
19900 |
Billto-City |
40 |
Character |
Enter the city of the bill-to address. For information on setting up cities, see Postal Code Maintenance. |
City field on the Bill-To tab in Customer Maintenance |
|
|
|
|
|
|
Ship-to Address Fields
|
|
|
|
|
|
20600 |
Shipto-name |
40 |
Character |
Enter the name of the customer's ship-to address. |
Name field on the Ship-To tab in Customer Maintenance |
20700 |
Shipto-edi-addr-code |
30 |
Character |
Enter the EDI shipping address code supplied by the customer on an EDI 850 transaction (incoming purchase order). |
EDI Address Code field on the Ship-To tab in Customer Maintenance |
20750 |
freight-collection |
25 |
Character |
Enter the default freight collection terms code for the customer ship-to address. This overrides the default freight collection terms code for the customer. For information on setting up freight collection terms codes, see Freight Collection Terms Maintenance. |
Freight Collection field on the Ship-To tab in Customer Maintenance |
20800 |
Shipto-country |
10 |
Character |
Enter a valid country for the ship-to address. The country controls the format and/or validation of the postal code, the format of the phone fields, and the label for the State/Province field. For information on setting up countries, see Country Maintenance. |
Country field on the Ship-To tab in Customer Maintenance |
20900 |
Shipto-address-1 |
60 |
Character |
Enter the first line of the ship-to street address. |
Address 1 field on the Ship-To tab in Customer Maintenance |
21000 |
Shipto-address-2 |
60 |
Character |
Enter the second line of the ship-to street address. |
Address 2 field on the Ship-To tab in Customer Maintenance |
21100 |
Shipto-address-3 |
60 |
Character |
Enter the third line of the ship-to street address. |
Address 3 field on the Ship-To tab in Customer Maintenance |
21200 |
Shipto-postal-code |
10 |
Character |
Enter the postal code of the ship-to address. The format of the postal code is set up for the country in Country Maintenance, and can optionally be set up to be validated. For information on setting up postal codes, see Postal Code Maintenance. |
Postal Code field on the Ship-To tab in Customer Maintenance |
21400 |
Shipto-county |
36 |
Character |
Enter the county associated with the ship-to address. |
County field on the Ship-To tab in Customer Maintenance |
21500 |
Shipto-state |
3 |
Character |
Enter a valid state or province of the ship-to address. |
State or Province field on the Ship-To tab in Customer Maintenance |
21600 |
Shipto-phone |
16 |
Character |
Enter the telephone number of the ship-to address. The format of the telephone number is set up in Country Maintenance. |
Telephone field on the Ship-To tab in Customer Maintenance |
21700 |
Shipto-fax |
16 |
Character |
Enter the fax number of the ship-to address. |
Fax field on the Ship-To tab in Customer Maintenance |
21800 |
Shipto-emergency-phone |
16 |
Character |
Enter the emergency telephone number for the ship-to address. The format of the telephone number is set up in Country Maintenance. |
Emerg. Phone field on the Ship-To tab in Customer Maintenance |
21900 |
Shipto-email |
60 |
Character |
Enter the main email address for the ship-to address. |
Email field on the Ship-To tab in Customer Maintenance |
22000 |
Shipto-related-billto |
8 |
Character |
Enter a valid related bill-to address ID. Use this field if a ship-to address needs to be associated with a specific bill-to address. |
Related Bill-To field on the Ship-To tab in Customer Maintenance |
22100 |
Shipto-store-id |
20 |
Character |
Enter the store ID for the ship-to address. |
Store ID field on the Ship-To tab in Customer Maintenance |
22200 |
Shipto-attention |
36 |
Character |
Enter the main contact of the customer who should receive invoices for the ship-to address. |
Attention field on the Ship-To tab in Customer Maintenance |
22300 |
Shipto-primary-shipper |
3 |
YES/NO |
Enter YES if the ship-to address is the main ship-to address for the customer that will be the default for sales order entry. There can only be one ship-to address marked as the primary ship-to address for each customer. Enter NO if the ship-to address is not the main ship-to address for the customer. |
Primary Ship-to check box on the Ship-To tab in Customer Maintenance |
22400 |
Shipto-active |
3 |
YES/NO |
Enter YES if the ship-to address is active and you want it to be available in Lookup windows and during sales order entry. Enter NO if the ship-to address is not active. |
Active check box on the Ship-To tab in Customer Maintenance |
22500 |
Shipto-shipper |
12 |
Character |
Enter a valid preferred shipper ID for the ship-to address. |
Shipper ID field on the Ship-To tab in Customer Maintenance |
22600 |
Shipto-fleet-shipper |
|
Character |
This field is not used. |
|
22700 |
Shipto-shipping-mode |
8 |
Character |
Enter the shipping mode for the ship-to address if you are using an external shipping interface. Example R is the residential code for the UPS shipping interface. |
Shipping Mode field on the Ship-To tab in Customer Maintenance |
22800 |
Shipto-shipping-acct-id |
12 |
Character |
Enter the ship-to address account number to charge for delivery if you are using an external shipping interface. |
Shipping Account ID field on the Ship-To tab in Customer Maintenance |
22900 |
Shipto-geo-lat |
14 |
->>>>>>>9.9999 |
Enter the latitude of the ship-to address if you are using an external delivery logistics interface. |
Latitude field on the Ship-To tab in Customer Maintenance |
23000 |
Shipto-geo-long |
14 |
->>>>>>>9.9999 |
Enter the longitude of the ship-to address if you are using an external delivery logistics interface. |
Longitude field on the Ship-To tab in Customer Maintenance |
23100 |
Shipto-fob |
12 |
Character |
Enter a valid default FOB (Freight On Board) used during sales order entry. |
FOB field on the Ship-To tab in Customer Maintenance |
23200 |
Shipto-tax-jurisdiction |
12 |
Character |
Enter a valid tax jurisdiction for the customer’s ship-to address. You can enter None if the customer is not charged tax. NOTE If the system is integrated with AvaTax, leave this field blank. The system automatically sets the value for this field as None. |
Tax Jurisdiction field on the Ship-To tab in Customer Maintenance |
23300 |
Shipto-forecast-region |
20 |
Character |
Enter the forecast region ID to which this customer ship-to address belongs for DRP product forecasting. For information on setting up regions, see Point of Sale Region Maintenance. |
Region ID field on the Ship-To tab in Customer Maintenance |
23400 |
Shipto-city |
40 |
Character |
Enter the city of the ship-to address. For information on setting up cities, see Postal Code Maintenance. |
City field on the Ship-To tab in Customer Maintenance |
23500 |
shipto-tax-exempt |
3 |
Yes/No |
Enter Yes if the customer's ship-to address is tax exempt. If you enter Yes and the internal tax functionality is used, then shipto-state-tax-exempt number and shipto-country-tax-exempt number are required. If you enter Yes and the AvaTax interface is used, either shipto-state-tax-exempt number or shipto-entity-use-code is required. |
Tax Exempt check box on the Ship-To tab in Customer Maintenance |
23600 |
shipto-state-tax-exempt |
20 |
Character |
Conditional; see the shipto-tax-exempt field. |
State Tax Exempt # field on the Ship-To tab in Customer Maintenance |
23700 |
shipto-country-tax-exempt |
20 |
Character |
If the customer ship-to address is always exempt from tax for the country for all products shipped to it, enter the customer’s country tax exemption number. This field is informational-only, and is only enabled if you select the Tax Exempt check box. This field does not apply to AvaTax interface. |
Country Tax Exempt # field on the Ship-To tab in Customer Maintenance |
24350 |
shipto-excise-id |
30 |
Character |
Enter the excise tax ID for the customer's ship-to address if the address is a tax warehouse. |
Excise ID field on the Ship-To tab in Customer Maintenance |
|
|
|
|
|
|
24400 |
Sales-user-def-1 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
First market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
24500 |
Sales-user-def-2 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Second market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
24600 |
Sales-user-def-3 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Third market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
24700 |
Sales-user-def-4 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Fourth market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
24800 |
Sales-user-def-5 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Fifth market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
24900 |
Sales-user-def-6 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Sixth market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
25000 |
Sales-user-def-7 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Seventh market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
25100 |
Sales-user-def-8 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Eighth market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
25200 |
Sales-user-def-9 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Ninth market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
25300 |
Sales-user-def-10 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Tenth market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
|
|
|
|
|
|
25400 |
Billing-cust |
12 |
Character |
Enter a valid billing customer code to use for accounts receivable collection and chargeback resolution. |
Billing Customer Code field on the A/R tab in Customer Maintenance |
25450 |
pay-for-other |
3 |
YES/NO |
Enter YES if the customer also remits payments for unrelated customers (e.g., UPS). Enter NO if the customer does not remit payments for unrelated customers. |
Pays for Other Customers check box on the Main tab in Customer Maintenance |
25500 |
Credit-cust |
12 |
Character |
Enter a valid customer to use for accounts receivable credit management. |
Credit Customer Code field on the A/R tab in Customer Maintenance |
25600 |
Paying-cust |
12 |
Character |
Enter a valid customer to use for payments. |
Paying Customer Code field on the A/R tab in Customer Maintenance |
25700 |
Payment-method |
11 |
Character |
Enter the default method of payment for the customer. Enter one of the following:
|
Payment Method field on the A/R tab in Customer Maintenance |
25800 |
AR-absorption-acct |
29 |
Character |
Enter a valid general ledger accounts receivable absorption account number. Only use this field if the customer needs an override accounts receivable absorption general ledger number different from the system default. If entered, the general ledger account must be a general ledger category of A/R Absorption. For information on setting up general ledger accounts, see Account Maintenance. |
A/R Absorption field on the A/R tab in Customer Maintenance |
25900 |
AR-clearing-acct |
29 |
Character |
Enter a valid general ledger accounts receivable clearing account number. Only use this field if the customer needs an override accounts receivable clearing general ledger account number different from the system one. If entered, the general ledger account must be a general ledger category of accounts receivable clearing. For information on setting up general ledger accounts, see Account Maintenance. |
A/R Clearing field on the A/R tab in Customer Maintenance |
26000 |
Payment-chbk-team |
12 |
Character |
Enter a valid chargeback team for the customer. If the billing customer is different from the customer, the billing customer’s chargeback team is used. For more information, see Chargeback Team Maintenance. |
Payment/Chargeback Team field on the A/R tab in Customer Maintenance |
26100 |
Collection-team |
12 |
Character |
Enter a valid collection team. If the billing customer is different from the customer, the billing customer’s collection team is used. For more information, see Collection Team Maintenance. |
Collection Team field on the A/R tab in Customer Maintenance |
26200 |
Credit-team |
12 |
Character |
Enter a valid credit team. If the billing customer is different from the customer, the billing customer’s credit team is used. For more information, see Credit Team Maintenance. |
Credit Team field on the A/R tab in Customer Maintenance |
26300 |
payment-chbk-grouping |
8 |
Character |
Enter one of the following to determine whether the customer will follow the default rules for its chargeback group or division.
|
Payment/Chargeback Default Grouping field on the A/R tab in Customer Maintenance |
26400 |
Chbk-payment-group |
12 |
Character |
Enter a valid chargeback group for the customer. |
Payment/Chargeback Group field on the A/R tab in Customer Maintenance |
26500 |
Collection-group |
12 |
Character |
Enter a valid collection statement group for the customer. For more information on collection statement groups, see Collection Statement Group Maintenance. |
Collection Group field on the A/R tab in Customer Maintenance |
26600 |
Credit-group |
12 |
Character |
Enter a valid credit group for the customer. If the billing customer is different from the customer, the billing customer’s credit group is used. For more information, see Customer Credit Rule Maintenance. |
Credit Group field on the A/R tab in Customer Maintenance |
26700 |
Collection-statement |
12 |
Character |
Enter a valid collection statement group for the customer. For more information on collection statement groups, see Collection Statement Group Maintenance. |
Collection Statement field on the A/R tab in Customer Maintenance |
26800 |
Collection-letter |
12 |
Character |
Enter a valid collection letter group for the customer. For more information on collection letter groups, see Collection Letter Group Maintenance. |
Collection Letter field on the A/R tab in Customer Maintenance |
26900 |
Finance-charge |
12 |
Character |
Enter a valid finance charge group for the customer. For more information on finance charge groups, see Finance Charge Group Maintenance. |
Finance Charge field on the A/R tab in Customer Maintenance |
27000 |
Chargeback-division |
12 |
Character |
Enter a valid chargeback division for the customer. If the billing customer is different from the customer, the billing customer’s chargeback division is used. For more information, see Customer Payment Rule Maintenance. |
Payment/Chargeback Division field on the A/R tab in Customer Maintenance |
27100 |
Collection-division |
12 |
Character |
Enter a valid collection division for the customer. If the billing customer is different from the customer, the billing customer’s collection division is used. For more information, see Customer Collection Rule Maintenance. |
Collection Division field on the A/R tab in Customer Maintenance |
27200 |
Credit-division |
12 |
Character |
Enter a valid credit division for the customer. If the billing customer is different from the customer, the billing customer’s credit division is used. For more information, see Customer Credit Rule Maintenance. |
Credit Division field on the A/R tab in Customer Maintenance |
27300 |
Collection-grouping |
8 |
Character |
Enter one of the following to determine whether the customer will follow the default rules for its collection group or division.
|
Collection Default Grouping field on the A/R tab in Customer Maintenance |
27400 |
Credit-grouping |
8 |
Character |
Enter one of the following to determine whether the customer will follow the default rules for its credit group or division.
|
Credit Default Grouping field on the A/R tab in Customer Maintenance |
27450 |
Credit Score |
10 |
->>,>>9.99 |
Enter the customer's actual credit score. A history of changes to the actual credit score is maintained for audit purposes. |
Actual Credit Score field on the Key Rules tab in Customer Credit Rule Maintenance |
28000 |
sales-division |
12 |
Character |
Enter a valid customer division for the customer. This data is used to group customers together for EIS and other inquiries. For more information, see Customer Division Maintenance. |
Customer Division field on the Sales tab in Customer Maintenance |
28100 |
user-def-11 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Eleventh customer user-defined field on the Other Customer Information tab in Customer Maintenance |
28200 |
user-def-12 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Twelfth customer user-defined field on the Other Customer Information tab in Customer Maintenance |
28300 |
user-def-13 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Thirteenth customer user-defined field on the Other Customer Information tab in Customer Maintenance |
28400 |
user-def-14 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Fourteenth customer user-defined field on the Other Customer Information tab in Customer Maintenance |
28500 |
user-def-15 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Fifteenth customer user-defined field on the Other Customer Information tab in Customer Maintenance |
28600 |
user-def-16 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Sixteenth customer user-defined field on the Other Customer Information tab in Customer Maintenance |
28700 |
user-def-17 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Seventeenth customer user-defined field on the Other Customer Information tab in Customer Maintenance |
28800 |
user-def-18 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Eighteenth customer user-defined field on the Other Customer Information tab in Customer Maintenance |
28900 |
user-def-19 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Nineteenth customer user-defined field on the Other Customer Information tab in Customer Maintenance |
29000 |
user-def-20 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
Twentieth customer user-defined field on the Other Customer Information tab in Customer Maintenance |
29100 |
mixed-cartons |
3 |
YES/NO |
Enter YES to allow cartons to contain different products when packing for the customer. |
Allow Mixed Cartons check box on the Options tab in Customer Maintenance |
29200 |
no-cartonization |
3 |
YES/NO |
Enter Yes to not perform cartonization when packing for the customer. |
No Cartonization check box on the Options tab in Customer Maintenance |
29300 |
no-banding |
3 |
YES/NO |
Enter Yes to not perform banding when packing for the customer. |
No Banding check box on the Options tab in Customer Maintenance |
29400 |
bookings-group |
12 |
Character |
Enter the bookings group for the customer. For information on setting up bookings groups, see Bookings Group Maintenance. |
Bookings Group field on the Sales tab in Customer Maintenance |
29500 |
relabel-option |
15 |
Character |
Enter one of the following:
|
Label Reprint Option field on the Options tab in Customer Maintenance |
29600 |
marketing-person1 |
12 |
Character |
Enter the primary marketing representative responsible for the customer. |
Marketing Representative 1 field on the Sales tab in Customer Maintenance |
29700 |
marketing-person2 |
12 |
Character |
Enter a secondary marketing representative responsible for the customer. |
Marketing Representative 2 field on the Sales tab in Customer Maintenance |
29800 |
profit-group |
12 |
Character |
Enter the scorecard profit group code for the customer. This field is only used for billing customers. For information on setting up scorecard profit group codes, see Scorecard Profit Group Maintenance. |
Profit Group Code field on the Groups tab in Customer Maintenance |
29900 |
skip-856 |
3 |
YES/NO |
Enter YES if you do not want to send EDI ASN's for the customer even if the trading partner associated with the customer is set up to send EDI ASN's. |
Do Not Send EDI ASN check box on the Groups tab in Customer Maintenance |
30000 |
cust-mfg |
10 |
Character |
Enter a ten-digit manufacturing number for the customer. This number is used as a prefix for the UCC128 and SGTIN numbers for the customer's packages. Note If you enter less than ten digits, the number is automatically prefixed with zeros. |
Customer MFG# field on the Main tab in Customer Maintenance |
30100 |
cust-service-team |
20 |
Character |
Enter the customer service team for the customer. For information on setting up customer service teams, see Customer Service Team Maintenance. |
Customer Service Team field on the Groups tab in Customer Maintenance |
30200 |
output-vat-mask |
29 |
Character |
Enter all or part of the output VAT general ledger account to use when resolving the account from the customer. For more information on output VAT accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the customer. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. |
Output VAT field on the Sales tab in Customer Maintenance |
30300 |
output-vat-variance-mask |
29 |
Character |
Enter all or part of the output VAT variance general ledger account to use when resolving the account from the customer. For more information on output VAT variance accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the customer. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. |
Output VAT Variance field on the Sales tab in Customer Maintenance |
30400 |
cust-vat-id |
30 |
Character |
Enter the customer's tax identification number for VAT. Example For an Australian customer, enter the customer's Australian Business Number (ABN). |
Customer VAT ID field on the Sales tab in Customer Maintenance |
30500 |
shipto-vat-id |
30 |
Character |
Enter a VAT identification number for the customer's ship-to address. |
Customer VAT ID field on the Ship-To tab in Customer Maintenance |
30600 |
vat-exempt |
3 |
YES/NO |
Enter Yes or Y if the customer's ship-to address is VAT exempt. Enter No or N if the customer's ship-to address is not VAT exempt. |
VAT Exempt check box on the Ship-To tab in Customer Maintenance |
30700 |
vat-reason-code |
20 |
Character |
If the customer's ship-to address is exempt from VAT, enter a VAT exempt reason code to explain why it is exempt from VAT. For information on setting up VAT exempt reason codes, see VAT Exempt Reason Maintenance. |
VAT Exempt Reason Code field on the Ship-To tab in Customer Maintenance |
30800 |
ordimp-price-include-vat |
7 |
Character |
Enter one of the following values:
Note This setting is only a default. You can override this setting in the order import file. If you select Yes or No, this setting overrides the setting for the EDI trading partner. |
Order Import Price Includes VAT radio set on the Sales tab in Customer Maintenance |
30900 |
cf-cust-group-code |
20 |
Character |
Enter the cash flow customer group for the customer. The cash flow customer group controls the rules for how and when cash is received from the customer. If this field is blank, the customer is assigned to the default cash flow customer group. For information on setting up cash flow customer groups, see Cash Flow Customer Group Maintenance. |
Cash Flow Group Code field on the Groups tab in Customer Maintenance |
31000 |
ar-credit-payment-terms |
12 |
Character |
Enter a valid payment terms code to use by default for the customer's orders. For more information on setting up payment terms codes, see Payment Terms Maintenance. |
Standard Payment Terms field on the Payment Terms tab in Customer Credit Rule Maintenance |
31100 |
Sales-user-def-11 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Eleventh market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
31200 |
Sales-user-def-12 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Twelfth market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
31300 |
Sales-user-def-13 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Thirteenth market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
31400 |
Sales-user-def-14 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Fourteenth market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
31500 |
Sales-user-def-15 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Fifteenth market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
31600 |
Sales-user-def-16 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Sixteenth market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
31700 |
Sales-user-def-17 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Seventeenth market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
31800 |
Sales-user-def-18 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Eighteenth market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
31900 |
Sales-user-def-19 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Nineteenth market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
32000 |
Sales-user-def-20 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter any user-defined market segment information for the customer. The labels, formats, and validations are set up in User Defined Fields Maintenance. |
Twentieth market segment user-defined field on the Other Marketing Information tab in Customer Maintenance |
32100 |
beverage-type |
1 |
Character |
If the customer is a beverage customer, enter one of the following 1-digit values to indicate a beverage type by which to classify the customer:
|
Beverage Type field on the Options tab in Customer Maintenance |
32200 |
license-wine |
3 |
Yes/No |
Enter Yes if the customer is licensed to sell wine. |
Wine check box on the Options tab in Customer Maintenance |
32300 |
license-spirits |
3 |
Yes/No |
Enter Yes if the customer is licensed to sell spirits. |
Spirits check box on the Options tab in Customer Maintenance |
32400 |
license-beer |
3 |
Yes/No |
Enter Yes if the customer is licensed to sell beer. |
Beer check box on the Options tab in Customer Maintenance |
32500 |
use-billing |
3 |
Yes/No |
Enter Yes if you want to default the bill-to address information from the related billing customer code's primary bill-to address during sales order entry for the customer. |
Use Billing Customer Code Address Information check box on the Bill-To tab in Customer Maintenance |
32600 |
royal-book |
12 |
Character |
Enter the royalty book name for the customer. For information on setting up royalty books, see Royalty Book Maintenance. |
Royalty Book Name field on the Options tab in Customer Maintenance |
32700 |
samp-sale-rep |
12 |
Character |
Enter a valid sales representative ID if the customer is a sales representative who will be associated with sample orders. |
Sample Sales Representative ID field on the Options tab in Customer Maintenance |
32800 |
ignore-min-mult |
3 |
Yes/No |
Enter Yes or Y if you want minimum and multiple order and allocation quantities to be ignored for products ordered by the customer. If this field is blank, it defaults to No. |
Ignore Minimum/Multiple check box on the Options tab in Customer Maintenance |
32900 |
invoice-form |
50 |
Character |
Enter a valid Crystal Reports form (including the .rpt file extension) to use for the customer's invoices. Note If this is entered for a customer and its associated billing customer, the form for the customer is used. |
Invoice Form Name field on the Sales tab in Customer Maintenance |
33000 |
pack-list-form |
50 |
Character |
Enter a valid Crystal Reports form (including the .rpt file extension) to use for the customer's pack lists (packing slips). |
Pack List Form Name field on the Sales tab in Customer Maintenance |
33100 |
accrual-group-code |
12 |
Character |
Enter the customer allowance group for the customer. For information on setting up customer allowance groups, see Customer Allowance Group Maintenance. |
Customer Allowance Group field on the Groups tab in Customer Maintenance |
33200 |
add-trade-id |
25 |
Character |
Enter a valid EDI trade ID if you want to associate a trading partner with the customer. This trading partner is set as the default for the customer if the customer does not have a default trading partner. For information on setting up EDI trading partners, see EDI Trading Partner Maintenance. |
EDI Trading Partners grid on the Groups tab in Customer Maintenance |
33300 |
remove-trade-id |
25 |
Character |
Enter a valid EDI trade ID if you want to remove the association between a trading partner and the customer. For information on setting up EDI trading partners, see EDI Trading Partner Maintenance. |
EDI Trading Partners grid on the Groups tab in Customer Maintenance |
33400 |
ship-to-ship-location |
3 |
Character |
Enter a valid default shipping location prefix for the customer's orders for the ship-to address. This default shipping location overrides the default shipping location for the customer. Note This default is only used if the Shipping or Both radio button is selected for the Use Customer Location for option in Accounts Receivable Control Maintenance. For information on setting up shipping locations, see Location Maintenance. |
Shipping Location field on the Ship-To tab in Customer Maintenance |
33500 |
ship-to-sales-location |
3 |
Character |
Enter a valid default sales location prefix for the customer's orders for the ship-to address. This default sales location overrides the default sales location for the customer. Note This default is only used if the Sales or Both radio button is selected for the Use Customer Location for option in Accounts Receivable Control Maintenance. For information on setting up sales locations, see Location Maintenance. |
Sales Location field on the Ship-To tab in Customer Maintenance |
33600 |
ship-to-sales-rep-1 |
12 |
Character |
Enter a valid default primary sales representative for the customer's orders for the ship-to address. This default sales representative overrides the default primary sales representative for the customer. For information on setting up sales representatives, see Sales Representative Maintenance. |
Sales Rep 1 field on the Ship-To tab in Customer Maintenance |
33700 |
ship-to-sales-rep-2 |
12 |
Character |
Enter a valid default secondary sales representative for the customer's orders for the ship-to address. This default sales representative overrides the default secondary sales representative for the customer. For information on setting up sales representatives, see Sales Representative Maintenance. |
Sales Rep 2 field on the Ship-To tab in Customer Maintenance |
33800 |
approved-fin-trms |
3 |
Yes/No |
If you want to override the credit group or credit division Approved for Finance Payment Terms setting for the customer, enter Yes or No. Enter Yes if the customer is approved for finance terms, or No if the customer is not approved for finance terms. |
Approved for Finance Payment Terms check box on the Payment Terms tab in Customer Credit Rule Maintenance |
33900 |
dft-cash-acct |
29 |
Character |
Enter a valid default cash general ledger account for the customer's payments. The account must be a Cash category account. |
Default Cash Account field on the A/R tab in Customer Maintenance |
34000 |
order-ack-form |
50 |
Character |
Enter the Crystal Reports form to use for the customer's order acknowledgments. |
Order Acknowledgment Form Name field on the Sales tab in Customer Maintenance |
34100 |
sls-rsrv-group-code |
12 |
Character |
Enter a valid sales restriction group code for the customer. For information on setting up sales restriction groups, see Sales Restriction Group Maintenance. |
Sales Restriction Group Code field on the Groups tab in Customer Maintenance |
34200 |
save-cc-info |
3 |
Yes/No |
Enter Yes to allow users to save credit card information for the customer during order entry. Enter No to prevent users from saving credit card information for the customer during order entry. |
Allow Saved Credit Cards in OE check box on the Options tab in Customer Maintenance |
34300 |
open-order-warning |
3 |
Yes/No |
Enter Yes to display a warning message during order entry if an open order already exists for the customer, and to allow the user to review the open orders. |
Open Order Warning check box on the Options tab in Customer Maintenance |
34400 |
price-book-group |
12 |
Character |
Enter the price book group for the customer. The price book group is a customer grouping to use for price calculations. For information on setting up price book groups, see Price Book Group Maintenance. |
Price Book Group field on the Sales tab in Customer Maintenance |
34500 |
last-inv-date |
10 |
99/99/9999 |
Enter the date of the customer's last invoice. This date is updated when invoices are created for the customer. This date may be used to put orders on inactive customer hold. |
Last Invoice Date field on the Credit Dates tab in Customer Credit Rule Maintenance |
34600 |
This field is not used. Leave this field blank. | ||||
34700 |
vat-group-code |
20 |
Character |
Enter a VAT group code for the customer. For information on setting up VAT groups, see VAT Group Maintenance. |
VAT Group Code field on the Sales tab in Customer Maintenance |
34800 |
shipto-vat-group-code |
20 |
Character |
Enter a VAT group code for the customer's primary ship-to address. For information on setting up VAT groups, see VAT Group Maintenance. |
VAT Group Code field on the Ship-To tab in Customer Maintenance |
34900 |
save-tgl-ignore-fut-alloc |
3 |
Yes/No |
Enter Yes to immediately allocate inventory for the customer's orders instead of creating future allocations. You cannot enter Yes for this field if open orders exist for the customer's billing customer. Enter No if the customer's orders can have future allocations. |
Ignore Future Allocations check box on the Options tab in Customer Maintenance |
35000 |
freight-cap-pct |
6 |
>>9.99 |
Enter the freight cap percentage for the customer. If the calculated freight for a sales order exceeds this percentage of the order or shipment total, the freight is set equal to the calculated amount for this percentage. Example You enter 10 in this field for customer A. A sales order is created for customer A for $100. The freight is calculated for the order as $12. However, this is greater than 10 percent of $100 ($10), so the freight for the order is limited to $10. This percentage is the default for the customer's orders, but can be overridden for a specific order. |
Freight Cap % field on the Sales tab in Customer Maintenance |
35100 |
create-ds-po |
3 |
Yes/No |
Enter Yes to automatically create drop-ship purchase orders for the customer. Enter No to not automatically create drop-ship purchase orders for the customer. |
Auto Create Drop Ship POs check box on the Groups tab in Customer Maintenance |
35200 |
create-ship-cnt |
3 |
Yes/No |
Enter Yes to automatically create shipments and containers for the customer's drop-ship purchase orders. Enter No to not automatically create shipments and containers for the customer's drop-ship purchase orders. |
Auto Create Shipment & Container check box on the Groups tab in Customer Maintenance |
35300 |
exe-bvgtax |
3 |
Yes/No |
Enter Yes if the customer is exempt from excise taxes set up for excise tax categories. Enter No if the customer is not exempt from excise taxes. |
Exempt from Excise Tax check box on the Sales tab in Customer Maintenance |
35400 |
imp-dup-po-num |
3 |
Yes/No |
Enter Yes to allow duplicate purchase order numbers when importing orders for the customer in Order Import or EDI Order Import. Enter No to prevent duplicate purchase order numbers from being imported for the customer's orders. |
Import Duplicate PO Number check box on the Options tab in Customer Maintenance |
35500 |
dflt-element-update |
|
Character |
If you are using Worldpay for credit card processing, enter the following information to update the credit card information for the customer bill-to address default credit card with each value separated by a | character:
Example 1234567890|12|2020|Customer |
Fields in Credit Card Number Entry |
35600 |
dflt-element-create |
|
Character |
If you are using Worldpay for credit card processing, enter the following credit card information for the customer bill-to address default credit card with each value separated by a | character:
Example 5555|1234567890|VISA|12|2020|Customer |
Fields in Credit Card Number Entry |
35700 |
allow-companion-products |
3 |
Yes/No |
Enter Yes to allow the customer to receive companion products. Enter No to prevent the customer from receiving companion products. For information on setting up companion products, see Companion Product Maintenance. |
Allow Companion Products check box on the Options tab in Customer Maintenance |
35800 |
add-restrict-beverage-tax-category |
20 |
Character |
Enter a valid excise tax category for which the customer is not allowed to receive companion products. |
Excise Tax Category Companion Product Restrictions grid on the Options tab in Customer Maintenance |
35900 |
remove-restrict-beverage-tax-category |
20 |
Character |
Enter a valid excise tax category for which the customer was previously not allowed to receive companion products, but for which you want to allow the customer to receive companion products. |
Excise Tax Category Companion Product Restrictions grid on the Options tab in Customer Maintenance |
36000 |
no-delivery-days |
49 |
Character |
Enter the days of the week the customer does not accept deliveries at the ship-to address. Separate each day of the week with the following delimiter character: | EXAMPLE Saturday|Sunday |
Check boxes in the No Delivery Days section in Fleet Delivery Stop Maintenance |
36100 |
ship-opt-group |
20 |
Character |
Enter a customer shipping options group for the customer. For information on setting up customer shipping options groups, see Customer Shipping Options Group Maintenance. |
Shipping Options Group field on the Groups tab in Customer Maintenance |
36200 |
print-pack-list |
3 |
Yes/No |
Enter Yes to automatically print pack lists for the customer when confirming pick demands for a location set up to print pack lists. Enter No to not automatically print pack lists for the customer when confirming pick demands for a location set up to print pack lists. |
Print Pack List check box on the Options tab in Customer Maintenance |
36300 |
Credit-limit |
>>>,>>>,>>9.99 |
Decimal |
Enter the amount of the credit limit authorized for the customer. This field is only used for credit customers. |
Credit Limit field on the Key Rules tab in Customer Credit Rule Maintenance |
36400 |
cust-freight-collection-terms |
20 |
Character |
Enter the default freight collection terms code for the customer's orders. This can be overridden by the freight collection terms for the customer's ship-to address. For information on setting up freight collection terms codes, see Freight Collection Terms Maintenance. |
Freight Collection field on the Options tab in Customer Maintenance |
36500 |
default-required-date |
12 |
Character |
Enter one of the following values for calculating required dates for the customer:
|
Default Required Date field on the Sales tab in Customer Maintenance |
36600 |
required-days |
4 |
Character |
Enter a number of business days past the current date to use to calculate a default required date for the customer's sales orders. The required date can still be manually changed for orders. Note The required date will not use this default if the shipper selected for an order is a fleet delivery shipper with a defined route/stop for the customer. |
Days From Order Date field on the Sales tab in Customer Maintenance |
36700 |
required-date-days |
3 |
Integer |
Enter a positive or negative number of days that are automatically added to the required date for the customer's orders. If a value is entered for this field, the default required date days entered in Customer Service Control Maintenance is ignored. NOTE Users can be set up to ignore this option in User Profile Maintenance. |
Required Date Days radio set and field on the Sales tab in Customer Maintenance |
36800 |
Cust-consent-provided |
3 |
Yes/No
|
Enter Yes if the data subjects have provided consents to use their personal data. |
Consent Provided check box on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Main tab in Customer Maintenance. |
36900 |
Cust-consent-attached |
3 |
Yes/No |
Enter Yes if the data subjects' consents to use their personal data are attached using the standard attachment function in Customer Maintenance. |
Consent Attached check box on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Main tab in Customer Maintenance. |
37000 |
Cust-consent-date |
10 |
99/99/9999 |
Enter the date on which the data subjects, that is, the customers, provided the consents to use their personal data. |
Consent Date field on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Main tab in Customer Maintenance. |
37100 |
Shipto-consent-provided |
3 |
Yes/No |
Enter Yes if the data subjects have provided consents to use their personal data such as Ship-To addresses. |
Consent Provided check box on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Ship-To tab in Customer Maintenance. |
37200 |
Shipto-consent-attached |
3 |
Yes/No |
Enter Yes if the data subjects' consents to use their personal data are attached using the standard attachment function in Customer Maintenance. |
Consent Attached check box on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Ship-To tab in Customer Maintenance. |
37300 |
Shipto-consent-date |
10 |
99/99/9999 |
Enter the date on which the data subjects, that is, the customers, provided the consents to use their personal data such as Ship-To addresses. |
Consent Date field on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Ship-To tab in Customer Maintenance. |
37400 |
Billto-consent-provided |
3 |
Yes/No |
Enter Yes if the data subjects have provided consents to use their personal data such as Bill-To addresses. |
Consent Provided check box on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Bill-To tab in Customer Maintenance. |
37500 |
Billto-consent-attached |
10 |
99/99/9999 |
Enter Yes if the data subjects' consents to use their personal data, such as Bill-To addresses, are attached using the standard attachment function in Customer Maintenance. |
Consent Provided check box on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Bill-To tab in Customer Maintenance. |
37600 |
Billto-consent-date |
3 |
Yes/No |
Enter the date on which the data subjects, that is, the customers, provided the consents to use their personal data such as Bill-To addresses. |
Consent Provided check box on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Bill-To tab in Customer Maintenance. |
37700 |
skip-810 |
3 |
Yes/No |
Enter Yes if you do not want to send EDI invoices for the customer even if the trading partner associated with the customer is set up to send EDI invoices. |
Do Not Send EDI Invoice check box on the Groups tab in Customer Maintenance |
37800 |
skip-855 |
3 |
Yes/No |
Enter Yes if you do not want to send EDI order acknowledgments for the customer even if the trading partner associated with the customer is set up to send EDI order acknowledgments. |
Do Not Send EDI Order Acknowlegment check box on the Groups tab in Customer Maintenance |
37900 |
skip-870 |
3 |
Yes/No |
Enter Yes if you do not want to send EDI order statuses for the customer even if the trading partner associated with the customer is set up to send EDI order statuses. |
Do Not Send EDI Order Status check box on the Groups tab in Customer Maintenance |
38000 |
skip-856 |
3 |
Yes/No |
Enter Yes if you do not want to send EDI ASN's for the customer even if the trading partner associated with the customer is set up to send EDI ASN's. |
Do Not Send EDI ASN check box on the Ship-To tab in Customer Maintenance |
38100 |
skip-810 |
3 |
Yes/No |
Enter Yes if you do not want to send EDI invoices for the customer even if the trading partner associated with the customer is set up to send EDI invoices. |
Do Not Send EDI Invoice check box on the Ship-To tab in Customer Maintenance |
38200 |
skip-855 |
3 |
Yes/No |
Enter Yes if you do not want to send EDI order acknowledgments for the customer even if the trading partner associated with the customer is set up to send EDI order acknowledgments. |
Do Not Send EDI Order Acknowlegment check box on the Ship-To tab in Customer Maintenance |
38300 |
skip-870 |
3 |
Yes/No |
Enter Yes if you do not want to send EDI order statuses for the customer even if the trading partner associated with the customer is set up to send EDI order statuses. |
Do Not Send EDI Order Status check box on the Ship-To tab in Customer Maintenance |
38400 |
bypass-pkslp-req-check |
23 |
Character |
Enter anyone of the following options:
|
Bypass Pack List Required Fields Checking radio button group on the Pack List Required Fields tab in Customer Maintenance |
38500 |
shipto-entity-use-code |
25 |
Character |
This field only applies when AvaTax interface is used. If the value for shipto-tax-exempt is Yes, then one of the following fields becomes a required field:
If AvaTax interface is not used, leave this field blank. |
Entity Use Code field on the Ship-To tab in Customer Maintenance |
Before using this import, the following must be set up:
customers