PSC_BNP_RECEIVABLE_OPTIONS

Table stores configure options for various transaction sources.

Details

Schema: FUSION
Object owner: PSC_CC
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
psc_bnp_receivable_option_PK	AGENCY_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
AGENCY_ID	NUMBER		8	Yes	Attribute identifying the agency associated with the row.
TERM_ID	NUMBER		18		TERM_ID
ORG_ID	NUMBER		18		Indicates the identifier of the business unit associated to the row.
INVOICE_SYSTEM	VARCHAR2	20		Yes	Attribute to identify source of invoice.
CUST_TRX_TYPE_ID	NUMBER		18		Attribute to identify Fusion AR transaction type for invoice.
CUST_CM_TRX_TYPE_ID	NUMBER		18		Attribute to identify Fusion AR transaction type for credit memo.
MEMO_LINE_ID	NUMBER		18		Attribute used to indicate memo line to derive revenue account.
PROFILE_CLASS_ID	NUMBER		18		Identifier of the customer profile class.
RECEIVABLE_ACTIVITY_NAME	VARCHAR2	50			Attribute to identify Receivable activity name.
ENABLED_FLAG	VARCHAR2	1		Yes	Indicates whether ERP Receivables integration is enabled.
START_DATE	DATE				Cut-off date for the ESS job to filter the payment records.
ONACCOUNT_RECEIVABLE_ACTIVITY	VARCHAR2	50			Indicates the Receivable Activity Name that is used on receipts created for payments on account.
REFUND_RECEIVABLE_ACTIVITY	VARCHAR2	50			Indicates the Receivable Activity Name that is used on receipts created for refunds.
TRANSACTION_SOURCE_NAME	VARCHAR2	50			Name of the transaction source used to create invoices in receivables.
TRANSACTION_SOURCE_ID	NUMBER		18		Identifier of the transaction source used to create invoices in receivables.
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.
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.
BU_NAME	VARCHAR2	240			Business unit name.
CUST_TRX_TYPE_NAME	VARCHAR2	20			CUSOMER TRANSACTION TYPE NAME.
CUST_CM_TRX_TYPE_NAME	VARCHAR2	20			CUST_CM_TRX_TYPE_NAME.
TERM_NAME	VARCHAR2	15			TERM NAME.
MEMO_LINE_NAME	VARCHAR2	50			MEMO_LINE_NAME.
PROFILE_CLASS_NAME	VARCHAR2	30			PROFILE_CLASS_NAME.
SET_NAME	VARCHAR2	80			SET_NAME.
CUST_DM_TRX_TYPE_ID	NUMBER		18		Identifier of the debit memo transaction type
CUST_DM_TRX_TYPE_NAME	VARCHAR2	20			Name of the debit memo transaction type.
DISP_DUPS_PUB_FLAG	VARCHAR2	1		Yes	Display potential matches for customer when public user submit new billing information.
DISP_THRSHOLD_PUB	NUMBER		3		Display potential matches on or above the threshold.
DUPLICATE_CHECK_OPTION	VARCHAR2	30		Yes	Find potential matches for customer when agency staff submit new billing information.
INVOICE_CE_FLAG	VARCHAR2	1		Yes	Invoice Code Violations Fees when enabled.
INVOICE_LIC_FLAG	VARCHAR2	1		Yes	Invoice Business Licenses Fees when enabled.
INVOICE_PAID_FEE_FLAG	VARCHAR2	1		Yes	Invoice paid fees
INVOICE_PMT_FLAG	VARCHAR2	1		Yes	Invoice Permit Fees when enabled.
INVOICE_PNZ_FLAG	VARCHAR2	1		Yes	Invoice Planning and Zoning Fees when enabled.
BATCH_SOURCE_NAME	VARCHAR2	50			Displays batch source name.
BATCH_SOURCE_ID	NUMBER		18		Displays batch source identifier.

Indexes

Index	Uniqueness	Tablespace	Columns
PSC_BNP_RECEIVABLE_OPTIONS_U1	Unique	Default	AGENCY_ID