[Home] [Help] [Dependency Information]
Object Name: | JAI_FBT_PAYMENT# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FBT_PAYMENT_ID | NUMBER | (15) | Yes | |
LEGAL_ENTITY_ID | NUMBER | (15) | Yes | |
FBT_YEAR | NUMBER | (9) | Yes | |
STATUS_DATE | DATE | Yes | ||
INVOICE_REFERENCE | VARCHAR2 | (50) | Yes | |
INVOICE_DATE | DATE | |||
INV_SUPPLIER_ID | NUMBER | (15) | ||
INV_SUPPLIER_SITE_ID | NUMBER | (15) | ||
INV_OU_ID | NUMBER | (15) | ||
FBT_TAX_AMOUNT | NUMBER | |||
FBT_SURCHARGE_AMOUNT | NUMBER | |||
FBT_EDU_CESS_AMOUNT | NUMBER | |||
FBT_SH_CESS_AMOUNT | NUMBER | |||
IT_CHALLAN | VARCHAR2 | (50) | ||
BANK_NAME | VARCHAR2 | (50) | ||
BRANCH_NAME | VARCHAR2 | (50) | ||
DEPOSIT_DATE | DATE | |||
BSR_CODE | VARCHAR2 | (50) | ||
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) |
Cut, paste (and edit) the following text to query this object:
SELECT FBT_PAYMENT_ID
, LEGAL_ENTITY_ID
, FBT_YEAR
, STATUS_DATE
, INVOICE_REFERENCE
, INVOICE_DATE
, INV_SUPPLIER_ID
, INV_SUPPLIER_SITE_ID
, INV_OU_ID
, FBT_TAX_AMOUNT
, FBT_SURCHARGE_AMOUNT
, FBT_EDU_CESS_AMOUNT
, FBT_SH_CESS_AMOUNT
, IT_CHALLAN
, BANK_NAME
, BRANCH_NAME
, DEPOSIT_DATE
, BSR_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM JA.JAI_FBT_PAYMENT#;
|
|
|