[Home] [Help] [Dependency Information]
Object Name: | JL_AR_TURN_UPL_ALL |
---|---|
Object Type: | TABLE |
Owner: | JL |
FND Design Data: | JL.JL_AR_TURN_UPL_ALL |
Subobject Name: | |
Status: | VALID |
JL_AR_TURN_UPL_ALL stores checked and approved data related to Argentine Applicable Tax Rates
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | Yes | Organization identifier |
PUBLISH_DATE | DATE | Yes | Government Flat File Publishing Date | |
START_DATE | DATE | Yes | Valid date from | |
END_DATE | DATE | Yes | Valid date to | |
TAXPAYER_ID | NUMBER | (15) | Yes | Contributor identification |
CONTRIBUTOR_TYPE_CODE | VARCHAR2 | (1) | Yes | Type of contributor D=Direct TaxPayer;C=Multilateral Agreement |
NEW_CONTRIBUTOR_FLAG | VARCHAR2 | (1) | Yes | Flag to identify new contributor S=Yes;New Contributor N=No;Old Contributor B=Off |
RATE_CHANGE_FLAG | VARCHAR2 | (1) | Yes | Flag to identify rate change S=Yes ;Rate changed N=No ;Rate not changed |
PERCEPTION_RATE | NUMBER | Turnover Perception Tax Rate (in percent) | ||
WHT_RATE | NUMBER | Turnover Withholding Tax Rate (in percent) | ||
PERCEPTION_GROUP_NUM | NUMBER | (15) | Perception Group number | |
WHT_GROUP_NUM | NUMBER | (15) | Withholding Group number | |
WHT_DEFAULT_FLAG | VARCHAR2 | (1) | Flag to determine if WHT Code came from data file or if it is DEFAULT | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, PUBLISH_DATE
, START_DATE
, END_DATE
, TAXPAYER_ID
, CONTRIBUTOR_TYPE_CODE
, NEW_CONTRIBUTOR_FLAG
, RATE_CHANGE_FLAG
, PERCEPTION_RATE
, WHT_RATE
, PERCEPTION_GROUP_NUM
, WHT_GROUP_NUM
, WHT_DEFAULT_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
FROM JL.JL_AR_TURN_UPL_ALL;
JL.JL_AR_TURN_UPL_ALL does not reference any database object
JL.JL_AR_TURN_UPL_ALL is referenced by following:
|
|
|