eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.AR_INVOICE_ADJ_V

Object Details

Object Name:	AR_INVOICE_ADJ_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.AR_INVOICE_ADJ_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

The AR_INVOICE_ADJ_V view, which is one of eight transaction printing views that Oracle Receivables provides, collects information about invoice adjustments. A system administrator or Oracle consultant can use transaction printing views to extract transaction information from Receivables and then print the data in a custom format using Oracle Reports or a similar SQL-based report generator.

[View Source]

Columns

Name	Datatype	Length	Comments
TRX_NUMBER	VARCHAR2	(20)	Transaction number associated with this adjustment
TRX_DATE	DATE		Transaction Date
CUSTOMER_TRX_ID	NUMBER	(15)	Identifier of customer transaction associated with this adjustment
OPEN_TRX	VARCHAR2	(80)	Open Transaction Identifier
CUST_TRX_TYPE_ID	NUMBER	(15)	Transaction type identifier
CUSTOMER_ID	NUMBER	(15)	Identifier of customer associated with this adjustment
TRX_TYPE_NAME	VARCHAR2	(20)	Transaction Type associated with this adjustment
CUSTOMER_CLASS_CODE	VARCHAR2	(30)	Customer Class Code
BATCH_ID	NUMBER	(15)	Batch identifier
TERM_SEQUENCE_NUMBER	NUMBER		Sequence number of transaction term
ADJUSTMENT_ID	NUMBER	(15)	Adjustment identifier
ADJUSTMENT_NUMBER	VARCHAR2	(20)	Adjustment number automatically generated from AR_ADJUSTMENT_NUMBER_S
APPLY_DATE	DATE		Date adjustment applied to payment
SHIP_CUSTOMER_ID	NUMBER	(15)	Customer identifier
SHIP_CONTACT_ID	NUMBER	(15)	Contact identifier for shipments
REMIT_TO_ADDRESS_ID	NUMBER	(15)	Remit to address identifier
CLASS_NAME	VARCHAR2	(80)	Customer Class Name
OPEN_RECEIVABLE_FLAG	VARCHAR2	(1)	Open Receivable Flag
INTERNAL_NOTES	VARCHAR2	(240)	Stores the special instruction entered in the Transactions workbench. Value can be printed on an invoice with using the Print Invoice View
TRX_COMMENTS	VARCHAR2	(1760)	Stores transaction comments
PRINTING_COUNT	NUMBER		This column shows the number of times this invoice was printed. If there are multiple installments for this invoice, this will increment once for every installment that was printed.
PRINTING_ORIGINAL_DATE	DATE		Date the first installment is printed
PRINTING_LAST_PRINTED	DATE		Last date any installment was printed
PRINTING_PENDING	VARCHAR2	(1)	Indicates if this invoice is waiting to be printed. Y for yes, N otherwise.
LAST_PRINTED_SEQUENCE_NUMBER	NUMBER	(15)	Last Printed Sequence number
START_DATE_COMMITMENT	DATE		Indicates if this invoice is waiting to be printed. Y for yes, N otherwise.
END_DATE_COMMITMENT	DATE		Date a commitment becomes active
INITIAL_CUSTOMER_TRX_ID	NUMBER	(15)	Identifier of a related commitment
PREVIOUS_CUSTOMER_TRX_ID	NUMBER	(15)	Identifier for invoice credited
INVOICE_CURRENCY_CODE	VARCHAR2	(15)	Invoice currency
TERM_NAME	VARCHAR2	(15)	Payment term name
TERM_ID	NUMBER	(15)	Payment term identifier
PRIMARY_SALESREP_ID	NUMBER	(15)	Sale rep given primary credit for the transaction
SHIP_DATE_ACTUAL	DATE		Ship date
SHIP_VIA	VARCHAR2	(30)	Ship via
WAYBILL_NUMBER	VARCHAR2	(50)	Waybill number
PURCHASE_ORDER_NUMBER	VARCHAR2	(50)	Purchase Order Number
PURCHASE_ORDER_REVISION	VARCHAR2	(50)	Purchase order revision
PURCHASE_ORDER_DATE	DATE		Date of purchase order
TERM_DUE_DATE_FROM_PS	DATE		Due Date
TERM_PERCENT	NUMBER		Term Precent
BILL_TO_CUSTOMER_NUMBER	VARCHAR2	(30)	Customer number
BILL_TO_CUSTOMER_ID	NUMBER	(15)	Customer identifier
BILL_TO_CONTACT_ID	NUMBER	(15)	Contact identifier to send bills to
BILL_TO_SITE_USE_ID	NUMBER	(15)	Site use identifier billed
BILL_TO_LOCATION	VARCHAR2	(40)	Site identifier to send bills to
BILL_TO_CUSTOMER_NAME	VARCHAR2	(50)	Customer Name to send bills to
DEFAULT_BILL_ATTN	VARCHAR2	(91)	Default Last Name of the Bill To Contact
BILL_TO_SITE_TAX_REFERENCE	VARCHAR2	(50)	Bill To Site Tax Reference
BILL_TO_CUST_TAX_REFERENCE	VARCHAR2	(50)	Bill To Customer Tax Refrence
BILL_TO_ADDRESS1	VARCHAR2	(240)	Bill To Address 1
BILL_TO_ADDRESS2	VARCHAR2	(240)	Bill To Address 2
BILL_TO_ADDRESS3	VARCHAR2	(240)	Bill To Address 3
BILL_TO_ADDRESS4	VARCHAR2	(240)	Bill To Address 4
BILL_TO_CITY	VARCHAR2	(60)	Bill To City
BILL_TO_STATE	VARCHAR2	(60)	Bill To State
BILL_TO_PROVINCE	VARCHAR2	(60)	Bill To Province
BILL_TO_POSTAL_CODE	VARCHAR2	(60)	Bill To Postal Code
BILL_TO_COUNTRY	VARCHAR2	(60)	Bill To Country
BILL_TO_COUNTRY_NAME	VARCHAR2	(80)	Default Bill To Country
BILL_TO_CONTACT_FIRST_NAME	VARCHAR2	(40)	First name of the person
BILL_TO_CONTACT_LAST_NAME	VARCHAR2	(50)	Last or surname of the person
BILL_TO_ATTN	VARCHAR2	(91)	Last Name of the Bill To Contact
BILL_TO_MAIL_STOP	VARCHAR2	(60)	Bill To Mail Stop
LINE_AMOUNT_ADJUSTED	NUMBER		Line amount adjusted as part of this adjustment
TAX_AMOUNT_ADJUSTED	NUMBER		Tax amount adjusted as part of this adjustment
FREIGHT_AMOUNT_ADJUSTED	NUMBER		Freight amount adjusted as part of this adjustment
TOTAL_AMOUNT_ADJUSTED	NUMBER		Adjustment amount
PRIMARY_SALESREP_NAME	VARCHAR2	(360)	Primary Sales Represantative Name
SHIP_VIA_DESCRIPTION	VARCHAR2	(80)	Freight description
SO_ORGANIZATION_ID	NUMBER		Organization identifier
SHIP_TO_CUSTOMER_NAME	VARCHAR2	(50)	Customer Name
SHIP_TO_ADDRESS1	VARCHAR2	(240)	Ship To Address 1
SHIP_TO_ADDRESS2	VARCHAR2	(240)	Ship To Address 2
SHIP_TO_ADDRESS3	VARCHAR2	(240)	Ship To Address 3
SHIP_TO_ADDRESS4	VARCHAR2	(240)	Ship To Address 4
SHIP_TO_CITY	VARCHAR2	(60)	Ship To City
SHIP_TO_POSTAL_CODE	VARCHAR2	(60)	Ship To Postal Code
SHIP_TO_COUNTRY	VARCHAR2	(60)	Ship To Country
SHIP_TO_COUNTRY_NAME	VARCHAR2	(80)	Default Ship To Country
SHIP_TO_SITE_USE_ID	NUMBER	(15)	Site Use identifier shipped
SHIP_TO_LOCATION	VARCHAR2	(40)	Site identifier to ship item to
SHIP_TO_SITE_TAX_REFERENCE	VARCHAR2	(50)	Ship To Site Tax Reference
SHIP_TO_CUST_TAX_REFERENCE	VARCHAR2	(50)	Ship To Customer Tax Refrence
SHIP_TO_STATE	VARCHAR2	(60)	Ship To State
SHIP_TO_PROVINCE	VARCHAR2	(60)	Ship To Province
SHIP_TO_CONTACT_FIRST_NAME	VARCHAR2	(40)	First name of the contact person
SHIP_TO_CONTACT_LAST_NAME	VARCHAR2	(50)	Last or surname of the contact person
SHIP_TO_ATTN	VARCHAR2	(91)	Last Name of the Ship To Contact
SHIP_TO_MAIL_STOP	VARCHAR2	(60)	Ship To Mail Stop
TAX_REFERENCE	VARCHAR2	(50)	Tax Reference
AMOUNT_APPLIED_TO_COMMITMENT	NUMBER		Amount Applied to commitment
REMIT_TO_ADDRESS1	VARCHAR2	(240)	Remit To Address 1
REMIT_TO_ADDRESS2	VARCHAR2	(240)	Remit To Address 2
REMIT_TO_ADDRESS3	VARCHAR2	(240)	Remit To Address 3
REMIT_TO_ADDRESS4	VARCHAR2	(240)	Remit To Address 4
REMIT_TO_CITY	VARCHAR2	(60)	Remit To City
REMIT_TO_STATE	VARCHAR2	(60)	Remit To State
REMIT_TO_POSTAL_CODE	VARCHAR2	(60)	Remit To Postal Code
REMIT_TO_COUNTRY	VARCHAR2	(60)	Remit To Country Identifier
REMIT_TO_COUNTRY_NAME	VARCHAR2	(80)	Remit To Country Name
TAX_REGISTRATION_NUMBER	VARCHAR2	(60)	Tax Registration Number
LAST_UPDATED_BY	NUMBER	(15)	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Standard who column - date when this row was created.
GL_DATE	DATE		General Ledger date
SET_OF_BOOKS_ID	NUMBER	(15)	General Ledger Set of Books used, only one currently supported
CODE_COMBINATION_ID	NUMBER	(15)	General Ledger account code combination
TYPE	VARCHAR2	(15)	Lookup code for adjustment type in AR_LOOKUPS
ADJUSTMENT_TYPE	VARCHAR2	(3)	Lookup code for adjustment creation type in AR_LOOKUPS
STATUS	VARCHAR2	(30)	Approval status, A for approve, U for unaccrued adjustments, R for rejected, and any other code for unapproved
RECEIVABLES_CHARGES_ADJUSTED	NUMBER		Charges adjusted as part of this adjustment
ASSOCIATED_CASH_RECEIPT_ID	NUMBER	(15)	Identifier of cash receipt associated with this adjustment
CHARGEBACK_CUSTOMER_TRX_ID	NUMBER	(15)	Identifier of chargeback transaction associated with this adjustment
CUSTOMER_TRX_LINE_ID	NUMBER	(15)	Identifier of customer transaction line associated with this adjustment
SUBSEQUENT_TRX_ID	NUMBER	(15)	CUSTOMER_TRX_ID of the invoice against the guarantee
PAYMENT_SCHEDULE_ID	NUMBER	(15)	Identifier of payment schedule associated with this adjustment
RECEIVABLES_TRX_ID	NUMBER	(15)	Identifier of receivables transaction associated with this adjustment
DISTRIBUTION_SET_ID	NUMBER	(15)	Identifier of distribution set associated with this adjustment
GL_POSTED_DATE	DATE		Date adjustment posted to General Ledger
COMMENTS	VARCHAR2	(2000)	Comments
AUTOMATICALLY_GENERATED	VARCHAR2	(1)	Y or N. No longer used.
CREATED_FROM	VARCHAR2	(30)	Form or concurrent program name that this adjustment was created from
REASON_CODE	VARCHAR2	(30)	Identifier of reason for this adjustment
POSTABLE	VARCHAR2	(1)	Y or null indicates whether this adjustment is postable or not
APPROVED_BY	NUMBER	(15)	Identifier of user approving the adjustment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)	Descriptive flexfield segment
POSTING_CONTROL_ID	NUMBER	(15)	Receivables posting batch identifier, -1, -2, and -4 for posted in previous releases and -3 for not posted
ACCTD_AMOUNT	NUMBER		Amount of journal entries
PROGRAM_APPLICATION_ID	NUMBER	(15)	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE		Concurrent Program who column - date when a program last updated this row).
REQUEST_ID	NUMBER	(15)	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ORG_ID	NUMBER	(15)	Organization identifier
USSGL_TRANSACTION_CODE	VARCHAR2	(30)	Value for the USSGL Transaction Code Flexfield
USSGL_TRANSACTION_CODE_CONTEXT	VARCHAR2	(30)	Context value for the USSGL Transaction Code Flexfield
DOC_SEQUENCE_VALUE	NUMBER	(15)	Document sequence number
DOC_SEQUENCE_ID	NUMBER	(15)	Document sequence identifier
ASSOCIATED_APPLICATION_ID	NUMBER	(15)	Identifier of the receipt application associated with this adjustment
CONS_INV_ID	NUMBER	(15)	Consolidated invoice number on which this transaction appeared

Query Text

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


SELECT TRX_NUMBER
,      TRX_DATE
,      CUSTOMER_TRX_ID
,      OPEN_TRX
,      CUST_TRX_TYPE_ID
,      CUSTOMER_ID
,      TRX_TYPE_NAME
,      CUSTOMER_CLASS_CODE
,      BATCH_ID
,      TERM_SEQUENCE_NUMBER
,      ADJUSTMENT_ID
,      ADJUSTMENT_NUMBER
,      APPLY_DATE
,      SHIP_CUSTOMER_ID
,      SHIP_CONTACT_ID
,      REMIT_TO_ADDRESS_ID
,      CLASS_NAME
,      OPEN_RECEIVABLE_FLAG
,      INTERNAL_NOTES
,      TRX_COMMENTS
,      PRINTING_COUNT
,      PRINTING_ORIGINAL_DATE
,      PRINTING_LAST_PRINTED
,      PRINTING_PENDING
,      LAST_PRINTED_SEQUENCE_NUMBER
,      START_DATE_COMMITMENT
,      END_DATE_COMMITMENT
,      INITIAL_CUSTOMER_TRX_ID
,      PREVIOUS_CUSTOMER_TRX_ID
,      INVOICE_CURRENCY_CODE
,      TERM_NAME
,      TERM_ID
,      PRIMARY_SALESREP_ID
,      SHIP_DATE_ACTUAL
,      SHIP_VIA
,      WAYBILL_NUMBER
,      PURCHASE_ORDER_NUMBER
,      PURCHASE_ORDER_REVISION
,      PURCHASE_ORDER_DATE
,      TERM_DUE_DATE_FROM_PS
,      TERM_PERCENT
,      BILL_TO_CUSTOMER_NUMBER
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_CONTACT_ID
,      BILL_TO_SITE_USE_ID
,      BILL_TO_LOCATION
,      BILL_TO_CUSTOMER_NAME
,      DEFAULT_BILL_ATTN
,      BILL_TO_SITE_TAX_REFERENCE
,      BILL_TO_CUST_TAX_REFERENCE
,      BILL_TO_ADDRESS1
,      BILL_TO_ADDRESS2
,      BILL_TO_ADDRESS3
,      BILL_TO_ADDRESS4
,      BILL_TO_CITY
,      BILL_TO_STATE
,      BILL_TO_PROVINCE
,      BILL_TO_POSTAL_CODE
,      BILL_TO_COUNTRY
,      BILL_TO_COUNTRY_NAME
,      BILL_TO_CONTACT_FIRST_NAME
,      BILL_TO_CONTACT_LAST_NAME
,      BILL_TO_ATTN
,      BILL_TO_MAIL_STOP
,      LINE_AMOUNT_ADJUSTED
,      TAX_AMOUNT_ADJUSTED
,      FREIGHT_AMOUNT_ADJUSTED
,      TOTAL_AMOUNT_ADJUSTED
,      PRIMARY_SALESREP_NAME
,      SHIP_VIA_DESCRIPTION
,      SO_ORGANIZATION_ID
,      SHIP_TO_CUSTOMER_NAME
,      SHIP_TO_ADDRESS1
,      SHIP_TO_ADDRESS2
,      SHIP_TO_ADDRESS3
,      SHIP_TO_ADDRESS4
,      SHIP_TO_CITY
,      SHIP_TO_POSTAL_CODE
,      SHIP_TO_COUNTRY
,      SHIP_TO_COUNTRY_NAME
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_LOCATION
,      SHIP_TO_SITE_TAX_REFERENCE
,      SHIP_TO_CUST_TAX_REFERENCE
,      SHIP_TO_STATE
,      SHIP_TO_PROVINCE
,      SHIP_TO_CONTACT_FIRST_NAME
,      SHIP_TO_CONTACT_LAST_NAME
,      SHIP_TO_ATTN
,      SHIP_TO_MAIL_STOP
,      TAX_REFERENCE
,      AMOUNT_APPLIED_TO_COMMITMENT
,      REMIT_TO_ADDRESS1
,      REMIT_TO_ADDRESS2
,      REMIT_TO_ADDRESS3
,      REMIT_TO_ADDRESS4
,      REMIT_TO_CITY
,      REMIT_TO_STATE
,      REMIT_TO_POSTAL_CODE
,      REMIT_TO_COUNTRY
,      REMIT_TO_COUNTRY_NAME
,      TAX_REGISTRATION_NUMBER
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      GL_DATE
,      SET_OF_BOOKS_ID
,      CODE_COMBINATION_ID
,      TYPE
,      ADJUSTMENT_TYPE
,      STATUS
,      RECEIVABLES_CHARGES_ADJUSTED
,      ASSOCIATED_CASH_RECEIPT_ID
,      CHARGEBACK_CUSTOMER_TRX_ID
,      CUSTOMER_TRX_LINE_ID
,      SUBSEQUENT_TRX_ID
,      PAYMENT_SCHEDULE_ID
,      RECEIVABLES_TRX_ID
,      DISTRIBUTION_SET_ID
,      GL_POSTED_DATE
,      COMMENTS
,      AUTOMATICALLY_GENERATED
,      CREATED_FROM
,      REASON_CODE
,      POSTABLE
,      APPROVED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      POSTING_CONTROL_ID
,      ACCTD_AMOUNT
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ORG_ID
,      USSGL_TRANSACTION_CODE
,      USSGL_TRANSACTION_CODE_CONTEXT
,      DOC_SEQUENCE_VALUE
,      DOC_SEQUENCE_ID
,      ASSOCIATED_APPLICATION_ID
,      CONS_INV_ID
FROM APPS.AR_INVOICE_ADJ_V;

Dependencies

[top of page]

APPS.AR_INVOICE_ADJ_V references the following:

APPS: AR_ADJUSTMENTS; AR_INVOICE_SQL_FUNC_PUB - show dependent code; AR_LOOKUPS; AR_PAYMENT_SCHEDULES; AR_SYSTEM_PARAMETERS; FND_TERRITORIES_VL; HZ_CUST_ACCOUNTS; HZ_CUST_ACCOUNT_ROLES; HZ_CUST_ACCT_SITES; HZ_CUST_SITE_USES; HZ_LOCATIONS; HZ_ORG_CONTACTS; HZ_PARTIES; HZ_PARTY_SITES; HZ_RELATIONSHIPS; ORG_FREIGHT; RA_CUSTOMER_TRX; RA_CUST_TRX_TYPES; RA_SALESREPS; RA_TERMS; RA_TERMS_LINES

APPS.AR_INVOICE_ADJ_V is not referenced by any database object