Subscriber Payment Journal
The following data elements can be used with the “SubPymtJrnl” usage.
Account Detail record Data Elements
LiteralValue
AccDeliveryFee
CountyTaxAuthID
AccountID
TipAmount1
StateTaxAmount
AccountName
TipCarrierID1
StateTaxAuthID
Type
TipOccupantName1
CountryTaxAmount
PaymentDate
TipAmount2
CountryTaxAuthID
PaymentAmount
TipCarrierID2
CityAdjTaxAmount
CheckNumber
TipOccupantName2
CityAdjTaxAuthID
PymtTranID
TipAmount3
CountyAdjTaxAmount
VaultID
TipCarrierID3
CountyAdjTaxAuthID
VaultCustomerID
TipOccupantName3
StateAdjTaxAmount
AuthorizationNum
TipAmount4
StateAdjTaxAuthID
AccountType
TipCarrierID4
CountryAdjTaxAmount
AccountNumber
TipOccupantName4
CountryAdjTaxAuthID
BankNumber
TipAmount5
CityGraceTaxAmount
PaypalEmail
TipCarrierID5
CityGraceTaxAuthID
CreditCardTypeID
TipOccupantName5
CountyGraceTaxAmount
CreditCardNumber
TipAmount6
CountyGraceTaxAuthID
CreditCardExpires
TipCarrierID6
StateGraceTaxAmount
PaymentSource
TipOccupantName6
StateGraceTaxAuthID
AdjustmentAmount
TipAmount7
CountryGraceTaxAmount
AdjustmentCodeID
TipCarrierID7
CountryGraceTaxAuthID
GracePaid
TipOccupantName7
Remarks
BadDebtPaid
ActivationFee
ActivationFeeTax
CouponAmount
PrintedBillFee
PrintedBillFeeTax
EffectiveDate
OtherFee
OtherFeeTax
ExpireDate
FeeCodeID
PaymentLength
ISOverride
PaymentTerm
CityTaxAmount
RateCode
CityTaxAuthID
Reason
CountyTaxAmount
Adjust Detail record Data Elements
LiteralValue
AdjustmentNonLiabGracePD
AdjustmentCode
AdjustmentTotalCount
AdjustmentCount
AdjustmentTotalNonCashAmt
AdjustmentNonCashAmt
AdjustmentTotalCashAmt
AdjustmentCashAmt
AdjustmentTotalNoUpdExp
AdjustmentNoUpdExp
AdjustmentTotalUpdExp
AdjustmentUpdExp
AdjustmentTotalLiabImpact
AdjustmentLiabImpact
AdjustmentTotalNonLiabGracePD
Bank Detail record Data Elements
LiteralValue
BankNonCashAdj
BankName
BankTotalCount
BankCount
BankTotalAmount
BankAmount
BankTotalCouponAmt
BankCouponAmt
BankTotalTipAmt
BankTipAmt
BankTotalPymtTotal
BankPymtTotal
BankTotalGracePaid
BankGracePaid
BankTotalBadDebtPD
BankBadDebtPD
BankTotalCashAdj
BankCashAdj
BankTotalNonCashAdj
Cancel By Type record Data Elements
LiteralValue
CancelTranTypeNonCashAdj
CancelTranType
CancelTranTotalTypeCount
CancelTranTypeCount
CancelTranTotalTypeAmt
CancelTranTypeAmt
CancelTranTotalTypeCouponAmt
CancelTranTypeCouponAmt
CancelTranTotalTypeTipAmt
CancelTranTypeTipAmt
CancelTranTotalTypePymtTotal
CancelTranTypePymtTotal
CancelTranTotalTypeGracePaid
CancelTranTypeGracePaid
CancelTranTotalTypeBadDebtPD
CancelTranTypeBadDebtPD
CancelTranTotalTypeCashAdj
CancelTranTypeCashAdj
CancelTranTotalTypeNonCashAdj
Delivery Fee Detail record Data Elements
LiteralValue
DeliveryFee
DeliveryFeeCount
DeliveryFeeAmount
DeliveryTotalFeeCount
DeliveryTotalFeeAmount
Subscriber Fee Detail record Data Elements
LiteralValue
FeeGrandTotalCount
FeeType
FeeGrandTotalAmt
FeeCode
FeeTaxCount
FeeDescription
FeeTaxAmt
FeeCount
FeeTaxTotalCount
FeeAmt
FeeTaxTotalAmt
FeeTotalCount
FeeTaxGrandTotalCount
FeeTotalAmt
FeeTaxGrandTotalAmt
Subscriber Group Detail record Data Elements
LiteralValue
GroupEffectiveDate
GroupName
GroupTotalPymtAmt
GroupPayDate
GroupTotalCouponAmt
GroupSubscriberID
GroupTotalTipAmt
GroupSubscriberName
GroupGrandTotalPymtAmt
GroupPymtAmt
GroupGrandTotalCouponAmt
GroupCouponAmt
GroupGrandTotalTipAmt
GroupTipAmt
Operator Detail record Data Elements
LiteralValue
OperatorNonCashAdj
OperatorName
OperatorTotalCount
OperatorCount
OperatorTotalAmt
OperatorAmt
OperatorTotalCouponAmt
OperatorCouponAmt
OperatorTotalTipAmt
OperatorTipAmt
OperatorTotalPymtAmt
OperatorPymtAmt
OperatorTotalGracePaid
OperatorGracePaid
OperatorTotalBadDebtPD
OperatorBadDebtPD
OperatorTotalCashAdj
OperatorCashAdj
OperatorTotalNonCashAdj
Process Status record Data Elements
LiteralValue
ProStatTotalSourceNonCashAdj
ProcessStatusType
ProStatGrandTotalSourceCount
ProStatTotalSourceCount
ProStatGrandTotalSourceAmt
ProStatTotalSourceAmt
ProStatGrandTotalSourceCouponA
ProStatTotalSourceCouponAmt
ProStatGrandTotalSourceTipAmt
ProStatTotalSourceTipAmt
ProStatGrandTotalSourcePymtTot
ProStatTotalSourcePymtTotal
ProStatGrandTotalSourceGracePa
ProStatTotalSourceGracePaid
ProStatGrandTotalSourceBadDebt
ProStatTotalSourceBadDebtPD
ProStatGrandTotalSourceCashAdj
ProStatTotalSourceCashAdj
ProStatGrandTotalSourceNoCashA
Publication PaymentType Detail record Data Elements
LiteralValue
PublPymtTypeNonCashAdj
PublID
PublPymtTypeTotalCount
PublPymtType
PublPymtTypeTotalAmt
PublPymtTypeCount
PublPymtTypeTotalCouponAmt
PublPymtTypeAmt
PublPymtTypeTotalTipAmt
PublPymtTypeCouponAmt
PublPymtTypeTotalPymtTotal
PublPymtTypeTipAmt
PublPymtTypeTotalGracePaid
PublPymtTypePymtTotal
PublPymtTypeTotalBadDebtPD
PublPymtTypeGracePaid
PublPymtTypeTotalCashAdj
PublPymtTypeBadDebtPD
PublPymtTypeTotalNonCashAdj
PublPymtTypeCashAdj
PaymentType Detail record Data Elements
LiteralValue
PaymentTypeNonCashAdj
PaymentType
PaymentTypeTotalCount
PaymentTypeCount
PaymentTypeTotalAmt
PaymentTypeAmt
PaymentTypeTotalCouponAmt
PaymentTypeCouponAmt
PaymentTypeTotalTipAmt
PaymentTypeTipAmt
PaymentTypeTotalPymtTotal
PaymentTypePymtTotal
PaymentTypeTotalGracePaid
PaymentTypeGracePaid
PaymentTypeTotalBadDebtPD
PaymentTypeBadDebtPD
PaymentTypeTotalCashAdj
PaymentTypeCashAdj
PaymentTypeTotalNonCashAdj
Source Detail record Data Elements
LiteralValue
SourceTotalTipAmt
Source
SourceTotalPymtTotal
SourceReason
SourceTotalGracePaid
SourceCount
SourceTotalBadDebtPD
SourceAmt
SourceTotalCashAdj
SourceCouponAmt
SourceTotalNonCashAdj
SourceTipAmt
SourceGrandTotalCount
SourcePymtTotal
SourceGrandTotalAmt
SourceGracePaid
SourceGrandTotalCouponAmt
SourceBadDebtPD
SourceGrandTotalTipAmt
SourceCashAdj
SourceGrandTotalPymtTotal
SourceNonCashAdj
SourceGrandTotalGracePaid
SourceTotalCount
SourceGrandTotalBadDebtPD
SourceTotalAmt
SourceGrandTotalCashAdj
SourceTotalCouponAmt
SourceGrandTotalNonCashAdj
SubTotal Detail record Data Elements
LiteralValue
SubTotalTypeTotalPymtTotal
SubTotalType
SubTotalTypeTotalGracePaid
SubTotalTypeTotalCount
SubTotalTypeTotalBadDebtPD
SubTotalTypeTotalAmt
SubTotalTypeTotalCashAdj
SubTotalTypeTotalCouponAmt
SubTotalTypeTotalNonCashAdj
SubTotalTypeTotalTipAmt
Subscriber Tax Detail record Data Elements
LiteralValue
TaxTotalCount
TaxAuthority
TaxTotalAmount
TaxCount
TaxTotalGraceTax
TaxAmount
TaxFeeTax
TaxGraceTax
TaxTotalFeeTax
Transaction Date Type Detail Record Detail record Data Elements
LiteralValue
TranDateTypeNonCashAdj
TranDate
TranDateTotalTypeCount
TranType
TranDateTotalTypeAmt
TranDateTypeCount
TranDateTotalTypeCouponAmt
TranDateTypeAmt
TranDateTotalTypeTipAmt
TranDateTypeCouponAmt
TranDateTotalTypePymtTotal
TranDateTypeTipAmt
TranDateTotalTypeGracePaid
TranDateTypePymtTotal
TranDateTotalTypeBadDebtPD
TranDateTypeGracePaid
TranDateTotalTypeCashAdj
TranDateTypeBadDebtPD
TranDateTotalTypeNonCashAdj
TranDateTypeCashAdj
Last updated