IN
INPIHeader
PX.Objects.IN28 of 28 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
PIID | nvarchar(15) | Reference Nbr. | - | |
Description:No description available | ||||
BaseCuryIDNonexistent in DB | nvarchar(5) | Currency | - | |
Description:No description available | ||||
CountDate | datetime2 | Freeze Date | - | |
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 | ||||
Descr | nvarchar(256) | Description | - | |
Description:No description available | ||||
FinPeriodID | char(6) | - | ||
Description:No description available | ||||
FirstTagNbr | int | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LineCntr | int | Number Of Lines | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PIAdjAcctID | int | Account | Account | |
Description:No description available | ||||
PIAdjRefNbr | nvarchar(15) | Adjustment Ref. Nbr. | INRegister | |
Description:No description available | ||||
PIAdjSubID | int | Subaccount | Sub | |
Description:No description available | ||||
PIClassID | nvarchar(30) | INPIClass | ||
Description:No description available | ||||
PIRcptRefNbr | nvarchar(15) | Receipt Ref. Nbr. | INRegister | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
TagNumbered | bit | Tag Numbered | - | |
Description:No description available | ||||
TotalNbrOfTags | int | Number Of Tags | - | |
Description:No description available | ||||
TotalPhysicalQty | decimal(25, 6) | Total Physical Qty. | - | |
Description:No description available | ||||
TotalVarCost | decimal(19, 6) | Total Variance Cost | - | |
Description:No description available | ||||
TotalVarQty | decimal(25, 6) | Total Variance Qty. | - | |
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||