Bill Format Export Elements (Used for Invoice Export)

The following data elements are used in Bill Format and Draw Format setup.

Bill Format Export Elements for Invoice Export

Bill Area	Setup Area	Data Element	Data Type
*	*	AccountID	Character
Note: These data elements can be used with any bill area.		BillAreaID	Character
		BillSourceID	Character
		CompanyID	Character
		LineFeed	N/A
		LiteralValue	Character
		TypeOfBill	Character
*	Draw	DistrictID	Character
Note: These data elements can be used with any bill area used for draw format setup.		ProductID	Character
		RouteID	Character
		RouteType	Character
Account Information	Bill	AccountClassID	Character
		AccountGroupID	Character
		AccountNumber	Character
		AccountTaxID	Character
		AccountType	Character
		AreaCode	Character
		BankNumber	Character
		BillDate	Date
		BillingAccountID	Character
		BillingDepotID	Character
		BillingDistrictID	Character
		BillingDropOrder	Character
		BillingTruckID	Character
		Building	Character
		CarriageReturn	N/A
		CityID	Character
		CollectorID	Character
		Complex	Character
		CountryID	Character
		CountyID	Character
		CreditCardOnFile	Logical
		CurrentBillAmount	Character
		DeliveryPointID	Character
		DepotID	Character
		DistributionCodeID	Character
		DistrictID	Character
		DropOrder	Integer
		DueDate	Date
		EMailAddress	Character
		FirstName	Character
		HonorificID	Character
		HouseNumber	Character
		HouseNumberModifier	Character
		InvoiceNumber	Integer
		LastBillAmount	Decimal
		LastBillDate	Date
		LastName	Character
		MiddleInitial	Character
		NameAddressLine1	Character
		NameAddressLine2	Character
		NameAddressLine3	Character
		NameAddressLine4	Character
		NameAddressLine5	Character
		NameAddressLine6	Character
		OccupantSalutationID	Character
		OtherName	Character
		OtherNameUsage	Character
		ParentDropOrder	Integer
		ParentTruckID	Character
		PastDueBalance	Decimal
		Phone	Character
		PostDirectional	Character
		PreDirectional	Character
		ProductID	Character
		RCTI	Logical
		RemitToAddressLine1	Character
		RemitToAddressLine2	Character
		RemitToAddressLine3	Character
		RemitToAddressLine4	Character
		RemitToAddressLine5	Character
		RemitToAddressLine6	Character
		RemitToAddressLine7	Character
		RouteID	Character
		RouteName	Character
		ScanLine	Character
		SecondaryAreaCode	Character
		SecondaryPhone	Character
		StateID	Character
		StreetName	Character
		StreetSuffixID	Character
		Tax	Character
		Terms	Character
		TotalDue	Decimal
		TruckID	Character
		UnitDesignatorID	Character
		UnitNumber	Character
		ZipBarCode	Character
		ZipCode	Character
		ZipExtension	Character
AdvanceDrawCharge	Bill	Amount	Decimal
		AmountPlusTax	Decimal
		BASCategoryID	Character
		BillingAccountID	Character
		CarriageReturn	N/A
		ChargeCodeID	Character
		ChargeDate	Date
		CityTaxAmount	Decimal
		CountryTaxAmount	Decimal
		CountyTaxAmount	Decimal
		DeliveryScheduleID	Character
		Description	Character
		DistrictID	Character
		DrawClassID	Character
		GLAccountID	Character
		GLDescription	Character
		ProductID	Character
		Quantity	Decimal
		RateCodeID	Character
		RecapFormat	Character
		RecapID	Character
		Reversal	Logical
		RouteID	Character
		RouteName	Character
		RouteType	Character
		StateTaxAmount	Decimal
		UnitRate	Decimal
AdvanceDrawCharge	Draw	CoverDate	Date
		DeliveryScheduleID	Character
		DrawClassID	Character
		DrawDate	Date
		DrawTotal	Integer
		EditionID	Character
		RecapFormat	Character
		RecapID	Character
		RouteName	Character
		SubstituteDelivery	Logical
Advance Drop Comp	Bill	Amount	Decimal
		AmountPlusTax	Decimal
		BASCategoryID	Character
		BillingAccountID	Character
		CarriageReturn	N/A
		ChargeCodeID	Character
		ChargeDate	Date
		ChargeTypeID	Character
		CityTaxAmount	Decimal
		CountryTaxAmount	Decimal
		CountyTaxAmount	Decimal
		Description	Character
		GLAccountID	Character
		GLDescription	Character
		ProductID	Character
		Quantity	Decimal
		RecapFormat	Character
		RecapID	Character
		Remarks	Character
		RouteID	Character
		RouteName	Character
		StateTaxAmount	Decimal
		UnitRate	Decimal
Advance Misc Charge	Bill	Amount	Decimal
		AmountPlusTax	Decimal
		BASCategoryID	Character
		BillingAccountID	Character
		CarriageReturn	N/A
		ChargeCodeID	Character
		ChargeDate	Date
		ChargeTypeID	Character
		CityTaxAmount	Decimal
		CountryTaxAmount	Decimal
		CountyTaxAmount	Decimal
		Description	Character
		GLAccountID	Character
		GLDescription	Character
		ProductID	Character
		Quantity	Decimal
		RateCodeID	Character
		RecapFormat	Character
		RecapID	Character
		Remarks	Character
		RouteID	Character
		RouteName	Character
		StateTaxAmount	Decimal
		UnitRate	Decimal
Aging	Bill	AgeCurrent	Decimal
		AgePeriod1	Decimal
		AgePeriod2	Decimal
		AgePeriod3	Decimal
		AgePeriod4	Decimal
Balance Forward	Bill	LastBillAmount	Decimal
		LastBillDate	Date
Bill Message	Bill	EntityID	Character
		EntityType	Character
		MessageText	Character
		PrintOrder	Integer
Bonus	Bill	BASCategoryID	Character
		BillingAccountID	Character
		BonusTotal	Decimal
		CarriageReturn	N/A
		ChargeCodeID	Character
		ChargeDate	Date
		DeliveryScheduleID	Character
		Description	Character
		DistrictID	Character
		DrawClassID	Character
		GLAccountID	Character
		GLDescription	Character
		ProductID	Character
		RecapFormat	Character
		RecapID	Character
		RouteID	Character
		RouteName	Character
		RouteType	Character
Bonus	Draw	BillingAccountID	Character
		BonusDate	Date
		BonusTotal	Decimal
		CarriageReturn	N/A
		DeliveryScheduleID	Character
		DrawClassID	Character
		RecapFormat	Character
		RecapID	Character
		RouteName	Character
Collection Message	Bill	CollectMessage	Character
Debit Memo	Bill	Description	Character
		DueDate	Date
		OriginalAmount	Decimal
Discount Amount	Bill	DiscountAmount	Decimal
		DiscountDate	Date
Draw Charge	Bill	AccountID	Character
		Amount	Decimal
		AmountPlusTax	Decimal
		BASCategoryID	Character
		BillAreaID	Character
		BillingAccountID	Character
		BillingMethod	Character
		BillSourceID	Character
		CarriageReturn	N/A
		ChargeCodeID	Character
		ChargeDate	Date
		CityTaxAmount	Decimal
		CompanyID	Character
		CountryTaxAmount	Decimal
		CountyTaxAmount	Decimal
		DeliveryScheduleID	Character
		Description	Character
		DistrictID	Character
		DrawClassID	Character
		GLAccountID	Character
		GLDescription	Character
		LineFeed	N/A
		LiteralValue	Character
		ProductID	Character
		Quantity	Decimal
		RateCodeID	Character
		RecapFormat	Character
		RecapID	Character
		Reversal	Logical
		RouteID	Character
		RouteName	Character
		RouteType	Character
		StateTaxAmount	Decimal
		SubscriberRateCodeID	Character
		TypeOfBill	Character
		UnitRate	Decimal
Draw Charge	Draw	BillingAccountID	Character
		CarriageReturn	N/A
		CoverDate	Date
		DeliveryScheduleID	Character
		DrawClassID	Character
		DrawDate	Date
		DrawTotal	Integer
		EditionID	Character
		RecapFormat	Character
		RecapID	Character
		RouteName	Character
		SubstituteDelivery	Logical
Drop Compensation	Bill	Amount	Decimal
		AmountPlusTax	Decimal
		BASCategoryID	Character
		BillingAccountID	Character
		CarriageReturn	N/A
		ChargeCodeID	Character
		ChargeDate	Date
		ChargeTypeID	Character
		CityTaxAmount	Decimal
		CountryTaxAmount	Decimal
		CountyTaxAmount	Decimal
		Description	Character
		GLAccountID	Character
		GLDescription	Character
		ProductID	Character
		Quantity	Decimal
		RecapFormat	Character
		RecapID	Character
		Remarks	Character
		RouteID	Character
		RouteName	Character
		StateTaxAmount	Decimal
Drop Credit	Bill	Amount	Decimal
		AmountPlusTax	Decimal
		BASCategoryID	Character
		BillingAccountID	Character
		CarriageReturn	N/A
		ChargeCodeID	Character
		ChargeDate	Date
		ChargeTypeID	Character
		CityTaxAmount	Decimal
		CountryTaxAmount	Decimal
		CountyTaxAmount	Decimal
		Description	Character
		GLAccountID	Character
		GLDescription	Character
		ProductID	Character
		Quantity	Decimal
		RecapFormat	Character
		RecapID	Character
		Remarks	Character
		RouteID	Character
		RouteName	Character
		StateTaxAmount	Decimal
		TaxableAmount	Decimal
		TaxAuthorityID	Character
		UnitRate	Decimal
GL Detail	Bill	Amount	Decimal
		BillingAccountID	Character
		CarriageReturn	N/A
		DebitAmount	Decimal
		GLAccountID	Character
		GLDescription	Character
Levy Balance	Bill	ChargeCodeID	Character
		ClosingBalance	Decimal
		CurrentActivity	Decimal
		Description	Character
		OpeningBalance	Decimal
Misc Charge	Bill	Amount	Decimal
		AmountPlusTax	Decimal
		BASCategoryID	Character
		BillingAccountID	Character
		CarriageReturn	N/A
		ChargeCodeID	Character
		ChargeDate	Date
		ChargeTypeID	Character
		CityTaxAmount	Decimal
		CountryTaxAmount	Decimal
		CountyTaxAmount	Decimal
		Description	Character
		GLAccountID	Character
		GLDescription	Character
		ProductID	Character
		Quantity	Decimal
		RateCodeID	Character
		RecapFormat	Character
		RecapID	Character
		Remarks	Character
		RouteID	Character
		RouteName	Character
		StateTaxAmount	Decimal
		TaxableAmount	Decimal
		TaxAuthorityID	Character
		UnitRate	Decimal
Misc Charge Reversal	Bill	Amount	Decimal
		AmountPlusTax	Decimal
		BASCategoryID	Character
		BillingAccountID	Character
		CarriageReturn	N/A
		ChargeCodeID	Character
		ChargeDate	Date
		ChargeTypeID	Character
		CityTaxAmount	Decimal
		CountryTaxAmount	Decimal
		CountyTaxAmount	Decimal
		Description	Character
		GLAccountID	Character
		GLDescription	Character
		ProductID	Character
		Quantity	Decimal
		RateCodeID	Character
		RecapFormat	Character
		RecapID	Character
		Remarks	Character
		RouteID	Character
		RouteName	Character
		StateTaxAmount	Decimal
		UnitRate	Decimal
Net Due	Bill	Amount	Decimal
		DueDate	Date
Office Pay Audit	Bill	BillingAccountID	Character
		CarriageReturn	N/A
		DeliveryScheduleID	Character
		ExpireDate	Date
		RouteID	Character
		RouteName	Character
		SubscriberAddress	Character
		SubscriberName	Character
		SubscriptionID	Integer
		TotalCopies	Integer
Payment	Bill	Amount	Decimal
		Remarks	Character
		TranDate	Date
Recurring Charge Bal	Bill	BillingAccountID	Character
		CarriageReturn	N/A
		ChargeCodeID	Character
		ClosingBalance	Decimal
		CurrentActivity	Decimal
		Description	Character
		Interest	Decimal
		OpeningBalance	Decimal
		RouteID	Character
		RouteName	Character
Returns	Bill	Amount	Decimal
		AmountPlusTax	Decimal
		BASCategoryID	Character
		BillingAccountID	Character
		CarriageReturn	N/A
		ChargeCodeID	Character
		ChargeDate	Date
		CityTaxAmount	Decimal
		CountryTaxAmount	Decimal
		CountyTaxAmount	Decimal
		DeliveryScheduleID	Character
		Description	Character
		DistrictID	Character
		DrawClassID	Character
		GLAccountID	Character
		GLDescription	Character
		ProductID	Character
		Quantity	Decimal
		RateCodeID	Character
		RecapFormat	Character
		RecapID	Character
		Reversal	Logical
		RouteID	Character
		RouteName	Character
		RouteType	Character
		StateTaxAmount	Decimal
		UnitRate	Decimal
Returns	Draw	AccountID	Character
		BarCode	Character
		BillAreaID	Character
		BillingAccountID	Character
		BillSourceID	Character
		CarriageReturn	N/A
		ClaimDate	Date
		ClaimReference	Character
		CompanyID	Character
		DeliveryScheduleID	Character
		DistrictID	Character
		DrawClassID	Character
		DrawDate	Date
		DrawTotal	Decimal
		IdentificationNumber	Character
		IssueNumber	Character
		LineFeed	N/A
		LiteralValue	Character
		ProductID	Character
		RecapFormat	Character
		RecapID	Character
		RouteID	Character
		RouteName	Character
		RouteType	Character
		SubstituteDelivery	Logical
		TypeOfBill	Character
		WeekNumber	Character
		Year	Character
Total Due	Bill	Amount	Character
		DueDate	Date