Reviewing Financial Information on an Order

Purpose: From the Order Inquiry Header Screen and Order Inquiry Detail Screen, you can advance to screens that display financial information for an order.

You can use these screens to review and evaluate invoices, refunds, additional charges, order totals and items ordered, as well as order payment methods, credit card authorization history, deposit history and order payment history.

Streamlined order inquiry: As an alternative to standard order inquiry, the Streamlined Order Inquiry (DORI) option provides a consolidated, one-page view of the order, including certain information on payment methods, invoices, refunds, and additional charges.

In this topic:

for information on	select	to advance to
Invoices	Display Invoices	Display Invoices Screen • Order Receipt Display Invoice Header Screen Display Invoice Pay Methods Screen Display Invoice Payment Method Screen (Reviewing Detail) First Display Invoice Detail Screen
		• Second Display Invoice Detail Screen Second Display Invoice Detail Screen Display Invoice Detail Pay Methods Screen Invoice Detail Charges Screen Invoice Cost Detail Screen Invoice Pay Summary Screen Change Invoice Pay Method Screen • Working with Rejected Deposits • Changing Credit Card Information for an Invoice Payment Method Display Invoice Pay Method Screen (Reviewing Deposit Information) Display Invoice Address Screen (Billing Address) Display Invoice Address Screen (Shipping Address)
Order Payment Methods	Pay Methods	Display Order Payment Methods Screen Display Order Pay Type Screen (1 of 2) Display Order Pay Type Screen (2 of 2) Display Authorization History Screen Authorization History Details Window Display Deposit History Screen Display Deposit History Detail Screen Display Order Payment History Screen Display Authorization Reversals Screen Display Contributions Screen
Additional Charges	Additional Charges	Display Additional Charges Screen
Refunds	Refunds	Display Refunds for Order Screen
Order Summary	Order Totals	Display Order Summary Screen Displaying Order Totals in Foreign Currency • If no Currency is Defined for the Country

Reviewing Invoices

Display Invoices Screen

Purpose: Use the invoice function from within standard Order Inquiry to review and print invoice detail on shipments. As you build an order, the system keeps a record of each shipment you make against the order. Similarly, the system creates a record of each credit against the order for returns, cancellations, and overpayments.

The Display Invoices screen lists the invoices or credits the system has generated for the order you are reviewing and provides access to each additional invoice-related screen.

Consolidate invoice? The Consolidated Invoice (B49) system control value indicates whether to consolidate multiple shipments for an order on the same system date under the same Invoice Header number. The Invoice Consolidation Method (E29) controls whether the system consolidates invoices for each separate ship-to for an order, or for the order as a whole.

Invoice consolidation does not apply when you express-bill an order or create a credit invoice.

Important: In Order Management System 21.0 or higher, you cannot select the Consolidated Invoice system control value if it is not already selected. If the system control value is currently selected (set to Y) and you deselect it (change it to N or blank), you cannot then change it back to selected. The option to consolidate invoices will be removed at a later date.

Also, if a billing or shipping address changes between shipments and the Capture Addresses for Invoice (J24) system control value is selected, this can prevent the invoice from consolidating. Even if the invoice is consolidated, there is a separate entry at this screen for each unique billing address/shipping address combination if the Capture Addresses for Invoice (J24) system control value is selected.

Invoice creation for ship-for-pickup orders: If the Invoice Ship For Pickup Order Once Intransit (M73) system control value is selected, the invoice is created for an item on a ship-for-pickup order once the system receives notification from Order Broker that the order line is in transit from the sourcing location to the pickup location, has been received at the pickup location, or has been fulfilled. See that system control value for more information.

For more information: See the Invoice Consolidation Method (E29) system control value for a discussion.

Note: On orders subject to VAT and tax-inclusive pricing, the invoice screens described in this section display the tax-inclusive price that the customer sees; in other words, the hidden tax amount is not visible. You can review the hidden tax amount for an item by advancing to the Invoice Detail Charges Screen.

How to display this screen: Select Display Invoices at the Order Inquiry Header Screen or Order Inquiry Detail Screen.

Field	Description
Order #	The number the system has assigned to this order. Numeric, 7 positions, display-only.
Ship-to	The number of the ship-to address on the order. The number of the ship-to you were displaying when you selected Invoices defaults in this field, but you can also review invoices for the other ship-to records on the order from this screen. Numeric, 3 positions; optional.
Invoice #	The number the system assigns to a customer's bill or credit. The system generates an invoice during billing. The Consolidated Invoice (B49) system control value selected controls whether two shipments to the same billing and shipping addresses on the same billing date are consolidated into the same Invoice Ship To record, producing a single entry on this screen. Multiple entries for same invoice: The system uses the same invoice number for separate shipments that occur on the same billing date if the Consolidated Invoice system is selected, and, • the Invoice Consolidation Method (E29) is set to ORDER, and the shipments were made for separate order ship-to’s, or, • the Invoice Consolidation Method (E29) is set to ORDER SHIP, and the shipments were made for the same order ship-to, and the billing and shipping addresses were the same for the shipments. When consolidating invoices as described above, the system creates a single Invoice Header record (and a single invoice number), but separate Invoice Ship To records. See the Invoice Consolidation Method (E29) for a discussion and examples. Note: In Order Management System 21.0 or higher, you cannot select the Consolidated Invoice system control value if it is not already selected. If the system control value is currently selected (set to Y) and you deselect it (change it to N or blank), you cannot then change it back to selected. The option to consolidate invoices will be removed at a later date. Assigned when? If the Generate Invoice Number at Pick Gen (H80) or Generate Invoice # at Pick Gen without Address Match (K81) system control value is selected, the system assigns the invoice number at pick slip generation if the order is eligible; otherwise, it assigns the invoice number at billing. Invoice address? If the Capture Addresses for Invoice (J24) system control value is selected, the shipping and billing addresses for each Invoice Ship To are stored in the Invoice Address table; you can use the Display Invoice Address Screen (Billing Address) and Display Invoice Address Screen (Shipping Address) to review them. Numeric, 7 positions; optional.
Date	The date the invoice record was created by billing. This is the Start date for the billing async job. Numeric, 6 positions (in user date format); display-only.
Type (Invoice type)	Indicates the type of invoice: • C = Credit memo. Generated when you process a return. Credit and return amounts appear as negative numbers when you review invoice information. • I = Invoice. Generated when you bill a shipment. The system does not consolidate credit invoices with other credits or with debit invoices. Alphanumeric, 1 position; display-only.
Total	The total of the invoice. Credit invoice amounts include a minus sign. Numeric, 20 positions with a 2-place decimal; display-only.
Net Bill	Indicates whether the invoice is currently pending Credit Card Net Exchange Billing. • * = the invoice is currently pending credit card net exchange billing. The system considers an invoice pending for credit card net exchange billing if the Invoice Payment Method record contains the EXC flexible payment option code in the IPM FPO Payment Code and the invoice has not yet been deposited (the IPM Deposit created date is blank). • blank = the invoice is not pending credit card net exchange billing.
Date Printed	The date the invoice was printed. Numeric, 6 positions (in user date format); display-only.

Screen Option	Procedure
Display invoice header	Select Invoice for an invoice to advance to the Display Invoice Header Screen.
Display payment methods records	Select Pay Methods for an invoice to advance to the Display Invoice Pay Methods Screen.
Display invoice details for particular items	Select Details for an invoice to advance to the First Display Invoice Detail Screen.
Display the billing address for an invoice	Select Billing Address for an invoice to advance to the Display Invoice Address Screen (Billing Address).
Display the shipping address for an invoice	Select Shipping Address for an invoice to advance to the Display Invoice Address Screen (Shipping Address).
Display invoice payment summary information	Select Invoice Pay Summary to advance to the Invoice Pay Summary Screen.
Print an order receipt for each ship-to on the order	Select Order Receipt. See the Order Receipt for more information. Note: • This option is available only if the Order Receipt Print Program (L46) specifies a program and there are any invoices currently displayed on the screen. For example, if there is an invoice for the first ship-to, but you have positioned to the second ship-to, the option is not displayed. • Selecting this option for a multi-recipient order generates a receipt for each ship-to that has had any shipments. • The screen displays an error message when you select this option if the only invoices on the order are credits: No eligible invoices found to print on Order Receipt.

Display Invoice Header Screen

Purpose: Use this screen to review the basic elements of the invoice, such as the tax, handling, additional charges, hidden freight and gross profit.

How to display this screen: At the Display Invoices Screen, select Invoice for an invoice.

Field	Description
Order #	The number the system has assigned to this order. The ship-to number is separated from the order number by a hyphen. Order number: numeric, 7 positions, display-only. Ship-to number: numeric, 3 positions; display-only.
Invoice #	The number the system assigns to a customer's bill. Assigned when? If the Generate Invoice Number at Pick Gen (H80) or Generate Invoice # at Pick Gen without Address Match (K81) system control value is selected, the system assigns the invoice number at pick slip generation if the order is eligible; otherwise, it assigns the invoice number at billing. Numeric, 7 positions; display-only.
Type (Invoice type)	Represents the type of invoice. Valid values are: • Credit memo = The system generates a credit memo whenever you process a return through Order Maintenance, Order Entry (by entering a negative order quantity), or through Return Authorizations. • Invoice = The system generates an invoice when you confirm shipment of an item. Display-only.
Invoice print date	The date you printed the invoice or credit memo. Numeric, 6 positions (in user date format); display-only.
Merchandise	The total value of the merchandise. Merchandise amount does not include tax, handling, additional charges, or freight. Numeric, 20 positions with a 2-place decimal; display-only.
Cost	The actual cost of the merchandise billed on this invoice. Note: The secured feature Display Invoice Cost in O/I (A36) controls whether this screen displays the cost. Numeric, 20 positions with a 2-place decimal; display-only.
Freight	The freight charges for the invoice. This amount may not be equal to the total of all the line-level freight charges. Numeric, 20 positions with a 2-place decimal; display-only.
G/M (Gross profit margin)	The amount of the merchandise price that exceeds the total cost. You can use gross margin to determine the profit of an order based on each item's selling price. See Determining Gross Profit for more information. The Display Gross Margin (A65) secured feature controls whether this field displays in order entry, maintenance, inquiry and item availability. Numeric, 20 positions with a 2-place decimal; display-only.
G/M% (Gross profit margin percentage)	The percentage of the merchandise price that exceeds the total cost. You can use gross margin to determine the profit of an order based on each item's selling price. See Determining Gross Profit for more information. The Display Gross Margin (A65) secured feature controls whether this field displays in order entry, maintenance, inquiry and item availability. Numeric, 5 positions with a 2-place decimal; display-only.
Tax	The sales tax for the invoice. This field includes GST and PST, if any. This field does not include hidden tax; see the Invoice Detail Charges Screen. Numeric, 20 positions with a 2-place decimal; display-only.
GST	The Canadian Goods and Services Tax, if any. This field displays only if there is a GST charge or credit on the invoice. Numeric, 20 positions with a 2-place decimal; display-only.
PST	The Canadian Provincial Services Tax, if any. This field displays only if there is a PST charge or credit on the invoice. Numeric, 20 positions with a 2-place decimal; display-only.
Handling (Handling charge)	The cost of any special handling on the order, such as personalizing, monogramming, or engraving, and any gift wrapping charges. Any duty charges on the invoice are included in this total. See First Display Invoice Detail Screen for information on duty charges on an invoice. Numeric, 20 positions with a 2-place decimal; display-only.
Add'l charges (Additional charges)	The total charges exceeding standard charges on the current order. The system validates additional charges, which are entered manually or automatically assigned against the Additional Charges table during Order Entry. Additional charges may include: Additional source code charge: An additional charge for services that apply to the source code or offer. These charges apply if you have set up a service charges table for the source code or offer. The system applies the additional charge to the order based on the total value of the merchandise. Additional shipper/item charge: An additional charge that applies to the item, depending on the shipper you select to deliver the item. Such charges may apply when the item exceeds established shipping rate charges. For example, delivery of an oversized item may incur an additional shipper/item charge. Additional shipper/item charges apply when defined for the shipper.
	Ad hoc charge: An additional charge, such as a charge for a gift box, that you assign at order entry. You initially define ad hoc charges in the Additional Charges table. Dollar discount: An additional charge (credit) that is applied based on the total value of the merchandise. Note: The Add'l charges field in standard Order Inquiry corresponds to the Chg field on Order Entry. Numeric, 20 positions with a 2-place decimal; display-only.
Add'l freight (Additional freight charges)	The total amount for freight charges exceeding the order's base freight charge. This is a shipper-level charge directly associated with the order, as opposed to the line item. Additional freight is defined for the shipper in the Ship Via table. Examples of additional freight charges that might apply include charges for overnight shipping, second day delivery, padded van, etc. Additional freight charges may include the standard freight charges, depending on how you have set up the shipper. In this case, the Freight field is blank. Note: The Add'l freight field in standard Order Inquiry corresponds to the Frt+ field in Order Entry. Numeric, 20 positions with a 2-place decimal; display-only.
Total	The total amount billed or credited, including all related merchandise charges, freight, tax, handling, additional charges, and additional freight. Numeric, 20 positions with a 2-place decimal; display-only.
Discount amount	The difference between the actual price charged for items and the offer prices. Comparing this amount to the original offer price gives you an indication of the amount that the order varied from the original offer price. A negative amount in Indicates a charge greater than the original offer price. Price overrides: When you override the price of an item, the system uses the following rules in determining what portion of the selling price constitutes a discount:
	• If the price override reason code’s Override item offer price field is selected, the discount amount equals the difference between the override price entered and the final selling price; in other words, it equals any additional discounts applied after the price override. Example: The price override amount entered was $10.00 and an additional discount coupon of $1.00 was applied; the discount amount is $1.00. • If the price override reason code’s Override item offer price field is unselected and an item/SKU offer price exists, the discount amount equals the difference between the offer price and the selling price. Example: The item offer price is $15.00, the price override amount entered was $10.00, and an additional coupon discount of $1.00 was applied; the discount amount is $6.00. • If the price override reason code’s Override item offer price field is unselected and an item/SKU offer price does not exist, the discount amount equals the selling price of the item, presented as a negative number. Example: The price override amount entered was $10.00 and an additional coupon discount of $1.00 was applied; the discount amount is -$9.00.
	See Overriding the Item/SKU Offer Price for an overview. Note: The setting of the Override item offer price field has no effect on orders you receive through the order API. If there is a price override reason code in the inbound order message, the system always processes these orders as if the field is unselected. Numeric, 20 positions with a 2-place decimal; display-only.
Hidden freight	The amount of the merchandise charge that represents hidden freight. Hidden freight, defined at the Item Offer level, is a freight charge that you want to track but not reveal to the customer. Note: Hidden freight will not appear on this screen if you override an item price in Order Entry. Numeric, 13 positions with a 2-place decimal; display-only.

Display Invoice Pay Methods Screen

Purpose: Use this screen to review the distribution of payment methods on an order invoice, and to select a specific payment method for detailed review.

How to display this screen: At the Display Invoices Screen, select Pay Methods for an invoice.

How to use this screen: Use this screen to review summary information on invoice payment method records; in addition, you can review a payment method by selecting Display for it.

See Display Invoice Payment Method Screen (Reviewing Detail) for field descriptions.

Display Invoice Payment Method Screen (Reviewing Detail)

Purpose: Use this screen to review detailed information, including unpaid balances, for a specific payment method used on the order.

How to display this screen: At the Display Invoice Pay Methods Screen, select Display for a payment method.

Field	Description
Order #	A number the system assigns to uniquely identify an order. Numeric, 8 positions; display-only.
Invoice #	A number the system assigns to uniquely identify an invoice. Numeric, 7 positions; display-only.
Pay method	Represents the method of payment on the order. Pay method codes are defined in and validated against the Pay Type table. See Working with Pay Types (WPAY). Numeric, 2 positions; display-only.
Description	The description of the payment method code. Alphanumeric, 30 positions; display-only.
Merchandise	The total value of the merchandise. Merchandise amount does not include tax, handling, additional charges, duty or freight. Numeric, 20 positions with a 2-place decimal; display-only.
Merchandise balance	The unpaid portion of the merchandise total. Numeric, 20 positions with a 2-place decimal; display-only.
Freight	The freight charges for the invoice assigned to the payment method. Numeric, 20 positions with a 2-place decimal; display-only.
Freight balance	The unpaid portion of the freight. Numeric, 20 positions with a 2-place decimal; display-only.
Add'l freight (Additional freight charges)	The total amount for freight charges exceeding the order's base freight charge. Additional freight reflects charges that are specific to the carrier, as defined for the shipper in the Ship Via table. See Working with Ship Via Codes (WVIA). Example: Additional freight charges that might apply include charges for overnight shipping, second day delivery, padded van, etc. Additional freight charges may include the standard freight charges, depending on how you have set up the shipper. Numeric, 20 positions with a 2-place decimal; display-only.
Additional freight balance	The unpaid portion of the additional freight balance charge. Numeric, 20 positions with a 2-place decimal; display-only.
Add'l charges (Additional charges)	The total charges exceeding standard charges on the current order. The system validates additional charges against the Additional Charges table during Order Entry. See Establishing Additional Charge Codes (WADC). Numeric, 20 positions with a 2-place decimal; display-only.
Additional charges balance	The unpaid portion of the additional charges. Numeric, 20 positions with a 2-place decimal; display-only.
Handling (Handling charge)	The cost of any special handling on the order, such as personalizing, monogramming, or engraving, and any gift wrapping charges. This field includes the duty charges, if any, for the payment method. Numeric, 20 positions with a 2-place decimal; display-only.
Handling balance	The unpaid portion of the handling charge and/or duty charge, if any. Numeric, 20 positions with a 2-place decimal; display-only.
Tax	The total sales tax that applies to the shipment on this payment method. This total does not include any hidden tax. Numeric, 20 positions with a 2-place decimal; display-only.
Tax balance	The unpaid portion of the taxes on the shipment on this payment method, excluding hidden tax. Numeric, 20 positions with a 2-place decimal; display-only.
Total	The total for the pay method, including merchandise, freight, additional freight, additional charges, handling and tax. Numeric, 20 positions with a 2-place decimal; display-only.
GST (Goods and Services tax)	The Canadian federal Goods and Services tax that applies to the shipment on this payment method. Numeric, 20 positions with a 2-place decimal; display-only.
GST balance	The unpaid portion of the Canadian federal Goods and Services tax on the shipment on this payment method. Numeric, 20 positions with a 2-place decimal; display-only.
PST (Provincial Services Tax)	A Canadian provincial services tax that applies to the shipment on this payment method. Numeric, 20 positions with a 2-place decimal; display-only.
PST balance	The unpaid portion of the Canadian provincial services tax. Numeric, 20 positions with a 2-place decimal; display-only.
Order level freight	Freight charges that apply to the total shipment. Numeric, 20 positions with a 2-place decimal; display-only.
Order level freight	The unpaid portion of the order level freight balance charged on the shipment. Numeric, 20 positions with a 2-place decimal; display-only.
Order level freight tax	The total freight tax on the shipment, excluding hidden tax. Numeric, 20 positions with a 2-place decimal; display-only.
Order level freight tax balance	The unpaid portion of the order level tax charged on the shipment, excluding hidden tax. Numeric, 20 positions with a 2-place decimal; display-only.
Deposit created	The date the deposit was created. Numeric, 6 positions (in user date format); display-only.
Adjusted Amt	The adjusted deposit amount after performing Credit Card Net Exchange Billing. Numeric, 20 positions with a 2-place decimal; display-only.
Deposit To Date	The total amount deposited for the pay method, including merchandise, freight, additional freight, additional charges, handling and tax. Numeric, 20 positions with a 2-place decimal; display-only.
Suppress deposit	Indicates whether the system will include this invoice payment method when you run Processing Auto Deposits (SDEP). Valid values are: • Selected = The system will not attempt to deposit this payment method. • Unselected = This payment method will be included when you process deposits. The system determines how to set this flag based on the setting of the Suppress deposit flag at the Display Order Pay Type Screen (1 of 2). This field can be selected if: • you create the order through the Generic Order Interface (Order API); see Suppressing Deposits and Refunds for an overview. • this is a ship-for-pickup order, and the Payment at POS for Ship for Pickup Orders (L60) system control value is selected. See that system control value for background. Only credit card payment methods can have this flag selected. This flag is selected only for the first time that you bill against the payment method; afterward, the system resets the flag for the payment method to Unselected.

First Display Invoice Detail Screen

Purpose: Use this screen to review the invoice details for each item on the order that has been billed, and to select a detail for review.

How to display this screen: At the Display Invoices Screen, select Details for an invoice.

Field	Description
Ln # (Line number)	The number of the invoice line on which the item appears. Numeric, 3 positions; display-only.
Item # (Item code)	Represents a unit of inventory. Item codes are defined in and validated against the Item table. See Performing Initial Item Entry (MITM). Alphanumeric, 12 positions; display-only.
SKU (Stock keeping unit)	A code that defines an item's special characteristics, such as size and color. SKU codes are defined in and validated against the SKU table. Alphanumeric, three 4-position fields; display-only.
Ship qty (Shipped quantity)	The shipped quantity of the invoiced item. The quantity is negative in the case of a return. Numeric 5 positions; display-only.
Price	The actual unit price of the shipped or returned item. Numeric, 13 positions with a 2-place decimal; display-only.
Ship date	The date the invoice line shipped or the return was processed. This is the Start date from the billing async job. Numeric, 6 positions (in user date format); display-only.
Return qty (Return quantity)	The quantity of the item billed on this invoice that the customer has returned. Numeric, 5 positions; display-only.
Return date	The most recent date when the customer returned any quantity of the item billed on this invoice. Numeric, 6 positions (in user date format); display-only.

Option	Procedure
Display invoice detail for an item	Select Display for an item to advance to the Second Display Invoice Detail Screen.
Display payment methods for an item	Select Display pay methods for an item to advance to the Display Invoice Detail Pay Methods Screen.
Display invoice detail charges for an item, such as duty	Select Detail charges for an item to advance to the Invoice Detail Charges Screen.
Display the FIFO layers used to calculate the total cost of the item on this order	Select FIFO cost history for an item to advance to the Invoice Cost Detail Screen. Note: You would use this option only if you use FIFO costing.

Second Display Invoice Detail Screen

Purpose: Use this screen to review the charges for particular items on the invoice.

How to display this screen: Select Display for an invoice at the First Display Invoice Detail Screen.

Field	Description
Pick control #	A number the system assigns to uniquely identify a pick slip. Numeric, 7 positions; display-only.
Qty shipped (Quantity shipped)	The total quantity of the item you have shipped to the customer. The shipment date appears to the right. Quantity: numeric, 5 positions; display-only. Date: numeric, 6 positions (in user date format); display-only.
Qty returned (Quantity returned)	The total quantity of the item returned by the customer. The return date appears to the right. Quantity: numeric, 5 positions; display-only. Date: numeric, 6 positions (in user date format); display-only.
Qty credited (Quantity credited)	The total quantity of the item for which you have credited the customer. The system does not track the credit date. Quantity: numeric, 5 positions; display-only.
Price	The unit price of the item. Numeric, 13 positions with a 2-place decimal; display-only.
Cost	The cost of the item. This is the unit cost if you use standard or average costing, and the total extended cost if you use FIFO costing. See Invoice Cost Detail Screen. Numeric, 13 positions with a 4-place decimal; display-only.
Freight	The total extended freight charge for all units of this item. Only line-level freight charges appear on this screen. Numeric, 20 positions with a 2-place decimal; display-only.
Discount	The total extended discount amount applied to all units of this item. Price overrides: When you override the price of an item, the system uses the following rules in determining what portion of the selling price constitutes a discount:
	• If the price override reason code’s Override item offer price field is selected, the discount amount equals the difference between the override price entered and the final selling price; in other words, it equals any additional discounts applied after the price override. Example: The price override amount entered was $10.00 and an additional discount coupon of $1.00 was applied; the discount amount is $1.00. • If the price override reason code’s Override item offer price field is unselected and an item/SKU offer price exists, the discount amount equals the difference between the offer price and the selling price. Example: The item offer price is $15.00, the price override amount entered was $10.00, and an additional coupon discount of $1.00 was applied; the discount amount is $6.00. • If the price override reason code’s Override item offer price field is unselected and an item/SKU offer price does not exist, the discount amount equals the selling price of the item, presented as a negative number. The price override amount entered was $10.00 and an additional coupon discount of $1.00 was applied; the discount amount is -$9.00.
	See Overriding the Item/SKU Offer Price for an overview. Numeric, 13 positions with a 2-place decimal; display-only.
Tax	The tax amount for the units of the item on the invoice. If a tax override amount is defined for the order line and you process multiple shipments against the line, the system prorates the tax override amount across the units shipped on the order line to determine the new tax override amount and the tax amount to apply to each shipment. Example: If the tax override amount for the order line is 9.00 and the order quantity is 3, the system charges 3.00 if you ship 1 unit of the item and then charges 6.00 if you ship the remaining 2 units of the item. Numeric, 20 positions with a 5-place decimal; display-only.
Handling	The total extended handling charges for all units of this item. Note: This handling total does not include any duty charges for the item. Numeric, 20 positions with a 2-place decimal; display-only.

Display Invoice Detail Pay Methods Screen

Purpose: Use this screen to review information about the payment methods associated with the item shipment/invoice. This information differs from the Display Invoice Payment Method Screen (Reviewing Detail) in that it shows how payment types are applied to shipments of individual items on the order.

Note: The system does not create invoice detail pay method records for returns that you process through Order Maintenance; it creates these records only for returns that you process by entering a negative quantity in Order Entry.

How to display this screen: Select Display pay methods for an invoice at the First Display Invoice Detail Screen.

About this screen: This screen displays how a payment method was charged for the shipment of an item.

See Display Invoice Payment Method Screen (Reviewing Detail) for descriptions of the fields on this screen.

Note: The Handling field on this screen includes any duty charges for the item and payment method.

Invoice Detail Charges Screen

Purpose: Use this screen to review any duty, shipper/item, or hidden tax charges for an item.

How to display this screen: Select Detail charges for an item at the First Display Invoice Detail Screen.

Field	Description
Charge type	The type of charge on the invoice detail. The description of each charge appears to the right. Valid values are: • Duty = The system determines whether to charge duty by comparing the harmonize codes for the item and the duty rates defined for the ship-to country. The duty calculation is described to the right. See Setting Up the Country Table (WCTY). • Shipper/Item = This charge is added to the order if you have set up a shipper/item charge for the item with the shipper used on the order. See Working with Ship Via Codes (WVIA). • Vat/Hidden Tax = This charge is included in the item price if the order was subject to tax-inclusive pricing. See Setting Up Order Entry Values for more information on VAT and tax-inclusive pricing. Display-only.
Amount	The amount of the charge for the item. The method for calculating duty charges is indicated in the fields to the right. Numeric, 13 positions with a 2-place decimal; display-only.
Duty rate percent	The percentage the system used to calculate the duty amount. The system multiplies this percentage by the extended item price. Numeric, 5 positions with a 2-place decimal; display-only.
Duty rate amount	The flat rate the system used to calculate the duty amount. The system multiplies this amount by the total unit quantity. Numeric, 20 positions with a 2-place decimal; display-only.

Invoice Cost Detail Screen

Purpose: Use this screen to review the unit costs from each FIFO layer that make up the extended cost for an item on an invoice.

Note: There is cost information on this screen only if you use FIFO costing. See FIFO Costing Overview.

How to display this screen: Select FIFO cost history for an item at the First Display Invoice Detail Screen.

Field	Description
FIFO seq # (FIFO sequence number)	The sequence number of the FIFO cost layer that provided the unit cost. Sequence numbers are required to distinguish FIFO layers with the same item/SKU, creation date, and warehouse. If you process a return against one or more units of this item, the system uses the sequence number to determine which FIFO layer to select when determining the cost for the returned units. Numeric, 7 positions; display-only.
FIFO date	The date the FIFO layer was created. Numeric, 6 positions (in user date format); display-only.
Qty (Quantity)	The unit quantity of the item taking its cost from this FIFO layer. The system uses a standard hierarchy to select FIFO layers for costing, decreasing the unit quantity of each layer in turn, and closing the layer and moving on to the next when the entire quantity is exhausted. Numeric, 7 positions; display-only.
FIFO cost	The unit cost of the item derived from this FIFO layer. Numeric, 13 positions with a 4-place decimal; display-only.
Unit balance	The total unit quantity of the item from this FIFO layer that has not been returned by the customer. The system selects FIFO layers to determine cost for returns in the same order as it determines costs for sales. Numeric, 7 positions; display-only.

Display Invoice Address Screen (Billing Address)

Purpose: Use this screen to review the billing address associated with an invoice.

Where does the billing address come from? Depending on how you create the order, the billing address can be:

• the name and address from the Customer Bill to table, if there is a bill-to account associated with the order; otherwise,

• the name and address of the Customer Sold To who placed the order. This customer might differ from a Customer Sold To who receives the order.

How to display this screen: Select Billing address for an invoice at the Display Invoices Screen.

Note: This screen is available only if the Capture Addresses for Invoice (J24) system control value was selected at the time that the system generated the invoice. See that system control value for more information.

Field	Description
Order #	A number the system assigns to uniquely identify an order. Numeric, 8 positions; display-only.
Invoice #	A number the system assigns to uniquely identify an invoice. Numeric, 7 positions; display-only.
Type	Set to Billing Address. Alphanumeric, 15 positions; display-only.
Name	The company name and name for the billing address. Alphanumeric, 41 positions; display-only.
Address	Up to four lines of address information. Alphanumeric, 32 positions each; display-only.
Apt/Suite	The apartment, suite, rural route, or floor number for the billing address. Alphanumeric, 10 positions; display-only.
City/State/Zip	The city, state code, and zip or postal code for the billing address. City: 25 positions; display-only. State: 2 positions; display-only. Zip: 10 positions; display-only.

Display Invoice Address Screen (Shipping Address)

Purpose: Use this screen to review the shipping address associated with an invoice.

Where does the shipping address come from? Depending on how you create the order, the shipping address can be:

• the order-level shipping address, as set up through Assigning an Order Shipping Address

• a permanent shipping address for the customer, as set up through Using a Permanent Shipping Address in Order Entry

• a recipient customer, as set up through Adding a Recipient Order in Order Entry

• the name and address of the Customer Sold To who placed the order

How to display this screen: Select Shipping address for an invoice at the Display Invoices Screen.

Field	Description
Order #	A number the system assigns to uniquely identify an order. Numeric, 8 positions; display-only.
Invoice #	A number the system assigns to uniquely identify an invoice. Numeric, 7 positions; display-only.
Type	Set to Shipping Address. Alphanumeric, 15 positions; display-only.
Name	The company name and name for the shipping address. Alphanumeric, 41 positions; display-only.
Address	Up to four lines of address information. Alphanumeric, 32 positions each; display-only.
Apt/Suite	The apartment, suite, rural route, or floor number for the shipping address. Alphanumeric, 10 positions; display-only.
City/State/Zip	The city, state code, and zip or postal code for the shipping address. City: 25 positions; display-only. State: 2 positions; display-only. Zip: 10 positions; display-only.
Delivery code	A code representing the type of delivery address for a postal code. Valid values are: • B = Business address. • R = Residence. • N = No distinction. • Blank = Delivery code not defined. Some shippers, such as UPS, charge different rates based on the type of delivery address on an order. For example, shipping to a business address is cheaper than shipping to a residential address. You can define the delivery code for a postal area to insure that the best possible rate is charged for shipping an order. Alphanumeric, 1 positions; display-only.

Invoice Pay Summary Screen

Purpose: Use this screen to review invoice payment information, such as:

• the payment plan associated with the invoice, if any

• the total amount deposited to date for each invoice

• the total amount to deposit for each invoice

• the date the deposit is available for processing

How to display this screen: Select Invoice Pay Summary at the Display Invoices Screen.

An error message indicates if the Deferred and Installment Billing (F51) system control value is unselected:

Deferred/Installment Billing feature required for this function

Field	Description
Order #	A number the system assigns to uniquely identify the order. Numeric, 8 positions; display-only.
Invoice #	The number the system assigns to a customer's bill or credit. Numeric, 7 positions; optional.
Pay type	Represents the method of payment on the order. Pay methods are defined in and validated against the Pay Type table. See Working with Pay Types (WPAY). Numeric, 2 positions; display-only.
Date (Invoice date)	The date you billed the merchandise. Numeric, 6 positions; display-only.
I/D (Payment plan type)	A value that identifies whether the invoice payment method is associated with a deferred or installment payment plan. Valid values are: • I = The invoice payment method is associated with an installment payment plan. An installment payment plan allows you to break payments into installment amounts, for example, 3 installments of $30.00 each month. • D = The invoice payment method is associated with a deferred payment plan or the EXC Net Billing for Exchanges plan. A deferred payment plan allows you to defer the payment until a later date, for example, don't pay until January 2007. See Credit Card Net Exchange Billing for more information on the EXC plan. • blank = The invoice payment method is not associated with a payment plan. Alphanumeric, 1 position; display-only.
CC/C status (Credit card credit status)	A value that indicates the credit status of the return. A value only displays in this field if the invoice payment method is associated with a return or exchange. The system does not process a credit card credit against an installment or deferred billing order before the deposit has been processed. This ensures that you do not credit the customer's credit card before the card has been charged. Valid values are: • P = Refund pending. The system updates the status to pending when you perform a return or exchange in order entry, order maintenance or through Work with Return Authorizations and have not yet processed the refund. • R = Refund processed/ready. The system updates the status to processed/ready when you process the refund in Process Refunds. blank = Refund deposited. This field is also blank if the invoice payment method is not associated with a return or exchange. Alphanumeric, 1 position; display-only.
To date (Deposit to date)	The total amount deposited to date. When you process a deposit for an installment payment plan, the system updates this field by the deposit amount. Example: You have an installment payment plan assigned to the order for 3 installments of $30.00 on the 15th of every month. • The first installment updates this field to $30.00. • The second installment updates this field to $60.00. • The third installment updates this field to $90.00. Numeric, 20 positions with a 4-place decimal; display-only.
Total (Total amount to deposit)	The total amount that needs to be deposited in order for the invoice to be completely deposited. An error message indicates if you try to change an invoice payment method that has been completely deposited: Invoice (399) has been completely deposited and cannot be changed. Numeric, 20 positions with a 4-place decimal; display-only.
Rel date (Deposit release date)	This date indicates when the invoice is eligible for deposit. If this date is equal to or prior to the current date, the invoice payment is eligible for deposit. The system updates this field when a deposit is confirmed with the next deposit release date if there is a remaining amount to deposit, for example, in installment billing. Regular (non-payment plan) Orders: For regular orders, the deposit release date is the same as the invoice date. The deposit is eligible for processing immediately after billing.
	Deferred Orders: For orders containing a deferred payment plan, the deposit release date is either a fixed date or is based on a specific interval. If the date is based on an interval, the interval can be calculated based on order date or invoice date. If the deposit release date is a fixed date, the system compares the fixed date against the invoice date: • If the fixed date is greater than the invoice date, the system will populate the deposit release date with the fixed date. • If the fixed date is less or equal to the invoice date, the system will populate the deposit release date with the invoice date. If the deposit release date is based on an interval and is calculated based on invoice date, the system adds the interval number of days to the invoice date and compares this date against the expiration date: • If the resulting date is less than the expiration date, the system updates the deposit release date with this date. • If the resulting date is equal to or greater than the expiration date, the system will use the expiration date as the deposit release date. • If the expiration date is less than the invoice date, the system will use the invoice date as the deposit release date.
	Installment Orders: For orders using an installment payment plan, the deposit release date is either the next fixed day of the month or is based on a specific interval. If the deposit release date is based on an interval, the system calculates the next installment interval by adding the interval number of days to the current date. If the deposit release date is a fixed date: • If the fixed day of the month has not been reached, the deposit release date is the fixed day of the current month. • If the fixed day of the month is today or in the past, the deposit release date is the fixed day of the next month. • If the expiration date is earlier than the invoice date, the system uses the invoice date as the deposit release date.
	Credit Invoices: For a credit invoice payment method, the deposit release date associated with the original invoice is used as long as that date is on or after the current date. If the deposit release date of the original invoice is earlier than the current date, the deposit release date of the credit invoice is updated with the current date. This ensures that the customer is not credited until he has been billed; but if the customer has been billed, the credit is released immediately. Numeric, 6 positions (in user date format); display-only.

Screen Option	Procedure
Change Invoice Pay Method	Select Change for an invoice payment method to advance to the Change Invoice Pay Method Screen. Error messages: The Change Invoice Pay Method screen might display these error messages when you Select Change for an invoice payment method: Pay category must be credit card. This message indicates that the invoice payment is not a credit card payment type. Invoice (397) has been completely deposited and cannot be changed. This message indicates that the invoice payment associated with a deferred or installment payment plan has been completely deposited. Not authorized to change invoice payment information. This error message indicates that you do not have authority to the Change Invoice Payment Information (A82) secured feature.
Display Invoice Pay Method	Select Display for an invoice payment method to advance to the Display Invoice Pay Method Screen (Reviewing Deposit Information).
Display Deposit History	Select Deposit History for an invoice payment method to advance to the Display Deposit History Screen.
Display Order Payment History	Select Payment History for an invoice payment method to advance to the Display Order Payment History Screen.

Change Invoice Pay Method Screen

Purpose: Use this screen to:

• Review deposit information, such as the total amount to deposit, the amount already deposited and the amount remaining to deposit.

• Review or change the deposit release date, installment information or credit card information.

• Apply a prepaid check or cash payment.

Typically, you use this screen when you receive a rejected deposit for an invoice associated with a deferred or installment payment plan, and you need to change the credit card information before resending the deposit to the service bureau.

Clearing the customer-initiated transaction number: If you use the CyberSource Point-to-Point Integration and you change the credit card number, the customer-initiated transaction number (ci_transaction_id) is cleared. CyberSource passes a new transaction number in the paymentNetworkTransactionID when you authorize the updated payment method.

Note: Depending on the user’s authority to credit card information, the system writes a record to the Credit Card Audit table when this screen is displayed. See Logging Credit Card Data Access in the Data Security and Encryption Guide on My Oracle Support (1988467.1) for more information.

How to display this screen: Select Change for an invoice payment method at the Invoice Pay Summary Screen. You can also advance to this screen by selecting Change for a rejected deposit in Submit Rejected Deposits. See Processing Auto Deposits (SDEP).

Field	Description
Order #	A number the system assigns to uniquely identify the order. Numeric, 8 positions; display-only.
Invoice #	The number the system assigns to a customer's bill or credit. Numeric, 7 positions; display-only.
Pay method	The code and description that represents the method of payment on the order. You can change the payment method associated with this invoice payment method by selecting Change CC# at the Change Invoice Pay Method screen, for example, the customer's credit card was stolen or the credit card was declined. See Changing Credit Card Information for an Invoice Payment Method. Pay methods are defined in and validated against the Pay Type table. See Working with Pay Types (WPAY). Numeric, 2 positions; display-only.
Invoice date	The date you shipped and billed the merchandise. Numeric, 6 positions; display-only.
Total amount (Total amount to deposit)	The total amount to deposit in order for the invoice to be completely deposited. Numeric, 20 positions with a 2-place decimal.
Adjustment (Deposit adjustment amount)	The amount of the deposit that has been changed or is in transition. The system updates the deposit adjustment amount with this information: • written off deposits • debit and credit netting amounts • deposits pending Numeric, 20 positions with a 2-place decimal; display-only.
Amount deposited (Deposit to date)	The total amount deposited to date. When a deposit is confirmed, the system updates this field by the deposit amount. Example: You have an installment payment plan assigned to the order for 3 installments of $30.00 on the 15th of every month. The first installment updates this field to $30.00. The second installment updates this field to $60.00. The third installment updates this field to $90.00. When a deposit is confirmed, the system updates this field with the amount deposited. Numeric, 20 positions with a 2-place decimal; display-only.
Remaining (Deposit remaining amount)	The amount remaining to deposit. The system uses this calculation to determine the deposit remaining amount: deposit amount - amount deposited to date - prepaid amount - adjustment amount = deposit remaining amount Numeric, 20 positions with a 2-place decimal; display-only.
Credit card #	The credit card number the customer used on the order. If you use credit card tokenization, this number may be a token rather than the actual credit card number. You can change the credit card number on the Change Credit Card window. See Changing Credit Card Information for an Invoice Payment Method. Masking: If you do not have authority to the Display Full Credit Card Number (B14) secured feature, the credit card number displays in the format specified at the Credit Card Number Layout Screen for the associated pay type. For example, ************1443 may display instead of the entire credit card number. See Credit Card Number Format for an overview. View authority: If you do not have authority to the Restrict Access to Credit Card Numbers in OI and OM (A88) secured feature, no credit card number is displayed. Alphanumeric, 20 positions; display-only.
Authorization #	The number used to authorize the credit card payment. The original authorization number from pick slip generation is retained and displays for a payment plan order, even after you receive a full authorization for the deposit. You can change the authorization number on the Change Credit Card window. See Changing Credit Card Information for an Invoice Payment Method. Numeric, 16 positions; display-only.
Expiration date	The date the credit card is no longer active. The expiration date might be zero if the Require expiration date flag for the pay type is not selected. For example, a stored value card credit card type typically does not require an expiration date. See Types of Credit Cards for more information. Note: Running the SECRISK periodic function clears the expiration date for closed or canceled orders. For more information, see the Credit Card Retention Days (K65) system control value. You can change the expiration date on the Change Credit Card window. See Changing Credit Card Information for an Invoice Payment Method. If you do not have authority to the Restrict Access to Credit Card Numbers in OI and OM (A88) secured feature, this field is blank. Numeric, 4 positions (MMYY format); display-only.
Authorization date	The date you manually authorize a payment method, or the date the payment method receives an authorization from the authorization service. You can change the authorization date on the Change Credit Card window. See Changing Credit Card Information for an Invoice Payment Method. Numeric, 6 positions (in user date format); display-only.
Issue #	An incremental issue number, assigned by some banks when they replace a card because it is lost or stolen. Debit cards might require a start date, an issue number, both, or neither. The Require issue # flag for the pay type controls whether an issue number is required or optional. You can change the issue number at the Change Credit Card for window. See Changing Credit Card Information for an Invoice Payment Method. Alphanumeric, 2 positions; display-only.
Start date	The first date when the card is effective. The Require start date flag for the pay type controls whether the start date is required or optional. Numeric, 4 positions; display-only.
Deposit release date	This date indicates when the invoice is eligible for deposit. If this date is on or earlier than the current date, the invoice payment is eligible for deposit. The system updates this field when a deposit is confirmed with the next deposit release date if there is a remaining amount to deposit, for example, in installment billing. Regular (non-payment plan) Orders For regular orders, the deposit release date is the same as the invoice date. The deposit is eligible for processing immediately after billing.
	Deferred Orders: For orders using a deferred payment plan, the deposit release date is either a fixed date or is based on a specific interval. If the date is based on an interval, the interval can be calculated based on order date or invoice date. If the deposit release date is a fixed date, the system compares the fixed date against the invoice date: • If the fixed date is later than the invoice date, the system populates the deposit release date with the fixed date. • If the fixed date is on or earlier than the invoice date, the system populates the deposit release date with the invoice date. • If the expiration date is earlier than the invoice date, the system populates the deposit release date with the invoice date. • If the deposit release date is based on an interval and is calculated based on invoice date, the system adds the interval number of days to the invoice date and compares this date against the expiration date: • If the resulting date is earlier than the expiration date, the system updates the deposit release date with this date. • If the resulting date is on or later than the expiration date, the system uses the expiration date as the deposit release date. • If the expiration date is earlier than the invoice date, the system populates the deposit release date with the invoice date.
	Installment Orders: For orders containing an installment payment plan, the deposit release date is either the next fixed day of the month or is based on a specific interval. • If the deposit release date is based on an interval, the system calculates the next installment interval by adding the interval number of days to the current date. • If the deposit release date is a fixed date: - If the fixed day of the month is in the future, the deposit release date is the fixed day of the current month. - If the fixed day of the month is on or earlier than today, the deposit release date is the fixed day of the next month.
	Credit Invoices: For a credit invoice payment method, the deposit release date associated with the original invoice is used as long as that date is on or after the current date. If the deposit release date of the original invoice is earlier than the current date, the deposit release date of the credit invoice is updated with the current date. You might want to change the deposit release date associated with a credit invoice to allow the credit invoice to process before the debit invoice. This ensures that the customer is not credited until he has been billed. Error Messages: An error message indicates if you enter a date that is later than the expiration date associated with the credit card: Deposit Release Date 110199 greater than Expiration Date 599. An error message indicates if you enter a date that is earlier than today's date: Date entered must not be less than today's date Numeric, 6 positions (in user date format); required.
Rejected deposit (Rejected deposit pending)	An informational message informing you a deposit amount has been rejected by the authorization service. When a deposit amount is rejected, the system: • writes an order payment history message • writes a deposit history record Alphanumeric, 25 positions; display-only.
Rejected (Rejected amount)	The deposit amount that has been rejected by the authorization service. Numeric, 20 positions with a 2-place decimal; display-only.
Resubmit	Indicates whether you wish to resubmit the rejected deposit amount for authorization and deposit. Valid values are: • Selected = Resubmit the deposit to the authorization service. The next time you process deposits, the system includes the rejected deposit amount. • Unselected = Do not resubmit the deposit to the authorization service.
Write off	This flag indicates whether you wish to write-off the total amount to deposit for this invoice payment method, for example, there is no chance of collecting the money from the customer. Valid values are: • Selected = Write off the total amount to deposit for this invoice payment method. • Unselected = Do not write off the total amount to deposit for this invoice payment method. Note: When you write-off a deposit amount, the amount is written off immediately.
Amt (Write off deposit amount)	The rejected deposit amount you wish to write off. The system removes the invoice payment method from the Resubmit Reject Deposits screen in Submit Rejected Deposits when you write off a rejected deposit. See Processing Auto Deposits (SDEP). Note: When you select OK to write off a rejected deposit, the write off occurs immediately. Numeric, 20 positions with a 2-place decimal; optional.
Delete	This flag indicates whether you wish to delete the rejected deposit. Valid values are: • Selected = Delete the rejected deposit amount. • Unselected = Do not delete the rejected deposit amount.
# of installments	The total number of installments assigned to this invoice payment method. Installment billing allows you to break the payment evenly into installments (for example, 3 payments on the 1st of each month). This field is used with an installment payment plan only. Numeric, 3 positions; display-only.
# remaining installment	The number of installments remaining. This number is the same as the number of installments when the invoice payment method record is first created and reduces by one each time an installment is sent for deposit. This field is used with an installment payment plan only. Numeric, 3 positions; display-only.
Installment interval	The number of days between installments. The system uses this interval number to determine the next deposit release date if you are basing installment dates on intervals, for example, 3 installments in 30 day intervals. The system determines the installment dates based on the order date. For example, if the order date is 09/01/06, the first installment date would be 09/01/06. The system would determine the next installment date by adding 30 days to the first installment date: 09/01/06 + 30 = 10/01/06. Numeric, 3 positions; display-only.
Fixed installment day	The day of the month when an installment is billed. The system uses the fixed installment date if you have defined a fixed date for each installment. For example, if 15 is defined here, each installment would be due on the 15th of every month. Numeric, 2 positions; display-only.
Pay type	Represents a method of payment on the order. You can enter a prepaid amount by entering a cash/check pay type in this field and entering the amount you wish to prepay in the Prepaid amount field. An error message indicates if you enter a pay type other than pay type 1 (cash/check): Pay category must be '1' Cash/Check. Pay types are defined in and validated against the Pay Type table. See Working with Pay Types (WPAY). Numeric, 2 positions; optional.
Prepaid amount	The amount you wish to prepay for this pay method, for example, the customer's credit card was rejected and the customer decides to send you a check instead. If you enter an amount in this field, the system subtracts the amount from the Deposit amount remaining field. Example: Deposit amount remaining = 130.75 Prepaid amount = 5.00 130.75 - 5.00 = 125.75 (this is the remaining amount to deposit) Numeric, 14 positions; optional.
Prepaid to date	The total amount prepaid to date. Numeric, 20 positions with a 2-place decimal.

Screen Option	Procedure
Work with rejected deposits	See Working with Rejected Deposits.
Change credit card information	Select Change CC#. See Changing Credit Card Information for an Invoice Payment Method.

Working with Rejected Deposits

From the Change Invoice Pay Method Screen you can also resubmit, write off or delete a rejected deposit amount.

To resubmit a rejected deposit:

Select the Resubmit field and select OK. The system sends the rejected deposit amount back to the authorization service for reauthorization. The Rejected amount, Resubmit, Write off, Write off amount and Delete fields are cleared from the screen.

The Change Invoice Payment Method screen displays this error message if you try to reenter the screen and the deposit amount that you have resubmitted completely deposits the amount for the invoice payment:

Invoice has been completely deposited and cannot be changed.

This message displays even if the submitted deposit amount has not been confirmed by the authorization service.

The system also writes an order payment history record indicating the deposit amount was resubmitted.

Note: When you select OK to resubmit, the deposit amount is resubmitted the next time you process deposits.

To write off a rejected deposit:

Select the Write off field and:

• If you wish to write off the remaining amount to deposit for this invoice payment method, select OK. You return to the Invoice Pay Summary screen.

• If you wish to write off a specific amount, enter this amount in the Write off amount field and select OK. The Confirm Accept window prompts you for confirmation.

When you write off a deposit amount:

• The system updates the Adjustment field with the rejected deposit amount. If you did not enter a specific write off amount, this is the amount remaining to deposit. If you entered a specific write off amount, this is the amount you entered in the Write off amount field.

• The system updates the Remaining field with the amount remaining to deposit. The system determines the remaining amount to deposit using this calculation:

total amount to deposit - write off amount = remaining amount to deposit

For a deferred payment plan:

If the invoice payment method is associated with a deferred payment plan, the system updates the Adjustment field with the write off amount and updates the Remaining field with the remaining amount to deposit, if any.

Example:

Total amount to deposit = 69.00

Rejected deposit amount = 69.00

Write off amount = 30.00

In this situation, the system updates the Adjustment amount field to 30.00 (the write off amount) and updates the Remaining field with 39.00 using this calculation:

total amount to deposit (69.00) - write off amount (30.00) = remaining amount to deposit (39.00)

When you receive an authorization for the deposit, the system updates:

• the Amount deposited field to 39.00

• the Remaining field to .00

• the Adjustment field remains at 30.00 (this is the write off amount)

For an installment payment plan:

If the invoice payment method is associated with an installment payment plan, the system updates the Adjustment field with the write off amount and updates the Remaining field with the remaining amount to deposit, if any. If there is a remaining amount to deposit, the system redistributes the amount remaining across the remaining installment intervals.

Example:

Total amount to deposit = 69.00

Number of installments = 3

Installment amount = 23.00

Rejected deposit amount = 23.00

Write off amount = 30.00

In this situation, the system updates the Adjustment amount field to 30.00 (the write off amount) and updates the Remaining field with 39.00 using this calculation:

total amount to deposit (69.00) - write off amount (30.00) = remaining amount to deposit (39.00)

The system also updates the Installment amount for the remaining installment intervals to 19.50 using this calculation:

remaining amount to deposit (39.00) / the number of remaining installments (2) = installment amount (19.50)

When you receive an authorization for the deposit, the system:

• updates the Amount deposited field to 19.50

• updates the Remaining field to 19.50 (this is the amount of the next installment)

• decreases the Number of remaining installments field by 1

• leaves the Adjustment field at 30.00 (this is the write off amount)

Note: If you write off the remaining amount to deposit for this invoice payment method, the system updates the Adjustment field with the amount remaining to deposit plus the rejected deposit amount and updates the Remaining field with the rejected deposit amount.

To delete a rejected deposit:

Select the Delete field. The system deletes the rejected deposit amount and displays the message Deleted. No further deposits. at the Change Invoice Pay Method screen.

Changing Credit Card Information for an Invoice Payment Method

Purpose: You can change credit card information at the Change Credit Card window. A history message is written, indicating CC# has been changed. You can review this history at the Display Order Payment History Screen.

Note: Depending on the user’s authority to credit card information, the system writes a record to the Credit Card Audit table when this window is displayed. See Logging Credit Card Data Access in the Data Security and Encryption Guide on My Oracle Support (1988467.1) for more information.

How to display this window: Select Change CC# at the Change Invoice Pay Method Screen.

Note: If you do not have access to the Restrict Access to Credit Card Numbers in OI and OM (A88) secured feature, the system displays an error message: You are not authorized to change Credit Card #.

Field	Description
Pay method	The code and description that represents the method of payment on the order. Error messages: If you entered a payment method other than a credit card: Pay category must by credit card. If you entered a pay method that is associated with a credit card authorization and deposit service different from the original credit card: Auth Service Code must match Original Service Code. Pay methods are defined in and validated against the Pay Type table. See Working with Pay Types (WPAY). Numeric, 2 positions; required.
Credit card #	The credit card number the customer used on the order. Tokenization: If you change the credit card number and the Request token field for the service bureau associated with the pay type is selected, the system sends a Token Request to the service bureau to replace the credit card number with token; see Credit Card Tokenization in the Data Security and Encryption Guide on My Oracle Support (1988467.1) for more information. Masking: If you do not have authority to the Display Full Credit Card Number (B14) secured feature, the credit card number displays in the format specified at the Credit Card Number Layout Screen for the associated pay type. For example, ************1443 may display instead of the entire credit card number. See Credit Card Number Format for an overview. For added security, you can run the SECRISK periodic to permanently remove the first 12 digits of credit card numbers. The numbers are no longer displayed, regardless of authority. For more information, see the Credit Card Retention Days (K65) system control value. Alphanumeric, 20 positions; required.
Expiration date	The date the credit card is no longer active. The Require expiration date flag for the pay type controls whether an expiration date is required. For example, a stored value card credit card type typically does not require an expiration date. See Types of Credit Cards for more information. Numeric, 4 positions (MMYY format); required or optional.
Issue #	An incremental issue number, assigned by some banks when they replace a card because it is lost or stolen. Debit cards might require a start date, an issue number, both, or neither. The Require issue # flag for the pay type controls whether an issue number is required or optional. It is important to enter the issue number exactly as it appears on the card. For example, an issue number of 1 is different from an issue number of 01; also, an issue number of 0 is different from a blank issue number. Each bank has its own requirements and conventions regarding issue number. If an issue number is required but not entered in order entry or order maintenance, the system displays an error message: Credit card issue# () is not valid. Note: An entry of 00 (two zeros) is not considered a valid issue number. Alphanumeric, 2 positions; required or optional.
Start date	The first date when the card is effective. The Require start date flag for the pay type controls whether the start date is required or optional. You might use a start date for a debit card to indicate the first date when the card is effective. If a start date is required but not entered, the system displays an error message in order entry or maintenance: Credit card start date (0) is not valid. Note: • Even if you require a start date for a pay type, the system does not validate the credit card based on whether the start date is before or after the current date. Typically, if your authorization service requires a start date for this pay type, the service would validate the start date provided against the current date. • Debit cards might require a start date, an issue number, both, or neither. Even if a start date or an issue date are not required, you can still enter this information in order entry if it is available. Numeric, 4 positions; required or optional.
Authorization #	The number used to authorize the credit card payment. The original authorization number from pick slip generation is retained and displays for a payment plan order, even after you receive a full authorization for the deposit. Numeric, 16 positions; optional.
Authorization date	The date you manually authorize a payment method, or the date the payment method receives an authorization from the authorization service. Numeric, 6 positions (in user date format); optional.

Display Invoice Pay Method Screen (Reviewing Deposit Information)

Purpose: Use this screen to review:

• deposit information, such as the total amount to deposit, the amount already deposited and the amount remaining to deposit

• the deposit release date, installment information or credit card information

• the prepaid check or cash payment

How to display this screen: Select Display for an invoice payment method at the Invoice Pay Summary Screen.

Field descriptions: See Change Invoice Pay Method Screen for a description of the other fields on this screen.

Field	Description
Installment (Installment amount)	The amount due for the next installment. This field displays only for invoice payment methods associated with an installment payment plan. Numeric, 20 positions with a 2-place decimal; display-only.
Schedule (Installment scheduled date)	The deposit date for the next installment. This date indicates when the invoice is eligible for deposit. If this date is equal to or prior to the current date, the invoice payment is eligible for deposit. The system updates this field when a deposit is confirmed with the next deposit date if there is a remaining amount to deposit. The system updates this field to 99/99/99 when a deposit amount is rejected. This field displays only for invoice payment methods associated with an installment payment plan. Numeric, 6 positions (in user date format); display-only.

Field

Description

Installment (Installment amount)

The amount due for the next installment.

This field displays only for invoice payment methods associated with an installment payment plan.

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

Schedule (Installment scheduled date)

The deposit date for the next installment.

This date indicates when the invoice is eligible for deposit. If this date is equal to or prior to the current date, the invoice payment is eligible for deposit.

The system updates this field when a deposit is confirmed with the next deposit date if there is a remaining amount to deposit.

The system updates this field to 99/99/99 when a deposit amount is rejected.

This field displays only for invoice payment methods associated with an installment payment plan.

Numeric, 6 positions (in user date format); display-only.

Display Deposit History Screen

Purpose: Use this screen to review invoice deposit attempts and responses.

How to display this screen: Select Deposit History for an invoice payment method at the Invoice Pay Summary Screen or the Display Order Payment Methods Screen.

Field	Description
Order #	A number the system assigns to uniquely identify an order. Numeric, 8 positions; display-only.
Pay type	Represents the method of payment on the order. Pay methods are defined in and validated against the Pay Type table. See Working with Pay Types (WPAY). Numeric, 2 positions; display-only.
Issue #	An incremental issue number, assigned by some banks when they replace a card because it is lost or stolen. Debit cards might require a start date, an issue number, both, or neither. The Require issue # flag for the pay type controls whether an issue number is required or optional. It is important to enter the issue number exactly as it appears on the card. For example, an issue number of 1 is different from an issue number of 01; also, an issue number of 0 is different from a blank issue number. Each bank has its own requirements and conventions regarding issue number. If an issue number is required but not entered in order entry or order maintenance, the system displays an error message: Credit card issue# () is not valid. Note: Debit cards might require a start date, an issue number, both, or neither. Even if a start date or an issue date are not required, you can still enter this information in order entry if it is available. Alphanumeric, 2 positions; display-only.
Start date	The first date when the card is effective. The Require start date flag for the pay type controls whether the start date is required or optional. You might use a start date for a debit card to indicate the first date when the card is effective. Numeric, 4 positions; display-only.
Credit card #	The credit card number the customer used on the order. If you use credit card tokenization, this number may be a token rather than the actual credit card number. Masking: If you do not have authority to the Display Full Credit Card Number (B14) secured feature, the credit card number displays in the format specified at the Credit Card Number Layout Screen for the associated pay type. For example, ************1443 may display instead of the entire credit card number. See Credit Card Number Format for an overview. If you do not have authority to the Restrict Access to Credit Card Numbers in OI and OM (A88) secured feature, this field is blank. Alphanumeric, 20 positions; display-only.
Exp date	The date the credit card is no longer active. The expiration date may be zero, depending on the setting of the Require expiration date flag for the pay type or whether it was removed by the SECRISK periodic function. See the Credit Card Retention Days (K65) system control value for more information. For example, a stored value card credit card type typically does not require an expiration date. See Types of Credit Cards for more information. You can change the expiration date on the Change Credit Card window. See Changing Credit Card Information for an Invoice Payment Method. Numeric, 4 positions (MMYY format); display-only.
Invoice #	The number the system assigns to a customer's bill or credit. The system generates an invoice during billing. Numeric, 7 positions; display-only.
Type (Transaction type)	Indicates the type of deposit. Valid values are: • PURCH = Purchase deposit, indicating a debit. • RETURN = Return deposit, indicating a credit. Alphanumeric, 10 positions; display-only.
Date (Deposit created date)	The date when this deposit history record was created. This is the date when the invoice pay method was deposited. The deposit created date ensures that the deposit is not sent again. Numeric, 6 positions (in user date format); display-only.
Amount (Deposit amount)	The amount deposited. The system uses this calculation to determine the amount to deposit: For deferred payment plans: prepaid amount - adjustment amount - total amount deposited to date = deposit amount For installment payment plans: prepaid amount - adjustment amount - total amount deposited to date / intervals remaining = deposit amount Numeric, 20 positions with a 2-place decimal; display-only.
Status (Deposit status)	The status of this deposit: • Confirmed = The service bureau confirmed the deposit. • Deleted = The user deleted a rejected deposit. • Forced = The deposit was rejected, but was forced through deposit (the Forced deposit field for the authorization service is selected). • Manual Confirmed = The user manually confirmed the deposit through Submit Rejected Deposits. • Prepaid = The user entered a prepaid adjustment amount. • Resubmitted = The deposit was resubmitted for deposit. • Sent = The deposit is in the process of being sent to the service bureau. • Unconfirmed = The deposit is unconfirmed by the service bureau. • Written Off = The user wrote off a rejected deposit. • blank = The deposit has not yet been sent to the service bureau. Display-only.
Response (Vendor response code)	A code assigned by the authorization service that identifies whether the credit card deposit was authorized and approved or declined, and the reason for the authorization decline. Vendor response codes are defined in and validated against the Authorization Service Vendor Response table. See Defining Vendor Response Codes. Alphanumeric, 10 positions; display-only.
Bill mthd (Flexible payment bill method)	A code that identifies whether this deposit is related to a deferred or installment payment plan. Valid values: • blank = This is a regular deposit; no payment plans are associated with this deposit. • D = This is a deferred billing deposit. • I = This is an installment billing deposit. The system uses this code to sort deposit records. Alphanumeric, 1 position; display-only.

Screen Option	Procedure
Display deposit history detail	Select Details for a deposit to advance to the Display Deposit History Detail Screen.

Display Deposit History Detail Screen

Purpose: Use this screen to review the deposit history details, such as the action code and the deposit service associated with this deposit.

How to display this screen: Select Details for a deposit at the Display Deposit History Screen.

If you do not have authority to the Restrict Access to Credit Card Numbers in OI and OM (A88) secured feature, the system displays a message: You are not authorized to display payment history.

Field	Description
Order #	A number the system assigns to uniquely identify an order. Numeric, 8 positions; display-only.
Invoice #	The number the system assigns to a customer's bill or credit. Numeric, 7 positions; display-only.
Merchant ID (Merchant identification code)	The account number assigned by the service bureau to identify transmissions to and from your company. Alphanumeric, 20 positions; display-only.
Issue #	An incremental issue number, assigned by some banks when they replace a card because it is lost or stolen. Debit cards might require a start date, an issue number, both, or neither. The Require issue # flag for the pay type controls whether an issue number is required or optional. It is important to enter the issue number exactly as it appears on the card. For example, an issue number of 1 is different from an issue number of 01; also, an issue number of 0 is different from a blank issue number. Each bank has its own requirements and conventions regarding issue number. If an issue number is required but not entered in order entry or order maintenance, the system displays an error message: Credit card issue# () is not valid. Note: Debit cards might require a start date, an issue number, both, or neither. Even if a start date or an issue date are not required, you can still enter this information in order entry if it is available. Alphanumeric, 2 positions; display-only.
Start date	The first date when the card is effective. The Require start date flag for the pay type controls whether the start date is required or optional. You might use a start date for a debit card to indicate the first date when the card is effective. Numeric, 4 positions; display-only.
Credit card #	The credit card number sent to be deposited. If you use credit card tokenization, this number may be a token rather than the actual credit card number. You can change the credit card number on the Change Credit Card window. See Changing Credit Card Information for an Invoice Payment Method. Masking: If you do not have authority to the Display Full Credit Card Number (B14) secured feature, the credit card number displays in the format specified at the Credit Card Number Layout Screen for the associated pay type. For example, ************1443 may display instead of the entire credit card number. See Credit Card Number Format for an overview. Alphanumeric, 20 positions; display-only.
Exp date	The date the credit card is no longer active. The expiration date may be zero, depending on the setting of the Require expiration date flag for the pay type. For example, a stored value card credit card type typically does not require an expiration date. See Types of Credit Cards for more information. You can change the expiration date on the Change Credit Card window. See Changing Credit Card Information for an Invoice Payment Method. Numeric, 4 positions (MMYY format); display-only.
Deposit amount (Deposit amount)	The amount deposited or the amount sent to be deposited. The system uses this calculation to determine the amount to deposit: For deferred payment plans: prepaid amount - adjustment amount - total amount deposited to date = deposit amount For installment payment plans: prepaid amount - adjustment amount - total amount deposited to date / intervals remaining = deposit amount Numeric, 20 positions with a 2-place decimal; display-only.
Deposit date (Deposit created date)	The date when this deposit history was created. This is the date when the invoice pay method was deposited. The deposit created date ensures that the deposit is not sent again. Numeric, 6 positions (in user date format); display-only.
Transaction type (Transaction type)	Indicates the type of deposit. Valid values are: • PURCH = Purchase deposit • RETURN = Return deposit Alphanumeric, 10 positions; display-only.
Response code (Vendor response code)	A code assigned by the authorization service that identifies whether the credit card deposit was authorized and approved or declined, and the reason for the authorization decline. Vendor response code are defined in and validated against the Authorization Service Vendor Response table. See Defining Vendor Response Codes. Note: In order to see the full vendor response code description, a Description must be defined for the response code on the Work with Vendor Response Screen. Alphanumeric, 10 positions; display-only.
Action code	A code set to the deposit service indicating the action to take for reauthorization. Valid values are: • Authorize and Deposit = The deposit requires an authorization before it can be processed. The system sends a code of B (Authorize and Deposit) for: • all payment plan deposits except for the first deposit of an installment plan, when a code of D is sent. • any regular (non-pay plan) deposit whose authorization has expired. You can review the authorization expiration date at the Authorization History Details Window. Additionally, the system updates the Authorization History record with the new authorization number. • Deposit = The deposit does not require authorization and can be processed. The system sends a code of D for all regular deposits, assuming there is an authorization number in the Invoice Pay Method table and the authorization has not expired. If there is no authorization number, the system sends a code of B (Authorize and Deposit). Alphanumeric, 1 position; display-only.
Authorization code	The authorization code sent with this deposit. This code indicates that the amount to charge for this credit card has been authorized manually or through a credit card authorization service. Alphanumeric, 16 positions; display-only.
Billing method (Flexible payment bill method)	A code that identifies whether this deposit is related to a deferred or installment payment plan. Valid values: • blank = This is a regular deposit; no payment plans are associated with this deposit. • Deferred = This is a deferred billing deposit. • Installment = This is an installment billing deposit. The system uses this code to sort deposit records. Display-only.
Deposit service	A code for the service bureau that performs credit card deposits for this pay type. Alphanumeric, 3 positions; display-only.
Deposit status	The status of this deposit. Valid values are: • Confirmed = The service bureau confirmed the deposit. • Deleted = The user deleted a rejected deposit. • Forced = The deposit was rejected, but was forced through deposit (the Forced deposit field for the authorization service is selected). • Manual Confirmed = The user manually confirmed the deposit through Submit Rejected Deposits. • Prepaid = The user entered a prepaid adjustment amount. • Resubmitted = The deposit was resubmitted for deposit. • Sent = The deposit is in the process of being sent to the service bureau. • Unconfirmed = The deposit is unconfirmed by the service bureau. • Written Off = The user wrote off a rejected deposit. • blank = The deposit has not yet been sent to the service bureau. Display-only.

Display Order Payment History Screen

Purpose: Use this screen to review messages written by the system describing changes in payment and invoice activity for the order. The system records all activity associated with the order payment method or invoice payment method defined for the order on this screen, such as:

• deposits made

• invoices netted against each other

• changes made by users

• deactivation of a pay type

• adding, changing, or deleting the payment plan associated with the payment type on the order

How to display this screen: Select Payment History for a payment at the Invoice Pay Summary Screen or the Display Order Payment Methods Screen.

Note: If you do not have authority to the Restrict Access to Credit Card Numbers in OI and OM (A88) secured feature, the system displays a message: You are not authorized to display payment history..

Field	Description
Order #	A number the system assigns to uniquely identify an order. Numeric, 8 positions; display-only.
Invoice #	The number the system assigns to a customer's bill or credit. This is the invoice number associated with an invoice payment method that has been updated. Numeric, 7 positions; display-only.
Pay type	The code and description of the pay type assigned to this order. Pay type codes are defined in and validated against the Pay Type table. See Working with Pay Types (WPAY). Pay type code: numeric, 2 positions; display-only. Pay type description: alphanumeric, 30 position; display-only.
Date	The date when the transaction occurred. Numeric, 6 positions (in user date format); display-only.
Typ (Transaction type)	Indicates the type of transaction that occurred. Valid values are: • A = CC# has been changed. You can change the credit card number at the Change Invoice Pay Method Screen or the Enter Credit Card Pop-Up window. • B = billing • C = credit check • D = deposit • M = maintenance • N = net Deposit split for PayPal? See Applying Refunds Across Multiple Capture Transaction IDs for a discussion of how refunds can be applied across multiple transactions for PayPal. Alphanumeric, 1 position; display-only.
Note (Transaction note)	A system-generated description of the transaction. Alphanumeric, 40 positions; display-only.
Invoice	The invoice number associated with an updated invoice payment method. Numeric, 7 positions; display-only.
User	The user ID of the operator responsible for the transaction. Alphanumeric, 10 positions; display-only.

Screen Option	Description
Switch views between order and invoice payment history and invoice payment history only	Select Payment History. The system displays order and invoice payment history records or invoice payment history records only. When you review invoice history records only, the system displays a message to the right of the Invoice number field: Invoice Notes Only.

Reviewing Payment Methods

Display Order Payment Methods Screen

Purpose: This screen lists all of the methods of payment used on the order. Payment methods apply across recipients. The screen does not display refunds or balance due pay types.

How to display this screen: Select Pay Methods from the Order Inquiry Header Screen or Order Inquiry Detail Screen.

Field	Description
Order #	A unique number the system assigns to the order. You will not see a ship-to suffix with the order number on this screen because payment methods apply across all recipients. Numeric, 8 positions; display-only.
Sold to	The name of the customer or company who placed the order. Alphanumeric, 41 positions; display-only.
Ship to	The name of the customer or company to receive the order. Alphanumeric, 41 positions; display-only.
Payment method (unlabeled)	Represents the method of payment on an order. Pay types codes are defined in and validated against the Pay Type table. See Working with Pay Types (WPAY). Numeric, 2 positions; display-only.
Payment method	A description of the pay type, and information such as the credit card number and expiration date, that is associated with the payment type. If you use credit card tokenization, the credit card number may be a token rather than the actual credit card number. If you do not have authority to the Display Full Credit Card Number (B14) secured feature, the credit card number displays in the format specified at the Credit Card Number Layout Screen for the associated pay type. For example, ************1443 may display instead of the entire credit card number. See Credit Card Number Format for an overview. If you do not have authority to the Restrict Access to Credit Card Numbers in OI and OM (A88) secured feature, the credit card number and expiration date are not displayed. Alphanumeric, 30 characters; display-only.
Amount	Three fields that identify the: Amount to charge The total value charged to the payment method. If no value appears, then this payment type serves as a “catch-all,” meaning any amount not assigned to another payment method applies to this one. Amount billed The amount that applies to the payment method that has been billed to the customer. For credit card payments, this is the total amount billed to the credit card. The system updates this amount as soon as the card is billed even before you process deposits. If you are using deferred or installment billing, the total amount to charge the card displays, even if the total amount has not yet been billed.
	Note: If this is a prepay amount, and part of the prepayment total was applied to a membership program, only the remaining amount appears as the amount to charge or amount billed. For example, if the customer sent a check for $100.00 and $80.00 was applied to the membership program, $20.00 appears here. See Membership Overview. Amount credited The amount that has been credited to the payment method in the event of a return, overpayment, cancellation, or sellout. Numeric, 20 positions with a 2-place decimal; display-only.
Chg seq (Charge sequence)	A number that designates the order of use for the payment method, from zero to 99. The catch-all account must have the highest charge sequence. A charge sequence of 99 indicates that the payment method has been deactivated on the order; see Enter Payment Methods Screen in Order Maintenance. Numeric, 2 positions; display-only.
Pay plan (Payment plan code)	A code that identifies the payment plan associated with the payment method on this order. Payment plan codes are defined in and validated against the Flexible Payment Options table. See Working with Flexible Payment Options (WFPO). Alphanumeric, 6 positions; display-only.
CC Last 4	The last four positions of the credit card number. From the CC Last 4 field in the Order Payment Method table. If you use credit card encryption, the system does not encrypt the value in this field. Alphanumeric, 4 positions; display-only.

Screen Option	Procedure
Review order pay type detail	Select Display Detail to advance to the Display Order Pay Type Screen (1 of 2).
Review credit authorization history	Select Display authorization history to advance to the Display Authorization History Screen.
Review contributions	Select Display contributions to advance to the Display Contributions Screen if the customer made a contribution using that payment type. If the customer has not used that payment type to make a contribution, a message displays: No Contributions Exist.
Display deposit history	Select Display Deposit History to advance to the Display Deposit History Screen.
Display payment history	Select Display payment history to advance to the Display Order Payment History Screen.

Display Order Pay Type Screen (1 of 2)

Purpose: Use this screen to view order pay type detail. This screen displays the specific properties or characteristics that comprise the order payment method you selected.

Additional order pay type information: Select OK to advance to the Display Order Pay Type Screen (2 of 2).

How to display this screen: Select Details for a payment method at the Display Order Payment Methods Screen.

Field	Description
Order #	A unique number assigned to the order. Numeric, 7 positions; display-only.
Sold to	The sold to customer defined for this order. Last name: Alphanumeric, 25 positions; display-only. First name: Alphanumeric, 15 positions; display-only. Middle initial: Alphanumeric, 1 position; display-only.
Pay type	The pay type code and description associated with this order. Pay type codes are defined in and validated against the Pay Type table. See Working with Pay Types (WPAY). Pay type code: Numeric, 2 positions; display-only. Pay type description: Alphanumeric, 30 positions; display-only.
Amount to charge	The total amount that applies as a charge to the payment method shown. If this field is blank, the balance of the charge for the order applies to the payment method. The balance charge occurs after charges to all other pay types on the order have reached their defined limit. Numeric, 20 positions with a 2-place decimal; display-only.
Amount authorized	The amount authorized for the credit card payment. The system updates this field: • when the system creates a pre-generated pick for the order in an H Generated Has Authorization status. This field remains blank: • if the payment is not a pay category 2 credit card pay type. • if a pre-generated pick is not created for the order. • when the system creates a pre-generated pick for the order in a G Generated No Authorization status; in this situation, the system updates this field when you print the pick slip. Numeric, 20 positions with a 2-place decimal; display-only.
Amount billed	The amount that has already been billed against this pay method. For credit card payments, this is the total amount billed to the credit card. The system updates this amount as soon as the card is billed even before you process deposits. If you are using deferred or installment billing, the total amount to charge the card displays, even if the total amount has not yet been billed. Note: If this is a prepay amount, and part of the prepayment total was applied to a membership program, only the remaining amount appears as the amount to charge or amount billed. For example, if the customer sent a check for $100.00 and $80.00 was applied to the membership program, $20.00 appears here. See Membership Overview. Numeric, 20 positions with a 2-place decimal; display-only.
Amount collected	The amount you have received from the customer. An amount is collected when: • A shipment is billed using a credit card payment type (Note: This field is updated before you process deposits, and the update occurs regardless of whether the credit card uses a deferred or installment payment plan or is set up for immediate deposit) • Cash amount is entered for a prepaid order Check and cash amounts are collected immediately, while credit card amount will not be visible until billing occurs.
	For credit card payments, the system updates this amount as soon as the card is billed even before you process deposits. If you are using deferred or installment billing, the total amount to charge the card displays, even if the total amount has not yet been collected. Note: If this is a prepay amount, and part of the prepayment total was applied to a membership program, only the remaining amount appears as the amount to charge or amount billed. For example, if the customer sent a check for $100.00 and $80.00 was applied to the membership program, $20.00 appears here. See Membership Overview. Numeric, 20 positions with a 2-place decimal; display-only.
Amount credited	The amount from this payment type that the customer has received as credit or refund, represented by the creation of a refund in the Refund table. This information is updated when the refund is processed or the refund check is cut. Numeric, 20 positions with a 2-place decimal; display-only.
Charge sequence	A number that designates the order in which a payment method is used. Numeric, 1 position; display-only.
Cash applied date	The month, day, and year you applied a cash (prepaid) payment to the order. Numeric, 6 positions; display-only.
Routing # (Routing number)	Check interface: An informational field that represents the routing number for the check interface pay type from the Check Interface Payment Type (G26) system control value. Alphanumeric, 9 positions; display-only.
Acct # (Checking account number)	Check interface: An informational field that represents the checking account number for the check interface pay type from the Check Interface Payment Type (G26) system control value. Alphanumeric, 20 positions; display-only.
Check # (Check number)	An informational field that represents the check number for the check interface pay type from the Check Interface Payment Type (G26) system control value. Numeric, 6 positions; display-only.
Check download date (Check interface download date)	Not implemented. Numeric, 6 positions (in user date format); display-only.
Credit card #	The credit card number the customer used on the order. If you use credit card tokenization, this number may be a token rather than the actual credit card number. You can change the credit card number on the Change Credit Card window. See Changing Credit Card Information for an Invoice Payment Method. Masking: If you do not have authority to the Display Full Credit Card Number (B14) secured feature, the credit card number displays in the format specified at the Credit Card Number Layout Screen for the associated pay type. For example, ************1443 may display instead of the entire credit card number. See Credit Card Number Format for an overview. For added security, you can run the SECRISK periodic to permanently remove the first 12 digits of credit card numbers. The numbers are no longer displayed, regardless of user authority. For more information, see the Credit Card Retention Days (K65) system control value. If you do not have authority to the Restrict Access to Credit Card Numbers in OI and OM (A88) secured feature, this field is blank. Alphanumeric, 20 positions; display-only.
Authorization date	The month, day, and year that your credit card authorization service confirmed or authorized the customer's credit card for the order, or you manually authorized the credit card. Numeric, 6 positions; display-only.
Expiration date	The date the credit card is no longer active. The expiration date may be zero, depending on the setting of the Require expiration date flag for the pay type. For example, a stored value card credit card type typically does not require an expiration date. See Types of Credit Cards for more information. You can change the expiration date on the Change Credit Card window. See Changing Credit Card Information for an Invoice Payment Method. If you do not have authority to the Restrict Access to Credit Card Numbers in OI and OM (A88) secured feature, this field is blank. Numeric, 4 positions (MMYY format); display-only.Numeric, 4 positions; display-only.
CC Last 4	The last four positions of the credit card number. From the CC Last 4 field in the Order Payment Method table. If you use credit card encryption, the system does not encrypt the value in this field. Alphanumeric, 4 positions; display-only.
Authorization number	The number you used when you manually authorized the credit card, or the authorization service assigned when authorizing the credit card. The number can be overridden for manual or authorization service updates, and clears when the order is purged. For orders using a payment plan, the system retains the original authorization number from pick slip generation, even after you receive a full authorization for deposit. Alphanumeric, 16 positions; display-only.
Card security value	The credit card’s security value. Note: The card security value is only available for online authorizations; once an order is accepted, the system removes the card security value from the order, even if the order has not received an approved online authorization. American Express: The card security value, or CID (card identification number), is a 4-digit number imprinted, not embossed, on an American Express credit card. The card security value displays above and to the right of the imprinted credit card number on the front of the card. Discover: The card security value, or CID (card identification number), is a 3-digit number in reverse indent printing located on the signature panel on the reverse side of the credit card following the account number. VISA: The card security value, or CVV2 (card verification value), is a 3-digit number in reverse indent printing located on the signature panel on the reverse side of the credit card following the account number. MasterCard: The card security value, or CVC2 (card validation code), is a 3-digit number in reverse indent printing located on the signature panel on the reverse side of the credit card following the account number. Reducing fraud: Authorization services use credit card security to help reduce fraud by verifying that the credit card is present at the point of sale and to ensure that the credit card data from the transaction matches the data stored by the authorization service for that card.
	The card security value and card security presence are used for the processing of VISA, Discover, MasterCard, and American Express online authorization transactions only; the card security value and presence are informational-only for every other credit card transaction. The card security response received for the authorization is stored in the Vendor response 2 field in the Authorization History table. Note: The system removes the card security value from an order when the order is accepted, even if an approved online authorization has not been received on the order; no message is written to Order History. Card security processing is not available during batch authorization or deposit processing. See Credit Card Security Service (CID, CVV2, CVC2). Numeric, 4 positions; display-only.
Authorization amount	The amount for this payment method that your authorization service has approved. This field is updated by the Auto Authorization function, and clears when the order is purged. Numeric, 20 positions with a 2-place decimal; display-only.
Card security presence	Indicates to the authorization service whether a card security value (CID, CVV, CVC) is present on the credit card. If a card security presence exists for the credit card payment method, the authorization service performs card security identification. Valid values: • Value Present = card security value is present on the credit card. • Value Illegible = card security value is present on the credit card, but is illegible. • No Value = card security value is not present on the credit card. See Credit Card Security Service (CID, CVV2, CVC2). Numeric, 1 position; display-only.
Issuing bank	The description of the bank issuing the credit card. This field is not currently implemented. Alphanumeric, 10 positions; display-only.
Issue #	An incremental issue number, assigned by some banks when they replace a card because it is lost or stolen. Debit cards might require a start date, an issue number, both, or neither. The Require issue # flag for the pay type controls whether an issue number is required or optional. Alphanumeric, 2 positions; display-only.
Start date	The first date when the card is effective. The Require start date flag for the pay type controls whether the start date is required or optional. You might use a start date for a debit card to indicate the first date when the card is effective. Numeric, 4 positions; display-only.
Hold reason	Represents why the pay type is on hold. Pay type holds include: • PT = Pay Type hold is a hold reason code that the system displays when the order is on pay type hold and no other hold exists. • Prepaid order holds: • TM = Time hold. The system assigns this hold when you specify a check hold time period in the Pay Type table. The hold remains in effect until the time period lapses or you manually release the hold through the Release Held Orders program, whichever occurs first. • KF = Check fraud. A hold that the system assigns when the micra number on a check meets a fraud condition that you defined in the Miscellaneous Fraud table.
	• BD = Balance due. A hold that refers to an outstanding balance or amount unpaid that exceeds an amount limit or percentage you established in the Pay Type table. This hold applies when the only pay type on the order is cash. Credit card holds: • AV = AVS hold. A credit card pay type hold that the system assigns when the credit card fails address verification. • CF = Credit card fraud. A credit card pay type hold that applies when you have entered the credit card number in the Miscellaneous Fraud • PV = Pay Plan Velocity Hold. A hold that the system assigns when a credit card has been used too many times within a specified period for an order containing a deferred or installment payment plan. • P$= Pay Plan Dollar Threshold. A hold that the system assigns when the total amount and invoice amount outstanding for a sold to customer on orders containing a deferred or installment payment plan exceeds the Dollar Threshold for Sold To Customer Orders with Flexible Payments (F54) system control value. • W = Waiting for credit authorization. A hold that applies to an order waiting for authorization from a credit checking service bureau from the Pay Type table. CW hold will not prevent the order from processing. See Releasing Held Orders. User-defined holds: A user-defined hold reason displays here if, for example, the pay type was declined by the authorization service and you associated the vendor response with a unique pay type hold reason. See the Hold date field. Alphanumeric, 2 positions; display-only.

Hold until	The date when the order is eligible for release through the Release Orders on Time Hold Periodic Function. You can assign a number of days for the system to add when calculating the hold date to each response code you receive from an authorization service. See Defining Vendor Response Codes for more information on setting up vendor responses for authorization services, and releasing orders from time hold. Numeric, 6 positions (in user date format); display-only.

Display Order Pay Type Screen (2 of 2)

Purpose: Use this screen to review order pay type detail related to deferred or installment pay plans.

How to display this screen: Select OK at the Display Order Pay Type Screen (1 of 2).

Field	Description
Order #	A unique number assigned to the order. Numeric, 7 positions; display-only.
Sold to	The sold to customer defined for this order. Last name: Alphanumeric, 25 positions; display-only. First name: Alphanumeric, 15 positions; display-only. Middle initial: Alphanumeric, 1 position; display-only.
Pay type	The pay type code and description associated with this order. Pay type codes are defined in and validated against the Pay Type table. See Working with Pay Types (WPAY). Pay type code: Numeric, 2 positions; display-only. Pay type description: Alphanumeric, 30 positions; display-only.
Pay plan code	The payment plan code and description associated with the pay type on this order. Payment plan codes are defined in and validated against the Flexible Payment Options table. See Working with Flexible Payment Options (WFPO). Pay plan code: Alphanumeric, 5 positions; display-only. Pay plan description: Alphanumeric, 40 positions; display-only.
Suppress deposit	Indicates whether the system will include this invoice payment method when you run Processing Auto Deposits (SDEP). Valid values are: • Selected = The system will not attempt to deposit this payment method. • Unselected = This payment method will be included when you process deposits. The system determines how to set this flag based on the setting of the Suppress deposit flag at the Display Order Pay Type Screen (1 of 2). This field can be selected if: • you create the order through the Generic Order Interface (Order API); see Suppressing Deposits and Refunds for an overview. • this is a ship-for-pickup order, and the Payment at POS for Ship for Pickup Orders (L60) system control value is selected. See that system control value for background. Only credit card payment methods can have this flag selected. This flag is selected only for the first time that you bill against the payment method; afterward, the system resets the flag for the payment method to Unselected. Once you bill this payment method, the system resets this flag to Unselected.
Suppress refund	Indicates whether the system will ever generate a refund for this payment method. Valid values are: • selected = The system will never generate a refund to the customer for this payment method; instead, any refund will be created in a cancel pending status, and canceled when you process refunds. In addition, if the return disposition code assigned to the return matches the return disposition code defined in the Return Disposition Code to Exclude in ORCE Sales Feed (M22) system control value, the system excludes the return (credit) invoice from the Customer Engagement Sales Feed and does not generate a return confirmation for the return. • unselected = Refunds will be created if appropriate based on normal processing. This flag can be selected if: • you create the order through the Generic Order Interface (Order API); see Suppressing Deposits and Refunds for an overview. • this is a ship-for-pickup order, and the Payment at POS for Ship for Pickup Orders (L60) system control value is selected. See that system control value for background. Additionally, this flag can be changed when you create a return through the Inbound Return API; see Suppressing Refunds for an overview.
# days for deferral	The number of days the payment is deferred. This field is used with deferred payment plans only. Numeric, 3 positions; display-only.
Fix date for deferral	The day of the month when payment for this order is due. This field is used with deferred payment plans only. Numeric, 6 positions (in user date format); display-only.
# of installments	The number of installments for this order. This field is used with installment payment plans only. Numeric, 2 positions; display-only.
Installment interval	The amount of days between each installment. This field is used with installment payment plans only. Numeric, 3 positions; display-only.
Fixed installment date	The day of the month when each installment is due. This field is used with installment payment plans only. Numeric, 6 positions (in user date format); display-only.
Expiration date	The date when this payment plan expires. Numeric, 6 positions (in user date format); display-only.

Display Authorization History Screen

Purpose: Use this screen to review the authorization transactions that occurred for the customer's credit card.

Creating authorization history for orders authorized on the web: Order Management System creates an authorization history record with a status of A Approved for an order that received an approved credit card authorization on the web storefront if an auth_number and auth_amount are defined for the credit card payment.

Creating authorization history records for reauthorization attempts: See Reauthorizing Expired Authorizations for more information.

How to display this screen: Select Display authorization history for a payment method at the Display Order Payment Methods Screen.

For more information: See Display Order Payment Methods Screen for a description of the fields at the top of this screen.

Field	Description
Currency code	The currency of the Authorization amount and Deposit amount. Displayed only if you use the Alternate Currency option to toggle between displaying the Authorization amount and Deposit amount in the local currency and alternate currency. This option is available only if the Multi Currency by Offer (E03) system control value is selected. Alphanumeric, 3 positions; display-only.
Sts (Status)	The status of the authorization as updated by the system. Valid values are: • blank = Not sent yet • S = Sent, but not received • A = Authorized • D = Declined • E = Expired; updated to this status by Pick Slip Generation only • O = Authorized, but not used • M = Mismatch Auth/Deposit (created for authorizations during deposits) Alphanumeric, 1 position; display-only.
Auth amt (Authorized amount)	The amount the service bureau authorized to be charged on the credit card. You can toggle between viewing the authorization amount in the local currency and the alternate currency by selecting Alternate Currency if the Multi Currency by Offer (E03) system control value is selected and the order is associated with an alternate currency. Numeric, 20 positions with a 2-place decimal; display-only.
Auth# (Authorization number)	A number for the authorization transaction assigned by the authorization service. Alphanumeric, 16 positions; display-only.
Auth date (Authorization date)	The date the authorization service approved the amount to be charged. Numeric, 6 positions (in user date format); display-only.
Send date	The date you transmitted the authorization to the authorization service. Numeric, 6 positions; display-only.
Deposit amt (Deposit amount)	The amount deposited to the bank for the charge. You can toggle between viewing the deposit amount in the local currency and the alternate currency by selecting Alternate Currency if the Multi Currency by Offer (E03) system control value is selected and the order is associated with an alternate currency. Numeric, 20 positions with a 2-place decimal; display-only.
Response 1	A code representing the response of the authorization service. The vendor response code is from the Vendor response 1 field in the Authorization History table. Alphanumeric, 10 positions; display-only.

Screen Option	Procedure
Display details	Select Details for an authorization to advance to the Authorization History Details Window.
Work with card authorization reversals	Select Auth Reversals for a pay category 2 Credit Card payment method to advance to the Display Authorization Reversals Screen. Note: For all other payment methods, the screen displays an error message: Option not valid for this pay type.
Toggle between displaying the Authorization amount and Deposit amount in the local currency and the alternate currency	Select Alternate Currency. The system toggles the Authorization amount and Deposit amount between the local currency and alternate currency. Additionally, when viewing the amounts in the alternate currency, the Currency code field displays in the upper right corner of the screen indicating the currency of the alternate amounts. This option is available only if the Multi Currency by Offer (E03) system control value is selected.

Screen Option

Procedure

Display details

Select Details for an authorization to advance to the Authorization History Details Window.

Work with card authorization reversals

Select Auth Reversals for a pay category 2 Credit Card payment method to advance to the Display Authorization Reversals Screen.

Note: For all other payment methods, the screen displays an error message: Option not valid for this pay type.

Toggle between displaying the Authorization amount and Deposit amount in the local currency and the alternate currency

Select Alternate Currency. The system toggles the Authorization amount and Deposit amount between the local currency and alternate currency. Additionally, when viewing the amounts in the alternate currency, the Currency code field displays in the upper right corner of the screen indicating the currency of the alternate amounts. This option is available only if the Multi Currency by Offer (E03) system control value is selected.

Authorization History Details Window

Purpose: Use this pop-up window to review the history of an authorization, such as the vendor response code and when the authorization was submitted and deposited.

How to display this screen: Select Details for an authorization at the Display Authorization History Screen.

Field	Description
Vendor response	A code representing the response of the authorization service. See Defining Vendor Response Codes for more information on vendor responses. Alphanumeric, 10 positions; display-only.
Vendor response description (unlabeled field)	The description of the vendor response code. Alphanumeric, two 30-position fields; display-only.
Vendor response 2	A code representing the credit card security response (CID, CVV2, CVC2) for the credit card authorization. If a card security value and card security presence were not provided for the credit card, this field is blank. The card security response code is from the Vendor response 2 field in the Authorization History table. See Credit Card Security Service (CID, CVV2, CVC2). Alphanumeric, 10 positions; display-only.
Vendor response 2 description (unlabeled field)	The description of the vendor response code used for card security identification. Alphanumeric, two 30-position fields; display-only.
AVS response	A code representing the address verification response for the credit card authorization if AVS is used. If AVS is not used, this field is blank. The AVS response code is from the AVS response field in the Authorization History table. See Address Verification Service (AVS). Alphanumeric, 10 positions; display-only.
AVS response description (unlabeled field)	The description of the AVS response code. Alphanumeric, two 40-position fields; display-only.
Auth # (Authorization number)	A number assigned by the authorization service for the authorization transaction. Alphanumeric, 16 positions; display-only.
Status (unlabeled field to the right of the Auth #)	A description of the status of the authorization as updated by the system. Possible statuses are: • Sent for authorization • Authorized • Not yet sent • Declined • Expired • Authorized but not used • Mismatch Auth/Deposit (created for authorizations during deposits) • Voided
Auth date (Authorization date)	The date the authorization service approved the amount to be charged. Numeric, 6 positions (in user date format); display-only.
Auth expires (Authorization expires)	The date the authorization expires. The system uses the following calculation to determine if an authorization has expired: authorization date (from Authorization History table) + reauthorization days (from Pay Type table) = authorization expiration date. Numeric, 6 positions (in user date format); display-only.
Auth time Authorization time	The time when the credit card payment was authorized. The system uses this time to determine if the authorization is eligible for reversal; see Credit Card Authorization Reversal. Also, this information is used through the REAUTH process; see Reauthorizing Expired Authorizations. Numeric, 6 positions (HH:MM:SS format); display-only.
Amount submitted	The amount submitted for authorization and approved by the credit card authorization service. You can toggle between viewing the amount submitted in the local currency and the alternate currency by selecting Alt Currency if the Multi Currency by Offer (E03) system control value is selected and the order is associated with an alternate currency. Numeric, 20 positions with a 2-place decimal; display-only.
Amount available	The amount remaining that requires authorization. You can toggle between viewing the amount available in the local currency and the alternate currency by selecting Alt Currency if the Multi Currency by Offer (E03) system control value is selected and the order is associated with an alternate currency.Numeric, 20 positions with a 2-place decimal; display-only.
Amount deposited	The total amount deposited. You can toggle between viewing the amount available in the local currency and the alternate currency by selecting Alt Currency if the Multi Currency by Offer (E03) system control value is selected and the order is associated with an alternate currency. Numeric, 20 positions with a 2-place decimal; display-only.
Auth request ID	The transaction ID, or reference number, associated with the authorization transaction for the credit card payment. Alphanumeric, 40 positions; display-only.

Field

Description

Vendor response

A code representing the response of the authorization service.

See Defining Vendor Response Codes for more information on vendor responses.

Alphanumeric, 10 positions; display-only.

Vendor response description

(unlabeled field)

The description of the vendor response code.

Alphanumeric, two 30-position fields; display-only.

Vendor response 2

A code representing the credit card security response (CID, CVV2, CVC2) for the credit card authorization.

If a card security value and card security presence were not provided for the credit card, this field is blank.

The card security response code is from the Vendor response 2 field in the Authorization History table.

See Credit Card Security Service (CID, CVV2, CVC2).

Alphanumeric, 10 positions; display-only.

Vendor response 2 description

(unlabeled field)

The description of the vendor response code used for card security identification.

Alphanumeric, two 30-position fields; display-only.

AVS response

A code representing the address verification response for the credit card authorization if AVS is used.

If AVS is not used, this field is blank.

The AVS response code is from the AVS response field in the Authorization History table.

See Address Verification Service (AVS).

Alphanumeric, 10 positions; display-only.

AVS response description

(unlabeled field)

The description of the AVS response code.

Alphanumeric, two 40-position fields; display-only.

Auth #

(Authorization number)

A number assigned by the authorization service for the authorization transaction.

Alphanumeric, 16 positions; display-only.

Status

(unlabeled field to the right of the Auth #)

A description of the status of the authorization as updated by the system. Possible statuses are:

• Sent for authorization

• Authorized

• Not yet sent

• Declined

• Expired

• Authorized but not used

• Mismatch Auth/Deposit (created for authorizations during deposits)

• Voided

Auth date

(Authorization date)

The date the authorization service approved the amount to be charged.

Numeric, 6 positions (in user date format); display-only.

Auth expires

(Authorization expires)

The date the authorization expires.

The system uses the following calculation to determine if an authorization has expired: authorization date (from Authorization History table) + reauthorization days (from Pay Type table) = authorization expiration date.

Numeric, 6 positions (in user date format); display-only.

Auth time

Authorization time

The time when the credit card payment was authorized. The system uses this time to determine if the authorization is eligible for reversal; see Credit Card Authorization Reversal. Also, this information is used through the REAUTH process; see Reauthorizing Expired Authorizations.

Numeric, 6 positions (HH:MM:SS format); display-only.

Amount submitted

The amount submitted for authorization and approved by the credit card authorization service.

You can toggle between viewing the amount submitted in the local currency and the alternate currency by selecting Alt Currency if the Multi Currency by Offer (E03) system control value is selected and the order is associated with an alternate currency.

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

Amount available

The amount remaining that requires authorization.

You can toggle between viewing the amount available in the local currency and the alternate currency by selecting Alt Currency if the Multi Currency by Offer (E03) system control value is selected and the order is associated with an alternate currency.Numeric, 20 positions with a 2-place decimal; display-only.

Amount deposited

The total amount deposited.

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

Auth request ID

The transaction ID, or reference number, associated with the authorization transaction for the credit card payment.

Alphanumeric, 40 positions; display-only.

Screen Option	Procedure
Toggle between displaying the Amount submitted, Amount available, and the Amount deposited in the local currency and the alternate currency	Select Alt Currency. The system toggles the Amount submitted, Amount available, and the Amount deposited between the local currency and alternate currency. Additionally, when viewing the amounts in the alternate currency, the Currency code field displays in the upper right corner of the screen indicating the currency of the alternate amounts.

Display Authorization Reversals Screen

Purpose: Use this screen to review authorization reversals applied against a card payment.

This screen is helpful in determining if the authorization reversal was approved or declined:

• Approved authorization reversals have a Response and Approval date and time.

• Declined authorization reversals have a Response, but a blank Approval date and time.

The system processes an authorization reversal against a card payment when a cancellation amount is applied against the card or the card is deactivated and an open, unused authorization amount exists. Authorization reversals allow you to reimburse the card the amount that was initially charged against the card so the customer can use the amount to pay for future purchases. See Stored Value Card Authorization Reversal for more information on the processing that occurs against a stored value card and see Credit Card Authorization Reversal for more information on the processing that occurs against a credit card.

Note:

• This screen is available for stored value card and credit card payment methods only.

• Stored value card payments have a Pay category of Credit Card and a Card type of Stored Value.

• Credit card payments have a Pay category of Credit Card and a Card type of Credit.

If you try to advance to this screen for any other pay type, an error message indicates: Option not valid for this pay type.

• Depending on the user’s authority to credit card information, the system writes a record to the Credit Card Audit table when this screen is displayed. See Logging Credit Card Data Access in the Data Security and Encryption Guide on My Oracle Support (1988467.1) for more information.

How to display this screen: Select Auth Reversals for an authorization history record related to a stored value card or credit card at the Display Authorization History Screen.

Field	Description
Order #	The order number containing the card payment method. Numeric, 8 positions; display-only.
Pay type	A description of the card payment method. Alphanumeric, 30 positions; display-only.
Credit card#	The number assigned to the card payment method. Masking: This number displays in the format specified at the Credit Card Number Layout Screen for the associated pay type. For example, ************1443 may display instead of the entire number. See Credit Card Number Format for an overview. Alphanumeric, 20 positions; display-only.
Exp date	The date when the card expires. Numeric, 4 positions (MMDD format); display-only.
Seq #	The authorization history sequence number associated with the card authorization reversal. Numeric, 3 positions; display-only.
Auth amount	The original authorization amount applied against the card. Numeric, 20 positions with a 2-place decimal; display-only.
Auth date	The date the card was originally authorized. Numeric, 6 positions (in user date format); display-only.
Create date	The date the authorization reversal was created against the card payment. This is the date when a cancellation was processed against the card payment or when the card was deactivated. Numeric, 6 positions (in user date format); display-only.
Create time	The time the authorization reversal was created against the card payment. Numeric, 6 positions (HH:MM:SS format); display-only.
Approval date	The date when the authorization reversal was approved by the service bureau. Numeric, 6 positions (in user date format); display-only.
Approval time	The time when the authorization reversal was approved by the service bureau. Numeric, 6 positions (HH:MM:SS format); display-only.
Reversal amount	The authorization amount to reimburse to the card. Numeric, 20 positions with a 2-place decimal; display-only.
Response	The response received from the service bureau, indicating if the authorization reversal was approved or declined. Note: The response received from the service bureau does not display in this field unless it is set up as a vendor response for the service bureau in Work with Authorization Services (WASV). Alphanumeric, 40 positions; display-only.

Screen Option	Procedure
Toggle between displaying the Authorization amount and Reversal amount in the local currency and the alternate currency	Select Toggle Alternate Currency. The system toggles the Authorization amount and Reversal amount between the local currency and alternate currency. Additionally, when viewing the amounts in the alternate currency, the Currency code field displays in the upper right corner of the screen indicating the currency of the alternate amounts.

Display Contributions Screen

Purpose: Use this screen to review a contribution or to convert the contribution to a refund.

How to display this screen: Select Display contributions a payment method at the Display Order Payment Methods Screen. If no contributions have been applied for the payment method you select, a message displays:

No contributions exist.

About contributions: The Method for Processing Overpayments in Order Entry (D70) system control value defines how you handle overpayments on prepaid orders. You can apply such overpayments as contributions, or you can refund the customer. If you apply an overpayment as a contribution, you can convert the contribution to a refund afterward by selecting Convert to a Refund on the Display Contributions screen (if you have authority to the Convert Contribution Authority (A41) secured feature).

Field	Description
Order #	A unique number to identify an order. Numeric, 8 positions.
Sold to #	A unique number to identify the customer who places an order. Numeric, 9 positions.
Amount contributed	The amount of the overpayment that has been applied as a contribution. Numeric, 20 positions with a 2-place decimal.
Date posted to cash	The date you posted the cash receipt. Numeric, 6 positions (in user date format).
Date converted	The date, if any, you converted the contribution to a refund. Numeric, 6 positions (in user date format).
Batch #	The number of the order batch, if any, that included the order. Numeric, 5 positions.

Screen Option	Procedure
Convert contribution to refund	Select Convert to a Refund. If you do not have authority to convert (you do not have authority to the Convert Contribution Authority (A41) secured feature), a message displays: User Not Authorized to Convert Contributions to Refunds.

Screen Option

Procedure

Convert contribution to refund

Select Convert to a Refund. If you do not have authority to convert (you do not have authority to the Convert Contribution Authority (A41) secured feature), a message displays:

User Not Authorized to Convert Contributions to Refunds.

Display Additional Charges Screen

Purpose: Use this screen to review the miscellaneous charges and credits that were added to the order through Order Entry or Order Maintenance.

How to display this screen: Select Charges at the Order Inquiry Header Screen or the Order Inquiry Detail Screen.

Field	Description
Order #	The number assigned by the system to identify this order. Numeric, 8 positions; display-only, assigned by the system.
Ship to number (Unlabeled field to the right of the Order number field)	A number to identify the shipping address on the order. Numeric, 3 positions; display-only, assigned by the system.
Sold to (Sold-to customer name)	The name of the sold-to customer. Alphanumeric, 40 positions; display-only.
Ship to (Ship-to customer name)	The name of the ship-to customer. Alphanumeric, 40 positions; display-only.
Code	A value that represents the additional charges code. Additional charges are defined in and validated against the Additional Charge Code table. See Establishing Additional Charge Codes (WADC). Alphanumeric, 2 positions; display-only.
Description	The description of the additional charge code. Alphanumeric, 30 positions; display-only.
Amount	The amount of the additional charge. A negative amount identifies an additional charge credit. Additional charges are billed through the billing function. You can limit the total amount of negative additional charges applied to an order by entering a value in the Negative Additional Charge Limit (E49) system control value. You cannot override this value unless you have authority to the Override Negative Additional Charge Limit (A60) secured feature. Numeric, 13 positions with a 2-place decimal; display-only.
Billed	Indicates whether or not the additional charge has been billed yet. If it has been billed, you cannot modify the charge. Values are: • Selected = The additional charge has been billed. • Unselected = The additional charge has not been billed.
Invoice	The number assigned to uniquely identify the invoice. Numeric, 7 positions; display-only.
Inv date (Invoice date)	The date the invoice was billed. Alphanumeric, 6 positions (in user date format); display-only.
Entered by	The user name of the person who entered the additional charge. In the case of a membership order, this is the user ID of the person who submitted the membership generation job through Generating Membership Orders (EGMO). See the entered_by_user field for information on how this field is populated through the order API (e-commerce order). Alphanumeric, 12 positions; display-only.
Date	The date the additional charge was entered. Numeric, 6 positions (in user date format); display-only.
System generated	Determines whether the additional charge was generated by the system or was manually entered. Valid values are: • Selected = This additional charge was generated by the system. • Unselected = This additional charge was manually entered.
Maintained by	The user name of the person who made any changes to the additional charge. Alphanumeric, 12 positions; display-only.
Date	The date the additional charge was changed. Numeric, 6 positions (in user date format); display-only.

Display Refunds for Order Screen

Purpose: Use this screen to review refund activity for an order.

How to display this screen: Select Refunds at the Order Inquiry Header Screen or the Order Inquiry Detail Screen.

Field	Description
Pay type	A code that identifies the payment type associated with the refund. Pay types are defined in and validated against the Pay Type table, and must fall into one of the valid pay categories (cash/check or credit card). See Working with Pay Types (WPAY). Numeric, 2 positions; display-only.
Sts (Status)	A code that identifies the current status of the refund. Valid values include: • C = Canceled • H = Held • N = Cancellation pending; the refund will be canceled when refunds are processed • O = Open • P = Processed • T = Written off • W = Write-off pending; the refund will be written off when write-offs are processed Alphanumeric, 1 position; display-only.
Dp (Deposit)	Indicates whether the refund has been deposited. A deferred or installment payment plan can prevent the system from depositing a refund in order to offset the deferred or installment amount. For example, if the order payment amount of 60.00 is deferred for 30 days and the customer receives a refund for 20.00, instead of refunding the customer 20.00, the system subtracts the refund amount from the order payment amount. The customer will then pay 40.00 at the end of the 30 days. Valid values are: • Selected = The refund has been deposited (there is a Deposit created date for the Invoice Payment Method). • Unselected = The refund has not been deposited.
Current category	A code that identifies the current pay category associated with the refund. Valid categories are: • Cash/check • Credit card Display-only.
Original category	A code that identifies the original pay category associated with the refund. Valid categories are: • Cash/check • Credit card Display-only.
Amount	The amount you are refunding to the customer. This is the amount that has actually been deposited. This amount can be different from the amount of the original refund if the credit was netted against a debit deposit. Numeric, 20 positions with a 2-place decimal; display-only.
Date created	The date the refund was generated. Numeric, 6 positions (in user date format); display-only.
Date processed	The date, if any, when the refund was processed, written off, or canceled. If the pay type on the order is a credit card, this date represents the deposit date, and might be either the actual deposit date or the future release date if the deposit has not yet been processed. Numeric, 6 positions (in user date format); display-only.
Man hld (Manual hold)	Indicates whether the amount of the refund exceeds the maximum refund amount specified in the Pay Type or if you placed the refund on hold manually through the Work with Refunds Screen. To issue the refund, you must first release it from hold using the Work with Refunds function. Valid values are: • Selected = The refund is on manual hold. • Unselected = The refund is not on manual hold.
Hold until (Hold until date)	The date when the refund is eligible for processing. Numeric, 6 positions (in user date format); display-only.

Display Order Summary Screen

Purpose: Use this option to review all items ordered, including items ordered for the current order plus any recipient orders. This screen lists each item ordered for each shipping address so you can verify or confirm the items ordered. You can also use this screen to view the order totals in the customer's currency.

Alternate currency order totals: The screen displays the order totals on this screen in the local currency. You can review the order totals in an alternate currency if the order is associated with an alternate currency.

How to display this screen: Select Order Totals at the Order Inquiry Header Screen or the Order Inquiry Detail Screen.

Field	Description
Order #	The number of the order you are currently working with. Numeric, 9 positions; display-only, assigned by the system.
# Rcp (Number of recipients)	The number of recipients on this order. This is the number of shipping addresses on the order. Numeric, 3 positions; display-only, assigned by the system.
Prepaid	The total amount prepaid on this order using checks. Numeric, 20 positions with a 2-place decimal; display-only, calculated by the system.
Balance	The balance due on the order, calculated by subtracting the order total (current order plus all recipient orders) from the prepaid amount. If the balance is 0, this means that the customer prepaid the entire order. If the balance is negative, there is a balance due that will be charged to the customer. Numeric, 20 positions with a 2-place decimal; display-only, calculated by the system.
Current recip (Current recipient)	The ship-to number indicating the recipient you are currently working with. Numeric, 3 positions; display-only.
Merch (Merchandise)	The total value of merchandise on this order, which is calculated by multiplying the quantity ordered by the item's price. This amount does not include charges for freight (shipping), sales tax (except for hidden tax), or handling. Numeric, 20 positions with a 2-place decimal; display-only, updated by the system.
Frt (Freight)	The total charge for shipping the current order plus any recipient orders. Shipping charges are based on the freight method defined for the source code used on the order. This amount does not include any additional shipping charges. This field is blank if no freight is charged on the order (Calc freight = N). Numeric, 20 positions with a 2-place decimal; display-only, updated by the system.
Frt+ (Additional freight)	The total additional freight charges on the current order plus any recipient orders. Additional freight charges can be defined for a shipper in the Ship Via table. For example, a shipper can charge a premium for overnight or Federal Express deliveries. See Working with Ship Via Codes (WVIA). Numeric, 20 positions with a 2-place decimal; display-only, updated by the system.
Chg (Additional charges)	The total extra charges added to the current order and any recipient orders. This can be an additional service charge defined for the source code or offer used on the order, an additional shipping charge for an item on the order, a guaranteed service charge defined for the offer, or any type of miscellaneous charge or credit added to the order. Numeric, 20 positions with a 2-place decimal; display-only, updated by the system.
Tax	The total sales tax on the current order and any recipient orders, based on the merchandise value of the order and, optionally, freight and special handling. This total does not include hidden tax. Numeric, 20 positions with a 2-place decimal; display-only, updated by the system.
Hnd	The total charge, on the current order and any recipient orders, for special handling or gift wrapping. Numeric, 13 positions with a 2-place decimal; display-only, updated by the system.
Total	The grand total of all charges on the current order and any recipient orders. This includes merchandise, freight, additional freight, additional charges, tax, and handling. Numeric, 20 positions with a 2-place decimal; display-only, updated by the system.
Shp (Ship To number)	The number of the shipping address on the order. Numeric, 3 positions; display-only, assigned by the system.
Name	The initial and last name or company name of the customer the order is shipping to. The customer or company name only displays next to the first detail line for each customer. Alphanumeric, 10 positions; display-only.
Ln#	The line number of this item on the order. Numeric, 3 positions; display-only.
Qty (Quantity)	The number of units ordered of the item. Numeric, 5 positions; display-only.
Item	A code for a unit of inventory that you sell. Enter a valid item to display items that match your entry. Alphanumeric, 12 positions; display-only.
SKU	The style of the item, such as its color or size. Alphanumeric, three 4-position fields.
Via	A code for the carrier or service that will deliver the order. Ship via codes are defined in and validated against the Ship Via table. See Working with Ship Via Codes (WVIA). Numeric, 2 positions; display-only.
Price	The selling price of a single unit of this item. The system calculates the price by taking into account any price breaks, source or order discounts, and using the pricing hierarchy in the System Control table. Numeric, 13 positions with a 2 place decimal; display-only, calculated by the system.
Whs (Warehouse)	A code for the warehouse this item will ship from. Warehouse codes are defined in and validated against the Warehouse table. See Creating and Maintaining Warehouses (WWHS). Numeric, 3 positions; display-only.
SA (Ship alone code)	Identifies whether the item can ship with other items. Valid values are: • S = Ship alone; item cannot be shipped with other items. A pick slip prints for each unit ordered. • M = Multi-ship; item can ship with other items. • L = Picks print in location code sequence. • U = User-defined. This information is taken from the Ship alone field in the Item table. Alphanumeric, 1 position; display-only.
Item description (Unlabeled field below the Shp field)	The description of the item being ordered. Alphanumeric, 120 positions; display-only.
SKU description (Unlabeled field below the SKU field)	The description of the SKU for the item. Alphanumeric, 25 positions; display-only.
Extended price (Unlabeled field below the Whs field)	The total charge for this item, which is calculated by multiplying the price of the item by the quantity ordered. Numeric, 20 positions with a 2-place decimal; display-only, updated by the system.

Screen Option	Procedure
Accept the order information for the recipient you are currently working with and switch to another recipient	Select recipient and accept current for a recipient. You can select this option only during order entry. A message displays if you select Select recipient and accept current for a recipient during order maintenance/inquiry: Subfile option (1) is not valid for current processing mode (Display).
Copy an item to the recipient you are currently work with	Select Copy item to current recipient for a recipient. You can select this option only during order entry. A message displays if you Select Copy item to current recipient for a recipient during order maintenance/inquiry: Subfile option (3) is not valid for current processing mode (Display).
Display the order totals at the top of the screen in the customer's currency or in the system currency (from the Local Currency Code (A55) system control value).	Select Foreign Currency. See Displaying Order Totals in Foreign Currency.
Review the items selected to copy	Select Items Selected. You can select this option only during order entry.
Accept the order information for the recipient you are currently working with and advance to the Select Order Recipient screen	Select Accept/Switch Recipient. You can select this option only during order entry.

Displaying Order Totals in Foreign Currency

Purpose: Use this function to convert, then display the order totals in the customer's currency.

Using this feature: Select Foreign Currency at the Display Order Summary Screen to convert the order totals to the customer's currency.

About currency conversion: When you select Foreign Currency, the system gets the country code for the sold-to customer (the customer who placed the order), then checks the Currency table (fast path = WCUR).

If a currency code has been defined for this country, the system multiplies each order total bucket by the conversion rate, and displays the order totals in the customer's own currency. This way, the order total is more meaningful to the customer.

Important: The figures on this screen will not be correct if the Multi Currency by Offer (E03) system control value is selected; in this case, the figures displayed at the other standard order inquiry screen, and in order entry and order maintenance, are already in the customer's currency.

Example: The customer calls from Italy to inquire on the charges and items on an order. You select Order Summary to review the order totals.

Next, you select Foreign Currency to display the totals expressed in the customer's own currency. The system performs the currency conversion immediately, using the current conversion rate from the Currency table, and updates the order totals appropriately.

If no Currency is Defined for the Country

The system issues a message if there is no currency defined for the customer's country in the Currency table, and you will not be able to view the order totals in the customer's currency when you select System Currency Display:

No currency match found for country XXX.

Note:

• The value in the Total field is the sum of all other order totals fields (Merch, Frt, Frt+, Chg, Tax, and Hnd); no conversion is performed on this field.

• Currency values extending beyond 2 decimal places are rounded up or down to the nearest integer value, such as a dollar value.

• The country code and the currency code must be the same for order totals conversion.

• The order totals are converted using the current currency rate. This means that the order totals you see on this screen may be different from the order totals at shipping time.

• Selecting System Currency Display toggles between displaying the order totals in the customer's (foreign) currency or in the system currency.

________________________________

Contents SCVs Reports XML Messages Glossary