[Home] [Help] [Dependency Information]
Object Name: | JAI_FBT_REPOSITORY |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_FBT_REPOSITORY |
Subobject Name: | |
Status: | VALID |
This table is used to store all the transactions that attract Fringe Benefit Tax
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JAI_FBT_REPOSITORY_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | FBT_TRANSACTION_ID |
JAI_FBT_REPOSITORY_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LEGAL_ENTITY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FBT_TRANSACTION_ID | NUMBER | (15) | Yes | Fringe Benefit Transaction Identifier |
LEGAL_ENTITY_ID | NUMBER | (15) | Yes | Legal Entity Identifier |
PERIOD_START_DATE | DATE | Period start date | ||
PERIOD_END_DATE | DATE | Period end date | ||
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | Invoice Distribution Identifier | |
INVOICE_DATE | DATE | Invoice Date | ||
INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Invoice Currency | |
DISTRIBUTION_AMT | NUMBER | Distribution amount | ||
DIST_CODE_COMBINATION_ID | NUMBER | (15) | Invoice Distribution code combination Identifier | |
DIST_NATURAL_ACCOUNT_VALUE | NUMBER | (25) | Invoice Distribution Natural Account | |
FRINGE_BENEFIT_TYPE_CODE | VARCHAR2 | (30) | Yes | Fringe Benefit Type |
FBT_CURRENCY | VARCHAR2 | (15) | Fringe Benefit Currency | |
TAXABLE_BASIS | NUMBER | Taxable Basis | ||
FBT_TAXABLE_AMOUNT | NUMBER | Fringe Benefit taxable amount | ||
FBT_TAX_AMOUNT | NUMBER | Fringe Benefit Tax amount | ||
FBT_SURCHARGE_AMOUNT | NUMBER | Fringe Benefit Surcharge amount | ||
FBT_EDU_CESS_AMOUNT | NUMBER | Fringe Benefit Education Cess Amount | ||
FBT_SH_CESS_AMOUNT | NUMBER | Fringe Benefit Secondary and higher Education Tax | ||
MANUAL_FLAG | VARCHAR2 | (1) | Set to Y if the transaction is manually created otherwise NULL | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
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 | |
SETTLEMENT_ID | NUMBER | (15) | Obsolete for R12 New change | |
SOURCE | VARCHAR2 | (30) | Set to 'Payables' if the transaction is gained from AP; Set to 'Others' if the transaction is gained from GL | |
JE_HEADER_ID | NUMBER | (15) | Journal Header Identifier.The information get from Gl_je_headers.je_header_id | |
BATCH_NAME | VARCHAR2 | (100) | Journal Batch Name.The information get from Gl_je_batche. name | |
JE_SOURCE | VARCHAR2 | (25) | Journal Source Name.The information get from Gl_je_headers.je_source | |
JE_NAME | VARCHAR2 | (100) | Journal Name.The information get from Gl_je_headers.name/ ap_invoices_all.invoice_num | |
PERIOD_NAME | VARCHAR2 | (15) | Journal Period Name. The information get from Gl_je_headers.period_name | |
JE_LINE_NUM | NUMBER | (15) | Invoice Line Number and Journal Line Number.The information get from Gl_je_lines.je_line_num/ ap_invoice_lines_all. invoice_line_number | |
DIST_BALANCE_ACCOUNT_VALUE | VARCHAR2 | (25) | Invoice Distribution and Journal lines Balance Account | |
CONVERSION_RATE | NUMBER | Conversion rate | ||
CONVERTED_AMOUNT | NUMBER | Converted amount | ||
CONVERSION_TYPE | VARCHAR2 | (30) | Conversion type | |
CONVERSION_DATE | DATE | Conversion date | ||
MODIFIED_FLAG | NUMBER | (1) | Flag of manual modified trans from processing "1" stands for manual modified."0" stands for no modification | |
REFERENCE | VARCHAR2 | (240) | Entered manually by user |
Cut, paste (and edit) the following text to query this object:
SELECT FBT_TRANSACTION_ID
, LEGAL_ENTITY_ID
, PERIOD_START_DATE
, PERIOD_END_DATE
, INVOICE_DISTRIBUTION_ID
, INVOICE_DATE
, INVOICE_CURRENCY_CODE
, DISTRIBUTION_AMT
, DIST_CODE_COMBINATION_ID
, DIST_NATURAL_ACCOUNT_VALUE
, FRINGE_BENEFIT_TYPE_CODE
, FBT_CURRENCY
, TAXABLE_BASIS
, FBT_TAXABLE_AMOUNT
, FBT_TAX_AMOUNT
, FBT_SURCHARGE_AMOUNT
, FBT_EDU_CESS_AMOUNT
, FBT_SH_CESS_AMOUNT
, MANUAL_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SETTLEMENT_ID
, SOURCE
, JE_HEADER_ID
, BATCH_NAME
, JE_SOURCE
, JE_NAME
, PERIOD_NAME
, JE_LINE_NUM
, DIST_BALANCE_ACCOUNT_VALUE
, CONVERSION_RATE
, CONVERTED_AMOUNT
, CONVERSION_TYPE
, CONVERSION_DATE
, MODIFIED_FLAG
, REFERENCE
FROM JA.JAI_FBT_REPOSITORY;
JA.JAI_FBT_REPOSITORY does not reference any database object
JA.JAI_FBT_REPOSITORY is referenced by following:
|
|
|