biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / General / Users
API ODCR
ODCR - Checking Rule Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
RuleCode KEY UNIQUEChecking Rule CodenVarChar
2
PRIMARYYes
RuleDescChecking Rule DescriptionnVarChar
100
PastRcpInclude Past Plan ReceiptsVarChar
Y) Yes
N) No
1
Y
AutoATPATP Check AutomaticallyVarChar
Y) Yes
N) No
1
Y
SLDUncfmSchedule for Unconfirmed QtyVarChar
Y) Yes
N) No
1
Y
AllowUncfmAllow Unconfirmed QuantityVarChar
Y) Yes
N) No
1
N
CmltStrtgCumulation StrategyVarChar
R) Required Qty on Creation; Confirmed Qty on Change
C) Confirmed Qty on Creation and Change
1
R
DeliStrtgDelivery StrategyVarChar
D) Delivery Proposal
O) One-Time Delivery
C) Complete Delivery
1
D
MaxPrpslsMax. No. of ProposalsInt
11
9
validForActiveVarChar
1
N
validFromActive FromnVarChar
8
validToActive TonVarChar
8
frozenForInactiveVarChar
1
N
frozenFromInactive FromnVarChar
8
frozenToInactive TonVarChar
8
LockedLockedVarChar
Y) Yes
N) No
1
N

SELECT statement

SELECT ODCR.RuleCode AS 'Checking Rule Code', ODCR.RuleDesc AS 'Checking Rule Description', ODCR.PastRcp AS 'Include Past Plan Receipts', ODCR.AutoATP AS 'ATP Check Automatically', ODCR.SLDUncfm AS 'Schedule for Unconfirmed Qty', ODCR.AllowUncfm AS 'Allow Unconfirmed Quantity', ODCR.CmltStrtg AS 'Cumulation Strategy', ODCR.DeliStrtg AS 'Delivery Strategy', ODCR.MaxPrpsls AS 'Max. No. of Proposals', ODCR.validFor AS 'Active', ODCR.validFrom AS 'Active From', ODCR.validTo AS 'Active To', ODCR.frozenFor AS 'Inactive', ODCR.frozenFrom AS 'Inactive From', ODCR.frozenTo AS 'Inactive To', ODCR.Locked AS 'Locked' FROM ODCR AS ODCR

Related information


ODCR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates