PSDMT_INSTANCEU(SQL Table) |
Index Back |
---|---|
Saved Search User Entered Val |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | USERID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
2 | 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 |
3 | PSDMUNIT_ID | Character(30) | VARCHAR2(30) NOT NULL | Transaction |
4 | SEARCH_SAVE_ID | Character(30) | VARCHAR2(30) NOT NULL | Save Search As |
5 | FIELDNUM | Number(4,0) | SMALLINT NOT NULL | Field Number |
6 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
7 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
8 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
9 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
10 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
11 | KEY_CHAR_30_01 | Character(30) | VARCHAR2(30) NOT NULL | Key Char(30) 01 |
12 | KEY_DATE_01 | Date(10) | DATE | Key Date 01 |
13 | KEY_SIGN_NUM_28_0 | Signed Number(29,0) | DECIMAL(28) NOT NULL | Key 1 |
14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
15 | MTM_UPDT_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Update Action
A=Set equal to B=Set to Empty |
16 | FIELDVALUE_CHAR1 | Character(30) | VARCHAR2(30) NOT NULL | Value |
17 | FIELDVALUE_CHR_DD1 | Character(30) | VARCHAR2(30) NOT NULL |
Value
Prompt Table: DUMMY_PROMPT_VW |
18 | FIELDVALUE_NUM1 | Signed Number(29,0) | DECIMAL(28) NOT NULL | Value |
19 | FIELDVALUE_DT1 | Date(10) | DATE | Value |
20 | FIELDVALUE_CHAR1P | Character(30) | VARCHAR2(30) NOT NULL |
Value
Prompt Table: %EDITTABLE4 |
21 | FIELDVALUE_DT1P | Date(10) | DATE |
Value
Prompt Table: %EDITTABLE6 |
22 | FIELDVALUE_NUM1P | Signed Number(29,0) | DECIMAL(28) NOT NULL |
Value
Prompt Table: %EDITTABLE5 |
23 | FIELDVALUE_AMT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Value |
24 | FIELDVALUE_DEC1 | Signed Number(31,6) | DECIMAL(29,6) NOT NULL | Value |