INV_RSV_HDR_VW

(SQL View)
 Index Back

Update Fulfillment Requests

BCT_DTL view used to maintain fulfillment request transactions.

SELECT BUSINESS_UNIT , EIP_CTL_ID , SEQ_NBR , TRANSACTION_CODE , LAST_DTTIME , BCT_DET_STATUS , EIP_TRANS_SRC_SEQ , PASS_THROUGH_LEVEL , AUTO_PICK_SEL , AUTO_SHIP_SEL , LEAD_DAYS , USE_LEAD_DAYS , RSV_AUTO_REL_OPT , RLS_RUN_CNTL_ID FROM PS_BCT_DTL

# 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
9 AUTO_PICK_SEL Character(1) VARCHAR2(1) NOT NULL The field is used to select the auto pick options for fulfillment.
0=Use Default Values
1=Override to "Yes"
2=Override to "No"

Default Value: 0

10 AUTO_SHIP_SEL Character(1) VARCHAR2(1) NOT NULL Used to capture the auto ship options for fulfillment.
0=Use Default Values
1=Override to "Yes"
2=Override to "No"

Default Value: 0

11 LEAD_DAYS Number(4,0) SMALLINT NOT NULL Lead Days for Calendar
12 USE_LEAD_DAYS Character(1) VARCHAR2(1) NOT NULL Use Lead Days
1=Use Fulfillment Lead Days
2=Override Fulfillment Lead Days
3=Ignore Lead Days

Default Value: 1

13 RSV_AUTO_REL_OPT Character(1) VARCHAR2(1) NOT NULL The field is used to select the auto pick options for fulfillment.
0=Use Default Values
1=Override to "Yes"
2=Override to "No"
14 RLS_RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

Prompt Table: RLS_RUN_CNTL_VW