PC_ACCTG_JNL_VW

(SQL View)
 Index Back

Accounting Line History

This view will show all Projects accounting lines which have been written to GL.

SELECT A.BUSINESS_UNIT_GL ,A.JOURNAL_ID ,A.JOURNAL_DATE ,A.UNPOST_SEQ ,A.JOURNAL_LINE ,A.LEDGER ,A.BUSINESS_UNIT_PC ,A.PROJECT_ID ,A.ACTIVITY_ID ,A.RESOURCE_ID ,A.FISCAL_YEAR ,A.ACCOUNTING_PERIOD ,A.ACCOUNT ,A.ALTACCT ,A.DEPTID ,%subrec(CF16_AN_SBR, A) ,A.BUS_UNIT_GL_FROM ,A.CURRENCY_CD ,A.STATISTICS_CODE ,A.LEDGER_GROUP ,A.ANALYSIS_TYPE ,A.RESOURCE_TYPE ,A.RESOURCE_CATEGORY ,A.RESOURCE_SUB_CAT ,A.TRANS_DT ,A.ACCOUNTING_DT ,A.DTTM_STAMP ,A.JRNL_LN_REF ,A.OPEN_ITEM_STATUS ,A.LINE_DESCR ,A.JRNL_LINE_STATUS ,A.JOURNAL_LINE_DATE ,A.FOREIGN_CURRENCY ,A.RT_TYPE ,A.FOREIGN_AMOUNT ,A.RATE_MULT ,A.RATE_DIV ,A.CUR_EFFDT ,A.PROCESS_INSTANCE ,A.PC_DISTRIB_STATUS ,A.GL_DISTRIB_STATUS ,A.PROJ_TRANS_TYPE ,A.PROJ_TRANS_CODE ,A.RESOURCE_STATUS ,A.DESCR ,A.SYSTEM_SOURCE ,A.UNIT_OF_MEASURE ,A.EMPLID ,A.EMPL_RCD ,A.TIME_RPTG_CD ,A.COMPANY ,A.BUSINESS_UNIT_AP ,A.VENDOR_ID ,A.VOUCHER_ID ,A.VOUCHER_LINE_NUM ,A.APPL_JRNL_ID ,A.PYMNT_CNT ,A.DST_ACCT_TYPE ,A.PO_DISTRIB_STATUS ,A.BUSINESS_UNIT_PO ,A.REQ_ID ,A.PO_ID ,A.DUE_DATE ,A.LINE_NBR ,A.SCHED_NBR ,A.DISTRIB_LINE_NUM ,A.AM_DISTRIB_STATUS ,A.BUSINESS_UNIT_AM ,A.ASSET_ID ,A.PROFILE_ID ,A.INCENTIVE_ID ,A.MSTONE_SEQ ,A.BI_DISTRIB_STATUS ,A.BUSINESS_UNIT_BI ,A.BILLING_DATE ,A.INVOICE ,A.BUSINESS_UNIT_AR ,A.CUST_ID ,A.ITEM ,A.ITEM_LINE ,A.ITEM_SEQ_NUM ,A.DST_SEQ_NUM ,A.BUSINESS_UNIT_IN ,A.SCHED_LINE_NO ,A.DEMAND_LINE_NO ,A.INV_ITEM_ID ,A.PAY_END_DT ,A.BUSINESS_UNIT_OM ,A.ORDER_NO ,A.ORDER_INT_LINE_NO ,A.EX_DOC_ID ,A.EX_DOC_TYPE ,A.RESOURCE_QUANTITY ,A.RESOURCE_AMOUNT ,A.RES_USER1 ,A.RES_USER2 ,A.RES_USER3 ,A.RES_USER4 ,A.RES_USER5 ,A.OPRID ,A.COMBO_STATUS ,B.CURRENCY_CD FROM PS_CA_ACCTG_LN_PC A , PS_BUS_UNIT_TBL_PC B WHERE A.BUSINESS_UNIT_PC = B.BUSINESS_UNIT AND A.JOURNAL_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
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 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 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.
6 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
7 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: SP_BU_PC_NONVW

8 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: SP_PROJ_NONVW

9 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
10 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID
11 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
12 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.
13 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
14 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
15 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
16 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

17 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

18 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

19 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

20 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

21 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

22 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

23 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

24 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

25 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

26 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

27 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

28 BUS_UNIT_GL_FROM Character(5) VARCHAR2(5) NOT NULL From Business Unit GL
29 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
30 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
31 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
32 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
33 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
34 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
35 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
36 TRANS_DT Date(10) DATE Transaction Date
37 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
38 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.
39 JRNL_LN_REF Character(10) VARCHAR2(10) NOT NULL Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
40 OPEN_ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Open Item Status
C=Closed Item
N=Not an Open Item Account
O=Open Item
41 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.
42 JRNL_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates the stage of processing of a journal entry.
0=OK - No Errors
1=Uncorrected Error(s)
43 JOURNAL_LINE_DATE Date(10) DATE Specifies the date of a journal line. This date must be the same as the journal date on the header (JOURNAL_DATE) in order for the Parent/Child relationship to remain intact.
44 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
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.
46 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.
47 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
48 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
49 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.
50 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
51 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged
52 GL_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
J=Creating Journals
M=Modified
N=None
P=To be processed
X=Waiting for Reversal
53 PROJ_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Project Transaction Type
54 PROJ_TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Project Transaction Code
55 RESOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
A=Resource Approved
U=Unapproved Resource
56 DESCR Character(30) VARCHAR2(30) NOT NULL Description
57 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.
58 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
59 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
60 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
61 TIME_RPTG_CD Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
62 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
63 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
64 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
65 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
66 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
67 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
68 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
69 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
70 PO_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PO Distribution Status
0=Non-PO
1=Active
2=In-process
3=Error
4=Processed
5=Modified
71 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
72 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
73 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
74 DUE_DATE Date(10) DATE Delivery Due Date from PO
75 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
76 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
77 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
78 AM_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL AM Distribution Status
D=Distributed
I=Ignore
M=Modified
N=Not Distributed
P=Pending
V=Reversed
79 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
80 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
81 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
82 INCENTIVE_ID Character(10) VARCHAR2(10) NOT NULL Investment Incentive ID
83 MSTONE_SEQ Number(3,0) SMALLINT NOT NULL Milestone Sequence
84 BI_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Billing Distribution Status
D=Distributed
I=Ignore
N=Not Distributed
P=Priced
U=Unbillable/Non-billable
W=Billing Worksheet
85 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
86 BILLING_DATE Date(10) DATE Billing Date
87 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
88 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit
89 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
90 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
91 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
92 ITEM_SEQ_NUM Number(3,0) SMALLINT NOT NULL Item Sequence Number
93 DST_SEQ_NUM Number(6,0) INTEGER NOT NULL Distribution Sequence
94 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
95 SCHED_LINE_NO Number(7,2) DECIMAL(6,2) NOT NULL Sched Line NO
96 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
97 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
98 PAY_END_DT Date(10) DATE Pay Period End Date
99 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
100 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
101 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
102 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Documentation ID
103 EX_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies Expenses Document Type
A=Cash Advance
C=Time Report
J=Time Adjustment
M=Accrual - My Wallet
R=Accrual - Expense Report
S=Expense Report
T=Travel Authorization
104 RESOURCE_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Quantity
105 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
106 RES_USER1 Character(10) VARCHAR2(10) NOT NULL Transaction User 1
107 RES_USER2 Character(10) VARCHAR2(10) NOT NULL Transaction User 2
108 RES_USER3 Character(10) VARCHAR2(10) NOT NULL Transaction User 3
109 RES_USER4 Character(10) VARCHAR2(10) NOT NULL Transaction User 4
110 RES_USER5 Character(10) VARCHAR2(10) NOT NULL Transaction User 5
111 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
112 COMBO_STATUS Character(1) VARCHAR2(1) NOT NULL Combo Status
I=Invalid
V=Valid
113 CURRENCY_CD_PC Character(3) VARCHAR2(3) NOT NULL Projects BU Currency