CONTROL POINT ACTIVITY FILE ACCESS ICR (6634)

Name

Value

NUMBER

6634

IA #

6634

FILE NUMBER

410

GLOBAL ROOT

PRCS(410,

DATE CREATED

2016/11/16

CUSTODIAL PACKAGE

IFCAP

USAGE

Controlled Subscription

TYPE

File

DBIC APPROVAL STATUS

APPROVED

NAME

CONTROL POINT ACTIVITY FILE ACCESS

GENERAL DESCRIPTION

Above PAR and the Advanced Prosthetics Acquisition Tool
(APAT) request permission to reference the CONTROL POINT ACTIVITY FILE #410 to
create/edit 2237's during the creation of purchase card orders and 2237's and
during purchase card reconciliation/close-out.


Above PAR Ad-Hoc Reporting includes the CONTROL POINT ACTIVITY FILE #410.
Ad-Hoc functionality provides the ability to select fields from the file for
display on user-defined reports.  Ad-Hoc offers only FileMan read access and
only if the user has permission to view the file.

GLOBAL REFERENCE

FIELD NUMBER

GLOBAL DESCRIPTION

PRCS(410,D0,0)

FIELD NUMBER	ACCESS	FIELD DESCRIPTION	FIELD NAME	LOCATION
.01	Both R/W w/Fileman	Global r	TRANSACTION NUMBER	0;1
1	Both R/W w/Fileman	Global r	TRANSACTION TYPE	0;2
2	Read w/Fileman		TEMPORARY TRANS. NUMBER	0;3
3	Both R/W w/Fileman		FORM TYPE	0;4
.5	Direct Global Read & w/Fileman		STATION NUMBER	0;5
4	Both R/W w/Fileman	Global r	INVENTORY DISTRIBUTION POINT	0;6
3.1	Read w/Fileman		INTERVAL ISSUE?	0;7
3.2	Read w/Fileman		MONTH OF 1358	0;8
67	Read w/Fileman		CONVERTED 1358	0;9
448	Read w/Fileman		SUBSTATION	0;10
449	Read w/Fileman		RUNNING BALANCE QUARTER DATE	0;11
450	Read w/Fileman		RUNNING BALANCE STATUS	0;12

PRCS(410,D0,1)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
5	Both R/W w/Fileman	DATE OF REQUEST	1;1
451	Both R/W w/Fileman	PURCHASE CARD RECORD	1;2
7.5	Both R/W w/Fileman	PRIORITY OF REQUEST	1;3
7	Both R/W w/Fileman	DATE REQUIRED	1;4
8	Both R/W w/Fileman	CLASSIFICATION OF REQUEST	1;5
6	Read w/Fileman	SERVICE START DATE	1;6
6.5	Read w/Fileman	SERVICE END DATE	1;7
103	Read w/Fileman	ECMS ACTIONUID	1;8
104	Read w/Fileman	CANCELLED BY	1;9
105	Read w/Fileman	CANCEL DATE/TIME	1;10

PRCS(410,D0,2)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
11	Both R/W w/Fileman	VENDOR	2;1
11.1	Both R/W w/Fileman	VENDOR ADDRESS1	2;2
11.2	Both R/W w/Fileman	VENDOR ADDRESS2	2;3
11.3	Both R/W w/Fileman	VENDOR ADDRESS3	2;4
11.4	Both R/W w/Fileman	VENDOR ADDRESS4	2;5
11.5	Both R/W w/Fileman	VENDOR CITY	2;6
11.6	Both R/W w/Fileman	VENDOR STATE	2;7
11.7	Both R/W w/Fileman	VENDOR ZIP CODE	2;8
11.8	Both R/W w/Fileman	VENDOR CONTACT	2;9
11.9	Both R/W w/Fileman	VENDOR PHONE NO.	2;10

PRCS(410,D0,3)

FIELD NUMBER	ACCESS	FIELD DESCRIPTION	FIELD NAME	LOCATION
15	Both R/W w/Fileman		CONTROL POINT	3;1
28	Read w/Fileman		ACCOUNTING DATA	3;2
15.5	Both R/W w/Fileman		COST CENTER	3;3
12	Both R/W w/Fileman	Global r	VENDOR(POINTER)	3;4
6.3	Both R/W w/Fileman		REQUESTING SERVICE	3;5
17	Read w/Fileman		BOC1	3;6
17.5	Read w/Fileman		BOC1 $ AMOUNT	3;7
18	Read w/Fileman		BOC2	3;8
18.5	Read w/Fileman		BOC2 $ AMOUNT	3;9
13	Read w/Fileman		VENDOR CONTRACT NUMBER	3;10
28.5	Read w/Fileman		BBFY	3;11
28.1	Read w/Fileman		FCP/PRJ	3;12

PRCS(410,D0,4)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
20	Read w/Fileman	COMMITTED (ESTIMATED) COST	4;1
21	Both R/W w/Fileman	DATE COMMITTED	4;2
22	Read w/Fileman	OBLIGATED (ACTUAL) COST	4;3
23	Read w/Fileman	DATE OBLIGATED	4;4
24	Both R/W w/Fileman	PURCHASE ORDER/OBLIGATION NO	4;5
25	Read w/Fileman	ADJUSTMENT $ AMOUNT	4;6
26	Read w/Fileman	DATE OBL ADJUSTED	4;7
27	Both R/W w/Fileman	TRANSACTION $ AMOUNT	4;8
29	Read w/Fileman	OBLIGATED BY	4;9
29.5	Read w/Fileman	OBLIGATION VALIDATION CODE	4;10
29.6	Read w/Fileman	OBLIGATION VALIDATION VERSION	4;11
29.7	Read w/Fileman	OBLIGATION SIGNATURE BLOCK	4;12
29.8	Read w/Fileman	OBLIGATION VAL CODE DATE/TIME	4;13
25.5	Read w/Fileman	ADJUST CP BALANCE ONLY	4;14

PRCS(410,D0,5)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
30	Read w/Fileman	FMS $ AMOUNT	5;1
31	Read w/Fileman	FMS DATE	5;2
32	Read w/Fileman	FMS TRANSACTION TYPE	5;3
33	Read w/Fileman	END DATE FOR 1358	5;4
34	Read w/Fileman	AUTO ACCRUE	5;5

PRCS(410,D0,6)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
35	Read w/Fileman	CEILING $ AMOUNT	6;1
36	Read w/Fileman	DATE ALLOCATED	6;2
37	Read w/Fileman	FUND CONTROL POINT DIST. NO	6;3
38	Read w/Fileman	TEMP CP REF#	6;4

PRCS(410,D0,7)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
40	Both R/W w/Fileman	REQUESTOR	7;1
41	Both R/W w/Fileman	REQUESTOR'S TITLE	7;2
42	Read w/Fileman	APPROVING OFFICIAL	7;3
43	Read w/Fileman	APPR. OFFICIAL'S TITLE	7;4
44	Read w/Fileman	DATE SIGNED (APPROVED)	7;5
44.5	Read w/Fileman	VALIDATION CODE	7;6
44.6	Read w/Fileman	ES CODE DATE/TIME	7;7
44.7	Read w/Fileman	GPF APPROVING FISCAL OFFICER	7;8
44.8	Direct Global Read & w/Fileman	GPF VALIDATION CODE	7;9
44.9	Read w/Fileman	GPF ES CODE DATE/TIME	7;10
39	Read w/Fileman	ACCOUNTABLE OFFICER	7;11
69	Read w/Fileman	AO SIGNATURE DATE	7;12

PRCS(410,D0,7.1)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
44.85	Read w/Fileman	GPF VALIDATION VERSION	7.1;1
44.87	Read w/Fileman	GPF ESIG CODE	7.1;2
44.55	Read w/Fileman	VALIDATION VERSION	7.1;3
44.57	Read w/Fileman	ESIG CODE	7.1;4

PRCS(410,D0,8,D1,0)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
.01	Read w/Fileman	JUSTIFICATION	0;1

PRCS(410,D0,9)

FIELD NUMBER	ACCESS	FIELD DESCRIPTION	FIELD NAME	LOCATION
46	Both R/W w/Fileman		DELIVER TO/LOCATION	9;1
47	Both R/W w/Fileman	Global r	EST. DELIVERY DATE	9;2
48	Read w/Fileman		DATE RECEIVED	9;3
48.1	Both R/W w/Fileman		EST. SHIPPING AND/OR HANDLING	9;4

PRCS(410,D0,10)

FIELD NUMBER	ACCESS	FIELD DESCRIPTION	FIELD NAME	LOCATION
50	Read w/Fileman		LINE ITEM COUNT	10;1
51	Read w/Fileman		PARENT TRANSACTION NUMBER	10;2
52	Both R/W w/Fileman	Global r	STATION NO - P.O. NO	10;3
56	Read w/Fileman		REQUEST STATUS	10;4

PRCS(410,D0,11)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
49	Both R/W w/Fileman	SORT GROUP	11;1
53	Read w/Fileman	ORIGINATOR OF TEMP # REQ.	11;2
55	Read w/Fileman	READY FOR APPROVAL/SIGNATURE?	11;3
19	Read w/Fileman	AUTHORITY	11;4
19.1	Read w/Fileman	SUB AUTHORITY	11;5

PRCS(410,D0,12,D1,0)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
.01	Both R/W w/Fileman	SUB-CONTROL POINT	0;1
1	Both R/W w/Fileman	$ AMOUNT	0;2

PRCS(410,D0,13,D1,0)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
.01	Read w/Fileman	REASON FOR RETURN	0;1

PRCS(410,D0,14)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
68	Both R/W w/Fileman	ORIGINATOR OF REQUEST	14;1

PRCS(410,D0,100)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
57	Read w/Fileman	LOG VOUCHER NUMBER (SUPPLY)	100;1
58	Read w/Fileman	LOG DIETETIC PERIOD	100;2
59	Read w/Fileman	FISCAL PROCESSING MONTH	100;3
62	Read w/Fileman	LOG CODE SHEETS SENT BY	100;4
63	Read w/Fileman	LOG CODE SHEETS VALID. CODE	100;5
64	Read w/Fileman	DATE SIGNED	100;6
65	Read w/Fileman	LOG VOUCHER NUMBER (FISCAL)	100;7
66	Read w/Fileman	LOG DEPARTMENT	100;8
63.5	Read w/Fileman	LOG CS VALIDATION VERSION	100;9
63.7	Read w/Fileman	LOG CS ESIG CODE	100;10

PRCS(410,D0,445)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
445.01	Read w/Fileman	REFERENCE VOUCHER NUMBER	445;1
445.02	Read w/Fileman	LAST FMSLINE USED	445;2
446	Read w/Fileman	TOTAL DOLLARS POSTED	445;3
447	Read w/Fileman	COUPLER	445;4
455	Read w/Fileman	ISSUE BOOK BATCH ID	445;5

PRCS(410,D0,'CO',D1,0)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
.01	Read w/Fileman	COMMENTS	0;1

PRCS(410,D0,'IT',D1,0)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
.01	Both R/W w/Fileman	LINE ITEM NUMBER	0;1
2	Both R/W w/Fileman	QUANTITY	0;2
3	Both R/W w/Fileman	UNIT OF PURCHASE	0;3
4	Both R/W w/Fileman	BOC	0;4
5	Both R/W w/Fileman	ITEM MASTER FILE NO.	0;5
6	Both R/W w/Fileman	STOCK NUMBER	0;6
7	Both R/W w/Fileman	EST. ITEM (UNIT) COST	0;7
8	Both R/W w/Fileman	ITEM DELIVERY POINTS	0;8
11	Read w/Fileman	RECEIVING CODE SHEET NO.	0;9
9	Read w/Fileman	PURCHASE ORDER/OBLIGATION NO	0;10
10	Read w/Fileman	INTERMEDIATE PRODUCT CODE	0;11
13	Read w/Fileman	QUANTITY POSTED (WHSE)	0;12
14	Read w/Fileman	QUANTITY RECEIVED (PRIMARY)	0;13
15	Read w/Fileman	STATUS	0;14

PRCS(410,D0,'IT',D1,1,D2,0)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
.01	Both R/W w/Fileman	DESCRIPTION	0;1

PRCS(410,D0,'IT',D1,2,D2,0)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
.01	Read w/Fileman	DELIVERY SCHEDULE	0;1
1	Read w/Fileman	DELIVERY REFERENCE NUMBER	0;2

PRCS(410,D0,'IT',D1,3)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
16	Read w/Fileman	PO EST. SHIPPING	3;1

PRCS(410,D0,'IT',D1,4)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
17	Read w/Fileman	DM DOC ID	4;1
18	Read w/Fileman	DATE NEEDED BY	4;2
100	Read w/Fileman	ECMS ITEMUID	4;3

PRCS(410,D0,'IT',D1,445)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
445.01	Direct Global Read & w/Fileman	ACCT-BOC	445;1
445.02	Direct Global Read & w/Fileman	FMSLINE	445;2
445.03	Direct Global Read & w/Fileman	TOTAL QUANTITY POSTED	445;3
445.04	Direct Global Read & w/Fileman	TOTAL INVENTORY VALUE	445;4
445.05	Direct Global Read & w/Fileman	TOTAL SELLING VALUE	445;5

PRCS(410,D0,'RM',D1,0)

FIELD NUMBER	ACCESS	FIELD NAME	LOCATION
.01	Direct Global Read & w/Fileman	SPECIAL REMARKS	0;1

PRCS(410,'B'

File 410 'B' cross-reference  Used to look up by
TRANSACTION NUMBER

PRCS(410,D0,'IT','AG'

File 410 'IT','AG' cross-reference  For looking up a
2237's item line
based on the file #410 entry's
IEN and the Item Master File (IMF)
Number on that item line

PRCS(410,'AO'

File 410 "AO" cross reference  Used to look up by
INVENTORY DISTRIBUTION POINT for the transaction

PRCS(410,'AQ'

File 410 'AQ' cross reference  Used to look up by
TRANSACTION NUMBER only for requests that are ready for the Control Point
Official's approval

PRCS(410,'E'

File 410 "E" cross reference  Used to look up
transactions by VENDOR NAME

STATUS

Active

KEYWORDS

APAT
ABOVE PAR

DURATION

Till Otherwise Agreed

PRCS(410,

SUBSCRIBING PACKAGE

ABOVE PAR
ADVANCED PROSTHETICS ACQUISITION TOOL

DATE ACTIVATED

2018/11/14