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
|