PRCH FPDS <25K (154)    SORT TEMPLATE (.401)

Name Value
NAME PRCH FPDS <25K
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)]]2941219.99999)&(DISX(1)']]2950330)
    DESCRIPTION OF SORT:   P.O. DATE from 12/20/94 to 3/30/95
    SEARCH EFFICIENCY RATING:   3.2083
    PROBABILITY RATING:   0.7624
    DATA TYPE FOR SORTING:   DATE/TIME
    FIELD NO.:   .1
    FIELD NAME:   P.O. DATE
    SORT QUALIFIERS BEFORE FIELD:   '@
    FROM VALUE INTERNAL:   2941219.99999
    FROM VALUE EXTERNAL:   2941220
    FROM VALUE PRINTABLE:   12/20/94
    TO VALUE INTERNAL:   2950330
    TO VALUE EXTERNAL:   2950330
    TO VALUE PRINTABLE:   3/30/95
    CROSS REFERENCE DATA:   ^PRC(442,"AB",^PRC(442,^2
  • FILE OR SUBFILE NO.:   442
    GET CODE:   S DISX(2)=$P($G(^PRC(442,D0,0)),U,1)
    QUERY CONDITION:   I (DISX(2)]]"688,z")&(DISX(2)']]"688z")
    DESCRIPTION OF SORT:   PURCHASE ORDER NUMBER from 688- to 688z
    SEARCH EFFICIENCY RATING:   0.0202
    PROBABILITY RATING:   0.0198
    DATA TYPE FOR SORTING:   FREE TEXT
    FIELD NO.:   .01
    FIELD NAME:   PURCHASE ORDER NUMBER
    SORT QUALIFIERS BEFORE FIELD:   '@
    FROM VALUE INTERNAL:   688,z
    FROM VALUE EXTERNAL:   688-
    TO VALUE INTERNAL:   688z
    TO VALUE EXTERNAL:   688z
    CROSS REFERENCE DATA:   ^PRC(442,"B",^PRC(442,^2
  • FILE OR SUBFILE NO.:   442
    GET CODE:   X DPP(3,"OVF0",9.2) S X=$P(Y(101),U,2) S D0=I(0,0) I D0>0 S DISX(3)=X
    QUERY CONDITION:   I DISX(3)]]8.99999
    DESCRIPTION OF SORT:   .5:#.02 from 9
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   X DPP(3,"OVF0",9.2) S X=$P(Y(101),U,2) S D0=I(0,0) I D0>0 S DISX(3)=X
    OVERFLOW DATA:
    • FIRST SUBSCRIPT FOR OVERFLOW:   OVF0
      SECOND SUBSCRIPT FOR OVERFLOW:   9.2
      OVERFLOW CODE:   S I(0,0)=$S($D(D0):D0,1:""),Y(1)=$S($D(^PRC(442,D0,7)):^(7),1:""),D0=$P(Y(1),U,1) S:'$D(^PRCD(442.3,+D0,0)) D0=-1 S Y(101)=$S($D(^PRCD(442.3,D0,0)):^(0),1:"")
    FIELD NAME:   .5:#.02
    SORT QUALIFIERS BEFORE FIELD:   '@#"
    FROM VALUE INTERNAL:   8.99999
    FROM VALUE EXTERNAL:   9
    TO VALUE INTERNAL:   z
  • FILE OR SUBFILE NO.:   442
    GET CODE:   S DISX(4)=$P($G(^PRC(442,D0,0)),U,15)
    QUERY CONDITION:   I (DISX(4)]]-1)&(DISX(4)']]25000)
    DESCRIPTION OF SORT:   TOTAL AMOUNT from 0 to 25000
    SEARCH EFFICIENCY RATING:   0.1485
    PROBABILITY RATING:   0.1485
    DATA TYPE FOR SORTING:   NUMERIC
    FIELD NO.:   91
    FIELD NAME:   TOTAL AMOUNT
    SORT QUALIFIERS BEFORE FIELD:   '@
    FROM VALUE INTERNAL:   -1
    FROM VALUE EXTERNAL:   0
    TO VALUE INTERNAL:   25000
    TO VALUE EXTERNAL:   25000
DATE CREATED 1988-12-08 00:00:00
FILE PROCUREMENT & ACCOUNTING TRANSACTIONS