PRCHOUT PA STATS DAILY (623)    SORT TEMPLATE (.401)

Name Value
NAME PRCHOUT PA STATS DAILY
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   442
    GET CODE:   S Y(1)=$S($D(^PRC(442,D0,1)):^(1),1:"") S X=$S('$D(^VA(200,+$P(Y(1),U,10),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
    QUERY CONDITION:   I (DISX(1)]]"@z")&(DISX(1)']]"CZ")
    DESCRIPTION OF SORT:   PA/PPM/AUTHORIZED BUYER from A to CZ
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^PRC(442,D0,1)):^(1),1:"") S X=$S('$D(^VA(200,+$P(Y(1),U,10),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
    FIELD NAME:   PA/PPM/AUTHORIZED BUYER
    SORT QUALIFIERS BEFORE FIELD:   +"16
    SORT QUALIFIERS AFTER FIELD:   ;S2
    FROM VALUE INTERNAL:   @z
    FROM VALUE EXTERNAL:   A
    TO VALUE INTERNAL:   CZ
    TO VALUE EXTERNAL:   CZ
  • FILE OR SUBFILE NO.:   442
    GET CODE:   S DISX(2)=$P($G(^PRC(442,D0,1)),U,15)
    QUERY CONDITION:   I (DISX(2)]]2970600.99999)&(DISX(2)']]2970801)
    DESCRIPTION OF SORT:   P.O. DATE from 6/1/97 to 8/1/97
    SEARCH EFFICIENCY RATING:   2.3667
    PROBABILITY RATING:   0.7030
    DATA TYPE FOR SORTING:   DATE/TIME
    FIELD NO.:   .1
    FIELD NAME:   P.O. DATE
    SORT QUALIFIERS BEFORE FIELD:   @
    FROM VALUE INTERNAL:   2970600.99999
    FROM VALUE EXTERNAL:   0601
    FROM VALUE PRINTABLE:   6/1/97
    TO VALUE INTERNAL:   2970801
    TO VALUE EXTERNAL:   0801
    TO VALUE PRINTABLE:   8/1/97
    CROSS REFERENCE DATA:   ^PRC(442,"AB",^PRC(442,^2
DATE CREATED 1997-05-21 08:03:00
READ ACCESS @
FILE PROCUREMENT & ACCOUNTING TRANSACTIONS
WRITE ACCESS @
DATE LAST USED 1997-09-08 00:00:00