SCR_VATRG_CMP_V

(SQL View)
 Index Back

Supplier VAT Information

Supplier VAT Information

SELECT a.scr_id ,a.scr_seq_num ,C.country , a.scr_country , a.scr_chng_type ,C.setid ,C.vendor_id , a.country_2char ,(CASE WHEN a.vat_rgstrn_id = b.vat_rgstrn_id THEN c.vat_rgstrn_id ELSE a.vat_rgstrn_id END) ,(CASE WHEN a.home_country_flg = b.home_country_flg THEN c.home_country_flg ELSE a.home_country_flg END) , a.scr_remove , a.ERR_MSG_NBR , a.MSG_SEVERITY , %subrec(FMS_WHO_SBR, a) FROM ps_scr_vat_rgs_dft a , PS_SCR_VAT_RGS_MST b , ps_VNDR_VAT_RGSTRN C WHERE a.scr_id = b.scr_id AND a.scr_seq_num = b.scr_seq_num AND a.country = b.country AND b.setid = c.setid AND b.vendor_id = c.vendor_id AND b.country = c.country UNION SELECT a.scr_id ,a.scr_seq_num ,a.country ,a.scr_country ,a.scr_chng_type ,a.setid ,a.vendor_id , a.country_2char ,a.vat_rgstrn_id ,a.home_country_flg , a.scr_remove , a.ERR_MSG_NBR , a.MSG_SEVERITY , %subrec(FMS_WHO_SBR, a) FROM ps_scr_vat_rgs_dft a WHERE a.scr_chng_type = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCR_ID Character(15) VARCHAR2(15) NOT NULL Supplier Change Request ID
2 SCR_SEQ_NUM Number(5,0) INTEGER NOT NULL Update Sequence Number
3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_VAT_VW

4 SCR_COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_VAT_VW

5 SCR_CHNG_TYPE Character(1) VARCHAR2(1) NOT NULL Request for Change Type
A=Add
D=Delete
I=Inactivate
U=Update
6 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
8 COUNTRY_2CHAR Character(2) VARCHAR2(2) NOT NULL 2-Char Country Code

Prompt Table: CNTRY_VAT_2C_VW

9 VAT_RGSTRN_ID Character(20) VARCHAR2(20) NOT NULL VAT Registration ID
10 HOME_COUNTRY_FLG Character(1) VARCHAR2(1) NOT NULL Home Country
N=No
Y=Yes

Y/N Table Edit

Default Value: N

11 SCR_REMOVE Character(1) VARCHAR2(1) NOT NULL Remove Contact
12 ERR_MSG_NBR Number(5,0) INTEGER NOT NULL Service Purchase Error Number
13 MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity
C=Cancel
E=Error
M=Message
W=Warning
14 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
15 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
16 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
17 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.