JRNL_PROC_VW(SQL View) |
Index Back |
|---|
| SELECT %Substring(FIELDVALUE, 1, 2) FROM PSXLATITEM WHERE FIELDNAME = 'JRNL_PROC_NAME' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JRNL_PROC_NAME | Character(2) | VARCHAR2(2) NOT NULL |
Journal process name for audit trail.
01=Journal Entry 02=Mark Journal for Posting 03=Mark Journal for Unposting 04=Journal Suspense Correction 05=Copy Journal 06=Create Standard Entry 07=External Flat File 08=Spreadsheet Import Batch 09=Edit Journal 10=Spreadsheet Import Online 11=Generate Journals 12=Allocation 13=Post Journal 14=Request Ledger Close 15=Process Multi-Currency 16=Consolidation 17=Equitization 18=Reversal Journals 19=BookCode Journals 20=Unpost Journals 21=Amortization Generate Journals 22=Mass Delete Journals |