Invoices
Invoices
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 | Double | 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 | Double | 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 | Double | AmountPaid of Invoices |
| BaseAmount | Double | BaseAmount of Invoices |
| PurchaseOrderNumber | String | PurchaseOrderNumber of Invoices |
| Party | String | Party of Invoices |
| PartySite | String | PartySite of Invoices |
| ControlAmount | Double | 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 |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |