Custom Report Screen

The Custom Report screen includes a list of data items (section and fields) included in the Haystack databases. You can select items from the list to include in your report format. To choose items for your report format, select all of the items in a particular section (database), clear all of them, or select only certain items from certain databases. Once you have selected the items you want, click the Save button at the bottom of the list or the bottom of the main database list.
Note: This list is constantly updated and the items listed here may not reflect fields and sections currently available.

To get to the Custom Report screen, go to Reports > Batch Setup > Batch Input (red button in upper right of screen), click the Edit or Create button for the Output Format field, and then click the Edit or Create button for the Data Selection field.

OR

Select it from the FLSIP/MAPL header when performing an APL Search.

The available items are

• Main Databases Data List - Segment A, MCRL (Master Cross Reference List) and Vender Info, MLC (Management Data) and MLC Phrase Statements, MOE (Major Organizational Entity) Rule (Segment B), Freight Data (Segment G), Packaging Data (Segment W), Technical Characteristics (Segments M & V), Procurement History and Vendor Info, Procurement History Archive, CTDF PID Option B and Complete PID (with SDDT lookup), CTDF PSDT, CTDF Weapon Systems, I&S (Interchangeable and Substitutable), AMDF (Army Master Data File), MRIL  (Master Reparable Item List), LIRSH (List of Items Requiring Special Handling), HMDF (Hazardous Material), NHA (Next Higher Assembly) and NHA 2330, CRF (NICN Cross Reference), WUC (Work Unit Code), SPMIG, MSD Cost, Government Solicitations, SNUD and SRANS, Inventory Capabilities, and Vendor Info Data.
• Segment A Data - NIIN, NSN, FSC, INC, ITEM NAME, FIIG, CRIT, ISC, STATUS, TIIC, RPDMRC, DEMIL, HMIC, ESDEMI, PMI, ADP AND DATE ASSIGNED.
• MCRL Data - NIIN, PARTNO, CAGE, RNFC, RNVC, RNCC, DAC, RNJC, RNSC, RNAAC, SADC COMPANY.
• MLC Data - NIIN, SA, SOS, MCD, UI, PRICE, QUP, RC, CIIC, AAC, SLC, UT_CONV, USC EFF_DATE.
• MLC Phrase Statements Data - NIIN, SA, PC, PHRASE.
• MOE Rule (Segment B) Data - NIIN, MOE RULE, MOECODE, PICA, AMC, AMSC, NIMSC, IMC, IMCA, AAC, COLLABORATORS, RECEIVERS, EFFDATE.
• Freight Data (Segment G) - NIIN, ORIGACTY, FREIGHTDESCR, INTEGRITY, RAILVAR, NMFCITEMNUM, NMFCSUBITEMNUM, UFC, HMC LCL, WATERCOMMODITY, TYPOFCARGO, SPECHANDLG, AIRDIM, AIRSPCHANDL, CLASSRATING
• Packaging Data (Segment W) - NIIN, CLEANING AND DRYING PROC, CONTAINER NSN, CUSHIONING AND DUNNAGE MAT, INTERMEDIATE CONTAINER CODE, INTERMEDIATE CONTAINER QTY, ITEM TYPE STORAGE, LEVEL A PACKING RQMT, LEVEL B PACKING RQMT, LEVEL C PACKING RQMT, OPTIONAL PROCEDURE INFO, PACKAGING CATEGORY, PKG DATA SOURCE, PACKAGING DESIGN ACTIVITY, PICA SICA IND, PRESERVATION MAT CD, METHOD OF PRESERVATION, SPECIAL MARKING, SPC PKG INSTRUCTION DTE, SPC PAK INSTRUCTION NBR, SPC PKG INSTRUCTION REV, SUPPLEMENTAL INSTRUCTIONS, THICKNESS OF CUSH & DUN, UNIT CONTAINER CODE, UNIT CONTAINER LEVEL CD, UNIT PACK CUBE, UNIT PACK SIZE, UNIT PACK WEIGHT, UNPACKAGED ITEM DIM, UNPACKAGED ITEM WEIGHT, WRAPPING MATERIAL CODE.
• Technical Characteristics (Segments M & V) - NIIN, FSC, MRC, REQUIREMENT, REPLY.
• Procurement History Data - NIIN, SOS, DATE, CONTRACTING, UI, PRICE, TOTAL PRICE, QTY, CAGE, VENDOR NAME, CONTRACTX, PRNUMBER, REQNUMBER.
• Procurement History Archive Data - NIIN, SOS, DATE, CONTRACTNO, UI, PRICE, TOTAL PRICE, QTY, CAGE, VENDOR NAME, CONTRACTX, PRNUMBER, REQNUMBER.
• CTDF PID Option B Data - NIIN FSC, DESCR, SDDTNO, SOS, PID_LINENUM, SDDT_LINENUM.
• CTDF PSDT Data - NIIN, BRC, DWGDEVCODE, RIDIQPL, SPECAMDDATE, SPECAMDNO, SPECCODE, SPECDATE, SPECNO, SPECVALDATE, SRC, TYPENO.
• CTDF Weapon Systems Data - NIIN, FSC, SRC, WSDC, CRIT, RICFM, DEFINITION.
• I & S (Interchangeable and Substitutable Data) - NIIN, AGENCY, IS_NIIN, PC, OOU, JTC.
• AMDF (Army Master Data File) Data - NIIN, EPI, CIIC, ARC, FC, RIC, SCI, LCC, SRC, ICC, SCMC, EC, AEC, ARI, UM, AMQ, EIC, LIN, MRC, PRICE, MATCAT.
• MRIL Data - COG, MCG, NIIN, FSC, SMIC, MPD, CICC, SRC, OTHERNOTES, PRIMARY NOTE, UIC, DEMIL, ASCODE.
• LIRSH Data - NIIN, FSC, DOCID, MCC, SMIC, COG, TDATE, SLC, SEC, SMCC, DEMIL, SLAC.
• HMDF (Hazardous Material) Data - NIIN, HMIC, DIC, ORIGINATOR, FSC, DOT, IMCO, IATA, TM38, AIRTAR, NETWT, UM, FPTEMP, FPNETHOD, NEUTRALIZER, TRANSDATE.
• NHS (Next Higher Assembly) - NIIN, COG, MCC, FSC, SMIC, ITEM_NAME, SMR, ALT_NIIN_FRC, ALT_NIIN, NRC, CAGE, PARTNO, LCT, UPA, LRC, PACKING_DATA, MODEL_CD, FRC, REC_ID.
• NHS 2330 Data - NIIN, FSC, SMIC, MCC, COG, FCC, FRC.
• CRF (NICN Cross Reference) Data - NIIN, NICN, PARTNO, CAGE, VENDOR
• WUC (Work Unit Code) Data - TECAT, AMN_TEC, XWUC, NMDF, CAGE, WUC_NAME, WUC, PARTNO, TOTAL, REPAIR, BCM, DEFECTS, FAILED, COG, MCC, FSC, NICN, SMIC, PRICE, UI, SSC, NICN_NAME, SMR, DO14.
• SPMIG Data - NIIN, FSC, APLID, CATCODE, COG, DTSMETH, HAZMATGROUPCODE, IDNO, MILFED, NOMEN, NOTE, NUMBER, PARTNO, CAGE, REMARKS SUBCATCODE, SUFFIC, UI, MODIFIER.
• MSD Cost Data - NIIN, FSC, ALC, CARCOST, EFFDATE, EXPPRICE, LAC, LACBOCR, LRC, LRCBOCR, MCR, MMAC, MUP, PREPDATE, STDPRICE, UAP.
• Government Solicitations Data - NIIN, FSC, PRNUMBER, SOLICITNR, LIN, CLOSEDATE, OPENDATE, QTY, UI, URL, AGENCY, BUYERCODE, CONTACTNAME, EMAIL, PHONE, FAX, OFFICECODE, OFFICENAME, ADDRESS1, ADDRESS2, CITYSTATE, STATE, ZIP.
• SNUD Data - NIIN, FSC, AAC, AFEMSRC, AIC, BC, CMDEFFDATE, DMIL, ADP, FC, ITEMNAME, MMAC, ERRC, OLDERRC, PC PHRASE, PMI, PRICE, PSC, PVC, QUP, RECID, CIIC, SFCI, SLC, SMGC, SOS, UI, OLDUI, UICONV, WPS, REPLEFFDATE, REPLNIIN.
• SRANS Data - NIIN SRANS
• Inventory Capabilities Data - NIIN DESCR, PART NUMBER, QUANTITY, CONDITION, AVAILABILITY, COMPANY NAME, POINT OF CONTACT, POG EMAIL, PHONE NR, FAX NR.
• Vendor Data - CAGE, OE STATUS, COMPANY1, COMPANY2, ADDRESS1, ADDRESS2, POBOX, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, FORMERLY, TYPE AFFIL SIZE, PRIM.BUS, WOMAN, TYPE BUS, REPLACED CAGE, ASSOC CAO, ADPP, SIC