PO_ACCTG_L3_VW(SQL View) |
Index Back |
---|---|
Requisition Acctng Line InqeryDate Initials Reference # Description 12/23/2010 VVBK 1975675002 Modified view definition |
SELECT H.BUSINESS_UNIT , H.PO_ID , H.UNPOST_SEQ , H.KK_SOURCE_TRAN , L.LINE_NBR , L.SCHED_NBR , L.DISTRIB_LINE_NUM , 0 , L.DST_ACCT_TYPE , ' ' , HDR.VENDOR_ID , HDR.PO_STATUS , A.KK_TRAN_ID , A.KK_TRAN_DT , H.KK_SOURCE_TRAN , 'D' , ' ' , A.BUSINESS_UNIT , A.LEDGER_GROUP , A.LEDGER , A.KK_TRAN_ID , A.ACCOUNT , ' ' , A.MONETARY_AMOUNT , A.BASE_CURRENCY , A.CLOSED_VALUE , A.ACCOUNTING_PERIOD , A.FISCAL_YEAR , A.DEPTID , %subrec(CF16_AN_SBR , A) , %subrec(CFCC1_AN_SBR , A) , A.FOREIGN_AMOUNT , A.FOREIGN_CURRENCY , A.BALANCING_LINE FROM PS_KK_ACTIVITY_LOG A , PS_KK_SOURCE_HDR H , PS_KK_SOURCE_LN L , PS_PO_HDR HDR WHERE H.BUSINESS_UNIT = HDR.BUSINESS_UNIT AND H.PO_ID = HDR.PO_ID AND H.KK_TRAN_ID = L.KK_TRAN_ID AND H.KK_TRAN_DT = L.KK_TRAN_DT AND H.KK_SOURCE_TRAN = 'PO_POENCNP' AND L.KK_TRAN_ID = A.KK_TRAN_ID AND L.KK_TRAN_DT = A.KK_TRAN_DT AND L.KK_TRAN_LN = A.KK_TRAN_LN AND A.REFERENCED_BUDGET = 'N' |
# | 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 | REF_REVERSAL_ID | Character(10) | VARCHAR2(10) NOT NULL | Reference Reversal ID |
11 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
12 | PO_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
PO Status
A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled |
13 | KK_TRAN_ID | Character(10) | VARCHAR2(10) NOT NULL | Commitment Control Foreign Key for Transaction Identification. |
14 | KK_TRAN_DT | Date(10) | DATE | Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID. |
15 | KK_SOURCE_TRAN | Character(10) | VARCHAR2(10) NOT NULL | Source Transaction Type |
16 | 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 |
17 | ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL | Entry Event |
18 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
19 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table: PO_KK_LEDGRP_VW |
20 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
21 | 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. |
22 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
23 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
24 | 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. |
25 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
26 | CLOSED_VALUE | Character(1) | VARCHAR2(1) NOT NULL | Closed Status field value |
27 | 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. |
28 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
29 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
30 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW |
31 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table: PRODUCT_BUGL_VW |
32 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table: FUND_BUGL_VW |
33 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL |
Class Field
Prompt Table: CLASSCF_BUGL_VW |
34 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW |
35 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table: BUD_REF_BUGL_VW |
36 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table: AFFILIATE_VW |
37 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01 |
38 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02 |
39 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table: CF1_BUGL_VW |
40 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW |
41 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW |
42 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
43 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
44 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
45 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
46 | BUDGET_PERIOD | Character(8) | VARCHAR2(8) NOT NULL | Budget Period |
47 | ENCUM_BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Encumbrance Balances |
48 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
49 | BALANCING_LINE | Character(1) | VARCHAR2(1) NOT NULL | Balancing Line |