IN
INRegister
PX.Objects.INView API Entity: InventoryAdjustment
/entity/Default/24.200.001/InventoryAdjustment54 of 54 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
DocType | char(1) | Document Type | - | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Reference Nbr. | INRegister | |
Description:No description available | ||||
BatchNbr | nvarchar(15) | Batch Nbr. | Batch | |
Description:No description available | ||||
BranchBaseCuryIDNonexistent in DB | nvarchar(5) | Currency | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
ControlAmount | decimal(19, 4) | Control Amount | - | |
Description:No description available | ||||
ControlCost | decimal(19, 4) | Control Cost | - | |
Description:No description available | ||||
ControlQty | decimal(25, 6) | Control Qty. | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
ExtRefNbr | nvarchar(40) | External Ref. | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
Hold API | bit | Hold | - | |
Description:No description available | ||||
IgnoreAllocationErrors | bit | Ignore Item Allocations | - | |
Description:A Boolean value that indicates whether the system should skip verification of inventory item allocations that can be broken by negative adjustment. | ||||
IsCorrection | bit | - | ||
Description:A stored field indicating if the document is created from a Correction PO Receipt | ||||
IsPPVTran | bit | - | ||
Description:No description available | ||||
IsTaxAdjustmentTran | bit | - | ||
Description:No description available | ||||
KitInventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
KitLineNbr | int | INTran | ||
Description:No description available | ||||
KitRequestDate | datetime2 | Requested On | - | |
Description:This field contains the request date of a Kit Assembly which will be used to drive allocation demand for components | ||||
KitRevisionID | nvarchar(10) | Revision | INKitSpecHdr | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime API | datetime | Last Modified On | - | |
Description:No description available | ||||
LineCntr | int | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigModule | char(2) | Source | - | |
Description:No description available | ||||
OrigReceiptNbr | nvarchar(15) | - | ||
Description:If the document is created from a Correction PO Receipt this field references the original IN Receipt | ||||
OrigRefNbr | nvarchar(15) | - | ||
Description:No description available | ||||
PIID | nvarchar(15) | PI Count Reference Nbr. | INPIHeader | |
Description:No description available | ||||
POReceiptNbr | nvarchar(15) | PO Receipt Nbr. | POReceipt | |
Description:No description available | ||||
POReceiptType | char(2) | PO Receipt Type | - | |
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
ReleasedToVerifyNonexistent in DB | bit | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse ID | INSite | |
Description:No description available | ||||
SOOrderNbr | nvarchar(15) | SO Order Nbr. | SOOrder | |
Description:No description available | ||||
SOOrderType | char(2) | SO Order Type | SOOrderType | |
Description:No description available | ||||
SOShipmentNbr | nvarchar(15) | SO Shipment Nbr. | SOShipment | |
Description:No description available | ||||
SOShipmentType | char(1) | - | ||
Description:No description available | ||||
SrcDocTypeNonexistent in DB | nvarchar(3) | - | ||
Description:The field is used for consolidation by source document (Shipment or Invoice for direct stock item lines) of IN Issues created from one Invoice | ||||
SrcRefNbrNonexistent in DB | nvarchar(15) | - | ||
Description:The field is used for consolidation by source document (Shipment or Invoice for direct stock item lines) of IN Issues created from one Invoice | ||||
Status API | char(1) | Status | - | |
Description:No description available | ||||
ToSiteID | int | To Warehouse ID | INSite | |
Description:No description available | ||||
TotalAmount | decimal(19, 4) | Total Amount | - | |
Description:No description available | ||||
TotalCost API | decimal(19, 4) | Total Cost | - | |
Description:No description available | ||||
TotalQty API | decimal(25, 6) | Total Qty. | - | |
Description:No description available | ||||
TranDate | datetime2 | Date | - | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Description | - | |
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
TransferNbr | nvarchar(15) | Transfer Nbr. | - | |
Description:Field used in INReceiptEntry screen. | ||||
TransferType | char(1) | Transfer Type | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||