|
SELECT A.BUSINESS_UNIT_IU ,A.JOURNAL_ID ,A.JOURNAL_DATE ,A.UNPOST_SEQ ,A.BUSINESS_UNIT ,A.ADJUSTING_ENTRY ,A.FISCAL_YEAR ,A.ACCOUNTING_PERIOD ,A.ADB_DATE ,A.LEDGER_GROUP ,A.LEDGER ,A.AUTO_GEN_LINES ,A.REVERSAL_CD ,A.REVERSAL_DATE ,A.REVERSAL_ADJ_PER ,A.REVERSAL_CD_ADB ,A.REVERSAL_DATE_ADB ,A.UNPOST_JRNL_DATE ,A.JRNL_TOTAL_LINES ,A.JRNL_TOTAL_DEBITS ,A.JRNL_TOT_CREDITS ,A.JRNL_NET_UNITS ,A.SOURCE ,A.TRANS_REF_NUM ,A.JRNL_BALANCE_STAT ,A.CONTROL_TOTAL_STAT ,A.JRNL_EDIT_ERR_STAT ,A.JRNL_HDR_STATUS ,A.SUSP_RECON_STATUS ,A.JRNL_PROCESS_REQST ,A.JRNL_SUMLED_REQST ,A.SJE_TYPE ,A.SCHEDULE ,A.EVENT_OCCURRENCE ,A.POSTED_DATE ,A.PROCESS_INSTANCE ,A.SOURCE_INSTANCE ,A.TRANSACTION_DATE ,A.LAST_LN_COMMITTED ,A.OPRID ,A.DTTM_STAMP_SEC ,A.DESCR ,A.CURRENCY_CD ,A.FOREIGN_CURRENCY ,A.RT_TYPE ,A.CUR_EFFDT ,A.RATE_DIV ,A.RATE_MULT ,A.SYSTEM_SOURCE ,A.DOC_TYPE ,A.DOC_SEQ_NBR ,A.DOC_SEQ_DATE ,A.DOC_SEQ_STATUS ,A.ACCTG_DEF_NAME ,A.BUDGET_HDR_STATUS ,A.KK_AMOUNT_TYPE ,A.KK_TRAN_OVER_FLAG ,A.KK_TRAN_OVER_OPRID ,A.KK_TRAN_OVER_DTTM ,A.KK_SKIP ,A.JOURNAL_LOCKED ,A.PROC_PART_ID ,A.GL_ADJUST_TYPE ,A.DATE_CODE_JRNL ,A.JOURNAL_DATE_ORIG ,A.JOURNAL_CLASS ,A.KK_TRAN_BYPAS_FLAG ,A.EE_HDR_STATUS ,A.IU_SYS_TRAN_CD ,A.IU_TRAN_CD ,A.JRNL_CREATE_DTTM ,A.ALC ,A.FED_DISTRIB_STATUS ,A.DESCR254 ,A.ATTACHMENT_EXIST FROM PS_JRNL_HEADER A WHERE EXISTS ( SELECT 'X' FROM PS_JRNL_HEADER B WHERE B.BUSINESS_UNIT_IU=A.BUSINESS_UNIT_IU AND B.BUSINESS_UNIT=A.BUSINESS_UNIT_IU AND B.JOURNAL_ID=A.JOURNAL_ID AND B.JOURNAL_DATE=A.JOURNAL_DATE AND A.UNPOST_SEQ=B.UNPOST_SEQ)
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 2 |
JOURNAL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
|
| 3 |
JOURNAL_DATE |
Date(10) |
DATE NOT NULL |
Specifies the date the journal was created.
|
| 4 |
UNPOST_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
|
| 5 |
BUSINESS_UNIT_LN |
Character(5) |
VARCHAR2(5) NOT NULL |
Line Business Unit
|
| 6 |
ADJUSTING_ENTRY |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjusting Entry
C=Fiscal Year Close
N=Non-Adjusting Entry
Y=Adjusting Entry
|
| 7 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 8 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
Prompt Table:
GL_OPEN_ADJP_VW
|
| 9 |
ADB_DATE |
Date(10) |
DATE |
Specifies the daily date to use when Average Daily Balancing is activated. The date is determined by the daily calendar associated with the General Ledger Business Unit to which the journal is posted. When ADB processing is not activated, the ADB_Date defaults to the date on the Journal Header (JOURNAL_DATE).
|
| 10 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table:
SP_BULGRP_NONVW
|
| 11 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
Prompt Table:
LED_GRP_LED_TBL
|
| 12 |
AUTO_GEN_LINES |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) journal lines should be automatically generated for other ledgers in a ledger group. This option is automatically on if the Keep Ledgers in Sync option is on for the specified ledger group. You can select the Auto Generate Lines option for a multibook ledger group specified on a journal header.
Y/N Table Edit
|
| 13 |
REVERSAL_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates if a journal entry should be automatically reversed, and if so, with what date. When associated with a reversal entry, it indicates that the entry was created automatically by the reversal process.
B=Beginning of Next Period
D=On Date Specified By User
E=End of Next Period
N=Do Not Generate Reversal
R=Created by Reversal Process
U=Adjustment Period
X=Next Day
|
| 14 |
REVERSAL_DATE |
Date(10) |
DATE |
Specifies the date for an automatic reversal journal entry. The date must be within the calendar of the target (posting) ledger. PeopleSoft General Ledger automatically creates and populates a journal entry with this date.
|
| 15 |
REVERSAL_ADJ_PER |
Number(3,0) |
SMALLINT NOT NULL |
Adjustment Period
Prompt Table:
CAL_ADJP_TBL
|
| 16 |
REVERSAL_CD_ADB |
Character(1) |
VARCHAR2(1) NOT NULL |
ADB Reversal Code
D=On Date Specified By User
S=Same As Journal Reversal
|
| 17 |
REVERSAL_DATE_ADB |
Date(10) |
DATE |
ADB Reversal Date
|
| 18 |
UNPOST_JRNL_DATE |
Date(10) |
DATE |
Unpost Date
|
| 19 |
JRNL_TOTAL_LINES |
Number(9,0) |
DECIMAL(9) NOT NULL |
Represents a running total of the number of lines in a journal entry. It is maintained by PeopleSoft General Ledger as lines are entered.
|
| 20 |
JRNL_TOTAL_DEBITS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents a running total of the debit amounts in a journal entry. It is maintained by PeopleSoft General Ledger as lines are entered.
|
| 21 |
JRNL_TOT_CREDITS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents a running total of the credit amounts in a journal entry. It is maintained by PeopleSoft General Ledger as lines are entered.
|
| 22 |
JRNL_NET_UNITS |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Represents a running total of the statistical units in a journal entry. It is a hash total since there may be different types of units of measure reflected in a single journal. It is maintained by PeopleSoft General Ledger as lines are entered.
|
| 23 |
SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.
Prompt Table:
SOURCE_TBL
|
| 24 |
TRANS_REF_NUM |
Character(8) |
VARCHAR2(8) NOT NULL |
Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal entry. The journal reference is helpful if you need to trace back to the source of the transaction.
|
| 25 |
JRNL_BALANCE_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a journal is in balance. A balanced journal is one in which the debit and credit lines net to zero. This field is maintained by the journal edit program of PeopleSoft General Ledger.
E=Error - Journal Out of Balance
V=Valid - Journal in Balance
|
| 26 |
CONTROL_TOTAL_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the control totals match the entry totals for a journal entry. The status is either (E) indicating an error or (V) indicating that the match is OK.
E=Error - Control Totals
V=Valid - Control Totals
|
| 27 |
JRNL_EDIT_ERR_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not there are edit errors in a journal entry.
E=Error - Edit Error(s)
N=No Status
V=Valid - No Edit Errors
|
| 28 |
JRNL_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates the processing status of a journal entry.
D=Deleted
E=Journal Has Errors
I=Posting Incomplete
M=Valid SJE Model -- Do Not Post
N=No Status - Needs to be Edited
P=Posted to Ledger(s)
T=Journal Entry Incomplete
U=Unposted
V=Valid Journal - Edits Complete
X=Cancelled
Z=Upgrade Journal - Can't Unpost
|
| 29 |
SUSP_RECON_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not there are suspense transactions in a journal, and if so, whether or not they have been corrected and posted.
0=No Suspense Transactions
1=Suspense Transactions
2=Correction Journal Created
3=Correction Journal Posted
|
| 30 |
JRNL_PROCESS_REQST |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that determines when a journal is ready for posting. Some examples of the request flag are Approved to Post, Denied, and Pending Approval.
D=Default
E=Denied
G=Pending Approval
N=None
P=Approved to Post
Q=Pending for Unpost Approval
R=Replace
S=Security Denied
T=Terminated
U=Pending Request to Unpost
W=Approved to Post
X=Delete
|
| 31 |
JRNL_SUMLED_REQST |
Character(1) |
VARCHAR2(1) NOT NULL |
Post to Summary Ledger
Y/N Table Edit
|
| 32 |
SJE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates the type of Standard Journal Entry (SJE), which can be either Template or Recurring. If the type is Recurring you must also specify a schedule (SCHEDULE).
M=Model -- Do Not Post
P=Spread Daily Proration
R=Recurring on a Schedule
S=Spread Amounts from SJE Model
T=Template to be Completed
|
| 33 |
SCHEDULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule ID
Prompt Table:
SCHEDULE_TBL
|
| 34 |
EVENT_OCCURRENCE |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.
Prompt Table:
EVENTS_TBL
|
| 35 |
POSTED_DATE |
Date(10) |
DATE |
Specifies the date that a journal entry is posted. This field is maintained by the posting program of PeopleSoft General Ledger.
|
| 36 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 37 |
SOURCE_INSTANCE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Identifies a Process Instance (PROCESS_INSTANCE), and is used by the PeopleSoft Process Scheduler to save this identifier.
|
| 38 |
TRANSACTION_DATE |
Date(10) |
DATE |
Transaction Date
|
| 39 |
LAST_LN_COMMITTED |
Number(6,0) |
INTEGER NOT NULL |
Last Line Committed
|
| 40 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 41 |
DTTM_STAMP_SEC |
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.
|
| 42 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 43 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 44 |
FOREIGN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Foreign Currency Code
Prompt Table:
FRGN_CURR_VW
|
| 45 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table:
RT_TYPE_TBL
|
| 46 |
CUR_EFFDT |
Date(10) |
DATE |
Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
|
| 47 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 48 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 49 |
SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
|
| 50 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
Prompt Table:
DOC_TYPE_TBL
|
| 51 |
DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
|
| 52 |
DOC_SEQ_DATE |
Date(10) |
DATE |
Specifies the date that a document sequence number is assigned to a document or the date the document was created.
|
| 53 |
DOC_SEQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
K=Invalid Ledger
L=Invalid Ledger Group
N=No Status
|
| 54 |
ACCTG_DEF_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Defines the content and source of the accounting transactions that the Journal Generator program of PeopleSoft General Ledger uses to create journal entries. Accounting transactions are populated by PeopleSoft applications or third-party systems for input to the general ledger.
|
| 55 |
BUDGET_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
|
| 56 |
KK_AMOUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic
|
| 57 |
KK_TRAN_OVER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control source transaction override flag
N=No
Y=Yes
Y/N Table Edit
|
| 58 |
KK_TRAN_OVER_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Commitment Control source transaction override operator
|
| 59 |
KK_TRAN_OVER_DTTM |
DateTime(26) |
TIMESTAMP |
Commitment Control source transaction override datetime
|
| 60 |
KK_SKIP |
Character(1) |
VARCHAR2(1) NOT NULL |
The field is used in Journal Header record. If its value is '1', the journal will skip commitment control budget checking. Usually, the journal created from Journal Generator for accounting entries which have been budget checked already will have '1' populated in this field.
0=Commitment Control in GL
1=Skip Commitment Control in GL
|
| 61 |
JOURNAL_LOCKED |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Locked for Change
|
| 62 |
PROC_PART_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Partition ID
|
| 63 |
GL_ADJUST_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Adjustment Type
Prompt Table:
FIN_ADJ_TYPE_VW
|
| 64 |
DATE_CODE_JRNL |
Character(1) |
VARCHAR2(1) NOT NULL |
This field defines codes for Date field used in Journal lines record.
The Different date fields can be used as the basis for alternate Posting to satisfy Trade Date/Settlement date requirements.
Y/N Table Edit
|
| 65 |
JOURNAL_DATE_ORIG |
Date(10) |
DATE |
Orignial Journal Date
|
| 66 |
JOURNAL_CLASS |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Class
Prompt Table:
JRNL_CLASS_TBL
|
| 67 |
KK_TRAN_BYPAS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Bypass Budget Checking
Y/N Table Edit
|
| 68 |
EE_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Entry Event Header Status
|
| 69 |
IU_SYS_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
|
| 70 |
IU_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
Prompt Table:
IU_TRAN_MAP_VW
|
| 71 |
JRNL_CREATE_DTTM |
DateTime(26) |
TIMESTAMP |
Journal Creation Date Time
|
| 72 |
ALC |
Character(8) |
VARCHAR2(8) NOT NULL |
Agency Location Code
Prompt Table:
AGENCY_LOC_CD
|
| 73 |
FED_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
GL Federal Reporting distribution status for SF 224.
0=Original Distribution
1=Supplemental 1 Distribution
2=Supplemental 2 Distribution
3=Supplemental 3 Distribution
4=Supplemental 4 Distribution
5=Supplemental 5 Distribution
6=Supplemental 6 Distribution
7=Supplemental 7 Distribution
8=Supplemental 8 Distribution
9=Supplemental 9 Distribution
N=Not Distributed
|
| 74 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 75 |
ATTACHMENT_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Attachments Exist
N=N
Y=Y
|