[Home] [Help] [Dependency Information]
Object Name: | ECE_AR_TRX_ALLOWANCE_CHARGES# |
---|---|
Object Type: | VIEW |
Owner: | EC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMMUNICATION_METHOD | VARCHAR2 | (30) | ||
TRANSACTION_TYPE | VARCHAR2 | (30) | ||
TRANSACTION_ID | NUMBER | Yes | ||
TRANSACTION_RECORD_ID | NUMBER | |||
RUN_ID | NUMBER | |||
LINE_NUMBER | NUMBER | |||
HEADER_DETAIL_INDICATOR | VARCHAR2 | (1) | ||
ALLOWANCE_CHARGE_INDICATOR | VARCHAR2 | (1) | ||
ALLOWANCE_CHARGE_AMOUNT | NUMBER | |||
SPECIAL_SERVICES_CODE | VARCHAR2 | (10) | ||
SPECIAL_SERVICES_CODE_EXT1 | VARCHAR2 | (80) | ||
SPECIAL_SERVICES_CODE_EXT2 | VARCHAR2 | (80) | ||
SPECIAL_SERVICES_CODE_EXT3 | VARCHAR2 | (80) | ||
SPECIAL_SERVICES_CODE_EXT4 | VARCHAR2 | (80) | ||
SPECIAL_SERVICES_CODE_EXT5 | VARCHAR2 | (80) | ||
SPECIAL_CHARGES_CODE | VARCHAR2 | (3) | ||
SPECIAL_CHARGES_CODE_EXT1 | VARCHAR2 | (80) | ||
SPECIAL_CHARGES_CODE_EXT2 | VARCHAR2 | (80) | ||
SPECIAL_CHARGES_CODE_EXT3 | VARCHAR2 | (80) | ||
SPECIAL_CHARGES_CODE_EXT4 | VARCHAR2 | (80) | ||
SPECIAL_CHARGES_CODE_EXT5 | VARCHAR2 | (80) | ||
METHOD_HANDLING_CODE | VARCHAR2 | (3) | ||
METHOD_HANDLING_CODE_EXT1 | VARCHAR2 | (80) | ||
METHOD_HANDLING_CODE_EXT2 | VARCHAR2 | (80) | ||
METHOD_HANDLING_CODE_EXT3 | VARCHAR2 | (80) | ||
METHOD_HANDLING_CODE_EXT4 | VARCHAR2 | (80) | ||
METHOD_HANDLING_CODE_EXT5 | VARCHAR2 | (80) | ||
ALLOWANCE_CHARGE_DESC | VARCHAR2 | (80) | ||
AGENCY_QUALIFIER_CODE | VARCHAR2 | (3) | ||
ALLOWANCE_CHARGE_RATE | NUMBER | |||
ALLOWANCE_CHARGE_PCT_QUALIFIER | VARCHAR2 | (3) | ||
ALLOWANCE_CHARGE_PCT | NUMBER | |||
ALLOWANCE_CHARGE_UOM_CODE | VARCHAR2 | (3) | ||
ALLOWANCE_CHARGE_QUANTITY | NUMBER | |||
AC_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
AC_ATTRIBUTE1 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE2 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE3 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE4 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE5 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE6 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE7 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE8 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE9 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE10 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE11 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE12 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE13 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE14 | VARCHAR2 | (150) | ||
AC_ATTRIBUTE15 | VARCHAR2 | (150) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT COMMUNICATION_METHOD
, TRANSACTION_TYPE
, TRANSACTION_ID
, TRANSACTION_RECORD_ID
, RUN_ID
, LINE_NUMBER
, HEADER_DETAIL_INDICATOR
, ALLOWANCE_CHARGE_INDICATOR
, ALLOWANCE_CHARGE_AMOUNT
, SPECIAL_SERVICES_CODE
, SPECIAL_SERVICES_CODE_EXT1
, SPECIAL_SERVICES_CODE_EXT2
, SPECIAL_SERVICES_CODE_EXT3
, SPECIAL_SERVICES_CODE_EXT4
, SPECIAL_SERVICES_CODE_EXT5
, SPECIAL_CHARGES_CODE
, SPECIAL_CHARGES_CODE_EXT1
, SPECIAL_CHARGES_CODE_EXT2
, SPECIAL_CHARGES_CODE_EXT3
, SPECIAL_CHARGES_CODE_EXT4
, SPECIAL_CHARGES_CODE_EXT5
, METHOD_HANDLING_CODE
, METHOD_HANDLING_CODE_EXT1
, METHOD_HANDLING_CODE_EXT2
, METHOD_HANDLING_CODE_EXT3
, METHOD_HANDLING_CODE_EXT4
, METHOD_HANDLING_CODE_EXT5
, ALLOWANCE_CHARGE_DESC
, AGENCY_QUALIFIER_CODE
, ALLOWANCE_CHARGE_RATE
, ALLOWANCE_CHARGE_PCT_QUALIFIER
, ALLOWANCE_CHARGE_PCT
, ALLOWANCE_CHARGE_UOM_CODE
, ALLOWANCE_CHARGE_QUANTITY
, AC_ATTRIBUTE_CATEGORY
, AC_ATTRIBUTE1
, AC_ATTRIBUTE2
, AC_ATTRIBUTE3
, AC_ATTRIBUTE4
, AC_ATTRIBUTE5
, AC_ATTRIBUTE6
, AC_ATTRIBUTE7
, AC_ATTRIBUTE8
, AC_ATTRIBUTE9
, AC_ATTRIBUTE10
, AC_ATTRIBUTE11
, AC_ATTRIBUTE12
, AC_ATTRIBUTE13
, AC_ATTRIBUTE14
, AC_ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM EC.ECE_AR_TRX_ALLOWANCE_CHARGES#;
|
|
|