BI_ACCT_LN_VW

(SQL View)
Index Back

Acctg Entries by Inv Ln

View to display accouting entries for a business unit/invoice/line.

SELECT business_unit ,invoice ,line_Seq_num ,accounting_dt ,acct_entry_type ,disc_sur_lvl ,disc_sur_id ,line_dst_seq_num ,tax_authority_cd ,business_unit_gl ,ledger_group ,ledger ,accounting_period ,account ,altacct , DEPTID ,%subrec(CF16_AN_SBR,A) ,%subrec(PC_CF1_N_SBR,A) ,statistics_code ,monetary_amount ,statistic_amount ,jrnl_ln_ref ,line_descr ,user1 ,user2 ,user3 ,user4 ,user5 ,journal_id ,journal_date ,journal_line ,gl_distrib_status ,appl_jrnl_id ,currency_cd ,foreign_currency ,foreign_amount ,rate_mult ,rate_div ,rt_type ,entry_event ,budget_dt ,budget_line_status , open_item_key FROM PS_BI_ACCT_ENTRY a WHERE line_seq_num <> 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_BI_NONVW

2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

Prompt Table: BI_HDR_ALL_VW

3 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
4 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
5 ACCT_ENTRY_TYPE Character(3) VARCHAR2(3) NOT NULL Account Entry Type
6 DISC_SUR_LVL Number(2,0) SMALLINT NOT NULL Discount/Surcharge Level
7 DISC_SUR_ID Character(15) VARCHAR2(15) NOT NULL Identifier
8 LINE_DST_SEQ_NUM Number(3,0) SMALLINT NOT NULL Revenue Sequence Number
9 TAX_AUTHORITY_CD Character(3) VARCHAR2(3) NOT NULL Tax Authority
10 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
11 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
12 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
13 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.
14 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
15 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
16 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

17 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

29 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

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

Prompt Table: %EDIT_PROJECT

31 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

32 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

33 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

34 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

35 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

36 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
37 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.
38 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.
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 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.
41 USER1 Character(1) VARCHAR2(1) NOT NULL Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
42 USER2 Character(1) VARCHAR2(1) NOT NULL Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
43 USER3 Character(1) VARCHAR2(1) NOT NULL Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
44 USER4 Character(1) VARCHAR2(1) NOT NULL Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
45 USER5 Character(1) VARCHAR2(1) NOT NULL Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
46 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.
47 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
48 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.
49 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
50 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
51 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
52 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
53 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.
54 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
55 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
56 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
57 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event
58 BUDGET_DT Date(10) DATE Budget Date
59 BUDGET_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL -> SL - 15-AUG-2002 MISC_CRITERIA label has been added <-
B=Bypass
E=Error
N=Not Chk'd
V=Valid
W=Warning
60 OPEN_ITEM_KEY Character(30) VARCHAR2(30) NOT NULL Open Item Key

Prompt Table: %EDITTABLE40