AR_BPA_PRINT_REQUESTS

This is an obsolete table and not in use.

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Columns

Name Datatype Length Precision Not-null Comments
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
BIP_OUTPUT_ID NUMBER 18 Unique identifier of the transaction output from the BIP server.
BIP_OUTPUT_NAME VARCHAR2 256 Name of the transaction output attachment file on the BIP server.
BIP_DOCUMENT_CONTENT_TYPE VARCHAR2 20 Identifies the type of output of the attachment file on the BIP server.
CUSTOMER_TRX_ID NUMBER 18 Unique identifier of the original customer transaction.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Yes Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PAYMENT_SCHEDULE_ID NUMBER 18 Yes Not currently used.
WORKER_ID NUMBER 18 Yes Not currently used.
PRINT_FLAG VARCHAR2 1 Not currently used.
REPORT_TYPE_CODE VARCHAR2 30 Indicates the type of report. Valid values are BFB indicating Balance Forward Bill report and PRT indicating Print Receivables Transaction report.

Foreign Keys

Table Foreign Table Foreign Key Column
AR_BPA_PRINT_REQUESTS ar_payment_schedules_all PAYMENT_SCHEDULE_ID
AR_BPA_PRINT_REQUESTS ra_customer_trx_all CUSTOMER_TRX_ID

Indexes

Index Uniqueness Tablespace Columns
AR_BPA_PRINT_REQUESTS_N1 Non Unique AR_BPA_PRINT_REQUESTS_N1 REQUEST_ID, WORKER_ID