Skip to content

Instantly share code, notes, and snippets.

@sethdorris

sethdorris/tablesasjson

Created May 12, 2022 14:49
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save sethdorris/2008153059d8d0ed5311a96e2cfa01c6 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save sethdorris/2008153059d8d0ed5311a96e2cfa01c6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
tablesasjson
[
{
"EntryId": 5,
"StartDate": "2010-03-04T00:00:00",
"EndDate": "2020-03-04T23:59:59",
"MonthlyMax": 100000.00,
"WeeklyMax": 10000.00,
"DailyMax": 1000.00,
"BillingUnitId": 2,
"BillingRate": 10.00,
"RemainingBalance": 1000000.00,
"PreviousAuthorizationId": null,
"ExtraUnits": 0,
"Nonbillable": "0",
"EligibilityCode": "",
"InitialBalance": 1000000.00,
"AuthorizationExpiration": "2021-03-04T23:59:59",
"MaximumDailyBillableUnits": null,
"DailyRate": null,
"BilledUnits": null,
"AuthorizationReference1": "",
"AuthorizationReference2": "",
"AuthorizationReference3": "",
"Reference1": "",
"Reference2": "",
"Reference3": "",
"Reference4": "",
"Reference5": "",
"HideInitialBalance": "0",
"BillingHold": "0",
"EntryId": 5,
"EntryType": 2,
"Status": 4,
"Created": "2019-03-04T21:33:39.803",
"Amount": 0.00,
"TransactionId": 3,
"AccountId": 87,
"CostCenterId": 3,
"BatchId": null,
"IPAddress": "65.120.253.250",
"CreatorId": 99,
"Reason": null,
"EntryReference": "123456",
"Flags": "",
"RollupId": null,
"RefEntryId": null,
"EntryGuid": null,
"ApprovedBy": 99,
"ApprovedDate": "2019-03-04T21:34:44.7",
"ImportSource": 2,
"AutoApprove": "1",
"LocationCode": "",
"ClientProfileId": null,
"ServiceCodeGLCode": "",
"ThirdPartyBatchRefID": "",
"ParentEntryId": null,
"RefVoidId": null,
"WriteOff": null,
"AssignedPayCode": null,
"ProcessState": 0,
"AccountId": 108,
"FundingProfileId": 84,
"AccountType": 1,
"Status": 1,
"AccountReference": "",
"Created": "2019-03-05T22:38:29.847",
"Modified": "2019-03-05T22:38:29.847",
"Flags": "",
"UnitId": 2,
"Balance": 0.00,
"CostCenterId": 3,
"ServiceCodeId": 8,
"Rate": 10.00,
"TrueClockInOut": "1",
"ProfileServiceType": 1,
"AssociateProfileId": 109,
"MainProfileId": 103,
"ReferenceId": 87,
"AccountCodeRef": "",
"MaxEntryAmount": null,
"MinEntryAmount": null,
"CertificationTemplateId": null,
"EvvFrequancy": 0,
"EvvFrequencyInterval": null,
"Payability": 5,
"EVVExempt": "0"
},
{
"EntryId": 5,
"StartDate": "2010-03-04T00:00:00",
"EndDate": "2020-03-04T23:59:59",
"MonthlyMax": 100000.00,
"WeeklyMax": 10000.00,
"DailyMax": 1000.00,
"BillingUnitId": 2,
"BillingRate": 10.00,
"RemainingBalance": 1000000.00,
"PreviousAuthorizationId": null,
"ExtraUnits": 0,
"Nonbillable": "0",
"EligibilityCode": "",
"InitialBalance": 1000000.00,
"AuthorizationExpiration": "2021-03-04T23:59:59",
"MaximumDailyBillableUnits": null,
"DailyRate": null,
"BilledUnits": null,
"AuthorizationReference1": "",
"AuthorizationReference2": "",
"AuthorizationReference3": "",
"Reference1": "",
"Reference2": "",
"Reference3": "",
"Reference4": "",
"Reference5": "",
"HideInitialBalance": "0",
"BillingHold": "0",
"EntryId": 5,
"EntryType": 2,
"Status": 4,
"Created": "2019-03-04T21:33:39.803",
"Amount": 0.00,
"TransactionId": 3,
"AccountId": 87,
"CostCenterId": 3,
"BatchId": null,
"IPAddress": "65.120.253.250",
"CreatorId": 99,
"Reason": null,
"EntryReference": "123456",
"Flags": "",
"RollupId": null,
"RefEntryId": null,
"EntryGuid": null,
"ApprovedBy": 99,
"ApprovedDate": "2019-03-04T21:34:44.7",
"ImportSource": 2,
"AutoApprove": "1",
"LocationCode": "",
"ClientProfileId": null,
"ServiceCodeGLCode": "",
"ThirdPartyBatchRefID": "",
"ParentEntryId": null,
"RefVoidId": null,
"WriteOff": null,
"AssignedPayCode": null,
"ProcessState": 0,
"AccountId": 21180,
"FundingProfileId": 84,
"AccountType": 1,
"Status": 1,
"AccountReference": "",
"Created": "2021-03-15T19:11:46.607",
"Modified": null,
"Flags": "",
"UnitId": 2,
"Balance": 0.00,
"CostCenterId": 3,
"ServiceCodeId": 8,
"Rate": 10.00,
"TrueClockInOut": "0",
"ProfileServiceType": 1,
"AssociateProfileId": 109,
"MainProfileId": 14593,
"ReferenceId": 87,
"AccountCodeRef": "",
"MaxEntryAmount": null,
"MinEntryAmount": null,
"CertificationTemplateId": null,
"EvvFrequancy": null,
"EvvFrequencyInterval": null,
"Payability": null,
"EVVExempt": "0"
},
{
"EntryId": 5,
"StartDate": "2010-03-04T00:00:00",
"EndDate": "2020-03-04T23:59:59",
"MonthlyMax": 100000.00,
"WeeklyMax": 10000.00,
"DailyMax": 1000.00,
"BillingUnitId": 2,
"BillingRate": 10.00,
"RemainingBalance": 1000000.00,
"PreviousAuthorizationId": null,
"ExtraUnits": 0,
"Nonbillable": "0",
"EligibilityCode": "",
"InitialBalance": 1000000.00,
"AuthorizationExpiration": "2021-03-04T23:59:59",
"MaximumDailyBillableUnits": null,
"DailyRate": null,
"BilledUnits": null,
"AuthorizationReference1": "",
"AuthorizationReference2": "",
"AuthorizationReference3": "",
"Reference1": "",
"Reference2": "",
"Reference3": "",
"Reference4": "",
"Reference5": "",
"HideInitialBalance": "0",
"BillingHold": "0",
"EntryId": 5,
"EntryType": 2,
"Status": 4,
"Created": "2019-03-04T21:33:39.803",
"Amount": 0.00,
"TransactionId": 3,
"AccountId": 87,
"CostCenterId": 3,
"BatchId": null,
"IPAddress": "65.120.253.250",
"CreatorId": 99,
"Reason": null,
"EntryReference": "123456",
"Flags": "",
"RollupId": null,
"RefEntryId": null,
"EntryGuid": null,
"ApprovedBy": 99,
"ApprovedDate": "2019-03-04T21:34:44.7",
"ImportSource": 2,
"AutoApprove": "1",
"LocationCode": "",
"ClientProfileId": null,
"ServiceCodeGLCode": "",
"ThirdPartyBatchRefID": "",
"ParentEntryId": null,
"RefVoidId": null,
"WriteOff": null,
"AssignedPayCode": null,
"ProcessState": 0,
"AccountId": 21181,
"FundingProfileId": 84,
"AccountType": 1,
"Status": 1,
"AccountReference": "",
"Created": "2021-03-15T19:11:46.687",
"Modified": null,
"Flags": "",
"UnitId": 2,
"Balance": 0.00,
"CostCenterId": 3,
"ServiceCodeId": 8,
"Rate": 10.00,
"TrueClockInOut": "0",
"ProfileServiceType": 1,
"AssociateProfileId": 109,
"MainProfileId": 14594,
"ReferenceId": 87,
"AccountCodeRef": "",
"MaxEntryAmount": null,
"MinEntryAmount": null,
"CertificationTemplateId": null,
"EvvFrequancy": null,
"EvvFrequencyInterval": null,
"Payability": null,
"EVVExempt": "0"
},
{
"EntryId": 5,
"StartDate": "2010-03-04T00:00:00",
"EndDate": "2020-03-04T23:59:59",
"MonthlyMax": 100000.00,
"WeeklyMax": 10000.00,
"DailyMax": 1000.00,
"BillingUnitId": 2,
"BillingRate": 10.00,
"RemainingBalance": 1000000.00,
"PreviousAuthorizationId": null,
"ExtraUnits": 0,
"Nonbillable": "0",
"EligibilityCode": "",
"InitialBalance": 1000000.00,
"AuthorizationExpiration": "2021-03-04T23:59:59",
"MaximumDailyBillableUnits": null,
"DailyRate": null,
"BilledUnits": null,
"AuthorizationReference1": "",
"AuthorizationReference2": "",
"AuthorizationReference3": "",
"Reference1": "",
"Reference2": "",
"Reference3": "",
"Reference4": "",
"Reference5": "",
"HideInitialBalance": "0",
"BillingHold": "0",
"EntryId": 5,
"EntryType": 2,
"Status": 4,
"Created": "2019-03-04T21:33:39.803",
"Amount": 0.00,
"TransactionId": 3,
"AccountId": 87,
"CostCenterId": 3,
"BatchId": null,
"IPAddress": "65.120.253.250",
"CreatorId": 99,
"Reason": null,
"EntryReference": "123456",
"Flags": "",
"RollupId": null,
"RefEntryId": null,
"EntryGuid": null,
"ApprovedBy": 99,
"ApprovedDate": "2019-03-04T21:34:44.7",
"ImportSource": 2,
"AutoApprove": "1",
"LocationCode": "",
"ClientProfileId": null,
"ServiceCodeGLCode": "",
"ThirdPartyBatchRefID": "",
"ParentEntryId": null,
"RefVoidId": null,
"WriteOff": null,
"AssignedPayCode": null,
"ProcessState": 0,
"AccountId": 21182,
"FundingProfileId": 84,
"AccountType": 1,
"Status": 1,
"AccountReference": "",
"Created": "2021-03-15T19:11:46.747",
"Modified": null,
"Flags": "",
"UnitId": 2,
"Balance": 0.00,
"CostCenterId": 3,
"ServiceCodeId": 8,
"Rate": 10.00,
"TrueClockInOut": "0",
"ProfileServiceType": 1,
"AssociateProfileId": 109,
"MainProfileId": 14595,
"ReferenceId": 87,
"AccountCodeRef": "",
"MaxEntryAmount": null,
"MinEntryAmount": null,
"CertificationTemplateId": null,
"EvvFrequancy": null,
"EvvFrequencyInterval": null,
"Payability": null,
"EVVExempt": "0"
},
{
"EntryId": 5,
"StartDate": "2010-03-04T00:00:00",
"EndDate": "2020-03-04T23:59:59",
"MonthlyMax": 100000.00,
"WeeklyMax": 10000.00,
"DailyMax": 1000.00,
"BillingUnitId": 2,
"BillingRate": 10.00,
"RemainingBalance": 1000000.00,
"PreviousAuthorizationId": null,
"ExtraUnits": 0,
"Nonbillable": "0",
"EligibilityCode": "",
"InitialBalance": 1000000.00,
"AuthorizationExpiration": "2021-03-04T23:59:59",
"MaximumDailyBillableUnits": null,
"DailyRate": null,
"BilledUnits": null,
"AuthorizationReference1": "",
"AuthorizationReference2": "",
"AuthorizationReference3": "",
"Reference1": "",
"Reference2": "",
"Reference3": "",
"Reference4": "",
"Reference5": "",
"HideInitialBalance": "0",
"BillingHold": "0",
"EntryId": 5,
"EntryType": 2,
"Status": 4,
"Created": "2019-03-04T21:33:39.803",
"Amount": 0.00,
"TransactionId": 3,
"AccountId": 87,
"CostCenterId": 3,
"BatchId": null,
"IPAddress": "65.120.253.250",
"CreatorId": 99,
"Reason": null,
"EntryReference": "123456",
"Flags": "",
"RollupId": null,
"RefEntryId": null,
"EntryGuid": null,
"ApprovedBy": 99,
"ApprovedDate": "2019-03-04T21:34:44.7",
"ImportSource": 2,
"AutoApprove": "1",
"LocationCode": "",
"ClientProfileId": null,
"ServiceCodeGLCode": "",
"ThirdPartyBatchRefID": "",
"ParentEntryId": null,
"RefVoidId": null,
"WriteOff": null,
"AssignedPayCode": null,
"ProcessState": 0,
"AccountId": 21183,
"FundingProfileId": 84,
"AccountType": 1,
"Status": 1,
"AccountReference": "",
"Created": "2021-03-15T19:11:46.793",
"Modified": null,
"Flags": "",
"UnitId": 2,
"Balance": 0.00,
"CostCenterId": 3,
"ServiceCodeId": 8,
"Rate": 10.00,
"TrueClockInOut": "0",
"ProfileServiceType": 1,
"AssociateProfileId": 109,
"MainProfileId": 14596,
"ReferenceId": 87,
"AccountCodeRef": "",
"MaxEntryAmount": null,
"MinEntryAmount": null,
"CertificationTemplateId": null,
"EvvFrequancy": null,
"EvvFrequencyInterval": null,
"Payability": null,
"EVVExempt": "0"
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment