1. Tables and Views for Financials
  2. EXM_CC_COMPANY_ACCOUNTS

EXM_CC_COMPANY_ACCOUNTS

This table contains the business units that are responsible for payment to the card issuer, payment liability, payment terms, and the card issuer's payment address for a corporate card program.

Details

  • Schema: FUSION

  • Object owner: EXM

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

EXM_CC_COMPANY_ACCOUNTS_PK

CC_COMPANY_ACCOUNT_ID

Columns

Name Datatype Length Precision Not-null Comments
CC_COMPANY_ACCOUNT_ID NUMBER 18 Yes Unique identifier of a company account number.
COMPANY_ACCOUNT_NAME VARCHAR2 80 Yes User-defined name representing a division, department, or cost center that issues corporate cards to its employees.
PAYMENT_TERM_ID NUMBER 18 Identifier of the payment term used for reimbursing the corporate card issuer.
CARD_PROGRAM_ID NUMBER 18 Yes Identifier of the corporate card program associated with the company account number.
COMPANY_NUMBER VARCHAR2 30 Corporate account numbers assigned by the corporate card issuer to the deploying company or its business unit.
CARD_ISSUER_NUMBER VARCHAR2 30 Number assigned by the payment processor that identifies a card issuer in the payment processor's system.
CARD_ISSUER_ID NUMBER 18 Name of the bank or entity that issues corporate credit cards.
CARD_ISSUER_SITE_ID NUMBER 18 Geographical address of the corporate card issuer.
INACTIVE_DATE DATE Date from which the company account cannot be used.
CORPORATE_CARD_ADMIN NUMBER 18 User who is authorized to maintain a corporate card program.
REQUISITION_BU NUMBER 18 Business unit responsible for handling invoices for the corporate card issuer.
PAYMENT_CURRENCY_CODE VARCHAR2 15 Currency in which the corporate card issuer must be paid.
PAYMENT_DUE_FROM_CODE VARCHAR2 30 Denotes the liability owner of the company account.
EXPENSE_CLEARING_CCID NUMBER 18 Account that holds accounting for corporate card transactions temporarily.
OVERLAY_BALANCING_SEG_FLAG VARCHAR2 1 Indicator of whether the balancing segment substitutes onto the clearing account's balancing segment from the employee's default expense account.
INCL_PERSONAL_EXPENSE_FLAG VARCHAR2 1 Indicator of whether it is mandatory to include personal expenses in the expense report.
BILLING_CNTL_ACCT_NUMBER VARCHAR2 30 Number that identifies the party responsible for payment within the deploying company.
MARKET_CODE VARCHAR2 30 Code issued by the card issuer that identifies the market in which the deploying company operates.
INTERBANK_CARDASSOC_NUMBER VARCHAR2 30 Unique number assigned by the processor to bank issuing corporate cards.
TAXPAYER_ID VARCHAR2 120 The supplier tax identifier issued by federal tax authorities.
TAX_REGISTRATION_NUMBER VARCHAR2 50 The supplier tax identifier for a specific tax registration.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
REAL_TIME_AUTH_STATUS_CODE VARCHAR2 30 Stores the synchronization status of real-time authorization setup data for the company account.
REAL_TIME_AUTH_SYNC_DATE TIMESTAMP Date and time of when the synchronization of real-time authorization setup data was last successful for the company account.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created 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.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
BOOK_NUMBER VARCHAR2 30 Book number used in American Express remittance advice.
LOAD_NUMBER VARCHAR2 30 Load number or sender identifier used in American Express remittance advice.
PAY_GROUP_CODE VARCHAR2 25 Code stamped on the payment requests to group card issuer payments in a single pay run.
CARD_ISSUER_COUNTRY NUMBER 9 Country of the registered address of a card issuer for a specific company account that is used in remittance advice
BILLING_BASIC_CTRL_ACCT_NUM VARCHAR2 30 An account number provided by the card issuer in the charge file that represents the organization that is billed by American Express.
CARD_DISGUISE_CTRL_ACCT_NUM VARCHAR2 30 An account number assigned to a company by American Express that represents the organizational level at which the company is enrolled in the Card Number Disguising program.
MULTI_CURRENCY_ENABLED VARCHAR2 1 Indicates whether multiple billed currencies are supported by the company account. Possible values are Y or N.
REAL_TIME_AUTH_ENABLED_FLAG VARCHAR2 1 Indicates whether real time authorization data creation is enabled for this company account.
CARD_ISSUING_BANK_NUMBER VARCHAR2 50 Transmit number assigned to the bank that issues cards associated with the company account. The transmit number is used in remittance advice.
CARD_PROCESSOR_BANK_NUMBER VARCHAR2 50 Bank identification number assigned by the card processor to the bank that issues cards associated with the company account. The corporate cards are issued under this identification number. Bank identification number is used in remittance advice.

Foreign Keys

Table Foreign Table Foreign Key Column
EXM_CC_COMPANY_ACCOUNTS exm_card_programs CARD_PROGRAM_ID
EXM_CC_COMPANY_ACCOUNTS per_persons CORPORATE_CARD_ADMIN
EXM_CC_COMPANY_ACCOUNTS gl_code_combinations EXPENSE_CLEARING_CCID
EXM_CC_COMPANY_ACCOUNTS ap_terms_b PAYMENT_TERM_ID
exm_cards exm_cc_company_accounts COMPANY_ACCOUNT_ID
exm_cc_download_params exm_cc_company_accounts COMPANY_ACCOUNT_ID
exm_credit_card_trxns exm_cc_company_accounts COMPANY_ACCOUNT_ID
exm_cc_acceptors exm_cc_company_accounts COMPANY_ACCOUNT_ID
exm_cc_outstnd_trxn_sum exm_cc_company_accounts COMPANY_ACCOUNT_ID
exm_cc_upload_rules exm_cc_company_accounts COMPANY_ACCOUNT_ID

Indexes

Index Uniqueness Tablespace Columns
EXM_CC_COMPANY_ACCOUNTS_N1 Non Unique Default UPPER("COMPANY_NUMBER")
EXM_CC_COMPANY_ACCOUNTS_PK Unique Default CC_COMPANY_ACCOUNT_ID
EXM_CC_COMPANY_ACCOUNTS_U2 Unique Default COMPANY_ACCOUNT_NAME