CM_NP_ACCTLN_VW(SQL View) |
Index Back |
|---|---|
Acctg Lines Pending GL Distib |
| SELECT BUSINESS_UNIT , CM_BOOK , ACCOUNTING_DT , TRANSACTION_GROUP , ACCTG_LINE_NO , DISTRIB_TYPE , COST_ELEMENT , INV_ITEM_ID , GL_DISTRIB_STATUS , APPL_JRNL_ID , LEDGER , LEDGER_GROUP , BUDGET_HDR_STATUS , BUDGET_LINE_STATUS , BUDGET_DT FROM PS_CM_ACCTG_LINE WHERE GL_DISTRIB_STATUS <> 'D' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUIN_NONVW |
| 2 | CM_BOOK | Character(10) | VARCHAR2(10) NOT NULL | Cost Book |
| 3 | ACCOUNTING_DT |
Date(10) | DATE NOT NULL | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 4 | TRANSACTION_GROUP |
Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 5 | ACCTG_LINE_NO |
Number(15,0) | DECIMAL(15) NOT NULL | Accounting Line Number |
| 6 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Distrib. Type
Prompt Table: CM_DISTR_TYPE |
| 7 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table: CM_ELEMENT |
| 8 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 9 | 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 |
| 10 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 11 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 12 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 13 | BUDGET_HDR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid |
| 14 | 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 |
| 15 | BUDGET_DT | Date(10) | DATE | Budget Date |