ReceivablesInvoicesreceivablesInvoiceLines
ReceivablesInvoicesreceivablesInvoiceLines
Columns
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId [KEY] | Long | ReceivablesInvoicesCustomerTransactionId of ReceivablesInvoicesreceivablesInvoiceLines |
| CustomerTransactionLineId [KEY] | Long | The line resource is used to identify each of the separate lines of a transaction. |
| LineNumber | Double | The line number of the invoice. |
| Description | String | The description that identifies the product or service on the invoice line. |
| Quantity | Double | The quantity of products or services referred to on the invoice line. |
| UnitSellingPrice | Double | The price of an individual item on the invoice line. |
| TaxClassificationCode | String | The tax classification code for the invoice line. |
| SalesOrder | String | The sales order number on the invoice line. |
| AccountingRuleDuration | Long | The number of periods in which revenue is to be recognized. A value is required for invoice lines with fixed and variable duration rules. |
| RuleEndDate | Date | The end date of the revenue scheduling rule. This is applicable for invoices with rules. |
| RuleStartDate | Date | The start date of the revenue scheduling rule. This is applicable for invoices with rules. |
| AccountingRule | String | The rule representing the revenue recognition method to be applied to the invoice line. |
| Warehouse | String | The ship-from location for the item on the invoice line. This value applies to inventory items. |
| MemoLine | String | The memo line that identifies the product or service on the invoice line. |
| UnitOfMeasure | String | The unit of measure used for the product or service on the invoice line. |
| ItemNumber | String | The number that identifies the inventory item on the invoice line. |
| AllocatedFreightAmount | Double | The freight amount applicable for the Invoice lines. |
| AssessableValue | Double | The assessable value tax determinant. |
| SalesOrderDate | Date | The sales order date. |
| LineAmount | Double | The transaction line amount. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date and time the record was created. |
| LastUpdatedBy | String | The user who last updated the record. |
| LastUpdateDate | Datetime | The date on which the record is last updated. |
| TransacationBusinessCategory | String | The transaction business category tax determinant. |
| UserDefinedFiscalClassification | String | The user defined fiscal classification tax determinant. |
| ProductFiscalClassification | String | The product fiscal classification tax determinant. |
| ProductCategory | String | The product category tax determinant. |
| ProductType | String | The product type tax determinant. |
| LineIntendedUse | String | The transaction line intended use tax determinant. |
| LineAmountIncludesTax | String | The flag that indicates whether the tax is inclusive, exclusive or should calculate based on the tax setup. |
| TaxInvoiceDate | Date | The date the tax invoice document is generated. |
| TaxInvoiceNumber | String | A unique identifier of the fiscal document supporting the sale, which is generated upon shipment of goods. |
| TaxExemptionCertificateNumber | String | Document that certifies that a party or product is partially or fully exempt from a tax. |
| TaxExemptionHandling | String | Value that indicates how to process tax exemptions on invoice lines. |
| TaxExemptionReason | String | Reason that a customer has a tax exemption. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AccountingDate | Date | AccountingDate |
| AllowCompletion | String | AllowCompletion |
| BillToCustomerName | String | BillToCustomerName |
| BillToCustomerNumber | String | BillToCustomerNumber |
| BillToSite | String | BillToSite |
| BillingDate | Date | BillingDate |
| BusinessUnit | String | BusinessUnit |
| CrossReference | String | CrossReference |
| CustomerTransactionId | Long | CustomerTransactionId |
| DocumentNumber | Long | DocumentNumber |
| DueDate | Date | DueDate |
| FirstPartyTaxRegistration | String | FirstPartyTaxRegistration |
| InvoiceCurrencyCode | String | InvoiceCurrencyCode |
| InvoiceStatus | String | InvoiceStatus |
| LegalEntityIdentifier | String | LegalEntityIdentifier |
| PaymentTerms | String | PaymentTerms |
| PurchaseOrder | String | PurchaseOrder |
| ShipToCustomerName | String | ShipToCustomerName |
| ShipToSite | String | ShipToSite |
| ThirdPartyTaxRegistration | String | ThirdPartyTaxRegistration |
| TransactionDate | Date | TransactionDate |
| TransactionNumber | String | TransactionNumber |
| TransactionSource | String | TransactionSource |
| TransactionType | String | TransactionType |
| Finder | String | finder |