INV_MSR_DTL_VW

(SQL View)
 Index Back

Create Stock Request Detail

Detail-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 , A.DEVICE_DTTIME , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.INV_ITEM_ID , A.DEMAND_DATE , A.REQUEST_DATE , A.SCHED_DATE , A.SCHED_TIME , A.LOAD_ID , A.CARRIER_ID , A.SHIP_TYPE_ID , A.SHIP_EARLY_DATE , A.SHIP_EARLY_TIME , A.SHIP_LATE_DATE , A.SHIP_LATE_TIME , A.SCHED_ARRV_DATE , A.SCHED_ARRV_TIME , A.FREIGHT_TERMS , A.PRIORITY_NBR , A.DISTRIB_TYPE , A.CHARGE_FLAG , A.FERC_CD , A.PRICE_MARKUP_PCT , A.TRANSFER_CALC_TYPE , A.LOCATION , A.CUST_ID , A.CUST_NAME , A.SHIP_TO_CUST_ID , A.SHIP_CUST_NAME1 , A.ADDRESS_SEQ_NUM , A.TRANSFER_COST , A.PACKAGING_CD , A.QTY , A.BCKORDR_CNCL_FLAG , A.PARTIAL_QTY_FLAG , A.IN_LINE_BO_RULE , A.IN_LINE_RESV_RULE , A.IN_LN_RESV_BO_RULE , A.IN_ORDER_RESV_RULE , A.UNIT_OF_MEASURE , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.CONFIG_CODE , A.DIRECT_INVOICING , A.BUSINESS_UNIT_PO , A.RTV_ID , A.RTV_LN_NBR , A.RTV_DISTRIB_NUM , A.HOLD_FLAG , A.HOLD_CD , A.ROUTE_CD , A.REPLACEMENT_FLG , A.IST_RETURN_FLG_IUT , A.REASON_CD , %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 DEVICE_DTTIME DateTime(26) TIMESTAMP Device Date Time

Default Value: %Datetime

8 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
9 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
10 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE

11 DEMAND_DATE Date(10) DATE Demand Date
12 REQUEST_DATE Date(10) DATE Requested
13 SCHED_DATE Date(10) DATE Schedule Date
14 SCHED_TIME Time(15) TIMESTAMP Schedule Time
15 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

Prompt Table: LOAD_INV_OPN_VW

16 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

Prompt Table: CARRIER_VW

17 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: SHIP_METHOD_VW

18 SHIP_EARLY_DATE Date(10) DATE Earliest Ship Date
19 SHIP_EARLY_TIME Time(15) TIMESTAMP Earliest Ship Time
20 SHIP_LATE_DATE Date(10) DATE Latest Ship Date
21 SHIP_LATE_TIME Time(15) TIMESTAMP Latest Ship Time
22 SCHED_ARRV_DATE Date(10) DATE Scheduled Arrival Date
23 SCHED_ARRV_TIME Time(15) TIMESTAMP Scheduled Arrival Time
24 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: FREIGHT_TERMS

25 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
26 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

Prompt Table: CM_DISTR_TYPE

27 CHARGE_FLAG Character(1) VARCHAR2(1) NOT NULL Charged Out

Y/N Table Edit

28 FERC_CD Character(10) VARCHAR2(10) NOT NULL FERC Code

Prompt Table: FERC_CD_TBL

29 PRICE_MARKUP_PCT Signed Number(16,2) DECIMAL(14,2) NOT NULL Price Markup %
30 TRANSFER_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Holds information regarding when the transfer price is calculated.
0=Calculate Cost at Depletions
1=Transfer at Zero Cost
31 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: %EDITTABLE2

32 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

Prompt Table: %EDITTABLE3

33 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name
34 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: %EDITTABLE4

35 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
36 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

Prompt Table: INV_CST_ADR2_VW

37 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price
38 PACKAGING_CD Character(4) VARCHAR2(4) NOT NULL Packaging Code

Prompt Table: PACKAGNG_CD_INV

39 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
40 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
41 PARTIAL_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Qtys Can Ship

Y/N Table Edit

42 IN_LINE_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Backorder Rule

Prompt Table: IN_RULE_B_VW

43 IN_LINE_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation Rule

Prompt Table: IN_RULE_R_VW

44 IN_LN_RESV_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation - Backorder

Prompt Table: IN_RULE_R_VW

45 IN_ORDER_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Order Reservation Rule

Prompt Table: IN_RULE_O_VW

46 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: INV_ORDR_UOM_VW

47 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: STOR_AREA_VW2

48 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1

Prompt Table: STOR_LEV1_VW2

49 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2

Prompt Table: STOR_LEV2_VW2

50 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3

Prompt Table: STOR_LEV3_VW2

51 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4

Prompt Table: STOR_LEV4_VW2

52 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: CP_CONFIG_VW

53 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing

Y/N Table Edit

54 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

Prompt Table: SP_BU_PM_NONVW

55 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID

Prompt Table: RTV_HDR_INV_VW

56 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line

Prompt Table: RTV_LN_INV_VW

57 RTV_DISTRIB_NUM Number(5,0) INTEGER NOT NULL RTV Distribution Number

Prompt Table: RTV_DIST_INV_VW

58 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold
59 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code

Prompt Table: HOLD_CD

60 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.

Prompt Table: ROUTE_INV_VW

61 REPLACEMENT_FLG Character(2) VARCHAR2(2) NOT NULL Replacement Flag
NA=Not Applicable
RN=Replace Goods Not Returned
RR=Replacement of Returned Goods
62 IST_RETURN_FLG_IUT Character(1) VARCHAR2(1) NOT NULL Intrastat InterUnit Returns

Y/N Table Edit

63 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

Prompt Table: REASON_SHIP_VW

64 LINE_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL User Defined C1 A
65 LINE_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL User Defined C1 B
66 LINE_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL User Defined C1 C
67 LINE_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL User Defined C1 D
68 LINE_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL User Defined C2
69 LINE_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL User Defined C4
70 LINE_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL User Defined C6
71 LINE_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL User Defined C8
72 LINE_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL User Defined C10 A
73 LINE_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL User Defined C10 B
74 LINE_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL User Defined C10 C
75 LINE_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Line Fld C10 D
76 LINE_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User Defined C30 A
77 LINE_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User Defined C30 B
78 LINE_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User Defined C30 C
79 LINE_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User Defined C30 D
80 LINE_FIELD_DTTM_A DateTime(26) TIMESTAMP User Defined DTTM A
81 LINE_FIELD_DTTM_B DateTime(26) TIMESTAMP User Defined DTTM B
82 LINE_FIELD_DTTM_C DateTime(26) TIMESTAMP User Defined DTTM C
83 LINE_FIELD_DTTM_D DateTime(26) TIMESTAMP User Defined DTTM D
84 LINE_FIELD_N11_A Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 A
85 LINE_FIELD_N11_B Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 B
86 LINE_FIELD_N11_C Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 C
87 LINE_FIELD_N11_D Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 D
88 LINE_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 A
89 LINE_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 B
90 LINE_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 C
91 LINE_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 D