OWNER_IDTIP_STAGELANGUAGE_CDPC_TIP_LANG_WRK(SQL Table) |
Index Back |
|---|---|
Derived Work RecordUsed by Transactions in Progress WRK - Record can be used for a variety of reasons. 1. Temporarily hold processing data 2. Placeholder for fields on a page 3. Place holder for Record.Field PeopleCode |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OWNER_ID |
Character(5) | VARCHAR2(5) NOT NULL | Owner ID |
| 2 | TIP_STAGE |
Character(7) | VARCHAR2(7) NOT NULL | Transactions In Progress |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR80 | Character(80) | VARCHAR2(80) NOT NULL | Description |
| 5 | AP | Character(1) | VARCHAR2(1) NOT NULL | Payables |
| 6 | EX | Character(1) | VARCHAR2(1) NOT NULL | Expenses |
| 7 | INV | Character(1) | VARCHAR2(1) NOT NULL | Inventory |
| 8 | PC | Character(1) | VARCHAR2(1) NOT NULL | Projects |
| 9 | PO | Character(1) | VARCHAR2(1) NOT NULL | Purchasing |
| 10 | GM | Character(1) | VARCHAR2(1) NOT NULL | Grants |
| 11 | GL | Character(1) | VARCHAR2(1) NOT NULL | General Ledger |
| 12 | CA | Character(1) | VARCHAR2(1) NOT NULL | Contracts |
| 13 | BI | Character(1) | VARCHAR2(1) NOT NULL | Billing |
| 14 | AR | Character(1) | VARCHAR2(1) NOT NULL | Receivables |