Paid Invoices, Returned Invoices, Unpaid Invoices by Contractor

 

File Name: vendor

Description: This report provides a listing of paid invoices, returned invoices, and unpaid invoices by contractor for a specific contractor and date range selected by the user on the prompt screen. The primary sort is CAGE and then within CAGE by PIIN, SPIIN and Invoice Number.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

CAGE

Required

Text

A unique code assigned by the Government to an entity conducting business with or within the Government.

PAYMENT STATUS

Required

Picklist

This field describes whether an invoice is paid, unpaid or returned.

BEGIN DATE

Required

Interval

The begin date to be selected.

END DATE

Required

Interval

The end date to be selected.

 

Report Fields:

Field Name

MOCAS Name

Description

PIIN

piin

The first 13 digits of the contract number.

SPIIN

spiin

A number used in conjunction with the basic PIIN to identify the contract. This number is referred to as the call/order, or delivery order, under a Blanket Purchase Agreement (BPA), Basic Ordering Agreement (BOA), or Indefinite Delivery-Type (IDT) contract.

Invoice No.

inv no

The contractor number used to identify the contractor’s request for payment.

Shipment No.

ship no

Represents the actual contractor assigned Shipment Number of the shipments against this line item. A ‘Z’ in the eighth position indicates a final shipment.

Receipt Date

recv dt

Received Date.

Processed Date

proc date

Processed Date.

Due Date

pay due date

Payment Due Date.

Invoice Amount

inv amt

The amount the contractor is billing the Government for services and or deliveries made.

Check Amount

check amt

The amount the Government pays the contractor for the satisfaction of a requirement.

Check No.

check no

The check number on the check issued to a contractor.

RSN CD

rsn cd

Code used to identify the status of an invoice.

Remarks

remark

Additional information for an invoice reason code.

 

Report Sample:

Paid, Returned, and Unpaid Invoices by Contractor


CAGE: 017N4
BEGIN DATE: 1999-01-01   END DATE: 1999-08-11

Date: 1999-08-11
PIIN SPIIN Invoice No. Shipment No. Receipt Date Processed Date Due Date Invoice Amount Check Amount Check No. RSN CD Remarks
F42610 98 C0008   PERFBAS1 PBPA001 1999-06-14 1999-08-03 1999-07-14 $38,500.00 $38,500.00 E2000001 F  
PERFBAS2 PBPA002 1999-07-07 1999-08-04 1999-08-06 $52,000.00 $52,000.00 E2000001 F  
PERFBAS3 PBPA003 1999-08-03 1999-08-09 1999-09-02 $24,000.00 $24,000.00 E2000001 F  
PERFBAS4 PBPA004 1999-08-07 1999-08-10 1999-09-06 $23,500.00     A  
N00253 97 M1208   INV001 SIG0001 1999-06-03 1999-08-05 1999-07-03 $21,786.15 $21,786.15 E4000001 F AP

5 rows returned.

Elapsed time: 3.44 seconds.

SELECT piin,spiin,inv_no,ship_no,received_dt,proc_dt,pay_due_dt, inv_amt,check_amt,check_no,rsn_cd,remark,td_piin FROM invoices WHERE prime_cage LIKE DECODE('017N4',NULL,'%',LPAD('017N4',6,' ')) AND proc_dt >= TO_DATE('1999-01-01','YYYY-MM-DD') AND proc_dt <= TO_DATE('1999-08-11','YYYY-MM-DD') ORDER BY td_piin,inv_no,pay_due_dt,received_dt,proc_dt

 

Back to Contract Administration Menu


HOME | QUERY MENU | USERS GUIDE | ABOUT