[Home] [Help] [Dependency Information]
Object Name: | AR_INVOICE_ADJ_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AR.AR_INVOICE_ADJ_V |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | 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 |
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;
APPS.AR_INVOICE_ADJ_V is not referenced by any database object
|
|
|