CS_CNT_LINE_VW

(SQL View)
Index Back

Contract Line Mappings

Bind Mapping view for Contracts

SELECT A.SETID ,A.CNTRCT_ID ,A.VERSION_NBR ,A.CNTRCT_LINE_NBR ,A.LINE_STATUS ,A.ITM_SETID ,A.INV_ITEM_ID ,A.DESCR254_MIXED ,A.ITM_ID_VNDR ,A.VNDR_CATALOG_ID ,A.CATEGORY_ID ,A.MFG_ID ,A.QTY_LINE_MIN ,A.QTY_LINE_MAX ,B.QTY_LINE_RELEASED ,A.QTY_LINE_RELSD_CUM ,A.AMT_LINE_MIN ,A.AMT_LINE_MAX ,B.AMT_LINE_RELEASED ,A.AMT_LINE_RELSD_CUM ,A.INCLUDE_FOR_RELS ,A.LINE_PRICE_TYPE ,A.USE_CNTRCT_BASE ,A.PRICE_UOM_ADJ ,A.PRICE_SHIPTO_ADJ ,A.ADJ_BEFORE ,A.QTY_TYPE ,A.PRICE_DT_TYPE ,A.PRICE_CAN_CHANGE ,A.UNIT_OF_MEASURE ,A.MERCHANDISE_AMT ,A.TOTAL_DISTRIBS ,A.MAX_DISTRIB_LINE ,A.STATISTIC_AMOUNT ,A.UNIT_PRICE ,A.TAX_CD ,A.DSCNT_APPL_FLG ,A.FRGHT_PRORATE_FLG ,A.CURRENCY_CD ,A.RFQ_ID ,A.RFQ_LINE_NBR ,A.PHYSICAL_NATURE ,A.VAT_RECOVERY_PCT ,A.WTHD_SETID ,A.WTHD_SW ,A.WTHD_CD ,A.SHIPTO_ID ,A.SUT_BASE_ID ,A.TAX_CD_SUT ,A.SUT_EXCPTN_TYPE ,A.SUT_EXCPTN_CERTIF ,A.SUT_APPLICABILITY ,A.AMT_ONLY_FLG ,A.RETENTION_CD ,A.RETENTION_PCT ,A.RETENTION_AMT ,A.MFG_ITM_ID ,A.ULTIMATE_USE_CD ,A.CNTRCT_LN_TYPE ,A.CNTR_LN_TYPE_ID ,%subrec(PUR_USR_LIN_SBR, A) ,%subrec(LAST_UPDATE_SBR, A) FROM PS_CNTRCT_LINE A , PS_CNTRCT_LIN_RLS B WHERE A.LINE_STATUS NOT IN ('C','I') AND B.SETID = A.SETID AND B.CNTRCT_ID = A.CNTRCT_ID AND B.CNTRCT_LINE_NBR = A.CNTRCT_LINE_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
4 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr

Default Value: 1

5 LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
A=Active
C=Cancelled
I=Inactive
O=Open
P=Pending

Default Value: O

6 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE13

8 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
9 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
10 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
11 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

Prompt Table: %EDITTABLE14
Set Control Field: SETID

12 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

Prompt Table: MANUFACTURER

13 QTY_LINE_MIN Number(15,2) DECIMAL(14,2) NOT NULL Min Line Qty Per Order
14 QTY_LINE_MAX Number(15,2) DECIMAL(14,2) NOT NULL Max Line Qty Per Contract
15 QTY_LINE_RELEASED Number(15,2) DECIMAL(14,2) NOT NULL Total Line Qty Released
16 QTY_LINE_RELSD_CUM Number(15,2) DECIMAL(14,2) NOT NULL Cumulative Line Qty Released
17 AMT_LINE_MIN Number(27,3) DECIMAL(26,3) NOT NULL Min Line Amt Per Order
18 AMT_LINE_MAX Number(27,3) DECIMAL(26,3) NOT NULL Max Line Amt Per Contract
19 AMT_LINE_RELEASED Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Line Amt Released
20 AMT_LINE_RELSD_CUM Signed Number(28,3) DECIMAL(26,3) NOT NULL Cumulative Line Amt Released
21 INCLUDE_FOR_RELS Character(1) VARCHAR2(1) NOT NULL Include for Release
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

22 LINE_PRICE_TYPE Character(1) VARCHAR2(1) NOT NULL Line Qty/Price Type
C=Current Order Quantity
Q=Quantity To Date

Default Value: C

23 USE_CNTRCT_BASE Character(1) VARCHAR2(1) NOT NULL Use Contract Base Price
N=No
Y=Yes

Y/N Table Edit

Default Value: N

24 PRICE_UOM_ADJ Character(1) VARCHAR2(1) NOT NULL Use Supp Price UOM Adjustments
N=No
Y=Yes

Y/N Table Edit

Default Value: N

25 PRICE_SHIPTO_ADJ Character(1) VARCHAR2(1) NOT NULL Use Supplier Price Shipto Adj
N=No
Y=Yes

Y/N Table Edit

Default Value: N

26 ADJ_BEFORE Character(1) VARCHAR2(1) NOT NULL Adjust Supplier Pricing First
N=After Contract Adjustments
Y=Before Contract Adjustments

Default Value: Y

27 QTY_TYPE Character(1) VARCHAR2(1) NOT NULL Quantity to Use for Prices
L=Line Quantity
S=Schedule Quantity

Default Value: L

28 PRICE_DT_TYPE Character(1) VARCHAR2(1) NOT NULL Date to Use for Prices
D=Due Date
P=PO Date

Default Value: D

29 PRICE_CAN_CHANGE Character(1) VARCHAR2(1) NOT NULL Price Can Be Changed on Order
N=No
Y=Yes

Y/N Table Edit

Default Value: N

30 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: %EDITTABLE6

31 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
32 TOTAL_DISTRIBS Number(5,0) INTEGER NOT NULL Total Number of Distributions
33 MAX_DISTRIB_LINE Number(5,0) INTEGER NOT NULL Highest Distribution Line
34 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
35 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
36 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

Prompt Table: CNTRCT_TAX_VW

37 DSCNT_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Apply Discount

Y/N Table Edit

Default Value: Y

38 FRGHT_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Freight Charges

Default Value: N

39 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: CNTRCT_HDR.CURRENCY_CD

40 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID
41 RFQ_LINE_NBR Number(5,0) INTEGER NOT NULL RFQ Line
42 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
43 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent
44 WTHD_SETID Character(5) VARCHAR2(5) NOT NULL Setid for the Withholding Code
45 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099

Y/N Table Edit

46 WTHD_CD Character(5) VARCHAR2(5) NOT NULL Withholding Code

Prompt Table: WTHD_CD_HDR

47 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: SHIPTO_TBL

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

Prompt Table: SHIPTO_TBL

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

Prompt Table: TAX_SALE_VW

50 SUT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Exception Type
D=Direct Pay
E=Exempt/Exonerated
N=None
51 SUT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Sales/Use Tax Exception Certif
52 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
53 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
N=No
Y=Yes

Y/N Table Edit

Default Value: N

54 RETENTION_CD Character(1) VARCHAR2(1) NOT NULL Retention
E=Retain on Each Payment
F=Retain on First Payment
L=Retain on Last Payment
N=No Retention
55 RETENTION_PCT Number(7,3) DECIMAL(6,3) NOT NULL Retention Percentage
56 RETENTION_AMT Number(27,3) DECIMAL(26,3) NOT NULL Retention Amount
57 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
58 ULTIMATE_USE_CD Character(8) VARCHAR2(8) NOT NULL Ultimate Use Code
59 CNTRCT_LN_TYPE Character(1) VARCHAR2(1) NOT NULL Contract Line Type
I=Item
R=Role

Default Value: I

60 CNTR_LN_TYPE_ID Character(30) VARCHAR2(30) NOT NULL Contract Line Type ID
61 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
62 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
63 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
64 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
65 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
66 CUSTOM_DATE_B Date(10) DATE Custom Date
67 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2
68 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
69 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.