BUSINESS_UNITPrompt Table: SP_BUIN_NONVW
EIP_CTL_IDGRP_SEQ_NBRDTL_SEQ_NBR0=Open
1=Error
2=Complete
3=Cancel
Default Value: 0
INV_MSR_DUD_VW(SQL View) |
Index Back |
|---|---|
Create Stock Request DetailDetail-level view for "Create Stock Request" BCT transaction, used in Transaction Maintenance |
| SELECT A.BUSINESS_UNIT , A.EIP_CTL_ID , A.GRP_SEQ_NBR , A.DTL_SEQ_NBR , A.BCT_DET_STATUS , A.EIP_TRANS_SRC_SEQ , %subrec(IN_DMD_USER_SBR, A) FROM %Table(INV_FUL_DTL_EC) A |
| # | 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 | EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 3 | GRP_SEQ_NBR |
Number(10,0) | DECIMAL(10) NOT NULL | Sequence used to uniquely identify a row in the Fulfillment Group stage table. |
| 4 | DTL_SEQ_NBR |
Number(10,0) | DECIMAL(10) NOT NULL | Sequence used to uniquely identify a row in the Fulfillment Details stage table. |
| 5 | BCT_DET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
BCTP Detail Status
0=Open 1=Error 2=Complete 3=Cancel Default Value: 0 |
| 6 | EIP_TRANS_SRC_SEQ | Number(15,0) | DECIMAL(15) NOT NULL | Source Transaction Sequence |
| 7 | LINE_FIELD_C1_A | Character(1) | VARCHAR2(1) NOT NULL | User Defined C1 A |
| 8 | LINE_FIELD_C1_B | Character(1) | VARCHAR2(1) NOT NULL | User Defined C1 B |
| 9 | LINE_FIELD_C1_C | Character(1) | VARCHAR2(1) NOT NULL | User Defined C1 C |
| 10 | LINE_FIELD_C1_D | Character(1) | VARCHAR2(1) NOT NULL | User Defined C1 D |
| 11 | LINE_FIELD_C2 | Character(2) | VARCHAR2(2) NOT NULL | User Defined C2 |
| 12 | LINE_FIELD_C4 | Character(4) | VARCHAR2(4) NOT NULL | User Defined C4 |
| 13 | LINE_FIELD_C6 | Character(6) | VARCHAR2(6) NOT NULL | User Defined C6 |
| 14 | LINE_FIELD_C8 | Character(8) | VARCHAR2(8) NOT NULL | User Defined C8 |
| 15 | LINE_FIELD_C10_A | Character(10) | VARCHAR2(10) NOT NULL | User Defined C10 A |
| 16 | LINE_FIELD_C10_B | Character(10) | VARCHAR2(10) NOT NULL | User Defined C10 B |
| 17 | LINE_FIELD_C10_C | Character(10) | VARCHAR2(10) NOT NULL | User Defined C10 C |
| 18 | LINE_FIELD_C10_D | Character(10) | VARCHAR2(10) NOT NULL | Line Fld C10 D |
| 19 | LINE_FIELD_C30_A | Character(30) | VARCHAR2(30) NOT NULL | User Defined C30 A |
| 20 | LINE_FIELD_C30_B | Character(30) | VARCHAR2(30) NOT NULL | User Defined C30 B |
| 21 | LINE_FIELD_C30_C | Character(30) | VARCHAR2(30) NOT NULL | User Defined C30 C |
| 22 | LINE_FIELD_C30_D | Character(30) | VARCHAR2(30) NOT NULL | User Defined C30 D |
| 23 | LINE_FIELD_DTTM_A | DateTime(26) | TIMESTAMP | User Defined DTTM A |
| 24 | LINE_FIELD_DTTM_B | DateTime(26) | TIMESTAMP | User Defined DTTM B |
| 25 | LINE_FIELD_DTTM_C | DateTime(26) | TIMESTAMP | User Defined DTTM C |
| 26 | LINE_FIELD_DTTM_D | DateTime(26) | TIMESTAMP | User Defined DTTM D |
| 27 | LINE_FIELD_N11_A | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | User Defined N11.4 A |
| 28 | LINE_FIELD_N11_B | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | User Defined N11.4 B |
| 29 | LINE_FIELD_N11_C | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | User Defined N11.4 C |
| 30 | LINE_FIELD_N11_D | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | User Defined N11.4 D |
| 31 | LINE_FIELD_N15_A | Number(15,0) | DECIMAL(15) NOT NULL | User Defined N15.0 A |
| 32 | LINE_FIELD_N15_B | Number(15,0) | DECIMAL(15) NOT NULL | User Defined N15.0 B |
| 33 | LINE_FIELD_N15_C | Number(15,0) | DECIMAL(15) NOT NULL | User Defined N15.0 C |
| 34 | LINE_FIELD_N15_D | Number(15,0) | DECIMAL(15) NOT NULL | User Defined N15.0 D |