1. Tables and Views for Financials
  2. ZX_BUCKETS_F

ZX_BUCKETS_F

This table stores detail information about tax to date amount and taxable to date amount buckets associated with a first party. In addition, it could be related to third party such as supplier or customer.

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

ZX_BUCKETS_F_PK

TAX_BUCKET_ID

Columns

Name Datatype Length Precision Not-null Comments Status
TAX_BUCKET_ID NUMBER 18 Yes Unique identifier for the tax bucket. Active
TAX VARCHAR2 30 Yes Tax code associated with the tax bucket. Active
RECORD_TYPE_CODE VARCHAR2 30 Lookup code to indicate whether the record is migrated, seeded or defined by the user. Active
ACCUMULATED_TAX_AMOUNT NUMBER Cumulative tax amount to date for the period.
ACCUMULATED_TAXABLE_AMOUNT NUMBER Cumulative taxable amount to date for the period.
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. Active
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective. Active
TAX_REGIME_CODE VARCHAR2 30 Yes Tax regime associated with the tax bucket. Active
TAX_JURISDICTION_CODE VARCHAR2 30 Tax jurisdiction code associated with the tax bucket. Active
CALENDAR_NAME VARCHAR2 30 Yes Name of tax calendar defined in ZX_CALENDARS. Used when the schedule basis is set to "period". Active
PERIOD_NAME VARCHAR2 30 Yes Calendar period associated with the tax bucket. Active
BUCKET_TYPE VARCHAR2 30 Yes Indicates whether the bucket is for procure to pay or order to cash transactions. Active
THIRD_PTY_TAX_PROF_ID NUMBER 18 Party tax profile identifier for third party. Foreign key to the party tax profile table. Active
THIRD_PTY_SITE_TAX_PROF_ID NUMBER 18 Party tax profile identifier for third party site. Foreign key to the party tax profile table. 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
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
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. Active
SUPPLIER_ID NUMBER 18 Supplier identifier associated with the bucket.
FIRST_PARTY_TAX_PROFILE_ID NUMBER 18 Party tax profile identifier for the first party organization.
TAX_RATE_CODE VARCHAR2 50 Tax rate code associated with the withholding tax bucket.
REGISTRATION_NUMBER VARCHAR2 50 Stores TAN number when buckets are being maintained by TAN.
ACCUMULATED_LINE_AMOUNT NUMBER Maintains the accumulated line amounts of the transactions on which taxable amount is different from line amount.
DOC_ACCUMULATED_TAX_AMOUNT NUMBER Maintain the accumulated tax amounts of the transactions on which document level threshold has applied successfully. This is needed for cancellation flows to retain the total document threshold amount.
TAX_RATE_ID NUMBER 18 Tax rate identifier used when the bucket was last updated.
TAX_RATE_SCHED_ID NUMBER 18 Tax rate schedule identifier used when the bucket was last updated.
RATE_PERCENTAGE NUMBER Tax rate percentage used when the bucket was last updated.
RECALC_REQUIRED_FLAG VARCHAR2 1 Indicates whether recalculation is required to be done.

Indexes

Index Uniqueness Tablespace Columns Status
ZX_BUCKETS_F_N1 Non Unique FUSION_TS_TX_IDX TAX_REGIME_CODE, TAX, TAX_JURISDICTION_CODE, CALENDAR_NAME, PERIOD_NAME, BUCKET_TYPE, FIRST_PARTY_TAX_PROFILE_ID, THIRD_PTY_TAX_PROF_ID, THIRD_PTY_SITE_TAX_PROF_ID, SUPPLIER_ID, TAX_RATE_CODE Active
ZX_BUCKETS_F_N2 Non Unique FUSION_TS_TX_IDX RECALC_REQUIRED_FLAG Active
ZX_BUCKETS_F_U1 Unique FUSION_TS_TX_IDX TAX_BUCKET_ID Active