BUSINESS_UNITAPBU_VAT_CF_VW(SQL View) |
Index Back |
|---|---|
APBU Vat Apport ChartFlds View |
| SELECT DISTINCT A.BUSINESS_UNIT , B.SETID , B.CHARTFIELD_PR1 , B.CHARTFIELD_PR2 , C.SETID FROM PS_BUS_UNIT_TBL_AP A , PS_VAT_APORT_BASE B , PS_SET_CNTRL_REC C WHERE B.SETID = ( SELECT I.SETID FROM PS_SET_CNTRL_REC I WHERE I.SETCNTRLVALUE = A.BUSINESS_UNIT AND I.REC_GROUP_ID = 'FS_44' AND I.RECNAME = 'VAT_APORT_BASE') AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.REC_GROUP_ID = 'FS_17' AND C.RECNAME = 'TAX_AUTHORITY' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VAT_CF_SETID | Character(5) | VARCHAR2(5) NOT NULL | VAT ChartField SetID |
| 3 | CHARTFIELD_PR1 | Character(18) | VARCHAR2(18) NOT NULL | Chartfield Priority 1 |
| 4 | CHARTFIELD_PR2 | Character(18) | VARCHAR2(18) NOT NULL | Chartfield Priority 2 |
| 5 | VAT_SETID | Character(5) | VARCHAR2(5) NOT NULL | VAT SetID |