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)'=""
- DESCRIPTION OF SORT: P.O. DATE not null
- SEARCH EFFICIENCY RATING: 0.0978
- PROBABILITY RATING: 0.0891
- 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: 100197
- FROM VALUE PRINTABLE: 10/1/97
- TO VALUE INTERNAL: z
- 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 S X=X<5,Y(2)=X,Y(3)=X S X=$P(Y(1),U,2),X=X S X=X=25,Y=X,X=Y(2),X=X!Y I D0>0 S DISX(2)=X
- QUERY CONDITION: I DISX(2)
- DESCRIPTION OF SORT: INTERNAL(#.02)<5!(INTERNAL(#.02)=25)
- 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 S X=X<5,Y(2)=X,Y(3)=X S X=$P(Y(1),U,2),X=X S X=X=25,Y=X,X=Y(2),X=X!Y I D0>0 S DISX(2)=X
- FIELD NAME: INTERNAL(#.02)<5!(INTERNAL(#.02)=25)
- SORT QUALIFIERS BEFORE FIELD: '@"@B
- SORT QUALIFIERS AFTER FIELD: ;L1
-
- FILE OR SUBFILE NO.: 442
- GET CODE: S Y(1)=$S($D(^PRC(442,D0,0)):^(0),1:"") S X=$S('$D(^PRCD(442.5,+$P(Y(1),U,2),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(3)=X
- QUERY CONDITION: I DISX(3)'=""
- DESCRIPTION OF SORT: METHOD OF PROCESSING not null
- SEARCH EFFICIENCY RATING: 0.0412
- PROBABILITY RATING: 0.0396
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: S Y(1)=$S($D(^PRC(442,D0,0)):^(0),1:"") S X=$S('$D(^PRCD(442.5,+$P(Y(1),U,2),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(3)=X
- FIELD NAME: METHOD OF PROCESSING
- SORT QUALIFIERS BEFORE FIELD: ".02
- SORT QUALIFIERS AFTER FIELD: ;S2
- CROSS REFERENCE DATA: ^PRC(442,"F",^PRC(442,^2
- POINT TO CROSS REFERENCE: ^PRCD(442.5,"B",
-
- FILE OR SUBFILE NO.: 442
- GET CODE: S DISX(4)=$P($G(^PRC(442,D0,0)),U,1)
- QUERY CONDITION: I DISX(4)'=""
- DESCRIPTION OF SORT: PURCHASE ORDER NUMBER not null
- SEARCH EFFICIENCY RATING: 0
- PROBABILITY RATING: 0
- DATA TYPE FOR SORTING: FREE TEXT
- FIELD NO.: .01
- FIELD NAME: PURCHASE ORDER NUMBER
- FROM VALUE INTERNAL: P7000/z
- FROM VALUE EXTERNAL: P70000
- TO VALUE INTERNAL: z
- CROSS REFERENCE DATA: ^PRC(442,"B",^PRC(442,^2
|