PRCH DEL. RECSORT (694)    SORT TEMPLATE (.401)

Name Value
NAME PRCH DEL. RECSORT
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   440.6
    GET CODE:   S Y(1)=$S($D(^PRCH(440.6,D0,0)):^(0),1:"") S X=$S('$D(^VA(200,+$P(Y(1),U,17),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
    QUERY CONDITION:   I (DISX(1)]]"@z")&(DISX(1)']]"Z")
    DESCRIPTION OF SORT:   CARD HOLDER from A to Z
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^PRCH(440.6,D0,0)):^(0),1:"") S X=$S('$D(^VA(200,+$P(Y(1),U,17),0)):"",1:$P(^(0),U,1)) I D0>0 S DISX(1)=X
    FIELD NAME:   CARD HOLDER
    SORT QUALIFIERS BEFORE FIELD:   @"16
    FROM VALUE INTERNAL:   @z
    FROM VALUE EXTERNAL:   A
    TO VALUE INTERNAL:   Z
    TO VALUE EXTERNAL:   Z
  • FILE OR SUBFILE NO.:   440.6
    GET CODE:   S DISX(2)=$P($G(^PRCH(440.6,D0,0)),U,7)
    QUERY CONDITION:   I (DISX(2)]]2900100.999999)&(DISX(2)']]3000915)
    DESCRIPTION OF SORT:   TRANSACTION DATE from Jan 1,1990 to Sep 15,2000
    SEARCH EFFICIENCY RATING:   0.0000
    PROBABILITY RATING:   0.0000
    DATA TYPE FOR SORTING:   DATE/TIME
    FIELD NO.:   6
    FIELD NAME:   TRANSACTION DATE
    SORT QUALIFIERS BEFORE FIELD:   @
    FROM VALUE INTERNAL:   2900100.999999
    FROM VALUE EXTERNAL:   1.1.90
    FROM VALUE PRINTABLE:   Jan 1,1990
    TO VALUE INTERNAL:   3000915
    TO VALUE EXTERNAL:   T
    TO VALUE PRINTABLE:   Sep 15,2000
  • FILE OR SUBFILE NO.:   440.6
    GET CODE:   S Y(1)=$S($D(^PRCH(440.6,D0,1)):^(1),1:"") S X=$P(Y(1),U,6),Y(2)=X S X=$P(Y(1),U,7),X1=X,X2=+1,X="" D C^%DTC:X1 S X=X,X1=Y(2) D ^XUWORKDY S X=X>5 I D0>0 S DISX(3)=X
    QUERY CONDITION:   I DISX(3)
    DESCRIPTION OF SORT:   XUWORKDAY(#46,#47+1)>5
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^PRCH(440.6,D0,1)):^(1),1:"") S X=$P(Y(1),U,6),Y(2)=X S X=$P(Y(1),U,7),X1=X,X2=+1,X="" D C^%DTC:X1 S X=X,X1=Y(2) D ^XUWORKDY S X=X>5 I D0>0 S DISX(3)=X
    FIELD NAME:   XUWORKDAY(#46,#47+1)>5
    SORT QUALIFIERS BEFORE FIELD:   @"@B
    SORT QUALIFIERS AFTER FIELD:   ;L1
  • FILE OR SUBFILE NO.:   440.6
    GET CODE:   S DISX(4)=$P($G(^PRCH(440.6,D0,0)),U,8)
    QUERY CONDITION:   I DISX(4)'=""
    DESCRIPTION OF SORT:   STATION NUMBER not null
    SEARCH EFFICIENCY RATING:   0.0000
    PROBABILITY RATING:   0.0000
    DATA TYPE FOR SORTING:   FREE TEXT
    FIELD NO.:   7
    FIELD NAME:   STATION NUMBER
    SORT QUALIFIERS BEFORE FIELD:   @
DATE CREATED 1999-08-03 16:57:00
FILE PURCHASE CARD ORDER RECONCILE
DATE LAST USED 2000-09-15 00:00:00