POLNSHP_DIAG_VW

(SQL View)
 Index Back

SELECT BUSINESS_UNIT , PO_ID , LINE_NBR , SCHED_NBR , CANCEL_STATUS , BAL_STATUS , CHANGE_STATUS , CHNG_ORD_SEQ , PRICE_PO , PRICE_PO_BSE , CUSTOM_PRICE , ZERO_PRICE_IND , QTY_PO , CURRENCY_CD , MERCHANDISE_AMT , CURRENCY_CD_BASE , MERCH_AMT_BSE , CONVERSION_RATE , FREIGHT_TERMS , DISTRIB_MTHD_FLG , UNIT_PRC_TOL , UNIT_PRC_TOL_BSE , PCT_UNIT_PRC_TOL , EXT_PRC_TOL , EXT_PRC_TOL_BSE , PCT_EXT_PRC_TOL , QTY_RECV_TOL_PCT , PCT_UNDER_QTY , MATCH_STATUS_LN_PO , MATCH_LINE_OPT , SCHED_LINE_NBR , SUT_BASE_ID , TAX_CD_SUT , ULTIMATE_USE_CD , SUT_EXCPTN_TYPE , SUT_APPLICABILITY , VAT_TREATMENT_GRP , BUSINESS_UNIT_RTV , RTV_ID , RTV_LN_NBR , RTV_VERIFIED , SHIP_DATE , UNIT_PRC_TOL_L , PCT_UNIT_PRC_TOL_L , EXT_PRC_TOL_L , PCT_EXT_PRC_TOL_L , UNIT_PRC_TOL_BSE_L , EXT_PRC_TOL_BSE_L , RJCT_OVER_TOL_FLAG FROM PS_PO_LINE_SHIP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

Default Value: 1

5 CANCEL_STATUS Character(1) VARCHAR2(1) NOT NULL Cancel Status
A=Active
C=Closed
D=Denied
H=Hold
O=Open
P=Pending Approval
X=Canceled

Default Value: A

6 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

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

Default Value: U

8 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
9 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
10 PRICE_PO_BSE Signed Number(17,5) DECIMAL(15,5) NOT NULL Price Base
11 CUSTOM_PRICE Character(1) VARCHAR2(1) NOT NULL Custom Price - No Override

Y/N Table Edit

Default Value: N

12 ZERO_PRICE_IND Character(1) VARCHAR2(1) NOT NULL Zero Price Indicator

Y/N Table Edit

Default Value: N

13 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
15 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
16 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
17 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
18 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
19 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: FREIGHT_TERMS

20 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity

Default Value: Q

21 UNIT_PRC_TOL Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance
22 UNIT_PRC_TOL_BSE Number(14,5) DECIMAL(13,5) NOT NULL Base Unit Price Tolerance
23 PCT_UNIT_PRC_TOL Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance
24 EXT_PRC_TOL Number(14,5) DECIMAL(13,5) NOT NULL Ext Price Tolerance
25 EXT_PRC_TOL_BSE Number(14,5) DECIMAL(13,5) NOT NULL Base Ext Price Tolerance
26 PCT_EXT_PRC_TOL Number(6,2) DECIMAL(5,2) NOT NULL % Ext Price Tolerance
27 QTY_RECV_TOL_PCT Number(6,2) DECIMAL(5,2) NOT NULL Qty Rcvd Tolerance %
28 PCT_UNDER_QTY Signed Number(4,0) DECIMAL(3) NOT NULL Close PO Under Qty Pct Tol
29 MATCH_STATUS_LN_PO Character(1) VARCHAR2(1) NOT NULL Match Status PO
M=Matched
N=Not Matched
P=Partially Matched

Default Value: N

30 MATCH_LINE_OPT Character(1) VARCHAR2(1) NOT NULL Match Line Option
E=ERS
F=Full Match
N=Don't Match

Default Value: N

31 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
32 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination

Prompt Table: SUT_BASE_VW

33 TAX_CD_SUT Character(8) VARCHAR2(8) NOT NULL Tax Code - Sales and Use Tax

Prompt Table: %EDITTABLE10

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

Prompt Table: SUT_USE_CD

35 SUT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Exception Type
D=Direct Pay
E=Exempt/Exonerated
N=None
36 SUT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Applicability
D=Direct Pay
E=Item is Exempt
S=Sales Tax Applicable
U=Use Tax Applicable
X=Purchaser Is Exonerated

Default Value: E

37 VAT_TREATMENT_GRP Character(4) VARCHAR2(4) NOT NULL VAT Treatment Group
38 BUSINESS_UNIT_RTV Character(5) VARCHAR2(5) NOT NULL RTV Business Unit

Prompt Table: SP_BU_PM_NONVW

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

Prompt Table: PO_RTV_VW

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

Prompt Table: PO_RTV_LN_VW

41 RTV_VERIFIED Character(1) VARCHAR2(1) NOT NULL RTV Verified
42 SHIP_DATE Date(10) DATE Item Shipping Date
43 UNIT_PRC_TOL_L Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance - Under
44 PCT_UNIT_PRC_TOL_L Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance - Under
45 EXT_PRC_TOL_L Number(14,5) DECIMAL(13,5) NOT NULL Ext Price Tolerance - Under
46 PCT_EXT_PRC_TOL_L Number(6,2) DECIMAL(5,2) NOT NULL % Ext Price Tolerance - Under
47 UNIT_PRC_TOL_BSE_L Number(14,5) DECIMAL(13,5) NOT NULL Base Unit Price Tolerance
48 EXT_PRC_TOL_BSE_L Number(14,5) DECIMAL(13,5) NOT NULL Base Ext Price Tolrnc - Under
49 RJCT_OVER_TOL_FLAG Character(1) VARCHAR2(1) NOT NULL Reject Qty Over Tolerance

Y/N Table Edit