INQ_JRNL_TRN_VW(SQL View) |
Index Back |
|---|---|
View of Journal Transactions |
| SELECT A.JOURNAL_ID , A.JOURNAL_DATE , B.FISCAL_YEAR , B.ACCOUNTING_PERIOD , B.BUSINESS_UNIT , A.LEDGER , A.UNPOST_SEQ , A.JOURNAL_LINE , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(CF12_AN_SBR,A) , A.PROJECT_ID , A.BUSINESS_UNIT_PC , A.ACTIVITY_ID , A.RESOURCE_TYPE , A.BUDGET_PERIOD , A.BOOK_CODE , A.GL_ADJUST_TYPE , A.SCENARIO , A.STATISTICS_CODE , A.DATE_CODE , B.SOURCE , A.LINE_DESCR , B.JRNL_HDR_STATUS , B.ACCTG_DEF_NAME , A.MONETARY_AMOUNT , A.CURRENCY_CD , A.STATISTIC_AMOUNT , A.FOREIGN_AMOUNT , A.FOREIGN_CURRENCY , A.MOVEMENT_FLAG , ' ' FROM PS_JRNL_LN A , PS_JRNL_HEADER B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.JOURNAL_ID = B.JOURNAL_ID AND A.JOURNAL_DATE = B.JOURNAL_DATE AND A.UNPOST_SEQ = B.UNPOST_SEQ AND B.JRNL_HDR_STATUS IN ('P', 'U') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |
| 2 | JOURNAL_DATE | Date(10) | DATE | Specifies the date the journal was created. |
| 3 |  FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 4 | 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. |
| 5 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 7 | 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". |
| 8 | JOURNAL_LINE | Number(9,0) | DECIMAL(9) NOT NULL | Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header. |
| 9 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 10 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 11 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 12 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit ChartField |
| 13 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product ChartField |
| 14 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
| 15 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL | Class Field |
| 16 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField |
| 17 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference |
| 18 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Affiliate |
| 19 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
| 20 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate |
| 21 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | Expansion chartfield 1 |
| 22 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
| 23 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |
| 24 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 25 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 26 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 27 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 28 | BUDGET_PERIOD | Character(8) | VARCHAR2(8) NOT NULL | Budget Period |
| 29 | BOOK_CODE | Character(4) | VARCHAR2(4) NOT NULL | Book Code |
| 30 | GL_ADJUST_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Adjustment Type |
| 31 | SCENARIO | Character(10) | VARCHAR2(10) NOT NULL | A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca |
| 32 | STATISTICS_CODE |
Character(3) | VARCHAR2(3) NOT NULL | Statistics Code |
| 33 | DATE_CODE | 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. |
| 34 | 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. |
| 35 | LINE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered. |
| 36 | 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 |
| 37 | 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. |
| 38 | MONETARY_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account. |
| 39 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 40 | STATISTIC_AMOUNT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT. |
| 41 | FOREIGN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item. |
| 42 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 43 | MOVEMENT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign.
N=Natural R=Reversal |
| 44 | DISP_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Display Currency |