InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Columns
| Name | Type | Description |
| InventoryConsumptionAdvicesConsumptionHeaderId [KEY] | Long | InventoryConsumptionAdvicesConsumptionHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| InventoryConsumptionAdvicesRevision [KEY] | Long | InventoryConsumptionAdvicesRevision of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ConsumptionadvicelinesConsumptionLineId [KEY] | Long | ConsumptionadvicelinesConsumptionLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransactionId [KEY] | Long | TransactionId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Item | String | Item of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ItemDescription | String | ItemDescription of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| InventoryItemId | Long | InventoryItemId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Revision | String | Revision of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| SubinventoryCode | String | SubinventoryCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| SubinventoryId | Long | SubinventoryId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| LocatorId | Long | LocatorId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Locator | String | Locator of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransactionQuantity | Double | TransactionQuantity of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransactionUOMCode | String | TransactionUOMCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransactionUOM | String | TransactionUOM of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransactionDate | Datetime | TransactionDate of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransactionTypeId | Long | TransactionTypeId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransactionType | String | TransactionType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransactionSourceTypeId | Long | TransactionSourceTypeId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransactionSourceType | String | TransactionSourceType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| SourceReference | String | SourceReference of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Account | String | Account of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Reason | String | Reason of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Reference | String | Reference of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ErrorExplanation | String | ErrorExplanation of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferOrganization | String | TransferOrganization of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferOrganizationCode | String | TransferOrganizationCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferOrganizationId | Long | TransferOrganizationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferOrgLocation | String | TransferOrgLocation of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferOrgLocationId | Double | TransferOrgLocationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferSubinventory | String | TransferSubinventory of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferSubinventoryCode | String | TransferSubinventoryCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferLocator | String | TransferLocator of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferLocatorId | Long | TransferLocatorId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferBusinessUnit | String | TransferBusinessUnit of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Quantity | Double | Quantity of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| UOMName | String | UOMName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| PrimaryUOMCode | String | PrimaryUOMCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| SecondaryQuantity | Double | SecondaryQuantity of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| SecondaryUOM | String | SecondaryUOM of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| SecondaryUOMCode | String | SecondaryUOMCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Source | String | Source of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| SourceLine | Long | SourceLine of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransactionAction | String | TransactionAction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransactionActionId | Long | TransactionActionId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransactionSet | Long | TransactionSet of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferTransaction | Long | TransferTransaction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ReceivingTransaction | Long | ReceivingTransaction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Costed | String | Costed of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| AssetTrackingStatus | String | AssetTrackingStatus of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| AlmInterfaceStatus | String | AlmInterfaceStatus of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| PickSlip | Long | PickSlip of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| PackingUnit | String | PackingUnit of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ReceiptRequiredAtExpenseDestination | String | ReceiptRequiredAtExpenseDestination of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ManualReceiptExpense | String | ManualReceiptExpense of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Location | String | Location of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ShipToLocationId | Long | ShipToLocationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| LocationType | String | LocationType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Shipment | String | Shipment of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Waybill | String | Waybill of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Carrier | String | Carrier of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| FreightCode | String | FreightCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| NumberOfContainers | Long | NumberOfContainers of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| OwningPartyType | String | OwningPartyType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| OwningTpType | Long | OwningTpType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferOwningTpType | Long | TransferOwningTpType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| OwningParty | String | OwningParty of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| OwningPartySite | String | OwningPartySite of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferOwningPartyType | String | TransferOwningPartyType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferOwningParty | String | TransferOwningParty of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferOwningPartySite | String | TransferOwningPartySite of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ConsumptionAdvice | String | ConsumptionAdvice of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ConsumptionAdviceLine | String | ConsumptionAdviceLine of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ConsumptionLineId | Long | ConsumptionLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| PurchaseOrder | String | PurchaseOrder of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| PurchaseOrderHeaderId | String | PurchaseOrderHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| PurchaseOrderLineId | String | PurchaseOrderLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| PurchaseOrderLine | String | PurchaseOrderLine of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ParentTransaction | Long | ParentTransaction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Receipt | String | Receipt of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| RcvShipmentHeaderId | Long | RcvShipmentHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ReceiptLine | String | ReceiptLine of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| RcvShipmentLineId | String | RcvShipmentLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ConsumptionAdviceError | String | ConsumptionAdviceError of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ConsumptionAdviceErrorAction | String | ConsumptionAdviceErrorAction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| AssociatedOwnershipChangeTransaction | Long | AssociatedOwnershipChangeTransaction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TaxationCountry | String | TaxationCountry of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| DefaultTaxationCountry | String | DefaultTaxationCountry of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransactionBusinessCategory | String | TransactionBusinessCategory of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TrxBusinessCategory | String | TrxBusinessCategory of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| DocumentFiscalClassification | String | DocumentFiscalClassification of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| DocumentSubType | String | DocumentSubType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| UserDefinedFiscalClassification | String | UserDefinedFiscalClassification of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| UserDefinedFiscClass | String | UserDefinedFiscClass of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ProductFiscalClassification | String | ProductFiscalClassification of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| CategoryId | Long | CategoryId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| IntendedUse | String | IntendedUse of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| IntendedUseClassifId | Long | IntendedUseClassifId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| LocationOfFinalDischarge | String | LocationOfFinalDischarge of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ProductCategory | String | ProductCategory of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ProductCategoryCode | String | ProductCategoryCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TaxClassificationCode | String | TaxClassificationCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TaxClassification | String | TaxClassification of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ProductType | String | ProductType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ProductTypeCode | String | ProductTypeCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| FirstPartyTaxRegistrationNumber | String | FirstPartyTaxRegistrationNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| FirstPtyRegId | Long | FirstPtyRegId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ThirdPartyTaxRegistrationNumber | String | ThirdPartyTaxRegistrationNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ThirdPtyRegId | Long | ThirdPtyRegId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ShipFromSite | String | ShipFromSite of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ShipFromLocationId | Long | ShipFromLocationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TaxInvoiceNumber | String | TaxInvoiceNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TaxInvoiceDate | Date | TaxInvoiceDate of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| AssessableValue | Double | AssessableValue of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Currency | String | Currency of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TaxExemptionCertificateNumber | String | TaxExemptionCertificateNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TaxExemptReasonCode | String | TaxExemptReasonCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ExemptReasonCode | String | ExemptReasonCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| OperationNumber | String | OperationNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| OperationSequenceNumber | Long | OperationSequenceNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| OperationSequenceNumberId | Long | OperationSequenceNumberId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| OperationTransaction | Long | OperationTransaction of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| WIPSupplyType | String | WIPSupplyType of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| WIPSupplyTypeCode | Double | WIPSupplyTypeCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| WorkCenter | String | WorkCenter of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| DepartmentCode | String | DepartmentCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| DepartmentId | Long | DepartmentId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| AssemblySerialNumber | String | AssemblySerialNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ElectronicSignature | Long | ElectronicSignature of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Organization | String | Organization of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| OrganizationName | String | OrganizationName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| OrganizationId | Long | OrganizationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| OwningPartyOrgName | String | OwningPartyOrgName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| OwningPartyLocation | String | OwningPartyLocation of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| OwningPartyLocationId | Long | OwningPartyLocationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| LotTransactionGroupName | String | LotTransactionGroupName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| SourceLotFlag | Bool | SourceLotFlag of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransactionSourceName | String | TransactionSourceName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransactionSourceId | Long | TransactionSourceId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ReasonId | Long | ReasonId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ConsErrorTypeCode | String | ConsErrorTypeCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ConsErrorActionCode | String | ConsErrorActionCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| OwningOrganizationId | Long | OwningOrganizationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| XfrOwningOrganizationId | Long | XfrOwningOrganizationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| StructureInstanceNumber | Long | StructureInstanceNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| CreationDate | Datetime | CreationDate of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| CreatedBy | String | CreatedBy of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Category | String | Category of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| Lot | String | Lot of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| SerialNumber | String | SerialNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| SupplierLot | String | SupplierLot of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ExternalSystemPackingUnit | String | ExternalSystemPackingUnit of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| DistributionAccountId | Long | DistributionAccountId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| FinalDischargeLocationId | Long | FinalDischargeLocationId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ProjectId | Double | ProjectId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TaskId | Double | TaskId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| CountryOfOriginCode | String | CountryOfOriginCode of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ProjectNumber | String | ProjectNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TaskNumber | String | TaskNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| CountryOfOrigin | String | CountryOfOrigin of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferProjectId | Long | TransferProjectId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferTaskId | Long | TransferTaskId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferProjectNumber | String | TransferProjectNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| TransferTaskNumber | String | TransferTaskNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| RequesterId | Long | RequesterId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| RequesterName | String | RequesterName of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| ExternalSystemTransactionReference | String | ExternalSystemTransactionReference of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| MovementRequestLineId | Long | MovementRequestLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
| LoadRequestId | Long | LoadRequestId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ConsumptionHeaderId | Long | ConsumptionHeaderId |
| Finder | String | finder |