Transcription
GFP Attachment Template InstructionsVersion 5.11.1December 2017Prepared For:Defense Logistics AgencyPrepared By:CACI Enterprise Solutions, Inc.50 North Laura Street, Suite 2100Jacksonville, FL 32202Under:Contract No. SP4701-16-D-2001Project Name: Wide Area WorkflowApproved By:Prepared By:Approved By:5/17/2018Recoverable SignatureXXTymothe ConnaughtonCACI Software Developer 2Signed by: Tymothe ConnaughtonRandy DietzCACI WAWF Technical LeadSigned by: DIETZ.RANDALL.J.1211901060
GFP Attachment Excel Template InstructionsDecember 2017History PageVersionDateInitialsChange 017TMCMaximum character limit for Item Name, Part Number, andModel Number updated from 50 characters to 48 characters.1
GFP Attachment Excel Template InstructionsDecember 2017Table of Contents1DOWNLOAD GFP ATTACHMENT EXCEL TEMPLATE . 32UPLOAD GFP ATTACHMENT EXCEL TEMPLATE . 33GFP ATTACHMENT FIELD RESTRICTIONS . 53.13.24Contract Information Fields . 5GFP Attachment Item Fields . 7GFP ATTACHMENT VALIDATIONS AND LIMITATIONS . 82
GFP Attachment Excel Template Instructions1December 2017Download GFP Attachment Excel TemplateTo obtain the latest copy of the GFP Attachment Excel Template, log into the GFP Module as aGFP Initiator or GFP Approver. Then select the Documentation dropdown and click ‘GFPTemplate Download’.Data can be entered and saved in the downloaded Excel template. This populated template canthen be used for initiating a GFP Attachment via Excel Upload.2Upload GFP Attachment Excel TemplateAs a GFP Initiator or GFP Approver, go to the Government dropdown and click ‘Create GFPAttachment’. Select ‘GFP Attachment Excel Upload’ in the ‘Create GFP Attachment Using?*’dropdown, then click the ‘Continue’ button.After clicking the ‘Browse ’ input button, select the populated Excel Template file. Next, clickthe ‘Upload’ button.3
GFP Attachment Excel Template InstructionsDecember 2017If the GFP Module detects any errors within the uploaded workbook, the following screen willbe presented to the user. They can review the errors via text file by clicking the ‘DownloadErrors’ button. They can then update their Excel Template accordingly and upload the file again.If no errors are encountered, the user will be redirected to the Routing screen to completeinitiation of the GFP Attachment.4
GFP Attachment Excel Template Instructions3December 2017GFP Attachment Field Restrictions3.1 Contract Information FieldsField NameMandatory? RestrictionsAttachment NumberYUp to 5 numeric digitsAttachment DateY‘CCYY-MM-DD’ formatNameNNot used by GFP ModuleEmailNNot used by GFP ModulePhoneNNot used by GFP ModuleDocument DescriptionYValues limited to those in dropdownMod NumberNIf Document Description is ‘Contract Mod’, entera 6 character Modification Number. If this is amodification to an Order enter a 2 charactermodification number. Value is alpha-numeric.Amendment No.NIf Document Description is ‘Amendment’, enter a4 numeric-digit Amendment Number.Contract Number TypeYValues limited to those in dropdownSOLICITATION,CONTRACT or UNIFORMPIID NUMBER – IssuingOffice DoDAACYIssuing Office must be 6 uppercase alphanumericcharacters. "I" and "O" are not allowed. IssuingYear, Contract Type & Sequence Number mustalso be provided.SOLICITATION,CONTRACT or UNIFORMPIID NUMBER – IssuingYearY2 numeric digits. Issuing Office DoDAAC,Contract Type & Sequence Number must also beprovided.SOLICITATION,CONTRACT or UNIFORMPIID NUMBER – ContractTypeYValues limited to those in dropdown. IssuingOffice DoDAAC, Issuing Year & SequenceNumber must also be provided.SOLICITATION,CONTRACT or UNIFORMPIID NUMBER – SequenceNumberY4 alphanumeric characters. The letters "I" and "O"are not allowed. Letters must be uppercase.Issuing Office, Issuing Year & Contract Typemust be entered.Order Number – IssuingOffice DoDAACNIssuing Office must be 6 uppercase alphanumericcharacters. "I" and "O" are not allowed. IssuingYear, Contract Type & Sequence Number must5
GFP Attachment Excel Template InstructionsDecember 2017also be provided.Order Number – IssuingYearN2 numeric digits. Issuing Office DoDAAC,Contract Type & Sequence Number must also beprovided.Order Number – ContractTypeNValues limited to those in dropdown. IssuingOffice DoDAAC, Issuing Year & SequenceNumber must also be provided.Order Number – SequenceNumberN4 uppercase alphanumeric characters. The letters"I" and "O" are not allowed. Issuing Office,Issuing Year & Contract Type must be entered.Order Number – Old OrderFormatN4 upper case alphanumeric characters and cannotcontain the letter "I" or "O".An Old Order Format and Order Number cannotbe entered at the same time.6
GFP Attachment Excel Template InstructionsDecember 20173.2 GFP Attachment Item FieldsField NameMandatory? RestrictionsLine NumberYUp to 5 numeric digits. Must be unique per tab. (i.e. Only asingle instance of Line Number ‘1’ is permitted on the SeriallyManaged Items tab)Item NameYUp to 48 alphanumeric charactersItem DescriptionYUp to 250 alphanumeric charactersNSNN13 numeric digits not starting with zero. One of NSN, MFRCAGE and Part Number, or Model Number is required.MFR CAGEN5 uppercase alphanumeric characters. If provided, PartNumber must be provided. One of NSN, MFR CAGE andPart Number, or Model Number is required.Part NumberNUp to 48 alphanumeric characters. If provided, MFR CAGEmust be provided. One of NSN, MFR CAGE and PartNumber, or Model Number is required.Model NumberNUp to 48 alphanumeric characters. One of NSN, MFR CAGEand Part Number, or Model Number is required. ModelNumber is not applicable to Requisition Items.QtyYNumeric. Must be greater than or equal to 0.00001Unit of MeasureYValues limited to those in dropdownUnit Acq CostNNumeric. Must be a greater than or equal to zero with no morethan 2 decimal places. Numbers with more than two decimalswill be rounded.Use As-IsYValues limited to those in dropdownDelivery DateN'CCYY-MM-DD' format.If this value is present, do not enter any information in the'Duration', 'Time Unit', or 'Delivery Event' fields.Delivery Date is not applicable to Requisition Items.DurationNNumeric. Must be a decimal value between 0.01 and 9999.99.If this value is present, do not enter any information in the‘Delivery Date’ field.If provided, Time Unit and Delivery Event must be provided.Duration is not applicable to Requisition Items.7
GFP Attachment Excel Template InstructionsTime UnitNDecember 2017Values limited to those in dropdownIf this value is present, do not enter any information in the‘Delivery Date’ field.If provided, Duration and Delivery Event must be provided.Time Unit is not applicable to Requisition Items.Delivery EventNValues limited to those in dropdownIf this value is present, do not enter any information in the‘Delivery Date’ field.If provided, Duration and Time Unit must be provided.Delivery Event is not applicable to Requisition Items.NotesNUp to 250 alphanumeric characters.Notes are not applicable to Requisition Items.4GFP Attachment Validations and Limitations The combination of Attachment Number and Attachment Date must be unique perContract/Order or Solicitation. Currently, the GFP Module limits users to 22500 Serially Managed Items, 22500 NonSerially Managed Items, and 1000 Requisition Items per GFP Attachment. Theseamounts are subject to change in future GFP Module releases. The number of blank rows allowed on the Excel Template between item data is managedby a system parameter. To avoid data issues during upload, eliminate as much blankspace as possible between item rows. Reference Section 3 for all field-specific validations.8
Project Name: Wide Area Workflow Approved By: Prepared By: Approved By: 5/17/2018 X Tymothe Connaughton CACI Software Developer 2 Signed by: Tymothe Connaughton Recoverable Signature X Randy Dietz CACI WAWF Technical Lead Signed by: DIETZ.RANDALL.J.1211901060. GFP Attachment Excel Template Instructions December 2017 .
