ODBC Driver for Workday

Build 24.0.9062

Invoices

Retrieves a single customer invoice or adjustment instance.

Workday Resource Information

Retrieves a customer invoice or adjustment with the specified ID.

Secured by: Process: Customer Invoice - View, Process: Project Billing - View

Scope: Customer Accounts, Project Billing

Columns

Name Type Description
Id [KEY] String Id of the instance
AdjustmentReason_Descriptor String Supported for: SELECT. A preview of the instance
BillToCustomerAddress_AddressLine1 String Supported for: SELECT. The first address line for the bill-to customer.
BillToCustomerAddress_AddressLine2 String Supported for: SELECT. The second address line for the bill-to customer.
BillToCustomerAddress_AddressLine3 String Supported for: SELECT. The third address line for the bill-to customer.
BillToCustomerAddress_AddressLine4 String Supported for: SELECT. The fourth address line for the bill-to customer.
BillToCustomerAddress_City String Supported for: SELECT. The city of the bill-to customer.
BillToCustomerAddress_CitySubdivision1 String Supported for: SELECT. The subdivision of the city of the bill-to customer.
BillToCustomerAddress_CitySubdivision2 String Supported for: SELECT. The second subdivision of the city of the bill-to customer.
BillToCustomerAddress_CountryRegion_Descriptor String Supported for: SELECT. A preview of the instance
BillToCustomerAddress_Country_Descriptor String Supported for: SELECT. A preview of the instance
BillToCustomerAddress_Descriptor String Supported for: SELECT. A preview of the instance
BillToCustomerAddress_Id String Supported for: SELECT. Id of the instance
BillToCustomerAddress_PostalCode String Supported for: SELECT. The postal code of the bill-to customer.
BillToCustomerAddress_RegionSubdivision1 String Supported for: SELECT. The subdivision of the region of the bill-to customer.
BillToCustomerAddress_RegionSubdivision2 String Supported for: SELECT. The second subdivision of the region of the bill-to customer.
BillToCustomer_Descriptor String Supported for: SELECT. A preview of the instance
BillToCustomer_Id String Supported for: SELECT. Id of the instance
Company_Descriptor String Supported for: SELECT. A preview of the instance
Company_Id String Supported for: SELECT. Id of the instance
Currency_Descriptor String Supported for: SELECT. A preview of the instance
Descriptor String Supported for: SELECT. A preview of the instance
DisputeAmount_Currency String Supported for: SELECT. The amount you dispute on a customer invoice. (Currency name)
DisputeAmount_Value Decimal Supported for: SELECT. The amount you dispute on a customer invoice. (Value)
DisputeDate Datetime Supported for: SELECT. The date you place the customer invoice in dispute.
DueAmount_Currency String Supported for: SELECT. The amount due for the customer invoice. The value can be positive or negative. (Currency name)
DueAmount_Value Decimal Supported for: SELECT. The amount due for the customer invoice. The value can be positive or negative. (Value)
DueDate Datetime Supported for: SELECT. The due date of the customer invoice or invoice adjustment as of the defined reporting date.
Href String Supported for: SELECT. A link to the instance
InCollection Bool Supported for: SELECT. A flag when set to true, places the invoices into collections.
InDispute Bool Supported for: SELECT. True if the invoice is in dispute.
InvoiceDate Datetime Supported for: SELECT. The date of the customer invoice.
InvoiceNumber String Supported for: SELECT. The customer invoice number.
InvoiceStatus_Descriptor String Supported for: SELECT. A preview of the instance
InvoiceStatus_Id String Supported for: SELECT. Id of the instance
InvoiceType_Descriptor String Supported for: SELECT. A preview of the instance
Memo String Supported for: SELECT. The memo for the customer invoice.
NetAmount_Currency String Supported for: SELECT. The total of all invoice line amounts minus the total Tax amount minus the Prepaid Utilization amount. This calculation doesn't deduct the withholding tax. This is the value printed on the customer invoice and can be positive or negative. (Currency name)
NetAmount_Value Decimal Supported for: SELECT. The total of all invoice line amounts minus the total Tax amount minus the Prepaid Utilization amount. This calculation doesn't deduct the withholding tax. This is the value printed on the customer invoice and can be positive or negative. (Value)
PaymentStatus_Descriptor String Supported for: SELECT. A preview of the instance
PaymentStatus_Id String Supported for: SELECT. Id of the instance
PoNumber String Supported for: SELECT. The purchase order number specified on the customer invoice.
RelatedInvoice_Descriptor String Supported for: SELECT. A description of the instance
RelatedInvoice_Href String Supported for: SELECT. A link to the instance
RelatedInvoice_Id String Supported for: SELECT. wid / id / reference id
RetentionAmount_Currency String Supported for: SELECT. Total retention amount from invoice lines. (Currency name)
RetentionAmount_Value Decimal Supported for: SELECT. Total retention amount from invoice lines. (Value)
TaxAmount_Currency String Supported for: SELECT. The total tax amount for the document with sign. (Currency name)
TaxAmount_Value Decimal Supported for: SELECT. The total tax amount for the document with sign. (Value)
TotalAmount_Currency String Supported for: SELECT. The total amount for the customer invoice including tax. The amount can be positive or negative. When the reporting transaction is not an instance of a customer invoice, the amount value is zero. (Currency name)
TotalAmount_Value Decimal Supported for: SELECT. The total amount for the customer invoice including tax. The amount can be positive or negative. When the reporting transaction is not an instance of a customer invoice, the amount value is zero. (Value)
TransactionType String Supported for: SELECT. The type of customer invoice document, either Invoice or Adjustment.
WithholdingAmount_Currency String Supported for: SELECT. The tax amount that you withhold from the customer invoice. (Currency name)
WithholdingAmount_Value Decimal Supported for: SELECT. The tax amount that you withhold from the customer invoice. (Value)
BillToCustomer_Prompt String Accepts multiple inputs. The customer on the invoice.
Company_Prompt String Accepts multiple inputs. No description available.
FromDueDate_Prompt Date The due date of the customer invoice or invoice adjustment as of the defined reporting date, formatted as YYYY-MM-DD.
FromInvoiceDate_Prompt Date The date of the customer invoice, formatted as YYYY-MM-DD.
InvoiceStatus_Prompt String Accepts multiple inputs. The current status of an invoice document.
PaymentStatus_Prompt String Accepts multiple inputs. The payment status of an invoice document.
ToDueDate_Prompt Date The due date of the customer invoice or invoice adjustment as of the defined reporting date, formatted as YYYY-MM-DD.
ToInvoiceDate_Prompt Date The date of the customer invoice, formatted as YYYY-MM-DD.
TransactionType_Prompt String The transaction type of this customer transaction. Use the string "invoice" or "adjustment" to filter to retrieve either only invoices or adjustments.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062