Negative Contract or ACRN ULO

File Name: negulo

Description: This report lists all contracts that have either a total negative ULO or an ACRN with a negative ULO. When the total ULO is negative, the report lists all ACRNS (both positive and negative ULO). When the overall contract has a positive ULO, only the ACRNS with a negative ULO are listed.

Prompts for Org Code and Department Code are required. Report is displayed by Buying Activity within the selected prompts.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

ORG

Required

Picklist

The CAO’s organization code.

DEPT CODE

Required

Picklist

A code used for Service Agency designation.

BUYING ACTIVITY (2 POS)

Optional

Text

The 2 position code of the office issuing the contract.

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.

 

Report Fields:

Field Name

MOCAS Name

Description

Buying Activity

buyg acty cd

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

Org

org cd

The CAO’s organization code.

Aco

aco code

The code which identifies the Administrative Contracting Officer assigned to 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/payee 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. The 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.

Section

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 dollars stated at a contract or call/order level, by appropriation, that a Government agency will eventually disburse.

Contraction Unliquidated

unlq dv cont

Contract Unliquidated Amount-

ACRN

acrn id

Accounting Classification Reference Number-this is a control number which relates to the long line accounting classification citation number.

ACRN Obligation

oblg amt

That dollar amount stated at ACRN level.

ACRN Unliquidated

unlq dv

Total unliquidated dollar value for this ACRN.

Contract Subtotals

N/A

Subtotal for each ACO.

Report Totals

N/A

Total of individual totals combined.

 

Report Sample:

Negative Contract or ACRN ULO

ORG:
'All'
DEPT CODE: 'All'
BUYING ACTIVITY: GM  ACO:   CAGE:
Date: 1999-08-17
Buying
Activity
ORG ACO CAGE Contractor PIIN SPIIN Section Contract
Obligation
Contract
Unliquidated
ACRN ACRN
Obligation
ACRN
Unliquidated
GM
SF XS3 017N4 ALLIEDSIGNAL INC
N68936 95 C0016
 
1
$34,264,889.71 $1,300,524.91
AC
$2,800,000.00 -$9,623.16
BD
$100,000.00 -$8,092.80
AV
$450,000.00 -$101,945.21
AE
$25,000.00 -$35.19
BC
$1,446,940.49 -$24,881.08
AD
$34,487.08 -$549.70
AS
$35,000.00 -$62,242.00
Contract Subtotals: $4,891,427.57 -$207,369.14
N68936 97 C0166
 
1
$16,927,959.55 $14,216,075.12
AA
$0.00 -$2,266,719.16
Contract Subtotals: $.00 -$2,266,719.16
Report Totals: 2 $51,192,849.26 $15,516,600.03 8 $4,891,427.57 -$207,369.14

8 rows returned.

Elapsed time: 13.07 seconds.

SELECT t1.buying_activity_cd, t1.admin_by_cao, t1.aco_code, t1.prime_cage, t1.prime_name, t1.piin, t1.spiin, t1.current_sts, t1.obligated_amount, t1.unliq_con_amount, t2.acrn_id, t2.obligated_acrn_amount, t2.unliq_acrn_amount, t1.td_piin, t2.sub_trans_cd FROM contracts t1, ACRNS t2 WHERE t1.pins_agmt_id = t2.pins_agmt_id AND t1.primary_flag = 'Y' AND (t2.unliq_acrn_amount < 0 OR t1.unliq_con_amount < 0 AND t2.sub_trans_cd = 'B') AND t1.assignment_cd in ('P','G') AND t1.current_sts < '5' AND NVL(t1.aco_code,'X') LIKE DECODE('',NULL,'%','%') AND t1.prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND NVL(t1.buying_activity_cd,'X') LIKE DECODE('GM',NULL,'%','GM%') ORDER BY t1.buying_activity_cd,t1.admin_by_cao, t1.prime_cage, t1.td_piin

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT