InventoryConsumptionAdvicesconsumptionAdviceLines
InventoryConsumptionAdvicesconsumptionAdviceLines
Columns
| Name | Type | Description |
| InventoryConsumptionAdvicesConsumptionHeaderId [KEY] | Long | InventoryConsumptionAdvicesConsumptionHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLines |
| InventoryConsumptionAdvicesRevision [KEY] | Long | InventoryConsumptionAdvicesRevision of InventoryConsumptionAdvicesconsumptionAdviceLines |
| ConsumptionLineId [KEY] | Long | ConsumptionLineId of InventoryConsumptionAdvicesconsumptionAdviceLines |
| ConsumptionAdviceLine | Double | ConsumptionAdviceLine of InventoryConsumptionAdvicesconsumptionAdviceLines |
| ConsumptionHeaderId | Long | ConsumptionHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLines |
| PurchaseAgreementLine | Double | PurchaseAgreementLine of InventoryConsumptionAdvicesconsumptionAdviceLines |
| PurchaseAgreementLineId | Long | PurchaseAgreementLineId of InventoryConsumptionAdvicesconsumptionAdviceLines |
| ConsumedQuantity | Double | ConsumedQuantity of InventoryConsumptionAdvicesconsumptionAdviceLines |
| ConsumedQuantityUOMCode | String | ConsumedQuantityUOMCode of InventoryConsumptionAdvicesconsumptionAdviceLines |
| ConsumedQuantityUnitOfMeasure | String | ConsumedQuantityUnitOfMeasure of InventoryConsumptionAdvicesconsumptionAdviceLines |
| InventoryItemId | Long | InventoryItemId of InventoryConsumptionAdvicesconsumptionAdviceLines |
| ItemNumber | String | ItemNumber of InventoryConsumptionAdvicesconsumptionAdviceLines |
| ItemDescription | String | ItemDescription of InventoryConsumptionAdvicesconsumptionAdviceLines |
| InventoryOrganizationId | Long | InventoryOrganizationId of InventoryConsumptionAdvicesconsumptionAdviceLines |
| OrganizationName | String | OrganizationName of InventoryConsumptionAdvicesconsumptionAdviceLines |
| OrganizationCode | String | OrganizationCode of InventoryConsumptionAdvicesconsumptionAdviceLines |
| POHeaderId | Long | POHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLines |
| PONumber | String | PONumber of InventoryConsumptionAdvicesconsumptionAdviceLines |
| POLineId | Long | POLineId of InventoryConsumptionAdvicesconsumptionAdviceLines |
| POLineNumber | Double | POLineNumber of InventoryConsumptionAdvicesconsumptionAdviceLines |
| POScheduleId | Long | POScheduleId of InventoryConsumptionAdvicesconsumptionAdviceLines |
| POScheduleNumber | Double | POScheduleNumber of InventoryConsumptionAdvicesconsumptionAdviceLines |
| SecondaryConsumedQuantity | Double | SecondaryConsumedQuantity of InventoryConsumptionAdvicesconsumptionAdviceLines |
| SecondaryQuantityUOMCode | String | SecondaryQuantityUOMCode of InventoryConsumptionAdvicesconsumptionAdviceLines |
| SecondaryQuantityUnitOfMeasure | String | SecondaryQuantityUnitOfMeasure of InventoryConsumptionAdvicesconsumptionAdviceLines |
| TransactionDate | Date | TransactionDate of InventoryConsumptionAdvicesconsumptionAdviceLines |
| TransactionTypeId | Long | TransactionTypeId of InventoryConsumptionAdvicesconsumptionAdviceLines |
| TransactionTypeName | String | TransactionTypeName of InventoryConsumptionAdvicesconsumptionAdviceLines |
| ShipmentReceiptNumber | String | ShipmentReceiptNumber of InventoryConsumptionAdvicesconsumptionAdviceLines |
| ShipmentHeaderId | Long | ShipmentHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLines |
| ReceiptLineNumber | Long | ReceiptLineNumber of InventoryConsumptionAdvicesconsumptionAdviceLines |
| ShipmentLineId | Long | ShipmentLineId of InventoryConsumptionAdvicesconsumptionAdviceLines |
| CurrencyCode | String | CurrencyCode of InventoryConsumptionAdvicesconsumptionAdviceLines |
| UnitPrice | Double | UnitPrice of InventoryConsumptionAdvicesconsumptionAdviceLines |
| ExtendedPrice | Double | ExtendedPrice of InventoryConsumptionAdvicesconsumptionAdviceLines |
| RevisionNumber | Long | RevisionNumber of InventoryConsumptionAdvicesconsumptionAdviceLines |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Revision | Long | Revision |
| Finder | String | finder |