ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineDFF
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineDFF
Columns
Name | Type | Description |
ReceivablesInvoicesCustomerTransactionId [KEY] | Long | ReceivablesInvoicesCustomerTransactionId of ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineDFF |
ReceivablesinvoicelinesCustomerTransactionLineId [KEY] | Long | ReceivablesinvoicelinesCustomerTransactionLineId of ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineDFF |
CustomerTrxLineId [KEY] | Long | The unique identifier of the invoice line descriptive flexfield. |
_FLEX_Context | String | The invoice line descriptive flexfield context segment. |
_FLEX_Context_DisplayValue | String | The invoice line descriptive flexfield context segment displayed value. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
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 |