POZ_SUPP_PMT_ATTR

Details

Schema: FUSION
Object owner: POZ
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
poz_supp_pmt_attr_requests_PK	PMT_ATTRIBUTES_REQUEST_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PMT_ATTRIBUTES_REQUEST_ID	NUMBER		18	Yes	This field is the unique identifier for payment attribute details change
ASSOCIATED_ENTITY	VARCHAR2	25		Yes	Entity associated with this Payment Attribute - values are 'SUPPLIER', 'SITE' or 'ADDRESS'
CHANGED_FLAG	VARCHAR2	1		Yes	Indicates if the row has been modified as part of a change request.
SUPP_REQUEST_ID	NUMBER		18	Yes	This field is the unique identifier for a supplier request
CHANGE_REQ_ROW_TYPE	VARCHAR2	30		Yes	Type of the request. This could either be 'CHANGE' or 'SNAPSHOT'
PARTY_SITE_ID	NUMBER		18		Identifier of the address/party site this Payment Attribute request is for. This will be null for Supplier level payment methods
VENDOR_SITE_ID	NUMBER		18		Unique identifier of a site corresponding to a supplier
DELIVERY_CHANNEL_CODE	VARCHAR2	30			Default delivery channel code
BANK_INSTRUCTION1_CODE	VARCHAR2	30			Code of first bank instruction
BANK_INSTRUCTION2_CODE	VARCHAR2	30			Code of second bank instruction
BANK_INSTRUCTION_DETAILS	VARCHAR2	255			Additional bank instruction details
SETTLEMENT_PRIORITY	VARCHAR2	30			Priority with which the financial institution or payment system settles payments for this payee. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY.
PAYMENT_TEXT_MESSAGE1	VARCHAR2	256			Text message for use in payment processing
PAYMENT_TEXT_MESSAGE2	VARCHAR2	256			Text message for use in payment processing
PAYMENT_TEXT_MESSAGE3	VARCHAR2	256			Text message for use in payment processing
SERVICE_LEVEL_CODE	VARCHAR2	30			Default Service Level Code
BANK_CHARGE_BEARER	VARCHAR2	30			Party that is responsible for paying regular or express bank charges, such as Payee or Payer. Values taken from lookup: IBY_BANK_CHARGE_BEARER
PAYMENT_REASON_CODE	VARCHAR2	30			Payment reason code
PAYMENT_REASON_COMMENTS	VARCHAR2	240			Free text field available for entering a reason for the payment
EXCLUSIVE_PAYMENT_FLAG	VARCHAR2	1			Yes or No flag indicating whether documents payable for this payee should be prevented from being grouped with other like documents payable for payment.
REMIT_ADVICE_DELIVERY_METHOD	VARCHAR2	30			Default delivery method set on the payee level. If the Override with Payee Delivery Method Preference flag on the Payment Process Profile is turned off, the setting here is ignored. Values from the lookup IBY_DELIVERY_METHODS include EMAIL, FAX, and PRINTED.
REMIT_ADVICE_EMAIL	VARCHAR2	255			E-mail address at which the payee wishes to receive remittance advice
REMIT_ADVICE_FAX	VARCHAR2	100			Fax number at which the payee wishes to receive remittance advice
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
poz_supp_pmt_attr_requests_N	Non Unique	Default	SUPP_REQUEST_ID
poz_supp_pmt_attr_requests_PK	Unique	Default	PMT_ATTRIBUTES_REQUEST_ID