VCHR_ACT_LN_VW(SQL View) |
Index Back |
---|---|
Line View of Accounting Line |
SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.UNPOST_SEQ , A.APPL_JRNL_ID , A.PYMNT_CNT , A.VOUCHER_LINE_NUM , A.DISTRIB_LINE_NUM , A.DST_ACCT_TYPE , 'DST' , A.CF_BAL_LINE_NUM , A.LEDGER , A.LEDGER_GROUP , A.ACCOUNTING_DT , A.GL_DISTRIB_STATUS , A.BUDGET_LINE_STATUS , A.CLOSE_STATUS , A.BUDGET_DT , A.KK_TRAN_OVER_FLAG , A.KK_TRAN_OVER_OPRID , A.KK_TRAN_OVER_DTTM , A.BUSINESS_UNIT_GL , A.CURRENCY_CD , A.MONETARY_AMOUNT , A.FOREIGN_CURRENCY , A.FOREIGN_AMOUNT , A.QTY_VCHR , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(CF15_AN_SBR, A) , A.PROJECT_ID , A.ACTIVITY_ID , A.RESOURCE_TYPE , A.BUSINESS_UNIT_PC , A.BUSINESS_UNIT_PO , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.PO_DIST_LINE_NUM , A.KK_PROCESS_PRIOR , A.QTY_VCHR_STD , A.ENTRY_EVENT FROM PS_VCHR_ACCTG_LINE A WHERE A.BUDGET_HDR_STATUS <> 'V' AND A.BUDGET_LINE_STATUS IN ('N', 'E') AND A.DST_ACCT_TYPE NOT IN ('APA','IUP','DSE') AND A.PRIMARY_LEDGER = 'Y' AND A.POSTING_PROCESS <> 'ACAV' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
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 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Payments |
6 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
7 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
8 | 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 |
9 | DST_ACCT_TYPE2 | Character(4) | VARCHAR2(4) NOT NULL | 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 | CF_BAL_LINE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Chart Field Balancing Line Num |
11 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
12 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
13 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
14 | 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 |
15 | 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 |
16 | CLOSE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Close Status Indicator
C=Closed O=Open |
17 | BUDGET_DT | Date(10) | DATE | Budget Date |
18 | KK_TRAN_OVER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control source transaction override flag
N=No Y=Yes |
19 | KK_TRAN_OVER_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Commitment Control source transaction override operator |
20 | KK_TRAN_OVER_DTTM | DateTime(26) | TIMESTAMP | Commitment Control source transaction override datetime |
21 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
22 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
23 | 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. |
24 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
25 | 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. |
26 | QTY_VCHR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered |
27 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
28 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
29 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPTID_BUGL_VW |
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 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
43 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
44 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
45 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
46 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
47 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
48 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
49 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
50 | PO_DIST_LINE_NUM | Number(5,0) | INTEGER NOT NULL | PO Distribution Line Number |
51 | KK_PROCESS_PRIOR | Character(1) | VARCHAR2(1) NOT NULL | Process Prior Document |
52 | QTY_VCHR_STD | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered in STD UOM |
53 | ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL | Entry Event |