Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

No Format
http://DOMAIN/api/API_KEY/gla.OUTPUT

Insert excerpt
SQL API Calls
SQL API Calls
nopaneltrue

Available Fields

Field

Required

Data Type

Options

Default

Notes

recid

Conditionally*

Integer



*Required if attempting UPDATE on GLA

ledger

No

Integer

1 or 0

0

1 = Yes, 0 = No

status

No

Integer

1 or 0

1

1 = Active, 0 = Inactive

speed_code

No

String



Speed Code of the GLA

description

No

String



Description of the GLA

format

Yes

String

System Specific


Name of the Format of the GLA

revenue

Conditionally*

Integer

1 or 0

0

1 = marks GLA as Revenue / *Requirement: Either 'revenue', 'expense', or 'both' need to be set to '1'.

expense

Conditionally*

Integer

1 or 0

0

1 = marks GLA as Expense / *Requirement: Either 'revenue', 'expense', or 'both' need to be set to '1'.

taxable

No

Integer

1 or 0

0

1 = marks the GLA as taxable

gla_item_1

Yes

String



The first component of the GLA

gla_item_n

System specific*

String



See postscript note

...

Field

Required

Data Type

Options

Default

Notes

type

Yes

String

CHARGES


This is REQUIRED when interacting with GLA Charges

recid

Conditionally*

Integer



*Required if attempting to UPDATE a GLA Charge. RECID column from GLA_CHARGES table.

gla

Yes

Integer



RECID of the GLA for this Charge

catalog

Yes

Integer

Reading GLAs


Charge Catalog RECID for this Charge

prorate

No

Integer

1 or 0

0

1 = Prorate, 0 = Do not Prorate

description

No

String



Description of the Charge

amount

No

Decimal



Will be used if Charge Catalog does not have a Default Amount set

quantity

No

Integer



The quantity of Charge to be applied

start_datenoString

MRC

ARC


The Start Date of a Charge. YYYY-MM-DD format. Other formats may give unexpected results.

Used for Monthly Recurring Charges and Alternate Recurring Charges.

stop_datenoString

MRC

ARC


YYYY-MM-DD format. Other formats may give unexpected results.

Used for Monthly Recurring Charges and Alternate Recurring Charges

recurring_datenoStringARC

YYYY-MM-DD format. Other formats may give unexpected results.

Used for Alternate Recurring Charges

transaction_datenoStringNRC

YYYY-MM-DD format. Other formats may give unexpected results.

Used for Non-Recurring Charges

billing_group

No

Integer



RECID of the Billing Group, if applicable

owner_type

No

String

'Contact' or 'Department'


Type of Owner of the Charge

owner

Conditionally

Integer

Contact, Department Hierarchy


RECID of the Owner, *Required if the "owner_type" is provided.

override_amount

No

Decimal



Amount to override the default amount with, if applicable.

effectivenoStringtoday, backdatetoday

Effective flag for the charge being added/stopped. if set to any value other than listed, "today" will be assumed by the API

Alternate Recurring Charges (Quarterly, Semi-Annual and Annual), when updated will always use backdate as the Effective Date.

...