[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | RA_INTERFACE_LINES_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.RA_INTERFACE_LINES_ALL
|
| Subobject Name: | |
| Status: | VALID |
The RA_INTERFACE_LINES_ALL table stores interface information for each invoice line that AutoInvoice imports into Oracle Receivables. Please refer to the appendix of the Oracle Receivables User Guide or online help for more detailed information on Open Interface table columns, including import validation and destination columns.
.
The primary key for this table is INTERFACE_LINE_ID.
Scope: public
Product: AR
Lifecycle: active
Display Name: AR Interface Lines
Category: BUSINESS_ENTITY AR_INVOICE
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| RA_INTERFACE_LINES_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 INTERFACE_LINE_ID
|
| RA_INTERFACE_LINES_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
REQUEST_ID
|
| RA_INTERFACE_LINES_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
CUSTOMER_TRX_ID
|
| RA_INTERFACE_LINES_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
LINK_TO_LINE_ID
|
| RA_INTERFACE_LINES_N4 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
REFERENCE_LINE_ID
|
| RA_INTERFACE_LINES_N5 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TRX_NUMBER
REQUEST_ID
|
| RA_INTERFACE_LINES_N6 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
DOCUMENT_NUMBER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INTERFACE_LINE_ID | NUMBER | (15) | Identifies the invoice line | |
| INTERFACE_LINE_CONTEXT | VARCHAR2 | (30) | Context of the Transaction Flexfield entered in columns ATTRIBUTE1-15 | |
| INTERFACE_LINE_ATTRIBUTE1 | VARCHAR2 | (150) | Attribute value used to uniquely identify this transaction | |
| INTERFACE_LINE_ATTRIBUTE2 | VARCHAR2 | (150) | Attribute value used to uniquely identify this transaction | |
| INTERFACE_LINE_ATTRIBUTE3 | VARCHAR2 | (150) | Attribute value used to uniquely identify this transaction | |
| INTERFACE_LINE_ATTRIBUTE4 | VARCHAR2 | (150) | Attribute value used to uniquely identify this transaction | |
| INTERFACE_LINE_ATTRIBUTE5 | VARCHAR2 | (150) | Attribute value used to uniquely identify this transaction | |
| INTERFACE_LINE_ATTRIBUTE6 | VARCHAR2 | (150) | Attribute value used to uniquely identify this transaction | |
| INTERFACE_LINE_ATTRIBUTE7 | VARCHAR2 | (150) | Attribute value used to uniquely identify this transaction | |
| INTERFACE_LINE_ATTRIBUTE8 | VARCHAR2 | (150) | Attribute value used to uniquely identify this transaction | |
| BATCH_SOURCE_NAME | VARCHAR2 | (50) | Yes | Name of the batch source |
| SET_OF_BOOKS_ID | NUMBER | (15) | Set of Books identifier | |
| LINE_TYPE | VARCHAR2 | (20) | Yes | Type of line this transaction identifies. LINE, TAX, FREIGHT, or CHARGES |
| DESCRIPTION | VARCHAR2 | (240) | Yes | Description |
| CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code |
| AMOUNT | NUMBER | Revenue amount of this transaction | ||
| CUST_TRX_TYPE_NAME | VARCHAR2 | (20) | Transaction type name | |
| CUST_TRX_TYPE_ID | NUMBER | (15) | Transaction type identifier | |
| TERM_NAME | VARCHAR2 | (15) | Name of the payment term | |
| TERM_ID | NUMBER | (15) | Identifies the payment term | |
| ORIG_SYSTEM_BATCH_NAME | VARCHAR2 | (40) | Batch identifier from foreign system | |
| ORIG_SYSTEM_BILL_CUSTOMER_REF | VARCHAR2 | (240) | Value used to uniquely identify this bill-to customer from the original system | |
| ORIG_SYSTEM_BILL_CUSTOMER_ID | NUMBER | (15) | Identifies the original Bill_to customer | |
| ORIG_SYSTEM_BILL_ADDRESS_REF | VARCHAR2 | (240) | Value used to uniquely identify the bill-to address from the original system | |
| ORIG_SYSTEM_BILL_ADDRESS_ID | NUMBER | (15) | Identifies the original bill-to address | |
| ORIG_SYSTEM_BILL_CONTACT_REF | VARCHAR2 | (240) | Value used to uniquely identify the billing contact from the original system | |
| ORIG_SYSTEM_BILL_CONTACT_ID | NUMBER | (15) | Identifies the original billing contact | |
| ORIG_SYSTEM_SHIP_CUSTOMER_REF | VARCHAR2 | (240) | Value used to uniquely identify the ship-to customer from the original system | |
| ORIG_SYSTEM_SHIP_CUSTOMER_ID | NUMBER | (15) | Identifies the original ship-to customer | |
| ORIG_SYSTEM_SHIP_ADDRESS_REF | VARCHAR2 | (240) | Value used to uniquely identify the shipping address from the original system | |
| ORIG_SYSTEM_SHIP_ADDRESS_ID | NUMBER | (15) | Identifies the original shipping address | |
| ORIG_SYSTEM_SHIP_CONTACT_REF | VARCHAR2 | (240) | Value used to uniquely identify the shipping contact from the original system | |
| ORIG_SYSTEM_SHIP_CONTACT_ID | NUMBER | (15) | Identifies the original shipping contact | |
| ORIG_SYSTEM_SOLD_CUSTOMER_REF | VARCHAR2 | (240) | Identifies the sold-to customer from the original system | |
| ORIG_SYSTEM_SOLD_CUSTOMER_ID | NUMBER | (15) | Value used to uniquely identify the sold-to customer from the original system | |
| LINK_TO_LINE_ID | NUMBER | (15) | This column is used by AutoInvoice. | |
| LINK_TO_LINE_CONTEXT | VARCHAR2 | (30) | Context name of the Transaction Flexfield data | |
| LINK_TO_LINE_ATTRIBUTE1 | VARCHAR2 | (150) | The link to your Transaction Flexfield attribute values | |
| LINK_TO_LINE_ATTRIBUTE2 | VARCHAR2 | (150) | The link to your Transaction Flexfield attribute values | |
| LINK_TO_LINE_ATTRIBUTE3 | VARCHAR2 | (150) | The link to your Transaction Flexfield attribute values | |
| LINK_TO_LINE_ATTRIBUTE4 | VARCHAR2 | (150) | The link to your Transaction Flexfield attribute values | |
| LINK_TO_LINE_ATTRIBUTE5 | VARCHAR2 | (150) | The link to your Transaction Flexfield attribute values | |
| LINK_TO_LINE_ATTRIBUTE6 | VARCHAR2 | (150) | The link to your Transaction Flexfield attribute values | |
| LINK_TO_LINE_ATTRIBUTE7 | VARCHAR2 | (150) | The link to your Transaction Flexfield attribute values | |
| RECEIPT_METHOD_NAME | VARCHAR2 | (30) | Name of the payment method | |
| RECEIPT_METHOD_ID | NUMBER | (15) | Identifies the payment method | |
| CONVERSION_TYPE | VARCHAR2 | (30) | Yes | The exchange rate type |
| CONVERSION_DATE | DATE | Exchange rate date | ||
| CONVERSION_RATE | NUMBER | Exchange rate | ||
| CUSTOMER_TRX_ID | NUMBER | (15) | Identifies the customer transaction. Used by AutoInvoice. | |
| TRX_DATE | DATE | Transaction date | ||
| GL_DATE | DATE | General Ledger date | ||
| DOCUMENT_NUMBER | NUMBER | (15) | Document number of the transaction | |
| TRX_NUMBER | VARCHAR2 | (20) | Number of the transaction | |
| LINE_NUMBER | NUMBER | (15) | The line number AutoInvoice assigns to the transaction | |
| QUANTITY | NUMBER | Number of units shipped, or number of the units on a credit memo | ||
| QUANTITY_ORDERED | NUMBER | Original number of units ordered for the transaction | ||
| UNIT_SELLING_PRICE | NUMBER | Selling price per unit | ||
| UNIT_STANDARD_PRICE | NUMBER | Standard price per unit | ||
| PRINTING_OPTION | VARCHAR2 | (20) | Printing option | |
| INTERFACE_STATUS | VARCHAR2 | (1) | Interface status of the transaction. Used by AutoInvoice. | |
| 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). | |
| RELATED_BATCH_SOURCE_NAME | VARCHAR2 | (50) | The name of the batch source of the document to which this transaction is related | |
| RELATED_TRX_NUMBER | VARCHAR2 | (20) | Document number to which this transaction is related | |
| RELATED_CUSTOMER_TRX_ID | NUMBER | (15) | Customer transaction identifier of the document to which this transaction is related | |
| PREVIOUS_CUSTOMER_TRX_ID | NUMBER | (15) | For credit memos, AutoInvoice defaults a value into this column using RA_INTERFACE_LINES.REFERENCE_LINE_ID | |
| CREDIT_METHOD_FOR_ACCT_RULE | VARCHAR2 | (30) | The credit method for crediting a transaction that uses an accounting rule | |
| CREDIT_METHOD_FOR_INSTALLMENTS | VARCHAR2 | (30) | The credit method for crediting a transaction that uses split payment terms | |
| REASON_CODE | VARCHAR2 | (30) | Reason code | |
| TAX_RATE | NUMBER | Tax rate for this tax line | ||
| TAX_CODE | VARCHAR2 | (50) | Tax code | |
| TAX_PRECEDENCE | NUMBER | Precedence number for this tax line. This column is used compute tax compounding. | ||
| EXCEPTION_ID | NUMBER | (15) | Identifies when a tax exception occurs. Used by AutoInvoice. | |
| EXEMPTION_ID | NUMBER | (15) | Identifies when a tax exemption occurs. Used by AutoInvoice. | |
| SHIP_DATE_ACTUAL | DATE | Shipment date | ||
| FOB_POINT | VARCHAR2 | (30) | Free on board point, which is the location at which the ownership title of the goods is transferred from the seller to the buyer | |
| SHIP_VIA | VARCHAR2 | (25) | Ship via code | |
| WAYBILL_NUMBER | VARCHAR2 | (50) | Waybill number | |
| INVOICING_RULE_NAME | VARCHAR2 | (30) | Invoicing rule name | |
| INVOICING_RULE_ID | NUMBER | (15) | Identifies the invoicing rule | |
| ACCOUNTING_RULE_NAME | VARCHAR2 | (30) | Accounting rule name | |
| ACCOUNTING_RULE_ID | NUMBER | (15) | Identifies the accounting rule | |
| ACCOUNTING_RULE_DURATION | NUMBER | (15) | Accounting rule duration | |
| RULE_START_DATE | DATE | Date the accounting rule for this transaction begins | ||
| PRIMARY_SALESREP_NUMBER | VARCHAR2 | (30) | Number of the primary salesperson | |
| PRIMARY_SALESREP_ID | NUMBER | (15) | Identifies the primary salesperson | |
| SALES_ORDER | VARCHAR2 | (50) | Sales order number | |
| SALES_ORDER_LINE | VARCHAR2 | (30) | Sales order line number | |
| SALES_ORDER_DATE | DATE | Date of the sales order | ||
| SALES_ORDER_SOURCE | VARCHAR2 | (50) | Source of the sales order | |
| SALES_ORDER_REVISION | NUMBER | Sales order revision number | ||
| PURCHASE_ORDER | VARCHAR2 | (50) | Purchase order number for this transaction | |
| PURCHASE_ORDER_REVISION | VARCHAR2 | (50) | Purchase order revision number | |
| PURCHASE_ORDER_DATE | DATE | Date of the purchase order | ||
| AGREEMENT_NAME | VARCHAR2 | (30) | Name of the customer agreement | |
| AGREEMENT_ID | NUMBER | (15) | Identifies the customer agreement | |
| MEMO_LINE_NAME | VARCHAR2 | (50) | Name of the standard memo line | |
| MEMO_LINE_ID | NUMBER | (15) | Identifies the standard memo line | |
| INVENTORY_ITEM_ID | NUMBER | (15) | Identifies the inventory item | |
| MTL_SYSTEM_ITEMS_SEG1 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG2 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG3 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG4 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG5 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG6 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG7 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG8 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG9 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG10 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG11 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG12 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG13 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG14 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG15 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG16 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG17 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG18 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG19 | VARCHAR2 | (40) | System Item Flexfield segment | |
| MTL_SYSTEM_ITEMS_SEG20 | VARCHAR2 | (40) | System Item Flexfield segment | |
| REFERENCE_LINE_ID | NUMBER | (15) | Identifies the line this transaction references | |
| REFERENCE_LINE_CONTEXT | VARCHAR2 | (30) | Context name of the reference line | |
| REFERENCE_LINE_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| REFERENCE_LINE_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| REFERENCE_LINE_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| REFERENCE_LINE_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| REFERENCE_LINE_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| REFERENCE_LINE_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| REFERENCE_LINE_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| TERRITORY_ID | NUMBER | (15) | Identifies the territory | |
| TERRITORY_SEGMENT1 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT2 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT3 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT4 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT5 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT6 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT7 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT8 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT9 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT10 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT11 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT12 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT13 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT14 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT15 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT16 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT17 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT18 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT19 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| TERRITORY_SEGMENT20 | VARCHAR2 | (25) | Descriptive Flexfield segment | |
| 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 | |
| HEADER_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield attribute category | |
| HEADER_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| HEADER_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| HEADER_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| HEADER_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| HEADER_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| HEADER_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| HEADER_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| HEADER_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| HEADER_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| HEADER_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| HEADER_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| HEADER_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| HEADER_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| HEADER_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| HEADER_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| COMMENTS | VARCHAR2 | (240) | Comments | |
| INTERNAL_NOTES | VARCHAR2 | (240) | Internal notes | |
| INITIAL_CUSTOMER_TRX_ID | NUMBER | (15) | Identifies the initial customer. Used by AutoInvoice. | |
| USSGL_TRANSACTION_CODE_CONTEXT | VARCHAR2 | (30) | Context value for the USSGL Transaction Code Flexfield | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | USSGL Transaction Code | |
| ACCTD_AMOUNT | NUMBER | Not currently used | ||
| CUSTOMER_BANK_ACCOUNT_ID | NUMBER | (15) | Identifies the bill-to customer bank account | |
| CUSTOMER_BANK_ACCOUNT_NAME | VARCHAR2 | (80) | Name of the bill-to customer's bank account | |
| UOM_CODE | VARCHAR2 | (3) | Unit of measure code | |
| UOM_NAME | VARCHAR2 | (25) | Unit of measure name | |
| DOCUMENT_NUMBER_SEQUENCE_ID | NUMBER | (15) | AutoInvoice uses this column to store the document sequence identifier for this transaction | |
| LINK_TO_LINE_ATTRIBUTE10 | VARCHAR2 | (150) | The link to your Transaction Flexfield attribute values | |
| LINK_TO_LINE_ATTRIBUTE11 | VARCHAR2 | (150) | The link to your Transaction Flexfield attribute values | |
| LINK_TO_LINE_ATTRIBUTE12 | VARCHAR2 | (150) | The link to your Transaction Flexfield attribute values | |
| LINK_TO_LINE_ATTRIBUTE13 | VARCHAR2 | (150) | The link to your Transaction Flexfield attribute values | |
| LINK_TO_LINE_ATTRIBUTE14 | VARCHAR2 | (150) | The link to your Transaction Flexfield attribute values | |
| LINK_TO_LINE_ATTRIBUTE15 | VARCHAR2 | (150) | The link to your Transaction Flexfield attribute values | |
| LINK_TO_LINE_ATTRIBUTE8 | VARCHAR2 | (150) | The link to your Transaction Flexfield attribute values | |
| LINK_TO_LINE_ATTRIBUTE9 | VARCHAR2 | (150) | The link to your Transaction Flexfield attribute values | |
| REFERENCE_LINE_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| REFERENCE_LINE_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| REFERENCE_LINE_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| REFERENCE_LINE_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| REFERENCE_LINE_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| REFERENCE_LINE_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| REFERENCE_LINE_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| REFERENCE_LINE_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| 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) | If you enter a value in TAX_CODE, AutoInvoice defaults a value in this column. | |
| REASON_CODE_MEANING | VARCHAR2 | (80) | Meaning of the reason code | |
| LAST_PERIOD_TO_CREDIT | NUMBER | Last period to credit for unit credit memos against invoices with rules | ||
| PAYING_CUSTOMER_ID | NUMBER | (15) | Identifies the paying customer | |
| PAYING_SITE_USE_ID | NUMBER | (15) | Used by AutoInvoice | |
| TAX_EXEMPT_FLAG | VARCHAR2 | (1) | Item lines either have S for standard taxation, or have tax lines with R for required or E for exempt. | |
| TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | Tax exempt reason code for item lines that have the TAX_EXEMPT_FLAG column set to E for exempt. | |
| TAX_EXEMPT_REASON_CODE_MEANING | VARCHAR2 | (80) | National Language implementation of the TAX_REASON_CODE | |
| TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | Tax exemption certificate number for item lines that have the TAX_EXEMPT_FLAG set to E for exempt. | |
| SALES_TAX_ID | NUMBER | (15) | Identifies sales tax, used by AutoInvoice | |
| 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. | ||
| 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). | |
| LOCATION_SEGMENT_ID | NUMBER | (15) | This column is used by AutoInvoice and should be left null. Autoinvoice defaults a value in this column if you are crediting a sales tax line. | |
| MOVEMENT_ID | NUMBER | (15) | Intrastat movement ID number | |
| ORG_ID | NUMBER | (15) | Organization identifier | |
| AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | (1) | Y indicates tax is inclusive. N indicates tax is exclusive. NULL indicates that this flag should be defaulted from the tax code. | |
| HEADER_GDF_ATTR_CATEGORY | VARCHAR2 | (30) | Global Descriptive Flexfield segment | |
| HEADER_GDF_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE21 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE22 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE23 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE24 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE25 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE26 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE27 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE28 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE29 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| HEADER_GDF_ATTRIBUTE30 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTR_CATEGORY | VARCHAR2 | (30) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GDF_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| RESET_TRX_DATE_FLAG | VARCHAR2 | (1) | Indicates if AutoInvoice resets the transaction date to the General Ledger date when the transaction date is not passed. Y for yes, N otherwise. | |
| PAYMENT_SERVER_ORDER_NUM | VARCHAR2 | (80) | A number that indicates the credit card payment was authorized by Oracle Payment Server | |
| APPROVAL_CODE | VARCHAR2 | (80) | Payment approval code from the credit card issuer | |
| ADDRESS_VERIFICATION_CODE | VARCHAR2 | (80) | Credit card address verification code from Oracle Payment Server | |
| 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 of 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 | |
| CONS_BILLING_NUMBER | VARCHAR2 | (30) | Imported billing number | |
| PROMISED_COMMITMENT_AMOUNT | NUMBER | Amount reserved for this line from the specified commitment | ||
| PAYMENT_SET_ID | NUMBER | (15) | Identifies the prepayment application's payment set | |
| ORIGINAL_GL_DATE | DATE | Stores the value of the GL_DATE column before Autoinvoice modifies the GL date. | ||
| CONTRACT_LINE_ID | NUMBER | Identifies the contract line from Oracle Contracts Core that is associated with this line | ||
| CONTRACT_ID | NUMBER | Identifies the contract 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 | |
| SOURCE_APPLICATION_ID | NUMBER | (15) | Identifies the application that supplied this transaction line | |
| SOURCE_EVENT_CLASS_CODE | VARCHAR2 | (30) | Identifies the event class provided by the source application | |
| SOURCE_ENTITY_CODE | VARCHAR2 | (30) | Identifies the entity provided by the source application | |
| SOURCE_TRX_ID | NUMBER | Identifies the transaction in the source application | ||
| SOURCE_TRX_LINE_ID | NUMBER | Identifies the transaction line in the source application | ||
| SOURCE_TRX_LINE_TYPE | VARCHAR2 | (30) | Identifies lowest level at which information is being passed from source application. Values can be HEADER, LINE, SHIPMENT, FREIGHT, or DISTRIBUTION. | |
| SOURCE_TRX_DETAIL_TAX_LINE_ID | NUMBER | (15) | Identifies the detail tax line in ZX_LINES that corresponds to this tax line | |
| HISTORICAL_FLAG | VARCHAR2 | (1) | Y, N, or NULL indicates if transaction line existed prior to implementation of eTax | |
| TAX_REGIME_CODE | VARCHAR2 | (30) | Represents a high-level entity for defining common set of tax rules | |
| TAX | VARCHAR2 | (30) | Represents a charge imposed by a fiscal or tax authority within a regime | |
| TAX_STATUS_CODE | VARCHAR2 | (30) | Represents the taxable nature of a product or service. Defined within the scope of a tax and tax regime. | |
| TAX_RATE_CODE | VARCHAR2 | (50) | Represents a numeric rate for calculations. Defined within the scope of a tax status, tax, and tax regime | |
| TAX_JURISDICTION_CODE | VARCHAR2 | (30) | Represents a geographic area where taxes are levied. Defined within the scope of a tax and tax regime. | |
| TAXABLE_AMOUNT | NUMBER | The taxable amount for lines of type TAX that are tax inclusive. | ||
| TAXABLE_FLAG | VARCHAR2 | (1) | Y, N, or NULL. Determines if the current line is taxable. | |
| LEGAL_ENTITY_ID | NUMBER | (15) | Identifies the legal entity responsible for issuing the invoice line. | |
| PARENT_LINE_ID | NUMBER | (15) | Parent line identifier | |
| DEFERRAL_EXCLUSION_FLAG | VARCHAR2 | (1) | Excludes line from automated revenue deferralExcludes line from automated revenue deferral | |
| PAYMENT_TRXN_EXTENSION_ID | NUMBER | (15) | Payment extension identifier | |
| RULE_END_DATE | DATE | Date when this transaction's accounting rule ends | ||
| PAYMENT_ATTRIBUTES | VARCHAR2 | (1000) | Payment attributes used for grouping transaction lines. | |
| APPLICATION_ID | NUMBER | (15) | Source application importing transactions into Receivables. | |
| BILLING_DATE | DATE | Date specified by feeder system for external consolidated billing schedules | ||
| TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | Transaction business category code of the transaction line | |
| PRODUCT_FISC_CLASSIFICATION | VARCHAR2 | (240) | Product fiscal classification code of the inventory item | |
| PRODUCT_CATEGORY | VARCHAR2 | (240) | Product category code of the transaction line | |
| PRODUCT_TYPE | VARCHAR2 | (240) | Product type code of the inventory item. Possible values are GOODS and SERVICES | |
| LINE_INTENDED_USE | VARCHAR2 | (240) | Intended use code of the transaction line. This identifies the purpose for which the product is used. | |
| ASSESSABLE_VALUE | NUMBER | Assessable value is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes. | ||
| DOCUMENT_SUB_TYPE | VARCHAR2 | (240) | Document sub type code | |
| DEFAULT_TAXATION_COUNTRY | VARCHAR2 | (2) | Default taxation country code | |
| USER_DEFINED_FISC_CLASS | VARCHAR2 | (30) | User defined fiscal classification code of the transaction line | |
| TAXED_UPSTREAM_FLAG | VARCHAR2 | (1) | Y or N indicates whether tax was calculated for this line in the source or upstream product. | |
| TAX_INVOICE_DATE | DATE | Transaction date for tax invoice generated by Receivables. | ||
| TAX_INVOICE_NUMBER | VARCHAR2 | (150) | Number for tax invoice generated by Receivables | |
| PAYMENT_TYPE_CODE | VARCHAR2 | (30) | Payment Type code | |
| MANDATE_LAST_TRX_FLAG | VARCHAR2 | (1) | Indicates if a transaction is the last one for a mandate. |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_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
, BATCH_SOURCE_NAME
, SET_OF_BOOKS_ID
, LINE_TYPE
, DESCRIPTION
, CURRENCY_CODE
, AMOUNT
, CUST_TRX_TYPE_NAME
, CUST_TRX_TYPE_ID
, TERM_NAME
, TERM_ID
, ORIG_SYSTEM_BATCH_NAME
, ORIG_SYSTEM_BILL_CUSTOMER_REF
, ORIG_SYSTEM_BILL_CUSTOMER_ID
, ORIG_SYSTEM_BILL_ADDRESS_REF
, ORIG_SYSTEM_BILL_ADDRESS_ID
, ORIG_SYSTEM_BILL_CONTACT_REF
, ORIG_SYSTEM_BILL_CONTACT_ID
, ORIG_SYSTEM_SHIP_CUSTOMER_REF
, ORIG_SYSTEM_SHIP_CUSTOMER_ID
, ORIG_SYSTEM_SHIP_ADDRESS_REF
, ORIG_SYSTEM_SHIP_ADDRESS_ID
, ORIG_SYSTEM_SHIP_CONTACT_REF
, ORIG_SYSTEM_SHIP_CONTACT_ID
, ORIG_SYSTEM_SOLD_CUSTOMER_REF
, ORIG_SYSTEM_SOLD_CUSTOMER_ID
, LINK_TO_LINE_ID
, LINK_TO_LINE_CONTEXT
, LINK_TO_LINE_ATTRIBUTE1
, LINK_TO_LINE_ATTRIBUTE2
, LINK_TO_LINE_ATTRIBUTE3
, LINK_TO_LINE_ATTRIBUTE4
, LINK_TO_LINE_ATTRIBUTE5
, LINK_TO_LINE_ATTRIBUTE6
, LINK_TO_LINE_ATTRIBUTE7
, RECEIPT_METHOD_NAME
, RECEIPT_METHOD_ID
, CONVERSION_TYPE
, CONVERSION_DATE
, CONVERSION_RATE
, CUSTOMER_TRX_ID
, TRX_DATE
, GL_DATE
, DOCUMENT_NUMBER
, TRX_NUMBER
, LINE_NUMBER
, QUANTITY
, QUANTITY_ORDERED
, UNIT_SELLING_PRICE
, UNIT_STANDARD_PRICE
, PRINTING_OPTION
, INTERFACE_STATUS
, REQUEST_ID
, RELATED_BATCH_SOURCE_NAME
, RELATED_TRX_NUMBER
, RELATED_CUSTOMER_TRX_ID
, PREVIOUS_CUSTOMER_TRX_ID
, CREDIT_METHOD_FOR_ACCT_RULE
, CREDIT_METHOD_FOR_INSTALLMENTS
, REASON_CODE
, TAX_RATE
, TAX_CODE
, TAX_PRECEDENCE
, EXCEPTION_ID
, EXEMPTION_ID
, SHIP_DATE_ACTUAL
, FOB_POINT
, SHIP_VIA
, WAYBILL_NUMBER
, INVOICING_RULE_NAME
, INVOICING_RULE_ID
, ACCOUNTING_RULE_NAME
, ACCOUNTING_RULE_ID
, ACCOUNTING_RULE_DURATION
, RULE_START_DATE
, PRIMARY_SALESREP_NUMBER
, PRIMARY_SALESREP_ID
, SALES_ORDER
, SALES_ORDER_LINE
, SALES_ORDER_DATE
, SALES_ORDER_SOURCE
, SALES_ORDER_REVISION
, PURCHASE_ORDER
, PURCHASE_ORDER_REVISION
, PURCHASE_ORDER_DATE
, AGREEMENT_NAME
, AGREEMENT_ID
, MEMO_LINE_NAME
, MEMO_LINE_ID
, INVENTORY_ITEM_ID
, MTL_SYSTEM_ITEMS_SEG1
, MTL_SYSTEM_ITEMS_SEG2
, MTL_SYSTEM_ITEMS_SEG3
, MTL_SYSTEM_ITEMS_SEG4
, MTL_SYSTEM_ITEMS_SEG5
, MTL_SYSTEM_ITEMS_SEG6
, MTL_SYSTEM_ITEMS_SEG7
, MTL_SYSTEM_ITEMS_SEG8
, MTL_SYSTEM_ITEMS_SEG9
, MTL_SYSTEM_ITEMS_SEG10
, MTL_SYSTEM_ITEMS_SEG11
, MTL_SYSTEM_ITEMS_SEG12
, MTL_SYSTEM_ITEMS_SEG13
, MTL_SYSTEM_ITEMS_SEG14
, MTL_SYSTEM_ITEMS_SEG15
, MTL_SYSTEM_ITEMS_SEG16
, MTL_SYSTEM_ITEMS_SEG17
, MTL_SYSTEM_ITEMS_SEG18
, MTL_SYSTEM_ITEMS_SEG19
, MTL_SYSTEM_ITEMS_SEG20
, REFERENCE_LINE_ID
, REFERENCE_LINE_CONTEXT
, REFERENCE_LINE_ATTRIBUTE1
, REFERENCE_LINE_ATTRIBUTE2
, REFERENCE_LINE_ATTRIBUTE3
, REFERENCE_LINE_ATTRIBUTE4
, REFERENCE_LINE_ATTRIBUTE5
, REFERENCE_LINE_ATTRIBUTE6
, REFERENCE_LINE_ATTRIBUTE7
, TERRITORY_ID
, TERRITORY_SEGMENT1
, TERRITORY_SEGMENT2
, TERRITORY_SEGMENT3
, TERRITORY_SEGMENT4
, TERRITORY_SEGMENT5
, TERRITORY_SEGMENT6
, TERRITORY_SEGMENT7
, TERRITORY_SEGMENT8
, TERRITORY_SEGMENT9
, TERRITORY_SEGMENT10
, TERRITORY_SEGMENT11
, TERRITORY_SEGMENT12
, TERRITORY_SEGMENT13
, TERRITORY_SEGMENT14
, TERRITORY_SEGMENT15
, TERRITORY_SEGMENT16
, TERRITORY_SEGMENT17
, TERRITORY_SEGMENT18
, TERRITORY_SEGMENT19
, TERRITORY_SEGMENT20
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, HEADER_ATTRIBUTE_CATEGORY
, HEADER_ATTRIBUTE1
, HEADER_ATTRIBUTE2
, HEADER_ATTRIBUTE3
, HEADER_ATTRIBUTE4
, HEADER_ATTRIBUTE5
, HEADER_ATTRIBUTE6
, HEADER_ATTRIBUTE7
, HEADER_ATTRIBUTE8
, HEADER_ATTRIBUTE9
, HEADER_ATTRIBUTE10
, HEADER_ATTRIBUTE11
, HEADER_ATTRIBUTE12
, HEADER_ATTRIBUTE13
, HEADER_ATTRIBUTE14
, HEADER_ATTRIBUTE15
, COMMENTS
, INTERNAL_NOTES
, INITIAL_CUSTOMER_TRX_ID
, USSGL_TRANSACTION_CODE_CONTEXT
, USSGL_TRANSACTION_CODE
, ACCTD_AMOUNT
, CUSTOMER_BANK_ACCOUNT_ID
, CUSTOMER_BANK_ACCOUNT_NAME
, UOM_CODE
, UOM_NAME
, DOCUMENT_NUMBER_SEQUENCE_ID
, LINK_TO_LINE_ATTRIBUTE10
, LINK_TO_LINE_ATTRIBUTE11
, LINK_TO_LINE_ATTRIBUTE12
, LINK_TO_LINE_ATTRIBUTE13
, LINK_TO_LINE_ATTRIBUTE14
, LINK_TO_LINE_ATTRIBUTE15
, LINK_TO_LINE_ATTRIBUTE8
, LINK_TO_LINE_ATTRIBUTE9
, REFERENCE_LINE_ATTRIBUTE10
, REFERENCE_LINE_ATTRIBUTE11
, REFERENCE_LINE_ATTRIBUTE12
, REFERENCE_LINE_ATTRIBUTE13
, REFERENCE_LINE_ATTRIBUTE14
, REFERENCE_LINE_ATTRIBUTE15
, REFERENCE_LINE_ATTRIBUTE8
, REFERENCE_LINE_ATTRIBUTE9
, INTERFACE_LINE_ATTRIBUTE10
, INTERFACE_LINE_ATTRIBUTE11
, INTERFACE_LINE_ATTRIBUTE12
, INTERFACE_LINE_ATTRIBUTE13
, INTERFACE_LINE_ATTRIBUTE14
, INTERFACE_LINE_ATTRIBUTE15
, INTERFACE_LINE_ATTRIBUTE9
, VAT_TAX_ID
, REASON_CODE_MEANING
, LAST_PERIOD_TO_CREDIT
, PAYING_CUSTOMER_ID
, PAYING_SITE_USE_ID
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_REASON_CODE
, TAX_EXEMPT_REASON_CODE_MEANING
, TAX_EXEMPT_NUMBER
, SALES_TAX_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LOCATION_SEGMENT_ID
, MOVEMENT_ID
, ORG_ID
, AMOUNT_INCLUDES_TAX_FLAG
, HEADER_GDF_ATTR_CATEGORY
, HEADER_GDF_ATTRIBUTE1
, HEADER_GDF_ATTRIBUTE2
, HEADER_GDF_ATTRIBUTE3
, HEADER_GDF_ATTRIBUTE4
, HEADER_GDF_ATTRIBUTE5
, HEADER_GDF_ATTRIBUTE6
, HEADER_GDF_ATTRIBUTE7
, HEADER_GDF_ATTRIBUTE8
, HEADER_GDF_ATTRIBUTE9
, HEADER_GDF_ATTRIBUTE10
, HEADER_GDF_ATTRIBUTE11
, HEADER_GDF_ATTRIBUTE12
, HEADER_GDF_ATTRIBUTE13
, HEADER_GDF_ATTRIBUTE14
, HEADER_GDF_ATTRIBUTE15
, HEADER_GDF_ATTRIBUTE16
, HEADER_GDF_ATTRIBUTE17
, HEADER_GDF_ATTRIBUTE18
, HEADER_GDF_ATTRIBUTE19
, HEADER_GDF_ATTRIBUTE20
, HEADER_GDF_ATTRIBUTE21
, HEADER_GDF_ATTRIBUTE22
, HEADER_GDF_ATTRIBUTE23
, HEADER_GDF_ATTRIBUTE24
, HEADER_GDF_ATTRIBUTE25
, HEADER_GDF_ATTRIBUTE26
, HEADER_GDF_ATTRIBUTE27
, HEADER_GDF_ATTRIBUTE28
, HEADER_GDF_ATTRIBUTE29
, HEADER_GDF_ATTRIBUTE30
, LINE_GDF_ATTR_CATEGORY
, LINE_GDF_ATTRIBUTE1
, LINE_GDF_ATTRIBUTE2
, LINE_GDF_ATTRIBUTE3
, LINE_GDF_ATTRIBUTE4
, LINE_GDF_ATTRIBUTE5
, LINE_GDF_ATTRIBUTE6
, LINE_GDF_ATTRIBUTE7
, LINE_GDF_ATTRIBUTE8
, LINE_GDF_ATTRIBUTE9
, LINE_GDF_ATTRIBUTE10
, LINE_GDF_ATTRIBUTE11
, LINE_GDF_ATTRIBUTE12
, LINE_GDF_ATTRIBUTE13
, LINE_GDF_ATTRIBUTE14
, LINE_GDF_ATTRIBUTE15
, LINE_GDF_ATTRIBUTE16
, LINE_GDF_ATTRIBUTE17
, LINE_GDF_ATTRIBUTE18
, LINE_GDF_ATTRIBUTE19
, LINE_GDF_ATTRIBUTE20
, RESET_TRX_DATE_FLAG
, PAYMENT_SERVER_ORDER_NUM
, APPROVAL_CODE
, ADDRESS_VERIFICATION_CODE
, WAREHOUSE_ID
, TRANSLATED_DESCRIPTION
, CONS_BILLING_NUMBER
, PROMISED_COMMITMENT_AMOUNT
, PAYMENT_SET_ID
, ORIGINAL_GL_DATE
, CONTRACT_LINE_ID
, CONTRACT_ID
, SOURCE_DATA_KEY1
, SOURCE_DATA_KEY2
, SOURCE_DATA_KEY3
, SOURCE_DATA_KEY4
, SOURCE_DATA_KEY5
, INVOICED_LINE_ACCTG_LEVEL
, OVERRIDE_AUTO_ACCOUNTING_FLAG
, SOURCE_APPLICATION_ID
, SOURCE_EVENT_CLASS_CODE
, SOURCE_ENTITY_CODE
, SOURCE_TRX_ID
, SOURCE_TRX_LINE_ID
, SOURCE_TRX_LINE_TYPE
, SOURCE_TRX_DETAIL_TAX_LINE_ID
, HISTORICAL_FLAG
, TAX_REGIME_CODE
, TAX
, TAX_STATUS_CODE
, TAX_RATE_CODE
, TAX_JURISDICTION_CODE
, TAXABLE_AMOUNT
, TAXABLE_FLAG
, LEGAL_ENTITY_ID
, PARENT_LINE_ID
, DEFERRAL_EXCLUSION_FLAG
, PAYMENT_TRXN_EXTENSION_ID
, RULE_END_DATE
, PAYMENT_ATTRIBUTES
, APPLICATION_ID
, BILLING_DATE
, TRX_BUSINESS_CATEGORY
, PRODUCT_FISC_CLASSIFICATION
, PRODUCT_CATEGORY
, PRODUCT_TYPE
, LINE_INTENDED_USE
, ASSESSABLE_VALUE
, DOCUMENT_SUB_TYPE
, DEFAULT_TAXATION_COUNTRY
, USER_DEFINED_FISC_CLASS
, TAXED_UPSTREAM_FLAG
, TAX_INVOICE_DATE
, TAX_INVOICE_NUMBER
, PAYMENT_TYPE_CODE
, MANDATE_LAST_TRX_FLAG
FROM AR.RA_INTERFACE_LINES_ALL;
AR.RA_INTERFACE_LINES_ALL does not reference any database object
AR.RA_INTERFACE_LINES_ALL is referenced by following:
AR
RA_INTERFACE_LINES_ALL#
|
|
|
|