BC_SOLDTO_OPT (SQL Table)	Index Back
Sold-to Options This table stores the processing information and defaults associated with the Sold To Business Contact. 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.

BC_SOLDTO_OPT

(SQL Table)

Sold-to Options

This table stores the processing information and defaults associated with the Sold To Business Contact. 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.

Parent record: BC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

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

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

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

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

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

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

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

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

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

12 PRICE_RULE_CD Character(10) VARCHAR2(10) NOT NULL Price Rule Code
Prompt Table: RB_ARB_PLAN_VW

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

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

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

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

17 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

18 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

19 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

20 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

21 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

22 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	FRT_CHRG_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Freight Charge Method 01=Order Value 02=Weight 03=Volume 04=Order Quantity
5	GRACE_PRICE_DAYS	Number(3,0)	SMALLINT NOT NULL	Grace Pricing Discount Days
6	LABEL_FORMAT_ID2	Character(30)	VARCHAR2(30) NOT NULL	Carton Label Format ID
7	LABEL_FORMAT_ID3	Character(30)	VARCHAR2(30) NOT NULL	Ship Container Label Format ID
8	LOAD_PRICE_RULE	Character(10)	VARCHAR2(10) NOT NULL	Load Price Rule
9	PROD_ID_SRC	Character(1)	VARCHAR2(1) NOT NULL	Product ID Source C=Customer Product ID S=System Product ID Default Value: S
10	PROD_SUBSTITUTE	Character(1)	VARCHAR2(1) NOT NULL	Product Substitute Y/N Table Edit Default Value: Y
11	PRICE_PROGRAM	Character(6)	VARCHAR2(6) NOT NULL	Exclusive Pricing ID
12	PRICE_RULE_CD	Character(10)	VARCHAR2(10) NOT NULL	Price Rule Code Prompt Table: RB_ARB_PLAN_VW
13	RESTOCK_FEE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Restocking Fee Y/N Table Edit Default Value: N
14	ADJUST_BAPRC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Buying Agreement Price Flag Y/N Table Edit Default Value: N
15	VMI_ORDER_CONSOL	Character(1)	VARCHAR2(1) NOT NULL	VMI Order Consolidation 1=Sold To Customer 2=Ship To Customer 3=None
16	RECEIPT_TRACK_FLG	Character(1)	VARCHAR2(1) NOT NULL	Receipt Verification Y/N Table Edit Default Value: N
17	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
18	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
19	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
20	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
21	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
22	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time