STANDARD DATA DICTIONARY #445.1 -- INVENTORY BALANCES FILE 3/24/25 PAGE 1
STORED IN ^PRCP(445.1, *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 5.1)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
This file stores the beginning monthly balances for the items stored in the inventory points.
FILE SCREEN (SCR-node) : I $D(DIS(0))!($G(PRCPPRIV))
DD ACCESS: @
WR ACCESS: @
DEL ACCESS: @
LAYGO ACCESS: @
AUDIT ACCESS: @
CROSS
REFERENCED BY: INVENTORY POINT(B)
445.1,.01 INVENTORY POINT 0;1 POINTER TO GENERIC INVENTORY FILE (#445) (Required)
INPUT TRANSFORM: K:'$G(PRCPPRIV) X S:$G(X) DINUM=X
LAST EDITED: JUL 23, 1992
DESCRIPTION:
This field stores the name of the inventory point from file 445.
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
CROSS-REFERENCE: 445.1^B
1)= S ^PRCP(445.1,"B",$E(X,1,30),DA)=""
2)= K ^PRCP(445.1,"B",$E(X,1,30),DA)
445.1,1 INVENTORY ITEM 1;0 POINTER Multiple #445.11
DESCRIPTION:
This field is the item stored within the inventory point.
445.11,.01 INVENTORY ITEM 0;1 POINTER TO ITEM MASTER FILE (#441) (Multiply asked)
INPUT TRANSFORM: S DINUM=X
LAST EDITED: JUL 23, 1992
DESCRIPTION:
This field is the item stored within the inventory point.
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
CROSS-REFERENCE: 445.11^B
1)= S ^PRCP(445.1,DA(1),1,"B",$E(X,1,30),DA)=""
2)= K ^PRCP(445.1,DA(1),1,"B",$E(X,1,30),DA)
445.11,1 BEGINNING MONTH-YEAR BALANCE 1;0 DATE Multiple #445.111
DESCRIPTION:
This field will store the month and year for the beginning item balance.
445.111,.01 BEGINNING MONTH-YEAR BALANCE 0;1 DATE (Multiply asked)
INPUT TRANSFORM: S %DT="EX" D ^%DT S X=$E(Y,1,5) K:Y<1 X S:$G(X) DINUM=X
LAST EDITED: JUL 23, 1992
DESCRIPTION:
This field will store the month and year for the beginning item balance.
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
CROSS-REFERENCE: 445.111^B
1)= S ^PRCP(445.1,DA(2),1,DA(1),1,"B",$E(X,1,30),DA)=""
2)= K ^PRCP(445.1,DA(2),1,DA(1),1,"B",$E(X,1,30),DA)
445.111,1 QUANTITY ON-HAND 0;2 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999999)!(X<-9999999)!(X?.E1"."1N.N) X
LAST EDITED: JUL 23, 1992
HELP-PROMPT: Enter the beginning monthly quantity on hand in unit per issue (from -9999999 to 9999999)
DESCRIPTION:
This field stores the beginning monthly quantity on-hand balance in the unit per issue.
445.111,2 QUANTITY NON-ISSUABLE 0;3 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999999)!(X<-9999999)!(X?.E1"."1N.N) X
HELP-PROMPT: Enter the beginning monthly quantity non-issuable in unit per issue (from -9999999 to 9999999)
DESCRIPTION:
This field stores the beginning monthly quantity in non-issuable balance in the unit per issue.
445.111,3 QUANTITY DUE-IN 0;4 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999999)!(X<-9999999)!(X?.E1"."1N.N) X
HELP-PROMPT: Enter the beginning monthly quantity due-in in unit per issue (from -9999999 to 9999999)
DESCRIPTION:
This field stores the beginning monthly quantity due-in balance in the unit per issue.
445.111,4 QUANTITY DUE-OUT 0;5 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999999)!(X<-9999999)!(X?.E1"."1N.N) X
HELP-PROMPT: Enter the beginning monthly quantity due-out in unit per issue (from -9999999 to 9999999)
DESCRIPTION:
This field stores the beginning monthly quantity due-out balance in the unit per issue.
445.111,5 AVERAGE UNIT COST 0;6 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999999.999)!(X<0)!(X?.E1"."4N.N) X
LAST EDITED: JUL 23, 1992
HELP-PROMPT: Enter the beginning monthly average unit cost for the item (from 0 to 9999999.999, 3 decimal
digits).
DESCRIPTION:
This field stores the beginning monthly average unit cost of the item in the unit per issue.
445.111,6 LAST RECEIPT UNIT COST 0;7 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999999.999)!(X<0)!(X?.E1"."4N.N) X
HELP-PROMPT: Enter the beginning monthly last receipt unit cost for the item (from 0 to 9999999.999, 3
decimal digits).
DESCRIPTION:
This field stores the beginning monthly last receipt cost of the item in the unit per issue.
445.111,7 TOTAL INVENTORY VALUE 0;8 NUMBER
INPUT TRANSFORM: S:X["$" X=$P(X,"$",2) K:X'?."-".N.1".".2N!(X>9999999.99)!(X<-9999999.99) X
LAST EDITED: JUL 23, 1992
HELP-PROMPT: Enter the total inventory value of this item at the beginning of the month (from -9999999.99 to
9999999.99, 2 decimal digits).
DESCRIPTION: This field stores the beginning monthly balance for the total value of the item in the unit per
issue.
FILES POINTED TO FIELDS
GENERIC INVENTORY (#445) INVENTORY POINT (#.01)
ITEM MASTER (#441) INVENTORY ITEM:INVENTORY ITEM (#.01)
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):