[Home] [Help] [Dependency Information]
Object Name: | JAI_FBT_REPOSITORY# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FBT_TRANSACTION_ID | NUMBER | (15) | Yes | |
LEGAL_ENTITY_ID | NUMBER | (15) | Yes | |
PERIOD_START_DATE | DATE | |||
PERIOD_END_DATE | DATE | |||
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | ||
INVOICE_DATE | DATE | |||
INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | ||
DISTRIBUTION_AMT | NUMBER | |||
DIST_CODE_COMBINATION_ID | NUMBER | (15) | ||
DIST_NATURAL_ACCOUNT_VALUE | NUMBER | (25) | ||
FRINGE_BENEFIT_TYPE_CODE | VARCHAR2 | (30) | Yes | |
FBT_CURRENCY | VARCHAR2 | (15) | ||
TAXABLE_BASIS | NUMBER | |||
FBT_TAXABLE_AMOUNT | NUMBER | |||
FBT_TAX_AMOUNT | NUMBER | |||
FBT_SURCHARGE_AMOUNT | NUMBER | |||
FBT_EDU_CESS_AMOUNT | NUMBER | |||
FBT_SH_CESS_AMOUNT | NUMBER | |||
MANUAL_FLAG | VARCHAR2 | (1) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
SETTLEMENT_ID | NUMBER | (15) | ||
SOURCE | VARCHAR2 | (30) | ||
JE_HEADER_ID | NUMBER | (15) | ||
BATCH_NAME | VARCHAR2 | (100) | ||
JE_SOURCE | VARCHAR2 | (25) | ||
JE_NAME | VARCHAR2 | (100) | ||
PERIOD_NAME | VARCHAR2 | (15) | ||
JE_LINE_NUM | NUMBER | (15) | ||
DIST_BALANCE_ACCOUNT_VALUE | VARCHAR2 | (25) | ||
CONVERSION_RATE | NUMBER | |||
CONVERTED_AMOUNT | NUMBER | |||
CONVERSION_TYPE | VARCHAR2 | (30) | ||
CONVERSION_DATE | DATE | |||
MODIFIED_FLAG | NUMBER | (1) | ||
REFERENCE | VARCHAR2 | (240) |
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#;
|
|
|