ReceivablesInvoices
The receivables invoices resource is used to create, get, update, and delete a receivables invoice. Note: You can update only the InvoiceStatus, PaymentTerms, and TransactionDate attributes.
Columns
| Name | Type | Description |
| CustomerTransactionId [KEY] | Long | The unique identifier of the invoice. |
| DueDate | Date | The date when the invoice installment is due to be paid. |
| ConversionDate | Date | The date a specific conversion rate is used to convert the invoice currency to the ledger currency. |
| ConversionRate | Decimal | The rate used to convert the invoice currency to the ledger currency. |
| InvoiceCurrencyCode | String | The code that identifies the entered currency of the invoice. |
| SpecialInstructions | String | The special instructions that accompany the invoice. |
| CrossReference | String | The reference field default value from the transaction source assigned to the invoice. The reference field default value is the source document used to identify transactions created using the transaction source. |
| DocumentNumber | Long | The document sequence number assigned to the invoice. |
| TransactionNumber | String | The transaction number assigned to the invoice. |
| TransactionDate | Date | The date when the invoice was created. |
| TransactionType | String | The transaction type assigned to the invoice. |
| TransactionSource | String | The transaction source assigned to the invoice. |
| BillToCustomerNumber | String | The account number of the bill-to customer assigned to the invoice. |
| BillToSite | String | The number that identifies the bill-to customer site assigned to the invoice. |
| Comments | String | The user comments that accompany the invoice. |
| InternalNotes | String | The user-defined internal notes that accompany the invoice. |
| PaymentTerms | String | The payment terms assigned to the invoice. |
| LegalEntityIdentifier | String | The unique identifier of the legal entity under which the invoice is created. A legal entity is a recognized party with rights and responsibilities given by legislation. |
| ConversionRateType | String | The grouping of conversion rates between currencies, used to automatically populate a specific rate to an invoice or invoice line according to business requirements. Valid values are Spot, Corporate, User, and Fixed. |
| PurchaseOrder | String | The purchase order number on the invoice. |
| PurchaseOrderDate | Date | The date when the purchase order was generated for the invoice. |
| PurchaseOrderRevision | String | The revision number of the purchase order on the invoice. |
| FirstPartyRegistrationNumber | String | The tax registration number of the deploying company. |
| ThirdPartyRegistrationNumber | String | The tax registration number of the bill-to customer. |
| InvoicingRule | String | The accounting approach used to recognize revenue on the invoice. The valid values are In Advance and In Arrears. |
| ShipToCustomerName | String | The name of the customer who receives the goods or services billed on the invoice. |
| ShipToCustomerNumber | String | The registry identifier of the ship-to customer assigned to the invoice. |
| BillingDate | Date | The balance forward bill date, if the invoice belongs to a balance forward bill. |
| BillToPartyId | Long | BillToPartyId of ReceivablesInvoices |
| BusinessUnit | String | The business unit under which the invoice is created. A business unit is a unit of an enterprise that performs one or more business functions that can be rolled up in a management hierarchy. |
| InvoiceStatus | String | The value that indicates the level of completion of the invoice. Valid values are Complete, Incomplete, and Frozen. Value must be Complete when creating a receivables invoice. |
| AccountingDate | Date | The accounting date assigned to the invoice. |
| ShipToSite | String | The number that identifies the ship-to customer site assigned to the invoice. |
| PayingCustomerName | String | The name of the customer who pays for the goods or services on the invoice. |
| PayingCustomerSite | String | The number that identifies the paying customer site assigned to the invoice. |
| BillToCustomerName | String | The name that identifies the bill-to customer assigned to the invoice. |
| FreightAmount | Decimal | The freight applicable at the invoice level. |
| Carrier | String | The name of the shipping vendor. |
| ShipDate | Date | The date when the items on the invoice are shipped. |
| ShippingReference | String | The waybill reference on the invoice. |
| BillToContact | String | The contact details of the bill-to customer. |
| ShipToContact | String | The contact details of the ship-to customer. |
| PrintOption | String | The option that indicates whether to print the invoice. |
| CreatedBy | String | CreatedBy of ReceivablesInvoices |
| CreationDate | Datetime | CreationDate of ReceivablesInvoices |
| LastUpdatedBy | String | LastUpdatedBy of ReceivablesInvoices |
| LastUpdateDate | Datetime | LastUpdateDate of ReceivablesInvoices |
| PayingCustomerAccount | String | The account number of the paying customer assigned to the invoice. |
| SoldToPartyNumber | String | The unique number used to identify the sold-to customer on the invoice. |
| RemitToAddress | String | The address to which the customer should send payment for the invoice. |
| DefaultTaxationCountry | String | The country where the invoice transaction takes place for tax purposes. |
| EnteredAmount | Decimal | EnteredAmount of ReceivablesInvoices |
| InvoiceBalanceAmount | Decimal | InvoiceBalanceAmount of ReceivablesInvoices |
| Prepayment | String | The option used to identify the invoice as a transaction requiring prepayment for goods and services. |
| Intercompany | String | The option used to identify the invoice as an intercompany transaction. |
| DocumentFiscalClassification | String | The classification for tax purposes of invoice transactions that require special documentation to accompany the transaction, as designated by a tax authority. |
| BankAccountNumber | String | The bank account number of the customer on the invoice. |
| CreditCardAuthorizationRequestIdentifier | String | The authorization request identifier received from the tokenization service provider to authorize the credit card number. |
| CreditCardExpirationDate | String | The date when the credit card expires. |
| CreditCardIssuerCode | String | The code for the credit card issuer, such as Visa or MasterCard. |
| CreditCardTokenNumber | String | The token number issued by the tokenization service provider corresponding to a credit card number. |
| CreditCardVoiceAuthorizationCode | String | The voice authorization code received from the tokenization service provider for authorization. |
| CreditCardErrorCode | String | The error code when credit card authorization fails. |
| CreditCardErrorText | String | The error text when credit card authorization fails. |
| CardHolderLastName | String | The last name of the credit card holder. |
| CardHolderFirstName | String | The first name of the credit card holder. |
| ReceiptMethod | String | The receipt method assigned to the invoice. |
| SalesPersonNumber | String | The number that identifies the primary salesperson on the invoice. |
| StructuredPaymentReference | String | An industry standard reference on Receivables transactions composed of letters, check digits, and transaction information, used to identify the transaction and its payments to the customer and bank. |
| InvoicePrinted | String | Option that indicates whether the invoice has been printed at least once. The user must enter Y to update print attributes. |
| LastPrintDate | Date | Date when the transaction was last reprinted. |
| OriginalPrintDate | Date | Date when the transaction was first printed. |
| DeliveryMethod | String | Method used to deliver printed transactions. Valid values are E-Mail, Paper, Portal Upload, or any of the custom values defined in the product. |
| String | Email address of the customer bill-to contact who receives printed transactions. | |
| AllowCompletion | String | Indicates whether the transaction is reviewed and can be allowed to complete. Valid value to allow completion is 'Y'. |
| ControlCompletionReason | String | Reason that determines transaction completion. |
| Finder | String | Finder of ReceivablesInvoices |
| FirstPartyTaxRegistration | String | FirstPartyTaxRegistration of ReceivablesInvoices |
| ThirdPartyTaxRegistration | String | ThirdPartyTaxRegistration of ReceivablesInvoices |