[Home] [Help] [Dependency Information]
Object Name: | JE_IT_TRX_ABOVE_THR_ALL# |
---|---|
Object Type: | VIEW |
Owner: | JE |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | (15) | Yes | |
VAT_REPORTING_ENTITY_ID | NUMBER | (15) | Yes | |
ORG_ID | NUMBER | (15) | ||
APPLICATION_ID | NUMBER | (15) | Yes | |
RECORD_TYPE | NUMBER | (1) | ||
EFT_PROGRESSION_NUM | NUMBER | (5) | ||
EFT_SEQUENTIAL_NUM | NUMBER | (5) | ||
PARTY_ID | NUMBER | (15) | ||
PARTY_NAME | VARCHAR2 | (240) | ||
VAT_REGISTRATION_NUM | VARCHAR2 | (30) | ||
TAX_PAYER_ID | VARCHAR2 | (30) | ||
COUNTRY | VARCHAR2 | (3) | ||
TRX_ID | NUMBER | (15) | ||
TRX_NUM | VARCHAR2 | (50) | ||
TRX_DATE | DATE | |||
TRX_GL_DATE | DATE | |||
TRX_TYPE | VARCHAR2 | (25) | ||
PAYMENT_METHOD | VARCHAR2 | (50) | ||
TRX_ACCOUNTING_STATUS | VARCHAR2 | (15) | ||
ASSESSABLE_AMT | NUMBER | (20) | ||
VAT_AMT | NUMBER | (20) | ||
PAYMENT_MODE | VARCHAR2 | (2) | ||
BELOW_THRESHOLD_FLAG | VARCHAR2 | (1) | ||
CONTRACT_IDENTIFICATION | VARCHAR2 | (30) | ||
ORIG_TRX_ID | NUMBER | (15) | ||
ORIG_TRX_NUM | VARCHAR2 | (50) | ||
ORIG_TRX_DATE | DATE | |||
ORIG_TRX_GL_DATE | DATE | |||
ORIG_TRX_ACCTG_STATUS | VARCHAR2 | (15) | ||
ORIG_TRX_PAYMENT_METHOD | VARCHAR2 | (50) | ||
PARTY_TYPE | VARCHAR2 | (20) | ||
INDV_PARTY_LAST_NAME | VARCHAR2 | (150) | ||
INDV_PARTY_FIRST_NAME | VARCHAR2 | (150) | ||
INDV_PARTY_DOB | DATE | |||
INDV_PARTY_CITY | VARCHAR2 | (120) | ||
INDV_PARTY_PROVINCE | VARCHAR2 | (3) | ||
COMPANY_CITY | VARCHAR2 | (60) | ||
COMPANY_ADDRESS | VARCHAR2 | (240) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, VAT_REPORTING_ENTITY_ID
, ORG_ID
, APPLICATION_ID
, RECORD_TYPE
, EFT_PROGRESSION_NUM
, EFT_SEQUENTIAL_NUM
, PARTY_ID
, PARTY_NAME
, VAT_REGISTRATION_NUM
, TAX_PAYER_ID
, COUNTRY
, TRX_ID
, TRX_NUM
, TRX_DATE
, TRX_GL_DATE
, TRX_TYPE
, PAYMENT_METHOD
, TRX_ACCOUNTING_STATUS
, ASSESSABLE_AMT
, VAT_AMT
, PAYMENT_MODE
, BELOW_THRESHOLD_FLAG
, CONTRACT_IDENTIFICATION
, ORIG_TRX_ID
, ORIG_TRX_NUM
, ORIG_TRX_DATE
, ORIG_TRX_GL_DATE
, ORIG_TRX_ACCTG_STATUS
, ORIG_TRX_PAYMENT_METHOD
, PARTY_TYPE
, INDV_PARTY_LAST_NAME
, INDV_PARTY_FIRST_NAME
, INDV_PARTY_DOB
, INDV_PARTY_CITY
, INDV_PARTY_PROVINCE
, COMPANY_CITY
, COMPANY_ADDRESS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
FROM JE.JE_IT_TRX_ABOVE_THR_ALL#;
|
|
|