CUST_SOLDTO_OPT (SQL View)	Index Back
Sold-to Customer Options This table stores the processing information and defaults associated with the Sold To customer. The grace days is used to extend a price to a customer after it's expiration date. The flag for product substitutions indicates whether or not this customer accepts substitutes for products ordered. The Part Num flag indicates whether the customer orders using thier part number or the System product ID.

CUST_SOLDTO_OPT

(SQL View)

Sold-to Customer Options

This table stores the processing information and defaults associated with the Sold To customer. The grace days is used to extend a price to a customer after it's expiration date. The flag for product substitutions indicates whether or not this customer accepts substitutes for products ordered. The Part Num flag indicates whether the customer orders using thier part number or the System product ID.

SELECT A.SETID ,B.PRICE_RULE_CD , A.CUST_ID , B.EFFDT , B.EFF_STATUS , B.FRT_CHRG_METHOD , B.GRACE_PRICE_DAYS , B.LABEL_FORMAT_ID2 , B.LABEL_FORMAT_ID3 , B.LOAD_PRICE_RULE , B.PROD_ID_SRC , B.PROD_SUBSTITUTE , B.PRICE_PROGRAM , B.PRICE_RULE_CD , B.RESTOCK_FEE_FLAG , B.ADJUST_BAPRC_FLG , B.VMI_ORDER_CONSOL , B.RECEIPT_TRACK_FLG , %DatePart(B.ROW_LASTMANT_DTTM) , B.ROW_LASTMANT_OPRID FROM PS_RB_INT_CUSTOMER A , PS_BC_SOLDTO_OPT B WHERE A.BO_ID=B.BO_ID

Parent record: CUSTOMER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 EOEP_ARB_ID Character(10) VARCHAR2(10) NOT NULL Arbitration Plan

3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID

4 EFFDT Date(10) DATE NOT NULL Effective Date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

6 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity

7 GRACE_PRICE_DAYS Number(3,0) SMALLINT NOT NULL Grace Pricing Discount Days

8 LABEL_FORMAT_ID2 Character(30) VARCHAR2(30) NOT NULL Carton Label Format ID

9 LABEL_FORMAT_ID3 Character(30) VARCHAR2(30) NOT NULL Ship Container Label Format ID

10 LOAD_PRICE_RULE Character(10) VARCHAR2(10) NOT NULL Load Price Rule

11 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product ID Source
C=Customer Product ID
S=System Product ID
Default Value: S

12 PROD_SUBSTITUTE Character(1) VARCHAR2(1) NOT NULL Product Substitute
Y/N Table Edit
Default Value: Y

13 PRICE_PROGRAM Character(6) VARCHAR2(6) NOT NULL Exclusive Pricing ID

14 PRICE_RULE_CD Character(10) VARCHAR2(10) NOT NULL Price Rule Code

15 RESTOCK_FEE_FLAG Character(1) VARCHAR2(1) NOT NULL Restocking Fee
Y/N Table Edit
Default Value: N

16 ADJUST_BAPRC_FLG Character(1) VARCHAR2(1) NOT NULL Buying Agreement Price Flag
Y/N Table Edit
Default Value: N

17 VMI_ORDER_CONSOL Character(1) VARCHAR2(1) NOT NULL VMI Order Consolidation
1=Sold To Customer
2=Ship To Customer
3=None

18 RECEIPT_TRACK_FLG Character(1) VARCHAR2(1) NOT NULL Receipt Verification
Y/N Table Edit
Default Value: N

19 DATE_LAST_MAINT Date(10) DATE This field determines the date of last maintenance.

20 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL This field determines the last user or operator that last changed this item.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	EOEP_ARB_ID	Character(10)	VARCHAR2(10) NOT NULL	Arbitration Plan
3	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	FRT_CHRG_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Freight Charge Method 01=Order Value 02=Weight 03=Volume 04=Order Quantity
7	GRACE_PRICE_DAYS	Number(3,0)	SMALLINT NOT NULL	Grace Pricing Discount Days
8	LABEL_FORMAT_ID2	Character(30)	VARCHAR2(30) NOT NULL	Carton Label Format ID
9	LABEL_FORMAT_ID3	Character(30)	VARCHAR2(30) NOT NULL	Ship Container Label Format ID
10	LOAD_PRICE_RULE	Character(10)	VARCHAR2(10) NOT NULL	Load Price Rule
11	PROD_ID_SRC	Character(1)	VARCHAR2(1) NOT NULL	Product ID Source C=Customer Product ID S=System Product ID Default Value: S
12	PROD_SUBSTITUTE	Character(1)	VARCHAR2(1) NOT NULL	Product Substitute Y/N Table Edit Default Value: Y
13	PRICE_PROGRAM	Character(6)	VARCHAR2(6) NOT NULL	Exclusive Pricing ID
14	PRICE_RULE_CD	Character(10)	VARCHAR2(10) NOT NULL	Price Rule Code
15	RESTOCK_FEE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Restocking Fee Y/N Table Edit Default Value: N
16	ADJUST_BAPRC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Buying Agreement Price Flag Y/N Table Edit Default Value: N
17	VMI_ORDER_CONSOL	Character(1)	VARCHAR2(1) NOT NULL	VMI Order Consolidation 1=Sold To Customer 2=Ship To Customer 3=None
18	RECEIPT_TRACK_FLG	Character(1)	VARCHAR2(1) NOT NULL	Receipt Verification Y/N Table Edit Default Value: N
19	DATE_LAST_MAINT	Date(10)	DATE	This field determines the date of last maintenance.
20	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	This field determines the last user or operator that last changed this item.