Common Elements Used in This Section

Field or Control Description

Adj (adjustment)

An asterisk in this column denotes an adjustment line on the invoice.

Amount Remitted

Displays a blank line for the amount that the customer wants to pay.

Bill Inquiry Phone

Number printed on the invoices for customers to call if they have any questions about their bills.

Bill To

Bill-to customer and bill-to address.

Bill To Customer Name

Customer to whom you ship the invoice.

Buyer's VAT Registration ID (buyer's value-added tax registration ID)

The buyer's VAT country registration number. Each country has its own set of valid VAT registration numbers.

Calculation Method

If you select to calculate VAT at Gross, the system calculates VAT before it applies any early payment discounts. If you select to calculate VAT at Net, the system calculates VAT after it deducts early payment discounts.

Contract

Default value, if it exists, comes from the CONTRACT_NUM field.

Currency

Billing currency.

Declaration Point

When VAT transaction information is recognized for reporting purposes.

Document Number

Header document sequence number.

Due Date

Date on which payment is due.

Est. Due Date (estimated due date)

Estimated date on which payment is due.

Final Start Date and Final End Date

Finalize run dates of the finalized invoices that you specify on the Invoice Register Process page for review on the report.

From and To

From and to dates for the corresponding resource type and category. The From field value is the minimum of CHARGE_FROM_DT. The To field value is the maximum of CHARGE_TO_DT.

In Euro

Total amount due for the invoice in euros.

Invoice No (invoice number)

Unique number that is assigned to the invoice. Define invoice number IDs on the Invoice Number page.

Net Amount

If you did not select Apply Disc/Surchg to Line Amt on the Invoice Formatting Options - Discounts, Surcharges, Taxes page, then net amount is the invoice amount before discounts, surcharges, and taxes are applied. If you select Apply Disc/Surchg to Line Amt, the net amount contains discounts and surcharges. Taxes are not included.

Number of Bills

Number of bills that are processed in the run.

Number of Invoices

Number of invoices that are included.

Page number or Page No.

Page number of the invoice or summary invoice.

Prepaid Utilization

Contracts prepaid utilization description, derived from CA_PPD_UTL_DESCR and based on CONTRACT_PPD_SEQ and CONTRACT_NUM, if those values exist. Sum of NET_EXTENDED_AMT. This field applies to utilization rows only (line type is UTL).

PO (purchase order)

Default value comes from the PO_REF field.

Printed On

Date and time when the invoice was generated.

Project

For each project, the report displays a description of PROJECT_ID, an employee name that corresponds to the value of EMPLID, and a description of the values from RESOURCE_TYPE and RESOURCE_CATEGORY.

Process Instance

System-generated instance ID from the Process Scheduler.

Rate

Amount billed for each unit of measure. The system derives this value from UNIT_AMT.

Report Action

Indicates whether the run was a pro forma (Pro forma) or a Finalize and Print (Invoice).

(Sales/Use)

The sales and use taxes that are applied to the bill.

Site

The system derives this value from the SHIP_TO_CUST_ID and SHIP_TO_ADDR_NUM fields. The system uses the ship-to information to get site details on the invoice header. It obtains the ship-to name from the CUSTOMER table. The ship-to customer ID and ship-to address number fields that are provided on the bill header must exist in the CUSTOMER table, and the CUST_STATUS field must have a value of A (active). Additionally, the SHIP_TO_FLG field must have a value of Y (yes). The system retrieves the ship-to address from BI_SHP_ADDR_VW based on the SHIP_TO_CUST_ID and SHIP_TO_ADDR_NUM fields.

Sellers VAT Registration ID (seller's value-added tax registration ID)

The seller's VAT country registration number. Each country has its own set of valid VAT registration numbers.

Status/Type

Invoice status and invoice type.

Subtotal

Combined net amount of each bill line.

Subtotal For Employee

Subtotal of NET_EXTENDED_AMT for each employee in the project.

Subtotal For Project

Subtotal of NET_EXTENDED_AMT for each project.

Summary page

On the Invoice Formatting Options - General page, you can define the summary page options and elect to have a summary page print with the invoice.

Total Amount Due

Total amount, including discounts, surcharges, and taxes, that is due for the invoice.

Total Invoice Amount

Total invoice amount, including taxes, discounts, surcharges, and other adjustments.

Total number of bills printed

Number of bills that are included with the invoice.

Total Number of Consolidated Invoices

Total number of registered consolidated invoices.

Total # of Invoices (total number of invoices)

Total number of registered invoices.

Unit Amt (unit amount)

Price per unit.

VAT Treatment (value-added tax treatment)

Main driver for processing VAT on sales and procurement transactions is the VAT treatment. This determines which default values to apply and controls the availability of some VAT-related fields.