PRCHOUT RR NOT PROC.BY FISCAL (166)    SORT TEMPLATE (.401)

Name Value
NAME PRCHOUT RR NOT PROC.BY FISCAL
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   442
    GET CODE:   S DISX(1)=$P($G(^PRC(442,D0,1)),U,15)
    QUERY CONDITION:   I DISX(1)]]2950316.99999
    DESCRIPTION OF SORT:   P.O. DATE from 3/17/95
    SEARCH EFFICIENCY RATING:   49.5000
    PROBABILITY RATING:   0.9802
    DATA TYPE FOR SORTING:   DATE/TIME
    FIELD NO.:   .1
    FIELD NAME:   P.O. DATE
    SORT QUALIFIERS BEFORE FIELD:   @
    FROM VALUE INTERNAL:   2950316.99999
    FROM VALUE EXTERNAL:   T-5
    FROM VALUE PRINTABLE:   3/17/95
    TO VALUE INTERNAL:   z
    CROSS REFERENCE DATA:   ^PRC(442,"AB",^PRC(442,^2
  • FILE OR SUBFILE NO.:   442
    GET CODE:   S DISX(2)=$P($G(^PRC(442,D0,7)),U,2)
    QUERY CONDITION:   I (DISX(2)]]24.99999)&(DISX(2)']]33)
    DESCRIPTION OF SORT:   SUPPLY STATUS ORDER from 25 to 33
    SEARCH EFFICIENCY RATING:   7.4167
    PROBABILITY RATING:   0.8812
    DATA TYPE FOR SORTING:   NUMERIC
    FIELD NO.:   .7
    FIELD NAME:   SUPPLY STATUS ORDER
    SORT QUALIFIERS BEFORE FIELD:   @'
    FROM VALUE INTERNAL:   24.99999
    FROM VALUE EXTERNAL:   25
    TO VALUE INTERNAL:   33
    TO VALUE EXTERNAL:   33
    CROSS REFERENCE DATA:   ^PRC(442,"AH",^PRC(442,^2
  • FILE OR SUBFILE NO.:   442
    GET CODE:   S Y(1)=$S($D(^PRC(442,D0,7)):^(7),1:"") S X=$P(Y(1),U,2)'=27 I D0>0 S DISX(3)=X
    QUERY CONDITION:   I DISX(3)
    DESCRIPTION OF SORT:   SUPPLY STATUS ORDER'=27
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^PRC(442,D0,7)):^(7),1:"") S X=$P(Y(1),U,2)'=27 I D0>0 S DISX(3)=X
    FIELD NAME:   SUPPLY STATUS ORDER'=27
    SORT QUALIFIERS BEFORE FIELD:   @'"@B
    SORT QUALIFIERS AFTER FIELD:   ;L1;L1
  • FILE OR SUBFILE NO.:   442.11
    GET CODE:   S DISX(4)=$P($G(^PRC(442,D0,11,D1,0)),U,6)
    QUERY CONDITION:   I DISX(4)=""
    DESCRIPTION OF SORT:   PROCESSED BY FISCAL? is null
    DATA TYPE FOR SORTING:   SET OF CODES
    MULTIPLE FIELD DATA:
    • MULT.FILE OR SUBFILE NO.:   442
      NODE:   11
    FIELD NO.:   5
    FIELD NAME:   PROCESSED BY FISCAL?
    SORT QUALIFIERS BEFORE FIELD:   '@'@
    FROM VALUE INTERNAL:   ?z
    FROM VALUE EXTERNAL:   @
    TO VALUE INTERNAL:   @
    TO VALUE EXTERNAL:   @
  • FILE OR SUBFILE NO.:   442
    GET CODE:   S DISX(5)=$P($G(^PRC(442,D0,0)),U,1)
    QUERY CONDITION:   I DISX(5)'=""
    DESCRIPTION OF SORT:   PURCHASE ORDER NUMBER not null
    SEARCH EFFICIENCY RATING:   0.0202
    PROBABILITY RATING:   0.0198
    DATA TYPE FOR SORTING:   FREE TEXT
    FIELD NO.:   .01
    FIELD NAME:   PURCHASE ORDER NUMBER
    CROSS REFERENCE DATA:   ^PRC(442,"B",^PRC(442,^2
DATE CREATED 1991-12-12 10:05:00
FILE PROCUREMENT & ACCOUNTING TRANSACTIONS