EE_PO_DRILL_VW

(SQL View)
 Index Back

EE PO Acctg. Drill View


SELECT A.BUSINESS_UNIT , A.PO_ID , A.UNPOST_SEQ , A.APPL_JRNL_ID , A.LINE_NBR , A.SCHED_NBR , A.DISTRIB_LINE_NUM , A.MOD_SEQ_NBR , A.DST_ACCT_TYPE , A.VOUCHER_ID , A.EE_EVENT_STEP , A.KK_TRAN_ID , A.KK_TRAN_DT , A.KK_TRAN_LN , A.RVRSL_FLG , A.SEQNBR , A.BALANCING_LINE , A.REFERENCED_BUDGET , A.CLOSED_VALUE , A.EVENT_LINE , A.LEDGER , A.JOURNAL_ID , A.JOURNAL_DATE , A.JOURNAL_LINE , A.STATISTICS_CODE , A.FOREIGN_CURRENCY , A.STATISTIC_AMOUNT , A.JRNL_LN_REF , A.CURRENCY_CD , A.ACCOUNTING_DT , A.ACCOUNTING_PERIOD , A.FISCAL_YEAR , A.BUSINESS_UNIT_GL , A.LEDGER_GROUP , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(CF16_AN_SBR,A) , A.PROJECT_ID , A.MONETARY_AMOUNT , A.FOREIGN_AMOUNT , A.GL_DISTRIB_STATUS , A.PROCESS_INSTANCE , A.ENTRY_EVENT , A.DEBIT_CREDIT , A.JRNL_DESCR , A.OPEN_ITEM_KEY , A.IN_PROCESS_FLG FROM PS_EE_PO_ACCTG_LN A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 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".
4 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
7 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
8 MOD_SEQ_NBR Number(3,0) SMALLINT NOT NULL Modification Sequence Nbr
9 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
10 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
11 EE_EVENT_STEP Character(10) VARCHAR2(10) NOT NULL Entry Event Step
12 KK_TRAN_ID Character(10) VARCHAR2(10) NOT NULL Commitment Control Foreign Key for Transaction Identification.
13 KK_TRAN_DT Date(10) DATE Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
14 KK_TRAN_LN Number(9,0) DECIMAL(9) NOT NULL Commitment Control Transaction Line number.
15 RVRSL_FLG Character(1) VARCHAR2(1) NOT NULL Commitment Control Reversal Flag

Y/N Table Edit

Default Value: N

16 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number

Default Value: 0

17 BALANCING_LINE Character(1) VARCHAR2(1) NOT NULL Balancing Line
18 REFERENCED_BUDGET Character(1) VARCHAR2(1) NOT NULL Referenced Budget
19 CLOSED_VALUE Character(1) VARCHAR2(1) NOT NULL Closed Status field value
20 EVENT_LINE Number(5,0) INTEGER NOT NULL Entry Event Line Number
21 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
22 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.
23 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
24 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.
25 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
26 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
27 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.
28 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.
29 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
30 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
31 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.
32 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
33 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
34 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
35 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
36 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
37 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
38 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

50 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
51 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.
52 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.
53 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
54 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
55 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event
56 DEBIT_CREDIT Character(2) VARCHAR2(2) NOT NULL Debit / Credit Indicator
CR=Credit
DR=Debit
57 JRNL_DESCR Character(30) VARCHAR2(30) NOT NULL Journal Description
58 OPEN_ITEM_KEY Character(30) VARCHAR2(30) NOT NULL Open Item Key
59 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag