SUB1006 - BPA Galley Export Report

When the BPA circulation statement is generated, there is an electronic export file, called the Qualified Galley, that must be submitted to BPA. BPA900 selects records to be processed from Sub_Issue_Fulfillment and Sub_Audit_Stats so that individual paragraph reports can be generated.  As part of running BPA900, a data file is generated as one of the outputs. This Data Analyzer query report has an export file layout and has the same fields as in the BPA900 galley export file .

Parameters

Selection Logic

Select order and fulfillment information

From Sub_Issue_Fulfillment sif,

Sub_Audit_Stats sas,

Customer c

Where sif.ORG_ID = ORG_ID of user running report

And sif.ORG_UNIT_ID = ORG_UNIT_ID of user running report

And sif.SUB_ISSUE_FULFILLMENT_ID = sas.SUB_ISSUE_FULFILLMENT_ID

And sif.MASTER_CUSTOMER_ID = c.MASTER_CUSTOMER_ID

And sif.SUB_CUSTOMER_ID = c.SUB_CUSTOMER_ID

And sif.PRODUCT_ID = p.PRODUCT_ID

And sif.PARENT_PRODUCT = @ParentProduct parameter

And sif.PRODUCT_CODE = @ProductCode parameter

And sif.ISSUE_DATE <= @IssueEndDate parameter

And sif.ISSUE_DATE >= @IssueBeginDate parameter

Fields in Export File