ID6_260601_PWS_Attach_2_WWRS_IIP_Data_Download_Formats.pdf

FA8630-26-R-B009

Performance Work Statement

IIP and Services for WWRS

Attachment #2

AFSAC-On-line (WWRS subsystem) Data Download Formats

RDO Dataset – Text file, (“^”) Delimited Field Name Data Type Length / Format Description

RDO ID Number 10 ID assigned to Seller’s Redistribution Order

RDO Number Char 14 Seller’s Redistribution Order

Requisition Header

ID

Number 10 The unique ID that ties RDO Numbers to the buyer’s requisitions that are being filled

Country Code Char 2 The seller’s country code

Account Number Char 10 The seller’s WWRS account number

Created On Date DD-MON-YYYY The date on which the RDO was created

Released On Date DD-MON-YYYY The date on which the RDO was released to the seller

RDO Authorization Char 14 The RDO number “authorizing” the current RDO to be released to the seller

WWRS Fee % Number 2,2 The percent (of material value) used as the basis for the WWRS fee

Pricing Category Char 1 The type of RDO sent to the seller

Split Shipments Char 1 Have partial shipments been approved for this RDO

Case Designator Char 3 The seller’s FMS case used to pay the WWRS Fee

Case/Line Number Char 3 The seller’s FMS case line used to pay the WWRS Fee

Line Number Number 2 The RDO Line Number

Identifier Char 10 The account identifier under which the RDO was sent to the seller

NIIN Char 9 The national item identification number being ordered

NSN Char 15 The national stock number being ordered

FSC Char 4 The federal supply classification of the item being ordered

MMC Char 2 The material management code of the item being ordered

Item Name Char 40 The description of the item being ordered

Part Number Char 32 The manufacturer’s part number of the item being ordered

CAGE Code Char 5 The manufacturer’s identification code

Condition Char 1 The code representing the condition of the item

MOV Number 10,2 The minimum order value as set by the seller

WWRS Qty Number 10 The quantity being ordered by WWRS

WWRS Unit Price Number 11,2 The unit price of the material being ordered

Order Value Number 11,2 The extended material value of the RDO

List Price Number 11,2 The listed unit price of the material as set by the seller

DoD Price Number 11,2 The stock list price of the material when ordered

Price Authorized Char 1 Was the selling unit price of the material authorized by the seller

Estimated Seller Proceeds

Number 11,2 The estimated dollar amount the seller is set to earn as a result of this sale

Estimated WWRS Charge

Number 11,2 The estimated WWRS redistribution fee

Estimated WWRS Payback

Number 11,2 The estimated seller payback for this order. This field is no longer used

Estimated WWRS Proceeds

Number 11,2 The estimated dollar amount the PMO is set to earn as a result of this sale

Estimated IIP

Charge

Number 11,2 The estimated dollar amount the IIP is set to earn as a result of this sale

RDO Line Open Char 1 Is this RDO line open or closed

Closed On Date DD-MON-YYYY The date on which the RDO line was closed

Days to Ship Number 3 The estimated number of days expected to receive the material from the seller based upon when the RDO was released

Status Char 2 The current status of the RDO

Expires On Date DD-MON-YYYY The date the RDO will expire if material is not received

Outstanding Extension Request

Char 1 Has the seller requested an extension on this RDO

Extension Requested On

Date DD-MON-YYYY The date on which the extension was requested by the seller

Extension Requested By

Char 30 The username of the person requesting the extension

Total Accepted Qty Number 5 The quantity accepted (and shipped to the buyer) on this RDO

Qty Due In Number 5 The quantity still due in to the IIP

Original WWRS

Qty

Number 5 The quantity on the RDO when first created

Original WWRS Unit Number 11,2 The unit price of the material on this RDO when first created

IIP and Services for WWRS

Attachment #2

Price

Requisition Qty Unfilled

Number 5 The quantity left unfilled on the buyer’s requisition

Advice Code Char 2 The advice code on the requisition(s) being filled

Status State Char 15 The state of the RDO

Lot Identifier Char 30 The identification on an RDO that ties it to a particular lot buy

Qty Unit Pack Code Char 1 The quantity unit pack code on the item being ordered

UI - Unit Of Issue Char 2 The unit of issue of the material being ordered

Actual Seller Proceeds

Number 11,2 The actual amount of money the seller realized by selling the material

Actual WWRS

Charge

Number 11,2 The actual amount of money the WWRS PMO charge the seller as a redistribution fee

Actual WWRS Payback

Number 11,2 The actual amount of money paid back to the seller (as it relates to the what the standard WWRS fee would have been)

Actual WWRS

Proceeds

Number 11,2 The actual dollar amount realized by the WWRS PMO after IIP fees are paid

Actual IIP Charge Number 11,2 The actual dollar amount charged by the IIP on this order

Actual Freight

Charges

Number 11,2 Any freight charges (charged to the seller) for services by the IIP to aid the seller to get the material to the IIP

Actual Additional Charge

Number 11,2 Any additional charges incurred by the IIP (and charged back to the seller) for inspecting the material

Actual Disposal

Charges

Number 11,2 Disposal charges on material disposed of by the IIP

Inspection Count Number 2 The number of inspections performed on material for this RDO

Awaiting Shipping Information

Char 1 Is the WWRS PMO awaiting shipping response from the seller

Outstanding Short

Shipment

Char 1 Is a short shipment notification awaiting seller response

IIP and Services for WWRS

Attachment #2

RDO Inspection Dataset – Text file, (“^”) Delimited

Field Name Data Type Length /Format Description

RDO Number Char 14 Seller’s Redistribution Order

Line Number Number 2 The RDO Line Number

Inspection Number Number 2 The inspection number (sequence number) on the RDO Line

Shipped On Date DD-MON-YYYY The date the material was shipped by the seller

Shipment Entered

On

Date DD-MON-YYYY The date the shipment information was entered by the e seller

Shipment Entered By

Char 30 The user who entered the seller shipment information

Qty Shipped Number 5 The quantity the seller promises to ship

Box Number Char 30 The box or packing slip number under which the material is/was shipped

Awaiting Material Receipt

Char 1 Is the IIP awaiting the material to be received

Received On Date DD-MON-YYYY The date the material was received at the IIP

Inspected On Date DD-MON-YYYY The date the material was inspected by the IIP

Qty Received Number 5 The quantity received at the IIP

Qty Accepted Number 5 The quantity accepted (and shipped to the buyer) by the IIP

Qty Broken Number 5 The quantity received that was broken

Qty Wrong Item Number 5 The quantity received that was not expected item

Qty Overage Number 5 The quantity over and above what was required on the RDO

Qty Overage and Broken

Number 5 The quantity received that was above what was expected and was also broken

Qty On Hold Number 5 The quantity received that an immediate decision could not be made on

Outstanding Qty On

Hold

Char 1 Is their material on hold at the IIP

Qty On Hold Released On

Date DD-MON-YYYY When was the quantity on hold released

Qty On Hold

Released By

Char 30 The user who released the quantity on hold

Shipped To Buyer Char 1 Was quantity received shipped to the buyer

WWRS Charge Number 11,2 The WWRS charge for the material accepted

IIP Charge Number 11,2 The IIP Charge for the material accepted

WWRS Payback Number 11,2 The difference in the actual WWRS charge and the standard WWRS

Charge

Freight Charge Number 11,2 Any freight paid by the IIP and charged back to the seller

Additional Charge Number 11,2 Any additional inspection charges by the IIP (charged back to the seller)

Outstanding Short Shipment

Char 1 Does the seller need to respond to a short shipment request

Short Shipment Expires On

Date DD-MON-YYYY The date the short shipment notification expires

Qty Short Number 5 The quantity still expected by the IIP to fully fill the RDO

Qty Short Response Number 5 The quantity the seller promises to ship in response to a short shipment

Short Responded On

Date DD-MON-YYYY The date the short shipment notification was responded on

Short Responded By Char 30 The user who responded to the short shipment

Outstanding Return/Disposal Notification

Char 1 Does the seller need to respond to a return/disposal notification

Return/Disposal

Expires On

Date DD-MON-YYYY The date on which the return/disposal notification expires

Return/Disposal

Response Char 1 The response to the return/disposal notification

Return/Disposal

Responded On

Date DD-MON-YYYY The date on which the return/disposal notification was responded to.

Return/Disposal Responded By

Char 30 The user who responded to the return/disposal notification

Disposal Charge

Required

Char 1 Is the WWRS PMO awaiting material disposal charges from the IIP

Disposal Charge Number 11,2 The actual dollar amount charged by the IIP to dispose of material

IIP and Services for WWRS

Attachment #2

RDO Comments Dataset – Text file, (“^”) Delimited

Field Name Data Type Length /Format Description

RDO Number Char 14 Seller’s Redistribution Order

RDO Line Number Number 2 The RDO Line Number

Sequence Number Number 2 The unique sequence number of the comment

Inspection Number Number 2 The inspection number on which the comment was made

Created On Date DD-MON-YYYY The date on which the comment was entered

Created By Char 30 The user who created the comments

Comment Char 1000 The actual comments entered

RDO Material Returns Dataset – Text file, (“^”) Delimited

Field Name Data Type Length /Format Description

RDO Number Char 14 Seller’s Redistribution Order

RDO Line Number Number 2 The RDO Line Number

Inspection Number Number 2 The inspection number (sequence number) on the RDO Line

Return Number Char 14 The number under which the material was returned

Shipped On Date DD-MON-YYYY The date the material was shipped

Awaiting Shipping Information

Char 1 Is the PMO awaiting details of the return shipment

Qty Shipped Number 5 The quantity shipped back to the seller

Freight Carrier Char 4 The abbreviated code of the commercial shipper used from the IIP to the seller’s freight forwarder

Shipment ID Char 50 The commercial shipper’s tracking number for this shipment

Mode Of Shipment Char 1 How the material was shipped

Containers Number 3 The number of containers used in the shipment

Weight Number 10,2 The weight of the shipment

Cubes Number 10,2 The cubic volume of the shipment

Prepaid Freight Number 11,2 The freight charge paid by the IIP to ship the material to the seller’s freight forwarder

Additional

Packaging Charge

Number 11,2 Any additional charges incurred in packaging the material for shipment

WWRS Charge Number 11,2 The WWRS fee incurred by the seller for shipment of material

IIP Charge Number 11,2 The IIP fee for shipping the material back to the seller

IIP and Services for WWRS

Attachment #2

Requisition Dataset – Text file, (“^”) Delimited

Field Name Data

Type

Length /Format Description

Requisition Header Id Number 10 The unique ID that ties Requisition Numbers to the seller’s RDOs

FSC Char 4 The federal supply classification of the item being ordered

MMC Char 2 The management material code of the item being ordered

Unit of Issue Char 2 The unit of issue of the item being ordered

NIIN Char 9 The national item identification number being ordered

NSN Char 15 The national stock number being ordered

Part Number Char 32 The specific manufacturer’s part number being ordered

CAGE Code Char 5 The manufacturer of the specified part number

Condition Code Char 1 The condition of the material being ordered

DoD Price Char 11,2 The current stock list unit price of the material being ordered

PROS Eligible Char 1 Is the item PROS eligible

On Hold Char 1 Is the requisition on hold (prior to running the selection process)

On Hold Reason Char 2 The reason why the requisition is on hold

Header Is Open Char 1 Is the requisition header still open

Header Closed On Date DD-MON-YYYY The date the requisition header was closed

Requisition Number Char 14 The buyer’s requisition number

Country Code Char 2 The buyer’s country code

Process Date Date DD-MON-YYYY The date the requisition was input into the legacy system

Advice Code Char 2 The advice code on the requisition

Priority Char 2 The priority of the requisition

Original Quantity Number 5 The original quantity being ordered

Purchaser Consignee

Service Code

Char 1 Position 1 of the supp address

Option Code Char 1 Position 2 of the supp address

Freight Forwarder Code Char 1 Position 3 of the supp address

Case Designator Char 3 The FMS case on which the funds will be used to pay for material

Supp Address Char 6 Supplemental address, used to verifying address of buyer’s freight forwarder

Line Number Char 3 The FMS case/line on which the funds will be used to pay for material

Project Code Char 3 The buyer specified project code

Media and Status Code Char 1 Designates how requisition status is to be transmitted

Demand Or Suffix Code Char 1 Recurring or Non recurring requirement

Signal Code Char 1 Designates intended consignee and activity to receive bill

Fund Code Char 2 The type of funding used on for this requisition

Legacy System Char 5 The legacy system in which the requisition is being processed

MIPR Estimated

Freight

Number 11,2 The estimated freight charge on material that is being purchased via a funding document

MIPR Shipping

Instructions

Char 200 The instructions for shipping material for material purchased via a funding document

Created On Date DD-MON-YYYY The date WWRS received the requisition

Current Status Char 2 The current status of the requisition

Current Qty Number 5 The current quantity being filled by WWRS

Current Price Number 11,2 The unit price of the material being purchased

Item Approval Pending

Char 1 Was PMO approval required prior to filling this document

Approval Needed Char 1 Is approval currently required by the PMO

Approval Response Char 1 The response by the PMO to item purchase approval

Approval Reviewed On Date DD-MON-YYYY When was the item approval response provided

Approval Reviewed By Char 30 The user who provided the item purchase approval decision

Qty Shipped Number 5 The total quantity shipped against this requisition

Requisition Is Open Char 1 Is the requisition currently open

Requisition Closed On Date DD-MON-YYYY When was the requisition closed in WWRS

Requisition Closed Char 2 Why was the requisition closed

Reason

IIP and Services for WWRS

Attachment #2

Requisition Shipment Dataset – Text file, (“^”) Delimited Field Name Data Type Length /Format Description

Requisition Header Id

Number 10 The unique ID that ties Requisition Numbers to the seller’s RDOs

Requisition Number Char 14 The buyer’s requisition number

Shipment Number Number 2 The unique shipment number (sequence number) for the requisition

Shipment Entered

On

Date DD-MON-YYYY When was the shipment entered

Shipment Entered By

Char 30 The user who entered the shipment

Awaiting Shipment

Information

Char 1 Is the PMO awaiting details of the material shipment

Shipped On Date DD-MON-YYYY The date the material was shipped

Qty Shipped Number 5 The quantity shipped

Freight Carrier Char 4 The abbreviated code of the commercial shipper used to transport the material from the IIP to the buyer’s freight forwarder

Shipment Identifier Char 50 The commercial shipper’s shipment tracking number

Mode of Shipment Char 1 The method used to ship the material

Containers Number 3 The number of containers used in the shipment

Weight Number 10,2 The weight of the shipment

Cubes Number 10,2 The cubic volume of the shipment

Prepaid Freight Number 11,2 The freight charge paid by the IIP to ship the material to the seller’s freight forwarder

Additional

Packaging Charge

Number 11,2 Any additional charges incurred in packaging the material for shipment

RDO Unit Price Number 11,2 The actual unit price of the material shipped