[628] | 1 | PRCHLO1 ;WOIFO/RLL-EXTRACT ROUTINE (cont.)CLO REPORT SERVER ; 12/19/05 10:56am
|
---|
| 2 | V ;;5.1;IFCAP;**83**;; Oct 20, 2000
|
---|
| 3 | ;Per VHA Directive 10-93-142, this routine should not be modified.
|
---|
| 4 | ; Continuation of PRCHLO1. This program builds the extracts for
|
---|
| 5 | ; the Master PO Table and the associated multiples
|
---|
| 6 | POMAST ; PoMaster Table
|
---|
| 7 | Q
|
---|
| 8 | PODISCW ; Write PO Discount table data
|
---|
| 9 | N GPOID,GPOND
|
---|
| 10 | S GPOID=0,GPOND=""
|
---|
| 11 | F S GPOID=$O(^TMP($J,"PODISC",GPOID)) Q:GPOID="" D
|
---|
| 12 | . F S GPOND=$O(^TMP($J,"PODISC",GPOID,GPOND)) Q:GPOND="" D
|
---|
| 13 | . . W $G(^TMP($J,"PODISC",GPOID,GPOND))
|
---|
| 14 | . . W !
|
---|
| 15 | . . Q
|
---|
| 16 | . Q
|
---|
| 17 | Q
|
---|
| 18 | GPOMAST ; get PO Master record
|
---|
| 19 | S U="^"
|
---|
| 20 | N N0,N1,N7,N12,N16,N23,PONUMB,STNUMB,PODAT,PPOKEY
|
---|
| 21 | N PAPAB,PAPAB1,AGAPO,AGAPO1,PCHDR,PCHDR1,PCUSR,PCUSR1
|
---|
| 22 | N VL6,VL7,VL8,VL9,VL10,VL11,VL12,VL13,VL14,VL15,VL16,VL17,VL18
|
---|
| 23 | N VL19,VL20,VL21,VL22,VL23,VL24,VL25,VL26,VL27,VL28,VL29,VL30,VL31
|
---|
| 24 | N VL32,VL33,VL34,VL35,VL36,VL37,VL38,VL39,VL40,VL41
|
---|
| 25 | N GN0,GN0A,GN0B,GN1,GN1A,GN2,VN,VN1,VN2
|
---|
| 26 | N VL6E,VL6E1,VL6E2,VL7E,VL7E1,VL7E2,VL8E,VL8E1,VL8E2,VL10E,VL10E1
|
---|
| 27 | N VL10E2,VL21E,VL21E1,VL21E2,VL25E,VL25E1,VL25E2,VL35E,VL35E1,VL35E2
|
---|
| 28 | N VL16E,VL16E1,VL16E2,VL18E,VL18E1,VL18E2,VL33E,VL33E1,VL33E2
|
---|
| 29 | N VL34E,VL34E1,VL34E2,PC2237V,PC2237V1,EXDT,EXDT1,EXDT2
|
---|
| 30 | S N0=$G(^PRC(442,POID,0))
|
---|
| 31 | S N1=$G(^PRC(442,POID,1))
|
---|
| 32 | S N7=$G(^PRC(442,POID,7))
|
---|
| 33 | S N12=$G(^PRC(442,POID,12))
|
---|
| 34 | S N16=$G(^PRC(442,POID,16))
|
---|
| 35 | S N23=$G(^PRC(442,POID,23))
|
---|
| 36 | S PONUMB=$P(N0,U,1),STNUMB=$P(PONUMB,"-",1)
|
---|
| 37 | S EXDT=$P(N1,U,15)
|
---|
| 38 | I EXDT="" S EXDT=POCRDAT ; if PO Date "" use x-ref date value for PO
|
---|
| 39 | S EXDT1=$P(EXDT,".",1)
|
---|
| 40 | S EXDT2=$$FMTE^XLFDT(EXDT1)
|
---|
| 41 | S PODAT=EXDT2 ; needed for key
|
---|
| 42 | S PPOKEY=POID_U_PONUMB_U_PODAT_U_MNTHYR_U_STNUMB
|
---|
| 43 | ;
|
---|
| 44 | ; The 1st 5 values in PPOKEY above are included in each record
|
---|
| 45 | ;
|
---|
| 46 | S VL6E=$P(N0,U,12),VL6E1=$G(^PRCS(410,+VL6E,0)),VL6E2=$P(VL6E1,U,1)
|
---|
| 47 | S VL6=VL6E2 ; Prim2237
|
---|
| 48 | S VL7E=$P(N0,U,2),VL7E1=$G(^PRCD(442.5,+VL7E,0)),VL7E2=$P(VL7E1,U,1)
|
---|
| 49 | S VL7=VL7E2 ; meth.of proc
|
---|
| 50 | S VL8E=$P(N1,U,19),VL8E1=$G(^PRC(443.8,+VL8E,0)),VL8E2=$P(VL8E1,U,2)
|
---|
| 51 | S VL8=VL8E2 ; locProcRsnCode
|
---|
| 52 | S VL9=$P(N1,U,18) ; exp/non-exp
|
---|
| 53 | S VL10E=$P(N7,U,1),VL10E1=$G(^PRCD(442.3,+VL10E,0))
|
---|
| 54 | S VL10E2=$P(VL10E1,U,1)
|
---|
| 55 | S VL10=VL10E2 ; Supply status
|
---|
| 56 | S VL11=$P(N7,U,2) ; Sup Stat Order
|
---|
| 57 | S VL12=$P(N7,U,4) ;Fis Stat Order
|
---|
| 58 | S VL13=$P(N0,U,3) ;FCP
|
---|
| 59 | S VL14=$P(N0,U,4) ;Appropriation
|
---|
| 60 | S VL15=$P(N0,U,5) ;CostCenter
|
---|
| 61 | S VL16E=$P(N0,U,6),VL16E1=$G(^PRCD(420.2,+VL16E,0))
|
---|
| 62 | S VL16E2=$P(VL16E1,U,1)
|
---|
| 63 | S VL16=VL16E2 ;SubAcct1
|
---|
| 64 | S VL17=$P(N0,U,7) ;SubAmt1
|
---|
| 65 | S VL18E=$P(N0,U,8),VL18E1=$G(^PRCD(420.2,+VL18E,0))
|
---|
| 66 | S VL18E2=$P(VL18E1,U,1)
|
---|
| 67 | S VL18=VL18E2 ;SubAcct2
|
---|
| 68 | S VL19=$P(N0,U,9) ;SubAmt2
|
---|
| 69 | ; set Node 0 of ^TMP
|
---|
| 70 | S GN0=PPOKEY_U_VL6_U_VL7_U_VL8_U_VL9_U_VL10_U
|
---|
| 71 | S GN0A=GN0_VL11_U_VL12_U_VL13_U_VL14_U_VL15_U
|
---|
| 72 | S GN0B=GN0A_VL16_U_VL17_U_VL18_U_VL19_U
|
---|
| 73 | S ^TMP($J,"POMAST",POID,0)=GN0B ; build and set node 0
|
---|
| 74 | ; begin Node 1
|
---|
| 75 | ; look up Vendor
|
---|
| 76 | S VN=$P(N1,U,1),VN1=$G(^PRC(440,+VN,0)),VN2=$P(VN1,U,1)
|
---|
| 77 | S VL20=VN2
|
---|
| 78 | ; S VL20=$P(N1,U,1) ; Vendor
|
---|
| 79 | S VL21E=$P(N1,U,2),VL21E1=$G(^DIC(49,+VL21E,0))
|
---|
| 80 | S VL21E2=$P(VL21E1,U,1)
|
---|
| 81 | S VL21=VL21E2 ; Req. Service
|
---|
| 82 | S VL22=$P(N1,U,6) ; Fob Point
|
---|
| 83 | ; get ext. date
|
---|
| 84 | S EXDT=$P(N0,U,20),EXDT1=$P(EXDT,".",1)
|
---|
| 85 | S EXDT2=$$FMTE^XLFDT(EXDT1)
|
---|
| 86 | S VL23=EXDT2 ; Org. Del. Date
|
---|
| 87 | S VL24=$P(N0,U,11) ; Est. Cost
|
---|
| 88 | S VL25E=$P(N1,U,7),VL25E1=$G(^PRCD(420.8,+VL25E,0))
|
---|
| 89 | S VL25E2=$P(VL25E1,U,2)
|
---|
| 90 | S VL25=VL25E2 ; Source Code
|
---|
| 91 | S VL26=$P(N0,U,13) ; Est Shipping
|
---|
| 92 | S VL27=$P(N0,U,18) ; Shp Ln Itm #
|
---|
| 93 | S VL28=$P(N0,U,14) ; Ln Itm Cnt
|
---|
| 94 | S PAPAB=$P(N1,U,10),PAPAB1=$G(^VA(200,+PAPAB,0))
|
---|
| 95 | S VL29=$P(PAPAB1,U,1) ; PaPpmAuthBuyer
|
---|
| 96 | S AGAPO=$P(N12,U,4),AGAPO1=$G(^VA(200,+AGAPO,0))
|
---|
| 97 | S VL30=$P(AGAPO1,U,1) ; Agt Assgnd PO
|
---|
| 98 | ; get external date
|
---|
| 99 | S EXDT=$P(N12,U,5),EXDT1=$P(EXDT,".",1)
|
---|
| 100 | S EXDT2=$$FMTE^XLFDT(EXDT1)
|
---|
| 101 | S VL31=EXDT2 ; DatePoAssigned
|
---|
| 102 | S VL32=$P(N16,U,0) ;remarks
|
---|
| 103 | S VL33E=$P(N23,U,3),VL33E1=$G(^PRC(442,+VL33E,0))
|
---|
| 104 | S VL33E2=$P(VL33E1,U,1)
|
---|
| 105 | S VL33=VL33E2 ; OldPoRec
|
---|
| 106 | S VL34E=$P(N23,U,4),VL34E1=$G(^PRC(442,+VL34E,0))
|
---|
| 107 | S VL34E2=$P(VL34E1,U,1)
|
---|
| 108 | S VL34=$P(N23,U,4) ; New PoRec
|
---|
| 109 | S GN1=VL20_U_VL21_U_VL22_U_VL23_U_VL24_U_VL25_U_VL26_U_VL27_U
|
---|
| 110 | S GN1A=GN1_VL28_U_VL29_U_VL30_U_VL31_U_VL32_U_VL33_U_VL34_U
|
---|
| 111 | S ^TMP($J,"POMAST",POID,1)=GN1A
|
---|
| 112 | ;
|
---|
| 113 | ; build node 2
|
---|
| 114 | S VL35E=$P(N23,U,14),VL35E1=$G(^PRC(440,+VL35E,0))
|
---|
| 115 | S VL35E2=$P(VL35E1,U,1)
|
---|
| 116 | S VL35=VL35E2 ; PcDo Vendor
|
---|
| 117 | S PCUSR=$P(N23,U,17),PCUSR1=$G(^VA(200,+PCUSR,0))
|
---|
| 118 | S VL36=$P(PCUSR1,U,1) ; Pur Crd User
|
---|
| 119 | S VL37=$P(N23,U,21) ; Pur Cost
|
---|
| 120 | S PCHDR=$P(N23,U,22),PCHDR1=$G(^VA(200,+PCHDR,0))
|
---|
| 121 | S VL38=$P(PCHDR1,U,1) ; Pur Card Hldr
|
---|
| 122 | ; get ext. value for 2237
|
---|
| 123 | S PC2237V=$P(N23,U,23),PC2237V1=$G(^PRCS(410,+PC2237V,0))
|
---|
| 124 | S VL39=$P(PC2237V1,U,1) ; Pcdo2237
|
---|
| 125 | S VL40=$P(N0,U,15) ; Total Amount
|
---|
| 126 | S VL41=$P(N0,U,16) ; Net amount
|
---|
| 127 | ;
|
---|
| 128 | S GN2=VL35_U_VL36_U_VL37_U_VL38_U_VL39_U_VL40_U_VL41
|
---|
| 129 | S ^TMP($J,"POMAST",POID,2)=GN2
|
---|
| 130 | ;
|
---|
| 131 | D PODISC^PRCHLO1A
|
---|
| 132 | D POBOC^PRCHLO1A
|
---|
| 133 | D POCMTS^PRCHLO1A
|
---|
| 134 | D PORMKS^PRCHLO1A
|
---|
| 135 | D PO2237^PRCHLO1A
|
---|
| 136 | D POAMT^PRCHLO1A
|
---|
| 137 | D POAMMD^PRCHLO1A
|
---|
| 138 | D POPPTER^PRCHLO2A
|
---|
| 139 | D POPART^PRCHLO2A
|
---|
| 140 | D POOBL^PRCHLO2A
|
---|
| 141 | D POPMET^PRCHLO2A
|
---|
| 142 | D GPOITEM^PRCHLO2
|
---|
| 143 | Q
|
---|
| 144 | PODISCH ; PO Discount Header File
|
---|
| 145 | ; Header file for PO Discount Multiple
|
---|
| 146 | W "PoIdNum^PurchaseOrderNum^PoDate^MonthYrRun^StationNum^"
|
---|
| 147 | W "DiscountIdNum^DiscountItem^PercentDollarAmount^"
|
---|
| 148 | W "DiscountAmount^ItemCount^Contract^LineItem",!
|
---|
| 149 | Q
|
---|