CONTENTS PAGE
An Introduction to Using the DIFS Output v
Part 1 Sample
Case Data 1
LOA 3
Amendment I 9
Modification 1 13
Part 2 Case
Control 17
Case Control Summary Data 19
Billing Status 24
Payment Schedule Data 39
Case Detail Data 41
Case Closure Certification Inventory 37
Part 3 DIFS Hardcopy Reports 41
PCN 400 43
FMS
Detail Delivery History Search 47
Part 4 Purchaser
Products 57
The
Quarterly DD Form 645 59
The
Quarterly Delivery Listing 65
Appendices A-1
A Document
Identifier Codes A-3
B Selected
Monitor Codes A-4
C Routing
Identifier Codes A-7
D Type
of Assistance Codes A-8
F Unit of Issue
Codes A-10
G Offer Release
Codes A-17
H Reimbursement
Codes A-18
I Mode
(Method) of Shipment Codes A-19
J Adjustment
Reply Codes A-21
K Delivery Term
Codes A-24
L Transportation
Bill Codes A-27
M Transportation
Area Rate Table A-30
N Generic
Surcharge Table A-34
O Transportation
Charges By DTC for Items Shipped by DWCF A-35
P Transportation
Charges By DTC for Items not Shipped by DWCF A-36
Q Transportation
Charges By TBC for Items Shipped by DWCF A-37
R Transportation
Charges By TBC for Items not Shipped by DWCF A-40
S Type Case and
RSN Codes A-43
T Selected
Command Codes A-44
U Case Closure Certificate Inventory (CCCI) Status Codes A-45
V Delivery Source Codes A-47
An Introduction to Using the DIFS Output
To say that the data in
the Defense Integrated Financial System (DIFS) must be accurate is an
understatement. DIFS is the interfacing accounting system which links
implementing activity records with the bill (DD 645) and supporting financial
documents issued to purchasing countries for the articles and/or services that
the country has purchased through the foreign military sales (FMS) process.
Case managers must track the financial status of the cases for which they are
responsible throughout the execution phase as well as throughout the entire
life span of the case. Anomalies in the DIFS output (possibly reflecting
anomalies in the military departments input) should be reviewed and reconciled
with the intended provisions of the case. The DIFS system can provide case
managers one tool showing the visibility of the financial configuration of
their cases in the accounting system at DFAS-DE from the offered stage through
case closure and beyond. It is possible, through this system, to verify that
computations are being made in accordance with FMS cases. This system can also
provide “real time” data to case managers for use in analyzing country programs
and summary data for use both to their Purchasers and within their activity.
It is the purpose of this
handbook to provide case managers and other personnel involved with FMS case
execution, reconciliation, review, and closure with an explanation of the data
fields in the various DIFS formats. An explanation of each field and, where
applicable, how each field works and some of the codes that apply are provided.
This should assist those personnel involved with FMS in analyzing some of the
DIFS products and indicate where any corrective action needs to be taken.
Information contained herein is not intended to be all encompassing and
unlimited. Explanations are for those generally encountered situations, not all
situations.
Differences between DIFS
data and implementing agency records may be due to delays in reporting,
inaccurate or incorrect reporting, failure to correct and resubmit rejected
reports, and, in some cases, record adjustments or reports input by DFAS-DE of
which the implementing agency has not yet been advised. Dollar values or
amounts followed by the abbreviation CR (or in some cases a negative sign) are
credit amounts and may be due to several factors. They are indicators that
something is amiss and need immediate investigation.
The DIFS output assists
case managers in the “periodic” match of local records to those of the central
site. Errors or imbalances can then be analyzed at the transaction level. A
tool for transaction analysis is the FK history search in either single or two-line
format. This product will be described in some detail as it is a powerful tool
for both case reconciliation and case closure.
There are relationships
in the DIFS data fields and database, the DD Form 645, the Delivery Listing,
and other DIFS products and the Letter of Offer and Acceptance (LOA) (or older
DD Form 1513). These relationships need to be understood for a complete
analysis to be conducted or achieved. One of the leading culprits in causing
errors is the delivery source code. The FMS Accessorial Computation Matrix,
found in DoD 7000.14-R and the FMS
Customer Financial Handbook (Billing) must be studied carefully to fully
comprehend the correct use of this code. There are other possible sources of
errors within the reporting system such as incorrect document number or
incorrect case designator, wrong line or even wrong case “billing”, and
debit/credit transactions that were incorrectly entered.
The purpose of this
handbook is to serve as a “text” for the various DIFS products whether in a
classroom environment at DISAM or a “Desk book Reference”. However, the FMS
system is dynamic and changes to the systems, both the Logistics and Financial
Systems, occur frequently. Therefore, at some future date, the formats and data
element descriptions depicted in this Handbook, may differ from the “real world”.
An attempt was made to
capture all codes in the financial systems that apply to the general types of
FMS cases. Certainly, there are some codes that are country specific (i.e., the
bill code) and are not indicated in this handbook. Questions concerning such
codes can be directed to the technician at the Directorate for Security
Assistance, Defense Finance and Accounting Service,
As the discipline of
Security Assistance has changed over the past several years, those personnel
involved in this area can no longer be “specialists” in one or two areas. Case
managers must not only know the logistics, but the financial aspects of FMS
cases as well. Case reconciliation and closure dictate that case managers, line
managers, etc., know the changes that have occurred to the financial system in
order to know when certain charges apply or no longer are applicable. The audit
trail for the majority of FMS cases will span several years and several changes
to the financial/accounting system. While not meant to be all-inclusive, the
following changes have occurred, which may affect a particular FMS Case:
1. DODI 2140.1 Implemented (1970)
2. Nonrecurring Recoupment in Law (1970)
3. Asset Use Implemented (1976)
4. DFAS-DE ( Then known as SAAC) Activated (1976)
5. DIFS Implemented (1980)
6. Administrative Charge
a. From 29 January 1970 until 9 March 1977,
the administrative fee was two percent unless the supplying Military Department
had determined that the rate was either insufficient or in excess of actual
administrative expenses for any single FMS case. The use of actual FMS case
administrative expense was authorized.
b. 10 March until 30 September 1977: A
uniform 2% administrative charge was in effect for LOAs signed out in this
period.
c. 1 October, 1977 to 1 June 1999: A uniform
3% administrative charge was in effect
unless the LOA was for non-standard articles/services.
d. 1 June 1999: The Administrative charge was
lowered to 2.5% for cases implemented after 1 June 1999.
e. 1 August 2006: The Administrative charge was raised to 3.8%
with a $15,000 minimum.
7. Contract
Administrative Surcharge activated (1981) (Later revised to include cases with
an offer date on or after 1 Jan 1979)
8. Stock Fund
Surcharge of 14.5% applied for one year by DFAS-DE for Fiscal Year 1981.
9. Stock Fund
Surcharge of 6% applied from October 1981 until September 1982
10. Delivery Source
Codes changed from numeric to alpha.
11. DOD 7290.3-M
replaced DODI 2140.1 (1981)
12. Logistics
Support Charge (LSC) 3.1% implemented (Spring 1987)
13. Asset Charge of
1% for items from inventory began in 1976 (30 September 1976) was removed Jan
1990.
14. LSC, PCH, and
Inland CONUS transportation charges no longer computed on stock funded items
(October 1990)
15. DBOF
operational fiscal year (FY) 1991
16. Parcel Post and
Commercial Package charge no longer computed on DBOF items (October 1991).
17. New LOA format
replaced DD1513, 1513-1, 1513-2 (June 1992)
18. DoD 7000.14-R,
Volume 15 replaces DoD 7290.3-M (March 1993)
19. Defense Working
Capital Fund “replaced” DBOF in Calendar Year 1997
20. CAS surcharge
rates changes (1 October 2002)
21. LSC eliminated
1 October 2007.
The accounting data in
DIFS may be displayed in various formats depending upon the inquiry. The data
can be aggregated at total DoD level or individually at transaction level
depending upon the needs of the user at the time of inquiry. While a number of
products are available from DIFS, only a few will be discussed in this
handbook. Products that case managers need to become familiar with include the
Case Summary Data, the Case Detail data, the FMS Delivery History Search.
Case Summary Data. As the title indicates, this is summary data at
case level. This format will reflect case status in terms of billings versus
the LOA status. The various fields in the Delivered Costs area are a roll-up of
detail level data for the case. In order to understand the status of any particular
field, it may be necessary to examine the field at detail level.
Case Detail Data. This data is structured the same as the Case
Summary Data but at RSN or Item Number (Line number) level. Since data from
this section of the Case Control Products is rolled up at the Case Summary
Level, and reflects how a particular line is set-up in the accounting system,
it is the first place one should look in solving problems when records appear
other than they should.
Foreign Military Sales Delivery History Search. This product is one
of the more important products when one is performing analysis at the line/Item
Number/RSN level. This product is available in either a single or double line
format and both are illustrated in this handbook. The single line search is a
reflection of what the Purchaser sees in the Delivery Listing that accompanies
the DD Form 645. It may be particularly useful when a large volume of
transactions are to be analyzed as it is relatively easy to scan and the volume
of pages will be considerably less than those in the double, or two-line,
search. The double, or two-line, search can facilitate locating information on
a particular transaction. The format used depends on the requester and the
particular information being sought.
This report can be requested online but the printout will be mailed to
the requester.
Case Closure Certificate Inventory (CCCI). Case Closure
Certificates are recorded at DFAS-DE as they are received from the Implementing
Agency/Activity. The current status of a closure certificate is found here. It
is a relatively easy to read format and provides detailed information on the
certificate status.
Foreign Military Sales Case Financial Management Worksheet (PCN 400).
This product pulls data from the Case Control Summary Data and the Case Detail Line
Data. This report must be requested from
the DFAS country manager and will be mailed to the requester.
Two products not
available from the DIFS are the quarterly DD Form 645 and Delivery Listing.
Those two products, sent to the Purchaser, are also discussed in this handbook
in an attempt to provide a comprehensive evaluation of the Purchaser’s FMS
case. The FMS Customer Financial
Handbook (Redbook) provides more detail on these products.
This sample case will
be used throughout this handbook as a reference for the user to use and
reference.
NOTE: Only the case
itself is presented here as it would appear after all Amendments and
Modifications have been applied - the normal case notes, Letter of Offer and
Acceptance Standard Terms and Conditions, and the Letter of Offer and
Acceptance Information, or any other additional notes are not included.
Pursuant to the Arms Export Control Act, the Government of the United States (USG) offers to sell to the Government of Bandaria, Washington D.C., defense articles or defense services (which may include defense design and construction services) collectively referred to as “items,” set forth herein, subject to the provisions, terms, and conditions in this LOA.
This LOA is for Munitions, Ammunitions, and Publications
Estimated Cost: $3,612,403 Initial Deposit: $45,806
Terms
of
This offer expires on 15 September, 200X. Unless a request for extension is made by the Purchaser and granted by the USG, the offer will terminate on the expiration date.
This page through page XXXXXXX plus Letter of Offer and Acceptance Standard Terms and Conditions attached, are a part of this LOA.
The undersigned are authorized representatives of their governments and hereby offer and accept, respectively, this LOA:
2 Jan 199X 25 Sep, 199X
US Signature Date Purchaser Signature Date
W.A.
Army
Colonel, GS
Director, Asia, Pacific and
Typed Name and Title Typed
Name and Title
Implementing Agency Agency
Mr.
Money Bags/Comptroller 4 Jan 199X
DSCA Date
(B)
Information to be provided by the Purchaser:
Mark For Code B ,
Freight Forwarder Code 4 ,
Purchaser Procuring Agency Code B , Name and Address of the Purchaser’s Paying
Office Bandaria Defense Staff .
Bandarian Embassy,
Explanations for acronyms and codes, and financial information, may be found in attached “Letter of Offer and Acceptance Information.”
Items to be Supplied (costs and months for delivery are estimates):
(1) (2) (3) (4) (5) (6) (7)
Qty SCIMOS/
Itm Unit of Costs TA Rel Trm Nbr Description/Condition Issue (a) Unit (b) Total Notes Cde Cde
(8) Net Estimated Cost $3,193,325
(9) Packing, Crating, and Handling $64,910
(10) Administrative Charge $95,800
(11) Transportation $199,515
(12) Other Asset Use
(13) Total Estimated Cost $3,553,550
To assist in fiscal planning, the USG provides the following anticipated costs of this LOA:
Estimated
Payment Estimated Payment Schedule
Payment Date Quarterly Cumulative
Initial Deposit 45,806 45,806
15 Sep 9X 1,411,946 1,457,752
15 Dec 9X 370,087 1,827,839
15 Mar 9X 372,107 2,199,946
15 Jun 9X 357,826 2,557,772
15 Sep 9X 338,203 2,895,975
15 Dec 9X 198,774 3,094,749
15 Mar 9X 387,254 3,482,003
15 Jun 9X 57,729 3,539,732
15 Sep 9X 10,975 3,550,707
15 Dec 9X 2,843 3,553,550
Identifier:
BN-B-JAC
Page
2 of 21 Pages
(1) (2) (3) (4) (5) (6) (7)
Qty SC/MOS/
Itm Unit
of Cost TA Rel Trm
Nbr Description/Condition Issue (a) Unit (b) Total Notes Cde Cde
001 G2M
132000000D505(Y) 144 EA $255.32 36,749 S(6) Z 8
A (K) TA3
Projectile,
155mm,
Illuminating,
M485
NC
Notes 4, 10, 12, 17, 21,
22,
24, 25, 26, & 30
002 G2M
132000000D533(N) 300 EA 133.47 40,041 S(6) Z 8
A (K) TA3
Charge,
Propellant,
155mm,
M119A2,
Red
Bag
NC
NOtes 4, 10, 21, 22,
24,
25, 26, 29, & 30
003 GM
132000000D540(N) 840 EA 57.62 48,401 S(6) Z 8
A (K) TA3
Charge,
Propellant
155mm,
M3A1
NC
Notes 4, 10 12, 17,
21,
22, 24, 25, 26, & 30
004 G2M
132000000D541(N) 2,350EA 96.50 226,775 S(6) Z 8
A (K) TA3
Charge,
Propellant
155mm,
M4A2
NC
Notes 4, 10, 12, 17,
21,
22, 24, 25, 26, 29, & 30
005 G2M
132000000D563(Y) 1,640 EA 529.54 868,446 S(6) Z 8
A (K) TA3
Projectile,
155mm, HE
M483A1
MC
Notes 4, 10, 12, 17,
21,
22, 24, 25, 26, & 30
006 G1P
133000000G881 (N) 180 EA 8.48 1,527 S(6) Z 8
A (K) TA3
Grenade,
Hand, Fragment
M67
Delay
NC
Notes 4, 10, 12, 17,
21,
22, 24, 25, 26, & 30
Identifier: BN-B-JAC
Page
3 of 21 Pages
(1) (2) (3) (4) (5) (6) (7)
Qty SC/MOS/
Itm Unit
of Cost TA Rel Trm
Nbr Description/Condition Issue (a) Unit (b) Total Notes Cde Cde
007 G1P 132000000G900(N) 96 EA 31.99 3,072 S(6) Z 8
A (K) TA3
Grenade
Hand
M14
NC
Notes 4, 10, 12, 17
21,
22, 24, 25, 26, 29, & 30
008 G7B
139000000N285(N) 2,464 EA 88.11 217,104 S(16) Z 8
A (K) TA3
Fuze,
MTSQ M577
And
M577A1
NC
Notes 4,10, 12, 17,
21,
22, 24, 25, 26, & 30
009 G7B
139000000N286(N) 1,168 EA 74.19 86,654 S(18) Z 8
A (K) TA3
Fuze,
MTSQ, M582A1
NC
Notes 4, 10, 12, 17,
21,
22, 24, 25, 26, & 30
010 G7B
139000000N340(N) 2,880 EA 18.10 52,128 S(13) Z 8
A (K) TA3
Fuze,
PD, M739A1
NC
Notes 4, 10, 12, 17,
21,
22, 24, 25, 25, 29, & 30
011 G7B
139000000N523(N) 10,000 EA 2.25 22,500 S(13) Z 8
A (K) TA3
Primer,
Percussion,
M82
MC Notes 4, 10, 12,
17,
21, 22, 24, 25, 26, & 30
012 G1F
130500000A576(N) 16,000 EA 2.02 32,320 P(16) Z 8
A (K) TA5
Cartridge,
Caliber .50
4
API M3
NC
Notes 4, 10, 15, 17,
18,
21, 24, & 25
013 G00
9G00000000000(N) 560 EA 437.02 292,152 S(18) Z 8
A (K) TA3
Projectile,
155mm
WP,
Smk M825
SC
Notes 4, 10, 15,
17,
18, 21, 24, 25 & 32
Identifier:
BN-B-JAC
Page
4 of 21 Pages
(1) (2) (3) (4) (5) (6) (7)
Qty SC/MOS/
Itm Unit
of Cost TA Rel Trm
Nbr Description/Condition Issue (a) Unit (b) Total Notes Cde Cde
014 G2M
132000000D532(N) 1,248 EA 646.88 854,731 P(20) Z 8
A (K) TA5
Charge,
Propellant,
155MM,
m203a1, Red Bag
NC
Notes 4, 10, 15, 17, 18
21,
24, 25, & 27
015 G2M
132000000D544(Y) 2,200 EA 202.27 444,994 P(19) Z 8
A (K) TA5
Projectile,
155mm, HE
M107
NC Notes
4, 10, 15, 17
18,
21, 24, & 25
016 G3A
1345000000K143(N) 120 EA 47.01 5,642 S(9) Z 8
A (K) TA3
Mine,
APERS, M18A1
w/ACC,
Claymore
NC
Notes 4, 10, 12, 15
17,
18, 21, 24, & 25
017 G6B
137000000L495(N) 224 EA 30.04 6,729 P(28) Z 8
A (K) TA5
Flare,
Surface, Trip
M49A1
NC
Notes, 4, 10, 12, 15
17,
18, 21, 24, & 25
018 J8A
768ZBOOKSPUBS(N) XX 2,780 2,780 S(15) A 5
A TA3
Publications
as Listed
On
Annex C
Notes
18, 23, & 28
Identifier:
BN-B-JAC
Page
5 of 21 Pages
Based on Embassy of Bandaria Letter of 8 Nov, 199X. Mail to
the Government of Bandaria,
Pursuant to the Arms Export Control Act, the Government of the United States (USG) hereby notifies the Purchaser of Modification of the Letter of Offer and Acceptance (LOA) identified above for the purchase of defense articles, defense services, or both. Other provisions, terms, and conditions of the original LOA remain unchanged..
This Amendment is for: line additions (line item 19 and 20), line deletions (line item 11), and quantity/cost adjustments to line item 3 and 10, and revise case notes.
Estimated Cost: $3,747,654 Initial Deposit: $10,975
Terms of
This offer expires on 23 April, 199X. Unless a request for extension is made by the Purchaser and granted by the USG, the offer will terminate on the expiration date.
This page through page 8 attached are a part of this Amendment.
The undersigned are duly authorized representatives of their Governments and hereby offer and accept, respectively, this Amendment:
__________________________ 10 Feb 9X __________________ ________________
__________________________ __________________________________
Typed Name and Title Typed Name and Title
___________________________ __________________________________
Implementing Agency Agency
__________________________ ___________ __________________________________
DSCA Date
This Amendment consists of
changes as follows:
(1) (2) (3) (4) (5) (6) (7)
Qty SC/MOS/
Itm Unit
of Cost TA Rel Trm
Nbr Description/Condition Issue (a) Unit (b) Total Notes Cde Cde
Previous
003 G6b
132000000D540 (N) 840 EA 57.62 48,401 S(6) Z 8
A (K) TA3
Charge,
Propellant
155mm,
M3A1
NC
Notes 4, 10, 12, 17
21,22, 24, 25, 26, & 30
Revised
003 G6B
137000000D540 (N) 776 EA 54.86 42,572 S(6) Z 8
A (K) TA3
Charge,
Propellant
155mm,
M3A1
NC
Notes 4, 10, 12, 17,
21,
22, 24, 25, 26, & 30
Previous Revised
(8) Net
Estimated Cost $3,193,325 $3,316,060
(9) Packing,
Crating, and Handling 64,910 69,835
(10) Administrative Charge 95,800 99,482
(11) Transportation 199,515 207,185
(12) Other:
(13) Total Estimated Cost 3,553,550 3,692,562
To assist in fiscal planning,
the USG provides the following anticipated costs of this LOA.
ESTIMATED PAYMENT SCHEDULE
Payment
Date Quarterly Cumulative
Cumulative
to date $3,539,732 $3,539,732
Initial
Deposit 10,975 3,550,707
15
Sep 9X 131,816 3,682,523
15Dec
9X 10,039 3,692,562
Amendment 1
Identifier BN-B-JAC
Page 2 of 8 Pages
(1) (2) (3) (4) (5) (6) (7)
Itm Unit
of Cost TA Rel Trm
Nbr Description/Condition Issue (a) Unit (b) Total Notes Cde Cde
Previous
010 G7B
139000000D340 (N) 2,880 EA 18.10 52,128 S(13) Z 8
A (K) TA3
Fuze,
PD, M739A1
NC
Notes 4, 10, 12, 17
21,22,
24, 25, 26, & 30
Revised
010 G7B
139000000D340 (N) 1,032 EA 17.45 18,009 S(13) Z 8
A (K) TA3
Fuze,
PD, M739A1
NC
Notes 4, 10, 12, 17
21,22,
24, 25, 26, & 30
Previous
011 G7B
139000000N523 (N) 10,000 EA 2.25 22,500 S(13) Z 8
A (K) TA3
Primer,
Percussion,
M82
NC Notes 4, 10, 12,
17,
21, 22, 24, 25, 26, & 30
Revised
011 Deleted
Added
019 G132000000D533
(N) 859 EA 173.08 148,676 S(6) Z 8
Charge,
Propellant (K) TA3
155mm,
M119A2
NC
Notes 4, 10, 12, 17
21,22,
24, 25, 26, 29 & 30
020 G132000000D541
(N) 259 EA 140.95 36,507 S(6) Z 8
Charge,
Propellant (K) TA3
155mm,
M14A2
NC
Notes 4, 10, 12, 17
21,22,
24, 25, 26, 29 & 30
Amendment 1
Identifier BN-B-JAC
Page 3 of 8 Pages
Based on cost adjustments due to experience during program
execution. Mail to: The Government of Bandaria,
Pursuant to the Arms Export Control Act, the Government of the United States (USG) hereby notifies the Purchaser of Modification of the Letter of Offer and Acceptance (LOA) identified above. All other terms and conditions of the LOA remain unchanged.
This Modification is for: Adjusting unit prices for line items 13 and 17; and increase total cost for line item 19. Notes 12, 24, 34-37 are revised. LOA accepted 26 September, 1999X.
Estimated Cost: $3,696,247 Initial Deposit: N/A
Terms of
This page through page 12 attached are part of this Modification.
The undersigned are duly authorized representatives of their Governments and hereby offer and accept, respectively, this Modification:
__________________________ 1 July 199X __________________ ________________
__________________________ __________________________________
Typed Name and Title Typed Name and Title
___________________________ __________________________________
Implementing Agency Agency
__________________________ ___________ __________________________________
DSCA Date
(1) (2) (3) (4) (5) (6) (7)
Qty SC/MOS/
Itm Unit
of Cost TA Rel Trm
Nbr Description/Condition Issue (a) Unit (b) Total Notes Cde Cde
Previous
013 G00
9G00000000000 560 EA 437.02 292,152 S(16) Z 8
A (K) TA3
Projectile,
155mm
WP,
Smk M825
SC
Notes 4, 10, 15,
17,
18, 21, 24, 25, & 32
Revised
013 G00
9G00000000000 560 EA 209.20 117,152 S(16) Z 8
A (K) TA3
Projectile,
155mm
WP,
Smk M825
SC
Notes 4, 10, 15,
17,
18, 21, 24, 25, & 32
Previous Revised
(8) Net Estimated Cost $3,316,060 $3,143,047
(9) Packing, Crating, and Handling 69,835 63,771
(10) Administrative Charge 99,482 94,290
(11)
Transportation 207,185 195,554
(12)
Other:
(13)
Total Estimated Cost 3,692,562 3,496,662
To assist in fiscal planning,
the USG provides the following revised anticipated costs of this LOA:
Payment
Date Quarterly Cumulative
Cumulative
to Date NA $3,692,562
Modification 1
Identifier BN-B-JAC
Page 2 of 12 Pages
(1) (2) (3) (4) (5) (6) (7)
Qty SC/MOS/
Itm Unit
of Cost TA Rel Trm
Nbr Description/Condition Issue (a) Unit (b) Total Notes Cde Cde
Previous
017 G6B
137000000L495 (N) 224 EA 30.04 6,729 P(28) Z 8
A (K) TA5
Flare,
Surface, Trip
M49A1
NC
Notes 4, 10, 12, 15,
17,
18, 21, 24, & 25
Revised
017 G6B
137000000L495 (N) 224 EA 38.74 8,678 P(28) Z 8
A (K) TA5
Flare,
Surface, Trip
M49A1
NC
Notes 4, 10, 12, 15,
17,
18, 21, 24, & 25
Previous
018 J8A
768ZBOOKSPUBS (N) XX 2,780.00 2,780 S(15) A 4
A
Publications
as Listed
On
Annex C
Notes
18, 23, & 28
Revised
018 J8A
768ZBOOKSPUBS (N) XX 2,818.00 2,818 S(25) A 4
A
Publications
as Listed
On
Annex C
Notes
18, 23, & 28
Modification 1
Identifier BN-B-JAC
Page 3 of 12 Pages
For this part of the
Handbook, an example of DIFS screens showing the Case Summary and Case Detail
will first be shown. This will be followed by an explanation of the data
elements of the screen.
FIC1 F2820 82 CASE
CONTROL SUMMARY AND DETAIL DATA PAGE
001 OF 023
COUNTRY
BN IA
B CASE JAC 01/30/9X
SUMMARY
CASE STATUS I DT-OFFER 9X004
ICS B DT-OFFER-EXPR 9X258
SRCE-SUPPLY S DT-IMPL 9X331
TYPE-ASSIST-GP 4 DT-CLSR
SCRTY-CLAS DT-FNLZD
HLD-ACCT 1QB DT-CANCL
HLDBK-PCT 0.10 DT-REOPENED
CAS-PCT .015 DT-C3-TO-C2
RSN-CT 019 CLSR-TYPE
CASE-TYPE BG INIT-DEP-REQR-IND Y
ULO-CLSR-IND CLOSED-OUT-OF-BAL-IND
AMEND-CD 1 AMEND-TYPE A
LST-AMEDN-NBR 01 LST-MOD-NBR 04
FICI
F2820 82 CASE CONTROL SUMMARY DATA PAGE 002 OF 023
COUNTRY BN
IA B CASE
JAC 01/30/9X
ORDERED
COSTS DELIVERED
COSTS
TOTAL-1512-CST 3,496,662.00 DLVR-SEC21-NON-LIQ 2,818.00
ORD-ART-SVC-CST 3,143,047.00 DLVR-SEC21-LIQ 73,373.20
ORD-ADMINCOST 94,290.00 DLVR-SEC22-NON-LIQ 1,142,923.62
ORD-ACSRL-COST 259,325.00 DLVR-SEC22-LIQ 1,176,126.33
TOTAL-ORD-COST 3,496,662.00 DLVR-ART-SVC-COST 2,945,241.15
ULO SUMMARY COST DLVR-ADMIN-COST 88,357.23
ULO SUMMARY COST 0.00 DLVR-ACSRL-COST 245,904.21
ULO-EQUITY 0.00 TOTAL-DLVR-COST 3,270,502.59
ULO-EA-ISS 0.00 DLVR-CAS-NON-LIQ 16,890.50
ULO-DISB 0.00 DLVR-CAS-LIQ .00
PROGRESS PAYMENTS LSC-STOCK-FUIND .00
PRG-PMT-RPT 1,799,499.53 RPT-EXPN 2,945,241.15
PP-DISP-UNDLV .00 ADMIN-EARNED 91,323.61
PRG-PMT-HLDBK .00 COLLECTIONS
PP-ADMIN-COST 2,966.38 TRUST-FUND-CLCT 2,983,220.00
TOT-UNLIQ-PP .00 INT-BR-ACCT-BAL 713,027.00
PRG-PMT-CAS .00 TOTAL-CLCT 3,696,247.00
This
format provides case data at the summary level. Data in the fields shown is
current summary data and is taken directly from the LOA or is the result of the
“billing” system or it may be the result of a computation or a “roll up” of
other case detail data.
CASE CONTROL
SUMMARY DATA ELEMENT DEFINITION Note: a CR
beside a dollar value indicates that the field is negative and should be
investigated to determine the cause.
CASE STATUS A code used
to identify the current case status.
O - Offered The case has been signed by the
responsible office and forwarded to the purchasing country
A - Accepted. The purchasing country has
accepted the case.
I - Implemented. Having received a signed
copy of the case and the required initial deposit, DFAS-DE has implemented the
case in DIFS.
C - Closed.
Indicates that the case has been closed in DIFS system. For the type of
closure, see CLSR-TYPE code below.
P - Proposed. The
FMS case has been entered into the data base but not signed/countersigned by
the responsible
S - Signed
E - Exceeded. The
offer expiration date has been exceeded and the customer has not accepted or
cancalled the offer..
X - Canceled.
ICS In
Country Service. In-country service of the customer country for whom the case
is written. Some in-country codes are;
A Armament Authority
B Army
D Air Force
G National Guard
H Hellenic Aerospace Industries
M Marine Corps
P Navy
R
BILL-CD
Bill
Code. DFAS-DE assigned code which divides the FMS customer country billing into
management levels lower than
SRCE-SUPPLY Source
of Supply. Identifies the planned source of supply for the major item or the
major source of supply for a case. It is generally the source of supply for
line one of a major item case.
TYPE-ASSIST-GP Type of Assistance code. See
Appendix D for specific codes
SCRTY-CLAS Security
Classification. Security classification of the case.
U
= Unclassified C = Classified.
HLD-ACCT Holding
Account. A pseudo designator assigned by DFAS-DE for each FMS country service.
The holding account is a suspense account for collections not identified to a
specific case; a depository for funds advanced to the USG and not designated
for distribution cases, and a clearinghouse for excess payments on hand at the
time the case is closed.
Numeric Type of Fund
0 Interest bearing account
1 Regular FMS payments by purchaser
2 Military Assistance Program (MAP) funds
3 Third country recoupments
4 Buybacks
5 FMF funds
The
second position (alpha) identifies the applicable U.S. Implementing
agency: In some instances, DFAS-DE may code the second position Q or some other
alpha either to reduce the number of accounts or to satisfy some other country
request. The third position (alpha) identifies the applicable purchaser's
in-country service or for some accounts, special programs.
Note: For a
complete understanding of the holding account coding, contact the DFAS-DE
accountant handling the country in question.
HLDBK-PCT Contractor
holdback percentage. It is usually 10 percent for procurement cases.
CAS-PCT Contract
Administration Service authorized charge percentThe usual charge is .015 for
procurement cases. This charge may be reduced if the purchaser has a reciprocal
agreement with the USG. Countries having reciprocal agreements are listed in
the Security Assistance Management Manual
( DoD 5105.38-M). Based on these reciprocal agreements, the CAS charge may be
between 0.000, and 0.017.
RSN-CNT Record
Serial Number or number of lines on the case. If the FMS case has been amended
or modified, adding or deleting lines, the number shown here is a summary
number of lines on the LOA or DD Form 1513. For example, if the original LOA
contained 10 lines and Amendment 01 deleted lines 04 and 07 but added lines 11,
12, 13, and 14, this data field would show an RSN count of 12, but the last
line number would be 14.
CASE-TYPE Type
of Case. This is a two position code; the first position is the Implementing
Agency Code, the second the type of case code. The code BF indicates that the
Implementing Agency is the U.S. Army. The F indicates that the major item
transferred is Weapons. See Appendix S for other case codes.
U LO-CLSR-IND Unliquidated Obligation Closure
Indicator. When case is certified for closure by the Implementing Agency, a Y
here indicates the case will be closed under the Accelerated Case Closure
procedures.
AMEND-CD A
management code that indicates whether the case has been amended or modified.
This field will be blank, indicating no amendment or modification has been
implemented in DIFS, or if one or more amendments or modifications have been
implemented, a “1” will be shown
LST-AMEND-NBR Sequential number of the latest
amendment implemented in DIFS.
DT-OFFER Date
of LOA offer expressed in year and Julian date. This date is from page one of
the LOA or Block 7 of the DD Form 1513.
DT-OFFER-EXPR Date of offer expiration expressed
in year and Julian date. This date is from page one of the LOA or Block 8 of
the DD Form 1513.
DT-ACPT Date
of acceptance by the purchaser. This date is expressed in year and Julian date
and is from page one of the LOA or Block 29 of the DD Form 1513.
DT-IMPL Date
of implementation. This date, expressed in year and Julian day, is the date the
case was implemented in DIFS.
DT-CLSR Closure
Date. Date of case closure as recorded in DIFS, expressed in year and Julian
day.
DT-FNLZD Date
finalized. Applies to ACC cases and is assigned when the case was categorized
as C3 status (See CLSR-TYPE below).
DT-CANCL Date
of case cancellation as recorded in DIFS. The date will be expressed in year
and Julian day.
DT-REOPENED Date
the case was reopened in DIFS
DT C3-TO-C2 Date
the case was re categorized from C3 status to C2 status (See CLSR TYPE below).
CLSR-TYPE A
code which indicates the type of case closure for status “C” cases.
1
Closed under non-ACC closure procedures.
2 Interim closed in DIFS and is a country
participating in the Accelerated Case Closure (ACC) program.
3 In the ACC program and has been final closed
in DIFS.
INIT-DEP-REQR-IND Initial Deposit Requirement Indicator.
A “Y” indicates an initial deposit is required to implement the case.
CASE-CLOSED-OUT-OF-BAL-IND Case closed out of balance indicator.
This code identifies cases closed with an irreconcilable difference between
DFAS-DE records and the Implementing Agency records. A “Y” in this field
indicates certain areas within DIFS were bypassed to permit case closure.
AMEND-TYPE Amendment
type. Identifies the type of the most recently implemented amendment or
modification. Codes are:
A
= Amendment with a net changeover $50,000
B
= Amendment with a net change less than or equal to $50,000
C
= Modification
LST-MOD-NBR Sequential
number of the latest modification implemented in DIFS.
Ordered Cost
TOTAL-1513-CST Dollar value of the Total Ordered
Cost as shown in Line (13), Total Estimated Cost, of the LOA, or Block 26
(Estimated Total Cost) of the DD Form 1513.
ORD-ART-SVC-CST Dollar value of the Ordered Articles
and Service cost as shown in Line (8), Net Estimated Cost, of the LOA, or Block
21 (Estimated Cost) of the DD Form 1513.
ORD-ADMIN-COST Dollar value of the administrative
cost as shown in Line (10), administrative charge, of the LOA, or Block 2
(Estimated General Administrative Cost) of the DD Form 1513.
ORD-ACSRL-COST Dollar value of the accessorial
costs. This amount is calculated by
adding lines (9), packing, crating, and handling, and (11) Transportation of
the LOA or Blocks 22 (Estimated packing, crating, and handling costs) and 25
(Other estimated costs) of the DD Form 1513.
ULO Summary Costs
ULO -REQD Unliquidated
Obligations Required. This is a computation that is systematically performed by
DIFS at the time the IA closure certificate is submitted. This calculation is
performed only for Accelerated Case Closure cases. The calculation is performed
as follows:
Certified
Delivery Cost $000000
Less
Certified Art/Svc Disbmts $000000
& CAS and LSC Disbmts $000000
ULO Required $000000
ULO-EQUITY Unliquidated
Obligations Equity Amount. This value represents each case's portion of the
cash balance in the Case Closure Summary Suspense Account.
ULO-EA ISS ULO
Expenditure Authority Issued. This value represents the net value of
expenditure authority request recorded in DIFS
after a ULO case has been certified for closure.
ULO-DISB Unliquidated
Obligations Disbursed. This amount represents the net value of disbursements
recorded in DIFS after a ULO case has been certified for closure.
Progress Payments
PGR-PMT-RPT Progress
payments reported. Represents the amount of progress payments reported in the
FK History file. These are generally cash disbursements or reimbursements to an
appropriation. This is a cumulative field and records all progress payments
reported from implementation forward.
PP-DISB-UNDLV Progress payments disbursed
undelivered. Represents the total amount of progress payments reported for
which liquidating deliveries have not been reported. Stated another way, it is
the amount of progress payments reported which exceeds the amount of
liquidating articles/services delivered.
PRG-PMT-HLDBK Progress payment holdback. An amount
computed by DFAS-DE and applied to progress payments disbursed undelivered.
PP-ADMIN-COST Progress payment administrative
cost. Computed at summary
level, it is equal to administrative costs earned minus delivered
administrative costs.
TOT-UNLIQ-PP Total unliquidated progress
payments. This value represents the total of disbursed undelivered plus
computed CAS, holdback, and administration. (this field will not be allowed to
be negative).
PRG-PMT-CAS Progress
payment CAS. Amount of CAS included in PRGPMT-RPT amount above. Now
automatically generates liquidating delivered CAS amount ( DLVR-CAS-LIQ).
Delivered Cost
DLVR-SEC21-NON-LIQ Delivery section 21 Non-liquidating.
Deliveries under Section 21, AECA (DoD inventories) that does not liquidate
progress payments.
DLVR-SEC21-LIQ Delivery Section 21 Liquidating.
Deliveries under Section 21, the Arms
Export Control Act (AECA), (DoD inventories) that liquidates progress
payments.
DEL-SEC22-NON-LIQ Delivery Section 22 Non-liquidating.
Deliveries under Section 22, AECA, (Procurement) that does not liquidate
progress payments.
DEL-SEC22-LIQ Delivery Section 22 Liquidating.
Deliveries under Section 22, AECA, (Procurement) that liquidates progress
payments.
DLVR-ART-SVC-COST Delivered Articles/Services Cost. This field
contains the total amount of reported deliveries from both DoD inventories (non-contract) and contract
(procurement) for the entire case.
DLVR-ADMIN-COST Delivered Administration Cost. Cumulative value of administrative costs
applied to reported performance above.
DLVR-ACSRL-COST Delivered Accessorial Cost. Amount of
Accessorial costs applied to above deliveries.
TOTAL-DLVR-COST Total Delivered Cost. This total
delivered cost is the sum of delivered articles/services, plus delivered
administrative plus delivered accessorial costs shown above.
DLVR-CAS-NON-LIQ Delivered Costs (CAS ) Non-Liquidated.
The cumulative amount of contractor administrative surcharge computed on contractual
deliveries that do not liquidate progress payment CAS.
DLVR-CAS-LIQ Delivered costs (CAS) Liquidated.
The cumulative amount of contractor administrative surcharge computed on
contractual deliveries that liquidated progress payment CAS.
LSC-STOCK-FUND Logistics support charge and/or stock
fund add-on amount. The amount of LSC and/or stock fund authorized charges that
have been computed based on performance. These charges are computed by DFAS-DE.
The stock fund computation was deactivated January 1987. The Logistics Support
Charge was activated April 1987. This field may contain a combination of LSC
and Stock Fund computations at Total Case level.
RPT-EXPN Reported
expenditures. Total case reported expenditures as of the report date. It is the
sum of the total delivered articles/services cost plus progress payments
disbursed undelivered at case level.
ADMIN-EARNED Administrative
Charges Earned. Current cumulative transfers to the Administrative cost
clearing account at case level.
Collections
TRUST-FUND-CLCT Amount collected into the country’s
trust fund.
INT-BR-ACCT-BAL Interest bearing account
balance. Amount deposited in an
interest bearing account with the FRBNY for this case.
TOTAL-CLCT Total
collections. Represents the total
collections for this
particular case.
FIC1 F2820 82 BILLING STATUS PAGE 003 OF 023
PRIOR STATEMENT COUNTRY
BN IA B
CASE JAC BILLING TO DATE
STMT-NBR 9512NB
ACRD-COST-PQTR 3,282,471.64 ACRD-COST 3,282,471.64
TERM-LIAB-PQTR .00 TERM-LIAB .00
UEA-PQTR 210,171.36 UEA 214,190.03
PS-ACTV-PQTR 4,019 PS-ACTV-QTR-01 3
FIN-REQR-PQTR 3,496,662.00 FIN-REQR 3,496,662.00
CLCT-PQTR 3,692,562.00 TOTAL-CLCT 3,692,562.00
PMT-DUE-PQTR .00 PMT-DUE .00
DATES MISCELLANEOUS DATA AMOUNTS
CASE-ESTAB 9X039 INDICATORS INIT-DEP-REQR 45,806.00
LST-PS-TRAN 9X303 FMS-CR-CLCR .00
LAST-TRAN 9X303 PS-K-IND-PQTR N MAP-COLLECTIONS .00
LST-K-TRAN PS-K-IND-HSTRY
AMEND-ACPT 9X096 PS-HST-CALC-BLK PS-K-NQTR .00
ACSRL-CMCMT S3-CLSR-TYPE PS-HSTRY-AS 1,136,178.00
LST-STAT-CNG 9X331 DSAA-RPT-CD PS-HSTRY-TL .00
L-PERF-UPDT 9601 PS-HSTRY-HB .00
BILLING STATUS DATA
Prior Statement
STMT-NBR Statement
Number. This data element has two
components; the first representing the numeric year and month the last
statement was sent to the purchaser and the second representing the “bill
code”. The number 9512NA, for example, indicates that the last statement
provided the purchaser was as of year 1995, and the month being the
12th.Therefore, the date of the last statement was 30 December 1995. The NA part of the Statement Number
represents the “bill code”. A two letter
alphabetic code mechanically assigned by DFAS-DE, which divides FMS purchaser
country billings into management levels lower than U.S. implementing activity
and in-country services. This code often correlates to the purchaser paying
office. This “bill code” has different meanings to different purchasers.
ACRD-COST-PQTR Accrued
cost prior quarter. This figure represents the total amount for articles and
services plus administrative and accessorial charges accrued through the end of
the prior quarter. This cost plus others
described below is found in column 10 of the DD Form 645 sent to the purchaser
for the prior quarter.
TERM-LIAB-PQTR Termination
liability prior quarter. Potential
costs, as of the end of the prior quarter, that represents the liability DoD
has to contractors in the event termination occurs.
UEA-PQTR Unearned
advance prior quarter (prior statement).
PS-ACTV-PQTR Payment
schedule active prior quarter. Equals the amount of the payment schedule for
the prior quarter’s bill reflected in column 11 of that bill.
FIN-REQR-PQTR Financial
requirements prior quarter. This is the
sum of accrued cost prior quarter, termination liability prior quarter and any
unearned advance plus payment schedule active prior quarter. This sum is in column 12 of the DD 645 on the
prior statement.
CLCT-PQTR Collections
through the prior quarter. The
cumulative receipts received from the purchaser as of the end of the prior
quarter will include both trust fund account and interest bearing account (if
any) amounts. This value is from column 13 of the DD 645.
PMT-DUE-PQTR Payment
due prior quarter. This amount should
equal prior quarter financial requirements minus collections. This value is from column 14 of the DD 645.
BILLING TO DATE
Amounts shown in
this section will be as of the inquiry and will not necessarily be the billed
amount on the next DD 645. Amounts here
merely represent the case position as of the inquiry date.
ACRD-COST Accrued
Cost. This is the cost accrued since
case implementation. To determine
activity since the last billing, subtract accrued cost prior quarter ACRD-COST-PQTR
from ACRD COST. A difference here may
indicate deliveries during the period.
TERM-LIAB Termination
liability. Termination liability set
aside as of the date of the inquiry.
Should only have termination liability on procurement coded (P) cases.
UEA Unearned
advance. Amount of dollars still
available for work in the current quarter.
Reflects amounts not yet supported by deliveries.
PS-ACTV-QTR-01 Payment
schedule active quarter 01. This amount
is from the payment schedule and should be in the next bill sent to the
purchaser. (see the payment schedule
data format, page4 of DIFS case control summary data. Amounts here and QTR01 of the payment
schedule format should be equal.)
FIN-REQR Financial
requirements. Financial requirements
through the next billing should be current as of the date of the inquiry. It
will be the total of ACRD-COST plus TERM-LIAB or UEA plus PS-ACTV-QTR-01.
TOTAL-CLCT Total
collected. Reflects total amount collected
from the purchaser on this case as of the date of the inquiry.
PMT-DUE Payment
due. Amount that should be reflected on
the next bill. This represents the
difference between the FIN-REQR and TOTAL-CLCT.
Miscellaneous Data
DATES
CASE-ESTAB Date
case was established. The Julian date
this case was established in the case control file of DIFS.
LST-PS-TRAN Date
of last payment schedule update transaction. Applies to source of supply “S”
cases only. Represents the date a K-card last updated the payment schedule for
this case.
LAST-TRAN Date
of last transaction. The last date a
transaction processed against the case.
Since this is summary data, the last transaction could be against any
line or at case level.
LST-K-TRAN Date
of last “K” card transaction.
LST-RQSN-ACPT Date
last requisition accepted. If
applicable, this is the date from the LOA after which requisitions will no
longer be accepted against the case.
AMEND-ACPT Date
amendment accepted. The date the LOA
amendment was accepted or the date DSCA countersigned the LOA
modification. This date refers to the
last amendment number or last modification number found on page 001 of DIFS
data case control summary for a particular case.
ACSRL-CMTMT Date
of accessorial commitment. Obsolete data
element; no longer updated.
LST-STATUS-CHG Date
of last status change. Indicates the
last date that the case status changed.
LST-PERF-UPDT Date
of last performance update. DIFS
accounting date of the most recent performance cycle which has posted to this
case or item number. The date in YYMM
format.
Indicators
PS-K-IND-PQTRY Payment
schedule commitment indicator prior quarter. Same explanation as PS-K-IND-HSTRY
below.
“K”
= Commitment update received and used.
“N” = No commitment update received.
“P” = Commitment update received but not used.
PS-K-IND-HSTRY Payment schedule commitment
indicator. Relates to the “K” card
system. “K” cards are commitment
transactions received at DFAS-DE and will only be accepted on cases with a
source of supply “S” (Stock). If a “K”
appears in this field, it indicates that “K” commitment has been received at
some time on this case. An “N” here indicates that no ”K” card has been
received on this case. A “P” indicates
that commitment has been received but not used.
PL-K-IND-NQTRY Payment schedule commitment
indicator next quarter. Same explanation
as PS-K-IND-HSTRY above.
“K” = Commitment received and used.
“N” = No commitment received.
“P” = Commitment received but not used.
PS-HSTRY-CALC-BLK Payment schedule calculation blocked.
S3-CLSR-TYPE S3
closure type. This field is used to
indicate the closure status of a particular FMS case. It is also used to facilitate reporting of
closures to the DSCA 1200 system.
Blank
- Case is open - has never been closed
1
= Case is closed - has never been reopened
2
= Case was closed - has been reopened
3
= Case was reopened - has reclosed since the last 1200 system reporting cycle.
Note - A case may migrate between codes
2 and 3.
DSCA-RPT-CD DSCA
report code. A code that indicates whether
DIFS case and line item data will be reported to the DSCA 1200 system.
Actually, there are only two codes; an “N” or a blank (yes, blank is a
code). If there is an N in this field,
the case is never reported to DSCA. So,
if there is nothing (a blank) the case is reported to DSCA.
Amounts
INIT-DEP-REQR Initial
deposit required. This is the initial
deposit requirement amount as specified in the LOA. For modified or amended cases, this amount
would reflect the amended or modified initial deposit amount. Can never be more than the LOA ordered value.
FMS-CR.CLCT FMS
credit collection. These are funds
received into the trust fund for the case, which is applicable to the FMS
credit program for the country of inquiry.
MAP-COLLECTIONS Military
assistance program collections. These
are funds received into the trust fund for this case, which are applicable to
the MAP program.
CNT-OTHER-CLCT This
field represents collections received from or on the behalf of a country other
than MAP or credit funds. Primarily it is purchaser cash received.
PS-K-PQTR Used
primarily by DFAS-DE.
PS-K-NQTR Used
primarily by DFAS-DE.
PS-HSTRY-AS Payment
schedule history articles and services.
PS-HSTRY-TL Payment
schedule history termination liability.
PS-HSTRY-HB Payment
schedule history contractor holdback.
PAYMENT SCHEDULE DATA
This
is the area of the DIFS Case Control that shows the payment schedule. It will
list the case payment schedule for 19 quarters ( that's almost five years).
If the schedule is for more than 19 quarters,
there is an entry on the screen 'UNSCH-AMT'. A figure here indicates that
the case has a five year or longer payment schedule and all the remaining payments are `lumped' together into one
dollar figure. That doesn't mean
that there is one payment in the 20th
quarter for the amount listed. It just means that that amount is due after the 19th quarter. Refer to
the case payment schedule for the dates and amounts due over the case life cycle.
|
FIC4 |
F2820 |
82 |
PAYMENT SCHEDULE DATA |
PAGE 004 |
OF 023 |
|||
|
|
|
COUNTRY |
BN |
IA B |
CASE JAC |
|
|
|
|
|
|
|
|
|||||
|
|
PS-ART-SVC |
PS-TERM-LIAB |
PS-HLDBK |
|||||
|
|
|
|
|
|||||
|
UNSCH-AMT |
0 |
|
|
|||||
|
QTR01 |
4,019 |
0 |
0 |
|||||
|
QTR02 |
0 |
0 |
0 |
|||||
|
QTR03 |
0 |
0 |
0 |
|||||
|
QTR04 |
0 |
0 |
0 |
|||||
|
QTR05 |
0 |
0 |
0 |
|||||
|
QTR06 |
0 |
0 |
0 |
|||||
|
QTR07 |
0 |
0 |
0 |
|||||
|
QTR08 |
0 |
0 |
0 |
|||||
|
QTR09 |
0 |
0 |
0 |
|||||
|
QTR10 |
0 |
0 |
0 |
|||||
|
QTR11 |
0 |
0 |
0 |
|||||
|
QTR12 |
0 |
0 |
0 |
|||||
|
QTR13 |
0 |
0 |
0 |
|||||
|
QTR14 |
0 |
0 |
0 |
|||||
|
QTR15 |
0 |
0 |
0 |
|||||
|
QTR16 |
0 |
0 |
0 |
|||||
|
QTR17 |
0 |
0 |
0 |
|||||
|
QTR18 |
0 |
0 |
0 |
|||||
|
QTR19 |
0 |
0 |
0 |
|||||
Data
Explanation
PS-ART-SVC
Payment schedule (by quarter) for the articles and/or services. Really, this is the case payment schedule and includes not only articles and services but admin and accessorial, etc., as well.
PS-TERM-LIAB Payment Schedule Termination
Liability ( by quarter). This field is not currently used in the DIFS Payment
Schedule. This amount is recorded only at case level in the Billing Section of
Case Control.
PS-HLDBK Payment Schedule Holdback (by
quarter). This field is not currently used in the DIFS Payment
Schedule. This amount is recorded only at case level in the Billing Section of
Case Control.
UNSCH-AMT Unscheduled Amount (NOT by
Quarter ). There are two instances where an amount will
show here if:
1. The payment schedule for the case extends
out more than 19 quarters. In that case, the amount shown
here should be that remaining after the 19th quarter.
2. The remaining payment schedule in the DIFS plus
current financial requirements do not total to the total case value.
Case Detail Level
Following are four sample screens at the Case Line Item Detail
Level. Generally, there is one screen
for each case line. This area of the
DIFS case control contains detailed data at the line level and also contains
most of the data elements found at case summary level.
FIC3 F2820 82 Case Detail Data Page 005of 023
Ordered Cost Country BN
IA B CASE
JAC RSN 001 Delivered Costs
ORD-ART-SVC-CST 36,749.00 DLVR-SEC21-NON-LIQ .00
ORD-ADMIN-COST 1,102.00 DLVR-SEC21-LIQ .00
ORD-ACSRL-COST 3,585.00 DLVR-SEC22-NON-LIQ .00
TOTAL-ORD-COST 41,436.00 DLVR-SEC22-LIQ 36.748.80
DLVR-ART-SVC-COST 36,748.80
PROGRESS PAYMENTS DLVR-ADMIN-COST 1,102.46
PRG-PMT-RPT 36,748.80 DLVR-ACSRL-COST 3,583.01
PP-DISB-UNDLVR .00 TOTAL-DLVR-COST 41,434.27
PRG-PMT-HLDBK .00 DLVR-CAS-NON-LIQ .00
TOTAL-UNLIQ-PP .00 DLVR-CAS-LIQ .00
PRG-PMT-CAS .00 LSC-STOCK-FUND .00
RPT-EXPN 36,748.80
DT-LST-PERF-UPDT 9510 FIX-PRC-CE DSCA-DLVR-AS-CST 36,748.99
DT-DLVR-CMTMT RSN-TYPE
BG ORD-QTY 144
DT-DLVR-CMPLT CMD-CD 20 DLVR-QTY 143
LST-C1-RPT-DT 94211 MOD-NBR 03 DSCA-DLVR-QTY 144
DT-DLVR-FCST AMEND-TYPE A SA-DLVR-TRAN-POST N
DT-AMEND-ACPT 92273 AMEND-NBR 01 ADMIN-PCT .030
FIC3 F2820 82 Case Detail Data Page0
06 of 023
Ordered Cost Country BN
IA B CASE
JAC RSN 002 Delivered
Costs
ORD-ART-SVC-CST 40,041.00 DLVR-SEC21-NON-LIQ .00
ORD-ADMIN-COST 1,201.00 DLVR-SEC21-LIQ .00
ORD-ACSRE-COST 3,907.00 DLVR-SEC22-NON-LIQ .00
TOTAL-ORD-COST 45,149.00 DLVR-SEC22-LIQ 40,041.00
DLVR-ART-SVC-COST 40,041.00
PROGRESS PAYMENTS DLVR-ADMIN-COST 1,102.236
PRG-PMT-RPT 40,041.00 DLVR-ACSRL-COST 3,904.01
PP-DISB-UNDLVR .00 TOTAL-DLVR-COST 45,146.24
PRG-PMT-HLDBK .00 DLVR-CAS-NON-LIQ .00
TOTAL-UNLIQ-PP .00 DLVR-CAS-LIQ .00
PRG-PMT-CAS .00 LSC-STOCK-FUND .00
RPT-EXPN 40,041.00
DT-LST-PERF-UPDT 9304 FIX-PRC-CE DSCA-DLVR-AS-CST 40,041.00
DT-DLVR-CMTMT RSN-TYPE
BG ORD-QTY 300
DT-DLVR-CMPLT CMD-CD 20 DLVR-QTY 300
LST-C1-RPT-DT 94211 MOD-NBR 03 DSCA-DLVR-QTY 300
DT-DLVR-FCST AMEND-TYPE A SA-DLVR-TRAN-POST N
DT-AMEND-ACPT 92273 AMEND-NBR 01 ADMIN-PCT .030
FIC3 F2820 82 Case
Detail Data Page
019 of 023
Ordered Cost Country BN
IA B CASE
JAC RSN 015 Delivered Costs
ORD-ART-SVC-CST 444,994.00 DLVR-SEC21-NON-LIQ .00
ORD-ADMIN-COST 13,349.00 DLVR-SEC21-LIQ .00
ORD-ACSR-COST 27,822.00 DLVR-SEC22-NON-LIQ 370,365.00
TOTAL-ORD-COST 486,165.00 DLVR-SEC22-LIQ .00
DLVR-ART-SVC-COST 370,365.38
PROGRESS PAYMENTS DLVR-ADMIN-COST 11,110.97
PRG-PMT-RPT .00 DLVR-ACSRL-COST 22,805.75
PP-DISB-UNDLVR .00 TOTAL-DLVR-COST 404,282.10
PRG-PMT-HLDBK .00 DLVR-CAS-NON-LIQ 5,473.38
TOTAL-UNLIQ-PP .00 DLVR-CAS-LIQ .00
PRG-PMT-CAS .00 LSC-STOCK-FUND .00
RPT-EXPN 370,365.38
DT-LST-PERF-UPDT 9601 FIX-PRC-CD DSCA-DLVR-AS-CST 444,994.00
DT-DLVR-CMTMT RSN-TYPE
BG ORD-QTY 2,200
DT-DLVR-CMPLT CMD-CD 65 DLVR-QTY 1,831
LST-C1-RPT-DT 94211 MOD-NBR 01 DSCA-DLVR-QTY 2,200
DT-DLVR-FCST AMEND-TYPE A SA-DLVR-TRAN-POST N
DT-AMEND-ACPT 92273 AMEND-NBR 01 ADMIN-PCT .030
FIC1 F2820 82 Case Detail Data Page 023
of 023
Ordered Cost Country BN
IA B CASE
JAC RSN 019 Delivered Costs
ORD-ART-SVC-CST 36,507.00 DLVR-SEC21-NON-LIQ .00
ORD-ADMIN-COST 1,095.00 DLVR-SEC21-LIQ .00
ORD-ACSR-COST 3,599.00 DLVR-SEC22-NON-LIQ .00
TOTAL-ORD-COST 45,161.00 DLVR-SEC22-LIQ 36,506.00
DLVR-ART-SVC-COST 36,506.05
PROGRESS PAYMENTS DLVR-ADMIN-COST 1,095.18
PRG-PMT-RPT 36,505.05 DLVR-ACSRL-COST 3,559.34
PP-DISB-UNDLVR .00 TOTAL-DLVR-COST 41,160.57
PRG-PMT-HLDBK .00 DLVR-CAS-NON-LIQ .00
TOTAL-UNLIQ-PP .00 DLVR-CAS-LIQ .00
PRG-PMT-CAS .00 LSC-STOCK-FUND .00
RPT-EXPN 36,506.00
DT-LST-PERF-UPDT 9403 FIX-PRC-CE DSCA-DLVR-AS-CST .00
DT-DLVR-CMTMT RSN-TYPE
BG ORD-QTY 259
DT-DLVR-CMPLT CMD-CD 20 DLVR-QTY 258
LST-C1-RPT-DT MOD-NBR DSCA-DLVR-QTY 0
DT-DLVR-FCST AMEND-TYPE A SA-DLVR-TRAN-POST N
DT-AMEND-ACPT 92273 AMEND-NBR 01 ADMIN-PCT .030
Data
Elements of the Case Detail Data
Most
of the data elements found at Case Summary level are also found here. One exception is the data on
collections. Collections are at case
level only. Additionally,. There are
unique data elements found at detail level that are not found at case level. Therefore, the following data elements are
those “common” elements with case summary and those unique line level ones.
Ordered
Cost
ORD-ART-SVC-CST Dollar value of
the ordered articles and service cost as shown in Line (8), Net Estimated Cost,
of the LOA, or Block 21 (Estimated Cost) of
the DD Form 1513.
ORD-ADMIN-COST Dollar value
of the Administrative cost as shown in Line (10),
Administrative Charge, of the LOA, or Block 2 (Estimated General Administrative
Cost) of the DD Form 1513.
ORD-ACSRL-COST
Dollar
value of the accessorial costs. This
amount is calculated by adding Lines (9), Packing, Crating, and Handling, and
(11) Transportation of the LOA or Blocks 22 (Estimated Packing, Crating, and
Handling Costs) and 25 (Other Estimated Costs) of the DD Form 1513.
TOTAL-ORD-COST
Total case
value as computed by summing all cost components of the LOA or the DD Form
1513. This summed value should equal the TOTAL-1513-CST.
Progress
Payments
PGM-PMT-RPT Progress
payments reported. Represents the amount of progress
payments reported in the FK History file. These generally represent cash
disbursements or reimbursements to an appropriation. This is a cumulative field
and records all progress payments reported from implementation to closure via
the FICS ‘NDI’ transaction and recorded in DIFS History as FKP/FKQ
transactions.
PP-DISB-UNDLV
Progress
payments disbursed undelivered. Represents the total amount of progress
payments reported for which liquidating deliveries have not been reported.
Stated another way, it is the amount of progress payments reported which
exceeds the amount of liquidating articles and services delivered.
PRG-PMT-HLDBK Progress
payment holdback. An amount computed by DFAS-DE and applied to progress
payments disbursed undelivered
TOTAL-UNLIQ-PP Total
Unliquidated Progress Payments. The total of Progress Payments Disbursed
Undelivered plus Progress Payment Holdback.
PRG-PMT-CAS Progress
Payment CAS. Amount of CAS computed on the PRG-PMT-RPT value above.
Automatically generates DLVR-CAS-LIQ amount.
Delivered
Cost
The
value at case level for the next ten items is the sum total of the line level
values recorded.
DLVR-SEC21-NON-LIQ Delivery section 21 Non-liquidating.
Deliveries under Section 21, Arms Export
Control Act (AECA) (DoD inventories) that does not liquidate progress payments.
DLVR-SEC21-LIQ Delivery
Section 21 Liquidating. Deliveries under
Section 21, AECA, (DoD inventories) that liquidates progress payments.
DEL-SEC22-NON-LIQ Delivery Section
22 Non-liquidating. Deliveries under Section 22, AECA, (Procurement) that do
not liquidate progress payments.
DEL-SEC22-LIQ Delivery
Section 22 Liquidating. Deliveries under Section 22, AECA, (Procurement) that
liquidate progress payments.
DLVR-ART-SVC-COST Delivered
Articles/Services Cost. This field contains the total of reported deliveries
recorded in the section 21 and 22 fields above. The detail delivery
transactions are recorded in DIFS FK History as FKA/FKB transactions
DLVR-ADMIN-COST Delivered
Administration Cost. Cumulative value of administrative costs applied to
reported performance above. FK History records the detail as FKC/FKD
transactions.
DLVR-ACSRL-COST Delivered
Accessorial Cost. Amount of Accessorial costs applied to above deliveries. FK
History records the detail as FKE/FKF transactions.
TOTAL-DLVR-COST Total Delivered
Cost. This total delivered cost is the
sum of delivered articles and services, plus delivered administrative plus
delivered accessorial costs shown above.
DLVR-CAS-NON-LIQ Delivered Costs
(CAS) Non-Liquidated. The cumulative
amount of contractor administrative surcharge computed on contractual
deliveries that do not liquidate progress payment CAS.
DLVR-CAS-LIQ
Delivered
Costs(CAS) Liquidated. The cumulative amount of contractor administrative
surcharge computed on contractual deliveries that liquidated progress payment
CAS.
LSC-STOCK-FUND
Logistics
Support Charge and/or Stock Fund Add-on amount. The amount of LSC and/or stock
fund authorized charges that have been computed based on performance. These charges are computed by DIFS. The stock
fund computation was deactivated January 1987. The Logistics Support Charge was
activated April 1987. This field may contain a combination of LSC and Stock
Fund computations depending upon when deliveries were reported..
RPT-EXPN
Reported
Expenditures. Total case reported
expenditures as of the report
date. It is the sum of the total
delivered articles/ services cost plus progress payments disbursed undelivered
at case level.
ADMIN-EARNED Administrative
Charge Earned. Current cumulative
transfers to the
administrative cost clearing account at case level.
DSCA-DLVR-AS-CST
DSCA
Delivered Articles and Services cost.
For SME line items, this is the cost of the delivered articles and
services reported to the DSCA 1200 system. Cost is normally the ordered unit
cost on the LOA times the DSCA-DLVR-QTY below.
DT-LST-PERF-UPDT
Date of Last
Performance Update. The date in YYMM
format is the last time this particular line was updated by either deliveries
(NA) or progress payments (ND).
DT-DLVR-CMTMT
Date of
Delivery Commitment. The date shown on
the LOA for delivery of the items on this particular line. This date in DIFS is in YYQ format, with the
Quarter noted as the calendar quarter, i.e., 1,2,3,or 4. Not a required entry.
DT-DLVR-CMPLT Date of
Delivery Completion. The date, in YYMM
format, of delivery completion for the
DSCA-DLVR-QTY of SME on this particular line.
LST-C1-RPT-DT
Last
C1 Report Date for DSCA Delivered Quantity Update. In other words, the last time the DSCA
Delivered Quantity was updated by an input transaction.
DT-DLVR-FCST Date
Delivery Forecasted. A date when
delivery of the total quantity of items on this line is forecasted to be
complete. The date shown is in YYQ format
with the Quarter being the calendar quarter and shown numerically, i.e.,
1,2,3,or 4. Not a required entry.
DT-AMEND-ACPT
Date
Amendment Accepted. This is the date the
latest case Amendment was accepted by the Purchaser.
FIX-PRC-CD Fixed
Price Code. A code designed to suppress
selected computation of administrative or accessorial costs. These are:
Code Meaning
1 Bypass all including Admin
2 Bypass all but Admin
3 Bypass Transportation only
4 Compute Admin only
5 Bypass asset use only (Don't
forget that
the 1% asset use was eliminated in
1989
by the Fair Pricing Legislation)
RSN-TYPE Type
of Record Serial Number. (In DIFS, RSN means Line Number). A code identifying the category of material
or service being provided on this line item, e.g., Spare Parts, Training, etc.
See Appendix S for RSN type codes.
CMD-CD
Command
Code. Identifies the activity responsible for the item number. See Appendix T
for codes.
MOD-NBR
Modification
Number. Number of the latest case Modification that has been implemented in
DIFS.
AMEND-TYPE
Amendment
Type. Identifies the most recent type of change
implemented
in DIFS.
A
= Amendment is over $50,000 net change
B
= Amendment is less than or equal to $50,000 net change
AMEND-NBR Amendment
Number. Number of the latest Amendment implemented in DIFS.
ORD-QTY Ordered
Quantity. The number of units ordered
for an item number. Generally taken from the LOA, column 3.
DLVR-QTY Delivered
Quantity. The number of units computed
as delivered for a particular item number.
This quantity is calculated by dividing the DLVR-ART-SVC-COST by the
latest unit cost on the LOA. Does not always equal the quantities on the LOA.
DSCA-DLVR-QTY
DSCA
Delivered Quantity. For SME items, the
quantity of delivered articles/ services reported to the DSCA 1200 system. This quantity is reported by the MILDEPS via
the ‘C1’ transaction.
SA-DLVR-TRAN-POST A ‘Y’ indicates
DFAS-DE has input an internal delivered value update to this line item. An ‘N’
indicates all performance was reported by the MILDEP
ADMIN-PCT Administrative
Percent. The Administrative percentage
applied by DIFS against deliveries reported on this line. The percentage should be consistent with the
amount required by line number on the LOA.
Case
Closure Certificate Inventory
One way to check on the status of a case closure
certificate is to use the DIFS.Case Closure Certificate Inventory (CCCI). Here,
on the inquiry screen, the country, IA, and FMS case are entered and the case
closure certificate status, along with some dates and values are provided. Data shown and a short explanation of the
data follows. Note that dates are on the
left hand portion of the form and values are on the right hand side. To keep from flipping pages, the data
elements will be presented from top of the form to the bottom. This means that the short explanation
following will jump between dates and dollars.
FII1 CASE
CLOSURE CERTIFICATE INVENTORY F282 82
INQUIRY
COUNTRY BN IA B CASE XXX
Certificate Date 95222 Certificate Value 51,104,610.21
DFAS-DE Receipt Date 95222 Certified DISB 50,509,344.99
Certificate Status Date 95273 ULO-Required Value 23,329.70
Certificate Closure Date 95270 Case Control DLVR AS 51,104,610.21
Closure Type Required 2 FK History DLVR AS 0.000R
Reopened Case Indicator UNLIQ
Program Payment 0.00
Primary Status Assigned C Total Collections 52,640,037.22
Certificate Revision IND Total
DIFS DISB 52,616,707.22
Originating Office Code BA Total DLVR Costs 52,640,037.22
Bypass Code Entered Total
CLSR Inhibitors C
If the
current status code = I and you are authorized
do you wish to generate a C8
Transaction?
EXPLANATION
CERTIFICATE
DATE Rather
self-explanatory. It is the date of the IA closure certificate.
CERTIFICATE
VALUE The
Articles/Services delivered value being certified by the submitting IA. Does
not include Administrative or Accessorial values, but does include CAS and LSC.
DFAS-DE RECEIPT
DATE Date the
certificate was received and recorded in DIFS.
CERTIFIED DISB The IA
certified Articles/Services disbursement value.
CERTIFICATE
STATUS DATE The date the
‘Primary Status’ was assigned to the certificate. See primary status in
ULO-REQUIRED VALUE This is the
un-liquidated obligations required and is a
value
calculated as a new ULO certificate is added to the
Case
Closure Certificate Inventory. This figure represents
the
difference between certified deliveries and certified
disbursements,
less DIFS CAS and LSC transfers. To see
how
this works, look at the explanation following this table
of
data elements and their short explanations.
CERTIFICATE
CLOSURE DATE Julian date case
was closed in DIFS; may or may not equal the DT-CLSR in DIFS case control.
CASE
CONTROL DLVR AS This is
the Delivered Articles and/or services value as shown in the DIFS case control
summary file. This value should be the same as the certificate value above.
CLOSURE TYPE
REQUESTED The type of closure
requested by the IA. There are three
codes
that may appear here:
1 Non-accelerated for cases not in the ACC
program;
2 Interim for cases in the ACC program;
3 Final for cases in the ACC program
FK
HISTORY DLVR AS This
is the DIFS FK History delivered ART/SVC cost for the case summed from the
FKA/FKB ‘EXT-VAL-BILLED. See ‘K’ status in
REOPENED CASE INDICATOR An “R” in this field means that
the case has been reopened.
If
this field is blank, either the case has been closed for some time, or the case is being reviewed for
closure for the first time.
UNLIQ
PROG PAYMENT If
there are Un-liquidated Progress Payments, the case normally cannot be closed.
See status Q in
PRIMARY
STATUS ASSIGNED The current
status code assigned. It identifies inhibitors or other codes related. to case
closure. A listing of the Case Closure Certificate Inventory Status Codes can
be found at Appendix U
TOTAL COLLECTIONS The dollar amount of
the collections for this case or how
much
has the purchaser paid on this case.
CERTIFICATE
REVISION
TOTAL
DIFS DISB Total
amount of case disbursements as recorded in DIFS for ART/SVC, Admin,
Accessorial, CAS, and LSC
Originating Office Code Assigned
initially by DIFS to identify the MILDEP certifying activity.
TOTAL DLVR COST As opposed to
Articles and/or Services, this value
represents
the total delivered cost of the case. It is the total
of
delivered articles and/or services plus the delivered
administrative
fee plus the delivered accessorial costs. For
closure,
the total delivered cost should equal the total
collections.
Bypass code entered An entry in this field indicates an
irreconcilable difference has been assigned to allow the case to close
Total CLSR inhibitors This field reflects all CCCI status codes
for closure inhibitors yet to be resolved before the case can be closed.
PART 3