Attachment 0007 MCA File - Format.xls

GFM Requirements Load Attachment 0007 MCA File

Command Designator:

H - Aviation L - Missile Contract Number (no dashes) Delivery Order/Task Order Number (if applicable; if not leave blank) - 4 characters Enter NIIN/material (last 9 digits of NSN) (no dashes) 1 character fund code (refer to MCA Table Information tab)

If a WBS is being used input G.

*Not to be confused with the 2 character fund code required for requisition processing.

CAGE (Commercial and Government Entity) Code:

5 characters *Must correspond to requested contract/DoDAAC Serial Number Range:

(beginning of range):

4 characters Example: A500 Serial Number Range:

(end of range):

4 characters Example: A599 Total Authorized Quantity per contractual verbiage

MCA Table Information

Complete this cell if you only want to update the WBS on MCA requirements that are ALREADY LOADED in the MCA table Use this cell for initial loading of MCA requirements.

Refer to Type Funds table below.

Refer to Type Funds table below.

Requisition Request

Media Status Code is usually S Change to B17 or B64 based on weapon system DIC is usually A0A for a standard MCA sales order Federal Supply Class (FSC) first four characters of NSN NIIN. Last 9 digits of NSN. No dashes.

Unit of Issue. Refer to Material Master - Basic Data 1 tab This column is formatted as a 5 character element. Only input the quantity that you need requisitioned. The column will automatically populate.

Document Number (14):

DoDAAC (6) Julian Date (4) Serial Range (4) Demand Code:

R - Recurring N - Non-Recurring Supplementary Address:

DoDAAC(6 char) Signal Code:

B - ship to document DoDAAC; bill to suppadd J - ship to suppadd; bill to document DoDAAC M - Free Issue; no bill Fund Code:

2 character element -Must be loaded into ZFINCOR table in LMP -Must correspond to the correct Appropriation Code *Not to be confused with the 1 character fund code required for MCA table loading.

Priority Code: Normally 03 for GFM sales orders Distribution Code:

E - B17 L - B64 Required Delivery Date:

3 characters Normally 7-10 days out from when sales order was processed. (Julian date format)