[Home] [Help]
View: ARBV_AR_TAX_GROUPS
| Product: | AR - Receivables |
|---|
| Description: | - Retrofitted |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT /* UNIQUE ATTRIBUTES */ VT.VAT_TAX_ID
, VT.TAX_CODE
, /* REGULAR ATTRIBUTES */ VT.PRINTED_TAX_NAME
, VT.DESCRIPTION
, VT.START_DATE
, VT.END_DATE
, /* IDS */ VT.ORG_ID
, /* WHO COLUMNS */ VT.LAST_UPDATE_DATE
, VT.LAST_UPDATED_BY
, VT.CREATION_DATE
, VT.CREATED_BY
FROM AR_VAT_TAX_ALL_VL VT
WHERE VT.TAX_TYPE = 'TAX_GROUP'
AND '_SEC:VT.ORG_ID' IS NOT NULL WITH READ ONLY
Columns
| Name |
| TAX_GROUP_ID |
| TAX_GROUP_CODE |
| TAX_GROUP_NAME |
| TAX_GROUP_DESCRIPTION |
| START_EFFECTIVE_DATE |
| END_EFFECTIVE_DATE |
| ORG_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |