1. Tables and Views
  2. PSC_BNP_FAR_INVOICE_INT

PSC_BNP_FAR_INVOICE_INT

This table is used to stage the data for importing billable invoice.

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

psc_bnp_far_invoice_int_PK

AGENCY_ID, INVOICE, INVOICE_LINE, BILL_TYPE

Columns

Name Datatype Length Precision Not-null Comments Status
PSC_BNP_REF_KEY VARCHAR2 240 PSC_BNP_REF_KEY
AGENCY_ID NUMBER 8 Yes Attribute identifying the agency associated with the row. Active
INVOICE VARCHAR2 50 Yes Unique invoice value generated using Auto Number Rule configured for the bill type for this transaction. RULE_ID is derived from BNP_BILL_TYPE table. Active
PARTY_ID NUMBER 18 Attribute Used to derive party information for a Person, Group or Organization Passed from source application. Active
PROFILE_ID NUMBER 18 Attribute used to derive cashier id information if payment is made through a cashier.
PREFERRED_CONTACT_PERSON_ID NUMBER 18 Person PARTY_ID of a preferred contact for a given party. Use to derive PARTY_ID from table PBL_PARTY_CONTACT_POINTS in order to derive contact name from PBL_PERSON_PROFILE table Passed from source application. Active
PREFERRED_CONTACT_METHOD VARCHAR2 30 How a person prefers to be contacted. Passed from source application. Active
SOURCE_TRANSACTION_KEY NUMBER 18 ID for source transaction; Passed from source application. Active
TRANSACTION_ORIGIN VARCHAR2 30 Attribute used to indicate Where a transaction originated. Passed from source application. Active
CURRENCY_CODE VARCHAR2 3 Attribute used to indicate the currency used for this transaction. Passed from source application. Active
BILL_TYPE VARCHAR2 15 Yes Used to default invoice values for invoice form and invoice number id. Passed from source application. Active
PAYMENT_METHOD_CODE VARCHAR2 30 Attribute used to indicate the payment method. Active
BANK_CODE VARCHAR2 30 Attribute used to indicate the remit To bank for the organizaton Active
BANK_ACCT_KEY VARCHAR2 30 Attribute used to indicate the remit To bank type of account Active
PERSON_NAME VARCHAR2 450 Attribute used to indicate the applicant or customer name Active
FIRST_NAME VARCHAR2 150 Attribute used to indicate the applicant or customer first name Active
MIDDLE_NAME VARCHAR2 60 Attribute used to indicate the applicant or customer middle name Active
LAST_NAME VARCHAR2 150 Attribute used to indicate the applicant or customer last name Active
NAME_SUFFIX VARCHAR2 30 Attribute used to indicate the applicant or customer name suffix Active
ADDRESS1 VARCHAR2 240 Attribute used for applicant or customer address line 1 Active
ADDRESS2 VARCHAR2 240 Attribute used for applicant or customer address line 2 Active
ADDRESS3 VARCHAR2 240 Attribute used for applicant or customer address line 3 Active
ADDRESS4 VARCHAR2 240 Attribute used for applicant or customer address line 4 Active
CITY VARCHAR2 60 Attribute used for applicant or customer city Active
POSTAL_CODE VARCHAR2 60 Attribute used for applicant or customer postal code Active
POSTAL_PLUS4_CODE VARCHAR2 10 Attribute used for applicant or customer postal plus4 code Active
STATE VARCHAR2 60 Attribute used for applicant or customer state Active
PROVINCE VARCHAR2 60 Attribute used for applicant or customer province Active
COUNTY VARCHAR2 60 Attribute used for applicant or customer county Active
COUNTRY VARCHAR2 3 Attribute used for applicant or customer country Active
LOCATION_ID NUMBER 18 Yes Attribute used to derive PARTY address information. Derive from PBL_PARTY_LOCATION_USE using PARTY_ID Active
INVOICE_TYPE VARCHAR2 30 Attribute used to indicate the type of invoice. Active
ORIGINAL_INVOICE VARCHAR2 50 Attribute used to track adjustments to the invoice Active
PRIOR_ADJ_INVOICE VARCHAR2 50 Attribute used to track adjustments to the invoice Active
NEXT_ADJ_INVOICE VARCHAR2 50 Attribute used to track adjustments to the invoice Active
LATEST_INVOICE VARCHAR2 50 Attribute used to track adjustments to the invoice Active
INVOICE_AMOUNT NUMBER Attibute used to store the sum of all invoice line amounts Active
INVOICE_DATE DATE Attribute used to store the invoice date Active
ACCOUNTING_DATE DATE Attribute used to store the accounting date Active
DUE_DATE DATE Attribute used to store the date payment is due Active
INVOICE_FORM_ID VARCHAR2 20 Attribute used to derived from BNP_BILL_TYPE what invoice form layout to print. Active
BILL_TO_MEDIA VARCHAR2 20 Attribute used to indicate the bill to media Active
EMAIL_ADDRESS VARCHAR2 320 Attribute used to store the applicant or customer email address Active
DESCRIPTION VARCHAR2 50 Yes Atribute used to describe the invoice.
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
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes 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
TERM_ID NUMBER 18 TERM_ID
BILL_STATUS VARCHAR2 30 BILL_STATUS
PAYMENT_STATUS VARCHAR2 30 PAYMENT_STATUS
BILLABLE VARCHAR2 1 BILLABLE
INVOICE_SYSTEM VARCHAR2 30 INVOICE_SYSTEM
BALANCE_AMOUNT NUMBER BALANCE_AMOUNT
INVOICE_STATUS VARCHAR2 30 INVOICE_STATUS
BILL_TO_CUSTOMER_ID NUMBER 18 BILL_TO_CUSTOMER_ID
BILL_TO_ADDRESS_ID NUMBER 18 BILL_TO_ADDRESS_ID
BILL_TO_CONTACT_ID NUMBER 18 BILL_TO_CONTACT_ID
BILL_TO_SITE_USE_ID NUMBER 18 BILL_TO_SITE_USE_ID
ORG_ID NUMBER 18 Indicates the identifier of the business unit associated to the row.
CUSTOMER_TRX_ID NUMBER 18 CUSTOMER_TRX_ID
CUST_TRX_TYPE_ID NUMBER 18 CUST_TRX_TYPE_ID
BUSINESS_ENTITY_ID VARCHAR2 50 BUSINESS_ENTITY_ID
BUS_BUSINESS_NAME VARCHAR2 100 BUS_BUSINESS_NAME
BUS_DBA_BUSINESS_NAME VARCHAR2 100 BUS_DBA_BUSINESS_NAME
BUSINESS_ENTITY_PARTY_ID NUMBER 18 BUSINESS_ENTITY_PARTY_ID
BUSINESS_LOCATION_PARTY_ID NUMBER 18 BUSINESS_LOCATION_PARTY_ID
BUSINESS_PROFILE_ID NUMBER 18 BUSINESS_PROFILE_ID
OWNER_ADDRESS1 VARCHAR2 240 OWNER_ADDRESS1
OWNER_ADDRESS2 VARCHAR2 240 OWNER_ADDRESS2
OWNER_ADDRESS3 VARCHAR2 240 OWNER_ADDRESS3
OWNER_ADDRESS4 VARCHAR2 240 OWNER_ADDRESS4
OWNER_CITY VARCHAR2 60 OWNER_CITY
OWNER_POSTAL_CODE VARCHAR2 60 OWNER_POSTAL_CODE
OWNER_POSTAL_PLUS4_CODE VARCHAR2 10 OWNER_POSTAL_PLUS4_CODE
OWNER_STATE VARCHAR2 60 OWNER_STATE
OWNER_PROVINCE VARCHAR2 60 OWNER_PROVINCE
OWNER_COUNTY VARCHAR2 60 OWNER_COUNTY
OWNER_COUNTRY VARCHAR2 3 OWNER_COUNTRY
INVOICE_LINE NUMBER 18 Yes Attribute used to store the invoice line number Active
ORIGINAL_LINE NUMBER 18 Attribute used to track adjustments to the invoice line Active
NEXT_ADJ_LINE NUMBER 3 Attribute used to track adjustments to the invoice line Active
PRIOR_ADJ_LINE NUMBER 3 Attribute used to track adjustments to the invoice line Active
LATEST_LINE NUMBER 3 Attribute used to track adjustments to the invoice line Active
QUANTITY NUMBER Attribute used to store the unit quantity Active
PRICE NUMBER Attribute used to store the fee amount or unit price Active
INVOICE_LINE_AMOUNT NUMBER Attribute used to store the (quantity x price) + discount - surcharge Active
DISCOUNT_AMOUNT NUMBER Attribute used to reduce the amount paid. Passed from source application. Active
SURCHARGE_AMOUNT NUMBER Attribute used to increase the amount paid. Passed from source application. Active
APPLICATION_REFERENCE_ID1 VARCHAR2 50 Identifying information/key from the application source.
APPLICATION_REFERENCE_ID2 VARCHAR2 50 Additional identifying information/key from the source application.
FEE_ITEM_ID VARCHAR2 30 FEE_ITEM_ID
DEPARTMENT_ID VARCHAR2 30 DEPARTMENT_ID
RECORD_ID VARCHAR2 50 RECORD_ID
CUSTOMER_TRX_LINE_ID NUMBER 18 CUSTOMER_TRX_LINE_ID
ISSUE_DATE TIMESTAMP ISSUE_DATE
EXPIRATION_DATE TIMESTAMP EXPIRATION_DATE
RENEWAL_DATE TIMESTAMP RENEWAL_DATE
CLASSIFICATION VARCHAR2 3 CLASSIFICATION
RECORD_TYPE VARCHAR2 30 RECORD_TYPE
MEMO_LINE_ID NUMBER 18 Indicates Memo Line identifier on an invoice line in Fusion Receivables
LOAD_REQUEST_ID NUMBER 18 LOAD_REQUEST_ID
PROCESS_FLAG VARCHAR2 1 PROCESS_FLAG
ROW_PROCESSED VARCHAR2 20 ROW_PROCESSED
BATCH_ID NUMBER 18 BATCH_ID
PAYMENT_TERM_NAME VARCHAR2 20 To derive payment term name using term id
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
BU_NAME VARCHAR2 240 Business unit name.
CUST_TRX_TYPE_NAME VARCHAR2 20 CUSOMER TRANSACTION TYPE NAME.
TERM_NAME VARCHAR2 15 TERM NAME.
MEMO_LINE_NAME VARCHAR2 50 MEMO_LINE_NAME.
PROFILE_CLASS_NAME VARCHAR2 30 PROFILE_CLASS_NAME.
LICENSE_PERIOD VARCHAR2 100 The period that applies to the transaction.
CREATED_FOR VARCHAR2 30 Indicates the phase when the fees were created.
INVOICE_CREATED_BY VARCHAR2 20 Indicates if the row was created by Realtime or ESS Job.
RT_INVOICE_LINE_NUMBER NUMBER 18 Store the invoice line number created by Real Time invoicing process.
TRX_NUMBER VARCHAR2 50 Invoice Number.
INVOICE_REQUEST_STATUS VARCHAR2 30 The request status when generating an invoice.
FEE_STATUS VARCHAR2 6 This column is used to indicate fee status.
PREVIOUS_INVOICE_NBR VARCHAR2 50 PREVIOUS_INVOICE_NBR.
PREVIOUS_INVOICE_ID NUMBER 18 Unique identifier of the billing header associated with previous bill.
PREVIOUS_INVOICE_LINE NUMBER 18 Unique identifier of the billing line associated with previous bill.
SET_NAME VARCHAR2 80 Identifies a set name of reference data shared across business units and other entities.
CUST_PARTY_TYPE_CD VARCHAR2 30 The party type can only be Person or Organization.
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).
CUST_PARTY_NUMBER VARCHAR2 30 Unique alternate identifier for the party.
PARTY_SITE_NAME VARCHAR2 240 User-defined name for the site.
TRXN_CUST_XREF_KEY NUMBER 18 Unique numeric key for the record.
TRXN_CUST_XREF_ID VARCHAR2 50 Unique alpha numeric reference for the record.
STATUS_TRX VARCHAR2 30 Transaction Status
COMPLETE_FLAG VARCHAR2 1 Complete Flag state
TRANSACTION_SOURCE_NAME VARCHAR2 50 Transaction Source Name
TRANSACTION_SOURCE_ID NUMBER 18 Transaction Source Id

Indexes

Index Uniqueness Tablespace Columns
psc_bnp_far_invoice_int_U1 Unique Default AGENCY_ID, INVOICE, INVOICE_LINE, BILL_TYPE