BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW
GROUP_ID_SEQ_NUMMIN_CNT_H_VW2(SQL View) |
Index Back |
|---|---|
Physical/Cycle Count Header |
| SELECT DISTINCT A.BUSINESS_UNIT , B.GROUP_ID_SEQ_NUM , A.COUNTING_EVENT_ID , A.COUNT_START_DT FROM PS_COUNT_HDR_INV A , PS_COUNT_INV B , PS_BUS_UNIT_TBL_IN C WHERE %Join(COMMON_KEYS, COUNT_HDR_INV A, COUNT_INV B) AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND COUNT_HDR_STATUS = '1' AND C.BU_STATUS = '1' |
| # | 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 | GROUP_ID_SEQ_NUM |
Number(15,0) | DECIMAL(15) NOT NULL | Group ID |
| 3 | COUNTING_EVENT_ID | Number(15,0) | DECIMAL(15) NOT NULL | Counting Event ID |
| 4 | COUNT_START_DT | Date(10) | DATE | Count Start Date |