[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JAI_INTERFACE_LINES_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | JA |
| FND Design Data: |  JA.JAI_INTERFACE_LINES_ALL
|
| Subobject Name: | |
| Status: | VALID |
This is an interface table to store the transaction data which are populated by customers program.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| JAI_INTERFACE_LINES_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 INTERFACE_LINE_ID
|
| JAI_INTERFACE_LINES_ALL_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARTY_ID
PARTY_SITE_ID
IMPORT_MODULE
TRANSACTION_NUM
TRANSACTION_LINE_NUM
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INTERFACE_LINE_ID | NUMBER | Interface Line ID | ||
| ORG_ID | NUMBER | Yes | Operating Unit ID | |
| ORGANIZATION_ID | NUMBER | Yes | Organization ID | |
| LOCATION_ID | NUMBER | Yes | Location ID | |
| PARTY_ID | NUMBER | Yes | Party id | |
| PARTY_SITE_ID | NUMBER | Yes | Party site id | |
| IMPORT_MODULE | VARCHAR2 | (10) | Yes | AR or AP |
| TRANSACTION_ID | NUMBER | For future use | ||
| TRANSACTION_NUM | VARCHAR2 | (240) | Yes | External Transaction Number |
| TRANSACTION_LINE_NUM | NUMBER | Yes | External Transaction Line Number. | |
| INTERNAL_TRX_ID | NUMBER | EBS Transaction ID | ||
| INTERNAL_TRX_LINE_ID | NUMBER | EBS Transaction Line ID | ||
| ERROR_FLAG | VARCHAR2 | (1) | Error Flag, Y or N | |
| BATCH_SOURCE_NAME | VARCHAR2 | (240) | Batch Source Name | |
| TAXABLE_BASIS | VARCHAR2 | (20) | LINE_AMOUNT or ASSESSABLE_VALUE | |
| TAXABLE_EVENT | VARCHAR2 | (20) | STANDARD or EXTERNAL | |
| INCLUSIVE_TAX_AMOUNT | NUMBER | Sum Inclusive tax amount for tax liens | ||
| EXCLUSIVE_TAX_AMOUNT | NUMBER | Sum Exclusive tax amount for tax liens | ||
| EXCISE_INVOICE_NO | VARCHAR2 | (150) | Excise Invoice No | |
| VAT_INVOICE_NO | VARCHAR2 | (150) | Vat Invoice No | |
| ST_INV_NUMBER | VARCHAR2 | (240) | Service Tax Invoice Number | |
| REFERENCE | VARCHAR2 | (240) | Reference | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Other Attribute1 | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Other Attribute2 | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Other Attribute3 | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Other Attribute4 | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Other Attribute5 | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Other Attribute6 | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Other Attribute7 | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Other Attribute8 | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Other Attribute9 | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Other Attribute10 | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Other Attribute11 | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Other Attribute12 | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Other Attribute13 | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Other Attribute14 | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Other Attribute15 | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Attribute category | |
| CREATION_DATE | DATE | Yes | Creation date | |
| CREATED_BY | NUMBER | Yes | Created By | |
| LAST_UPDATE_DATE | DATE | Yes | Last update date | |
| LAST_UPDATE_LOGIN | NUMBER | Yes | Last update login | |
| LAST_UPDATED_BY | NUMBER | Yes | Last updated by | |
| IMPORT_STATUS | VARCHAR2 | (30) | SUCCESS or FAILURE | |
| IMPORT_PROCESS | VARCHAR2 | (30) | VALIDATION, POPULATION, CALCULATION, ACCOUNTING | |
| REQUEST_ID | NUMBER | Concurrent request id | ||
| TAX_CATEGORY_ID | NUMBER | Tax category id | ||
| SERVICE_TYPE_CODE | VARCHAR2 | (30) | Service type code |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_LINE_ID
, ORG_ID
, ORGANIZATION_ID
, LOCATION_ID
, PARTY_ID
, PARTY_SITE_ID
, IMPORT_MODULE
, TRANSACTION_ID
, TRANSACTION_NUM
, TRANSACTION_LINE_NUM
, INTERNAL_TRX_ID
, INTERNAL_TRX_LINE_ID
, ERROR_FLAG
, BATCH_SOURCE_NAME
, TAXABLE_BASIS
, TAXABLE_EVENT
, INCLUSIVE_TAX_AMOUNT
, EXCLUSIVE_TAX_AMOUNT
, EXCISE_INVOICE_NO
, VAT_INVOICE_NO
, ST_INV_NUMBER
, REFERENCE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, IMPORT_STATUS
, IMPORT_PROCESS
, REQUEST_ID
, TAX_CATEGORY_ID
, SERVICE_TYPE_CODE
FROM JA.JAI_INTERFACE_LINES_ALL;
JA.JAI_INTERFACE_LINES_ALL does not reference any database object
JA.JAI_INTERFACE_LINES_ALL is referenced by following:
JA
JAI_INTERFACE_LINES_ALL#
|
|
|
|