CS_CNT_LINE_VW(SQL View) |
Index Back |
---|---|
Contract Line MappingsBind 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
|
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. |