ZX_PARTY_TAX_PROFILE
This table stores Party Tax Profile Information
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
ZX_PARTY_TAX_PROFILE_PK |
PARTY_TAX_PROFILE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PARTY_TYPE_CODE | VARCHAR2 | 30 | Lookup code for party type | ||
| SUPPLIER_FLAG | VARCHAR2 | 1 | Y or N indicates whether this party tax profile is for a third party supplier | ||
| CUSTOMER_FLAG | VARCHAR2 | 1 | Y or N indicates whether this party tax profile is for a third party customer | ||
| SITE_FLAG | VARCHAR2 | 1 | Y or N indicates whether this party tax profile is for a third party site | ||
| PROCESS_FOR_APPLICABILITY_FLAG | VARCHAR2 | 1 | Y or N indicates whether taxes should be automatically calculated for this party tax profile | ||
| ROUNDING_LEVEL_CODE | VARCHAR2 | 30 | Rounding level code to be used for rounding of taxes calculated for this party tax profile | ||
| ROUNDING_RULE_CODE | VARCHAR2 | 30 | Rounding rule code to be used for rounding of taxes calculated for this party tax profile | ||
| WITHHOLDING_START_DATE | DATE | Withholding start date for this party tax profile | |||
| INCLUSIVE_TAX_FLAG | VARCHAR2 | 1 | Y or N indicates whether transaction line amounts include tax amount for this party tax profile. This column is applicable for only suppliers. | ||
| ALLOW_AWT_FLAG | VARCHAR2 | 1 | Y or N indicates whether tax withholding is allowed for this party tax profile | ||
| USE_LE_AS_SUBSCRIBER_FLAG | VARCHAR2 | 1 | Y or N indicates whether Legal Entity should be used for determining taxes for transactions of this party tax profile. This column is applicable only for operating units. | ||
| LEGAL_ESTABLISHMENT_FLAG | VARCHAR2 | 1 | Y or N indicates whether this party tax profile is for a first party legal establishment | ||
| FIRST_PARTY_LE_FLAG | VARCHAR2 | 1 | Y or N indicates whether this party tax profile is for a first party legal entity | ||
| REPORTING_AUTHORITY_FLAG | VARCHAR2 | 1 | Y or N indicates whether this party tax profile is for a reporting tax authority | ||
| COLLECTING_AUTHORITY_FLAG | VARCHAR2 | 1 | Y or N indicates whether this party tax profile is for a collecting tax authority | ||
| PROVIDER_TYPE_CODE | VARCHAR2 | 30 | Lookup code that identifies whether the third party provider offers tax content or tax services or both | ||
| CREATE_AWT_DISTS_TYPE_CODE | VARCHAR2 | 30 | Lookup code to indicate the event when tax is automatically withheld for this party tax profile (Never, Approval, Payment) | ||
| CREATE_AWT_INVOICES_TYPE_CODE | VARCHAR2 | 30 | Lookup code to indicate the event when withholding tax invoices are automatically created for this party tax profile (Never, Approval, Payment) | ||
| TAX_CLASSIFICATION_CODE | VARCHAR2 | 30 | Default tax classification code for this party tax profile | ||
| SELF_ASSESS_FLAG | VARCHAR2 | 1 | Y or N indicates whether taxes are self-assessed for this party tax profile | ||
| ALLOW_OFFSET_TAX_FLAG | VARCHAR2 | 1 | Y or N indicates whether offset taxes are allowed for this party tax profile | ||
| EFFECTIVE_FROM_USE_LE | DATE | Effective start date from which Legal Entity is used to determine taxes for transactions of this party tax profile. This column is applicable only for operating units. | |||
| RECORD_TYPE_CODE | VARCHAR2 | 30 | Lookup code to indicate whether the record is migrated, seeded or defined by the user | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| PROGRAM_LOGIN_ID | NUMBER | Login user identifier of this record by a concurrent program | |||
| PARTY_TAX_PROFILE_ID | NUMBER | 18 | Yes | Unique identifier | |
| PARTY_ID | NUMBER | 18 | Yes | Party identifier | |
| REP_REGISTRATION_NUMBER | VARCHAR2 | 50 | Tax registration number for this party tax profile. This column is applicable only for suppliers, customers and first party legal establishments. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| REGISTRATION_TYPE_CODE | VARCHAR2 | 30 | Lookup code to indicate registration type | ||
| COUNTRY_CODE | VARCHAR2 | 2 | Country code used to validate the tax registration number for this party tax profile | ||
| MERGED_TO_PTP_ID | NUMBER | 18 | Identifier of the party tax profile into which this party tax profile is merged | ||
| MERGED_STATUS_CODE | VARCHAR2 | 30 | Lookup code to indicate the status of party merge for this party tax profile | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Program name of last concurrent program to update this record | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Application name of last concurrent program to update this record | ||
| WHT_DATE_BASIS | VARCHAR2 | 30 | Attribute to indicate whether the withholding date basis to be adopted for the party is invoice date or accounting date. | ||
| ALLOW_ZERO_AMT_WHT_INV_FLAG | VARCHAR2 | 1 | Yes or No indicates whether zero amount withholding invoices can be created. | ||
| WHT_ROUNDING_LEVEL_CODE | VARCHAR2 | 30 | Rounding level code to be used for rounding of withholding taxes calculated for this party tax profile. | ||
| WHT_ROUNDING_RULE_CODE | VARCHAR2 | 30 | Rounding rule code to be used for rounding of withholding taxes calculated for this party tax profile. | ||
| WHT_USE_LE_AS_SUBSCRIBER_FLAG | VARCHAR2 | 1 | Yes or No indicates whether legal entity should be used for determining withholding taxes for transactions of this party tax profile. This column is applicable only for business units. | ||
| WHT_EFFECTIVE_FROM_USE_LE | DATE | Start date that the business unit uses the withholding tax configuration of the associated legal entity. | |||
| TRANSPORT_PRVDR_FLAG | VARCHAR2 | 1 | Indicates whether the party is a transportation provider such as freight carrier. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| USE_SYSTEM_DEFAULTS_FLAG | VARCHAR2 | 1 | Indicates that application default values of tax status, rate, recovery rate, taxable basis formula, or tax calculation formula are used in tax calculation when an incomplete or inconsistent configuration is found. | ||
| TAX_GROSS_NET_FLAG | VARCHAR2 | 1 | Transaction tax calculated on the gross or net amount identifier. | ||
| WHT_GROSS_NET_FLAG | VARCHAR2 | 1 | Withholding tax calculated on the gross or net amount identifier. | ||
| CUSTOMER_TRN_DEFAULT_FLAG | VARCHAR2 | 1 | This column indicates whether the customer tax registration number should be defaulted on Receivables transactions for this leg al entity. Y indicates yes, and N indicates no. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ZX_PARTY_TAX_PROFILE | hz_parties | PARTY_ID |
| ZX_PARTY_TAX_PROFILE | hz_party_sites | PARTY_ID |
| zx_lines_summary | zx_party_tax_profile | CONTENT_OWNER_ID |
| zx_lines_summary | zx_party_tax_profile | TAX_PROVIDER_ID |
| zx_taxes_b | zx_party_tax_profile | CONTENT_OWNER_ID |
| zx_taxes_b | zx_party_tax_profile | REP_TAX_AUTHORITY_ID |
| zx_taxes_b | zx_party_tax_profile | COLL_TAX_AUTHORITY_ID |
| zx_process_results | zx_party_tax_profile | CONTENT_OWNER_ID |
| zx_api_owner_statuses | zx_party_tax_profile | API_OWNER_ID |
| zx_rec_nrec_dist | zx_party_tax_profile | CONTENT_OWNER_ID |
| zx_transaction | zx_party_tax_profile | FIRST_PTY_ORG_ID |
| zx_regimes_usages | zx_party_tax_profile | FIRST_PTY_ORG_ID |
| zx_lines_det_factors | zx_party_tax_profile | SHIP_TO_PARTY_TAX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | SHIP_FROM_PARTY_TAX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | POA_PARTY_TAX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | POO_PARTY_TAX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | BILL_TO_PARTY_TAX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | BILL_FROM_PARTY_TAX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | TITLE_TRANS_PARTY_TAX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | SHIP_TO_SITE_TAX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | SHIP_FROM_SITE_TAX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | POA_SITE_TAX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | POO_SITE_TAX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | BILL_TO_SITE_TAX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | BILL_FROM_SITE_TAX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | RDNG_SHIP_TO_PTY_TX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | RDNG_SHIP_FROM_PTY_TX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | RDNG_BILL_TO_PTY_TX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | RDNG_BILL_FROM_PTY_TX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | RDNG_SHIP_TO_PTY_TX_P_ST_ID |
| zx_lines_det_factors | zx_party_tax_profile | RDNG_SHIP_FROM_PTY_TX_P_ST_ID |
| zx_lines_det_factors | zx_party_tax_profile | RDNG_BILL_TO_PTY_TX_P_ST_ID |
| zx_lines_det_factors | zx_party_tax_profile | RDNG_BILL_FROM_PTY_TX_P_ST_ID |
| zx_lines_det_factors | zx_party_tax_profile | MERCHANT_PARTY_TAX_PROF_ID |
| zx_lines_det_factors | zx_party_tax_profile | HQ_ESTB_PARTY_TAX_PROF_ID |
| zx_lines | zx_party_tax_profile | CONTENT_OWNER_ID |
| zx_lines | zx_party_tax_profile | HQ_ESTB_PARTY_TAX_PROF_ID |
| zx_lines | zx_party_tax_profile | ROUNDING_LVL_PARTY_TAX_PROF_ID |
| zx_lines | zx_party_tax_profile | TAX_PROVIDER_ID |
| zx_status_b | zx_party_tax_profile | CONTENT_OWNER_ID |
| zx_subscription_details | zx_party_tax_profile | FIRST_PTY_ORG_ID |
| zx_subscription_details | zx_party_tax_profile | PARENT_FIRST_PTY_ORG_ID |
| zx_regimes_b | zx_party_tax_profile | REP_TAX_AUTHORITY_ID |
| zx_regimes_b | zx_party_tax_profile | COLL_TAX_AUTHORITY_ID |
| zx_api_registrations | zx_party_tax_profile | API_OWNER_ID |
| zx_rules_b | zx_party_tax_profile | CONTENT_OWNER_ID |
| zx_content_sources | zx_party_tax_profile | PROVIDER_ID |
| zx_subscription_options | zx_party_tax_profile | PARENT_FIRST_PTY_ORG_ID |
| zx_srvc_subscriptions | zx_party_tax_profile | SRVC_PROVIDER_ID |
| zx_registrations | zx_party_tax_profile | PARTY_TAX_PROFILE_ID |
| zx_registrations | zx_party_tax_profile | TAX_AUTHORITY_ID |
| zx_registrations | zx_party_tax_profile | COLL_TAX_AUTHORITY_ID |
| zx_registrations | zx_party_tax_profile | REP_TAX_AUTHORITY_ID |
| zx_trx_line_app_regimes | zx_party_tax_profile | TAX_PROVIDER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_PARTY_TAX_PROFILE_N1 | Non Unique | Default | PARTY_TYPE_CODE, REP_REGISTRATION_NUMBER |
| ZX_PARTY_TAX_PROFILE_U1 | Unique | Default | PARTY_TAX_PROFILE_ID |
| ZX_PARTY_TAX_PROFILE_U2 | Unique | Default | PARTY_ID, PARTY_TYPE_CODE |