PRCH PO REGISTER (143)    SORT TEMPLATE (.401)

Name Value
NAME PRCH PO REGISTER
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
DATE CREATED 1996-04-11 17:27:00
FILE PROCUREMENT & ACCOUNTING TRANSACTIONS
DATE LAST USED 1998-05-22 00:00:00