| SORT FIELD DATA |
-
- FILE OR SUBFILE NO.: 442
- GET CODE: S DISX(1)=$P($G(^PRC(442,D0,0)),U,3)
- QUERY CONDITION: I (DISX(1)]]"0 AA@z")&(DISX(1)']]"99999 ZZZ ZZZ")
- DESCRIPTION OF SORT: FCP from 0 AAA to 99999 ZZZ ZZZ
- SEARCH EFFICIENCY RATING: 0.1287
- PROBABILITY RATING: 0.1287
- DATA TYPE FOR SORTING: FREE TEXT
- FIELD NO.: 1
- FIELD NAME: FCP
- SORT QUALIFIERS BEFORE FIELD: @#
- FROM VALUE INTERNAL: 0 AA@z
- FROM VALUE EXTERNAL: 0 AAA
- TO VALUE INTERNAL: 99999 ZZZ ZZZ
- TO VALUE EXTERNAL: 99999 ZZZ ZZZ
-
- FILE OR SUBFILE NO.: 442
- GET CODE: S Y(1)=$S($D(^PRC(442,D0,0)):^(0),1:"") S X=$P(Y(1),U,1),Y(2)=X S X="-",Y(3)=X S X=1,X=$P(Y(2),Y(3),X) I D0>0 S DISX(2)=X
- QUERY CONDITION: I DISX(2)=688
- DESCRIPTION OF SORT: $P(PURCHASE ORDER NUMBER,""-"",1) equals 688
- 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,1),Y(2)=X S X="-",Y(3)=X S X=1,X=$P(Y(2),Y(3),X) I D0>0 S DISX(2)=X
- FIELD NAME: $P(PURCHASE ORDER NUMBER,"-",1)
- SORT QUALIFIERS BEFORE FIELD: @"
- SORT QUALIFIERS AFTER FIELD: ;"STN"
- FROM VALUE INTERNAL: 687.99999
- FROM VALUE EXTERNAL: 688
- TO VALUE INTERNAL: 688
- TO VALUE EXTERNAL: 688
-
- FILE OR SUBFILE NO.: 442.01
- GET CODE: S Y(1)=$S($D(^PRC(442,D0,2,D1,0)):^(0),1:"") S X=$S('$D(^PRC(441,+$P(Y(1),U,5),0)):"",1:$P(^(0),U,1)) I D1>0 S DISX(3)=X
- QUERY CONDITION: I DISX(3)=1
- DESCRIPTION OF SORT: ITEM MASTER FILE NO. equals 1
- DATA TYPE FOR SORTING: NUMERIC
- COMPUTED FIELD CODE: S Y(1)=$S($D(^PRC(442,D0,2,D1,0)):^(0),1:"") S X=$S('$D(^PRC(441,+$P(Y(1),U,5),0)):"",1:$P(^(0),U,1)) I D1>0 S DISX(3)=X
- MULTIPLE FIELD DATA:
-
-
- MULT.FILE OR SUBFILE NO.: 442
- NODE: 2
- FIELD NAME: ITEM MASTER FILE NO.
- SORT QUALIFIERS BEFORE FIELD: @"1.5
- FROM VALUE INTERNAL: .99999
- FROM VALUE EXTERNAL: 1
- TO VALUE INTERNAL: 1
- TO VALUE EXTERNAL: 1
-
- FILE OR SUBFILE NO.: 442
- GET CODE: S DISX(4)=$P($G(^PRC(442,D0,1)),U,15)
- QUERY CONDITION: I (DISX(4)]]2980100.99999)&(DISX(4)']]2980722)
- DESCRIPTION OF SORT: P.O. DATE from Jan 1,1998 to Jul 22,1998
- SEARCH EFFICIENCY RATING: 0.5149
- PROBABILITY RATING: 0.5149
- DATA TYPE FOR SORTING: DATE/TIME
- FIELD NO.: .1
- FIELD NAME: P.O. DATE
- SORT QUALIFIERS BEFORE FIELD: -
- FROM VALUE INTERNAL: 2980100.99999
- FROM VALUE EXTERNAL: 2980101
- FROM VALUE PRINTABLE: Jan 1,1998
- TO VALUE INTERNAL: 2980722
- TO VALUE EXTERNAL: 2980722
- TO VALUE PRINTABLE: Jul 22,1998
|
