Contract Line Item Status

 

File Name: clinhist

Description: This Report provides a listing of all Line Items and their status for a specific contract selected by the user on the prompt screen. The primary sort is CLIN. Users can further tailor the query to a specific CLIN, or any combination of these fields.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

PIIN

Required

Text

These are the first 13 digits of the contract number.

SPIIN

Optional

Text

SPIIN is the 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.

CLIN

Optional

Text

The CLIN identifies each supply or service recorded in the database. The number will appear once for each separate item, even if multiple schedules apply.

 

Report Fields:

Field Name

MOCAS Name

Description

CLIN

clin elin

The Contract Line Item Number identifies each supply or service recorded in the database. The number will appear once for each separate item, even if multiple schedules apply.

Noun

noun

The name of the item or purpose for which the contract line item was established.

Order Qty

ord qty

Order quantity for a given line item.

Ord Qty Stat

qty sts

Status Cd or blank if equal to A

Ship Qty

qty shipped

The number of items which have been shipped which apply to the schedule.

Acpt Qty

qty acpt

Quantity Accepted - The number of items accepted.

Unit Price

unit prc

The cost of each item ordered. An E displayed to the right of the unit price indicates the unit price is estimated.

Unit Prc Stat

unit prc

Unit Price Cd or blank if equal to A

Total Price

tot itm amt

The sum of the unit price times the order quantity for each line item.

Tot Amt Stat

tot itm amt

Amt Status Cd or blank if equal to A

Dlvy Sched Date

dlvy sched dt

Delivery Schedule Date - The Contractual Date for delivery. When the date is estimated, it will be followed by an E.

Dlvy Sched Qty

dlvy sched qty

Delivery Schedule Quantity - The amount of the item that is to be delivered according to this schedule.

Sched Qty Shipped

qty shpd ft

 

Schedule Quantity Shipped - The total quantity shipped against the schedule.

Qty Var Over

qty var ovr

The over run percent for the line item as authorized by the contract.

Qty Var Under

qty var und

The under run percent for the line item as authorized by the contract.

 

Report Sample:

Contract Line Item Status

PIIN: SP074097MGZ31   SPIIN:    CLIN:
Date: 1999-08-03
CLIN Noun Order
Qty
Ord
Qty
Stat
Ship
Qty
Acpt
Qty
Unit Price Unit
Prc
Stat
Total Price Tot
Amt
Stat
Dlvy
Sched
Date
Dlvy
Sched
Qty
Sched
Qty
Shipped
Qty
Var
Over
Qty
Var
Under
0001 TUBE ASSEMB 21   21 21 $300.00   $6,300.00   1998-01-21 21 21 5.00% 5.00%
0002 TUBE ASSEMB 7   7 7 $300.00   $2,100.00   1998-01-21 7 7 5.00% 5.00%

2 rows returned.

Elapsed time: .07 seconds.

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT