...
For updates, the Import needs to find the Charges to update. At a minimum, the Service ID, Charge Catalog and Charge Type must be provided. Optionally the Start Date, Override Amount, and Quantity can be provided. If the values provided match more than one Charge, then all of those that match will be updated.
...
This will override the Charge Catalog Description for Billing.
Prorate
Default Value is False.
Datatype is Boolean.
Permitted Values: 1, Yes, and True sets the Prorate flag to True [1].
All other Values will enter as False [0].
Expense GLA
Datatype is String.
...
New Override Amount
Datatype is Number.
Default value is blank.
This is only allowed if the Charge Catalog entry allows overrides.
This field is only used for UPDATES.
New Quantity
Datatype is String Number.
Default value is blank.
This field is only used for UPDATES.
RECID
Datatype is String Number.
Default value is blank.
This field is only used for UPDATES.
Quantity
Datatype is String Number.
Default Value is 1.
Service RECID
...
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
...
Default value is False.
Data type is Boolean.
Permitted Values: 1, Yes, and or True will turn on this flag. All other values are false.
...
If set, the Import will only update existing Charges. This can be used to set Stop Dates on MRCs, or change Override Amounts, Quantity, Description, GLA, or Prorate flag.
PRORATE:
Default Value is False.
Datatype is Boolean.
Permitted Values: 1, Yes, and True sets the Prorate flag to True [1].
All other Values will enter as False [0].
Effective Date
Data type is String.
...
This is not a date field. Allowed values are: BACKDATE or TODAY
This field is only used for UPDATES.
See the Notes for more details.
Warnings and Errors
The following warnings display if the Service Charge UPDATE fails:
...