Orders Against Basic Ordering Agreements/Indefinite Delivery Type Contracts

 

File Name: orders

Description: This report provides a listing of all orders against Basic Ordering Agreements (BOA) and Indefinite Delivery Type (IDT) contracts within the parameters specified by the user on the prompt screen. The primary sort is by SPIIN. Users can further tailor the query data by Section and Part, CAGE, Assignment Code, or any combination of these fields.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

CONTRACT OBLIGATED AMT GREATER THAN OR EQUAL

Required

Dollar

Those contracts with obligated dollars equal to or in excess of the amount entered by the User.

CONTRACT OBLIGATED AMT LESS THAN OR EQUAL

Required

Dollar

Those contracts with obligated dollars equal to or less than the amount entered by the User.

CONTRACT UNLIQUIDATED GREATER THAN OR EQUAL

Required

Dollar

Unliquidated dollars greater than or equal to the amount indicated.

CONTRACT UNLIQUIDATED LESS THAN OR EQUAL

Required

Dollar

Unliquidated dollars less than or equal to the amount indicated.

UNLIQUIDATED PROGRESS PAYMENTS > OR =

Required

Dollar

Records pertaining to total unrecouped progress payments made to the contractor or subcontractor greater than or equal to the amount entered.

UNLIQUIDATED PROGRESS PAYMENTS < OR =

Required

Dollar

Records pertaining to total unrecouped progress payments made to the contractor or subcontractor less than or equal to the amount entered.

PIIN

Required

Text

These are the first 13 digits of the contract number.

ASSIGNMENT CODE

Required

Picklist

The code that depicts the level of administration.

SECTION

Required

Picklist

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

PART

Required

Picklist

Contract Administration Report (CAR) Part Codes assigned to the PIIN-SPIIN displayed.

CAGE

Optional

Text

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

 

Report Fields:

Field Name

MOCAS Name

Description

ORG

org cd

The CAO’s organization code.

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.

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.

ACO

aco code

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

K

kind contr cd

The kind of Contract Code reflects the basic intent of the contract, such as procurement of supplies, services, or research.

T

ty contr cd

The specific type of contract pricing provisions.

P

car partno

Contract Administration Report (CAR) Part Codes assigned to the PIIN-SPIIN displayed.

S

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.

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

unlq dv cont

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

Unliquidated Progress Payments

unlq dv pp

The total unrecouped progress payments made to the contractor or subcontractor.

Asgn Code

asgnm cd

The code that depicts the level of administration.

Date Closed

contr clsd dt

The date all administrative actions on a contract have been completed and all excess obligated funds have been removed. The contract is coded as closed in the database.

Totals

n/a

Total dollar amount for Contract Obligation, Contract Unliquidated, and Unliquidated Progress Payments for the report.

 

Report Sample:

Orders Against Basic Ordering Agreements/Indefinite Delivery Type Contracts

Contract Obligation From: -10000000000.00    Contract Obligation To: 10000000000.00
Contract Unliquidated From: -10000000000.00    Contract Unliquidated To: 10000000000.00
Unliquidated Progress Payments From: -10000000000.00    Unliquidated Progress Payments To: 10000000000.00
PIIN: N0001990G0200    CAGE:     ASSIGNMENT CODE: 'All'
SECTION: 'All'    PART: 'All'
Date: 1999-08-11
ORG PIIN SPIIN CAGE Contractor ACO K T P S Contract Obligation Contract Unliquidated Unliquidated
Progress Payments
Asgn
Code
Date
Closed
SF N00019 90 G0200   017N4 ALLIEDSIGNAL INC XR4 0   A 1 $0.00 $0.00 $0.00 P  
N00019 90 G0200 YC2K 1 J A 1 $6,796.00 $6,796.00 $0.00 P  
N00019 90 G0200 YC2S 1 J A 1 $4,613.16 $384.43 $0.00 P  
N00019 90 G0200 YC3M 6 J A 1 $19,282.00 $2,115.00 $0.00 P  
N00019 90 G0200 YC93 9 J A 1 $1,966,536.87 $864,302.51 $0.00 P  
N00019 90 G0200 YC94 1 J A 1 $371,312.00 $16,804.00 $0.00 P  
N00019 90 G0200 YC95 1 J A 1 $1,516,122.00 $254,104.50 $0.00 P  
Totals: 7   $3,884,662.03 $1,144,506.44 $0.00  

7 rows returned.

Elapsed time: .2 seconds.

SELECT admin_by_cao,piin,spiin,prime_cage,prime_name,aco_code, contract_purpose,contract_type,car_partno,current_sts,obligated_amount, unliq_con_amount,unliq_pp_amount,assignment_cd,closed_dt FROM contracts WHERE piin = 'N0001990G0200' AND obligated_amount >= TO_NUMBER('-10000000000.00') AND obligated_amount <= TO_NUMBER('10000000000.00') AND unliq_con_amount >= TO_NUMBER('-10000000000.00') AND unliq_con_amount <= TO_NUMBER('10000000000.00') AND unliq_pp_amount >= TO_NUMBER('-10000000000.00') AND unliq_pp_amount <= TO_NUMBER('10000000000.00') AND prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) ORDER BY admin_by_cao,prime_cage,td_piin

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT