Returns Journal

The following table lists the data elements available for the “ReturnsJournal” File Map usage. Some of the data elements are valid only for certain types of draw adjustments (route, single copy, or TM), and the table shows which elements are valid for each. When a data element is exported for a table that does not use that field, a blank will be exported instead of a value.

Data Element	Route	Single Copy	TM
ProductID*	X	X	X
RouteID*	X	X	X
DrawDate	X	X	X
DrawClassID		X
SequenceNumber	X	X	X
DrawAdjustID	X	X	X
AAMDrawDate	X	X	X
DrawAdjustDate	X	X	X
DrawAdjustment	X	X	X
DrawAdjustBatchID	X	X	X
BillBatchID	X	X	X
FullyBilled	X	X	X
AmountCollected		X
ShortageTranNumber		X
IsBadEdition		X
IsOverSupply		X	X
IsEarlyLateReturn	X	X	X
Remarks		X
ChargeBatchID	X	X	X
ChargeSequenceNumber	X	X	X
CreditSequenceNumber	X	X	X
ImportEditionID		X
TMProductID			X
DeliveryDate			X
DeliveryScheduleID	X
CarrierCollectDrawAdjust	X
OfficePayDrawAdjust	X
PaidCompDrawAdjust	X
UnpaidCompDrawAdjust	X
SampleDrawAdjust	X
ServiceDrawAdjust	X
ThirdPartyDrawAdjust	X
SubscriptionID	X
TranNumber	X
AAMColumnID	X
CreateDate	X	X	X
CreateTime	X	X	X
CreateUser	X	X	X

* Field is required.