RecurringBillTransactions

Columns

Name

Type

References

Description

Bill_Id [KEY]

String

The Id of the Recurring Transaction.

Bill_SyncToken

String

The Version number of the object.

Bill_MetaData_CreateTime

Datetime

The time the record was created.

Bill_MetaData_LastUpdatedTime

Datetime

The time the record was last updated.

Bill_CurrencyRef

String

The Id of the currency used in the transaction.

Bill_CurrencyRef_Name

String

The currency used in the transaction.

Bill_TotalAmt

Decimal

The total bill amount.

Bill_APAccountRef_Name

String

The account reference name.

Bill_APAccountRef

String

The account reference value.

Bill_Sparse

Boolean

The Recurring transaction is sparse or not.

Bill_VendorRef_Name

String

The vendor reference name.

Bill_VendorRef

String

The vendor reference value.

Bill_SalesTermRef_Name

String

The sales reference name.

Bill_SalesTermRef

String

The sales reference value.

Bill_Balance

Decimal

The transaction balance.

Bill_LineAggregate

String

An XML aggregate of the line items of a transaction.

Bill_RecurringInfo_Name

String

The Recurring Info name.

Bill_RecurDataRef

String

The recurring data reference value.

Bill_RecurringInfo_RecurType

String

The Recurring Info recurring type.

Bill_RecurringInfo_Active

Boolean

The Recurring Info is active or not.

Bill_RecurringInfo_ScheduleInfo_IntervalType

String

The Recurring Info interval type.

Bill_RecurringInfo_ScheduleInfo_NumInterval

Integer

The Recurring Info num interval.

Bill_RecurringInfo_ScheduleInfo_DayOfWeek

String

The Recurring Info day of week.

Bill_RecurringInfo_ScheduleInfo_DayOfMonth

String

The Recurring Info day of month.

Bill_RecurringInfo_ScheduleInfo_WeekOfMonth

String

The Recurring Info week of month.

Bill_RecurringInfo_ScheduleInfo_StartDate

Datetime

The Recurring Info start date.

Bill_RecurringInfo_ScheduleInfo_NextDate

Datetime

The Recurring Info next date.

Bill_RecurringInfo_ScheduleInfo_PreviousDate

Datetime

The Recurring Info previous date.

Bill_RecurringInfo_ScheduleInfo_MaxOccurrences

String

The max number of recurring occurrences.

Bill_RecurringInfo_ScheduleInfo_RemindDays

String

The days before start date for a reminded RecurType.

Bill_RecurringInfo_ScheduleInfo_MonthOfYear

String

The month of the year.

Bill_RecurringInfo_ScheduleInfo_DaysBefore

String

The days before the scheduled date.

Bill_RecurringInfo_ScheduleInfo_EndDate

Datetime

The end date for the recurring schedule.

Last updated