| # |
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 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
PSDMT_UEVFLDSVW
|
| 5 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 6 |
LABEL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
LABEL_ID identifies uniquness of DB Field Labels.
This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
Prompt Table:
PSDMT_SRCHLBLVW
|
| 7 |
PROMPT_EDITTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Type
1=No Table Edit
2=Prompt Table
3=Translate Table
4=Yes/No
5=Currency Controlled
Default Value: 1
|
| 8 |
PROMPT_TBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Prompt Table
Prompt Table:
IT_PSRECDEFN
|