CM_CST_WOR_VW

(SQL View)
 Index Back

SELECT B.BUSINESS_UNIT , B.INV_ITEM_ID , B.CM_BOOK , B.DT_TIMESTAMP , B.SEQ_NBR , B.CM_DT_TIMESTAMP , B.CM_SEQ_NBR , B.CM_DT_TIMESTAMP_A , B.CM_SEQ_NBR_A , B.COST_ELEMENT , B.CM_SEQ_COST , A.STORAGE_AREA , B.QTY_BASE , B.CM_UNIT_COST , B.UNIT_MEASURE_STD , A.DISTRIB_TYPE , A.BUDGET_DT , B.POSTED_FLAG , B.PROCESS_INSTANCE , B.TRANSACTION_GROUP , G.BUSINESS_UNIT_GL , G.BASE_CURRENCY , G.APPL_JRNL_ID , A.TRANSACTION_DATE , A.ACCOUNT , A.ALTACCT , A.DEPTID , A.TRANSACTION_SOURCE , A.BUSINESS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.DEMAND_LINE_NO , %subrec(CF16_AN_SBR,A) , %subrec(PC_CF1_N_SBR,A) FROM PS_TRANSACTION_INV A , PS_CM_DEPLETE_COST B , PS_BUS_UNIT_TBL_IN G WHERE %Join(COMMON_KEYS, TRANSACTION_INV A, CM_DEPLETE_COST B) AND %Join(COMMON_KEYS, TRANSACTION_INV A, BUS_UNIT_TBL_IN G) AND B.POSTED_FLAG = 'N' AND B.TRANSACTION_GROUP = '231' AND A.ADJUST_TYPE ='I' AND B.CM_COST_MODE = 'L'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
4 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
6 CM_DT_TIMESTAMP DateTime(26) TIMESTAMP Receipt dttm.
7 CM_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
8 CM_DT_TIMESTAMP_A DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
9 CM_SEQ_NBR_A Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:
10 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
11 CM_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.
12 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
13 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
14 CE_EXTENDED_COST Signed Number(32,15) DECIMAL(30,15) NOT NULL Extended Cost
15 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
16 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
17 BUDGET_DT Date(10) DATE Budget Date
18 POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted
X=Don't Post
Y=Posted
19 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
20 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
21 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
22 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
23 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
24 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
25 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
26 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
27 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
28 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
29 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
30 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
31 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
32 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
33 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

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

Prompt Table: %EDIT_BU_PC

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

Prompt Table: %EDIT_PROJECT

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

Prompt Table: %EDIT_ACTIVITY

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

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC