[Home] [Help] [Dependency Information]
Object Name: | JAI_PA_DRAFT_INVOICE_LINES |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_PA_DRAFT_INVOICE_LINES |
Subobject Name: | |
Status: | VALID |
This table stores draft invoice line attributes related to india localization
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JAI_PA_DRAFT_INVOICE_LINES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | DRAFT_INVOICE_LINE_ID |
JAI_PA_DRAFT_INVOICE_LINES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PROJECT_ID
DRAFT_INVOICE_NUM LINE_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DRAFT_INVOICE_LINE_ID | NUMBER | (15) | Yes | Sequence generated primary key |
DRAFT_INVOICE_ID | NUMBER | (15) | Yes | Draft invoice identifier |
PROJECT_ID | NUMBER | (15) | Yes | Project identifier |
DRAFT_INVOICE_NUM | NUMBER | (15) | Draft invoice number | |
LINE_NUM | NUMBER | (15) | Line number | |
LINE_TAX_AMT | NUMBER | Line tax amount | ||
TAX_CATEGORY_ID | NUMBER | (15) | Tax category identifier | |
SERVICE_TYPE_CODE | VARCHAR2 | (30) | Service type code for lines which has service type of taxes | |
LINE_AMT | NUMBER | Draft invoice line amount | ||
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard who column |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
ORGANIZATION_ID | NUMBER | (15) | Invetory organization identifier | |
LOCATION_ID | NUMBER | (15) | Location identifier | |
PARENT_DRAFT_INVOICE_ID | NUMBER | (15) | Parent draft Invoice identifier for credit transactions | |
PARENT_DRAFT_INVOICE_LINE_ID | NUMBER | (15) | Parent draft Invoice line identifier for credit transaction |
Cut, paste (and edit) the following text to query this object:
SELECT DRAFT_INVOICE_LINE_ID
, DRAFT_INVOICE_ID
, PROJECT_ID
, DRAFT_INVOICE_NUM
, LINE_NUM
, LINE_TAX_AMT
, TAX_CATEGORY_ID
, SERVICE_TYPE_CODE
, LINE_AMT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ORGANIZATION_ID
, LOCATION_ID
, PARENT_DRAFT_INVOICE_ID
, PARENT_DRAFT_INVOICE_LINE_ID
FROM JA.JAI_PA_DRAFT_INVOICE_LINES;
JA.JAI_PA_DRAFT_INVOICE_LINES does not reference any database object
JA.JAI_PA_DRAFT_INVOICE_LINES is referenced by following:
|
|
|