AQS_BUDREF_U_VW(SQL View) |
Index Back |
|---|---|
CFS: Budget Reference TableChartfield Security: Stores the Budget Reference security values by user ID. |
| SELECT A.OPRID , A.PRODSRCID , B.BUSINESS_UNIT , %Sql(BUDGET_REF, A.) FROM PS_SEC_BUDREF_USER A , PS_OI_BUSET_MAP B WHERE A.SETID = B.BUDGREF_SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | PRODSRCID |
Character(4) | VARCHAR2(4) NOT NULL |
Chartfield Security: Source Product
DBI=Billing DCM=Cost Management DIN=Inventory DMI=Mobile Inventory DOM=Order Management DPO=Purchasing DPV=eProcurement DSP=Service Procurement FAM=Asset Management FAP=Payables FAR=Receivables FCA=Contracts FEX=Expenses FGL=General Ledger FGM=Grants Management FPC=Project Costing FTR=Treasury KK=Commitment Control |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | BUDGET_REF |
Character(8) | VARCHAR2(8) NOT NULL | Budget Reference |