Invoices
The payables invoices resource is used to manage details about supplier invoices, that includes header, lines, distributions, installments, descriptive flexfields, global descriptive flexfields, and attachments. Note: You can only update certain attributes and the update applies only to those attributes. Related fields don't automatically get populated. In summary, the cascade defaulting doesn't automatically happen and you must review and update the dependent attributes. For example, when you update the invoice date in the Create or Edit Invoice pages, related fields, such as the terms date or due date, may be autopopulated based on the invoice date you enter. Using REST API, the invoice date is updated, but the related fields aren't autopopulated. Before updating a key attribute, consider the impact on the related attributes.
Columns
Name | Type | Description |
InvoiceId [KEY] | Long | InvoiceId of Invoices |
InvoiceNumber | String | InvoiceNumber of Invoices |
InvoiceCurrency | String | InvoiceCurrency of Invoices |
PaymentCurrency | String | PaymentCurrency of Invoices |
InvoiceAmount | Decimal | InvoiceAmount of Invoices |
InvoiceDate | Date | InvoiceDate of Invoices |
BusinessUnit | String | BusinessUnit of Invoices |
Supplier | String | Supplier of Invoices |
SupplierNumber | String | SupplierNumber of Invoices |
ProcurementBU | String | ProcurementBU of Invoices |
SupplierSite | String | SupplierSite of Invoices |
RequesterId | Long | RequesterId of Invoices |
Requester | String | Requester of Invoices |
InvoiceGroup | String | InvoiceGroup of Invoices |
ConversionRateType | String | ConversionRateType of Invoices |
ConversionDate | Date | ConversionDate of Invoices |
ConversionRate | Decimal | ConversionRate of Invoices |
AccountingDate | Date | AccountingDate of Invoices |
Description | String | Description of Invoices |
DeliveryChannelCode | String | DeliveryChannelCode of Invoices |
DeliveryChannel | String | DeliveryChannel of Invoices |
PayAloneFlag | Bool | PayAloneFlag of Invoices |
InvoiceSourceCode | String | InvoiceSourceCode of Invoices |
InvoiceSource | String | InvoiceSource of Invoices |
InvoiceType | String | InvoiceType of Invoices |
PayGroup | String | PayGroup of Invoices |
InvoiceReceivedDate | Date | InvoiceReceivedDate of Invoices |
PaymentReasonCode | String | PaymentReasonCode of Invoices |
PaymentReason | String | PaymentReason of Invoices |
PaymentReasonComments | String | PaymentReasonComments of Invoices |
RemittanceMessageOne | String | RemittanceMessageOne of Invoices |
RemittanceMessageTwo | String | RemittanceMessageTwo of Invoices |
RemittanceMessageThree | String | RemittanceMessageThree of Invoices |
PaymentTerms | String | PaymentTerms of Invoices |
TermsDate | Date | TermsDate of Invoices |
GoodsReceivedDate | Date | GoodsReceivedDate of Invoices |
PaymentMethodCode | String | PaymentMethodCode of Invoices |
PaymentMethod | String | PaymentMethod of Invoices |
SupplierTaxRegistrationNumber | String | SupplierTaxRegistrationNumber of Invoices |
FirstPartyTaxRegistrationId | Long | FirstPartyTaxRegistrationId of Invoices |
FirstPartyTaxRegistrationNumber | String | FirstPartyTaxRegistrationNumber of Invoices |
LegalEntity | String | LegalEntity of Invoices |
LegalEntityIdentifier | String | LegalEntityIdentifier of Invoices |
LiabilityDistribution | String | LiabilityDistribution of Invoices |
DocumentCategory | String | DocumentCategory of Invoices |
DocumentSequence | Long | DocumentSequence of Invoices |
VoucherNumber | String | VoucherNumber of Invoices |
ValidationStatus | String | ValidationStatus of Invoices |
ApprovalStatus | String | ApprovalStatus of Invoices |
PaidStatus | String | PaidStatus of Invoices |
AccountingStatus | String | AccountingStatus of Invoices |
ApplyAfterDate | Date | ApplyAfterDate of Invoices |
CanceledFlag | Bool | CanceledFlag of Invoices |
AmountPaid | Decimal | AmountPaid of Invoices |
BaseAmount | Decimal | BaseAmount of Invoices |
PurchaseOrderNumber | String | PurchaseOrderNumber of Invoices |
Party | String | Party of Invoices |
PartySite | String | PartySite of Invoices |
ControlAmount | Decimal | ControlAmount of Invoices |
DocumentFiscalClassificationCodePath | String | DocumentFiscalClassificationCodePath of Invoices |
TaxationCountry | String | TaxationCountry of Invoices |
RoutingAttribute1 | String | RoutingAttribute1 of Invoices |
RoutingAttribute2 | String | RoutingAttribute2 of Invoices |
RoutingAttribute3 | String | RoutingAttribute3 of Invoices |
RoutingAttribute4 | String | RoutingAttribute4 of Invoices |
RoutingAttribute5 | String | RoutingAttribute5 of Invoices |
AccountCodingStatus | String | AccountCodingStatus of Invoices |
BudgetDate | Date | BudgetDate of Invoices |
FundsStatus | String | FundsStatus of Invoices |
CanceledDate | Date | CanceledDate of Invoices |
CanceledBy | String | CanceledBy of Invoices |
UniqueRemittanceIdentifier | String | UniqueRemittanceIdentifier of Invoices |
UniqueRemittanceIdentifierCheckDigit | String | UniqueRemittanceIdentifierCheckDigit of Invoices |
CreationDate | Datetime | CreationDate of Invoices |
CreatedBy | String | CreatedBy of Invoices |
LastUpdatedBy | String | LastUpdatedBy of Invoices |
LastUpdateDate | Datetime | LastUpdateDate of Invoices |
LastUpdateLogin | String | LastUpdateLogin of Invoices |
BankAccount | String | BankAccount of Invoices |
SupplierIBAN | String | SupplierIBAN of Invoices |
ExternalBankAccountId | Long | ExternalBankAccountId of Invoices |
BankChargeBearer | String | BankChargeBearer of Invoices |
SettlementPriority | String | SettlementPriority of Invoices |
ReferenceKeyOne | String | ReferenceKeyOne of Invoices |
ReferenceKeyTwo | String | ReferenceKeyTwo of Invoices |
ReferenceKeyThree | String | ReferenceKeyThree of Invoices |
ReferenceKeyFour | String | ReferenceKeyFour of Invoices |
ReferenceKeyFive | String | ReferenceKeyFive of Invoices |
ProductTable | String | ProductTable of Invoices |
ImageDocumentNumber | String | ImageDocumentNumber of Invoices |
Finder | String | Finder of Invoices |