GST_TA_SETUP_VW

(SQL View)
Index Back

GST Trading Partner Setup View

Add search View for GST Trading Partner Setup page

SELECT SETID ,TPR_CATG ,TPR_ID ,TPR_NAME FROM PS_GST_TPR_SETUP

# 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 TPR_CATG Character(4) VARCHAR2(4) NOT NULL Trading Partner Category
CUST=Customer
SUPL=Supplier
3 TPR_ID Character(15) VARCHAR2(15) NOT NULL Trading Partner ID

Prompt Table: %EDITTABLE2

4 TPR_NAME Character(50) VARCHAR2(50) NOT NULL Trading Partner Name