AUC_CNT_ADJ_RUL

(SQL View)
 Index Back

Contract Price Adjust Rules


SELECT setid , cntrct_id , cntrct_line_nbr , effdt , price_adjust_seq , adjust_on_general , adjust_on_uom , unit_of_measure , adjust_on_shipto , shipto_setid , shipto_id , currency_cd , final_price , hard_price , ignore_if_other , vndr_loc FROM PS_CNTRCT_ADJ_RULE

# 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 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
4 EFFDT Date(10) DATE Effective Date
5 PRICE_ADJUST_SEQ Number(3,0) SMALLINT NOT NULL Price Adjustment Sequence

Default Value: 1

6 ADJUST_ON_GENERAL Character(1) VARCHAR2(1) NOT NULL General Adjustment
N=No
Y=Yes

Y/N Table Edit

Default Value: N

7 ADJUST_ON_UOM Character(1) VARCHAR2(1) NOT NULL Adjust When UOM Matches
N=No
Y=Yes

Y/N Table Edit

Default Value: N

8 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: %EDITTABLE2

9 ADJUST_ON_SHIPTO Character(1) VARCHAR2(1) NOT NULL Adjust on Shipto
N=No
Y=Yes

Y/N Table Edit

Default Value: N

10 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID

Prompt Table: %EDITTABLE3

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

Prompt Table: %EDITTABLE4

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

Prompt Table: %EDITTABLE

13 FINAL_PRICE Character(1) VARCHAR2(1) NOT NULL Stop Price Calculation Here
N=No
Y=Yes

Y/N Table Edit

Default Value: N

14 HARD_PRICE Character(1) VARCHAR2(1) NOT NULL Hard Price
N=No
Y=Yes

Y/N Table Edit

Default Value: N

15 IGNORE_IF_OTHER Character(1) VARCHAR2(1) NOT NULL Ignore If Other Adjustments
N=No
Y=Yes

Y/N Table Edit

Default Value: N

16 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: %EDITTABLE8