JDBC Driver for Exact Online

Build 22.0.8462

ShopOrderMaterialPlans

Usage information for the operation ShopOrderMaterialPlans.rsd.

Columns

Name Type ReadOnly Description
ID [KEY] String True

The ID column for the table ShopOrderMaterialPlans.

Backflush Int False

The Backflush column for the table ShopOrderMaterialPlans.

CalculatorType Int False

The CalculatorType column for the table ShopOrderMaterialPlans.

Created Datetime False

The Created column for the table ShopOrderMaterialPlans.

Creator String False

The Creator column for the table ShopOrderMaterialPlans.

CreatorFullName String False

The CreatorFullName column for the table ShopOrderMaterialPlans.

Description String False

The Description column for the table ShopOrderMaterialPlans.

DetailDrawing String False

The DetailDrawing column for the table ShopOrderMaterialPlans.

Division Int False

The Division column for the table ShopOrderMaterialPlans.

Item String False

The Item column for the table ShopOrderMaterialPlans.

ItemCode String False

The ItemCode column for the table ShopOrderMaterialPlans.

ItemDescription String False

The ItemDescription column for the table ShopOrderMaterialPlans.

ItemPictureUrl String False

The ItemPictureUrl column for the table ShopOrderMaterialPlans.

LineNumber Int False

The LineNumber column for the table ShopOrderMaterialPlans.

Modified Datetime False

The Modified column for the table ShopOrderMaterialPlans.

Modifier String False

The Modifier column for the table ShopOrderMaterialPlans.

ModifierFullName String False

The ModifierFullName column for the table ShopOrderMaterialPlans.

Notes String False

The Notes column for the table ShopOrderMaterialPlans.

PlannedAmountFC Double False

The PlannedAmountFC column for the table ShopOrderMaterialPlans.

PlannedDate Datetime False

The PlannedDate column for the table ShopOrderMaterialPlans.

PlannedPriceFC Double False

The PlannedPriceFC column for the table ShopOrderMaterialPlans.

PlannedQuantity Double False

The PlannedQuantity column for the table ShopOrderMaterialPlans.

PlannedQuantityFactor Double False

The PlannedQuantityFactor column for the table ShopOrderMaterialPlans.

ShopOrder String False

The ShopOrder column for the table ShopOrderMaterialPlans.

Status Int False

The Status column for the table ShopOrderMaterialPlans.

StatusDescription String False

The StatusDescription column for the table ShopOrderMaterialPlans.

Type Int False

The Type column for the table ShopOrderMaterialPlans.

Unit String False

The Unit column for the table ShopOrderMaterialPlans.

UnitDescription String False

The UnitDescription column for the table ShopOrderMaterialPlans.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462