DBA Data[Home] [Help] [Dependency Information]

TABLE: ZX.ZX_PTNR_NEG_LINE_GT

Object Details
Object Name: ZX_PTNR_NEG_LINE_GT
Object Type: TABLE
Owner: ZX
FND Design Data: TableZX.ZX_PTNR_NEG_LINE_GT
Subobject Name:
Status: VALID

Temporary Table Details

ZX.ZX_PTNR_NEG_LINE_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
INTERNAL_ORGANIZATION_ID NUMBER
Yes Internal organization identifier of the transaction
EVENT_CLASS_MAPPING_ID NUMBER

Event class mapping identifier
TRX_ID NUMBER
Yes Primary transaction identifier
ENTITY_CODE VARCHAR2 (30) Yes Entity code of the application event class for the transaction
EVENT_CLASS_CODE VARCHAR2 (30) Yes Application event class of the transaction
APPLICATION_ID NUMBER
Yes Application Identifier of the transaction
TRX_DATE DATE
Yes Transaction date
TRX_CURRENCY_CODE VARCHAR2 (15)
Transaction currency code
TRX_NUMBER VARCHAR2 (150)
Transaction number, typically the number that enables a user to identify a transaction
RECORD_TYPE_CODE VARCHAR2 (30) Yes Lookup code to indicate whether the record is migrated, seeded or defined by the user
TRX_LINE_ID NUMBER

Transaction line identifier
TRX_LEVEL_TYPE VARCHAR2 (30) Yes Column to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
LINE_LEVEL_ACTION VARCHAR2 (30)
Column to store action at the transaction line level
TRX_LINE_TYPE VARCHAR2 (30)
Column to store type of the transaction line. Possible values are ITEM, FREIGHT and MISC.
TRX_LINE_DATE DATE

Transaction line date
LINE_AMT NUMBER
Yes Transaction line amount
TRX_LINE_QUANTITY NUMBER

Transaction line quantity
UNIT_PRICE NUMBER

Unit Price of the transaction line item or product
PRODUCT_ID NUMBER

Column to store internal identifier of the inventory item or memo line used on this transaction line.
PRODUCT_ORG_ID NUMBER

Identifier of the organization for the inventory item
UOM_CODE VARCHAR2 (30)
Unit of measure code for the inventory item
PRODUCT_TYPE VARCHAR2 (240)
Product type code of the inventory item. Possible values are GOODS and SERVICES.
PRODUCT_CODE VARCHAR2 (300)
Inventory item code
FOB_POINT VARCHAR2 (30)
Free on Board point
SHIP_TO_GEOGRAPHY_TYPE1 VARCHAR2 (30)
Geography type of the first element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE1 VARCHAR2 (30)
Geography name of the first element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE2 VARCHAR2 (30)
Geography type of the second element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE2 VARCHAR2 (30)
Geography name of the second element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE3 VARCHAR2 (30)
Geography type of the third element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE3 VARCHAR2 (30)
Geography name of the third element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE4 VARCHAR2 (30)
Geography type of the fourth element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE4 VARCHAR2 (30)
Geography name of the fourth element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE5 VARCHAR2 (30)
Geography type of the fifth element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE5 VARCHAR2 (30)
Geography name of the fifth element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE6 VARCHAR2 (30)
Geography type of the sixth element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE6 VARCHAR2 (30)
Geography name of the sixth element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE7 VARCHAR2 (30)
Geography type of the seventh element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE7 VARCHAR2 (30)
Geography name of the seventh element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE8 VARCHAR2 (30)
Geography type of the eighth element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE8 VARCHAR2 (30)
Geography name of the eighth element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE9 VARCHAR2 (30)
Geography type of the nineth element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE9 VARCHAR2 (30)
Geography name of the nineth element of the Ship To location
SHIP_TO_GEOGRAPHY_TYPE10 VARCHAR2 (30)
Geography type of the tenth element of the Ship To location
SHIP_TO_GEOGRAPHY_VALUE10 VARCHAR2 (30)
Geography name of the tenth element of the Ship To location
SHIP_FROM_GEOGRAPHY_TYPE1 VARCHAR2 (30)
Geography type of the first element of the Ship From location
SHIP_FROM_GEOGRAPHY_VALUE1 VARCHAR2 (30)
Geography name of the first element of the Ship From location
SHIP_FROM_GEOGRAPHY_TYPE2 VARCHAR2 (30)
Geography type of the second element of the Ship From location
SHIP_FROM_GEOGRAPHY_VALUE2 VARCHAR2 (30)
Geography name of the second element of the Ship From location
SHIP_FROM_GEOGRAPHY_TYPE3 VARCHAR2 (30)
Geography type of the third element of the Ship From location
SHIP_FROM_GEOGRAPHY_VALUE3 VARCHAR2 (30)
Geography name of the third element of the Ship From location
SHIP_FROM_GEOGRAPHY_TYPE4 VARCHAR2 (30)
Geography type of the fourth element of the Ship From location
SHIP_FROM_GEOGRAPHY_VALUE4 VARCHAR2 (30)
Geography name of the fourth element of the Ship from location
SHIP_FROM_GEOGRAPHY_TYPE5 VARCHAR2 (30)
Geography type of the fifth element of the Ship from location
SHIP_FROM_GEOGRAPHY_VALUE5 VARCHAR2 (30)
Geography name of the fifth element of the Ship from location
SHIP_FROM_GEOGRAPHY_TYPE6 VARCHAR2 (30)
Geography type of the sixth element of the Ship from location
SHIP_FROM_GEOGRAPHY_VALUE6 VARCHAR2 (30)
Geography name of the sixth element of the Ship from location
SHIP_FROM_GEOGRAPHY_TYPE7 VARCHAR2 (30)
Geography type of the seventh element of the Ship from location
SHIP_FROM_GEOGRAPHY_VALUE7 VARCHAR2 (30)
Geography name of the seventh element of the Ship from location
SHIP_FROM_GEOGRAPHY_TYPE8 VARCHAR2 (30)
Geography type of the eighth element of the Ship from location
SHIP_FROM_GEOGRAPHY_VALUE8 VARCHAR2 (30)
Geography name of the eighth element of the Ship from location
SHIP_FROM_GEOGRAPHY_TYPE9 VARCHAR2 (30)
Geography type of the nineth element of the Ship from location
SHIP_FROM_GEOGRAPHY_VALUE9 VARCHAR2 (30)
Geography name of the nineth element of the Ship from location
SHIP_FROM_GEOGRAPHY_TYPE10 VARCHAR2 (30)
Geography type of the tenth element of the Ship from location
SHIP_FROM_GEOGRAPHY_VALUE10 VARCHAR2 (30)
Geography name of the tenth element of the Ship from location
BILL_TO_GEOGRAPHY_TYPE1 VARCHAR2 (30)
Geography type of the first element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE1 VARCHAR2 (30)
Geography name of the first element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE2 VARCHAR2 (30)
Geography type of the second element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE2 VARCHAR2 (30)
Geography name of the second element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE3 VARCHAR2 (30)
Geography type of the third element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE3 VARCHAR2 (30)
Geography name of the third element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE4 VARCHAR2 (30)
Geography type of the fourth element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE4 VARCHAR2 (30)
Geography name of the fourth element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE5 VARCHAR2 (30)
Geography type of the fifth element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE5 VARCHAR2 (30)
Geography name of the fifth element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE6 VARCHAR2 (30)
Geography type of the sixth element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE6 VARCHAR2 (30)
Geography name of the sixth element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE7 VARCHAR2 (30)
Geography type of the seventh element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE7 VARCHAR2 (30)
Geography name of the seventh element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE8 VARCHAR2 (30)
Geography type of the eighth element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE8 VARCHAR2 (30)
Geography name of the eighth element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE9 VARCHAR2 (30)
Geography type of the nineth element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE9 VARCHAR2 (30)
Geography name of the nineth element of the Bill To location
BILL_TO_GEOGRAPHY_TYPE10 VARCHAR2 (30)
Geography type of the tenth element of the Bill To location
BILL_TO_GEOGRAPHY_VALUE10 VARCHAR2 (30)
Geography name of the tenth element of the Bill To location
BILL_FROM_GEOGRAPHY_TYPE1 VARCHAR2 (30)
Geography type of the first element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE1 VARCHAR2 (30)
Geography name of the first element of the Bill From location
BILL_FROM_GEOGRAPHY_TYPE2 VARCHAR2 (30)
Geography type of the second element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE2 VARCHAR2 (30)
Geography name of the second element of the Bill From location
BILL_FROM_GEOGRAPHY_TYPE3 VARCHAR2 (30)
Geography type of the third element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE3 VARCHAR2 (30)
Geography name of the third element of the Bill From location
BILL_FROM_GEOGRAPHY_TYPE4 VARCHAR2 (30)
Geography type of the fourth element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE4 VARCHAR2 (30)
Geography name of the fourth element of the Bill from location
BILL_FROM_GEOGRAPHY_TYPE5 VARCHAR2 (30)
Geography type of the fifth element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE5 VARCHAR2 (30)
Geography name of the fifth element of the Bill From location
BILL_FROM_GEOGRAPHY_TYPE6 VARCHAR2 (30)
Geography type of the sixth element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE6 VARCHAR2 (30)
Geography name of the sixth element of the Bill From location
BILL_FROM_GEOGRAPHY_TYPE7 VARCHAR2 (30)
Geography type of the seventh element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE7 VARCHAR2 (30)
Geography name of the seventh element of the Bill From location
BILL_FROM_GEOGRAPHY_TYPE8 VARCHAR2 (30)
Geography type of the eighth element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE8 VARCHAR2 (30)
Geography name of the eighth element of the Bill From location
BILL_FROM_GEOGRAPHY_TYPE9 VARCHAR2 (30)
Geography type of the nineth element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE9 VARCHAR2 (30)
Geography name of the nineth element of the Bill From location
BILL_FROM_GEOGRAPHY_TYPE10 VARCHAR2 (30)
Geography type of the tenth element of the Bill From location
BILL_FROM_GEOGRAPHY_VALUE10 VARCHAR2 (30)
Geography name of the tenth element of the Bill From location
APPLIED_FROM_TRX_ID NUMBER

Applied from document transaction identifier
APPLIED_FROM_LINE_ID NUMBER

Transaction line identifier for the applied from document
APPLIED_FROM_TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the applied from document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
APPLIED_FROM_TRX_NUMBER VARCHAR2 (150)
Transaction number of the applied from document
ADJUSTED_DOC_TRX_ID NUMBER

Adjusted document transaction identifier
ADJUSTED_DOC_LINE_ID NUMBER

Transaction line identifier for the adjusted document
ADJUSTED_DOC_TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the adjusted document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
ADJUSTED_DOC_NUMBER VARCHAR2 (150)
Transaction number of the adjusted document
ADJUSTED_DOC_DATE DATE

Adjusted document date
HEADER_EXT_VARCHAR_ATTRIBUTE1 VARCHAR2 (150)
Header level user extensible attribute1 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE2 VARCHAR2 (150)
Header Level user extensible attribute2 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE3 VARCHAR2 (150)
Header Level user extensible attribute3 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE4 VARCHAR2 (150)
Header Level user extensible attribute4 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE5 VARCHAR2 (150)
Header Level user extensible attribute5 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE6 VARCHAR2 (150)
Header Level user extensible attribute6 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE7 VARCHAR2 (150)
Header Level user extensible attribute7 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE8 VARCHAR2 (150)
Header Level user extensible attribute8 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE9 VARCHAR2 (150)
Header Level user extensible attribute9 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE10 VARCHAR2 (150)
Header Level user extensible attribute10 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE11 VARCHAR2 (150)
Header Level user extensible attribute11 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE12 VARCHAR2 (150)
Header Level user extensible attribute12 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE13 VARCHAR2 (150)
Header Level user extensible attribute13 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE14 VARCHAR2 (150)
Header Level user extensible attribute14 of type character used by third party service provider
HEADER_EXT_VARCHAR_ATTRIBUTE15 VARCHAR2 (150)
Header Level user extensible attribute15 of type character used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE1 NUMBER

Header Level user extensible attribute1 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE2 NUMBER

Header Level user extensible attribute2 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE3 NUMBER

Header Level user extensible attribute3 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE4 NUMBER

Header Level user extensible attribute4 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE5 NUMBER

Header Level user extensible attribute5 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE6 NUMBER

Header Level user extensible attribute6 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE7 NUMBER

Header Level user extensible attribute7 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE8 NUMBER

Header Level user extensible attribute8 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE9 NUMBER

Header Level user extensible attribute9 of type number used by third party service provider
HEADER_EXT_NUMBER_ATTRIBUTE10 NUMBER

Header Level user extensible attribute10 of type number used by third party service provider
HEADER_EXT_DATE_ATTRIBUTE1 DATE

Header Level user extensible attribute1 of type date used by third party service provider
HEADER_EXT_DATE_ATTRIBUTE2 DATE

Header Level user extensible attribute2 of type date used by third party service provider
HEADER_EXT_DATE_ATTRIBUTE3 DATE

Header Level ueader Level user extensible attribute3 of type date used by third party service provider
HEADER_EXT_DATE_ATTRIBUTE4 DATE

Header Level user extensible attribute4 of type date used by third party service provider
HEADER_EXT_DATE_ATTRIBUTE5 DATE

Header Level user extensible attribute5 of type date used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE1 VARCHAR2 (150)
Line Level user extensible attribute1 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE2 VARCHAR2 (150)
Line Level user extensible attribute2 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE3 VARCHAR2 (150)
Line Level user extensible attribute3 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE4 VARCHAR2 (150)
Line Level user extensible attribute4 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE5 VARCHAR2 (150)
Line Level user extensible attribute5 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE6 VARCHAR2 (150)
Line Level user extensible attribute6 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE7 VARCHAR2 (150)
Line Level user extensible attribute7 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE8 VARCHAR2 (150)
Line Level user extensible attribute8 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE9 VARCHAR2 (150)
Line Level user extensible attribute9 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE10 VARCHAR2 (150)
Line Level user extensible attribute10 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE11 VARCHAR2 (150)
Line Level user extensible attribute11 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE12 VARCHAR2 (150)
Line Level user extensible attribute12 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE13 VARCHAR2 (150)
Line Level user extensible attribute13 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE14 VARCHAR2 (150)
Line Level user extensible attribute14 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE15 VARCHAR2 (150)
Line Level user extensible attribute15 of type character used by third party service provider
LINE_EXT_NUMBER_ATTRIBUTE1 NUMBER

Line Level user extensible attribute1 of type number used by third party service provider
LINE_EXT_NUMBER_ATTRIBUTE2 NUMBER

Line Level user extensible attribute2 of type number used by third party service provider
LINE_EXT_NUMBER_ATTRIBUTE3 NUMBER

Line Level user extensible attribute3 of type number used by third party service provider
LINE_EXT_NUMBER_ATTRIBUTE4 NUMBER

Line Level user extensible attribute4 of type number used by third party service provider
LINE_EXT_NUMBER_ATTRIBUTE5 NUMBER

Line Level user extensible attribute5 of type number used by third party service provider
LINE_EXT_NUMBER_ATTRIBUTE6 NUMBER

Line Level user extensible attribute6 of type number used by third party service provider
LINE_EXT_NUMBER_ATTRIBUTE7 NUMBER

Line Level user extensible attribute7 of type number used by third party service provider
LINE_EXT_NUMBER_ATTRIBUTE8 NUMBER

Line Level user extensible attribute8 of type number used by third party service provider
LINE_EXT_NUMBER_ATTRIBUTE9 NUMBER

Line Level user extensible attribute9 of type number used by third party service provider
LINE_EXT_NUMBER_ATTRIBUTE10 NUMBER

Line Level user extensible attribute10 of type number used by third party service provider
LINE_EXT_DATE_ATTRIBUTE1 DATE

Line Level user extensible attribute1 of type date used by third party service provider
LINE_EXT_DATE_ATTRIBUTE2 DATE

Line Level user extensible attribute2 of type date used by third party service provider
LINE_EXT_DATE_ATTRIBUTE3 DATE

Line Level user extensible attribute3 of type date used by third party service provider
LINE_EXT_DATE_ATTRIBUTE4 DATE

Line Level user extensible attribute4 of type date used by third party service provider
LINE_EXT_DATE_ATTRIBUTE5 DATE

Line Level user extensible attribute5 of type date used by third party service provider
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 (80)
Tax exemption certificate number
EXEMPT_REASON VARCHAR2 (240)
Tax exemption reason
EXEMPTION_CONTROL_FLAG VARCHAR2 (1)
Lookup code to control the application of exemptions to the transaction line during tax lines calculation. Possible values are R, S and E.
SHIP_FROM_PARTY_TAX_PROF_ID NUMBER

Party tax profile identifier for ship from party of the transaction line
SHIP_TO_SITE_TAX_PROF_ID NUMBER

Party tax profile identifier for ship to party site of the transaction line
SHIP_TO_PARTY_TAX_PROF_ID NUMBER

Party tax profile identifier for ship to party of the transaction line
SHIP_TO_LOCATION_ID NUMBER

Ship to location identifier
BILL_TO_CUST_ACCT_SITE_USE_ID NUMBER

Column to record bill to customer account site use identifier for Receivables
BILL_TO_SITE_TAX_PROF_ID NUMBER

Party tax profile identifier for bill to party site of the transaction line
BILL_TO_PARTY_TAX_PROF_ID NUMBER

Party tax profile identifier for bill to party of the transaction line
BILL_TO_LOCATION_ID NUMBER

Bill to location identifier
TRADING_HQ_SITE_TAX_PROF_ID NUMBER

Not currently used
TRADING_HQ_PARTY_TAX_PROF_ID NUMBER

Not currently used
BILL_THIRD_PTY_ACCT_ID NUMBER

Column to record bill to customer account identifier for Receivables or bill from supplier identifier for Payables
RECEIVABLES_TRX_TYPE_ID NUMBER

Transaction type identifier for Receivables transactions
ADJUSTED_DOC_APPLICATION_ID NUMBER

Adjusted document application identifier
ADJUSTED_DOC_ENTITY_CODE VARCHAR2 (30)
Adjusted document entity code
ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
Adjusted document event class code
TAX_PROVIDER_ID NUMBER

Identifier of the third party service provider that has determined the tax on this summary line. Null if there is no third party service provider integration for the tax.
TAX_REGIME_CODE VARCHAR2 (30)
Tax regime code
SHIP_TO_PARTY_NUMBER VARCHAR2 (30)
Number of the ship to party
SHIP_TO_PARTY_NAME VARCHAR2 (360)
Name of the ship to party
SHIP_FROM_PARTY_NUMBER VARCHAR2 (30)
Number of the ship from party
SHIP_FROM_PARTY_NAME VARCHAR2 (360)
Name of the ship from party
BILL_TO_PARTY_NUMBER VARCHAR2 (30)
Number of the bill to party
BILL_TO_PARTY_NAME VARCHAR2 (360)
Name of the bill to party
BILL_FROM_PARTY_NUMBER VARCHAR2 (30)
Number of the bill from party
BILL_FROM_PARTY_NAME VARCHAR2 (360)
Name of the bill from party
LINE_EXT_VARCHAR_ATTRIBUTE16 VARCHAR2 (150)
Line Level user extensible attribute16 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE17 VARCHAR2 (150)
Line Level user extensible attribute17 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE18 VARCHAR2 (150)
Line Level user extensible attribute18 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE19 VARCHAR2 (150)
Line Level user extensible attribute19 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE20 VARCHAR2 (150)
Line Level user extensible attribute20 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE21 VARCHAR2 (150)
Line Level user extensible attribute21 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE22 VARCHAR2 (150)
Line Level user extensible attribute22 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE23 VARCHAR2 (150)
Line Level user extensible attribute23 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE24 VARCHAR2 (150)
Line Level user extensible attribute24 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE25 VARCHAR2 (150)
Line Level user extensible attribute25 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE26 VARCHAR2 (150)
Line Level user extensible attribute26 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE27 VARCHAR2 (150)
Line Level user extensible attribute27 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE28 VARCHAR2 (150)
Line Level user extensible attribute28 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE29 VARCHAR2 (150)
Line Level user extensible attribute29 of type character used by third party service provider
LINE_EXT_VARCHAR_ATTRIBUTE30 VARCHAR2 (150)
Line Level user extensible attribute30 of type character used by third party service provider
SHIP_TO_CUST_ACCT_SITE_USE_ID NUMBER

Column to record ship to customer account site use identifier for Receivables.
SHIP_THIRD_PTY_ACCT_SITE_ID NUMBER

Column to record ship to customer account site identifier for Receivables or ship from supplier site identifier for Payables
BILL_THIRD_PTY_ACCT_SITE_ID NUMBER

Column to record bill to customer account site identifier for Receivables or bill from supplier site identifier for Payables
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INTERNAL_ORGANIZATION_ID
,      EVENT_CLASS_MAPPING_ID
,      TRX_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      APPLICATION_ID
,      TRX_DATE
,      TRX_CURRENCY_CODE
,      TRX_NUMBER
,      RECORD_TYPE_CODE
,      TRX_LINE_ID
,      TRX_LEVEL_TYPE
,      LINE_LEVEL_ACTION
,      TRX_LINE_TYPE
,      TRX_LINE_DATE
,      LINE_AMT
,      TRX_LINE_QUANTITY
,      UNIT_PRICE
,      PRODUCT_ID
,      PRODUCT_ORG_ID
,      UOM_CODE
,      PRODUCT_TYPE
,      PRODUCT_CODE
,      FOB_POINT
,      SHIP_TO_GEOGRAPHY_TYPE1
,      SHIP_TO_GEOGRAPHY_VALUE1
,      SHIP_TO_GEOGRAPHY_TYPE2
,      SHIP_TO_GEOGRAPHY_VALUE2
,      SHIP_TO_GEOGRAPHY_TYPE3
,      SHIP_TO_GEOGRAPHY_VALUE3
,      SHIP_TO_GEOGRAPHY_TYPE4
,      SHIP_TO_GEOGRAPHY_VALUE4
,      SHIP_TO_GEOGRAPHY_TYPE5
,      SHIP_TO_GEOGRAPHY_VALUE5
,      SHIP_TO_GEOGRAPHY_TYPE6
,      SHIP_TO_GEOGRAPHY_VALUE6
,      SHIP_TO_GEOGRAPHY_TYPE7
,      SHIP_TO_GEOGRAPHY_VALUE7
,      SHIP_TO_GEOGRAPHY_TYPE8
,      SHIP_TO_GEOGRAPHY_VALUE8
,      SHIP_TO_GEOGRAPHY_TYPE9
,      SHIP_TO_GEOGRAPHY_VALUE9
,      SHIP_TO_GEOGRAPHY_TYPE10
,      SHIP_TO_GEOGRAPHY_VALUE10
,      SHIP_FROM_GEOGRAPHY_TYPE1
,      SHIP_FROM_GEOGRAPHY_VALUE1
,      SHIP_FROM_GEOGRAPHY_TYPE2
,      SHIP_FROM_GEOGRAPHY_VALUE2
,      SHIP_FROM_GEOGRAPHY_TYPE3
,      SHIP_FROM_GEOGRAPHY_VALUE3
,      SHIP_FROM_GEOGRAPHY_TYPE4
,      SHIP_FROM_GEOGRAPHY_VALUE4
,      SHIP_FROM_GEOGRAPHY_TYPE5
,      SHIP_FROM_GEOGRAPHY_VALUE5
,      SHIP_FROM_GEOGRAPHY_TYPE6
,      SHIP_FROM_GEOGRAPHY_VALUE6
,      SHIP_FROM_GEOGRAPHY_TYPE7
,      SHIP_FROM_GEOGRAPHY_VALUE7
,      SHIP_FROM_GEOGRAPHY_TYPE8
,      SHIP_FROM_GEOGRAPHY_VALUE8
,      SHIP_FROM_GEOGRAPHY_TYPE9
,      SHIP_FROM_GEOGRAPHY_VALUE9
,      SHIP_FROM_GEOGRAPHY_TYPE10
,      SHIP_FROM_GEOGRAPHY_VALUE10
,      BILL_TO_GEOGRAPHY_TYPE1
,      BILL_TO_GEOGRAPHY_VALUE1
,      BILL_TO_GEOGRAPHY_TYPE2
,      BILL_TO_GEOGRAPHY_VALUE2
,      BILL_TO_GEOGRAPHY_TYPE3
,      BILL_TO_GEOGRAPHY_VALUE3
,      BILL_TO_GEOGRAPHY_TYPE4
,      BILL_TO_GEOGRAPHY_VALUE4
,      BILL_TO_GEOGRAPHY_TYPE5
,      BILL_TO_GEOGRAPHY_VALUE5
,      BILL_TO_GEOGRAPHY_TYPE6
,      BILL_TO_GEOGRAPHY_VALUE6
,      BILL_TO_GEOGRAPHY_TYPE7
,      BILL_TO_GEOGRAPHY_VALUE7
,      BILL_TO_GEOGRAPHY_TYPE8
,      BILL_TO_GEOGRAPHY_VALUE8
,      BILL_TO_GEOGRAPHY_TYPE9
,      BILL_TO_GEOGRAPHY_VALUE9
,      BILL_TO_GEOGRAPHY_TYPE10
,      BILL_TO_GEOGRAPHY_VALUE10
,      BILL_FROM_GEOGRAPHY_TYPE1
,      BILL_FROM_GEOGRAPHY_VALUE1
,      BILL_FROM_GEOGRAPHY_TYPE2
,      BILL_FROM_GEOGRAPHY_VALUE2
,      BILL_FROM_GEOGRAPHY_TYPE3
,      BILL_FROM_GEOGRAPHY_VALUE3
,      BILL_FROM_GEOGRAPHY_TYPE4
,      BILL_FROM_GEOGRAPHY_VALUE4
,      BILL_FROM_GEOGRAPHY_TYPE5
,      BILL_FROM_GEOGRAPHY_VALUE5
,      BILL_FROM_GEOGRAPHY_TYPE6
,      BILL_FROM_GEOGRAPHY_VALUE6
,      BILL_FROM_GEOGRAPHY_TYPE7
,      BILL_FROM_GEOGRAPHY_VALUE7
,      BILL_FROM_GEOGRAPHY_TYPE8
,      BILL_FROM_GEOGRAPHY_VALUE8
,      BILL_FROM_GEOGRAPHY_TYPE9
,      BILL_FROM_GEOGRAPHY_VALUE9
,      BILL_FROM_GEOGRAPHY_TYPE10
,      BILL_FROM_GEOGRAPHY_VALUE10
,      APPLIED_FROM_TRX_ID
,      APPLIED_FROM_LINE_ID
,      APPLIED_FROM_TRX_LEVEL_TYPE
,      APPLIED_FROM_TRX_NUMBER
,      ADJUSTED_DOC_TRX_ID
,      ADJUSTED_DOC_LINE_ID
,      ADJUSTED_DOC_TRX_LEVEL_TYPE
,      ADJUSTED_DOC_NUMBER
,      ADJUSTED_DOC_DATE
,      HEADER_EXT_VARCHAR_ATTRIBUTE1
,      HEADER_EXT_VARCHAR_ATTRIBUTE2
,      HEADER_EXT_VARCHAR_ATTRIBUTE3
,      HEADER_EXT_VARCHAR_ATTRIBUTE4
,      HEADER_EXT_VARCHAR_ATTRIBUTE5
,      HEADER_EXT_VARCHAR_ATTRIBUTE6
,      HEADER_EXT_VARCHAR_ATTRIBUTE7
,      HEADER_EXT_VARCHAR_ATTRIBUTE8
,      HEADER_EXT_VARCHAR_ATTRIBUTE9
,      HEADER_EXT_VARCHAR_ATTRIBUTE10
,      HEADER_EXT_VARCHAR_ATTRIBUTE11
,      HEADER_EXT_VARCHAR_ATTRIBUTE12
,      HEADER_EXT_VARCHAR_ATTRIBUTE13
,      HEADER_EXT_VARCHAR_ATTRIBUTE14
,      HEADER_EXT_VARCHAR_ATTRIBUTE15
,      HEADER_EXT_NUMBER_ATTRIBUTE1
,      HEADER_EXT_NUMBER_ATTRIBUTE2
,      HEADER_EXT_NUMBER_ATTRIBUTE3
,      HEADER_EXT_NUMBER_ATTRIBUTE4
,      HEADER_EXT_NUMBER_ATTRIBUTE5
,      HEADER_EXT_NUMBER_ATTRIBUTE6
,      HEADER_EXT_NUMBER_ATTRIBUTE7
,      HEADER_EXT_NUMBER_ATTRIBUTE8
,      HEADER_EXT_NUMBER_ATTRIBUTE9
,      HEADER_EXT_NUMBER_ATTRIBUTE10
,      HEADER_EXT_DATE_ATTRIBUTE1
,      HEADER_EXT_DATE_ATTRIBUTE2
,      HEADER_EXT_DATE_ATTRIBUTE3
,      HEADER_EXT_DATE_ATTRIBUTE4
,      HEADER_EXT_DATE_ATTRIBUTE5
,      LINE_EXT_VARCHAR_ATTRIBUTE1
,      LINE_EXT_VARCHAR_ATTRIBUTE2
,      LINE_EXT_VARCHAR_ATTRIBUTE3
,      LINE_EXT_VARCHAR_ATTRIBUTE4
,      LINE_EXT_VARCHAR_ATTRIBUTE5
,      LINE_EXT_VARCHAR_ATTRIBUTE6
,      LINE_EXT_VARCHAR_ATTRIBUTE7
,      LINE_EXT_VARCHAR_ATTRIBUTE8
,      LINE_EXT_VARCHAR_ATTRIBUTE9
,      LINE_EXT_VARCHAR_ATTRIBUTE10
,      LINE_EXT_VARCHAR_ATTRIBUTE11
,      LINE_EXT_VARCHAR_ATTRIBUTE12
,      LINE_EXT_VARCHAR_ATTRIBUTE13
,      LINE_EXT_VARCHAR_ATTRIBUTE14
,      LINE_EXT_VARCHAR_ATTRIBUTE15
,      LINE_EXT_NUMBER_ATTRIBUTE1
,      LINE_EXT_NUMBER_ATTRIBUTE2
,      LINE_EXT_NUMBER_ATTRIBUTE3
,      LINE_EXT_NUMBER_ATTRIBUTE4
,      LINE_EXT_NUMBER_ATTRIBUTE5
,      LINE_EXT_NUMBER_ATTRIBUTE6
,      LINE_EXT_NUMBER_ATTRIBUTE7
,      LINE_EXT_NUMBER_ATTRIBUTE8
,      LINE_EXT_NUMBER_ATTRIBUTE9
,      LINE_EXT_NUMBER_ATTRIBUTE10
,      LINE_EXT_DATE_ATTRIBUTE1
,      LINE_EXT_DATE_ATTRIBUTE2
,      LINE_EXT_DATE_ATTRIBUTE3
,      LINE_EXT_DATE_ATTRIBUTE4
,      LINE_EXT_DATE_ATTRIBUTE5
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON
,      EXEMPTION_CONTROL_FLAG
,      SHIP_FROM_PARTY_TAX_PROF_ID
,      SHIP_TO_SITE_TAX_PROF_ID
,      SHIP_TO_PARTY_TAX_PROF_ID
,      SHIP_TO_LOCATION_ID
,      BILL_TO_CUST_ACCT_SITE_USE_ID
,      BILL_TO_SITE_TAX_PROF_ID
,      BILL_TO_PARTY_TAX_PROF_ID
,      BILL_TO_LOCATION_ID
,      TRADING_HQ_SITE_TAX_PROF_ID
,      TRADING_HQ_PARTY_TAX_PROF_ID
,      BILL_THIRD_PTY_ACCT_ID
,      RECEIVABLES_TRX_TYPE_ID
,      ADJUSTED_DOC_APPLICATION_ID
,      ADJUSTED_DOC_ENTITY_CODE
,      ADJUSTED_DOC_EVENT_CLASS_CODE
,      TAX_PROVIDER_ID
,      TAX_REGIME_CODE
,      SHIP_TO_PARTY_NUMBER
,      SHIP_TO_PARTY_NAME
,      SHIP_FROM_PARTY_NUMBER
,      SHIP_FROM_PARTY_NAME
,      BILL_TO_PARTY_NUMBER
,      BILL_TO_PARTY_NAME
,      BILL_FROM_PARTY_NUMBER
,      BILL_FROM_PARTY_NAME
,      LINE_EXT_VARCHAR_ATTRIBUTE16
,      LINE_EXT_VARCHAR_ATTRIBUTE17
,      LINE_EXT_VARCHAR_ATTRIBUTE18
,      LINE_EXT_VARCHAR_ATTRIBUTE19
,      LINE_EXT_VARCHAR_ATTRIBUTE20
,      LINE_EXT_VARCHAR_ATTRIBUTE21
,      LINE_EXT_VARCHAR_ATTRIBUTE22
,      LINE_EXT_VARCHAR_ATTRIBUTE23
,      LINE_EXT_VARCHAR_ATTRIBUTE24
,      LINE_EXT_VARCHAR_ATTRIBUTE25
,      LINE_EXT_VARCHAR_ATTRIBUTE26
,      LINE_EXT_VARCHAR_ATTRIBUTE27
,      LINE_EXT_VARCHAR_ATTRIBUTE28
,      LINE_EXT_VARCHAR_ATTRIBUTE29
,      LINE_EXT_VARCHAR_ATTRIBUTE30
,      SHIP_TO_CUST_ACCT_SITE_USE_ID
,      SHIP_THIRD_PTY_ACCT_SITE_ID
,      BILL_THIRD_PTY_ACCT_SITE_ID
FROM ZX.ZX_PTNR_NEG_LINE_GT;

Dependencies

[top of page]

ZX.ZX_PTNR_NEG_LINE_GT does not reference any database object

ZX.ZX_PTNR_NEG_LINE_GT is referenced by following:

SchemaAPPS
SynonymZX_PTNR_NEG_LINE_GT