1. Tables and Views
  2. PSC_BNP_BILL_HEADER

PSC_BNP_BILL_HEADER

This table contains invoice information specific to all lines for an invoice.

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PSC_BNP_BILL_HEADER_PK

AGENCY_ID, INVOICE, BILL_TYPE

Columns

Name Datatype Length Precision Not-null Comments Status
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
PARTY_TYPE VARCHAR2 30 Yes PARTY_TYPE - Organization or Person

Foreign Keys

Table Foreign Table Foreign Key Column
PSC_BNP_BILL_HEADER psc_bnp_bill_type_b AGENCY_ID, BILL_TYPE
psc_bnp_bill_line psc_bnp_bill_header AGENCY_ID, INVOICE, BILL_TYPE
psc_bnp_checkout_lin psc_bnp_bill_header BILL_AGENCY_ID, INVOICE, BILL_TYPE
psc_bnp_payment_hist_lin psc_bnp_bill_header BILL_AGENCY_ID, INVOICE, BILL_TYPE

Indexes

Index Uniqueness Tablespace Columns Status
PSC_BNP_BILL_HEADER_PK Unique Default AGENCY_ID, INVOICE, BILL_TYPE Active