Skip to main content
DR

ScheduleMaint.DRScheduleDetailEx

PX.Objects.DR
Field NameTypeDisplay NameForeign Key
ComponentIDDefault Navigation
intComponentINUnit
Description:No description available
DetailLineNbr
intDetail Line Nbr.-
Description:No description available
ScheduleID
intSchedule IDDRSchedule
Description:No description available
AccountIDDefault Navigation
intAccountAccount
Description:No description available
AllocationWeightResidualNonexistent in DB
decimalAllocation Weight Residual-
Description:No description available
AllowControlAccountForModuleNonexistent in DB
nvarchar(MAX)-
Description:No description available
BAccountIDDefault Navigation
intBusiness Account-
Description:No description available
BAccountTypeNonexistent in DB
nchar(2)BAccount
Description:No description available
BaseQty
decimalBase Qty.-
Description:No description available
BranchIDDefault Navigation
intBranchBranch
Description:No description available
CloseFinPeriodID
char(6)Close Period-
Description:No description available
CoTermRate
decimalCoTerm Rate-
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
varchar(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
CreditLineNbr
intCredit Line Nbr.-
Description:No description available
CuryDefAmt
decimal-
Description:No description available
CuryInfoID
bigintCurrencyInfo
Description:No description available
CuryTotalAmt
decimal-
Description:No description available
DefAcctIDDefault Navigation
intDeferral AccountAccount
Description:No description available
DefAmt
decimalDeferred Amount-
Description:No description available
DefCodeDefault Navigation
nvarchar(10)Deferral CodeDRDeferredCode
Description:No description available
DefCodeTypeNonexistent in DB
nvarchar(1)DRDeferredCode
Description:No description available
DefSubIDDefault Navigation
intDeferral Sub.Sub
Description:No description available
DefTotalNonexistent in DB
decimalLine Total-
Description:No description available
DiscountPercent
decimalDiscount Percent-
Description:No description available
DocDate
datetime2Date-
Description:No description available
DocType
char(3)Doc. Type-
Description:No description available
DocumentTypeNonexistent in DB
nchar(3)Doc. Type-
Description:No description available
EffectiveFairValuePrice
decimalEffective Fair Value Price-
Description:No description available
FairValueCuryID
nvarchar(5)Fair Value Currency-
Description:No description available
FairValuePrice
decimalFair Value Price-
Description:No description available
FinPeriodIDDefault Navigation
char(6)Post Period-
Description:No description available
IsCustom
bitIs Custom-
Description:No description available
IsOpen
bitIsOpen-
Description:No description available
IsResidual
bit-
Description:No description available
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
varchar(8)-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
LastRecFinPeriodID
char(6)Last Recognition Period-
Description:No description available
LineCntr
int-
Description:No description available
LineNbr
intLine Nbr.-
Description:No description available
Module
char(2)Module-
Description:No description available
ParentInventoryIDNonexistent in DB
int-
Description:No description available
Percentage
decimalShare-
Description:No description available
PONbrNonexistent in DB
nvarchar(15)-
Description:No description available
ProjectIDDefault Navigation
intContract IDPMProject
Description:No description available
Qty
decimalQuantity-
Description:No description available
ReceiptNbrNonexistent in DB
nvarchar(15)-
Description:No description available
RefNbrDefault Navigation
nvarchar(15)Ref. Nbr.-
Description:No description available
SelectedNonexistent in DB
bitSelected-
Description:No description available
Status
char(1)Status-
Description:No description available
SubIDDefault Navigation
intSubaccountSub
Description:No description available
TaskIDDefault Navigation
intProject TaskContractTask
Description:No description available
TermEndDate
datetime2Term End Date-
Description:No description available
TermStartDate
datetime2Term Start Date-
Description:No description available
TotalAmt
decimalTotal Amount-
Description:No description available
TranPeriodID
char(6)-
Description:No description available
tstamp
timestamp-
Description:No description available
UOMDefault Navigation
nvarchar(6)UOM-
Description:No description available