COUNT_INV_H_EVW

(SQL View)
 Index Back

Physical/Cycle Count Header


SELECT DISTINCT A.BUSINESS_UNIT , A.COUNTING_EVENT_ID , B.GROUP_ID_SEQ_NUM , A.COUNT_HDR_STATUS , A.MAX_ITEMS , A.NO_RECORDS , A.NO_RECS_POSTED , A.BLIND_COUNT , A.CANCEL_UNPROCESSED , A.COUNT_TYPE , A.DUE_TO_COUNT , A.CYCLE_COUNT_OPT , A.ZERO_QTY_CNT_OPT , ' ' , ' ' , A.COUNT_START_DT , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , %DateTimeNull , %DateTimeNull , %DateTimeNull , %DateTimeNull , ' ' , ' ' , ' ' , 0 , ' ' FROM PS_COUNT_HDR_INV A , PS_COUNT_INV B WHERE %Join(COMMON_KEYS, COUNT_HDR_INV A, COUNT_INV B)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUIN_NONVW

2 COUNTING_EVENT_ID Number(15,0) DECIMAL(15) NOT NULL Counting Event ID
3 GROUP_ID_SEQ_NUM Number(15,0) DECIMAL(15) NOT NULL Group ID
4 COUNT_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Count Header Status
1=Open
2=Finished
3=Canceled

Default Value: 1

5 MAX_ITEMS Number(6,0) INTEGER NOT NULL Maximum Items to Select
6 NO_RECORDS Signed Number(9,0) DECIMAL(8) NOT NULL Number of Records
7 NO_RECS_POSTED Signed Number(9,0) DECIMAL(8) NOT NULL Number Updated Stock Qty
8 BLIND_COUNT Character(1) VARCHAR2(1) NOT NULL Blind Count

Y/N Table Edit

Default Value: Y

9 CANCEL_UNPROCESSED Character(1) VARCHAR2(1) NOT NULL Cancel Unprocessed Items

Y/N Table Edit

10 COUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Count Options
C=Cycle Count
M=Manual Count
P=Physical Inventory
11 DUE_TO_COUNT Character(1) VARCHAR2(1) NOT NULL Due to Count

Y/N Table Edit

12 CYCLE_COUNT_OPT Character(1) VARCHAR2(1) NOT NULL Cycle Count Option
1=Manual Count
2=Due To Count
3=Item ID
4=Family
5=Storage Location
6=Negative Balance
7=Due To Count by Storage Loc
13 ZERO_QTY_CNT_OPT Character(1) VARCHAR2(1) NOT NULL Zero Quantity Option
1=Include All
2=Exclude Zero Quantity
3=Include Zero Quantity
14 ACTION Character(3) VARCHAR2(3) NOT NULL Action
15 COUNT_OPTION Character(3) VARCHAR2(3) NOT NULL Count Option
01=Enter Par Location Count
02=Update Par Location Count
16 COUNT_START_DT Date(10) DATE Count Start Date
17 FLEX_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL Flex Field Char 30 A
18 FLEX_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL Flex Field Char 30 B
19 FLEX_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL Flex Field Char 30 C
20 FLEX_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL Flex Field Char 30 D
21 FLEX_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL Flex Field Char 1 A
22 FLEX_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL Flex Field Char 1 B
23 FLEX_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL Flex Field Char 1 C
24 FLEX_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL Flex Field Char 1 D
25 FLEX_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL Flex Field Char 10 A
26 FLEX_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL Flex Field Char 10 B
27 FLEX_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL Flex Field Char 10 C
28 FLEX_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Flex Field Char 10 D
29 FLEX_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL Flex Field Char 2
30 FLEX_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL Flex Field Char 4
31 FLEX_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL Flex Field Char 6
32 FLEX_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL Flex Field Char 8
33 FLEX_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL Flex Field Numeric 12 A
34 FLEX_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL Flex Field Numeric 12 B
35 FLEX_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL Flex Field Numeric 12 C
36 FLEX_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL Flex Field Numeric 12 D
37 FLEX_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL Flex Field Numeric 15 A
38 FLEX_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL Flex Field Numeric 15 B
39 FLEX_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL Flex Field Numeric 15 C
40 FLEX_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL Flex Field Numeric 15 D
41 FLEX_FIELD_S15_A Signed Number(32,15) DECIMAL(30,15) NOT NULL Flex Field Signed 15.15 A
42 FLEX_FIELD_S15_B Signed Number(32,15) DECIMAL(30,15) NOT NULL Flex Field Signed 15.15 B
43 FLEX_FIELD_S15_C Signed Number(32,15) DECIMAL(30,15) NOT NULL Flex Field Signed 15.15 C
44 FLEX_FIELD_S15_D Signed Number(32,15) DECIMAL(30,15) NOT NULL Flex Field Signed 15.15 D
45 FLEX_FIELD_DT_A DateTime(26) TIMESTAMP Flex Field Datetime A
46 FLEX_FIELD_DT_B DateTime(26) TIMESTAMP Flex Field Datetime B
47 FLEX_FIELD_DT_C DateTime(26) TIMESTAMP Flex Field Datetime C
48 FLEX_FIELD_DT_D DateTime(26) TIMESTAMP Flex Field Datetime D
49 GROUPBOX Character(1) VARCHAR2(1) NOT NULL Groupbox
50 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
51 MESSAGE_TEXT_LONG Long Character CLOB Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
52 RETURN_CODE Signed Number(5,0) DECIMAL(4) NOT NULL Return Code
53 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).