Detail Billing Record Search
The Detail Billing Record Search query allows users to search for detail billing records and the transactions associated with them. The query is accessible from the VSS menu bar, enabling VSS users to search for their billing details without being in a bill document. Search results on the query may contain detail billing records from one or many bills, depending on the search criteria. The query joins information from the VSS vendor information, bill header, bill accounting line, and detail billing record information.
Orphaned detail billing records are not displayed in VSS. Only detail billing records associated with transactions viewable in VSS are available through the Detail Billing Record Search.
The Detail Billing Record Search can be accessed using the following path from the desktop:
Billing>Detail Billing Record Search
The Detail Billing Record Search records several types of information. It contains the following buttons, pages, and tabs (click each tab for more information): (* indicates a required field)
There are several buttons on the Bill Search. Some buttons will not be active if a record is not selected.
| Button | Description |
|---|---|
|
Search |
|
|
Clear |
|
|
View |
|
|
Next |
|
|
Previous |
|
|
View Document |
|
|
View Statement |
|
This is the search page of the Detail Billing Record search.
Search Criteria
General Criteria
| Field Name | Description |
|---|---|
|
Referenced Bill Document Number |
|
|
Billing Reference Number |
|
|
Bill Title |
|
|
Bill Generated Date From/To |
|
|
Type of Transfer |
|
|
Currency |
|
|
Statement |
|
|
Bill Generated |
|
|
Business Line |
|
Line Criteria
| Field Name | Description |
|---|---|
|
Principal Amount From/To |
|
|
Total Amount From/To |
|
|
Line Number |
|
|
Line Type |
|
|
Disputed |
|
|
Billing Status |
|
|
Source Number |
|
|
Invoice Number |
|
|
Period of Performance Start Date From/To |
|
|
Period of Performance End Date From/To |
|
Additional Criteria
Vendor Criteria
| Field Name | Description |
|---|---|
|
Agency |
|
|
Registration Number |
|
|
Code (Vendor) |
|
|
Address Code |
|
|
Name |
|
|
DUNS+4 |
|
|
UEI |
(Unique Entity Identifier) - An identifier used to identify a specific commercial, nonprofit, or Government entity. |
|
EFT Indicator |
EFT Indicator - Unique code used to identify additional bank accounts associated to a single UEI. |
|
Bureau |
|
|
Agency Location Code |
|
Detail Billing Record Criteria
| Field Name | Description |
|---|---|
|
Unique Record Identifier |
|
|
Commodity Code |
|
|
Quantity |
|
|
Record Date From/To |
|
|
Charge Period |
|
|
Articles/Services Description |
|
|
Detail Amount From/To |
|
Funding Information
| Field | Description |
|---|---|
|
Partition |
|
|
BBFY |
|
|
EBFY |
|
|
Fund |
|
|
Division |
|
|
Organization |
|
|
Sub Organization |
|
|
Program |
|
|
Project |
|
|
Sub Project |
|
|
Activity |
|
|
Object |
|
|
Sub Object |
|
|
Revenue Source |
|
|
Sub Revenue Source |
|
|
User Dimension 1-10 |
|
|
Reimbursable Object |
|
|
Reimbursable Sub Object |
|
|
Canceled BBFY |
|
|
Canceled EBFY |
|
|
Canceled Fund |
|
|
Cost Organization |
|
|
Sub Cost Organization |
|
|
YBA |
|
|
BETC |
|
|
PRC |
|
|
Cohort Year |
|
G-Invoicing
| Field Name | Description |
|---|---|
|
GT&C Number |
The General Terms and Conditions Number |
|
Order Number |
The unique number that identifies the document. |
|
Line |
The numeric value of the line. |
|
Schedule |
Schedule information |
|
G-Inv / IPAC Indicator |
Select G-Invoicing or IPAC Indicators to limit search. |
IPAC
| Field Name | Description |
|---|---|
|
Customer Treasury Symbol |
|
|
Customer Funding Source |
|
|
Funding Document |
|
|
Requisition Number |
|
|
JAS Number |
|
|
Job Number |
|
|
Accounting Classification Code |
|
|
Accounting Classification Reference Number |
|
|
DOD Activity Address Code |
|
|
Accounting Trace Number |
|
|
Fiscal Station Number |
|
|
Customer BETC |
|
|
ATA |
|
|
AID |
|
|
BPOA |
|
|
EPOA |
|
|
A |
|
|
MAIN |
|
|
SUB |
|
Referenced Entities
| Field Name | Description |
|---|---|
|
Agreement Number |
|
|
Debt Account Number |
|
|
Contract Number |
|
|
Blanket Agreement Number |
|
Detail Billing Record
Detail Billing Elements
| Field Name | Description |
|---|---|
|
Detail Billing Element 1-15 |
|
Detail Billing Text Elements
| Field Name | Description |
|---|---|
|
Detail Billing Text Element 1-80 |
|
Detail Billing Number Elements
| Field Name | Description |
|---|---|
|
Detail Billing Number Element 1-25 |
|
Detail Billing Amount Elements
| Field Name | Description |
|---|---|
|
Detail Billing Amount Element 1-45 |
|
Detail Billing Date Elements
| Field Name | Description |
|---|---|
|
Detail Billing Date Element 1-35 |
|
User Defined Fields
| Field Name | Description |
|---|---|
|
User Defined Field 1-10 |
|
Search Results
Each row in the summary represents one detail billing record line from Momentum. The accounting line information is repeated for each detail billing record under a specific accounting line.
Summary
The fields listed in the Summary section are defined above except:
| Field Name | Description |
|---|---|
|
Principal Amount |
|
|
Total Amount |
|
|
Total Outstanding Amount |
|
|
Total Collected Amount |
|
|
Disputed |
|
|
Unique Record Identifier |
|
|
Record Date |
|
|
Detail Amount |
|
|
Total Applied Credit |
|
|
Source Record ID |
|
Totals Row
Upon retrieving the search results from the query, the system will sum and display the amount totals. The totals display for all amount fields regardless of currency and are calculated across all search results even if multiple pages.
If search results contain multiple currencies, the totals will not be calculated.
| Field Name | Description |
|---|---|
|
Total Amount |
|
|
Collected Amount |
|
|
Adjustment Amount |
|
|
Closed Amount |
|
|
Outstanding Amount |
|
|
Outstanding Chargeback Amount |
|
|
Credit Amount |
|
|
Applied Credit Amount |
|
|
Closed Credit Amount |
|
|
Outstanding Credit Amount |
|
Accessed by selecting an item on the Detail Billing Records Search Summary and clicking the View button. Displays the details of the selected Billing Record.
Field descriptions listed below are broken down by section for easy searching. To find the field description you need, locate the section title on the table in VSS and find the field in the corresponding category below.
General
| Field Name | Description |
|---|---|
|
Referenced Bill Document Number |
|
|
Billing Reference Number |
|
|
Bill Title |
|
|
Bill Generated Date |
|
|
Type of Transfer |
|
|
Currency |
|
|
Business Line |
|
|
Bill Generated |
|
|
Statement Number |
|
|
Collection Due Date |
|
Vendor Information
| Field Name | Description |
|---|---|
|
Agency |
|
|
Registration Number |
|
|
Code (Vendor) |
|
|
Address Code |
|
|
Name |
|
|
DUNS+4 |
|
|
EFT Indicator |
EFT Indicator - Unique code used to identify additional bank accounts associated to a single UEI. |
|
UEI |
(Unique Entity Identifier) - An identifier used to identify a specific commercial, nonprofit, or Government entity. |
|
Bureau |
|
|
Agency Location Code |
|
|
Designated Agent Code |
|
|
Designated Agent Address Code |
|
Line Information
General
| Field Name | Description |
|---|---|
|
Line Number |
|
|
Line Type |
|
|
Disputed |
|
|
Source Number |
|
|
Billing Status |
|
|
Closed Date |
|
|
Period of Performance Start Date |
|
|
Period of Performance End Date |
|
|
Disputed Date |
|
Amounts
| Field Name | Description |
|---|---|
|
Principal Amount |
|
|
Interest Amount |
|
|
Admin Charges Amount |
|
|
Penalty Amount |
|
|
Initial Amount |
|
|
Discount Amount |
|
|
Surcharge Amount |
|
|
Total Amount |
|
Totals
| Field Name | Description |
|---|---|
|
Totals Chart |
|
Referenced Amounts
| Field Name | Description |
|---|---|
|
External Offset Amount |
|
|
Internal Offset Amount |
|
|
Refunded Amount |
|
|
Outstanding Chargeback Amount |
|
Referral Amounts
| Field Name | Description |
|---|---|
|
Collections Agency Referred Amount |
|
|
Department of Justice Referred Amount |
|
|
Treasury Servicing Referred Amount |
|
|
Other Referred Amount |
|
|
External Offset Referred Amount |
|
|
Referral Collected Amount |
|
Funding
| Field | Description |
|---|---|
|
Partition |
|
|
BBFY |
|
|
EBFY |
|
|
Fund |
|
|
Division |
|
|
Organization |
|
|
Sub Organization |
|
|
Program |
|
|
Project |
|
|
Sub Project |
|
|
Activity |
|
|
Object |
|
|
Sub Object |
|
|
Revenue Source |
|
|
Sub Revenue Source |
|
|
User Dimension 1-10 |
|
|
Reimbursable Object |
|
|
Reimbursable Sub Object |
|
|
Canceled BBFY |
|
|
Canceled EBFY |
|
|
Canceled Fund |
|
|
Cost Organization |
|
|
Sub Cost Organization |
|
|
YBA |
|
|
BETC |
|
|
PRC |
|
|
Cohort Year |
|
Printing
| Field Name | Description |
|---|---|
|
Comments to Print |
|
Dunning
| Field Name | Description |
|---|---|
|
Dunning Count |
|
|
Last Dunning Date |
|
|
Last Dunning Amount |
|
G-Invoicing
| Field Name | Description |
|---|---|
|
GT&C Number |
The General Terms and Conditions Number |
|
Order Number |
The unique number that identifies the document. |
|
Line |
The numeric value of the line. |
|
Schedule |
Schedule information |
|
G-Inv / IPAC Indicator |
Select G-Invoicing or IPAC Indicators to limit search. |
IPAC
| Field Name | Description |
|---|---|
|
Customer BETC |
|
|
Customer Funding Source |
|
|
Funding Document |
|
|
Requisition Number |
|
|
JAS Number |
|
|
Job Number |
|
|
Accounting Classification Code |
|
|
Accounting Classification Reference Number |
|
|
DOD Activity Address Code |
|
|
Accounting Trace Number |
|
|
Fiscal Station Number |
|
|
Job Number |
|
|
Internal Obligation Document Number |
|
|
Customer Treasury Symbol |
|
|
Transaction Contact |
|
|
Contact Phone Number |
|
|
ATA |
|
|
AID |
|
|
BPOA |
|
|
EPOA |
|
|
A |
|
|
MAIN |
|
|
SUB |
|
Agreement
| Field Name | Description |
|---|---|
|
Agreement Number |
|
|
Agreement Line Number |
|
Debt Account
| Field Name | Description |
|---|---|
|
Debt Account Number |
|
|
Debt Account Line Number |
|
|
Depository Line Number |
|
|
Payee Line Number |
|
Contract
| Field Name | Description |
|---|---|
|
Contract Number |
|
|
Blanket Agreement Number |
|
|
Delivery Order Number |
|
|
Contract Line Item Number |
|
|
Sub Contract Line Item Number |
|
|
Blanket Agreement Line Item Number |
|
|
Sub Blanket Agreement Line Item Number |
|
|
Invoice Number |
|
User Defined Fields
| Field Name | Description |
|---|---|
|
User Defined Fields 1-10 |
|
Description
| Field Name | Description |
|---|---|
|
Description |
|
Additional Criteria
| Field Name | Description |
|---|---|
|
Printed Message |
|
Detail Billing Record Information
General
| Field Name | Description |
|---|---|
|
Unique Record Identifier |
|
|
Commodity Code |
|
|
Quantity |
|
|
Charge Period |
|
|
Record Date |
|
|
Source Record ID |
|
Detail Billing Elements
| Field Name | Description |
|---|---|
|
Detail Billing Element 1-15 |
|
Text Elements
| Field Name | Description |
|---|---|
|
Detail Billing Text Element 1-80 |
|
Number Elements
| Field Name | Description |
|---|---|
|
Detail Billing Number Element 1-25 |
|
Amount Elements
| Field Name | Description |
|---|---|
|
Detail Billing Amount Element 1-45 |
|
Date Elements
| Field Name | Description |
|---|---|
|
Detail Billing Date Element 1-35 |
|
Description
| Field Name | Description |
|---|---|
|
Articles/Services Description |
|