PO
POFixedDemand
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ActiveNonexistent in DB | bool? | Active | - | |
Description:No description available | ||||
AddLeadTimeDaysNonexistent in DB | short? | Add. Lead Time (Days) | - | |
Description:No description available | ||||
BAccountID | int | BAccount | ||
Description:No description available | ||||
CostCenterID | int | INLotSerialStatusByCostCenter | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryIDNonexistent in DB | string | Currency | Currency | |
Description:Key field. Unique identifier of the currency. | ||||
DemandPlanID | bigint | INItemPlanDemand | ||
Description:No description available | ||||
DemandProjectIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
DemandUOM | nvarchar | UOM | - | |
Description:No description available | ||||
EffPriceNonexistent in DB | decimal? | Vendor Price | - | |
Description:No description available | ||||
ExcludePlanLevel | int | - | ||
Description:No description available | ||||
ExtCostNonexistent in DB | decimal? | Extended Amt. | - | |
Description:No description available | ||||
ExtVolumeNonexistent in DB | decimal? | Volume | - | |
Description:No description available | ||||
ExtWeightNonexistent in DB | decimal? | Weight | - | |
Description:No description available | ||||
FixedSource | char(1) | Fixed Source | - | |
Description:No description available | ||||
Hold | bit | On Hold | - | |
Description:No description available | ||||
IgnoreOrigPlan | bit | - | ||
Description:The field is used for breaking inheritance between plans. It may be needed, e.g., when Lot/Serial Number of the base plan differs from the derivative one. | ||||
InventoryCD | nvarchar | Inventory ID | - | |
Description:Key field. The user-friendly unique identifier of the Inventory Item. The structure of the identifier is determined by the INVENTORY Segmented Key. | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsSkippedWhenBackOrderedNonexistent in DB | bool? | - | ||
Description:The flag indicates if the record has to be skipped when backordered. | ||||
IsSpecialOrderNonexistent in DB | bool? | - | ||
Description:A Boolean value that indicates whether the line is a part of the special order. A special order is a customer order for goods that a company does not normally keep in stock (due to their nature, specific components, dimensions, attributes, etc.) or for goods that have been acquired for a specific job only at a special purchase cost from a vendor. The special-ordered items must maintain their cost from purchase to sale and are not included in inventory cost calculations. | ||||
IsTempLotSerialNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsTemporaryNonexistent in DB | bool? | - | ||
Description:The flag indicates if the record is not for persistence | ||||
ItemClassCD | nvarchar(30) | Class ID | INItemClass | |
Description:No description available | ||||
ItemStatus | nvarchar | Item Status | - | |
Description:The status of the Inventory Item. Possible values are: ""AC"" - Active (can be used in inventory operations, such as issues and receipts), ""NS"" - No Sales (cannot be sold), ""NP"" - No Purchases (cannot be purchased), ""NR"" - No Request (cannot be used on requisition requests), ""IN"" - Inactive, ""DE"" - Marked for Deletion. Defaults to Active (""AC""). | ||||
KitInventoryID | int | Inventory ID | InventoryItem | |
Description:An identifier of a non-stock kit item that is associated with this component plan. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LocalizedPlanDescrNonexistent in DB | string | Plan Type | - | |
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | INLotSerialStatusByCostCenter | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrderQtyNonexistent in DB | decimal? | Quantity | - | |
Description:No description available | ||||
OrigNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigPlanID | bigint | INItemPlanOrig | ||
Description:No description available | ||||
OrigPlanLevel | int | - | ||
Description:No description available | ||||
OrigPlanType | char(2) | Orig. Plan Type | INPlanType | |
Description:No description available | ||||
OrigUOM | nvarchar(6) | - | ||
Description:No description available | ||||
POSiteID | int | Warehouse | INSite | |
Description:No description available | ||||
PlanDate | datetime | Planned On | - | |
Description:No description available | ||||
PlanDescr | nvarchar(60) | - | ||
Description:No description available | ||||
PlanID | bigint | - | ||
Description:No description available | ||||
PlanQty | decimal | Requested Qty. | - | |
Description:No description available | ||||
PlanType | char(2) | Plan Type | INPlanType | |
Description:No description available | ||||
PlanUnitQtyNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
PriceRecordIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
ProjectID | int | - | ||
Description:No description available | ||||
RefEntityType | varchar(255) | - | ||
Description:No description available | ||||
RefNoteID | uniqueidentifier | Reference Nbr. | - | |
Description:No description available | ||||
RequestedDate | datetime | Requested On | - | |
Description:No description available | ||||
Reverse | bit | Reverse | - | |
Description:No description available | ||||
SalesBranchIDNonexistent in DB | int? | - | ||
Description:The identifier of the branch. The field is included in the FK.Branch foreign key. The value of this field corresponds to the value of the Branch.branchID field. | ||||
SalesCustomerIDNonexistent in DB | int? | Customer | BAccountR | |
Description:The identifier of the customer. The field is a part of the identifier of the customer location. The field is included in the foreign keys FK.Customer and FK.CustomerLocation. For a customer, the value of this field corresponds to the value of the Customer.bAccountID field. For a customer location, the value of this field corresponds to the value of the Location.bAccountID field. | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SorterStringNonexistent in DB | string | - | ||
Description:Defines the order in which demands are processed upon Purchase Order creation. | ||||
SourceSiteDescrNonexistent in DB | string | Demand Warehouse Description | - | |
Description:No description available | ||||
SourceSiteID | int | Demand Warehouse | INSite | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
SupplyPlanID | bigint | INItemPlanSupply | ||
Description:No description available | ||||
TaskID | int | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | - | ||
Description:No description available | ||||
UnitMultDiv | char(1) | - | ||
Description:No description available | ||||
UnitRate | decimal | - | ||
Description:No description available | ||||
VendorID | int | Vendor | Vendor | |
Description:The identifier of the business account. This field is auto-incremental. This field is a surrogate key, as opposed to the natural key AcctCD. | ||||
VendorLocationID | int | Location | Location | |
Description:The unique identifier assigned to the location. This field is the primary key field. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||