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 |