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.
BPA_PRINT_REQUESTS_GUID	VARCHAR2	32		Yes	Unique identifier for BFB and 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