[Home] [Help] [Dependency Information]
Object Name: | JAI_AR_TRX_INS_LINES_T# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PADDR | RAW | (32) | ||
EXTENDED_AMOUNT | NUMBER | |||
CUSTOMER_TRX_LINE_ID | NUMBER | (15) | ||
CUSTOMER_TRX_ID | NUMBER | (15) | ||
LINE_NUMBER | NUMBER | |||
SET_OF_BOOKS_ID | NUMBER | (15) | ||
LINK_TO_CUST_TRX_LINE_ID | NUMBER | (15) | ||
LINE_TYPE | VARCHAR2 | (20) | ||
ORG_ID | NUMBER | (15) | ||
UOM_CODE | VARCHAR2 | (3) | ||
VAT_TAX_ID | NUMBER | (15) | ||
ACCTD_AMOUNT | NUMBER | |||
AMOUNT | NUMBER | |||
CUST_TRX_LINE_SALES_REP_ID | NUMBER | (15) | ||
GL_DATE | DATE | |||
INSERT_UPDATE_FLAG | VARCHAR2 | (1) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
TAX_RATE | NUMBER | |||
ERROR_FLAG | VARCHAR2 | (1) | ||
ERR_MESG | VARCHAR2 | (250) | ||
SOURCE | VARCHAR2 | (30) | Yes | |
CODE_COMBINATION_ID | NUMBER | (15) | ||
OBJECT_VERSION_NUMBER | NUMBER | |||
INTERFACE_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT PADDR
, EXTENDED_AMOUNT
, CUSTOMER_TRX_LINE_ID
, CUSTOMER_TRX_ID
, LINE_NUMBER
, SET_OF_BOOKS_ID
, LINK_TO_CUST_TRX_LINE_ID
, LINE_TYPE
, ORG_ID
, UOM_CODE
, VAT_TAX_ID
, ACCTD_AMOUNT
, AMOUNT
, CUST_TRX_LINE_SALES_REP_ID
, GL_DATE
, INSERT_UPDATE_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TAX_RATE
, ERROR_FLAG
, ERR_MESG
, SOURCE
, CODE_COMBINATION_ID
, OBJECT_VERSION_NUMBER
, INTERFACE_FLAG
FROM JA.JAI_AR_TRX_INS_LINES_T#;
|
|
|