BUSINESS_UNITPrompt Table: SP_BUIN_NONVW
EIP_CTL_IDSEQ_NBRDefault Value: %Datetime
0=Open
1=Error
2=Complete
3=Cancel
Default Value: 0
10=Request
20=Order
30=Line
INV_MSR_HDR_VW(SQL View) |
Index Back |
|---|---|
Create Stock Request HeaderHeader-level view for "Create Stock Request" BCT transaction, used in Transaction Maintenance |
| SELECT A.BUSINESS_UNIT , A.EIP_CTL_ID , A.SEQ_NBR , A.TRANSACTION_CODE , A.LAST_DTTIME , A.BCT_DET_STATUS , A.EIP_TRANS_SRC_SEQ , A.PASS_THROUGH_LEVEL FROM %Table(BCT_DTL) 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 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 4 | TRANSACTION_CODE | Character(4) | VARCHAR2(4) NOT NULL | Transaction Code |
| 5 | LAST_DTTIME | DateTime(26) | TIMESTAMP NOT NULL |
Last Date Time
Default Value: %Datetime |
| 6 | BCT_DET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
BCTP Detail Status
0=Open 1=Error 2=Complete 3=Cancel Default Value: 0 |
| 7 | EIP_TRANS_SRC_SEQ | Number(15,0) | DECIMAL(15) NOT NULL | Source Transaction Sequence |
| 8 | PASS_THROUGH_LEVEL | Character(2) | VARCHAR2(2) NOT NULL |
Provides the ability to pass good transactions through the system while holding up transactions that need additional review. When processing, the Pass-through Level must be less than or equal to Processing Level and Commit Level. If the process recieves a Pass-through Level greater than the specified Commit Level or Processing Level, the Commit Group and/or Processing Group will be expanded to include all data at the Pass-through Level.
10=Request 20=Order 30=Line |