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.

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

This option is not currently implemented.

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).

All payment methods including PayPal and wallets are shown. As PayPal orders are created via the CWOrderIn API and not directly through the user interface, hence these pay types should not be selected here. Order Administration does not support authorization integration with PayPal.

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)

Informational.

Alphanumeric, 9 positions; display-only.

Acct # (Checking account number)

Informational.

Alphanumeric, 20 positions; display-only.

Check # (Check number)

Informational.

Numeric, 6 positions; display-only.

Check download date (Check interface download date)

Not implemented.

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

Card Number

Information will be provided by Oracle at a later date.

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. Information will be provided by Oracle at a later date.

Numeric, 4 positions (MMYY format); display-only.

Card 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.

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.

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 in the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1) 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.

For more information see

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.

For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).

Additionally, this flag can be changed when you create a return through the Inbound Return API; see Suppressing Refunds in the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1) for an overview 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 Administration 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.

For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1).

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.

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.

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.

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. Also, this information is used through the REAUTH process. Information will be provided by Oracle at a later date.

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.

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. Information will be provided by Oracle at a later date.

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.

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.

Card Number

The number assigned to the card payment method.

Masking: This number displays in the format specified at the Card Number Layout Screen for the associated pay type. For example, ************1443 may display instead of the entire number. See 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.