[Home] [Help] [Dependency Information]
Object Name: | JL_BR_AP_TAX_CALENDAR_LINES |
---|---|
Object Type: | TABLE |
Owner: | JL |
FND Design Data: | JL.JL_BR_AP_TAX_CALENDAR_LINES |
Subobject Name: | |
Status: | VALID |
JL_BR_AP_TAX_CALENDAR_LINES stores the lines for each withholding tax calendar header, related to the withholding tax, that allows the user to have a specific due date to pay the withholding tax.
This table corresponds to the TAX_CALENDAR_LINES block of the Tax Calendars window.
.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JL_BR_AP_TAX_CALENDAR_LINE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TAX_CALENDAR_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TAX_CALENDAR_ID | NUMBER | Yes | Withholding Tax Calendar Line Identifier | |
TAX_CALENDAR_NAME | VARCHAR2 | (25) | Yes | Withholding Tax Calendar Name |
START_DATE | DATE | Yes | Withholding Start Date | |
END_DATE | DATE | Yes | Withholding End Date | |
DUE_DATE | DATE | Yes | Withholding Invoice Due Date | |
ACTIVE | VARCHAR2 | (1) | Yes | Flag that indicates if this withholding tax line is active |
INACTIVE_DATE | DATE | Inactive Date | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Standard Who Column | ||
CREATED_BY | NUMBER | (15) | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT TAX_CALENDAR_ID
, TAX_CALENDAR_NAME
, START_DATE
, END_DATE
, DUE_DATE
, ACTIVE
, INACTIVE_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM JL.JL_BR_AP_TAX_CALENDAR_LINES;
JL.JL_BR_AP_TAX_CALENDAR_LINES does not reference any database object
JL.JL_BR_AP_TAX_CALENDAR_LINES is referenced by following:
|
|
|