DBA Data[Home] [Help] [Dependency Information]


VIEW: AR.AR_ADJUSTMENTS_REP_ITF#

Object Details
Object Name: AR_ADJUSTMENTS_REP_ITF#
Object Type: VIEW
Owner: AR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
ORGANIZATION_NAME VARCHAR2 (50)
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
POSTABLE VARCHAR2 (15)
ADJ_CURRENCY_CODE VARCHAR2 (15)
CONS VARCHAR2 (15)
SORTBY VARCHAR2 (30)
ADJ_TYPE VARCHAR2 (30)
TRX_NUMBER VARCHAR2 (36)
DUE_DATE DATE

GL_DATE DATE

ADJ_NUMBER VARCHAR2 (20)
ADJ_CLASS VARCHAR2 (30)
ADJ_TYPE_CODE VARCHAR2 (30)
ADJ_TYPE_MEANING VARCHAR2 (30)
CUSTOMER_NAME VARCHAR2 (50)
CUSTOMER_NUMBER VARCHAR2 (30)
TRX_DATE DATE

ACCTD_ADJ_AMOUNT NUMBER

DOC_SEQUENCE_NAME VARCHAR2 (30)
DOC_SEQUENCE_VALUE NUMBER

CUSTOMER_ID NUMBER (15)
ADJ_NAME VARCHAR2 (30)
D_OR_I VARCHAR2 (6)
ADJ_AMOUNT NUMBER

DEBIT_ACCOUNT VARCHAR2 (240)
DEBIT_ACCOUNT_DESC VARCHAR2 (240)
DEBIT_BALANCING VARCHAR2 (240)
DEBIT_BALANCING_DESC VARCHAR2 (240)
DEBIT_NATACCT VARCHAR2 (240)
DEBIT_NATACCT_DESC VARCHAR2 (240)
ACCOUNT_CODE_COMBINATION_ID NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_NAME
,      FUNCTIONAL_CURRENCY_CODE
,      POSTABLE
,      ADJ_CURRENCY_CODE
,      CONS
,      SORTBY
,      ADJ_TYPE
,      TRX_NUMBER
,      DUE_DATE
,      GL_DATE
,      ADJ_NUMBER
,      ADJ_CLASS
,      ADJ_TYPE_CODE
,      ADJ_TYPE_MEANING
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      TRX_DATE
,      ACCTD_ADJ_AMOUNT
,      DOC_SEQUENCE_NAME
,      DOC_SEQUENCE_VALUE
,      CUSTOMER_ID
,      ADJ_NAME
,      D_OR_I
,      ADJ_AMOUNT
,      DEBIT_ACCOUNT
,      DEBIT_ACCOUNT_DESC
,      DEBIT_BALANCING
,      DEBIT_BALANCING_DESC
,      DEBIT_NATACCT
,      DEBIT_NATACCT_DESC
,      ACCOUNT_CODE_COMBINATION_ID
FROM AR.AR_ADJUSTMENTS_REP_ITF#;

Dependencies

[top of page]

AR.AR_ADJUSTMENTS_REP_ITF# references the following:

SchemaAR
TableAR_ADJUSTMENTS_REP_ITF
AR.AR_ADJUSTMENTS_REP_ITF# is referenced by following:

SchemaAPPS
SynonymAR_ADJUSTMENTS_REP_ITF