[Home] [Help] [Dependency Information]
Object Name: | JL_BR_INV_API_TRX_LINES_T# |
---|---|
Object Type: | VIEW |
Owner: | JL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRX_LINE_ID | NUMBER | (15) | ||
INDUSTRY_ATTRIBUTE1 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE2 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE3 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE4 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE5 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE6 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE7 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE8 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE9 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE10 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE11 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE12 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE13 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE14 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE15 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE16 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE17 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE18 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE19 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE20 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE21 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE22 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE23 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE24 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE25 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE26 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE27 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE28 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE29 | VARCHAR2 | (150) | ||
INDUSTRY_ATTRIBUTE30 | VARCHAR2 | (150) | ||
TOWING_VEH_PLATE_NUMBER2 | VARCHAR2 | (30) | ||
TOWING_VEH_PLATE_STATE_CODE2 | VARCHAR2 | (2) | ||
TOWING_VEH_PLATE_NUMBER3 | VARCHAR2 | (30) | ||
TOWING_VEH_PLATE_STATE_CODE3 | VARCHAR2 | (2) | ||
TOWING_VEH_PLATE_NUMBER4 | VARCHAR2 | (30) | ||
TOWING_VEH_PLATE_STATE_CODE4 | VARCHAR2 | (2) | ||
TOWING_VEH_PLATE_NUMBER5 | VARCHAR2 | (30) | ||
TOWING_VEH_PLATE_STATE_CODE5 | VARCHAR2 | (2) | ||
TRX_HEADER_ID | NUMBER | (15) | ||
SRV_EXEC_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT TRX_LINE_ID
, INDUSTRY_ATTRIBUTE1
, INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE4
, INDUSTRY_ATTRIBUTE5
, INDUSTRY_ATTRIBUTE6
, INDUSTRY_ATTRIBUTE7
, INDUSTRY_ATTRIBUTE8
, INDUSTRY_ATTRIBUTE9
, INDUSTRY_ATTRIBUTE10
, INDUSTRY_ATTRIBUTE11
, INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE13
, INDUSTRY_ATTRIBUTE14
, INDUSTRY_ATTRIBUTE15
, INDUSTRY_ATTRIBUTE16
, INDUSTRY_ATTRIBUTE17
, INDUSTRY_ATTRIBUTE18
, INDUSTRY_ATTRIBUTE19
, INDUSTRY_ATTRIBUTE20
, INDUSTRY_ATTRIBUTE21
, INDUSTRY_ATTRIBUTE22
, INDUSTRY_ATTRIBUTE23
, INDUSTRY_ATTRIBUTE24
, INDUSTRY_ATTRIBUTE25
, INDUSTRY_ATTRIBUTE26
, INDUSTRY_ATTRIBUTE27
, INDUSTRY_ATTRIBUTE28
, INDUSTRY_ATTRIBUTE29
, INDUSTRY_ATTRIBUTE30
, TOWING_VEH_PLATE_NUMBER2
, TOWING_VEH_PLATE_STATE_CODE2
, TOWING_VEH_PLATE_NUMBER3
, TOWING_VEH_PLATE_STATE_CODE3
, TOWING_VEH_PLATE_NUMBER4
, TOWING_VEH_PLATE_STATE_CODE4
, TOWING_VEH_PLATE_NUMBER5
, TOWING_VEH_PLATE_STATE_CODE5
, TRX_HEADER_ID
, SRV_EXEC_DATE
FROM JL.JL_BR_INV_API_TRX_LINES_T#;
|
|
|