1. Tables and Views for Financials
  2. ZX_REGISTRATIONS_STG

ZX_REGISTRATIONS_STG

This table stores tax registration details that need to be imported into tax registrations table.

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments Status
BATCH_NAME VARCHAR2 30 Yes Batch name to identify the set of records to be processed Active
PARTY_NUMBER VARCHAR2 240 Yes Party number used to identify the party Active
PARTY_NAME VARCHAR2 240 Party name used to identify the party Active
PARTY_TYPE_CODE VARCHAR2 30 Yes Party type code associated with the record such as THIRD_PARTY,etc. Active
REGISTRATION_TYPE_CODE VARCHAR2 30 Lookup code for registration type. System uses this in tax registration number validation and reporting based on the type, where applicable. Active
REGISTRATION_NUMBER VARCHAR2 50 Column to store tax registration number. System validates the number according to tax authority validation rules, where applicable. Active
ROUNDING_RULE_CODE VARCHAR2 30 Rounding rule code to be used for rounding taxes of this regime. Possible values are UP, DOWN and NEAREST. Rounding rule is the method to use to round off taxes to the minimum accountable unit. Active
TAX_JURISDICTION_CODE VARCHAR2 30 Tax jurisdiction code of the tax registration record. Active
REGISTRATION_STATUS_CODE VARCHAR2 30 Lookup code for party registration status. System uses tax registration status as a determining factor in tax rules. Active
REGISTRATION_SOURCE_CODE VARCHAR2 30 Stores registration source code and used to distinguish between formal registration numbers from logical tax registrations. Logical tax registrations do not have a formal number assigned to it but indicate that the party is considered to meet one or more requirements for reports. Active
REGISTRATION_REASON_CODE VARCHAR2 30 Reason for the registration such as minimum presence or revenue threshold. Active
TAX_CODE VARCHAR2 30 Tax for the registration record. Active
TAX_REGIME_CODE VARCHAR2 30 Tax regime code for the registration. Active
INCLUSIVE_TAX_FLAG VARCHAR2 1 Y or N indicates whether the tax of this registration is inclusive. Active
EFFECTIVE_FROM DATE Yes Date from which the tax registration record is effective Active
EFFECTIVE_TO DATE Date until which the tax registration record is effective. Active
DEFAULT_REGISTRATION_FLAG VARCHAR2 1 Y or N indicates whether this is the default registration for the party. The tax registration number associated with this registration is used as the default tax registration number on all tax reports. Active
LEGAL_LOCATION_CODE VARCHAR2 60 Location name for Location identifier for the legal registration address Active
ADDRESS_LINE_1 VARCHAR2 240 First line of location address for Location identifier for the legal registration address Active
TOWN_OR_CITY VARCHAR2 30 Town or city for Location identifier for the legal registration address Active
REGION_1 VARCHAR2 120 County (US, UK); Province (CA) for Location identifier for the legal registration address. Active
TAX_AUTHORITY_NAME VARCHAR2 360 Name of tax authority as seen in hz_parties Active
RECORD_STATUS NUMBER Gives the validation status of the record being processed: NULL - only these records will be picked up for processing by program 0 - record picked up by concurrent program for validation 1 -all id???s validated 2 - successful record 3 - error record Active
LOAD_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. Active
LOAD_STATUS VARCHAR2 30 Enterprise Service Scheduler: indicates the request status of the interface load job that created the row. 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 Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP 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
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

Indexes

Index Uniqueness Tablespace Columns Status
ZX_REGISTRATIONS_STG_N1 Non Unique FUSION_TS_TX_IDX PARTY_NAME, PARTY_TYPE_CODE, PARTY_NUMBER Active