PV_REQ_SHIP_VW

(SQL View)
Index Back

Requisition Line Delivery Schd

Requisition Line Schedule Date Initials Issue Description 092107 dh F-AHAYT-95051 PRICE_REQ for ePro change from number to Sign to allow negative

SELECT A.BUSINESS_UNIT , A.REQ_ID , A.LINE_NBR , A.SCHED_NBR , A.DUE_DT , A.SHIPTO_SETID , A.SHIPTO_ID , A.QTY_REQ , A.MERCHANDISE_AMT , A.DISTRIB_MTHD_FLG , A.LIQUIDATE_METHOD , A.PRICE_REQ , A.BAL_STATUS , A.BUSINESS_UNIT_OM , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.SHIP_TO_CUST_ID , A.CURRENCY_CD , A.CURRENCY_CD_BASE , A.PRICE_REQ_BSE , A.MERCH_AMT_BSE , A.QTY_REQ_STD , A.SHIP_TYPE_ID , A.CARRIER_ID , A.UNIT_MEASURE_STD , A.DUE_TIME , A.ZERO_PRICE_IND , A.SUT_BASE_ID , A.ULTIMATE_USE_CD , A.REVISION , A.CHANGE_STATUS , A.CHNG_ORD_SEQ , A.CURR_STATUS , A.ATTN_TO , A.FREIGHT_TERMS , %subrec(PUR_USR_SHP_SBR, A) ,B.UNIT_OF_MEASURE FROM PS_REQ_LINE_SHIP A , PS_REQ_LINE B WHERE B.BUSINESS_UNIT=A.BUSINESS_UNIT AND B.REQ_ID=A.REQ_ID AND B.LINE_NBR=A.LINE_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

Default Value: NEXT

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Default Value: 1

4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

Default Value: 1

5 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
6 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
7 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: %EDIT_SHIPTO

8 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
9 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
10 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity

Default Value: Q

11 LIQUIDATE_METHOD Character(1) VARCHAR2(1) NOT NULL Liquidate by
A=Amount
Q=Quantity

Default Value: A

12 PRICE_REQ Signed Number(17,5) DECIMAL(15,5) NOT NULL Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
13 BAL_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not the control totals for a deposit match the entered totals. A deposit is considered "balanced" when the two sets of totals are equal.
I=Balanced
O=Not Balanced

Default Value: I

14 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
15 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
16 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
17 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
18 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
19 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: REQ_HDR.CURRENCY_CD

20 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

Default Value: REQ_HDR.CURRENCY_CD_BASE

21 PRICE_REQ_BSE Signed Number(17,5) DECIMAL(15,5) NOT NULL Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
22 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
23 QTY_REQ_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Requested Stand. UOM
24 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
25 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
26 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
27 DUE_TIME Time(15) TIMESTAMP Due Time
28 ZERO_PRICE_IND Character(1) VARCHAR2(1) NOT NULL Zero Price Indicator

Y/N Table Edit

Default Value: N

29 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination

Prompt Table: SUT_BASE_VW

30 ULTIMATE_USE_CD Character(8) VARCHAR2(8) NOT NULL Ultimate Use Code

Prompt Table: SUT_USE_CD

31 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label

Prompt Table: EN_REV_PO_VW

32 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
C=Changed
U=Unchanged

Default Value: U

33 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
34 CURR_STATUS Character(1) VARCHAR2(1) NOT NULL Current Status
A=Approved
C=Closed
D=Denied
H=Hold
O=Open
P=Pending
X=Canceled

Default Value: A

35 ATTN_TO Character(30) VARCHAR2(30) NOT NULL Attention
36 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
37 USER_SCHED_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
38 CUSTOM_C100_C1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
39 CUSTOM_C100_C2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
40 CUSTOM_C100_C3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
41 CUSTOM_DATE_C1 Date(10) DATE Custom Date 1
42 CUSTOM_DATE_C2 Date(10) DATE Custom Date 2
43 CUSTOM_C1_C Character(1) VARCHAR2(1) NOT NULL Custom Character 2
44 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage