SORT FIELD DATA |
-
- FILE OR SUBFILE NO.: 470.1
- GET CODE: S DISX(1)=$P($G(^PRPF(470.1,D0,0)),U,6)
- QUERY CONDITION: I (DISX(1)]]2970100.99999)&(DISX(1)']]2970218)
- DESCRIPTION OF SORT: DATE TRANSACTION ENTERED from 1/1/97 to 2/18/97
- SEARCH EFFICIENCY RATING: 100.0000
- PROBABILITY RATING: 1.0000
- DATA TYPE FOR SORTING: DATE/TIME
- FIELD NO.: 5
- FIELD NAME: DATE TRANSACTION ENTERED
- SORT QUALIFIERS BEFORE FIELD: +
- SORT QUALIFIERS AFTER FIELD: ;S2
- FROM VALUE INTERNAL: 2970100.99999
- FROM VALUE EXTERNAL: 2970101
- FROM VALUE PRINTABLE: 1/1/97
- TO VALUE INTERNAL: 2970218
- TO VALUE EXTERNAL: 2970218
- TO VALUE PRINTABLE: 2/18/97
- CROSS REFERENCE DATA: ^PRPF(470.1,"AC",^PRPF(470.1,^2
-
- FILE OR SUBFILE NO.: 470.1
- GET CODE: S DISX(2)=$P($G(^PRPF(470.1,D0,0)),U,8)
- QUERY CONDITION: I DISX(2)'=""
- DESCRIPTION OF SORT: DEPOSIT/WITHDRAWAL not null
- SEARCH EFFICIENCY RATING: 0.0000
- PROBABILITY RATING: 0.0000
- DATA TYPE FOR SORTING: SET OF CODES
- FIELD NO.: 7
- FIELD NAME: DEPOSIT/WITHDRAWAL
- SORT QUALIFIERS BEFORE FIELD: +
- SORT QUALIFIERS AFTER FIELD: ;S
-
- FILE OR SUBFILE NO.: 470.1
- GET CODE: S DISX(3)=$P($G(^PRPF(470.1,D0,0)),U,9)
- QUERY CONDITION: I DISX(3)'=""
- DESCRIPTION OF SORT: CASH/CHECK/OTHER not null
- SEARCH EFFICIENCY RATING: 0.0000
- PROBABILITY RATING: 0.0000
- DATA TYPE FOR SORTING: SET OF CODES
- FIELD NO.: 8
- FIELD NAME: CASH/CHECK/OTHER
- SORT QUALIFIERS BEFORE FIELD: +
- SORT QUALIFIERS AFTER FIELD: ;S
-
- FILE OR SUBFILE NO.: 470.1
- GET CODE: S Y(1)=$S($D(^PRPF(470.1,D0,0)):^(0),1:"") S X=$S('$D(^PRPF(470.2,+$P(Y(1),U,11),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(4)=X
- QUERY CONDITION: I DISX(4)'=""
- DESCRIPTION OF SORT: FORM not null
- DATA TYPE FOR SORTING: FREE TEXT
- COMPUTED FIELD CODE: S Y(1)=$S($D(^PRPF(470.1,D0,0)):^(0),1:"") S X=$S('$D(^PRPF(470.2,+$P(Y(1),U,11),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(4)=X
- FIELD NAME: FORM
- SORT QUALIFIERS BEFORE FIELD: +"10
- SORT QUALIFIERS AFTER FIELD: ;S
-
- FILE OR SUBFILE NO.: 470.1
- GET CODE: S DISX(5)=$P($G(^PRPF(470.1,D0,0)),U,7)
- QUERY CONDITION: I DISX(5)'=""
- DESCRIPTION OF SORT: REFERENCE not null
- SEARCH EFFICIENCY RATING: 0.0000
- PROBABILITY RATING: 0.0000
- DATA TYPE FOR SORTING: FREE TEXT
- FIELD NO.: 6
- FIELD NAME: REFERENCE
- SORT QUALIFIERS BEFORE FIELD: @
|