Field

Description

Code

The code representing a deferred or installment pay plan.

Alphanumeric, 5 positions; optional.

Type

The type of pay plan. Valid values are:

D = deferred billing

I = installment

Alphanumeric, 1 position; optional.

Description

The description of the pay plan.

Alphanumeric, 40 positions; optional.

Start date

The date when the pay plan first becomes available to apply to orders.

Numeric, 6 positions (MM/DD/YY format); display-only.

End date

The date when the pay plan is no longer available to apply to orders.

Numeric, 6 positions (MM/DD/YY format); display-only).

Field

Description

FPO payment code

The code to identify the deferred or installment pay plan.

Alphanumeric, 5 positions.

Create screen: required.

Change screen: display-only.

Description

The description of the deferred or installment pay plan.

Alphanumeric, 40 positions; required.

Type

The type of pay plan. Valid values are:

D = deferred: Defer depositing the amount the customer owes for an order shipment for a specified period of time or until a specific date.

I = installment: Deposit the amount the customer owes for an order shipment in a specified number of equal installments.

Alphanumeric, 1 position; required.

Start (Start date)

The first date when new orders will be eligible for the pay plan. When evaluating whether an order is eligible for a pay plan, the system checks the original order date, even if you are attempting to add a pay plan in order maintenance on a later date.

Example: 7/25: You enter an order for an item that is currently backordered.

8/20: The customer calls to request a pay plan. The pay plan start date is 8/15.

Result: The order is ineligible for the pay plan based on the pay plan start date (8/15) and order date (7/25).

This date must be earlier than or the same as the end date.

Numeric, 6 positions (MMDDYY format); required.

End (End date)

The date when new orders will no longer be eligible for the pay plan. Eligibility is based on the original order date, not the current date, when you add a pay plan in order maintenance.

Example: 7/25: You enter an order for an item that is currently backordered.

8/20: The customer calls to request a pay plan. The pay plan end date is 7/31.

Result: The order is eligible for the pay plan based on the pay plan end date (7/31) and order date (7/25).

This date must be later than or the same as the start date.

Numeric, 6 positions (MMDDYY format); required.

Expiration date

The date when you will no longer defer processing deposits for the pay plan.

Example: 7/25: You enter an order for deferral of payment for 60 days based on invoice date. The item is currently backordered. The pay plan has an ending date of 7/31, and an expiration date of9/30.

8/15: You ship and bill the order.

Result: Since the deferred date (60 days past the invoice date of 8/15, or 10/14) would be past the expiration date of 9/30, the deposit will not be deferred, but will be available for processing immediately.

The system determines when the pay plan has expired as follows:

Deferral: You can enter an expiration date only if you use the # of days for deferral field rather than the Fixed deferral date.

To determine whether to apply the deferral, the system adds the number of days for deferral to the order's invoice date (if the Based on field is set to I) or the order date (if the Based on field is set to O). If the result is later than the Expiration date, the deposit is not deferred and is eligible for processing immediately after billing.

You cannot enter an expiration date that is sooner than the pay plan End date; otherwise, the following error message displays:

Invalid Expiration Date

Installment: To determine whether to apply the installment, the system compares the order's invoice date with the expiration date. If the Invoice date is later than or the same as the Expiration date, the deposit is not broken out into installments, but the entire amount is eligible for processing immediately after billing.

Numeric, 6 positions (MMDDYY format); required unless you enter a Fixed deferral date for a deferral pay plan.

View in OE/OM

Indicates whether this pay plan displays on the Select Payment Plan Window during order entry and order maintenance.

Valid values are:

Y = If the order is eligible for the payment plan, the Select Payment Plan window lists the plan.

N = The Select Payment Plan pop-up window does not list the plan; however, you can still apply this plan to an eligible order by entering the code in the Pay plan field.

Regardless of the setting of this field:

• The system displays the primary payment plan in the Select Payment Plan window.

• You can still apply the pay plan by typing in the code, even if it does not display on the Select Payment Plan window; also, the plan can be auto-applied regardless of whether it is viewable.

Alphanumeric, 1 position; required.

Restrict to entity

Enter an entity code in this field to restrict the pay plan to orders whose source code points to this entity. The source code is associated with an entity through its division.

The source code on the order header determines the entity.

Leave this field blank to make orders eligible for the pay plan regardless of entity.

Entity codes are defined in and validated against the Entity file. See Accounts Payable Chapter 1: Working with Entities (WENT) and Marketing Chapter 67: Working with Flexible Payment Options (WFPO).

Numeric, 3 positions; optional.

Auth full amount (Authorize full amount)

This field indicates whether to authorize the full pickable amount of the order when generating the initial authorization at pick slip generation. Valid values are:

Y = authorize full pickable amount

N = do not authorize full pickable amount.

If you set this field to N, the amount authorized at pick slip generation is:

Deferred: $1.00 is authorized at pick slip generation.

Installment: The amount of the first installment is authorized at pick slip generation.

See Chapter 68: Processing Auto Deposits (SDEP) for an overview of the authorization process for pay plan orders.

Alphanumeric, 1 position; required.

Merchant ID message

A short message to pass to the deposit service. This message appears on the customer's credit card statement. The message is concatenated with additional information into a 14- or 18-position message, formatted as follows:

DBA industry code (3 positions): taken from the first 3 positions of the Industry format code for the authorization service

Merchant ID message (11 positions)

Installment description (4 positions): for installment pay plans, this consists of a description of which installment was deposited, for example, 1of 4. With this description, the entire message for an installment plan is 18 positions. For deferred pay plans, the entire message ends after the merchant ID message, producing a 14-position message.

Alphanumeric, 11 positions; optional.

Ship complete

This field indicates whether to override the Ship complete flag setting on an order that uses this pay plan to Y. You might use this field to prevent pay plan orders from having multiple invoice dates, thus multiplying the number of deposits.

Example: If an order uses a pay plan of four installments, and you fulfill the order in three separate shipments because of backorders, you would need to process 12 deposits to complete the pay plan.

Valid values are:

Y = force orders with this pay plan to ship complete

N = do not force orders with this pay plan to ship complete

You might also set the Consolidated Invoice (B49) system control value to Y to simplify pay plan processing; see Chapter 66: Deferred/Installment Billing Setup.

Alphanumeric, 1 position; required.

Display summary

This field controls whether the Display Payment Plan Summary Screen displays automatically when you add this payment plan to an order. This screen includes projected deposit dates and amounts for the order. Valid values are:

Y = display the summary screen

N = do not display the summary screen

You can also display the summary screen in order entry by typing 8 next to the pay type at the Enter Payment Method Screen.

Alphanumeric, 1 position; required.

Auto apply

This field indicates the method the system should use when determining which pay plan(s) apply to an order in order entry. Valid values are:

1 = automatically apply: apply this pay plan to an order if the order qualifies, without prompting the operator. If a pay plan is set to apply automatically, it overrides the regular hierarchy of pay plan selection.

2 = do not automatically apply: apply this pay plan to a qualifying order only when the operator selects it.

3 = prompt operator: force a window to pop up in order entry displaying all available pay plans if the order qualifies for the pay plan. You should set the View in OE/OM field to Y if you set this field to 3.

Note: To simplify pay plan selection in order entry, you should use the same setting in this field for all of your pay plans.

See Assigning a Payment Plan to the Order for a discussion of how the system determines which pay plan(s) an order qualifies for.

Numeric, 1 position; required.

Validate CC expiration date

This field is not currently implemented.

Alphanumeric, 1 position; required.

Pick message

Three lines of message text to appear on the pick slip. Messages appear only if your pick slip printing program supports them.

Alphanumeric, 60 positions each; optional.

Use the following fields to set up a deferral pay plan:

# of days for deferral

This field indicates the number of days to defer processing the deposit for a shipment. If you enter a number in this field, you must also specify whether to base the calculation on order date or invoice date; see the field description below.

Example: No payments for 60 days from shipment.

You can also base a deferral on a fixed date; see Fixed deferral date, below.

You cannot use this field for an installment pay plan.

Numeric, 3 positions; required for a deferral pay plan if you do not enter a fixed date.

Based on

This field indicates whether to base the deferral interval on the date you enter the order, or the date you ship and bill it. Valid values are:

O = base deferral on original order date. If you base the deferral on original order date, it is possible for the deposit to be eligible for processing immediately after billing. For example, if you defer payment for 30 days from order date, and you do not ship for 30 days or more after the order date, the deposit will be eligible for processing immediately.

I = base deferral on invoice (billing) date.

The system uses this field to calculate the deposit date only for deferred pay plans that use the # of days for deferral to calculate deposit date. You cannot use this field for an installment pay plan.

Alphanumeric, 1 position; required for a deferral pay plan if you enter a # of days for deferral.

Fixed deferral date

This field indicates the fixed date to use for a deferral pay plan. If you select a fixed deferral date for a pay plan, all orders using this pay plan will be eligible for deposit on this date regardless of when they are entered or billed.

Example: No payment till February 1 when you order from our holiday book.

If you complete this field, you cannot complete the # of days for deferral or Based on fields. Also, you cannot use this field for an installment pay plan.

Numeric, 6 positions (MMDDYY format); required for a deferral pay plan if you do not enter a # of days for deferral.

Use the following fields to set up an installment pay plan:

# of installments (Number of installments)

The number of installments required to pay off the invoice balance.

Example: Four easy payments. The system divides the invoice total into this number of equal installments. If the total does not divide equally, the last installment(s) will include the additional balance.

You must complete either the Interval or the Fixed installment day field to indicate when the installments will be due.

You cannot use this field for a deferral pay plan.

Numeric, 2 positions; required for an installment pay plan.

Interval

The number of days between installments. The shortest interval you can set is 30 days. The installment date is based on the date you bill the shipment.

Example: Set this field to 30 and the # of installments to 3 to have deposits eligible for processing 30, 60, and 90 days after billing.

You can also base the installment dates on a fixed day of the month; see Fixed installment day below.

You cannot use this field for a deferral pay plan.

Numeric, 3 positions; required for an installment pay plan if you do not complete the Fixed installment day.

Fixed installment day

The day of the month to process the deposits for an installment pay plan. The first deposit is eligible for processing on the first occurrence of this date after shipment.

Example: If you set this field to 15, and you confirm shipment of the order on any date from August 16 to September 15, the deposit will be eligible for processing on September 15.

You can also base the installment dates on a number of days between installments; see Interval above.

You cannot use this field for a deferral pay plan.

Numeric, 2 positions; required for an installment pay plan if you do not complete the Interval field.

Use the following fields to restrict orders which can use the pay plan. An order must meet all of the specified criteria for the pay plan to qualify:

Offer

Enter an offer code to restrict the pay plan to orders for this offer. The offer is based on the source code on the order header.

If you leave this field blank, the pay plan will not be restricted by offer.

Offer codes are defined in and validated against the Offer file; see Marketing Chapter 2: Working with Offers (WOFR).

Alphanumeric, 3 positions; optional.

Minimum amt (Minimum amount)

Enter a minimum order merchandise total to restrict the pay plan to orders who meet or exceed this total. For a multi-recipient order, the merchandise total against all recipients is compared with this minimum to determine eligibility.

If you leave this field blank, the pay plan will not be restricted by merchandise total.

Numeric, 9 positions with a 2-place decimal; optional.

Pay type

Enter a pay type code to restrict the pay plan to orders that use this pay type. If you leave this field blank, the pay plan will not be restricted by pay type. Pay type codes are defined in and validated against the Pay Type file; see Accounts Payable Chapter 5: Working with Pay Types (WPAY).

Numeric, 2 positions; optional.

Item

Enter an item code to restrict the pay plan to orders that include this item. The order can also include additional items.

You can enter the base item code only. If the item has SKUs, you cannot restrict the pay plan to specific SKUs.

If you leave this field blank, the pay plan will not be restricted by item.

Item codes are defined in and validated against the Item file; see Merchandising Chapter 24: Performing Initial Item Entry (MITM).

Alphanumeric, 12 positions; optional.

Field

Description

Code

The code representing a deferred or installment pay plan.

Alphanumeric, 5 positions; display-only.

Type

The type of pay plan. Valid values are:

D = deferred billing

I = installment

Alphanumeric, 1 position; display-only.

Description

The description of the pay plan.

Alphanumeric, 40 positions; optional.

Start date

The date when the pay plan first becomes available to apply to orders.

Numeric, 6 positions (MM/DD/YY format); display-only.

End date

The date when the pay plan is no longer available to apply to orders.

Numeric, 6 positions (MM/DD/YY format); display-only).

# of orders

The total number of orders for the pay plan. This total increases when you:

• enter an order for the pay plan

• change an order to this pay plan in order maintenance, if the Update Demand for Order Maintenance Transactions (C72) system control value is set to Y

This total decreases when you cancel an item and use a cancel reason whose Reduce demand? field is set to N. See Customer Service Chapter 5: Establishing Cancel Reason Codes (WCNR).

Numeric, 7 positions; display-only.

# of shipments

The total number of shipments made for this pay plan. This total increases when you confirm shipments for any orders using the pay plan, including orders that were not originally entered for the pay plan and were changed in order maintenance.

Numeric, 7 positions; display-only.

$ ordered (Dollars ordered)

The dollar merchandise total, excluding any order charges such as freight, tax, and handling, of all orders entered for the pay plan. This total increases when you:

• enter an order for the pay plan

• change an order to use this pay plan in order maintenance, if the Update Demand for Order Maintenance Transactions (C72) system control value is set to Y

• add an item in order maintenance if the Update Demand for Order Maintenance Transactions (C72) system control value is set to Y

This total decreases when you cancel an item and use a cancel reason whose Reduce demand? field is set to N. See Customer Service Chapter 5: Establishing Cancel Reason Codes (WCNR).

Numeric, 13 positions with a 2-place decimal; display-only.

$ shipped (Dollars shipped)

The dollar merchandise total, excluding additional order charges such as freight, tax, and handling, of shipments made for the pay plan. This total increases when you confirm shipments for any orders using the pay plan, including orders that were not originally entered for the pay plan and were changed in order maintenance.

Numeric, 13 positions with a 2-place decimal; display-only.

# of cancels

The total number of items or orders canceled for the pay plan. This total increases when you process a cancellation for any orders using the pay plan, including orders that were not originally entered for the pay plan and were changed in order maintenance, through:

• order maintenance

• Working with Backorders Pending Cancellation (WBPC)

Orders you cancel due to credit card decline through Working with Credit Card Cancellations (WCCC) do not update this total.

Numeric, 7 positions; display-only.

# of returns

The total number of items or orders returned or exchanged for the pay plan. This total increases when you process a return or exchange for an order with the pay plan, including orders that were not originally entered for the pay plan and were changed in order maintenance.

Numeric, 7 positions; display-only.

$ cancelled (Dollars canceled)

The dollar merchandise total, excluding additional order charges such as freight, tax, and handling, of cancellations made for the pay plan. This total increases when you process any sort of cancellation for an order using the pay plan, including orders that were not originally entered for the pay plan and were changed in order maintenance, through:

• order maintenance

• Working with Backorders Pending Cancellation (WBPC)

Orders you cancel due to credit card decline through Working with Credit Card Cancellations (WCCC) do not update this total.

Numeric, 13 positions with a 2-place decimal; display-only.

$ returned (Dollars returned)

The dollar merchandise total, excluding additional order charges such as freight, tax, and handling, of returns or exchanges made for the pay plan. This total increases when you process any sort of return or exchange for an order using the pay plan, including orders that were not originally entered for the pay plan and were changed in order maintenance.

Numeric, 13 positions with a 2-place decimal; display-only.

# of sold outs

The total number of items or orders sold out for the pay plan. This total increases when sell out an item on an order with the pay plan, including orders that were not originally entered for the pay plan and were changed in order maintenance, through entering 13 next to the item in order entry or order maintenance or Processing Auto Soldout Cancellations (MASO).

Numeric, 7 positions; display-only.

$ sold out (Dollars sold out)

The dollar merchandise total, excluding additional order charges such as freight, tax, and handling, of sellouts made for the pay plan. This total increases when you process any sort of sellout for an order using the pay plan, including orders that were not originally entered for the pay plan and were changed in order maintenance, through

• entering 13 next to the item in order entry or order maintenance

• Processing Auto Soldout Cancellations (MASO)

Numeric, 13 positions with a 2-place decimal; display-only.