[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JL_ZZ_AP_INV_DIS_WH_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | JL |
| FND Design Data: |  JL.JL_ZZ_AP_INV_DIS_WH_ALL
|
| Subobject Name: | |
| Status: | VALID |
JL_ZZ_AP_INV_DIS_WH_ALL contains information about the multiple withholding tax names per invoice distribution line. This information is initially defaulted from the Supplier Withholding Applicability by following a set of filtering rules such as invoice line type, ship-to location, primary tax codes, etc. These primary tax codes can still be modified by the user but restricted to the supplier's withholding tax setup. All tax codes associated to invoice distribution lines will be considered when calculating withholding taxes and when running legal reports.
.
This table corresponds to the Invoice Distribution Withholding window.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| JL_ZZ_AP_INV_DIS_WH_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 INV_DISTRIB_AWT_ID
|
| JL_ZZ_AP_INV_DIS_WH_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
INVOICE_DISTRIBUTION_ID
SUPP_AWT_CODE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INV_DISTRIB_AWT_ID | NUMBER | (15) | Yes | Invoice distribution withholding identifier |
| INVOICE_ID | NUMBER | (15) | Yes | Invoice identifier |
| DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | Yes | Distribution line identifier |
| SUPP_AWT_CODE_ID | NUMBER | (15) | Yes | Supplier withholding code identifier |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| ORG_ID | NUMBER | (15) | Organization identifier | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive Flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| INVOICE_DISTRIBUTION_ID | NUMBER | (15) | Invoice distribution ID |
Cut, paste (and edit) the following text to query this object:
SELECT INV_DISTRIB_AWT_ID
, INVOICE_ID
, DISTRIBUTION_LINE_NUMBER
, SUPP_AWT_CODE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, INVOICE_DISTRIBUTION_ID
FROM JL.JL_ZZ_AP_INV_DIS_WH_ALL;
JL.JL_ZZ_AP_INV_DIS_WH_ALL does not reference any database object
JL.JL_ZZ_AP_INV_DIS_WH_ALL is referenced by following:
APPS
JL_ZZ_AP_INV_DIS_WH
JL_ZZ_AP_INV_DIS_WH_ALL
|
|
|
|