PRCH IMP POREG (181)    SORT TEMPLATE (.401)

Name Value
NAME PRCH IMP POREG
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)]]2971000.99999)&(DISX(1)']]2980101)
    DESCRIPTION OF SORT:   P.O. DATE from Oct 1,1997 to Jan 1,1998
    SEARCH EFFICIENCY RATING:   5.7333
    PROBABILITY RATING:   0.8515
    DATA TYPE FOR SORTING:   DATE/TIME
    FIELD NO.:   .1
    FIELD NAME:   P.O. DATE
    SORT QUALIFIERS BEFORE FIELD:   '
    FROM VALUE INTERNAL:   2971000.99999
    FROM VALUE EXTERNAL:   10/1/97
    FROM VALUE PRINTABLE:   Oct 1,1997
    TO VALUE INTERNAL:   2980101
    TO VALUE EXTERNAL:   1/1/98
    TO VALUE PRINTABLE:   Jan 1,1998
    CROSS REFERENCE DATA:   ^PRC(442,"AB",^PRC(442,^2
  • FILE OR SUBFILE NO.:   442
    GET CODE:   S Y(1)=$S($D(^PRC(442,D0,0)):^(0),1:"") S X=$P(Y(1),U,2),X=X I D0>0 S DISX(2)=X
    QUERY CONDITION:   I (DISX(2)]]6.99999)&(DISX(2)']]7)
    DESCRIPTION OF SORT:   INTERNAL(#.02)
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^PRC(442,D0,0)):^(0),1:"") S X=$P(Y(1),U,2),X=X I D0>0 S DISX(2)=X
    FIELD NAME:   INTERNAL(#.02)
    SORT QUALIFIERS BEFORE FIELD:   '@"
  • FILE OR SUBFILE NO.:   442
    GET CODE:   S DISX(3)=$P($G(^PRC(442,D0,0)),U,1)
    QUERY CONDITION:   I DISX(3)]]"'NULKz"
    DESCRIPTION OF SORT:   PURCHASE ORDER NUMBER from 'NULL
    SEARCH EFFICIENCY RATING:   0.0306
    PROBABILITY RATING:   0.0297
    DATA TYPE FOR SORTING:   FREE TEXT
    FIELD NO.:   .01
    FIELD NAME:   PURCHASE ORDER NUMBER
    FROM VALUE INTERNAL:   'NULKz
    FROM VALUE EXTERNAL:   'NULL
    TO VALUE INTERNAL:   z
    CROSS REFERENCE DATA:   ^PRC(442,"B",^PRC(442,^2
DATE CREATED 1989-08-16 12:03:00
FILE PROCUREMENT & ACCOUNTING TRANSACTIONS
DATE LAST USED 1998-09-02 00:00:00