| SORT FIELD DATA |
-
- FILE OR SUBFILE NO.: 6914
- GET CODE: S Y(1)=$S($D(^ENG(6914,D0,2)):^(2),1:"") S X=$S('$D(^ENG(6914.1,+$P(Y(1),U,9),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
- QUERY CONDITION: I DISX(1)=200
- DESCRIPTION OF SORT: CMR equals 200
- SEARCH EFFICIENCY RATING: 9.7143
- PROBABILITY RATING: 0.9067
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: S Y(1)=$S($D(^ENG(6914,D0,2)):^(2),1:"") S X=$S('$D(^ENG(6914.1,+$P(Y(1),U,9),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
- FIELD NAME: CMR
- SORT QUALIFIERS BEFORE FIELD: '"19
- FROM VALUE INTERNAL: 199.99999
- FROM VALUE EXTERNAL: 200
- TO VALUE INTERNAL: 200
- TO VALUE EXTERNAL: 200
- CROSS REFERENCE DATA: ^ENG(6914,"AD",^ENG(6914,^2
- POINT TO CROSS REFERENCE: ^ENG(6914.1,"B",
-
- FILE OR SUBFILE NO.: 6914
- GET CODE: S Y(1)=$S($D(^ENG(6914,D0,2)):^(2),1:"") S X=$S('$D(^ENCSN(6917,+$P(Y(1),U,8),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(2)=X
- QUERY CONDITION: I 1
- DESCRIPTION OF SORT: All CATEGORY STOCK NUMBER (includes nulls)
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: S Y(1)=$S($D(^ENG(6914,D0,2)):^(2),1:"") S X=$S('$D(^ENCSN(6917,+$P(Y(1),U,8),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(2)=X
- FIELD NAME: CATEGORY STOCK NUMBER
- SORT QUALIFIERS BEFORE FIELD: @"18
- FROM VALUE INTERNAL: ?z
- FROM VALUE EXTERNAL: @
- TO VALUE INTERNAL: z
-
- FILE OR SUBFILE NO.: 6914
- GET CODE: X DPP(3,"OVF0",9.3) S X=$S('$D(^ENG("SP",+$P(Y(1),U,5),0)):"",1:$P(^(0),U,1)),Y(8)=X S X="-",X=$P(Y(8),X) S Y=X,X=Y(7),X=X_Y I D0>0 S DISX(3)=X
- QUERY CONDITION: I 1
- DESCRIPTION OF SORT: All $P(LOCATION,""-"",3)_"":""_$P(LOCATION,""-"",2)_"":""_$P(LOCATION,""-"") (includes nulls)
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: X DPP(3,"OVF0",9.3) S X=$S('$D(^ENG("SP",+$P(Y(1),U,5),0)):"",1:$P(^(0),U,1)),Y(8)=X S X="-",X=$P(Y(8),X) S Y=X,X=Y(7),X=X_Y I D0>0 S DISX(3)=X
- OVERFLOW DATA:
-
-
- FIRST SUBSCRIPT FOR OVERFLOW: OVF0
- SECOND SUBSCRIPT FOR OVERFLOW: 9.2
- OVERFLOW CODE: S Y(1)=$S($D(^ENG(6914,D0,3)):^(3),1:"") S X=$S('$D(^ENG("SP",+$P(Y(1),U,5),0)):"",1:$P(^(0),U,1)),Y(2)=X S X="-",Y(3)=X S X=3,X=$P(Y(2),Y(3),X)_":",Y(4)=X
-
- FIRST SUBSCRIPT FOR OVERFLOW: OVF0
- SECOND SUBSCRIPT FOR OVERFLOW: 9.3
- OVERFLOW CODE: X DPP(3,"OVF0",9.2) S X=$S('$D(^ENG("SP",+$P(Y(1),U,5),0)):"",1:$P(^(0),U,1)),Y(5)=X S X="-",Y(6)=X S X=2,X=$P(Y(5),Y(6),X) S Y=X,X=Y(4),X=X_Y_":",Y(7)=X
- FIELD NAME: $P(LOCATION,"-",3)_":"_$P(LOCATION,"-",2)_":"_$P(LOCATION,"-")
- SORT QUALIFIERS BEFORE FIELD: @"
- FROM VALUE INTERNAL: ?z
- FROM VALUE EXTERNAL: @
- TO VALUE INTERNAL: z
|
