[Home] [Help] [Dependency Information]
Object Name: | FTE_INVOICE_LINES# |
---|---|
Object Type: | VIEW |
Owner: | FTE |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_LINE_ID | NUMBER | Yes | ||
INVOICE_HEADER_ID | NUMBER | Yes | ||
INVOICE_LINE_NUM | VARCHAR2 | (30) | ||
INVOICE_LINE_TYPE | VARCHAR2 | (30) | ||
LADING_QUANTITY | NUMBER | |||
LADING_UNIT | VARCHAR2 | (30) | ||
DESCRIPTION | VARCHAR2 | (1000) | ||
FREIGHT_CLASS | VARCHAR2 | (30) | ||
TOTAL_WEIGHT | NUMBER | |||
WEIGHT_UOM | VARCHAR2 | (30) | ||
TOTAL_VOLUME | NUMBER | |||
VOLUME_UOM | VARCHAR2 | (30) | ||
RATE_AMOUNT | NUMBER | |||
RATE_TYPE | VARCHAR2 | (30) | ||
DISCOUNT_UOM | VARCHAR2 | (30) | ||
DISCOUNT_AMOUNT | NUMBER | |||
DISCOUNT_TYPE | VARCHAR2 | (30) | ||
DISCOUNT_DISC | VARCHAR2 | (1000) | ||
SURCHARGE_UOM | VARCHAR2 | (30) | ||
SURCHARGE_AMOUNT | NUMBER | |||
SURCHARGE_TYPE | VARCHAR2 | (30) | ||
SURCHARGE_DISC | VARCHAR2 | (1000) | ||
APPROVED_AMOUNT | NUMBER | |||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
RATE_BASIS | VARCHAR2 | (50) | ||
RATE_BASIS_UOM | VARCHAR2 | (50) |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_LINE_ID
, INVOICE_HEADER_ID
, INVOICE_LINE_NUM
, INVOICE_LINE_TYPE
, LADING_QUANTITY
, LADING_UNIT
, DESCRIPTION
, FREIGHT_CLASS
, TOTAL_WEIGHT
, WEIGHT_UOM
, TOTAL_VOLUME
, VOLUME_UOM
, RATE_AMOUNT
, RATE_TYPE
, DISCOUNT_UOM
, DISCOUNT_AMOUNT
, DISCOUNT_TYPE
, DISCOUNT_DISC
, SURCHARGE_UOM
, SURCHARGE_AMOUNT
, SURCHARGE_TYPE
, SURCHARGE_DISC
, APPROVED_AMOUNT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, RATE_BASIS
, RATE_BASIS_UOM
FROM FTE.FTE_INVOICE_LINES#;
|
|
|