VMI_CUSTSHIP_VW (SQL View)	Index Back
Valid VMI Ship To Cust - SETID This is used as a prompt table where it is not restricted to a certain OM BU, but instead can be used for a range of OM BU's , therefore we select by SETID since the range of OM BU may cross SETID's. The Calc Replenishment and Process Replenishment VMI processes use this prompt.

VMI_CUSTSHIP_VW

(SQL View)

Valid VMI Ship To Cust - SETID

This is used as a prompt table where it is not restricted to a certain OM BU, but instead can be used for a range of OM BU's , therefore we select by SETID since the range of OM BU may cross SETID's. The Calc Replenishment and Process Replenishment VMI processes use this prompt.

SELECT A.SETID ,A.CUST_ID ,B.NAME1 FROM PS_CUST_SHIPTO_OPT A , PS_CUSTOMER B WHERE %Join(COMMON_KEYS, CUST_SHIPTO_OPT A, CUSTOMER B) AND B.CUST_STATUS = 'A' AND %EffdtCheck(CUST_SHIPTO_OPT A2,A,%CurrentDateIn) AND A.EFF_STATUS = 'A' AND A.VMI_CUST_FLG = 'Y'

Parent record: 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.

3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1