ODO Contracts Received Detail

File Name: odocond

Description: This report provides a listing of all ODO contracts received/accepted within the date range specified by the user. The data shown is Received Date, Buying Activity, ACO, CAGE, Contractor, PIIN, SPIIN, Section, ODO Obligation, Contract Obligation, Contract Unliquidated. ODO contracts which have been transmitted via EDI or MILSCAP and have rejected will NOT be shown on the report. The report is sorted by received date. Users can further tailor the report by ACO, Cage, and Buying Activity. Report totals are provided. Note ODO contracts normally do not contain a contract obligation or unliquidated obligation as they are paid by other than MOCAS. The only time an ODO contract contains entries in these fields is if it is improperly input into MOCAS, or is a partial ODO, i.e. that is part of the contract is paid by MOCAS and part is paid by another Payment Office.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

BEGIN DATE

Required

Text

The date that the user wishes to start with.

END DATE

Required

Text

The date that the user wishes to end with.

ORG

Required

Picklist

The CAO' s organization code.

DEPT CODE

Required

Picklist

A code used for Service Agency designation.

ACO

Optional

Text

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

CAGE

Optional

Text

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

BUYING ACTIVITY (2 Pos)

Optional

Text

A 2-position code of the office issuing the contract.

 

Report Fields:

Field Name

MOCAS Name

Description

Received Date

contr rcvd dt

Received Date of the Invoice

Buying Activity

buyg acty cd

A 2-position code of the office issuing the contract.

Cage

cage

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

Contractor

contr/payrr 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.

Sec

car sec no

Contract Administration Report Section Number is a code assigned to a procurement instrument that depicts the status of a contract during its lifecycle.

ODO Obligation

odo obligation

The ODO obligation for the contract.

Contract Obligation

obligated amount

The dollars that have been committed to a specific effort. Specifically, it is the Contract Total Obligated amount ($).

Contract Unliquidated

unlq dv con

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

ACO

aco code

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

ORG

org cd

The CAO's organization code.

Report Totals

N/A

Total of individual totals combined.

 

Report Sample:

ODO Contracts Received Detail

BEGIN DATE: 1998-01-01  END DATE: 1999-03-30
ORG:
'All'
DEPT CODE: 'All'
ACO:    CAGE: 7S526  BUYING ACTIVITY:
Date: 1999-08-11
Received
Date
Buying
Activity
CAGE Contractor PIIN SPIIN Sec ODO
Obligation
Contract
Obligation
Contract
Unliquidated
ACO: JR1  ORG: JF
1998-04-17 UB 7S526 BTMC CORP SP0750 98 M6419   1 $3,583.80 $.00 $.00
1998-04-04 UB SP0770 98 MDR84   1 $1,326.20 $.00 $.00
1998-03-27 TZ SP0560 98 MAU59   1 $2,364.58 $.00 $.00
1998-03-19 TY SP0450 98 MAB33   1 $175.45 $.00 $.00
1998-03-15 UB SP0750 98 M0716   1 $2,470.53 $.00 $.00
UB SP0750 98 MC769   1 $430.20 $.00 $.00
1998-02-23 TZ SP0560 98 MV762   1 $7,054.85 $.00 $.00
1998-01-31 TZ SP0560 98 W0804   1 $13,883.52 $.00 $.00
1998-01-19 TZ SP0560 98 MK835   1 $1,213.97 $.00 $.00
1998-01-15 UB SP0750 98 M0382   1 $2,724.20 $.00 $.00
1998-01-11 UB SP0750 98 M0359   1 $919.20 $.00 $.00
1998-01-08 TZ SP0560 98 MF858   2 $8,588.74 $.00 $.00
1998-01-04 UB SP0750 98 M6232   1 $3,631.50 $.00 $.00
Totals: 13 $48,366.74 $.00 $.00

13 rows returned.

Elapsed time: .26 seconds.

SELECT unliq_con_amount, obligated_amount, other_obligated_amt, current_sts, dept_cd, buying_activity_cd, spiin, piin, prime_name, prime_cage, aco_code, admin_by_cao, received_dt FROM contracts WHERE assignment_cd = 'P' AND paying_office = '9' AND NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND prime_cage LIKE DECODE('7S526',NULL,'%',LPAD('7S526',6,' ')) AND NVL(buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') AND received_dt >= TO_DATE('1998-01-01','YYYY-MM-DD') AND received_dt <= TO_DATE('1999-03-30','YYYY-MM-DD') ORDER BY aco_code,admin_by_cao,prime_cage,prime_name,received_dt DESC,td_piin

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT