Batch Refund

BatchRefund

The BatchRefund usage is used to define the export structure for refund transaction files generated from Batch Refunds.

Data Element	Description
AccountingDate	The accounting date associated with the refund transaction.
AddressLine1	The first line of the subscriber or vendor address.
AddressLine2	The second line of the subscriber or vendor address.
AddressLine3	The third line of the subscriber or vendor address.
AddressLine4	The fourth line of the subscriber or vendor address.
AddressLine5	The fifth line of the subscriber or vendor address.
AddressLine6	The sixth line of the subscriber or vendor address.
APCompany	The Accounts Payable company associated with the transaction.
AreaCode	The telephone area code.
BusinessUnit	The business unit associated with the transaction.
CarrierID	The carrier identifier associated with the subscription.
Category	The category associated with the transaction or subscriber.
CityID	The city identifier associated with the address.
ClearingAccount	The clearing account used for the transaction.
ComboSubscriptionId	The identifier for a combo subscription.
CountryID	The country identifier associated with the address.
CurrentDate	The current system date at the time of export.
CycleEndDate	The end date of the subscription cycle.
Description	The description associated with the transaction.
DueDate	The due date of the transaction.
DueDate2	An additional due date field for extended processing requirements.
Filler	A blank or constant value used for spacing or formatting.
FirstName	The first name of the subscriber or vendor.
FiscalPeriod	The fiscal period associated with the transaction.
FiscalYear	The fiscal year associated with the transaction.
GLAccount	The general ledger account number.
GLCompanyID	The general ledger company identifier.
GLDepartment	The general ledger department identifier.
HonorificID	The honorific or title identifier (for example, Mr, Ms).
IntSubscriberId	The internal subscriber identifier.
InvoiceDate	The invoice date associated with the transaction.
Invoicenumber	The invoice number associated with the transaction.
LastName	The last name of the subscriber or vendor.
LiabilityAccount	The liability account used for the transaction.
LineFeed	Inserts a line break in the export file.
LiteralValue	A constant or user-defined literal value.
MiddleInitial	The middle initial of the subscriber or vendor.
OccupantSalutationID	The salutation associated with the occupant.
Phone	The telephone number of the subscriber or vendor.
ProductID	The product identifier associated with the subscription.
ProfitCenter	The profit centre associated with the transaction.
Project	The project identifier associated with the transaction.
PublicationName	The name of the publication.
RecordCount	The total number of records in the export.
RefundAmount	The refund amount for the transaction.
RefundEntryDate	The date the refund was entered.
RouteType	The route type associated with delivery.
RowCount	The number of rows processed in the export.
SequenceNumber	A sequential number assigned to each record.
StateID	The state identifier associated with the address.
SubscriberId	The subscriber identifier.
TaxId	The tax identifier associated with the subscriber or vendor.
TermsCode	The payment terms code.
TotalAmount	The total amount for the transaction batch.
VendorCompanyID	The vendor company identifier.
VendorID	The vendor identifier.
VendorName	The vendor name.
ZipCode	The postal or ZIP code.
ZipExtension	The ZIP/postal extension.

---

BatchVendRef

The BatchVendRef usage is used to define the export structure for vendor-related refund files generated from Batch Refunds.

Data Element	Description
AddressLine1	The first line of the vendor address.
AddressLine2	The second line of the vendor address.
AddressLine3	The third line of the vendor address.
AddressLine4	The fourth line of the vendor address.
AddressLine5	The fifth line of the vendor address.
AddressLine6	The sixth line of the vendor address.
AreaCode	The telephone area code.
CarrierID	The carrier identifier associated with the subscription.
CityID	The city identifier associated with the address.
CountryID	The country identifier associated with the address.
Filler	A blank or constant value used for spacing or formatting.
FirstName	The first name of the vendor or contact.
HonorificID	The honorific or title identifier.
InvoiceDate	The invoice date associated with the transaction.
LastName	The last name of the vendor or contact.
LineFeed	Inserts a line break in the export file.
LiteralValue	A constant or user-defined literal value.
MiddleInitial	The middle initial of the vendor or contact.
OccupantEmail	The email address associated with the occupant or vendor.
PayMethod	The payment method associated with the refund.
Phone	The telephone number of the vendor or contact.
PhoneExtension	The telephone extension.
RefundEntryDate	The date the refund was entered.
StateID	The state identifier associated with the address.
VDRPersistc	Indicates vendor persistence or vendor-specific flag.
VendorCompanyID	The vendor company identifier.
VendorID	The vendor identifier.
ZipCode	The postal or ZIP code.
ZipExtension	The ZIP/postal extension.

---

RefundTotExport

The RefundTotExport usage is used to define the export structure for totals (.TOT) files generated from Batch Refunds.

Data Element	Description
FileAmount	The total amount contained in the export file.
Filler	A blank or constant value used for spacing or formatting.
LineFeed	Inserts a line break in the export file.
LiteralValue	A constant or user-defined literal value.
RecordCount	The total number of records in the export file.
TodayDate	The current system date at the time of export.