CUST_SHIPTO_OPT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Prompt Table: CUSTOMER
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code Prompt Table: SHIP_METHOD_VW
6	SHIP_TYPE_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Shipping Method Prompt Table: SHIP_METHOD_VW
7	SHIP_PRIOR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Ship Prior to Request Date N=Ship Prior No Y=Ship Prior Yes Default Value: Y
8	SHIP_PARTIAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Partial Schedules N=Ship Partial No Y=Ship Partial Yes Default Value: Y
9	BCKORDR_CNCL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Cancel Backorder N=Cancel Backorder No Y=Cancel Backorder Yes Default Value: N
10	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code Default Value: PSOPTIONS.LANGUAGE_CD
11	SHIP_PRIORITY_ID	Character(6)	VARCHAR2(6) NOT NULL	Shipping Priority Code Prompt Table: PRIORITY_SHP_VW
12	DS_NETWORK_CODE	Character(6)	VARCHAR2(6) NOT NULL	Distribution Network Code Prompt Table: DS_NETHDR_TBL
13	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code Prompt Table: FREIGHT_TERMS
14	FREIGHT_TERMS_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Freight Terms Code Prompt Table: FREIGHT_TERMS
15	SHIP_EARLY_DAYS	Number(4,0)	SMALLINT NOT NULL	Number of Days Early
16	SHIP_LATE_DAYS	Number(4,0)	SMALLINT NOT NULL	Days Allowed After Request Dt
17	SHIP_PARTIAL_ORD	Character(1)	VARCHAR2(1) NOT NULL	Partial Order N=Partial Order No Y=Partial Order Yes Default Value: Y
18	STORE_NUMBER	Character(17)	VARCHAR2(17) NOT NULL	Store Number
19	NAFTA_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	North American Free Trade Agmt N=No Y=Yes Y/N Table Edit Default Value: N
20	CCI_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	Canadian Customs Invoice N=No Y=Yes Y/N Table Edit Default Value: N
21	SED_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	Shippers Export Declaration N=No Y=Yes Y/N Table Edit Default Value: N
22	COO_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	Certificate of Origin N=No Y=Yes Y/N Table Edit Default Value: N
23	AERP	Character(50)	VARCHAR2(50) NOT NULL	Automated Exporter Rptg Prgm
24	INSURANCE_REQD	Character(1)	VARCHAR2(1) NOT NULL	Insurance Required Y/N Table Edit Default Value: N
25	MILITARY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Military End User Flag Y/N Table Edit Default Value: N
26	EXPORT_ORDER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag Orders for Export Y/N Table Edit Default Value: N
27	PREF_CARRIER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Preferred Carrier flag N=No Preferred Carrier Y=Preferred Carrier
28	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID Prompt Table: CARRIER_SHP_VW
29	CARRIER_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Carrier ID Prompt Table: CARRIER_SHP_VW
30	SHIP_PRIORITY_EXP	Character(6)	VARCHAR2(6) NOT NULL	Export Shipping Priority Prompt Table: PRIORITY_SHP_VW
31	SINGLE_SHIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Single Ship Flag N=No Y=Yes
32	LABEL_FORMAT_ID2	Character(30)	VARCHAR2(30) NOT NULL	Carton Label Format ID Prompt Table: BCT_SHL_INV_VW
33	LABEL_FORMAT_ID3	Character(30)	VARCHAR2(30) NOT NULL	Ship Container Label Format ID Prompt Table: BCT_SHC_INV_VW
34	ALLOW_OVERPICK_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate whether or not overpicking is allowed for a customer or business unit. Y/N Table Edit Default Value: N
35	MAX_PICK_TOLERANCE	Number(6,2)	DECIMAL(5,2) NOT NULL	Used to indicate the allowable percentage of overshipment for a customer or business unit.
36	STOCKOUT_RATE	Number(4,1)	DECIMAL(3,1) NOT NULL	Desired Stock-In Probability Prompt Table: STKOUT_RATE_INV
37	VMI_REORDER_CHK	Character(1)	VARCHAR2(1) NOT NULL	Reorder Range Check N=No U=Use Default Y=Yes Default Value: U
38	RANGE_PCT	Number(2,0)	SMALLINT NOT NULL	Reorder Range Percentage
39	VMI_CUST_FLG	Character(1)	VARCHAR2(1) NOT NULL	VMI Enabled Customer Y/N Table Edit Default Value: N
40	VMI_MANAGER	Character(30)	VARCHAR2(30) NOT NULL	VMI Manager Prompt Table: VMI_MANAGER_VW
41	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit Prompt Table: SP_BUNVM_NONVW
42	REORD_QTY_OPTION	Character(2)	VARCHAR2(2) NOT NULL	Reorder Quantity Option 1=EOQ 2=Min/Max 3=AOQ 4=Static Reorder Qty 5=Demand Quantity 99=Use Business Unit Default
43	REPL_CALC_PERIOD	Number(3,0)	SMALLINT NOT NULL	Replenish Calc Period (Days)
44	SELL_CONSIGNED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Goods Consigned at Customer Y/N Table Edit Default Value: N
45	LOT_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Lot Control N=N Y=Y Y/N Table Edit Default Value: N
46	SERIAL_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Serial Control N=N Y=Y Y/N Table Edit Default Value: N
47	CONTAINER_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Container Control Y/N Table Edit Default Value: N
48	STAGED_DATE_CNTRL	Character(1)	VARCHAR2(1) NOT NULL	Staged Date Control Y/N Table Edit Default Value: N
49	DEL_ORD_RESTRICTED	Character(1)	VARCHAR2(1) NOT NULL	Deliveries restricted to order N=Deliveries Not Restricted Y=Deliveries Restricted to Order
50	DEFAULT_PO	Character(25)	VARCHAR2(25) NOT NULL	Customer PO Number
51	DATE_LAST_MAINT	Date(10)	DATE	Date Last Maintained
52	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID