AR_BPA_PRINT_REQUESTS

Details

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.

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

Index	Uniqueness	Tablespace	Columns
AR_BPA_PRINT_REQUESTS_N1	Non Unique	AR_BPA_PRINT_REQUESTS_N1	REQUEST_ID, WORKER_ID