ZX_PTNR_NEG_LINE

Details

Schema: FUSION
Object owner: ZX
Object type: TABLE

Columns

Name
INTERNAL_ORGANIZATION_IDNUMBERYesInternal organization identifier of the transaction EVENT_CLASS_MAPPING_IDNUMBEREvent class mapping identifier TRX_IDNUMBERYesPrimary transaction identifier ENTITY_CODEVARCHAR230YesEntity code of the application event class for the transaction EVENT_CLASS_CODEVARCHAR230YesApplication event class of the transaction APPLICATION_IDNUMBERYesApplication Identifier of the transaction TRX_DATEDATEYesTransaction date TRX_CURRENCY_CODEVARCHAR215Transaction currency code TRX_NUMBERVARCHAR2150Transaction number, typically the number that enables a user to identify a transaction RECORD_TYPE_CODEVARCHAR230YesLookup code to indicate whether the record is migrated, seeded or defined by the user TRX_LINE_IDNUMBERTransaction line identifier TRX_LEVEL_TYPEVARCHAR230YesColumn to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. LINE_LEVEL_ACTIONVARCHAR230Column to store action at the transaction line level TRX_LINE_TYPEVARCHAR230Column to store type of the transaction line. Possible values are ITEM, FREIGHT and MISC. TRX_LINE_DATEDATETransaction line date LINE_AMTNUMBERYesTransaction line amount TRX_LINE_QUANTITYNUMBERTransaction line quantity UNIT_PRICENUMBERUnit Price of the transaction line item or product PRODUCT_IDNUMBERColumn to store internal identifier of the inventory item or memo line used on this transaction line. PRODUCT_ORG_IDNUMBERIdentifier of the organization for the inventory item UOM_CODEVARCHAR230Unit of measure code for the inventory item PRODUCT_TYPEVARCHAR2240Product type code of the inventory item. Possible values are GOODS and SERVICES. PRODUCT_CODEVARCHAR2300Inventory item code FOB_POINTVARCHAR230Free on Board point SHIP_TO_GEOGRAPHY_TYPE1VARCHAR230Geography type of the first element of the Ship To location SHIP_TO_GEOGRAPHY_VALUE1VARCHAR230Geography name of the first element of the Ship To location SHIP_TO_GEOGRAPHY_TYPE2VARCHAR230Geography type of the second element of the Ship To location SHIP_TO_GEOGRAPHY_VALUE2VARCHAR230Geography name of the second element of the Ship To location SHIP_TO_GEOGRAPHY_TYPE3VARCHAR230Geography type of the third element of the Ship To location SHIP_TO_GEOGRAPHY_VALUE3VARCHAR230Geography name of the third element of the Ship To location SHIP_TO_GEOGRAPHY_TYPE4VARCHAR230Geography type of the fourth element of the Ship To location SHIP_TO_GEOGRAPHY_VALUE4VARCHAR230Geography name of the fourth element of the Ship To location SHIP_TO_GEOGRAPHY_TYPE5VARCHAR230Geography type of the fifth element of the Ship To location SHIP_TO_GEOGRAPHY_VALUE5VARCHAR230Geography name of the fifth element of the Ship To location SHIP_TO_GEOGRAPHY_TYPE6VARCHAR230Geography type of the sixth element of the Ship To location SHIP_TO_GEOGRAPHY_VALUE6VARCHAR230Geography name of the sixth element of the Ship To location SHIP_TO_GEOGRAPHY_TYPE7VARCHAR230Geography type of the seventh element of the Ship To location SHIP_TO_GEOGRAPHY_VALUE7VARCHAR230Geography name of the seventh element of the Ship To location SHIP_TO_GEOGRAPHY_TYPE8VARCHAR230Geography type of the eighth element of the Ship To location SHIP_TO_GEOGRAPHY_VALUE8VARCHAR230Geography name of the eighth element of the Ship To location SHIP_TO_GEOGRAPHY_TYPE9VARCHAR230Geography type of the nineth element of the Ship To location SHIP_TO_GEOGRAPHY_VALUE9VARCHAR230Geography name of the nineth element of the Ship To location SHIP_TO_GEOGRAPHY_TYPE10VARCHAR230Geography type of the tenth element of the Ship To location SHIP_TO_GEOGRAPHY_VALUE10VARCHAR230Geography name of the tenth element of the Ship To location SHIP_FROM_GEOGRAPHY_TYPE1VARCHAR230Geography type of the first element of the Ship From location SHIP_FROM_GEOGRAPHY_VALUE1VARCHAR230Geography name of the first element of the Ship From location SHIP_FROM_GEOGRAPHY_TYPE2VARCHAR230Geography type of the second element of the Ship From location SHIP_FROM_GEOGRAPHY_VALUE2VARCHAR230Geography name of the second element of the Ship From location SHIP_FROM_GEOGRAPHY_TYPE3VARCHAR230Geography type of the third element of the Ship From location SHIP_FROM_GEOGRAPHY_VALUE3VARCHAR230Geography name of the third element of the Ship From location SHIP_FROM_GEOGRAPHY_TYPE4VARCHAR230Geography type of the fourth element of the Ship From location SHIP_FROM_GEOGRAPHY_VALUE4VARCHAR230Geography name of the fourth element of the Ship from location SHIP_FROM_GEOGRAPHY_TYPE5VARCHAR230Geography type of the fifth element of the Ship from location SHIP_FROM_GEOGRAPHY_VALUE5VARCHAR230Geography name of the fifth element of the Ship from location SHIP_FROM_GEOGRAPHY_TYPE6VARCHAR230Geography type of the sixth element of the Ship from location SHIP_FROM_GEOGRAPHY_VALUE6VARCHAR230Geography name of the sixth element of the Ship from location SHIP_FROM_GEOGRAPHY_TYPE7VARCHAR230Geography type of the seventh element of the Ship from location SHIP_FROM_GEOGRAPHY_VALUE7VARCHAR230Geography name of the seventh element of the Ship from location SHIP_FROM_GEOGRAPHY_TYPE8VARCHAR230Geography type of the eighth element of the Ship from location SHIP_FROM_GEOGRAPHY_VALUE8VARCHAR230Geography name of the eighth element of the Ship from location SHIP_FROM_GEOGRAPHY_TYPE9VARCHAR230Geography type of the nineth element of the Ship from location SHIP_FROM_GEOGRAPHY_VALUE9VARCHAR230Geography name of the nineth element of the Ship from location SHIP_FROM_GEOGRAPHY_TYPE10VARCHAR230Geography type of the tenth element of the Ship from location SHIP_FROM_GEOGRAPHY_VALUE10VARCHAR230Geography name of the tenth element of the Ship from location BILL_TO_GEOGRAPHY_TYPE1VARCHAR230Geography type of the first element of the Bill To location BILL_TO_GEOGRAPHY_VALUE1VARCHAR230Geography name of the first element of the Bill To location BILL_TO_GEOGRAPHY_TYPE2VARCHAR230Geography type of the second element of the Bill To location BILL_TO_GEOGRAPHY_VALUE2VARCHAR230Geography name of the second element of the Bill To location BILL_TO_GEOGRAPHY_TYPE3VARCHAR230Geography type of the third element of the Bill To location BILL_TO_GEOGRAPHY_VALUE3VARCHAR230Geography name of the third element of the Bill To location BILL_TO_GEOGRAPHY_TYPE4VARCHAR230Geography type of the fourth element of the Bill To location BILL_TO_GEOGRAPHY_VALUE4VARCHAR230Geography name of the fourth element of the Bill To location BILL_TO_GEOGRAPHY_TYPE5VARCHAR230Geography type of the fifth element of the Bill To location BILL_TO_GEOGRAPHY_VALUE5VARCHAR230Geography name of the fifth element of the Bill To location BILL_TO_GEOGRAPHY_TYPE6VARCHAR230Geography type of the sixth element of the Bill To location BILL_TO_GEOGRAPHY_VALUE6VARCHAR230Geography name of the sixth element of the Bill To location BILL_TO_GEOGRAPHY_TYPE7VARCHAR230Geography type of the seventh element of the Bill To location BILL_TO_GEOGRAPHY_VALUE7VARCHAR230Geography name of the seventh element of the Bill To location BILL_TO_GEOGRAPHY_TYPE8VARCHAR230Geography type of the eighth element of the Bill To location BILL_TO_GEOGRAPHY_VALUE8VARCHAR230Geography name of the eighth element of the Bill To location BILL_TO_GEOGRAPHY_TYPE9VARCHAR230Geography type of the nineth element of the Bill To location BILL_TO_GEOGRAPHY_VALUE9VARCHAR230Geography name of the nineth element of the Bill To location BILL_TO_GEOGRAPHY_TYPE10VARCHAR230Geography type of the tenth element of the Bill To location BILL_TO_GEOGRAPHY_VALUE10VARCHAR230Geography name of the tenth element of the Bill To location BILL_FROM_GEOGRAPHY_TYPE1VARCHAR230Geography type of the first element of the Bill From location BILL_FROM_GEOGRAPHY_VALUE1VARCHAR230Geography name of the first element of the Bill From location BILL_FROM_GEOGRAPHY_TYPE2VARCHAR230Geography type of the second element of the Bill From location BILL_FROM_GEOGRAPHY_VALUE2VARCHAR230Geography name of the second element of the Bill From location BILL_FROM_GEOGRAPHY_TYPE3VARCHAR230Geography type of the third element of the Bill From location BILL_FROM_GEOGRAPHY_VALUE3VARCHAR230Geography name of the third element of the Bill From location BILL_FROM_GEOGRAPHY_TYPE4VARCHAR230Geography type of the fourth element of the Bill From location BILL_FROM_GEOGRAPHY_VALUE4VARCHAR230Geography name of the fourth element of the Bill from location BILL_FROM_GEOGRAPHY_TYPE5VARCHAR230Geography type of the fifth element of the Bill From location BILL_FROM_GEOGRAPHY_VALUE5VARCHAR230Geography name of the fifth element of the Bill From location BILL_FROM_GEOGRAPHY_TYPE6VARCHAR230Geography type of the sixth element of the Bill From location BILL_FROM_GEOGRAPHY_VALUE6VARCHAR230Geography name of the sixth element of the Bill From location BILL_FROM_GEOGRAPHY_TYPE7VARCHAR230Geography type of the seventh element of the Bill From location BILL_FROM_GEOGRAPHY_VALUE7VARCHAR230Geography name of the seventh element of the Bill From location BILL_FROM_GEOGRAPHY_TYPE8VARCHAR230Geography type of the eighth element of the Bill From location BILL_FROM_GEOGRAPHY_VALUE8VARCHAR230Geography name of the eighth element of the Bill From location BILL_FROM_GEOGRAPHY_TYPE9VARCHAR230Geography type of the nineth element of the Bill From location BILL_FROM_GEOGRAPHY_VALUE9VARCHAR230Geography name of the nineth element of the Bill From location BILL_FROM_GEOGRAPHY_TYPE10VARCHAR230Geography type of the tenth element of the Bill From location BILL_FROM_GEOGRAPHY_VALUE10VARCHAR230Geography name of the tenth element of the Bill From location APPLIED_FROM_TRX_IDNUMBERApplied from document transaction identifier APPLIED_FROM_LINE_IDNUMBERTransaction line identifier for the applied from document APPLIED_FROM_TRX_LEVEL_TYPEVARCHAR230Column to record the level at which the applied from document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. APPLIED_FROM_TRX_NUMBERVARCHAR2150Transaction number of the applied from document ADJUSTED_DOC_TRX_IDNUMBERAdjusted document transaction identifier ADJUSTED_DOC_LINE_IDNUMBERTransaction line identifier for the adjusted document ADJUSTED_DOC_TRX_LEVEL_TYPEVARCHAR230Column to record the level at which the adjusted document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. ADJUSTED_DOC_NUMBERVARCHAR2150Transaction number of the adjusted document ADJUSTED_DOC_DATEDATEAdjusted document date HEADER_EXT_VARCHAR_ATTRIBUTE1VARCHAR2150Header level user extensible attribute1 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE2VARCHAR2150Header Level user extensible attribute2 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE3VARCHAR2150Header Level user extensible attribute3 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE4VARCHAR2150Header Level user extensible attribute4 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE5VARCHAR2150Header Level user extensible attribute5 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE6VARCHAR2150Header Level user extensible attribute6 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE7VARCHAR2150Header Level user extensible attribute7 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE8VARCHAR2150Header Level user extensible attribute8 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE9VARCHAR2150Header Level user extensible attribute9 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE10VARCHAR2150Header Level user extensible attribute10 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE11VARCHAR2150Header Level user extensible attribute11 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE12VARCHAR2150Header Level user extensible attribute12 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE13VARCHAR2150Header Level user extensible attribute13 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE14VARCHAR2150Header Level user extensible attribute14 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE15VARCHAR2150Header Level user extensible attribute15 of type character used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE1NUMBERHeader Level user extensible attribute1 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE2NUMBERHeader Level user extensible attribute2 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE3NUMBERHeader Level user extensible attribute3 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE4NUMBERHeader Level user extensible attribute4 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE5NUMBERHeader Level user extensible attribute5 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE6NUMBERHeader Level user extensible attribute6 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE7NUMBERHeader Level user extensible attribute7 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE8NUMBERHeader Level user extensible attribute8 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE9NUMBERHeader Level user extensible attribute9 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE10NUMBERHeader Level user extensible attribute10 of type number used by third party service provider HEADER_EXT_DATE_ATTRIBUTE1DATEHeader Level user extensible attribute1 of type date used by third party service provider HEADER_EXT_DATE_ATTRIBUTE2DATEHeader Level user extensible attribute2 of type date used by third party service provider HEADER_EXT_DATE_ATTRIBUTE3DATEHeader Level ueader Level user extensible attribute3 of type date used by third party service provider HEADER_EXT_DATE_ATTRIBUTE4DATEHeader Level user extensible attribute4 of type date used by third party service provider HEADER_EXT_DATE_ATTRIBUTE5DATEHeader Level user extensible attribute5 of type date used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE1VARCHAR2150Line Level user extensible attribute1 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE2VARCHAR2150Line Level user extensible attribute2 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE3VARCHAR2150Line Level user extensible attribute3 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE4VARCHAR2150Line Level user extensible attribute4 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE5VARCHAR2150Line Level user extensible attribute5 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE6VARCHAR2150Line Level user extensible attribute6 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE7VARCHAR2150Line Level user extensible attribute7 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE8VARCHAR2150Line Level user extensible attribute8 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE9VARCHAR2150Line Level user extensible attribute9 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE10VARCHAR2150Line Level user extensible attribute10 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE11VARCHAR2150Line Level user extensible attribute11 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE12VARCHAR2150Line Level user extensible attribute12 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE13VARCHAR2150Line Level user extensible attribute13 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE14VARCHAR2150Line Level user extensible attribute14 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE15VARCHAR2150Line Level user extensible attribute15 of type character used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE1NUMBERLine Level user extensible attribute1 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE2NUMBERLine Level user extensible attribute2 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE3NUMBERLine Level user extensible attribute3 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE4NUMBERLine Level user extensible attribute4 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE5NUMBERLine Level user extensible attribute5 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE6NUMBERLine Level user extensible attribute6 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE7NUMBERLine Level user extensible attribute7 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE8NUMBERLine Level user extensible attribute8 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE9NUMBERLine Level user extensible attribute9 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE10NUMBERLine Level user extensible attribute10 of type number used by third party service provider LINE_EXT_DATE_ATTRIBUTE1DATELine Level user extensible attribute1 of type date used by third party service provider LINE_EXT_DATE_ATTRIBUTE2DATELine Level user extensible attribute2 of type date used by third party service provider LINE_EXT_DATE_ATTRIBUTE3DATELine Level user extensible attribute3 of type date used by third party service provider LINE_EXT_DATE_ATTRIBUTE4DATELine Level user extensible attribute4 of type date used by third party service provider LINE_EXT_DATE_ATTRIBUTE5DATELine Level user extensible attribute5 of type date used by third party service provider EXEMPT_CERTIFICATE_NUMBERVARCHAR280Tax exemption certificate number EXEMPT_REASONVARCHAR2240Tax exemption reason EXEMPTION_CONTROL_FLAGVARCHAR21Lookup 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_IDNUMBERParty tax profile identifier for ship from party of the transaction line SHIP_TO_SITE_TAX_PROF_IDNUMBERParty tax profile identifier for ship to party site of the transaction line SHIP_TO_PARTY_TAX_PROF_IDNUMBERParty tax profile identifier for ship to party of the transaction line SHIP_TO_LOCATION_IDNUMBERShip to location identifier BILL_TO_CUST_ACCT_SITE_USE_IDNUMBERColumn to record bill to customer account site use identifier for Receivables BILL_TO_SITE_TAX_PROF_IDNUMBERParty tax profile identifier for bill to party site of the transaction line BILL_TO_PARTY_TAX_PROF_IDNUMBERParty tax profile identifier for bill to party of the transaction line BILL_TO_LOCATION_IDNUMBERBill to location identifier TRADING_HQ_SITE_TAX_PROF_IDNUMBERNot currently used TRADING_HQ_PARTY_TAX_PROF_IDNUMBERNot currently used BILL_THIRD_PTY_ACCT_IDNUMBERColumn to record bill to customer account identifier for Receivables or bill from supplier identifier for Payables RECEIVABLES_TRX_TYPE_IDNUMBERTransaction type identifier for Receivables transactions RECEIVABLES_TRX_TYPE_SEQ_IDNUMBERTransaction type identifier for Receivables transactions ADJUSTED_DOC_APPLICATION_IDNUMBERAdjusted document application identifier ADJUSTED_DOC_ENTITY_CODEVARCHAR230Adjusted document entity code ADJUSTED_DOC_EVENT_CLASS_CODEVARCHAR230Adjusted document event class code TAX_PROVIDER_IDNUMBERIdentifier 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_CODEVARCHAR230Tax regime code SHIP_TO_PARTY_NUMBERVARCHAR230Number of the ship to party SHIP_TO_PARTY_NAMEVARCHAR2360Name of the ship to party SHIP_FROM_PARTY_NUMBERVARCHAR230Number of the ship from party SHIP_FROM_PARTY_NAMEVARCHAR2360Name of the ship from party BILL_TO_PARTY_NUMBERVARCHAR230Number of the bill to party BILL_TO_PARTY_NAMEVARCHAR2360Name of the bill to party BILL_FROM_PARTY_NUMBERVARCHAR230Number of the bill from party BILL_FROM_PARTY_NAMEVARCHAR2360Name of the bill from party LINE_EXT_VARCHAR_ATTRIBUTE16VARCHAR2150Line Level user extensible attribute16 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE17VARCHAR2150Line Level user extensible attribute17 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE18VARCHAR2150Line Level user extensible attribute18 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE19VARCHAR2150Line Level user extensible attribute19 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE20VARCHAR2150Line Level user extensible attribute20 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE21VARCHAR2150Line Level user extensible attribute21 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE22VARCHAR2150Line Level user extensible attribute22 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE23VARCHAR2150Line Level user extensible attribute23 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE24VARCHAR2150Line Level user extensible attribute24 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE25VARCHAR2150Line Level user extensible attribute25 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE26VARCHAR2150Line Level user extensible attribute26 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE27VARCHAR2150Line Level user extensible attribute27 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE28VARCHAR2150Line Level user extensible attribute28 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE29VARCHAR2150Line Level user extensible attribute29 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE30VARCHAR2150Line Level user extensible attribute30 of type character used by third party service provider SHIP_TO_CUST_ACCT_SITE_USE_IDNUMBERColumn to record ship to customer account site use identifier for Receivables. SHIP_THIRD_PTY_ACCT_SITE_IDNUMBERColumn to record ship to customer account site identifier for Receivables or ship from supplier site identifier for Payables BILL_THIRD_PTY_ACCT_SITE_IDNUMBERColumn to record bill to customer account site identifier for Receivables or bill from supplier site identifier for Payables TAX_DETERMINE_DATEDATEOracle internal use only

Name

INTERNAL_ORGANIZATION_IDNUMBERYesInternal organization identifier of the transaction

EVENT_CLASS_MAPPING_IDNUMBEREvent class mapping identifier

TRX_IDNUMBERYesPrimary transaction identifier

ENTITY_CODEVARCHAR230YesEntity code of the application event class for the transaction

EVENT_CLASS_CODEVARCHAR230YesApplication event class of the transaction

APPLICATION_IDNUMBERYesApplication Identifier of the transaction

TRX_DATEDATEYesTransaction date

TRX_CURRENCY_CODEVARCHAR215Transaction currency code

TRX_NUMBERVARCHAR2150Transaction number, typically the number that enables a user to identify a transaction

RECORD_TYPE_CODEVARCHAR230YesLookup code to indicate whether the record is migrated, seeded or defined by the user

TRX_LINE_IDNUMBERTransaction line identifier

TRX_LEVEL_TYPEVARCHAR230YesColumn to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.

LINE_LEVEL_ACTIONVARCHAR230Column to store action at the transaction line level

TRX_LINE_TYPEVARCHAR230Column to store type of the transaction line. Possible values are ITEM, FREIGHT and MISC.

TRX_LINE_DATEDATETransaction line date

LINE_AMTNUMBERYesTransaction line amount

TRX_LINE_QUANTITYNUMBERTransaction line quantity

UNIT_PRICENUMBERUnit Price of the transaction line item or product

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

PRODUCT_ORG_IDNUMBERIdentifier of the organization for the inventory item

UOM_CODEVARCHAR230Unit of measure code for the inventory item

PRODUCT_TYPEVARCHAR2240Product type code of the inventory item. Possible values are GOODS and SERVICES.

PRODUCT_CODEVARCHAR2300Inventory item code

FOB_POINTVARCHAR230Free on Board point

SHIP_TO_GEOGRAPHY_TYPE1VARCHAR230Geography type of the first element of the Ship To location

SHIP_TO_GEOGRAPHY_VALUE1VARCHAR230Geography name of the first element of the Ship To location

SHIP_TO_GEOGRAPHY_TYPE2VARCHAR230Geography type of the second element of the Ship To location

SHIP_TO_GEOGRAPHY_VALUE2VARCHAR230Geography name of the second element of the Ship To location

SHIP_TO_GEOGRAPHY_TYPE3VARCHAR230Geography type of the third element of the Ship To location

SHIP_TO_GEOGRAPHY_VALUE3VARCHAR230Geography name of the third element of the Ship To location

SHIP_TO_GEOGRAPHY_TYPE4VARCHAR230Geography type of the fourth element of the Ship To location

SHIP_TO_GEOGRAPHY_VALUE4VARCHAR230Geography name of the fourth element of the Ship To location

SHIP_TO_GEOGRAPHY_TYPE5VARCHAR230Geography type of the fifth element of the Ship To location

SHIP_TO_GEOGRAPHY_VALUE5VARCHAR230Geography name of the fifth element of the Ship To location

SHIP_TO_GEOGRAPHY_TYPE6VARCHAR230Geography type of the sixth element of the Ship To location

SHIP_TO_GEOGRAPHY_VALUE6VARCHAR230Geography name of the sixth element of the Ship To location

SHIP_TO_GEOGRAPHY_TYPE7VARCHAR230Geography type of the seventh element of the Ship To location

SHIP_TO_GEOGRAPHY_VALUE7VARCHAR230Geography name of the seventh element of the Ship To location

SHIP_TO_GEOGRAPHY_TYPE8VARCHAR230Geography type of the eighth element of the Ship To location

SHIP_TO_GEOGRAPHY_VALUE8VARCHAR230Geography name of the eighth element of the Ship To location

SHIP_TO_GEOGRAPHY_TYPE9VARCHAR230Geography type of the nineth element of the Ship To location

SHIP_TO_GEOGRAPHY_VALUE9VARCHAR230Geography name of the nineth element of the Ship To location

SHIP_TO_GEOGRAPHY_TYPE10VARCHAR230Geography type of the tenth element of the Ship To location

SHIP_TO_GEOGRAPHY_VALUE10VARCHAR230Geography name of the tenth element of the Ship To location

SHIP_FROM_GEOGRAPHY_TYPE1VARCHAR230Geography type of the first element of the Ship From location

SHIP_FROM_GEOGRAPHY_VALUE1VARCHAR230Geography name of the first element of the Ship From location

SHIP_FROM_GEOGRAPHY_TYPE2VARCHAR230Geography type of the second element of the Ship From location

SHIP_FROM_GEOGRAPHY_VALUE2VARCHAR230Geography name of the second element of the Ship From location

SHIP_FROM_GEOGRAPHY_TYPE3VARCHAR230Geography type of the third element of the Ship From location

SHIP_FROM_GEOGRAPHY_VALUE3VARCHAR230Geography name of the third element of the Ship From location

SHIP_FROM_GEOGRAPHY_TYPE4VARCHAR230Geography type of the fourth element of the Ship From location

SHIP_FROM_GEOGRAPHY_VALUE4VARCHAR230Geography name of the fourth element of the Ship from location

SHIP_FROM_GEOGRAPHY_TYPE5VARCHAR230Geography type of the fifth element of the Ship from location

SHIP_FROM_GEOGRAPHY_VALUE5VARCHAR230Geography name of the fifth element of the Ship from location

SHIP_FROM_GEOGRAPHY_TYPE6VARCHAR230Geography type of the sixth element of the Ship from location

SHIP_FROM_GEOGRAPHY_VALUE6VARCHAR230Geography name of the sixth element of the Ship from location

SHIP_FROM_GEOGRAPHY_TYPE7VARCHAR230Geography type of the seventh element of the Ship from location

SHIP_FROM_GEOGRAPHY_VALUE7VARCHAR230Geography name of the seventh element of the Ship from location

SHIP_FROM_GEOGRAPHY_TYPE8VARCHAR230Geography type of the eighth element of the Ship from location

SHIP_FROM_GEOGRAPHY_VALUE8VARCHAR230Geography name of the eighth element of the Ship from location

SHIP_FROM_GEOGRAPHY_TYPE9VARCHAR230Geography type of the nineth element of the Ship from location

SHIP_FROM_GEOGRAPHY_VALUE9VARCHAR230Geography name of the nineth element of the Ship from location

SHIP_FROM_GEOGRAPHY_TYPE10VARCHAR230Geography type of the tenth element of the Ship from location

SHIP_FROM_GEOGRAPHY_VALUE10VARCHAR230Geography name of the tenth element of the Ship from location

BILL_TO_GEOGRAPHY_TYPE1VARCHAR230Geography type of the first element of the Bill To location

BILL_TO_GEOGRAPHY_VALUE1VARCHAR230Geography name of the first element of the Bill To location

BILL_TO_GEOGRAPHY_TYPE2VARCHAR230Geography type of the second element of the Bill To location

BILL_TO_GEOGRAPHY_VALUE2VARCHAR230Geography name of the second element of the Bill To location

BILL_TO_GEOGRAPHY_TYPE3VARCHAR230Geography type of the third element of the Bill To location

BILL_TO_GEOGRAPHY_VALUE3VARCHAR230Geography name of the third element of the Bill To location

BILL_TO_GEOGRAPHY_TYPE4VARCHAR230Geography type of the fourth element of the Bill To location

BILL_TO_GEOGRAPHY_VALUE4VARCHAR230Geography name of the fourth element of the Bill To location

BILL_TO_GEOGRAPHY_TYPE5VARCHAR230Geography type of the fifth element of the Bill To location

BILL_TO_GEOGRAPHY_VALUE5VARCHAR230Geography name of the fifth element of the Bill To location

BILL_TO_GEOGRAPHY_TYPE6VARCHAR230Geography type of the sixth element of the Bill To location

BILL_TO_GEOGRAPHY_VALUE6VARCHAR230Geography name of the sixth element of the Bill To location

BILL_TO_GEOGRAPHY_TYPE7VARCHAR230Geography type of the seventh element of the Bill To location

BILL_TO_GEOGRAPHY_VALUE7VARCHAR230Geography name of the seventh element of the Bill To location

BILL_TO_GEOGRAPHY_TYPE8VARCHAR230Geography type of the eighth element of the Bill To location

BILL_TO_GEOGRAPHY_VALUE8VARCHAR230Geography name of the eighth element of the Bill To location

BILL_TO_GEOGRAPHY_TYPE9VARCHAR230Geography type of the nineth element of the Bill To location

BILL_TO_GEOGRAPHY_VALUE9VARCHAR230Geography name of the nineth element of the Bill To location

BILL_TO_GEOGRAPHY_TYPE10VARCHAR230Geography type of the tenth element of the Bill To location

BILL_TO_GEOGRAPHY_VALUE10VARCHAR230Geography name of the tenth element of the Bill To location

BILL_FROM_GEOGRAPHY_TYPE1VARCHAR230Geography type of the first element of the Bill From location

BILL_FROM_GEOGRAPHY_VALUE1VARCHAR230Geography name of the first element of the Bill From location

BILL_FROM_GEOGRAPHY_TYPE2VARCHAR230Geography type of the second element of the Bill From location

BILL_FROM_GEOGRAPHY_VALUE2VARCHAR230Geography name of the second element of the Bill From location

BILL_FROM_GEOGRAPHY_TYPE3VARCHAR230Geography type of the third element of the Bill From location

BILL_FROM_GEOGRAPHY_VALUE3VARCHAR230Geography name of the third element of the Bill From location

BILL_FROM_GEOGRAPHY_TYPE4VARCHAR230Geography type of the fourth element of the Bill From location

BILL_FROM_GEOGRAPHY_VALUE4VARCHAR230Geography name of the fourth element of the Bill from location

BILL_FROM_GEOGRAPHY_TYPE5VARCHAR230Geography type of the fifth element of the Bill From location

BILL_FROM_GEOGRAPHY_VALUE5VARCHAR230Geography name of the fifth element of the Bill From location

BILL_FROM_GEOGRAPHY_TYPE6VARCHAR230Geography type of the sixth element of the Bill From location

BILL_FROM_GEOGRAPHY_VALUE6VARCHAR230Geography name of the sixth element of the Bill From location

BILL_FROM_GEOGRAPHY_TYPE7VARCHAR230Geography type of the seventh element of the Bill From location

BILL_FROM_GEOGRAPHY_VALUE7VARCHAR230Geography name of the seventh element of the Bill From location

BILL_FROM_GEOGRAPHY_TYPE8VARCHAR230Geography type of the eighth element of the Bill From location

BILL_FROM_GEOGRAPHY_VALUE8VARCHAR230Geography name of the eighth element of the Bill From location

BILL_FROM_GEOGRAPHY_TYPE9VARCHAR230Geography type of the nineth element of the Bill From location

BILL_FROM_GEOGRAPHY_VALUE9VARCHAR230Geography name of the nineth element of the Bill From location

BILL_FROM_GEOGRAPHY_TYPE10VARCHAR230Geography type of the tenth element of the Bill From location

BILL_FROM_GEOGRAPHY_VALUE10VARCHAR230Geography name of the tenth element of the Bill From location

APPLIED_FROM_TRX_IDNUMBERApplied from document transaction identifier

APPLIED_FROM_LINE_IDNUMBERTransaction line identifier for the applied from document

APPLIED_FROM_TRX_LEVEL_TYPEVARCHAR230Column to record the level at which the applied from document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.

APPLIED_FROM_TRX_NUMBERVARCHAR2150Transaction number of the applied from document

ADJUSTED_DOC_TRX_IDNUMBERAdjusted document transaction identifier

ADJUSTED_DOC_LINE_IDNUMBERTransaction line identifier for the adjusted document

ADJUSTED_DOC_TRX_LEVEL_TYPEVARCHAR230Column to record the level at which the adjusted document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.

ADJUSTED_DOC_NUMBERVARCHAR2150Transaction number of the adjusted document

ADJUSTED_DOC_DATEDATEAdjusted document date

HEADER_EXT_VARCHAR_ATTRIBUTE1VARCHAR2150Header level user extensible attribute1 of type character used by third party service provider

HEADER_EXT_VARCHAR_ATTRIBUTE2VARCHAR2150Header Level user extensible attribute2 of type character used by third party service provider

HEADER_EXT_VARCHAR_ATTRIBUTE3VARCHAR2150Header Level user extensible attribute3 of type character used by third party service provider

HEADER_EXT_VARCHAR_ATTRIBUTE4VARCHAR2150Header Level user extensible attribute4 of type character used by third party service provider

HEADER_EXT_VARCHAR_ATTRIBUTE5VARCHAR2150Header Level user extensible attribute5 of type character used by third party service provider

HEADER_EXT_VARCHAR_ATTRIBUTE6VARCHAR2150Header Level user extensible attribute6 of type character used by third party service provider

HEADER_EXT_VARCHAR_ATTRIBUTE7VARCHAR2150Header Level user extensible attribute7 of type character used by third party service provider

HEADER_EXT_VARCHAR_ATTRIBUTE8VARCHAR2150Header Level user extensible attribute8 of type character used by third party service provider

HEADER_EXT_VARCHAR_ATTRIBUTE9VARCHAR2150Header Level user extensible attribute9 of type character used by third party service provider

HEADER_EXT_VARCHAR_ATTRIBUTE10VARCHAR2150Header Level user extensible attribute10 of type character used by third party service provider

HEADER_EXT_VARCHAR_ATTRIBUTE11VARCHAR2150Header Level user extensible attribute11 of type character used by third party service provider

HEADER_EXT_VARCHAR_ATTRIBUTE12VARCHAR2150Header Level user extensible attribute12 of type character used by third party service provider

HEADER_EXT_VARCHAR_ATTRIBUTE13VARCHAR2150Header Level user extensible attribute13 of type character used by third party service provider

HEADER_EXT_VARCHAR_ATTRIBUTE14VARCHAR2150Header Level user extensible attribute14 of type character used by third party service provider

HEADER_EXT_VARCHAR_ATTRIBUTE15VARCHAR2150Header Level user extensible attribute15 of type character used by third party service provider

HEADER_EXT_NUMBER_ATTRIBUTE1NUMBERHeader Level user extensible attribute1 of type number used by third party service provider

HEADER_EXT_NUMBER_ATTRIBUTE2NUMBERHeader Level user extensible attribute2 of type number used by third party service provider

HEADER_EXT_NUMBER_ATTRIBUTE3NUMBERHeader Level user extensible attribute3 of type number used by third party service provider

HEADER_EXT_NUMBER_ATTRIBUTE4NUMBERHeader Level user extensible attribute4 of type number used by third party service provider

HEADER_EXT_NUMBER_ATTRIBUTE5NUMBERHeader Level user extensible attribute5 of type number used by third party service provider

HEADER_EXT_NUMBER_ATTRIBUTE6NUMBERHeader Level user extensible attribute6 of type number used by third party service provider

HEADER_EXT_NUMBER_ATTRIBUTE7NUMBERHeader Level user extensible attribute7 of type number used by third party service provider

HEADER_EXT_NUMBER_ATTRIBUTE8NUMBERHeader Level user extensible attribute8 of type number used by third party service provider

HEADER_EXT_NUMBER_ATTRIBUTE9NUMBERHeader Level user extensible attribute9 of type number used by third party service provider

HEADER_EXT_NUMBER_ATTRIBUTE10NUMBERHeader Level user extensible attribute10 of type number used by third party service provider

HEADER_EXT_DATE_ATTRIBUTE1DATEHeader Level user extensible attribute1 of type date used by third party service provider

HEADER_EXT_DATE_ATTRIBUTE2DATEHeader Level user extensible attribute2 of type date used by third party service provider

HEADER_EXT_DATE_ATTRIBUTE3DATEHeader Level ueader Level user extensible attribute3 of type date used by third party service provider

HEADER_EXT_DATE_ATTRIBUTE4DATEHeader Level user extensible attribute4 of type date used by third party service provider

HEADER_EXT_DATE_ATTRIBUTE5DATEHeader Level user extensible attribute5 of type date used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE1VARCHAR2150Line Level user extensible attribute1 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE2VARCHAR2150Line Level user extensible attribute2 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE3VARCHAR2150Line Level user extensible attribute3 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE4VARCHAR2150Line Level user extensible attribute4 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE5VARCHAR2150Line Level user extensible attribute5 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE6VARCHAR2150Line Level user extensible attribute6 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE7VARCHAR2150Line Level user extensible attribute7 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE8VARCHAR2150Line Level user extensible attribute8 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE9VARCHAR2150Line Level user extensible attribute9 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE10VARCHAR2150Line Level user extensible attribute10 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE11VARCHAR2150Line Level user extensible attribute11 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE12VARCHAR2150Line Level user extensible attribute12 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE13VARCHAR2150Line Level user extensible attribute13 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE14VARCHAR2150Line Level user extensible attribute14 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE15VARCHAR2150Line Level user extensible attribute15 of type character used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE1NUMBERLine Level user extensible attribute1 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE2NUMBERLine Level user extensible attribute2 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE3NUMBERLine Level user extensible attribute3 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE4NUMBERLine Level user extensible attribute4 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE5NUMBERLine Level user extensible attribute5 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE6NUMBERLine Level user extensible attribute6 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE7NUMBERLine Level user extensible attribute7 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE8NUMBERLine Level user extensible attribute8 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE9NUMBERLine Level user extensible attribute9 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE10NUMBERLine Level user extensible attribute10 of type number used by third party service provider

LINE_EXT_DATE_ATTRIBUTE1DATELine Level user extensible attribute1 of type date used by third party service provider

LINE_EXT_DATE_ATTRIBUTE2DATELine Level user extensible attribute2 of type date used by third party service provider

LINE_EXT_DATE_ATTRIBUTE3DATELine Level user extensible attribute3 of type date used by third party service provider

LINE_EXT_DATE_ATTRIBUTE4DATELine Level user extensible attribute4 of type date used by third party service provider

LINE_EXT_DATE_ATTRIBUTE5DATELine Level user extensible attribute5 of type date used by third party service provider

EXEMPT_CERTIFICATE_NUMBERVARCHAR280Tax exemption certificate number

EXEMPT_REASONVARCHAR2240Tax exemption reason

EXEMPTION_CONTROL_FLAGVARCHAR21Lookup 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_IDNUMBERParty tax profile identifier for ship from party of the transaction line

SHIP_TO_SITE_TAX_PROF_IDNUMBERParty tax profile identifier for ship to party site of the transaction line

SHIP_TO_PARTY_TAX_PROF_IDNUMBERParty tax profile identifier for ship to party of the transaction line

SHIP_TO_LOCATION_IDNUMBERShip to location identifier

BILL_TO_CUST_ACCT_SITE_USE_IDNUMBERColumn to record bill to customer account site use identifier for Receivables

BILL_TO_SITE_TAX_PROF_IDNUMBERParty tax profile identifier for bill to party site of the transaction line

BILL_TO_PARTY_TAX_PROF_IDNUMBERParty tax profile identifier for bill to party of the transaction line

BILL_TO_LOCATION_IDNUMBERBill to location identifier

TRADING_HQ_SITE_TAX_PROF_IDNUMBERNot currently used

TRADING_HQ_PARTY_TAX_PROF_IDNUMBERNot currently used

BILL_THIRD_PTY_ACCT_IDNUMBERColumn to record bill to customer account identifier for Receivables or bill from supplier identifier for Payables

RECEIVABLES_TRX_TYPE_IDNUMBERTransaction type identifier for Receivables transactions

RECEIVABLES_TRX_TYPE_SEQ_IDNUMBERTransaction type identifier for Receivables transactions

ADJUSTED_DOC_APPLICATION_IDNUMBERAdjusted document application identifier

ADJUSTED_DOC_ENTITY_CODEVARCHAR230Adjusted document entity code

ADJUSTED_DOC_EVENT_CLASS_CODEVARCHAR230Adjusted document event class code

TAX_PROVIDER_IDNUMBERIdentifier 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_CODEVARCHAR230Tax regime code

SHIP_TO_PARTY_NUMBERVARCHAR230Number of the ship to party

SHIP_TO_PARTY_NAMEVARCHAR2360Name of the ship to party

SHIP_FROM_PARTY_NUMBERVARCHAR230Number of the ship from party

SHIP_FROM_PARTY_NAMEVARCHAR2360Name of the ship from party

BILL_TO_PARTY_NUMBERVARCHAR230Number of the bill to party

BILL_TO_PARTY_NAMEVARCHAR2360Name of the bill to party

BILL_FROM_PARTY_NUMBERVARCHAR230Number of the bill from party

BILL_FROM_PARTY_NAMEVARCHAR2360Name of the bill from party

LINE_EXT_VARCHAR_ATTRIBUTE16VARCHAR2150Line Level user extensible attribute16 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE17VARCHAR2150Line Level user extensible attribute17 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE18VARCHAR2150Line Level user extensible attribute18 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE19VARCHAR2150Line Level user extensible attribute19 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE20VARCHAR2150Line Level user extensible attribute20 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE21VARCHAR2150Line Level user extensible attribute21 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE22VARCHAR2150Line Level user extensible attribute22 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE23VARCHAR2150Line Level user extensible attribute23 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE24VARCHAR2150Line Level user extensible attribute24 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE25VARCHAR2150Line Level user extensible attribute25 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE26VARCHAR2150Line Level user extensible attribute26 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE27VARCHAR2150Line Level user extensible attribute27 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE28VARCHAR2150Line Level user extensible attribute28 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE29VARCHAR2150Line Level user extensible attribute29 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE30VARCHAR2150Line Level user extensible attribute30 of type character used by third party service provider

SHIP_TO_CUST_ACCT_SITE_USE_IDNUMBERColumn to record ship to customer account site use identifier for Receivables.

SHIP_THIRD_PTY_ACCT_SITE_IDNUMBERColumn to record ship to customer account site identifier for Receivables or ship from supplier site identifier for Payables

BILL_THIRD_PTY_ACCT_SITE_IDNUMBERColumn to record bill to customer account site identifier for Receivables or bill from supplier site identifier for Payables

TAX_DETERMINE_DATEDATEOracle internal use only