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
|