| # |
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 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 5 |
PSDMT_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Action
A=Application Engine
D=SQL Delete
I=SQL Insert
U=SQL Update
|
| 6 |
PSDMT_DISTINCT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Distinct Values
Y/N Table Edit
|
| 7 |
TARGET_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Target Table Record Name
Prompt Table:
PSDMT_TRGTTBLVW
|
| 8 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 9 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
Prompt Table:
PSDMT_AE_VW
|
| 10 |
PSDMT_CUSTOM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom
|