InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Columns
| Name | Type | SupportedFinders | Description |
| InventoryConsumptionAdvicesConsumptionHeaderId [KEY] | Long | InventoryConsumptionAdvicesConsumptionHeaderId | |
| InventoryConsumptionAdvicesRevision [KEY] | Long | InventoryConsumptionAdvicesRevision | |
| InventoryConsumptionAdvicesLegalEntityId | Long | InventoryConsumptionAdvicesLegalEntityId | |
| InventoryConsumptionAdvicesSupplier | String | InventoryConsumptionAdvicesSupplier | |
| InventoryConsumptionAdvicesConsumptionAdvice | String | InventoryConsumptionAdvicesConsumptionAdvice | |
| InventoryConsumptionAdvicesSupplierId | Long | InventoryConsumptionAdvicesSupplierId | |
| InventoryConsumptionAdvicesLegalEntityName | String | InventoryConsumptionAdvicesLegalEntityName | |
| InventoryConsumptionAdvicesCreationDate | Date | InventoryConsumptionAdvicesCreationDate | |
| ConsumptionadvicelinesConsumptionLineId [KEY] | Long | ConsumptionadvicelinesConsumptionLineId | |
| TransactionId [KEY] | Long | TransactionId | |
| Item | String | Item | |
| ItemDescription | String | ItemDescription | |
| InventoryItemId | Long | InventoryItemId | |
| Revision | String | PrimaryKey | Revision |
| SubinventoryCode | String | SubinventoryCode | |
| SubinventoryId | Long | SubinventoryId | |
| LocatorId | Long | LocatorId | |
| Locator | String | Locator | |
| TransactionQuantity | Decimal | TransactionQuantity | |
| TransactionUOMCode | String | TransactionUOMCode | |
| TransactionUOM | String | TransactionUOM | |
| TransactionDate | Datetime | TransactionDate | |
| TransactionTypeId | Long | TransactionTypeId | |
| TransactionType | String | TransactionType | |
| TransactionSourceTypeId | Long | TransactionSourceTypeId | |
| TransactionSourceType | String | TransactionSourceType | |
| SourceReference | String | SourceReference | |
| Account | String | Account | |
| Reason | String | Reason | |
| Reference | String | Reference | |
| ErrorExplanation | String | ErrorExplanation | |
| TransferOrganization | String | TransferOrganization | |
| TransferOrganizationCode | String | TransferOrganizationCode | |
| TransferOrganizationId | Long | TransferOrganizationId | |
| TransferOrgLocation | String | TransferOrgLocation | |
| TransferOrgLocationId | Decimal | TransferOrgLocationId | |
| TransferSubinventory | String | TransferSubinventory | |
| TransferSubinventoryCode | String | TransferSubinventoryCode | |
| TransferLocator | String | TransferLocator | |
| TransferLocatorId | Long | TransferLocatorId | |
| TransferBusinessUnit | String | TransferBusinessUnit | |
| Quantity | Decimal | Quantity | |
| UOMName | String | UOMName | |
| PrimaryUOMCode | String | PrimaryUOMCode | |
| SecondaryQuantity | Decimal | SecondaryQuantity | |
| SecondaryUOMCode | String | SecondaryUOMCode | |
| Source | String | Source | |
| SourceLine | Long | SourceLine | |
| TransactionAction | String | TransactionAction | |
| TransactionActionId | Long | TransactionActionId | |
| TransactionSet | Long | TransactionSet | |
| TransferTransaction | Long | TransferTransaction | |
| ReceivingTransaction | Long | ReceivingTransaction | |
| Costed | String | Costed | |
| AssetTrackingStatus | String | AssetTrackingStatus | |
| AlmInterfaceStatus | String | AlmInterfaceStatus | |
| PickSlip | Long | PickSlip | |
| PackingUnit | String | PackingUnit | |
| ReceiptRequiredAtExpenseDestination | String | ReceiptRequiredAtExpenseDestination | |
| ManualReceiptExpense | String | ManualReceiptExpense | |
| Location | String | Location | |
| ShipToLocationId | Long | ShipToLocationId | |
| LocationType | String | LocationType | |
| Shipment | String | Shipment | |
| Waybill | String | Waybill | |
| Carrier | String | Carrier | |
| FreightCode | String | FreightCode | |
| NumberOfContainers | Long | NumberOfContainers | |
| OwningPartyType | String | OwningPartyType | |
| OwningTpType | Long | OwningTpType | |
| TransferOwningTpType | Long | TransferOwningTpType | |
| OwningParty | String | OwningParty | |
| OwningPartySite | String | OwningPartySite | |
| TransferOwningPartyType | String | TransferOwningPartyType | |
| TransferOwningParty | String | TransferOwningParty | |
| TransferOwningPartySite | String | TransferOwningPartySite | |
| ConsumptionAdviceStatus | String | ConsumptionAdviceStatus | |
| ConsumptionAdvice | String | ConsumptionAdvice | |
| ConsumptionAdviceLine | String | ConsumptionAdviceLine | |
| ConsumptionLineId | Long | ConsumptionLineId | |
| PurchaseOrder | String | PurchaseOrder | |
| PurchaseOrderHeaderId | String | PurchaseOrderHeaderId | |
| PurchaseOrderLineId | String | PurchaseOrderLineId | |
| PurchaseOrderLine | String | PurchaseOrderLine | |
| ParentTransaction | Long | ParentTransaction | |
| Receipt | String | Receipt | |
| RcvShipmentHeaderId | Long | RcvShipmentHeaderId | |
| ReceiptLine | String | ReceiptLine | |
| RcvShipmentLineId | String | RcvShipmentLineId | |
| ConsumptionAdviceError | String | ConsumptionAdviceError | |
| ConsumptionAdviceErrorAction | String | ConsumptionAdviceErrorAction | |
| AssociatedOwnershipChangeTransaction | Long | AssociatedOwnershipChangeTransaction | |
| TaxationCountry | String | TaxationCountry | |
| DefaultTaxationCountry | String | DefaultTaxationCountry | |
| TransactionBusinessCategory | String | TransactionBusinessCategory | |
| TrxBusinessCategory | String | TrxBusinessCategory | |
| DocumentFiscalClassification | String | DocumentFiscalClassification | |
| DocumentSubType | String | DocumentSubType | |
| UserDefinedFiscalClassification | String | UserDefinedFiscalClassification | |
| UserDefinedFiscClass | String | UserDefinedFiscClass | |
| ProductFiscalClassification | String | ProductFiscalClassification | |
| CategoryId | Long | CategoryId | |
| IntendedUse | String | IntendedUse | |
| IntendedUseClassifId | Long | IntendedUseClassifId | |
| LocationOfFinalDischarge | String | LocationOfFinalDischarge | |
| ProductCategory | String | ProductCategory | |
| ProductCategoryCode | String | ProductCategoryCode | |
| TaxClassificationCode | String | TaxClassificationCode | |
| TaxClassification | String | TaxClassification | |
| ProductType | String | ProductType | |
| ProductTypeCode | String | ProductTypeCode | |
| FirstPartyTaxRegistrationNumber | String | FirstPartyTaxRegistrationNumber | |
| FirstPtyRegId | Long | FirstPtyRegId | |
| ThirdPartyTaxRegistrationNumber | String | ThirdPartyTaxRegistrationNumber | |
| ThirdPtyRegId | Long | ThirdPtyRegId | |
| ShipFromSite | String | ShipFromSite | |
| ShipFromLocationId | Long | ShipFromLocationId | |
| TaxInvoiceNumber | String | TaxInvoiceNumber | |
| TaxInvoiceDate | Date | TaxInvoiceDate | |
| AssessableValue | Decimal | AssessableValue | |
| Currency | String | Currency | |
| TaxExemptionCertificateNumber | String | TaxExemptionCertificateNumber | |
| TaxExemptReasonCode | String | TaxExemptReasonCode | |
| ExemptReasonCode | String | ExemptReasonCode | |
| OperationNumber | String | OperationNumber | |
| OperationSequenceNumber | Long | OperationSequenceNumber | |
| OperationSequenceNumberId | Long | OperationSequenceNumberId | |
| OperationTransaction | Long | OperationTransaction | |
| WIPSupplyType | String | WIPSupplyType | |
| WIPSupplyTypeCode | Decimal | WIPSupplyTypeCode | |
| WorkCenter | String | WorkCenter | |
| DepartmentCode | String | DepartmentCode | |
| DepartmentId | Long | DepartmentId | |
| AssemblySerialNumber | String | AssemblySerialNumber | |
| ElectronicSignature | Long | ElectronicSignature | |
| Organization | String | Organization | |
| OrganizationName | String | OrganizationName | |
| OrganizationId | Long | OrganizationId | |
| OwningPartyOrgName | String | OwningPartyOrgName | |
| OwningPartyLocation | String | OwningPartyLocation | |
| OwningPartyLocationId | Long | OwningPartyLocationId | |
| LotTransactionGroupName | String | LotTransactionGroupName | |
| SourceLotFlag | Bool | SourceLotFlag | |
| TransactionSourceName | String | TransactionSourceName | |
| TransactionSourceId | Long | TransactionSourceId | |
| ReasonId | Long | ReasonId | |
| TransferCost | Decimal | TransferCost | |
| TransportationCost | Decimal | TransportationCost | |
| ConsErrorTypeCode | String | ConsErrorTypeCode | |
| ConsErrorActionCode | String | ConsErrorActionCode | |
| OwningOrganizationId | Long | OwningOrganizationId | |
| XfrOwningOrganizationId | Long | XfrOwningOrganizationId | |
| StructureInstanceNumber | Long | StructureInstanceNumber | |
| CostedStatusCode | String | CostedStatusCode | |
| ConsumptionAdviceStatusCode | String | ConsumptionAdviceStatusCode | |
| CreationDate | Datetime | CreationDate | |
| CreatedBy | String | CreatedBy | |
| Category | String | Category | |
| Lot | String | Lot | |
| SerialNumber | String | SerialNumber | |
| SupplierLot | String | SupplierLot | |
| ExternalSystemPackingUnit | String | ExternalSystemPackingUnit | |
| DistributionAccountId | Long | DistributionAccountId | |
| LotControlCode | Decimal | LotControlCode | |
| SerialNumberControlCode | Decimal | SerialNumberControlCode | |
| FinalDischargeLocationId | Long | FinalDischargeLocationId | |
| ProjectId | Decimal | ProjectId | |
| TaskId | Decimal | TaskId | |
| CountryOfOriginCode | String | CountryOfOriginCode | |
| ProjectNumber | String | ProjectNumber | |
| TaskNumber | String | TaskNumber | |
| CountryOfOrigin | String | CountryOfOrigin | |
| TransferProjectId | Long | TransferProjectId | |
| TransferTaskId | Long | TransferTaskId | |
| TransferProjectNumber | String | TransferProjectNumber | |
| TransferTaskNumber | String | TransferTaskNumber | |
| RequesterId | Long | RequesterId | |
| RequesterName | String | RequesterName | |
| ExternalSystemTransactionReference | String | ExternalSystemTransactionReference | |
| MovementRequestLineId | Long | MovementRequestLineId | |
| LoadRequestId | Long | LoadRequestId | |
| WorkOrderExternalSystemGroupId | Long | WorkOrderExternalSystemGroupId | |
| IntegrationStatus | String | IntegrationStatus | |
| SecondaryUOM | String | SecondaryUOM | |
| LotTransactionSource | String | LotTransactionSource | |
| ConsumptionHeaderId | Long | PrimaryKey | consumptionheaderid |
| Finder | String | finder |