INV_FRT_HUP_VW

(SQL View)
 Index Back

Create Stock Request Header

Header-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.DELIVERY_ID , A.FRT_ROLLUP_IND_RUN , A.MANIFEST_FLG , A.RESPONSE_CODE , A.RESPONSE_DESCR , A.ERROR_CODE , A.ERRORMSG , A.EIP_TRANS_SRC_SEQ , A.DEVICE_DTTIME , A.COUNTING_EVENT_ID FROM PS_BCT_DTL A WHERE A.TRANSACTION_CODE = '0380'

# 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 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
8 FRT_ROLLUP_IND_RUN Character(1) VARCHAR2(1) NOT NULL Indicates to batch run how the freight will be rolled up.
1=Delivery Freight
2=Rollup Packages/Containers
3=Default from Delivery
9 MANIFEST_FLG Character(1) VARCHAR2(1) NOT NULL Manifest

Y/N Table Edit

10 RESPONSE_CODE Character(10) VARCHAR2(10) NOT NULL Response Status Code
11 RESPONSE_DESCR Character(254) VARCHAR2(254) NOT NULL Response Status Description
12 ERROR_CODE Character(10) VARCHAR2(10) NOT NULL Error Code
13 ERRORMSG Character(254) VARCHAR2(254) NOT NULL Error Message field
14 EIP_TRANS_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Source Transaction Sequence
15 DEVICE_DTTIME DateTime(26) TIMESTAMP Device Date Time
16 COUNTING_EVENT_ID Number(15,0) DECIMAL(15) NOT NULL Counting Event ID