;-------------------------------------------------------------------------------------
; GFP-Import-v5_csv.txt                                       MIL-Comply UID Expeditor
;-------------------------------------------------------------------------------------
;
;	CSV format for importing GFP UID items into UID Expeditor for 
;	servicing (MRO) and return to the Government on WAWF Reparable 
;	Receiving Reports (DD250s).   
;	
;	Contract Definition Fields:
;	   Contract -  GFP Contract Number (with hyphens)
;	   Order    -  GFP Delivery Order (without hyphens, optional)
;	   Prime    -  Prime Contractor's CAGE (for UID Entity matching)
;	   ACO      -  Contracting Office DODAAC  (optional, may be added later)
;	   PCO      -  Buying Party DODAAC        (optional, may be added later)
;
;	Item Fields:
;	   UII      -  The Construct 1 or 2 UII to be imported
;	   UIType   -  "UID1" or "UID2"   
;	   PN       -  The item's Part Number
;	   NSN      -  National Stock Number with hyphens (optional)
;	   Noun     -  Item Nomenclature (Contract Name) 
;	   UnitPrc  -  Acquisition Cost (when adding to UID Registry)
;	   Contract -  GFP Contract Number (with hyphens)
;	   Order    -  GFP Delivery Order (without hyphens, optional)
;	   CLIN     -  GFP CLIN/Sub-CLIN  (optional)
;	   STSTE    -  Special Tooling / Test Equipment (ST, STE, NOT; default: NOT)
;	   2D-Mark  -  Has Compliant 2D-Marking (Yes or No; default: Yes)
;
;	Contract and Order are optional when a GFP Contract Record is included 
;	Blank lines and those starting with semicolons are ignored.
;	Use of Construct 1 requires user to enter item Serial Numbers manually.
;
;		Use of CSV Import v5 requires MIL-Comply Release 1.7.0272 or later.
;-------------------------------------------------------------------------------------


;-------------------------------------------------------------------------------------
; GFP Contract Definition Line - defines contract & order numbers to 
; 	which GFP items are associated, as well as the data which is required
;	for GFP custody transactions.  It is impported into the Contract Profile 
;	record, which is required, but may be added manually, after import.
;	import.  
;
;	In the absence of contract information, each GFPItem must include
;	a Contract and, if applicable, an Order.
;-------------------------------------------------------------------------------------


;GFPCon,Contract,Order,Prime,ACO,PCO
GFPCon,N00535-19-A-1234,N0053521F0099,1HLD9,XACOXX,XPCOXX


;---------------------------------------------------------------
; GFP Item Line(s) with explicit Contract/Order, optional CLIN
;---------------------------------------------------------------

;GFPItem,UII,UIType,PN,NSN,Noun,UnitPrc,Contract,Order,CLIN,STSTE,2D-Mark
GFPItem,D1HLD9WID9987A-P0701,UID2,WID9987A-P,2610-01-214-1344,"WIDGET, PURPLE",7954.5,N00535-19-A-1234,N0053521F0099
GFPItem,D1HLD9WID9987A-P0702,UID2,WID9987A-P,2610-01-214-1344,"WIDGET, PURPLE",7954.5,N00035-19-A-1234,N0053521F0099
GFPItem,D1HLD9WID9987A-P0703,UID2,WID9987A-P,2610-01-214-1344,"WIDGET, PURPLE",7954.5,N00535-19-A-1234,N0053521F0099

GFPItem,D12345SK-WOM-LG21XKR063701,UID2,SK-WOM-LG21,1910-01-087-4453,"BOOTS, WOMBAT",,N00535-19-A-1234,N0053521F0742,0023
GFPItem,D12345SK-WOM-LG21XKR063702,UID2,SK-WOM-LG21,1910-01-087-4453,"BOOTS, WOMBAT",,N00535-19-A-1234,N0053521F0742,0023
GFPItem,D12345SK-WOM-LG21XKR063703,UID2,SK-WOM-LG21,1910-01-087-4453,"BOOTS, WOMBAT",,N00535-19-A-1234,N0053521F0742,0023

; GFP Items may appear in any order, without regard to contract ownership:

GFPItem,D1HLD9WID9987A-P0804,UID2,WID9987A-P,2610-01-214-1344,"WIDGET, PURPLE",7954.5,N00535-19-A-1234,N0053521F0099
GFPItem,D12345SK-WOM-LG21XKR0907,UID2,SK-WOM-LG21,1910-01-087-4453,"BOOTS, WOMBAT",,N00535-19-A-1234,N0053521F0742
GFPItem,D1HLD9WID9987A-P0805,UID2,WID9987A-P,2610-01-214-1344,"WIDGET, PURPLE",7954.5,N00535-19-A-1234,N0053521F0099
GFPItem,D12345SK-WOM-LG21XKR0908,UID2,SK-WOM-LG21,1910-01-087-4453,"BOOTS, WOMBAT",,N00535-19-A-1234,N0053521F0742


;-------------------------------------------------------------------------
; Implied Contract/Order Assignment
;
;	Contact/Order are optional in GFPItem lines when preceded by
;	a GFPCon line.  That information is used until another GFPCon 
;	is encountered.  
;
;	In these examples ACO and PCO are left to be entered 
;	into the Contract Properties by the user
;-------------------------------------------------------------------------

;GFPCon,Contract,Order,Prime,ACO,PCO
GFPCon,N00535-19-A-1234,N0053521F0099,1HLD9

;GFPItem,UII,UIType,PN,NSN,Noun,UnitPrc,Contract,Order,CLIN,STSTE,2D-Mark
GFPItem,D1HLD9WID9987A-P0732,UID2,WID9987A-P,2610-01-214-1344,"WIDGET, PURPLE",7954.5
GFPItem,D1HLD9WID9987A-P0733,UID2,WID9987A-P,2610-01-214-1344,"WIDGET, PURPLE",7954.5
GFPItem,D1HLD9WID9987A-P0734,UID2,WID9987A-P,2610-01-214-1344,"WIDGET, PURPLE",7954.5

GFPItem,D12345SK-WOM-LG21XKR0406,UID2,SK-WOM-LG21,1910-01-087-4453,"BOOTS, WOMBAT",,0023
GFPItem,D12345SK-WOM-LG21XKR0407,UID2,SK-WOM-LG21,1910-01-087-4453,"BOOTS, WOMBAT",,0023
GFPItem,D12345SK-WOM-LG21XKR0408,UID2,SK-WOM-LG21,1910-01-087-4453,"BOOTS, WOMBAT",,0023


GFPCon,N00535-19-A-1234,N0053521F1022,1HLD9
GFPItem,D1HLD9WID9987A-P0624,UID2,WID9987A-P,2610-01-214-1344,"WIDGET, PURPLE",7954.5,,,0001
GFPItem,D1HLD9WID9987A-P0625,UID2,WID9987A-P,2610-01-214-1344,"WIDGET, PURPLE",7954.5,,,0001