[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | RA_CUSTOMER_TRX_LINES_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.RA_CUSTOMER_TRX_LINES_ALL
|
| Subobject Name: | |
| Status: | VALID |
The RA_CUSTOMER_TRX_LINES_ALL table stores information about invoice, debit memo, credit memo, bills receivable, and commitment lines. For example, an invoice can have one line for Product A and another line for Product B. Each line requires one row in this table.
.
Invoice, debit memo, credit memo, bills receivable, and commitment lines are distinguished by the transaction type of the corresponding row in the RA_CUSTOMER_TRX_ALL table. Credit memos must also have a value in the PREVIOUS_CUSTOMER_TRX_LINE_ID column. On-account credits, which are not related to specific invoices or invoice lines when they are created, will not have values in this column.
.
The QUANTITY_ORDERED column stores the amount of product that was ordered. The QUANTITY_INVOICED column stores the amount of product that was invoiced. For manually entered invoices, the QUANTITY_ORDERED and QUANTITY_INVOICED columns must be the same. For invoices that were imported through AutoInvoice, the QUANTITY_ORDERED and QUANTITY_INVOICED columns can be different. If you enter a credit memo, the QUANTITY_CREDITED column stores the amount of product that was credited.
.
The UOM_CODE column stores the unit of measure code as defined in the MTL_UNITS_OF_MEASURE table. The UNIT_STANDARD_PRICE column stores the list price per unit for this transaction line. The UNIT_SELLING_PRICE column stores the selling price per unit for this transaction line. For transactions that were imported through AutoInvoice, the UNIT_STANDARD_PRICE and UNIT_SELLING_PRICE columns can be different. The DESCRIPTION, TAXING_RULE, QUANTITY_ORDERED, UNIT_STANDARD_PRICE, UOM_CODE, and UNIT_SELLING_PRICE columns are required even though they are null allowed.
.
Receivables uses the LINE_TYPE column to distinguish between the different types of lines that are stored in this table. LINE represents regular invoice lines that normally refer to an item. TAX represents a tax line. The LINK_TO_CUST_TRX_LINE_ID column references the invoice line that is associated with the row that holds the TAX line type. FREIGHT is similar to TAX, but you can have at most one freight line per invoice line. You can also have one freight line that has a null LINK_TO_CUST_TRX_LINE_ID column. An invoice that has one freight line with a null LINK_TO_CUST_TRX_LINE_ID column has header-level freight.
.
CB represents a chargeback line. For every row in this table that belongs to a completed postable or nonpostable transaction, where the RA_CUSTOMER_TRX.COMPLETE_FLAG is Y, there must be at least one row in the RA_CUST_TRX_LINE_GL_DIST table that stores accounting information. There must be at least one row in this table even for nonpostable transactions.
.
The primary key for this table is CUSTOMER_TRX_LINE_ID.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| RA_CUSTOMER_TRX_LINES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CUSTOMER_TRX_LINE_ID
|
| RA_CUSTOMER_TRX_LINES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PREVIOUS_CUSTOMER_TRX_LINE_ID
|
| RA_CUSTOMER_TRX_LINES_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BR_REF_CUSTOMER_TRX_ID
|
| RA_CUSTOMER_TRX_LINES_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BR_REF_PAYMENT_SCHEDULE_ID
|
| RA_CUSTOMER_TRX_LINES_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BR_ADJUSTMENT_ID
|
| RA_CUSTOMER_TRX_LINES_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUSTOMER_TRX_ID
LINE_NUMBER
|
| RA_CUSTOMER_TRX_LINES_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LINK_TO_CUST_TRX_LINE_ID
|
| RA_CUSTOMER_TRX_LINES_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REQUEST_ID
CUSTOMER_TRX_ID
LINE_TYPE
|
| RA_CUSTOMER_TRX_LINES_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PREVIOUS_CUSTOMER_TRX_ID
|
| RA_CUSTOMER_TRX_LINES_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AUTORULE_COMPLETE_FLAG
CUSTOMER_TRX_ID
|
| RA_CUSTOMER_TRX_LINES_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SALES_TAX_ID
|
| RA_CUSTOMER_TRX_LINES_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ITEM_EXCEPTION_RATE_ID
|
| RA_CUSTOMER_TRX_LINES_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SALES_ORDER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CUSTOMER_TRX_LINE_ID | NUMBER | (15) | Yes | Invoice line identifier |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| 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). | |
| CUSTOMER_TRX_ID | NUMBER | (15) | Yes | Invoice identifier |
| LINE_NUMBER | NUMBER | Yes | Line number of the invoice | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books identifier |
| REASON_CODE | VARCHAR2 | (30) | Reason code identifier | |
| INVENTORY_ITEM_ID | NUMBER | (15) | Inventory item identifier. Mutually exclusive with the column MEMO_LINE_ID. | |
| DESCRIPTION | VARCHAR2 | (240) | Line description | |
| PREVIOUS_CUSTOMER_TRX_ID | NUMBER | (15) | Credit memo's invoice identifier | |
| PREVIOUS_CUSTOMER_TRX_LINE_ID | NUMBER | (15) | Credit memo line's invoice line identifier | |
| QUANTITY_ORDERED | NUMBER | Quantity of an order | ||
| QUANTITY_CREDITED | NUMBER | Quantity credited | ||
| QUANTITY_INVOICED | NUMBER | Quantity of invoice line | ||
| UNIT_STANDARD_PRICE | NUMBER | List price per unit. Price is gross of inclusive taxes. There is no separate gross standard price. | ||
| UNIT_SELLING_PRICE | NUMBER | Selling price per unit for a transaction line | ||
| SALES_ORDER | VARCHAR2 | (50) | Sales order | |
| SALES_ORDER_REVISION | NUMBER | Not currently used | ||
| SALES_ORDER_LINE | VARCHAR2 | (30) | Sales order line | |
| SALES_ORDER_DATE | DATE | Sales order date | ||
| ACCOUNTING_RULE_ID | NUMBER | (15) | Accounting rule identifier | |
| ACCOUNTING_RULE_DURATION | NUMBER | (15) | The number of periods in which revenue is to be recognized. Must be filled in for lines with fixed and variable duration rules. | |
| LINE_TYPE | VARCHAR2 | (20) | Yes | Receivables lookup code for STD_LINE_TYPE |
| 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 | |
| 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). | |
| 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). | ||
| RULE_START_DATE | DATE | First GL date of the invoice. Only used for invoice with rules | ||
| INITIAL_CUSTOMER_TRX_LINE_ID | NUMBER | (15) | Identifies the initial transaction line for the customer | |
| INTERFACE_LINE_CONTEXT | VARCHAR2 | (30) | Interface line context | |
| INTERFACE_LINE_ATTRIBUTE1 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE2 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE3 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE4 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE5 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE6 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE7 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE8 | VARCHAR2 | (150) | Interface line attribute value | |
| SALES_ORDER_SOURCE | VARCHAR2 | (50) | The source of the sales order | |
| TAXABLE_FLAG | VARCHAR2 | (1) | No longer used | |
| EXTENDED_AMOUNT | NUMBER | Yes | Transaction line amount | |
| REVENUE_AMOUNT | NUMBER | Transaction line revenue amount | ||
| AUTORULE_COMPLETE_FLAG | VARCHAR2 | (1) | Indicates if all account assignments have been created. Y for yes, N otherwise. | |
| LINK_TO_CUST_TRX_LINE_ID | NUMBER | (15) | Link to transaction line identifier | |
| 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 | |
| TAX_PRECEDENCE | NUMBER | Tax precedence for a tax line | ||
| TAX_RATE | NUMBER | Tax rate for a line | ||
| ITEM_EXCEPTION_RATE_ID | NUMBER | (15) | Tax exception identifier | |
| TAX_EXEMPTION_ID | NUMBER | (15) | Tax exemption identifier | |
| MEMO_LINE_ID | NUMBER | (15) | Memo line description identifier. Mutually exclusive with the column INVENTORY_ITEM_ID. | |
| AUTORULE_DURATION_PROCESSED | NUMBER | (15) | Number of times revenue recognition has created distributions for the line | |
| UOM_CODE | VARCHAR2 | (3) | Unit of measure code | |
| DEFAULT_USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | Default value for the USSGL Transaction Code Flexfield | |
| DEFAULT_USSGL_TRX_CODE_CONTEXT | VARCHAR2 | (30) | Default context value for the USSGL Transaction Code Flexfield | |
| INTERFACE_LINE_ATTRIBUTE10 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE11 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE12 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE13 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE14 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE15 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE9 | VARCHAR2 | (150) | Interface line attribute value | |
| VAT_TAX_ID | NUMBER | (15) | Unique identifier for AR_VAT_TAX | |
| AUTOTAX | VARCHAR2 | (1) | Indicates if this tax line was generated automatically by the tax engine. Y for yes, N otherwise. | |
| LAST_PERIOD_TO_CREDIT | NUMBER | Last period to credit for unit credit memos against invoices with rules | ||
| ITEM_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
| TAX_EXEMPT_FLAG | VARCHAR2 | (1) | Tax Lines are controlled by the lookup (TAX_CONTROL_FLAG), which allows for standard tax, exempt tax, and required tax. | |
| TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | Exemption certificate number for item lines that have TAX_EXEMPT_FLAG set to E for exempt | |
| TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | Tax Exempt Reason, for item lines that have tax_exempt_flag set to "E" (exempt) | |
| TAX_VENDOR_RETURN_CODE | VARCHAR2 | (30) | Warning code returned during vendor calculation of a sales tax rate, used for diagnostics and support. Only applicable if the artaxvdr() returns TAX_SUCCESS | |
| SALES_TAX_ID | NUMBER | (15) | Not currently used in the production release - replaced by location_segment_id | |
| LOCATION_SEGMENT_ID | NUMBER | (15) | This column points to the record in the AR_LOCATION_VALUES table from which AutoAccounting derived the tax account for this line | |
| MOVEMENT_ID | NUMBER | (15) | Intrastat movement ID number | |
| ORG_ID | NUMBER | (15) | Organization identifier | |
| WH_UPDATE_DATE | DATE | Date sent to data warehouse | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved for country-specific functionality | |
| GROSS_UNIT_SELLING_PRICE | NUMBER | Unit selling price inclusive of tax amounts | ||
| GROSS_EXTENDED_AMOUNT | NUMBER | Amount gross of inclusive tax amounts | ||
| AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | (1) | Y indicates tax is inclusive. N indicates tax is exclusive. NULL for lines indicates tax is not-overridable or tax is a tax group. Cannot be NULL for tax types. Must be NULL for other types. | |
| TAXABLE_AMOUNT | NUMBER | The taxable amount for lines of the tax type that are tax inclusive | ||
| WAREHOUSE_ID | NUMBER | (15) | Foreign key to the HR_ORGANIZATIONS table. The warehouse identifies the ship-from location and can be used to control taxation. Within the US, the Warehouse ID is important when calculating tax on the origin/modified origin state sales tax. Outside the US you can use tax groups and conditions to build a schedule of multiple conditional taxes based on both the ship-from and ship-to county/county/state or provinces. | |
| TRANSLATED_DESCRIPTION | VARCHAR2 | (1000) | Translated description of this transaction line. | |
| EXTENDED_ACCTD_AMOUNT | NUMBER | Transaction line amount in functional currency for bills receivable | ||
| BR_REF_CUSTOMER_TRX_ID | NUMBER | (15) | Transaction ID of a transaction exchanged for a bills receivable | |
| BR_REF_PAYMENT_SCHEDULE_ID | NUMBER | (15) | Payment Schedule ID of a transaction exchanged for a bills receivable | |
| BR_ADJUSTMENT_ID | NUMBER | (15) | Adjustment identifier of a non-accounting adjustment created when a transaction is exchanged for a bills receivable | |
| MRC_EXTENDED_ACCTD_AMOUNT | VARCHAR2 | (2000) | MRC only: Concatenated string of reporting Set of Books, with amount in reporting currency(s) pairs. | |
| PAYMENT_SET_ID | NUMBER | (15) | Identifies the prepayment application's payment set | |
| CONTRACT_LINE_ID | NUMBER | Identifies the contract line from Oracle Contracts Core that is associated with this line | ||
| SOURCE_DATA_KEY1 | VARCHAR2 | (150) | Identifies source data from original system | |
| SOURCE_DATA_KEY2 | VARCHAR2 | (150) | Identifies source data from original system | |
| SOURCE_DATA_KEY3 | VARCHAR2 | (150) | Identifies source data from original system | |
| SOURCE_DATA_KEY4 | VARCHAR2 | (150) | Identifies source data from original system | |
| SOURCE_DATA_KEY5 | VARCHAR2 | (150) | Identifies source data from original system | |
| INVOICED_LINE_ACCTG_LEVEL | VARCHAR2 | (15) | Identifies accounting level for invoiceable lines in original system | |
| OVERRIDE_AUTO_ACCOUNTING_FLAG | VARCHAR2 | (1) | Overrides AutoAccounting | |
| SHIP_TO_CUSTOMER_ID | NUMBER | (15) | Identifies ship-to customer | |
| SHIP_TO_ADDRESS_ID | NUMBER | (15) | Identifies ship-to address | |
| SHIP_TO_SITE_USE_ID | NUMBER | (15) | Identifies ship-to site | |
| SHIP_TO_CONTACT_ID | NUMBER | (15) | Identifies ship-to contact or recipient | |
| HISTORICAL_FLAG | VARCHAR2 | (1) | Y, N, or NULL indicates if transaction line existed prior to implementation of eTax | |
| TAX_LINE_ID | NUMBER | (15) | Identifies the detail tax line in ZX_LINES that corresponds to this tax line of eTax | |
| LINE_RECOVERABLE | NUMBER | Line amount for this line that is considered recoverable for eTax calculations | ||
| TAX_RECOVERABLE | NUMBER | Total tax amount associated with this line that is considered recoverable for eTax calculations | ||
| TAX_CLASSIFICATION_CODE | VARCHAR2 | (50) | Single tax attribute code supported by eTax for backward compatibility. Represents a tax code or tax group as defined in eTax output tax classifications. | |
| AMOUNT_DUE_REMAINING | NUMBER | remaining balance | ||
| ACCTD_AMOUNT_DUE_REMAINING | NUMBER | accounted remaining balance | ||
| AMOUNT_DUE_ORIGINAL | NUMBER | original balance | ||
| ACCTD_AMOUNT_DUE_ORIGINAL | NUMBER | accounted original balance | ||
| CHRG_AMOUNT_REMAINING | NUMBER | charges balance on revenue line | ||
| CHRG_ACCTD_AMOUNT_REMAINING | NUMBER | accounted charges balance on revenue line | ||
| FRT_ADJ_REMAINING | NUMBER | freight adjusted amount on revenue line | ||
| FRT_ADJ_ACCTD_REMAINING | NUMBER | freight adjusted accounted amount on revenue line. | ||
| FRT_ED_AMOUNT | NUMBER | earned discount on freight assigned to the revenue line. | ||
| FRT_ED_ACCTD_AMOUNT | NUMBER | earned accounted discount on freight assigned to the revenue line. | ||
| FRT_UNED_AMOUNT | NUMBER | unearned discount on freight assigned to the revenue line. | ||
| FRT_UNED_ACCTD_AMOUNT | NUMBER | unearned accounted discount on freight assigned to the revenue line. | ||
| DEFERRAL_EXCLUSION_FLAG | VARCHAR2 | (1) | Excludes line from automated revenue deferral | |
| RULE_END_DATE | DATE | Last GL date of the invoice. Only used for invoice | ||
| PAYMENT_TRXN_EXTENSION_ID | NUMBER | (15) | Payment extension identifier | |
| INTEREST_LINE_ID | NUMBER | (15) | Fkey late charge |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER_TRX_LINE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CUSTOMER_TRX_ID
, LINE_NUMBER
, SET_OF_BOOKS_ID
, REASON_CODE
, INVENTORY_ITEM_ID
, DESCRIPTION
, PREVIOUS_CUSTOMER_TRX_ID
, PREVIOUS_CUSTOMER_TRX_LINE_ID
, QUANTITY_ORDERED
, QUANTITY_CREDITED
, QUANTITY_INVOICED
, UNIT_STANDARD_PRICE
, UNIT_SELLING_PRICE
, SALES_ORDER
, SALES_ORDER_REVISION
, SALES_ORDER_LINE
, SALES_ORDER_DATE
, ACCOUNTING_RULE_ID
, ACCOUNTING_RULE_DURATION
, LINE_TYPE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, RULE_START_DATE
, INITIAL_CUSTOMER_TRX_LINE_ID
, INTERFACE_LINE_CONTEXT
, INTERFACE_LINE_ATTRIBUTE1
, INTERFACE_LINE_ATTRIBUTE2
, INTERFACE_LINE_ATTRIBUTE3
, INTERFACE_LINE_ATTRIBUTE4
, INTERFACE_LINE_ATTRIBUTE5
, INTERFACE_LINE_ATTRIBUTE6
, INTERFACE_LINE_ATTRIBUTE7
, INTERFACE_LINE_ATTRIBUTE8
, SALES_ORDER_SOURCE
, TAXABLE_FLAG
, EXTENDED_AMOUNT
, REVENUE_AMOUNT
, AUTORULE_COMPLETE_FLAG
, LINK_TO_CUST_TRX_LINE_ID
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, TAX_PRECEDENCE
, TAX_RATE
, ITEM_EXCEPTION_RATE_ID
, TAX_EXEMPTION_ID
, MEMO_LINE_ID
, AUTORULE_DURATION_PROCESSED
, UOM_CODE
, DEFAULT_USSGL_TRANSACTION_CODE
, DEFAULT_USSGL_TRX_CODE_CONTEXT
, INTERFACE_LINE_ATTRIBUTE10
, INTERFACE_LINE_ATTRIBUTE11
, INTERFACE_LINE_ATTRIBUTE12
, INTERFACE_LINE_ATTRIBUTE13
, INTERFACE_LINE_ATTRIBUTE14
, INTERFACE_LINE_ATTRIBUTE15
, INTERFACE_LINE_ATTRIBUTE9
, VAT_TAX_ID
, AUTOTAX
, LAST_PERIOD_TO_CREDIT
, ITEM_CONTEXT
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_VENDOR_RETURN_CODE
, SALES_TAX_ID
, LOCATION_SEGMENT_ID
, MOVEMENT_ID
, ORG_ID
, WH_UPDATE_DATE
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, GROSS_UNIT_SELLING_PRICE
, GROSS_EXTENDED_AMOUNT
, AMOUNT_INCLUDES_TAX_FLAG
, TAXABLE_AMOUNT
, WAREHOUSE_ID
, TRANSLATED_DESCRIPTION
, EXTENDED_ACCTD_AMOUNT
, BR_REF_CUSTOMER_TRX_ID
, BR_REF_PAYMENT_SCHEDULE_ID
, BR_ADJUSTMENT_ID
, MRC_EXTENDED_ACCTD_AMOUNT
, PAYMENT_SET_ID
, CONTRACT_LINE_ID
, SOURCE_DATA_KEY1
, SOURCE_DATA_KEY2
, SOURCE_DATA_KEY3
, SOURCE_DATA_KEY4
, SOURCE_DATA_KEY5
, INVOICED_LINE_ACCTG_LEVEL
, OVERRIDE_AUTO_ACCOUNTING_FLAG
, SHIP_TO_CUSTOMER_ID
, SHIP_TO_ADDRESS_ID
, SHIP_TO_SITE_USE_ID
, SHIP_TO_CONTACT_ID
, HISTORICAL_FLAG
, TAX_LINE_ID
, LINE_RECOVERABLE
, TAX_RECOVERABLE
, TAX_CLASSIFICATION_CODE
, AMOUNT_DUE_REMAINING
, ACCTD_AMOUNT_DUE_REMAINING
, AMOUNT_DUE_ORIGINAL
, ACCTD_AMOUNT_DUE_ORIGINAL
, CHRG_AMOUNT_REMAINING
, CHRG_ACCTD_AMOUNT_REMAINING
, FRT_ADJ_REMAINING
, FRT_ADJ_ACCTD_REMAINING
, FRT_ED_AMOUNT
, FRT_ED_ACCTD_AMOUNT
, FRT_UNED_AMOUNT
, FRT_UNED_ACCTD_AMOUNT
, DEFERRAL_EXCLUSION_FLAG
, RULE_END_DATE
, PAYMENT_TRXN_EXTENSION_ID
, INTEREST_LINE_ID
FROM AR.RA_CUSTOMER_TRX_LINES_ALL;
AR.RA_CUSTOMER_TRX_LINES_ALL does not reference any database object
AR.RA_CUSTOMER_TRX_LINES_ALL is referenced by following:
AR
RA_CUSTOMER_TRX_LINES_ALL#
|
|
|
|