Processed DD Form 250s Detail

File Name: shipproc

Description: This report provides detail information on the number of DD 250s processed during the date range specified by the user. The data shown is ORG, PIIN, SPIIN, Shipment No, CLIN, Ship Qty, Acpt Qty, and Acceptance Site. The report is sorted in Org, PIIN, SPIIN, and Shipment No sequence. Users should note that shipment data only resides in MOCAS for 14 days after the contract has been closed at which time all line items, schedules and shipments are purged from MOCAS and consequently SDW also. Therefore it is impossible to get a valid count for anything past 14 days past the day the query is run.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

BEGIN DATE

Required

Text

The begin date to be selected.

END DATE

Required

Text

The end date to be selected.

ORG

Required

Picklist

The CAOs organization code.

 

Report Fields:

Field Name

MOCAS Name

Description

Org

org cd

The CAOs organization code.

PIIN

piiin

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.

Shipment No.

shpvcsno

Represents the actual contractor assigned Shipment Number of the shipments against this line item. A Z in the eighth position indicates a final shipment.

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.

Ship Qty

qty shipped

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

Acpt Qty

qty acpt

Quantity accepted is the number of items accepted.

Accept Site

acpt site

An indicator as to where Government acceptance has/will occur. The code (S-Source, D-Destination) is taken from the processed DD 250 record.

Acceptance Site Subtotals

N/A

Individual totals for the acceptance site.

Org Subtotals

N/A

The individual totals for each ORG

Report Totals

N/A

Totals of the individual totals combined.

 

Report Sample:

Processed DD Form 250s Detail

BEGIN DATE: 1998-04-01   END DATE: 1998-08-30
ORG:
'WF'
Date: 1999-08-30

ORG

PIIN

SPIIN
Shipment
No.

CLIN
Ship
Qty
Acpt
Qty
Accept
Site
WF F0470189C0073   AHX0043 0034 1 0 D
AHX0055 0035AE 1 0
Acceptance Site Subtotals:
DD 250s:    2              Line Items:    2
N0002495C4079   CAX0030 0032AB 1 1 S
N0010487GA043 5006 SGD0004Z 0001AA 1 1
Acceptance Site Subtotals:
DD 250s:    2              Line Items:    2
ORG Subtotals:
DD 250s:    4              Line Items:    4
Report Totals:
DD 250s:    4              Line Items:    4

4 rows returned.

Elapsed time: 9.4 seconds.

SELECT admin_by_cao, piin, spiin, ship_no, piin||spiin||ship_no,line_item_id, piin||spiin||ship_no||line_item_id, ship_qty, ship_qty_accepted, acceptance_site FROM shipments WHERE chain_cd = 'P' AND ship_no <> 'FIRSTART' AND (proc_dt >= TO_DATE('1998-04-01','YYYY-MM-DD') AND proc_dt <= TO_DATE('1998-08-30','YYYY-MM-DD')) AND admin_by_cao in ('WF') ORDER BY admin_by_cao, acceptance_site, piin, spiin, ship_no, line_item_id

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT