InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceTransactions
Columns
| Name | Type | 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 | 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 | consumptionheaderid |
| Finder | String | finder |