Selected PeopleSoft Billing Report Information

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.

MISC

A simple, miscellaneous type of bill with nonindustry-specific billing information.

RIGHTSTUB

A simple, miscellaneous type of bill that is constructed with a remittance tear sheet on the right side of the form.

Default Portrait

A simple, miscellaneous type of bill with nonindustry-specific billing information.

PS/PSA51 - PSA by Project, Employee Name

This format groups lines by project description, employee name, and resource type (if they exist) and prints subtotals on change of project or employee. It prints contract prepaid information for utilization lines based on the existence of a contract number and a contract prepaid sequence number.

PS/PSA52 - PSA by Project, Activity

This format groups lines by project description, activity description, employee name, resource type, and resource category (if they exist) and prints subtotals on change of project, activity, or employee. It prints contract prepaid information for utilization lines based on the existence of contract number and a contract prepaid sequence number.

PS/PSA53 - PSA Project Details

This format displays project details.

PS/CA51 - PSA Contracts Only

Similar to layout PS/CA. This format prints contract details. It applies to PeopleSoft Contracts without PeopleSoft Project Costing.

Consolidation Summary

Each attached bill appears with its corresponding amount due. The total amount due for all attached bills appears at the bottom.

Range Option

Parameters that the system uses to select the bill or group of bills for processing for the specified business unit. Specify range options on the Load AR Pending Items page.

Post Action

Indicates to the Receivables Update process how to process the pending receivables items that the Load AR process created.

Group ID

A system-generated identifier for any group of pending items that the Receivable Update program will process.

Item (Invoice)

The individual receivables that comprise a customer's balance. Companies may refer to items in a variety of ways, including invoices, obligations, open items, receivables, or documents.

Entry Type

The pending items that create or update posted items within the system. The Receivable Update program uses the pending items that you supply to create or update items and to maintain customer balances. Examples of entry types are invoices, debit memos, credit memos, payments, prepayments, on account payments, deductions, adjustments, and write-offs. Use the Entry Type Correction page to correct invalid entry type and reason entries.

Entry Reason

An entry type can be qualified by an entry reason, which is a means of further categorizing the pending items. Use the Entry Type Correction page to correct invalid entry type and reason entries.

Entry Use ID

System function or type of processing that is associated with an entry type.

Entry Amount

Amount of the AR entry.

Terms

Payment term code. Specifies how the payment due date and discount due date are calculated.

# of Invoices in Group (number of invoices in the group)

Total number of invoices that are posted to the receivables system for the corresponding group ID.

# of AR Entries in Group (number of accounts receivable entries in the group)

Total number of AR entries that are posted to the receivables system for the corresponding group ID.

Accounts Receivable Amount

Total amount of AR entries that are posted to the receivables system for the corresponding group ID.

Total # of Invoices Processed (total number of invoices processed)

The total number of items (invoices) that are processed for all group IDs in the range selection.

Total # of AR Entries Generated (total number of accounts receivable entries generated)

The total number of AR entries that are processed for all group IDs in the range selection.

Range Option

The parameters that the system uses to select the bill or group of bills for processing for the specified business unit. Specify range options on the Load GL Accounting Entries page.

Starting ID and Ending ID

A user-specified invoice ID range parameter. These dates refer to the beginning and ending invoice IDs that are selected for the Load GL process.

Stat (statistic)

Statistics code that is used to identify non-monetary amounts

AR Entry Amount (accounts receivable entry amount)

Amount of the entry that is passed to the receivables system.

Offset Entry Amounts

When you invoice a bill, the Load GL process finds the same lines that you accrued in the current accounting period and creates reversal entries for the current accounting period. These offsetting entries are reversed in the next accounting period.

Total for Currency

Totals for all AR entry amounts and offset entry amounts that are generated.

Range Option

Parameters that the system uses to select the bill or group of bills for processing for the specified business unit. Specify range options on the Generate AP Vouchers page.

AP Unit (accounts payable unit)

An independent transaction processing entity.

Supplier SetID

Unique identifier that represents a default set of rules, or attributes, that define how you conduct business with a particular supplier.

Supplier ID

Unique identifier that represents a default set of rules, or attributes, that define how you conduct business with a particular supplier.

# of Lines (number of lines)

Number of bill lines per bill header.

Total # of Voucher Headers Generated (total number of voucher headers generated)

Total number of voucher headers generated for the corresponding range option.

GL (general ledger)

Depending on how you define the GL Level field on the Installation Options - Billing - Integration Options page, values are:

A: Accounts receivable creates GL accounting entries. PeopleSoft Receivables is responsible for creating accounting entries and passing them to the general ledger system.

B: PeopleSoft Billing creates GL accounting entries. PeopleSoft Billing is responsible for creating accounting entries and passing them to the general ledger system.

N: No GL accounting entries. PeopleSoft Billing does not pass any accounting entries to the general ledger system.

AR

Depending on how you defined the AR Level field on the Installation Options - Billing - Integration Options page, values are:

H: Header is AR Open Item. PeopleSoft Billing passes each bill as an open item in the receivables system.

B: Bill line is AR open item. PeopleSoft Billing passes each bill line as an open item in the receivables system.

N: No AR open items. PeopleSoft Billing does not pass any open items to the receivables system.

Template

If you select the Replace Template check box on the Define Copy Group Detail 2 page, the resulting invoice from this copy process becomes the new template for subsequent batch copy processes. This field has a value of Y (yes) if you elect to replace the template and of N (no) if you did not elect to replace the template.

Type

The invoice layout ID. See the Layout Identifiers page.

Level

The discount level that you define on the Standard Billing - Discount/Surcharge page.

Error Message

Error messages for any fields that failed the required criteria for status change.

Range Option

Parameters that the system uses to select the bill or group of bills for processing for the specified business unit.

Starting ID and Ending ID

Displays the invoice ID with which the process begins and ends. Define these invoice IDs in the Range Selection field.

Total Number of Bills Updated

Total number of bills that are processed within the corresponding starting and ending IDs.

Bal Accum ID (balance accumulation ID)

You can calculate cumulative balances for a nearly unlimited set of key combinations in PeopleSoft Billing. Each balance accumulation ID represents a set of accumulation rules, which you establish on the Accumulation Description page.

Start Date

Date on which you defined this accumulation to begin.

Key

Display all of the fields to which you have defined this accumulation to pertain. Every key that you add after the first functions to increase the level of detail that you retrieve. For example, if you accumulate by customer, you get a total for each customer. If you accumulate by customer and order number, you receive subtotals for each combination of customer and order number, which significantly increases the number of rows in the database. In the example, this accumulation updates bill-to customer balances. On the Accumulation Description page, you can define the keys from a list that includes most of the informational fields that are found in the bill header and bill line tables.

Amount

Display the amounts that you want to maintain and for which you want to balance. Balances are maintained for invoiced bills, uninvoiced bills, and total (invoiced plus uninvoiced). In the example, this accumulation updates cumulative balances for quantity (because you selected Accumulate Quantity), gross extended amount, and net extended amount.

Accum Qty (accumulation quantity)

Quantities that you define for accumulation.

From Intfc ID (from interface ID) and To Intfc ID (to interface ID)

Represents the beginning and end of a range of interface identifiers that you specify on the Billing Interface Report page prior to running the interface process.

Load Status

The billing activity in the interface staging area has one of these load statuses:

NEW: The Billing Interface was not run for the data.

ERR: The Billing Interface was run and encountered validation errors.

DON: The Billing Interface successfully loaded the billing activity into a structured bill format and is considered complete. Items in this state are automatically moved to an archive table.

UPD: The Billing Interface is actively processing data.

Trans Type (transaction type)

The type of information that is contained in the bill line. Values are:

LINE: Charge line.

AHDR: Adjustment Header.

DDS: Deferred Discount/Surcharge.

EXSD: India Excise/Sales Tax Details.

TAX: Sales/Use Tax Details.

AE: Accounting Entry.

NOTE: Note/Comment.

DS: Discount or Surcharge.

# Lines (number of lines)

Number of lines of each transaction type that the system calculates for each customer for the corresponding interface ID.

Tot Gross Ext Amount (total gross extended amount)

Total gross extended amount for each transaction type. This field is applicable only for the transaction type LINE.

Total Amount

Total amount–including taxes, discounts, surcharges, or other adjustments–for each transaction type. This field is applicable only for the transaction types AE and DS.

Totals for Status

Total number of lines, gross extended amount, and total amount for the corresponding load status.

Totals for Intfc ID (totals for interface ID)

Total number of lines, gross extended amount and total amount for the corresponding interface ID.

Grand Totals for Currency

Total number of lines, gross extended amount, and total amount for the corresponding currency code.

Total Number of Lines

Total number of lines that are processed for the corresponding range selection.

From Intfc ID and To Intfc ID

Represents the beginning and end of a range of interface identifiers that you specify on the Billing Interface Report page prior to running the interface process.

Error Status

The Billing Interface process performs edit checks on the data that is presented to the interface staging area to verify data integrity. If the Billing Interface process finds an error, it marks all rows that are related to the bill line charge found to be in error with a load status of ERR (error) and marks the error status column with a more specific error condition. Review the Billing Interface errors and take the appropriate action necessary to correct the error. See the Billing Interface Errors table for specific information about Billing Interface error conditions.

Intfc Line # (interface line number)

The rows of data that are related to the bill line charge that are in error.

Trans Type (transaction type)

The type of information that is contained in the bill line. Values are:

LINE: Charge line.

AHDR: Adjustment Header.

DDS: Deferred Discount/Surcharge.

EXSD: India Excise/Sales Tax Details.

TAX: Sales/Use Tax Details.

AE: Accounting Entry.

NOTE: Note/Comment.

DS: Discount or Surcharge.

Trans Type Seq # (transaction type sequence number)

The transaction type sequence is part of the key and is used to provide uniqueness in the event that there are multiple accounting entries, notes, comments, or discounts or surcharges for a bill line.

Total Errors

The total number of errors for the corresponding interface ID.

Transaction Amount

Total amount in transaction currency. Transaction currency is the currency that is used to complete the transaction.

Base Amount

Total amount in base currency (the primary currency that is in use for a business unit). Each business unit must have one base currency. This is usually the local currency for the organization, but accounting rules or other circumstances may dictate that it be different.

Not Marked to Accrue

Bills that you did not mark to accrue on the Standard Billing - Header - Info 2 page (ACCRUE_UNBILLED='N').

100% Revenue Distribution

Bills that do not have adequate revenue accounting information to create accounting entries.

No Dis/Sur ChartFields (no discount or surcharge ChartFields)

Bills that do not have adequate discount or surcharge accounting information to create accounting entries.

Bill Status Not Eligible

Bills with a bill status that is neither included on the list of statuses on the business unit nor INV, TMP, TMR, or CAN. Bills that did not accrue for this reason could have been disqualified for other reasons, as well. You must fix the status and run this report again to see if it was disqualified for any other reason.

Reason

System-generated message indicating why a report did not accrue.

Transaction Amount

Total amount in transaction currency (the currency that is used to complete the transaction).

Base Amount

Total amount in base currency (the primary currency that is in use for a business unit). Each business unit must have one base currency. This is usually the local currency for the organization, but accounting rules or other circumstances may dictate that it be different.

Group Heading

Group headings are dynamically constructed from the summarization template using the custom text defined in the template and the values in the field or fields upon which the grouping is based.

Summarization note

The text for the optional summarization note is defined in the summarization template.

Summarized line

The text displayed for summarized lines is dynamically constructed from the custom text in the template and the selected fields from the summarized bill lines.

Payment Reference

The payment reference helps match the acceptgiro payment to the invoice. The reference is printed in both the invoice and attached payment slip portions of the report. The payment reference number consists of a one-digit control code followed by a 15-digit, automatically generated number. The control code is calculated based on the digits in the generated number and serves to validate that the reference number was not garbled in transmission.