Invoices
Invoices
Columns
Name | Type | Description |
InvoiceId [KEY] | String | InvoiceId |
InvoiceNumber | String | InvoiceNumber |
InvoiceCurrency | String | InvoiceCurrency |
PaymentCurrency | String | PaymentCurrency |
InvoiceAmount | String | InvoiceAmount |
InvoiceDate | Date | InvoiceDate |
BusinessUnit | String | BusinessUnit |
Supplier | String | Supplier |
SupplierNumber | String | SupplierNumber |
ProcurementBU | String | ProcurementBU |
SupplierSite | String | SupplierSite |
RequesterId | String | RequesterId |
Requester | String | Requester |
InvoiceGroup | String | InvoiceGroup |
ConversionRateType | String | ConversionRateType |
ConversionDate | Date | ConversionDate |
ConversionRate | String | ConversionRate |
AccountingDate | Date | AccountingDate |
Description | String | Description |
DeliveryChannelCode | String | DeliveryChannelCode |
DeliveryChannel | String | DeliveryChannel |
PayAloneFlag | Bool | PayAloneFlag |
InvoiceSourceCode | String | InvoiceSourceCode |
InvoiceSource | String | InvoiceSource |
InvoiceType | String | InvoiceType |
PayGroup | String | PayGroup |
InvoiceReceivedDate | Date | InvoiceReceivedDate |
PaymentReasonCode | String | PaymentReasonCode |
PaymentReason | String | PaymentReason |
PaymentReasonComments | String | PaymentReasonComments |
RemittanceMessageOne | String | RemittanceMessageOne |
RemittanceMessageTwo | String | RemittanceMessageTwo |
RemittanceMessageThree | String | RemittanceMessageThree |
PaymentTerms | String | PaymentTerms |
TermsDate | Date | TermsDate |
GoodsReceivedDate | Date | GoodsReceivedDate |
PaymentMethodCode | String | PaymentMethodCode |
PaymentMethod | String | PaymentMethod |
SupplierTaxRegistrationNumber | String | SupplierTaxRegistrationNumber |
FirstPartyTaxRegistrationId | String | FirstPartyTaxRegistrationId |
FirstPartyTaxRegistrationNumber | String | FirstPartyTaxRegistrationNumber |
LegalEntity | String | LegalEntity |
LegalEntityIdentifier | String | LegalEntityIdentifier |
LiabilityDistribution | String | LiabilityDistribution |
DocumentCategory | String | DocumentCategory |
DocumentSequence | String | DocumentSequence |
VoucherNumber | String | VoucherNumber |
ValidationStatus | String | ValidationStatus |
ApprovalStatus | String | ApprovalStatus |
PaidStatus | String | PaidStatus |
AccountingStatus | String | AccountingStatus |
ApplyAfterDate | Date | ApplyAfterDate |
CanceledFlag | Bool | CanceledFlag |
AmountPaid | String | AmountPaid |
BaseAmount | String | BaseAmount |
PurchaseOrderNumber | String | PurchaseOrderNumber |
Party | String | Party |
PartySite | String | PartySite |
ControlAmount | String | ControlAmount |
DocumentFiscalClassificationCodePath | String | DocumentFiscalClassificationCodePath |
TaxationCountry | String | TaxationCountry |
RoutingAttribute1 | String | RoutingAttribute1 |
RoutingAttribute2 | String | RoutingAttribute2 |
RoutingAttribute3 | String | RoutingAttribute3 |
RoutingAttribute4 | String | RoutingAttribute4 |
RoutingAttribute5 | String | RoutingAttribute5 |
AccountCodingStatus | String | AccountCodingStatus |
BudgetDate | Date | BudgetDate |
FundsStatus | String | FundsStatus |
CanceledDate | Date | CanceledDate |
CanceledBy | String | CanceledBy |
UniqueRemittanceIdentifier | String | UniqueRemittanceIdentifier |
UniqueRemittanceIdentifierCheckDigit | String | UniqueRemittanceIdentifierCheckDigit |
CreationDate | Datetime | CreationDate |
CreatedBy | String | CreatedBy |
LastUpdatedBy | String | LastUpdatedBy |
LastUpdateDate | Datetime | LastUpdateDate |
LastUpdateLogin | String | LastUpdateLogin |
BankAccount | String | BankAccount |
SupplierIBAN | String | SupplierIBAN |
ExternalBankAccountId | String | ExternalBankAccountId |
BankChargeBearer | String | BankChargeBearer |
SettlementPriority | String | SettlementPriority |
ReferenceKeyOne | String | ReferenceKeyOne |
ReferenceKeyTwo | String | ReferenceKeyTwo |
ReferenceKeyThree | String | ReferenceKeyThree |
ReferenceKeyFour | String | ReferenceKeyFour |
ReferenceKeyFive | String | ReferenceKeyFive |
ProductTable | String | ProductTable |
ImageDocumentNumber | String | ImageDocumentNumber |