ZX_PARTY_TAX_PROFILE_STG

This table stores party tax profile details that need to be imported into party tax profile 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
ROUNDING_LEVEL_CODE	VARCHAR2	30			Rounding level code to be used for rounding of taxes calculated for a party tax profile.	Active
ROUNDING_RULE_CODE	VARCHAR2	30			Rounding rule code to be used for rounding taxes. Possible values are UP, DOWN and NEAREST.	Active
TAX_CLASSIFICATION_CODE	VARCHAR2	30			Default tax classification code for this party tax profile	Active
SUPPLIER_FLAG	VARCHAR2	1			Y or N indicates whether this party tax profile is for a third party supplier	Active
CUSTOMER_FLAG	VARCHAR2	1			Y or N indicates whether this party tax profile is for a third party customer	Active
PROCESS_FOR_APPLICABILITY_FLAG	VARCHAR2	1			Flag to indicates whether taxes should be automatically calculated for this party tax profile.	Active
INCLUSIVE_TAX_FLAG	VARCHAR2	1			Flag to indicate whether transaction line amounts include tax amount for this party tax profile. This column is applicable for only suppliers.	Active
ALLOW_OFFSET_TAX_FLAG	VARCHAR2	1			Allow offset taxes for this party tax profile.	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 validated 2 - successful record 3 - error record	Active
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.	Active
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or 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
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
TRANSPORT_PRVDR_FLAG	VARCHAR2	1			Indicates whether the party is a transportation provider such as freight carrier.
COUNTRY_CODE	VARCHAR2	2			Country code used to validate the tax registration number for this party tax profile.
REGISTRATION_TYPE_CODE	VARCHAR2	30			Lookup code to indicate registration type.
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.
TAX_GROSS_NET_FLAG	VARCHAR2	1			Transaction tax applicability on the gross or net amount indicator.
WHT_GROSS_NET_FLAG	VARCHAR2	1			Withholding tax applicability on the gross or net amount indicator.

Indexes

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