Versions Compared

Key

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

...

Permitted values are from the SERVICE_TYPE List Values

All Service Types are valid for Service Charge Imports.

...

New Override Amount

Datatype is String Number.

Default value is blank.

This is only allowed if the Charge Catalog entry allows overrides. Used for updates.

New Quantity

Datatype is Stringis Number

Default value is blank.

Used for UPDATE only.

RECID

Datatype is String Number.

Default value is blank.

This is used only as a lookup key for Charge Updates.

Effective Date

Data type is String.

Default value is blank.

This is not a date field. Allowed values are: BACKDATE or TODAY

Prorate Flag

Datatype is Boolean.

...

All other Values will enter as False [0].

Quantity

Datatype is String.

UPDATE flag

Data type is Boolean.

Default value is False.

Permitted Values: 1, Yes, and True will turn on this flag.  All other values are false.

If set, this import will UPDATE existing records. If the import cannot find an existing record to UPDATE, it will error.Number.

Service RECID

Datatype is Number.

...

Flags / Conditional Logic

SERVICE_CHARGE_TYPE

...

Default Value is 'NONRECURRING'.

...

The only allowed values are the System Use Values: MONTHLY_RECURRING, NONRECURRING, QUARTERLY, SEMI_ANNUAL, and ANNUAL_RECURRING.

UPDATE

...

Data type is Boolean.

Default value is False.

Permitted Values: 1, Yes, and or True will turn on this flag.  All other values are false.

If set, this import will UPDATE existing records. If the import cannot find an existing record to UPDATE, it will error.

Effective Date

Data type is String.

Default value is blank.

...