VIEW: ZX.ZX_REGISTRATIONS#

Source

View Text - Preformatted

select REGISTRATION_TYPE_CODE REGISTRATION_TYPE_CODE, REGISTRATION_NUMBER REGISTRATION_NUMBER, VALIDATION_RULE VALIDATION_RULE, ROUNDING_RULE_CODE ROUNDING_RULE_CODE, TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE, SELF_ASSESS_FLAG SELF_ASSESS_FLAG, REGISTRATION_STATUS_CODE REGISTRATION_STATUS_CODE, REGISTRATION_SOURCE_CODE REGISTRATION_SOURCE_CODE, REGISTRATION_REASON_CODE REGISTRATION_REASON_CODE, TAX TAX, TAX_REGIME_CODE TAX_REGIME_CODE, INCLUSIVE_TAX_FLAG INCLUSIVE_TAX_FLAG, HAS_TAX_EXEMPTIONS_FLAG HAS_TAX_EXEMPTIONS_FLAG, EFFECTIVE_FROM EFFECTIVE_FROM, EFFECTIVE_TO EFFECTIVE_TO, REP_PARTY_TAX_NAME REP_PARTY_TAX_NAME, DEFAULT_REGISTRATION_FLAG DEFAULT_REGISTRATION_FLAG, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM, LEGAL_LOCATION_ID LEGAL_LOCATION_ID, RECORD_TYPE_CODE RECORD_TYPE_CODE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, REGISTRATION_ID REGISTRATION_ID, TAX_AUTHORITY_ID TAX_AUTHORITY_ID, REP_TAX_AUTHORITY_ID REP_TAX_AUTHORITY_ID, COLL_TAX_AUTHORITY_ID COLL_TAX_AUTHORITY_ID, PARTY_TAX_PROFILE_ID PARTY_TAX_PROFILE_ID, LEGAL_REGISTRATION_ID LEGAL_REGISTRATION_ID, BANK_ID BANK_ID, BANK_BRANCH_ID BANK_BRANCH_ID, ACCOUNT_ID ACCOUNT_ID, ACCOUNT_SITE_ID ACCOUNT_SITE_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ROUNDING_LEVEL_CODE ROUNDING_LEVEL_CODE, ACCOUNT_TYPE_CODE ACCOUNT_TYPE_CODE, MERGED_TO_REGISTRATION_ID MERGED_TO_REGISTRATION_ID from "ZX"."ZX_REGISTRATIONS"

View Text - HTML Formatted

SELECT REGISTRATION_TYPE_CODE REGISTRATION_TYPE_CODE
, REGISTRATION_NUMBER REGISTRATION_NUMBER
, VALIDATION_RULE VALIDATION_RULE
, ROUNDING_RULE_CODE ROUNDING_RULE_CODE
, TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE
, SELF_ASSESS_FLAG SELF_ASSESS_FLAG
, REGISTRATION_STATUS_CODE REGISTRATION_STATUS_CODE
, REGISTRATION_SOURCE_CODE REGISTRATION_SOURCE_CODE
, REGISTRATION_REASON_CODE REGISTRATION_REASON_CODE
, TAX TAX
, TAX_REGIME_CODE TAX_REGIME_CODE
, INCLUSIVE_TAX_FLAG INCLUSIVE_TAX_FLAG
, HAS_TAX_EXEMPTIONS_FLAG HAS_TAX_EXEMPTIONS_FLAG
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_TO EFFECTIVE_TO
, REP_PARTY_TAX_NAME REP_PARTY_TAX_NAME
, DEFAULT_REGISTRATION_FLAG DEFAULT_REGISTRATION_FLAG
, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, LEGAL_LOCATION_ID LEGAL_LOCATION_ID
, RECORD_TYPE_CODE RECORD_TYPE_CODE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, REGISTRATION_ID REGISTRATION_ID
, TAX_AUTHORITY_ID TAX_AUTHORITY_ID
, REP_TAX_AUTHORITY_ID REP_TAX_AUTHORITY_ID
, COLL_TAX_AUTHORITY_ID COLL_TAX_AUTHORITY_ID
, PARTY_TAX_PROFILE_ID PARTY_TAX_PROFILE_ID
, LEGAL_REGISTRATION_ID LEGAL_REGISTRATION_ID
, BANK_ID BANK_ID
, BANK_BRANCH_ID BANK_BRANCH_ID
, ACCOUNT_ID ACCOUNT_ID
, ACCOUNT_SITE_ID ACCOUNT_SITE_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ROUNDING_LEVEL_CODE ROUNDING_LEVEL_CODE
, ACCOUNT_TYPE_CODE ACCOUNT_TYPE_CODE
, MERGED_TO_REGISTRATION_ID MERGED_TO_REGISTRATION_ID
FROM "ZX"."ZX_REGISTRATIONS"