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
|