EndPoint Mark an Invoice As Uncollectible

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

mark_uncollectible_invoice

Description

Marking an invoice as uncollectible is useful for keeping track of bad debts that can be written off for accounting purposes. [API reference]

Parameters

Parameter	Label	Required	Options	Description
Id	Invoice Id	YES		Mark Uncollectible for the Invoice Id.

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(255)`	255	False
Object	`DT_WSTR`	`nvarchar(100)`	100	False
AccountCountry	`DT_WSTR`	`nvarchar(100)`	100	False
AccountName	`DT_WSTR`	`nvarchar(1020)`	1020	False
AccountTaxId	`DT_WSTR`	`nvarchar(1020)`	1020	False
AmountDue	`DT_I8`	`bigint`		False
AmountPaid	`DT_I8`	`bigint`		False
AmountRemaining	`DT_I8`	`bigint`		False
ApplicationFeeAmount	`DT_I8`	`bigint`		False
AttemptCount	`DT_I8`	`bigint`		False
Attempted	`DT_BOOL`	`bit`		False
AutoAdvance	`DT_BOOL`	`bit`		False
BillingReason	`DT_WSTR`	`nvarchar(1020)`	1020	False
Charge	`DT_WSTR`	`nvarchar(255)`	255	False
CollectionMethod	`DT_WSTR`	`nvarchar(1020)`	1020	False
Created	`DT_DBTIMESTAMP`	`datetime`		False
Currency	`DT_WSTR`	`nvarchar(100)`	100	False
CustomFields	`DT_WSTR`	`nvarchar(1020)`	1020	False
CustomerId	`DT_WSTR`	`nvarchar(1020)`	1020	False
CustomerAddressCity	`DT_WSTR`	`nvarchar(1020)`	1020	False
CustomerAddressCountry	`DT_WSTR`	`nvarchar(1020)`	1020	False
CustomerAddressLine1	`DT_WSTR`	`nvarchar(1020)`	1020	False
CustomerAddressLine2	`DT_WSTR`	`nvarchar(1020)`	1020	False
CustomerAddressPostalCode	`DT_WSTR`	`nvarchar(1020)`	1020	False
CustomerAddressState	`DT_WSTR`	`nvarchar(1020)`	1020	False
CustomerEmail	`DT_WSTR`	`nvarchar(100)`	100	False
CustomerName	`DT_WSTR`	`nvarchar(100)`	100	False
CustomerPhone	`DT_WSTR`	`nvarchar(100)`	100	False
CustomerShippingAddressCity	`DT_WSTR`	`nvarchar(100)`	100	False
CustomerShippingAddressCountry	`DT_WSTR`	`nvarchar(100)`	100	False
CustomerShippingAddressLine1	`DT_WSTR`	`nvarchar(100)`	100	False
CustomerShippingAddressLine2	`DT_WSTR`	`nvarchar(100)`	100	False
CustomerShippingAddressPostalCode	`DT_WSTR`	`nvarchar(100)`	100	False
CustomerShippingAddressState	`DT_WSTR`	`nvarchar(100)`	100	False
CustomerShippingName	`DT_WSTR`	`nvarchar(100)`	100	False
CustomerShippingPhone	`DT_WSTR`	`nvarchar(100)`	100	False
TaxExempt	`DT_WSTR`	`nvarchar(100)`	100	False
TaxIDs	`DT_WSTR`	`nvarchar(1020)`	1020	False
DefaultPaymentMethod	`DT_WSTR`	`nvarchar(1020)`	1020	False
DefaultSource	`DT_WSTR`	`nvarchar(1020)`	1020	False
DefaultTaxRates	`DT_WSTR`	`nvarchar(1000)`	1000	False
Description	`DT_WSTR`	`nvarchar(1020)`	1020	False
Discount	`DT_WSTR`	`nvarchar(1020)`	1020	False
Discounts	`DT_WSTR`	`nvarchar(100)`	100	False
DueDate	`DT_DBTIMESTAMP`	`datetime`		False
EndingBalance	`DT_I8`	`bigint`		False
Footer	`DT_WSTR`	`nvarchar(1020)`	1020	False
HostedInvoiceURL	`DT_WSTR`	`nvarchar(1020)`	1020	False
InvoicePDF	`DT_WSTR`	`nvarchar(1020)`	1020	False
LastFinalizationError	`DT_WSTR`	`nvarchar(1020)`	1020	False
LinesObject	`DT_WSTR`	`nvarchar(100)`	100	False
LinesData	`DT_NTEXT`	`nvarchar(MAX)`		False
LinesHasMore	`DT_BOOL`	`bit`		False
LinesTotalCount	`DT_I8`	`bigint`		False
LinesUrl	`DT_WSTR`	`nvarchar(1020)`	1020	False
LiveMode	`DT_BOOL`	`bit`		False
NextPaymentAttempt	`DT_DBTIMESTAMP`	`datetime`		False
Number	`DT_WSTR`	`nvarchar(1020)`	1020	False
Paid	`DT_BOOL`	`bit`		False
PaymentIntent	`DT_WSTR`	`nvarchar(1020)`	1020	False
PeriodEnd	`DT_DBTIMESTAMP`	`datetime`		False
PeriodStart	`DT_DBTIMESTAMP`	`datetime`		False
PostPaymentCreditNotesAmount	`DT_I8`	`bigint`		False
PrepaymentCreditNotesAmount	`DT_I8`	`bigint`		False
ReceiptNumber	`DT_WSTR`	`nvarchar(255)`	255	False
StartingBalance	`DT_I8`	`bigint`		False
StatementDesctiption	`DT_WSTR`	`nvarchar(1020)`	1020	False
Status	`DT_WSTR`	`nvarchar(100)`	100	False
StatusTransitionsFinalizedAt	`DT_DBTIMESTAMP`	`datetime`		False
StatusTransitionsMarkedUncollectibleAt	`DT_DBTIMESTAMP`	`datetime`		False
StatusTransitionsPaidAt	`DT_DBTIMESTAMP`	`datetime`		False
StatusTransitionsVoidedAt	`DT_DBTIMESTAMP`	`datetime`		False
SubscriptionId	`DT_WSTR`	`nvarchar(1020)`	1020	False
Subtotal	`DT_I8`	`bigint`		False
Tax	`DT_I8`	`bigint`		False
Total	`DT_I8`	`bigint`		False
TotalDiscountAmounts	`DT_WSTR`	`nvarchar(100)`	100	False
TotalTaxAmounts	`DT_WSTR`	`nvarchar(100)`	100	False
TransferData	`DT_WSTR`	`nvarchar(1020)`	1020	False
WebhooksDeliveredAt	`DT_DBTIMESTAMP`	`datetime`		False

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Id	`DT_WSTR`	`nvarchar(4000)`	4000	False

Required columns that you need to supply are bolded.