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

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

Alternate total (XXX, where XXX is the currency code in the Order Header Extended table)

The total of the invoice in the alternate currency.

The order is associated with an alternate currency if a currency code and conversion rate are defined in the Order Header Extended table. The system updates the Order Header Extended table with a currency code and conversion rate if the offer associated with the source code on the order header is associated with a currency code and conversion rate.

The system determines the alternate total by multiplying the local order total by the conversion rate from the Order Header Extended table: local order total x conversion rate = alternate order total.

This field displays only if the Use Alternate Currency Pricing (H89) system control value is selected and the order is associated with an alternate currency. See Customer Service Using Alternate Currency Pricing for an overview and required setup.

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

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.

Sales journal print date

The date you printed a sales journal that includes this invoice.

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, 9 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, 7 positions with a 2-place decimal; display-only.

Alternate merchandise (XXX, where XXX is the currency code in the Order Header Extended table)

The total value of the merchandise in the alternate currency.

The order is associated with an alternate currency if a currency code and conversion rate are defined in the Order Header Extended table. The system updates the Order Header Extended table with a currency code and conversion rate if the offer associated with the source code on the order header is associated with a currency code and conversion rate.

The system determines the alternate merchandise amount by multiplying the local merchandise amount by the conversion rate from the Order Header Extended table: local merchandise amount x conversion rate = alternate merchandise amount.

This field displays only if the Use Alternate Currency Pricing (H89) system control value is selected and the order is associated with an alternate currency. See Using Alternate Currency Pricing for an overview and required setup.

Numeric, 11 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, 7 positions with a 2-place decimal; display-only.

Alternate freight (XXX, where XXX is the currency code in the Order Header Extended table)

The freight charges for the invoice in the alternate currency.

The order is associated with an alternate currency if a currency code and conversion rate are defined in the Order Header Extended table. The system updates the Order Header Extended table with a currency code and conversion rate if the offer associated with the source code on the order header is associated with a currency code and conversion rate.

The system determines the alternate freight amount by multiplying the local freight amount by the conversion rate from the Order Header Extended table: local freight amount x conversion rate = alternate freight amount.

This field displays only if the Use Alternate Currency Pricing (H89) system control value is selected and the order is associated with an alternate currency. See Using Alternate Currency Pricing for an overview and required setup.

Numeric, 9 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, 7 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, 7 positions with a 2-place decimal; display-only.

Alternate tax (XXX, where XXX is the currency code in the Order Header Extended table)

The sales tax for the invoice in the alternate currency.

The order is associated with an alternate currency if a currency code and conversion rate are defined in the Order Header Extended table. The system updates the Order Header Extended table with a currency code and conversion rate if the offer associated with the source code on the order header is associated with a currency code and conversion rate.

The system determines the alternate tax amount by multiplying the local tax amount by the conversion rate from the Order Header Extended table: local tax amount x conversion rate = alternate tax amount.

This field displays only if the Use Alternate Currency Pricing (H89) system control value is selected and the order is associated with an alternate currency. See Using Alternate Currency Pricing for an overview and required setup.

Numeric, 9 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, 7 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, 7 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, 7 positions with a 2-place decimal; display-only.

Alternate handling (XXX, where XXX is the currency code in the Order Header Extended table)

The cost of any special handling on the order in the alternate currency.

The order is associated with an alternate currency if a currency code and conversion rate are defined in the Order Header Extended table. The system updates the Order Header Extended table with a currency code and conversion rate if the offer associated with the source code on the order header is associated with a currency code and conversion rate.

The system determines the alternate handling amount by multiplying the local handling amount by the conversion rate from the Order Header Extended table: local handling amount x conversion rate = alternate handling amount.

This field displays only if the Use Alternate Currency Pricing (H89) system control value is selected and the order is associated with an alternate currency. See Using Alternate Currency Pricing for an overview and required setup.

Numeric, 9 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, 7 positions with a 2-place decimal; display-only.

Alternate add’l charges (XXX, where XXX is the currency code in the Order Header Extended table)

The total additional charges for the invoice in the alternate currency.

The order is associated with an alternate currency if a currency code and conversion rate are defined in the Order Header Extended table. The system updates the Order Header Extended table with a currency code and conversion rate if the offer associated with the source code on the order header is associated with a currency code and conversion rate.

The system determines the alternate additional charges by multiplying the local additional charges by the conversion rate from the Order Header Extended table: local additional charges x conversion rate = alternate additional charges.

This field displays only if the Use Alternate Currency Pricing (H89) system control value is selected and the order is associated with an alternate currency. See Using Alternate Currency Pricing for an overview and required setup.

Numeric, 9 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, 7 positions with a 2-place decimal; display-only.

Alternate add’l freight (XXX, where XXX is the currency code in the Order Header Extended table)

The total additional freight for the invoice in the alternate currency.

The order is associated with an alternate currency if a currency code and conversion rate are defined in the Order Header Extended table. The system updates the Order Header Extended table with a currency code and conversion rate if the offer associated with the source code on the order header is associated with a currency code and conversion rate.

The system determines the alternate additional freight amount by multiplying the local additional freight amount by the conversion rate from the Order Header Extended table: local additional freight amount x conversion rate = alternate additional freight amount.

This field displays only if the Use Alternate Currency Pricing (H89) system control value is selected and the order is associated with an alternate currency. See Using Alternate Currency Pricing for an overview and required setup.

Numeric, 9 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, 11 positions with a 2-place decimal; display-only.

Alternate total (XXX, where XXX is the currency code in the Order Header Extended table)

The total amount billed for this shipment in the alternate currency.

The order is associated with an alternate currency if a currency code and conversion rate are defined in the Order Header Extended table. The system updates the Order Header Extended table with a currency code and conversion rate if the offer associated with the source code on the order header is associated with a currency code and conversion rate.

The system determines the alternate total by multiplying the local total by the conversion rate from the Order Header Extended table: local total x conversion rate = alternate total.

This field displays only if the Use Alternate Currency Pricing (H89) system control value is selected and the order is associated with an alternate currency. See Using Alternate Currency Pricing for an overview and required setup.

Numeric, 9 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, 7 positions with a 2-place decimal; display-only.

Alternate discount amount (XXX, where XXX is the currency code in the Order Header Extended table)

The differences between the actual price charged for items and the offer prices in the alternate currency.

The order is associated with an alternate currency if a currency code and conversion rate are defined in the Order Header Extended table. The system updates the Order Header Extended table with a currency code and conversion rate if the offer associated with the source code on the order header is associated with a currency code and conversion rate.

The system determines the alternate discount amount by multiplying the local discount amount by the conversion rate from the Order Header Extended table: local discount amount x conversion rate = alternate discount amount.

This field displays only if the Use Alternate Currency Pricing (H89) system control value is selected and the order is associated with an alternate currency. See Using Alternate Currency Pricing for an overview and required setup.

Numeric, 9 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, 7 positions with a 2-place decimal; display-only.

Alternate hidden freight (XXX, where XXX is the currency code in the Order Header Extended table)

The hidden freight amount in the alternate currency.

The order is associated with an alternate currency if a currency code and conversion rate are defined in the Order Header Extended table. The system updates the Order Header Extended table with a currency code and conversion rate if the offer associated with the source code on the order header is associated with a currency code and conversion rate.

The system determines the alternate hidden freight by multiplying the local hidden freight by the conversion rate from the Order Header Extended table: local hidden freight x conversion rate = alternate hidden freight.

This field displays only if the Use Alternate Currency Pricing (H89) system control value is selected and the order is associated with an alternate currency. See Using Alternate Currency Pricing for an overview and required setup.

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

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, 9 positions with a 2-place decimal; display-only.

Merchandise balance

The unpaid portion of the merchandise total.

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

Freight

The freight charges for the invoice assigned to the payment method.

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

Freight balance

The unpaid portion of the freight.

Numeric, 7 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, 7 positions with a 2-place decimal; display-only.

Additional freight balance

The unpaid portion of the additional freight balance charge.

Numeric, 7 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, 7 positions with a 2-place decimal; display-only.

Additional charges balance

The unpaid portion of the additional charges.

Numeric, 7 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, 7 positions with a 2-place decimal; display-only.

Handling balance

The unpaid portion of the handling charge and/or duty charge, if any.

Numeric, 7 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, 7 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, 7 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, 7 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, 7 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, 7 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, 7 positions with a 2-place decimal; display-only.

PST balance

The unpaid portion of the Canadian provincial services tax.

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

Order level freight

Freight charges that apply to the total shipment.

Numeric, 7 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, 7 positions with a 2-place decimal; display-only.

Order level freight tax

The total freight tax on the shipment, excluding hidden tax.

Numeric, 7 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, 7 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, 7 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, 7 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.

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

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, 11 positions with a 2-place decimal; 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, 11 positions with a 2-place decimal; 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, 11 positions with a 2-place decimal; display-only.

Price

The unit price of the item.

Numeric, 9 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, 11 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, 7 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, 9 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, 7 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, 7 positions with a 2-place decimal; display-only.

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, 11 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, 11 positions with a 2-place decimal; display-only.

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, 11 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.

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.

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.

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, 14 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, 14 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.

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, 13 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, 15 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, 13 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, 13 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 cancelled 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, 13 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, 13 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, 13 positions with a 2-place decimal.

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

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, 13 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.

Order #

A number the system assigns to uniquely identify an order.

Numeric, 8 positions; display-only.

Currency code

The currency of the Deposit amount. You can toggle between displaying the Deposit amount in the local currency and alternate currency if you Use Alternate Currency Pricing (H89) and you select Toggle AC. If you are viewing the amount in the alternate currency, this field displays; if you are viewing the amount in the local currency, this field does not display.

The order is associated with an alternate currency if a currency code and conversion rate are defined in the Order Header Extended table. The system updates the Order Header Extended table with a currency code and conversion rate if the offer associated with the source code on the order header is associated with a currency code and conversion rate.

This field displays only if the Use Alternate Currency Pricing (H89) system control value is selected and the order is associated with an alternate currency. See Using Alternate Currency Pricing for an overview and required setup.

Alphanumeric, 3 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

Alternate currency pricing: You can toggle between viewing the deposit amount in the local currency and the alternate currency by selecting Toggle AC if the Use Alternate Currency Pricing (H89) system control value is selected and the order is associated with an alternate currency. See Using Alternate Currency Pricing for an overview and required setup.

Numeric, 13 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.

Order #

A number the system assigns to uniquely identify an order.

Numeric, 8 positions; display-only.

Currency code

The currency of the Deposit amount. You can toggle between displaying the Deposit amount in the local currency and alternate currency if you Use Alternate Currency Pricing (H89) and you select Toggle AC. If you are viewing the amount in the alternate currency, this field displays; if you are viewing the amount in the local currency, this field does not display.

The order is associated with an alternate currency if a currency code and conversion rate are defined in the Order Header Extended table. The system updates the Order Header Extended table with a currency code and conversion rate if the offer associated with the source code on the order header is associated with a currency code and conversion rate.

This field displays only if the Use Alternate Currency Pricing (H89) system control value is selected and the order is associated with an alternate currency. See Using Alternate Currency Pricing for an overview and required setup.

Alphanumeric, 3 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

Alternate currency pricing: You can toggle between viewing the deposit amount in the local currency and the alternate currency by selecting Toggle AC if the Use Alternate Currency Pricing (H89) system control value is selected and the order is associated with an alternate currency. See Using Alternate Currency Pricing for an overview and required setup.

Numeric, 13 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.

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:

• B = billing

• C = credit check

• D = deposit

• M = maintenance

• N = net

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.