PSDMT_FBSEQ_VW(SQL View) |
Index Back |
|---|---|
Fields by Sequence |
| SELECT A.PS_OWNER , A.PSDMUNIT_ID , B.PSDMUNIT_SEQ , A.FIELDNUM , A.RECNAME , ' ' , A.FIELDNAME , B.RECNAME , B.RECALIAS FROM %Table(PSDMT_UNIT_DTL) A , %Table(PSDMT_SEQ_DTL) B WHERE A.PS_OWNER = B.PS_OWNER AND A.PSDMUNIT_ID = B.PSDMUNIT_ID AND A.FIELDNAME = B.FIELDNAME AND A.ACTIVE_STATUS = 'A' AND EXISTS ( SELECT 'X' FROM %Table(PSDMT_UDC) U WHERE U.PS_OWNER = A.PS_OWNER AND U.PSDMUNIT_ID = A.PSDMUNIT_ID AND U.FIELDNUM = A.FIELDNUM AND U.SELECT_SW = 'Y') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PS_OWNER | Character(2) | VARCHAR2(2) NOT NULL |
PeopleSoft Owner
AM=Asset Management AP=Accounts Payable AR=Accounts Receivable BD=Budgets BI=Billing CA=Contracts CM=Cost Management CS=Customer Service EN=Engineering EX=Expenses GL=General Ledger HR=Human Resources IN=Inventory MG=Manufacturing OM=Order Management PC=Project Costing PL=Planning PO=Purchasing PR=Production Control PT=PeopleTools TL=Time and Labor TR=Treasury |
| 2 | PSDMUNIT_ID | Character(30) | VARCHAR2(30) NOT NULL | Transaction |
| 3 | PSDMUNIT_SEQ | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | FIELDNUM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN_VW3 |
| 6 | RECALIAS | Character(15) | VARCHAR2(15) NOT NULL | Record Alias |
| 7 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 8 | RECNAME_SEQ | Character(15) | VARCHAR2(15) NOT NULL | Sequence Record Name |
| 9 | RECALIAS_SEQ | Character(15) | VARCHAR2(15) NOT NULL | Sequence Record Alias |