[Home] [Help] [Dependency Information]
Object Name: | AR_CONS_INV_TRX_ALL# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONS_INV_ID | NUMBER | (15) | Yes | |
CONS_INV_LINE_NUMBER | NUMBER | (15) | ||
TRANSACTION_TYPE | VARCHAR2 | (30) | Yes | |
TRX_NUMBER | VARCHAR2 | (30) | ||
TRANSACTION_DATE | DATE | Yes | ||
AMOUNT_ORIGINAL | NUMBER | |||
TAX_ORIGINAL | NUMBER | |||
ADJ_PS_ID | NUMBER | (15) | ||
ORG_ID | NUMBER | (15) | ||
CUSTOMER_TRX_ID | NUMBER | (15) | ||
JUSTIFICATION | VARCHAR2 | (200) | ||
UNPAID_REASON | VARCHAR2 | (30) | ||
SHIP_TO_SITE_ID | NUMBER | (15) | ||
TRX_DESCRIPTION | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT CONS_INV_ID
, CONS_INV_LINE_NUMBER
, TRANSACTION_TYPE
, TRX_NUMBER
, TRANSACTION_DATE
, AMOUNT_ORIGINAL
, TAX_ORIGINAL
, ADJ_PS_ID
, ORG_ID
, CUSTOMER_TRX_ID
, JUSTIFICATION
, UNPAID_REASON
, SHIP_TO_SITE_ID
, TRX_DESCRIPTION
FROM AR.AR_CONS_INV_TRX_ALL#;
|
|
|