MTMTOOL_AET(SQL Table) |
Index Back |
---|---|
Mass Transaction AET |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
4 | 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 Default Value: AM |
5 | PSDMUNIT_ID | Character(30) | VARCHAR2(30) NOT NULL | Transaction |
6 | PSDMUNIT_SEQ | Number(3,0) | SMALLINT NOT NULL | Sequence |
7 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
8 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
9 | MTM_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Library Section |
10 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
11 | DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
12 | MTM_NULL_DT | Date(10) | DATE | Null Date |
13 | MTM_NULL_DTTMSTAMP | DateTime(26) | TIMESTAMP | Null Timestamp |
14 | MTM_NULL_TIME | Time(15) | TIMESTAMP | Null Time |
15 | MTM_AFFECTED_ROWS | Number(9,0) | DECIMAL(9) NOT NULL | Affected Rows |
16 | GET_AFF_ROWS_SW | Character(1) | VARCHAR2(1) NOT NULL | Get Affected Rows |