Contract Receipts

File Name: krcpt

Description: This report provides a listing of all contracts received within the date range selected by the user on the prompt screen. The primary sort is ACO, CAGE and then within Date Received. Users can further tailor the query data by ACO, Buying Activity, Type Contract, Department Code, Assignment Code, or any combination of these fields.

At the end of the report, totals should be reflected for the following fields: PIIN, Contract Obligation, and Contract Unliquidated.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

RECEIVED DATE BEGINNING

Required

Interval

The lower limit of the date range.

RECEIVED DATE ENDING

Required

Interval

The upper limit of the date range.

OBLIGATED DOLLAR VALUE FROM

Required

Dollars

Records applicable to contracts with an obligated $ amount of at least the amount specified.

CONTRACT OBLIGATED AMT LESS THAN OR EQUAL TO

Required

Dollars

Records applicable to contracts with an obligated $ amount less than or equal to the amount specified.

ORG

Required

Picklist

The CAO's organization code.

ACO

Optional

Text

The code which identifies the Administrative Contracting Officer assigned to the contract.

CAGE

Optional

Text

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

BUYING ACTIVITY (2 Pos)

Optional

Text

The 2 position Buying Activity code of the office issuing the contract.

TYPE CONTRACT

Optional

Text

The specific type of contract pricing provisions.

DEPT CODE

Optional

Text

A code used for Service Agency designation.

ASSIGNMENT CODE

Optional

Text

The code that depicts the level of administration.

 

Report Fields:

Field Name

MOCAS Name

Description

Begin Date

contr rcvd dt

The beginning date that was entered in the prompt field.

End Date

contr rcvd dt

The ending date that was entered in the prompt field.

Buying Activity

buyg acty cd

The Buying Activity code that was entered in the prompt field.

Part

car partno

The Contract Administration Report Part Number Code that was entered in the prompt field.

ORG

admin by cao

The CAO's organization code.

ACO

aco code

The code which identifies the Administrative Contracting Officer assigned to the contract.

Date Received

received dt

The date a document is recorded as officially received.

CAGE

prime cage

Commercial and Government Entity. A code assigned by the Government to an entity conducting business with or within the Government.

Contractor

prime name

The official name of the entity supplying goods and services to the Government.

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.

Contract Obligation

obligated amount

The dollar amount stated at a contract or call/order level, by appropriation, that a Government agency will eventually disburse.

Contract Unliquidated

unliq dv cont

The total remaining dollar obligation on a contract, call/order after disbursements have been made.

Asgn Code

assignment cd

The code that depicts the level of administration.

Totals

N/A

The grand total for the report.

 

Report Sample:

Contract Receipts

BEGIN DATE: 1999-01-01   END DATE: 1999-08-03
OBLIGATED DOLLAR VALUE FROM: 0000.00  OBLIGATED DOLLAR VALUE TO: 0000.00
ORG:
'WF'
ACO:    CAGE:    BUYING ACTIVITY:
TYPE CONTRACT:   DEPARTMENT CODE:    ASSIGNMENT CODE:
Date: 1999-08-03
ORG ACO Date
Received
CAGE Contractor PIIN SPIIN Contract Obligation Contract Unliquidated Asgn
Code
WF XU6 1999-01-31 03928 COURTNEY'S PLACE DAAE07 99 C1235   $0.00 $0.00 P
XU6 1999-01-22 0A789 RETEST INC. F09603 99 C0002   $0.00 $0.00 P
XU6 1999-01-22 0CABC RETEST TRIFLE CO DAAA09 99 C0002   $0.00 $0.00 P
XU6 F09603 99 C0004   $0.00 $0.00 P
XU6 1999-02-07 0LESS LAURAAN'S COMPANY DAAA09 00 M9136   $0.00 $0.00 P
XU6 1999-02-07 1TAM3 DAD'S COMPANY F09603 00 C0011   $0.00 $0.00 P
XU6 1999-02-07 3SIMP LAURA'S COMPANY F09603 00 C0014   $0.00 $0.00 P
XU6 F09603 00 C0015   $0.00 $0.00 P
XU6 1999-02-07 4APPL CHAD'S COMPANY F09603 00 P0090   $0.00 $0.00 P
XU1 1999-01-15 98765 ROD'S BAIT SHOP F09603 99 C0001   $0.00 $0.00 P
XU6 1999-01-22 BU769 RETEST CO DAAA09 99 C0001   $0.00 $0.00 P
XU6 F09603 99 C0003   $0.00 $0.00 P
XU6 1999-01-22 DOUG9 RETEST MARBLE CO DAAA09 99 C0003   $0.00 $0.00 P
XU6 1999-01-22 FE123 RETEST TRIAL DAAA09 99 C0004   $0.00 $0.00 P
Totals: 14 $0.00 $0.00

14 rows returned.

Elapsed time: .49 seconds.

SELECT admin_by_cao, aco_code, received_dt, prime_cage, prime_name, piin, spiin, obligated_amount, unliq_con_amount, assignment_cd FROM contracts WHERE NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND admin_by_cao in ('WF') AND prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND NVL(buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') AND received_dt >= TO_DATE('1999-01-01','YYYY-MM-DD') AND received_dt <= TO_DATE('1999-08-03','YYYY-MM-DD') AND NVL(contract_type,'X') LIKE DECODE('',NULL,'%','%') AND assignment_cd like '%' AND dept_cd like '%' AND obligated_amount >= 0000.00 AND obligated_amount <= 0000.00 ORDER BY admin_by_cao,prime_cage, prime_name, received_dt, td_piin, aco_code, spiin, assignment_cd, obligated_amount, unliq_con_amount

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT