PSC_BNP_TRXN_CUST_INV
Links permitting and licensing transaction and receivable invoice.
Details
-
Schema: FUSION
-
Object owner: PSC_CC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
psc_bnp_trxn_cust_inv_PK |
TRXN_CUST_INV_KEY |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRXN_CUST_INV_KEY | NUMBER | 18 | Yes | Unique numeric key for the record. | |
| TRXN_CUST_INV_ID | VARCHAR2 | 50 | Yes | Alpha numeric identifier for the record. | |
| TRXN_CUST_XREF_KEY | NUMBER | 18 | Yes | Cross reference key. | |
| TRXN_CUST_XREF_ID | VARCHAR2 | 50 | Yes | Cross reference id. | |
| AGENCY_ID | NUMBER | 8 | Yes | Unique Identifier of the agency. | |
| CLASSIFICATION | VARCHAR2 | 3 | Yes | Type of offering. | |
| RECORD_TYPE_ID | VARCHAR2 | 50 | Yes | Type of application. | |
| RECORD_KEY | NUMBER | 18 | Yes | Numeric identifier of the record. | |
| RECORD_ID | VARCHAR2 | 50 | Yes | Alpha numeric identifier of the record. | |
| INVOICE_SYSTEM_CD | VARCHAR2 | 30 | Invoice System Code. | ||
| CUST_PARTY_ID | NUMBER | 18 | Party Identifier of the customer. | ||
| CUST_PARTY_NUMBER | VARCHAR2 | 30 | Unique alternate identifier for the party. | ||
| CUST_PARTY_TYPE_CD | VARCHAR2 | 30 | The party type can only be Person or Organization. | ||
| CUST_ACCOUNT_ID | NUMBER | 18 | Unique identifier for the account created for a Party. | ||
| CUST_ACCOUNT_NUMBER | VARCHAR2 | 30 | Number assigned to account created for a Party. | ||
| CUST_ACCOUNT_NAME | VARCHAR2 | 240 | Description chosen by customer (but can be entered internally on behalf on the customer). | ||
| LOCATION_ID | NUMBER | 18 | Unique identifier for this location. | ||
| PARTY_SITE_NAME | VARCHAR2 | 240 | User-defined name for the site. | ||
| CUST_ACCT_SITE_ID | NUMBER | 18 | Identifier for the customer account site. | ||
| CUST_SITE_USE_ID | NUMBER | 18 | Identifier of the site usage. | ||
| SET_NAME | VARCHAR2 | 80 | Identifies a set name of reference data shared across business units and other entities. | ||
| INVOICE | VARCHAR2 | 50 | Invoice Number. | ||
| INVOICE_ID | NUMBER | 18 | Invoice Identifier. | ||
| PREVIOUS_INVOICE_NBR | VARCHAR2 | 50 | Previous invoice. | ||
| PREVIOUS_INVOICE_ID | NUMBER | 18 | Previous invoice id. | ||
| PREVIOUS_INVOICE_LINE | NUMBER | Previous invoice line. | |||
| INVOICE_TYPE_CD | VARCHAR2 | 30 | Invoice type. | ||
| INVOICE_DATE | DATE | Invoice Date. | |||
| INVOICE_AMOUNT | NUMBER | Yes | Invoice amount. | ||
| CURRENCY_CODE | VARCHAR2 | 3 | Currency code. | ||
| PAID_AMOUNT | NUMBER | Paid Amount. | |||
| ADJUSTMENT_AMOUNT | NUMBER | Adjusted amount. | |||
| DISPUTE_AMOUNT | NUMBER | Disputed amount. | |||
| CREDIT_AMOUNT | NUMBER | Credit amount. | |||
| BALANCE_AMOUNT | NUMBER | Balance amount. | |||
| DISCOUNT_AMOUNT | NUMBER | Discount amount. | |||
| INVOICE_STATUS | VARCHAR2 | 30 | Status of the invoice. | ||
| COMPLETE_FLAG | VARCHAR2 | 1 | Indicates invoice record is complete. | ||
| LAST_SYNC_DATE | TIMESTAMP | Last sync datetime. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| TRANSACTION_SOURCE_NAME | VARCHAR2 | 50 | Name of source used to create transaction in receivable application. | ||
| TRANSACTION_SOURCE_ID | NUMBER | 18 | Identifier of source used to create transaction in receivable application. | ||
| TERM_NAME | VARCHAR2 | 15 | Name of terms of payment. | ||
| TERM_ID | NUMBER | 18 | Id of terms of payment. | ||
| DUE_DATE | DATE | Due date of invoice. | |||
| MIGRATED_DATA_FLAG | VARCHAR2 | 3 | Yes | Attribute identifying data migrated from legacy system | |
| TRXN_INV_XREF_PUID | VARCHAR2 | 480 | Yes | Indicates the PUID reference identifier for data migration. | |
| RECORD_NUMBER | VARCHAR2 | 64 | PUID key of Records table | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| psc_bnp_trxn_cust_inv_N1 | Non Unique | psc_bnp_trxn_cust_inv_N1 | RECORD_KEY |
| psc_bnp_trxn_cust_inv_N2 | Non Unique | psc_bnp_trxn_cust_inv_N2 | INVOICE_ID |
| psc_bnp_trxn_cust_inv_U1 | Unique | Default | TRXN_CUST_INV_KEY |
| psc_bnp_trxn_cust_inv_U2 | Unique | Default | CLASSIFICATION, RECORD_TYPE_ID, RECORD_KEY, TRXN_CUST_INV_ID |
| psc_bnp_trxn_cust_inv_U3 | Unique | Default | TRXN_CUST_INV_ID |
| psc_bnp_trxn_cust_inv_U4 | Unique | Default | TRXN_INV_XREF_PUID |