1. Tables and Views for Financials
  2. ZX_FC_COUNTRY_DEFAULTS_

ZX_FC_COUNTRY_DEFAULTS_

This table stores tax defaults and controls for multiple countries. Each record contains tax defaults and controls for a specific country.

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ZX_FC_COUNTRY_DEFAULTS_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, COUNTRY_CODE

Columns

Name Datatype Length Precision Not-null Comments Status
COUNTRY_CODE VARCHAR2 2 Yes Country code Active
TRANS_CATEG_CTRL_LEVEL_CODE VARCHAR2 30 Column for recording the maximum number of levels allowed for selection of transaction business category codes in the transactions for this country Active
PRODUCT_CATEG_CTRL_LEVEL_CODE VARCHAR2 30 Column for recording the maximum number of levels allowed for selection of product category codes in the transactions for this country Active
PRIMARY_INVENTORY_CATEGORY_SET NUMBER Inventory category set to be used for defaulting product fiscal classification in the transactions for this country Active
INTENDED_USE_DEFAULT VARCHAR2 240 Intended use code to be defaulted in transactions for this country Active
PRODUCT_CATEG_DEFAULT VARCHAR2 240 Product category code to be defaulted in transactions for this country Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
RECORD_TYPE_CODE VARCHAR2 30 Lookup code to indicate whether the record is migrated, seeded or defined by the user Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
DEF_REGIME_FOR_INVOICE_FLAG VARCHAR2 1 Y or N indicates whether tax regime code is to be defaulted for tax registration when tax registration is created from a legal entity of this country Active
DEF_REGIME_FOR_LE_TR_FLAG VARCHAR2 1 Y or N indicates whether tax regime code is to be defaulted for imported transactions in Oracle Payables for this country Active
DEF_TAX_FOR_INVOICE_FLAG VARCHAR2 1 Y or N indicates whether tax is to be defaulted for tax registration when tax registration is created from a legal entity of this country Active
DEF_TAX_FOR_LE_TR_FLAG VARCHAR2 1 Y or N indicates whether tax is to be defaulted for imported transactions in Oracle Payables for this country Active
PROGRAM_LOGIN_ID NUMBER Login user identifier of last concurrent program to update this record Active
TAX_REGIME_CODE VARCHAR2 30 Default tax regime code for this country Active
ROUNDING_RULE_CODE VARCHAR2 30 Tax amount rounding rule code for this country Active
TAX VARCHAR2 30 Default tax for this country Active
REGISTRATION_TYPE_CODE VARCHAR2 30 Registration type code for this country Active
REGISTRATION_STATUS_CODE VARCHAR2 30 Registration status code for this country Active
COLLECT_TAX_AUTHORITY_ID NUMBER 18 Default collecting tax authority for this country Active
REPORT_TAX_AUTHORITY_ID NUMBER 18 Default reporting tax authority for this country Active
ISSUE_TAX_AUTHORITY_ID NUMBER 18 Default issuing tax authority for this country Active
COUNTRY_DEFAULTS_ID NUMBER 18 Unique identifier Active
OBJECT_VERSION_NUMBER NUMBER 9 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. Active
PROGRAM_NAME VARCHAR2 30 Program name of last concurrent program to update this record Active
PROGRAM_APP_NAME VARCHAR2 50 Application name of last concurrent program to update this record Active
INTENDED_USE_CLASSIF_ID NUMBER Default intended use code for transactions for a specified country.
VALIDATION_TYPE VARCHAR2 30 Reporting type defined for registration number validation.
VALIDATION_LEVEL VARCHAR2 30 Lookup code to indicate whether validation is based on an error or a warning.
UNIQUENESS_VALIDATION_LEVEL VARCHAR2 30 Lookup code to indicate whether validation is for all parties or a specific party.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.

Indexes

Index Uniqueness Tablespace Columns
ZX_FC_COUNTRY_DEFAULTS_N1_ Non Unique Default COUNTRY_CODE
ZX_FC_COUNTRY_DEFAULTS_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, COUNTRY_CODE