AP_CGRP_FLTR_VW(SQL View) |
Index Back |
|---|---|
AP Control Group Table |
| SELECT BUSINESS_UNIT , GRP_AP_ID , GRP_AP_STATUS , CTL_GROSS_AMT , ASSIGNED_TO_OPRID , DTTM_ASSIGNED , DTTM_DUE FROM PS_GRP_AP WHERE GRP_AP_STATUS <> 'A' |
| # | 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_VW2 |
| 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 | ASSIGNED_TO_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Assigned to
Prompt Table: OPR_AP_VW |
| 6 | DTTM_ASSIGNED | DateTime(26) | TIMESTAMP | Date/Time Assigned |
| 7 | DTTM_DUE | DateTime(26) | TIMESTAMP | Date/Time Due |