CUST_ADDRCT_LVW

(SQL View)
 Index Back

Contact Cust Billing Addr

This view is used as a prompt on the contact credit card.

SELECT lng.setid , lng.cust_id , lng.address_seq_num , lng.language_cd , lng.descr FROM ps_cust_addr_seq a , PS_CUST_ADDRESS b , ps_CUST_ADDRSQ_LNG lng WHERE a.setid = b.setid AND a.cust_id= b.cust_id AND a.address_seq_num = b.address_seq_num AND a.bill_to_addr = 'Y' AND %EffdtCheck(cust_address b2, b, %currentdatein) AND b.eff_status='A' AND lng.setid = a.setid AND lng.cust_id = a.cust_id AND lng.address_seq_num = a.address_seq_num

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer 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 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description