AP_WC_INC_CGRP(SQL View) |
Index Back |
|---|---|
AP Control Group Table |
| SELECT G.BUSINESS_UNIT , G.GRP_AP_ID , G.GRP_AP_STATUS , G.CTL_GROSS_AMT , G.CURRENCY_CD , G.CTL_VOUCHERS , G.ASSIGNED_TO_OPRID , G.DTTM_ASSIGNED , G.DTTM_DUE FROM PS_GRP_AP G WHERE G.GRP_AP_STATUS <> 'V' AND G.CURRENCY_CD <> ' ' UNION SELECT G.BUSINESS_UNIT , G.GRP_AP_ID , G.GRP_AP_STATUS , G.CTL_GROSS_AMT , A.CURRENCY_CD , G.CTL_VOUCHERS , G.ASSIGNED_TO_OPRID , G.DTTM_ASSIGNED , G.DTTM_DUE FROM PS_BUS_UNIT_OPT_AP A , PS_BUS_UNIT_TBL_AP B , PS_BUS_UNIT_INTFC C , PS_SET_CNTRL_REC D , PS_GRP_AP G WHERE B.BUSINESS_UNIT = G.BUSINESS_UNIT AND B.BUSINESS_UNIT_GL = C.BUSINESS_UNIT AND A.SETID = D.SETID AND D.REC_GROUP_ID = 'AP_01' AND D.RECNAME = 'BUS_UNIT_OPT_AP' AND D.SETCNTRLVALUE = G.BUSINESS_UNIT AND A.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_BUS_UNIT_OPT_AP E WHERE E.SETID = A.SETID AND E.EFFDT <= %CurrentDateIn AND E.EFF_STATUS = 'A') AND G.GRP_AP_STATUS <> 'V' AND G.CURRENCY_CD = ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AP_NONVW |
| 2 | GRP_AP_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Control Group ID
Default Value: NEXT Prompt Table: GRP_AP |
| 3 | GRP_AP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status of Control Group
A=Assigned E=Entry Set Aside O=Open R=Ready for Review S=Supervisor Set Aside V=Verified Default Value: O |
| 4 | GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Invoice Amount |
| 5 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 6 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 7 | ASSIGNED_TO_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Assigned to
Prompt Table: OPR_AP_VW |
| 8 | DTTM_ASSIGNED | DateTime(26) | TIMESTAMP | Date/Time Assigned |
| 9 | DTTM_DUE | DateTime(26) | TIMESTAMP | Date/Time Due |