AV_ACCTG_DTL_VW

(SQL View)
Index Back

AV Accounting Line view

This record contains the consolidated payroll accounting detail.

SELECT EMPLID ,EXT_ORG_ID ,LINE_DESCR ,APPL_JRNL_ID ,FISCAL_YEAR ,ACCOUNTING_PERIOD ,GL_DISTRIB_STATUS ,BUDGET_PERIOD ,RUN_DT ,SEQNUM ,SF_LINE_NBR ,IN_PROCESS_FLG ,BUSINESS_UNIT_GL ,JOURNAL_ID ,JOURNAL_DATE ,JOURNAL_LINE ,ACCOUNT ,DEPTID ,OPERATING_UNIT ,PRODUCT ,FUND_CODE ,CLASS_FLD ,PROGRAM_CODE ,BUDGET_REF ,AFFILIATE ,AFFILIATE_INTRA1 ,AFFILIATE_INTRA2 ,CHARTFIELD1 ,CHARTFIELD2 ,CHARTFIELD3 ,ALTACCT ,PROJECT_ID ,STATISTICS_CODE ,MONETARY_AMOUNT ,STATISTIC_AMOUNT ,JRNL_LN_REF ,OPEN_ITEM_STATUS ,JRNL_LINE_STATUS ,JOURNAL_LINE_DATE ,BUSINESS_UNIT ,ACCOUNTING_DT ,PROCESS_INSTANCE ,CURRENCY_CD ,FOREIGN_AMOUNT ,FOREIGN_CURRENCY ,LEDGER ,LEDGER_GROUP ,EXT_GL_CHARTFLD ,AV_BUSINESS_UNIT ,SESSION_NO ,GIFT_NO ,INSTITUTION ,MBR_PMT_NO ,TENDER_TYPE ,DESIGNATION ,RT_TYPE ,RATE_DIV ,RATE_MULT ,AUDIT_ACTN FROM PS_AV_ACCTG_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
3 LINE_DESCR Character(30) VARCHAR2(30) NOT NULL Journal Line Description
4 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
5 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
6 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Accounting Period
7 GL_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
D=Distributed
G=Generated
H=Hold
I=Ignored
M=Modified
N=None
8 BUDGET_PERIOD Character(10) VARCHAR2(10) NOT NULL Budget Period
9 RUN_DT Date(10) DATE Run Date
10 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
11 SF_LINE_NBR Number(9,0) DECIMAL(9) NOT NULL Student Financials Line Number
12 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In Process
13 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Unit
14 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL GL Journal ID
15 JOURNAL_DATE Date(10) DATE Journal Date
16 JOURNAL_LINE Number(9,0) DECIMAL(9) NOT NULL GL Journal Line Number
17 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
18 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
19 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit
20 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
21 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
22 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.
23 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
24 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield
25 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field
26 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
27 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
28 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1
29 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
30 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
31 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
32 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
33 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
34 MONETARY_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Monetary Amount
35 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Statistic Amount
36 JRNL_LN_REF Character(10) VARCHAR2(10) NOT NULL Journal Line Reference
37 OPEN_ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Open Item Status
C=Closed Item
N=Not an Open Item Account
O=Open Item
38 JRNL_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Journal Line Status
0=OK - No Errors
1=Uncorrected Error(s)
39 JOURNAL_LINE_DATE Date(10) DATE Journal Line Date
40 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
41 ACCOUNTING_DT Date(10) DATE Accounting Date
42 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
43 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
44 FOREIGN_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Foreign Amount
45 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
46 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
47 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
48 EXT_GL_CHARTFLD Character(50) VARCHAR2(50) NOT NULL External GL Chart Field
49 AV_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
50 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
51 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr
52 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
53 MBR_PMT_NO Character(11) VARCHAR2(11) NOT NULL Member Payment Number
54 TENDER_TYPE Character(6) VARCHAR2(6) NOT NULL Tender Type
55 DESIGNATION Character(11) VARCHAR2(11) NOT NULL Designation
56 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.
57 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
58 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
59 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values