method GetValidationRulesForSSTypeDebtor

Parameters

oiReturnStatus
output
integer
Return status of the method.
Internal usage

QadFinancials
method BSharedSetMerge.GetValidationRulesForSSType
program code (program6/bsharedsetmerge.p)

/* =================================================================================================== */
/* Method      : GetValidationRulesForSSTypeDebtor                                                     */
/* Desc        : This method populates temporary tables with rules for validation of shared set data   */
/* =================================================================================================== */

assign oiReturnStatus = -98.

/* =================================================================================================== */
/* Validation rules                                                                                    */
/* =================================================================================================== */
create tMergeValidateTable.
assign tMergeValidateTable.tcTableName           = "Debtor":U
       tMergeValidateTable.tlDeleteRedundantOnly = false
       tMergeValidateTable.tcParentTableName     = ?
       tMergeValidateTable.tc_Rowid              = "1":U.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName             = "tcBillToDebtorCode":U
       tMergeValidateField.tiMergeType             = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed        = false
       tMergeValidateField.tlIsRelationToSameTable = true
       tMergeValidateField.tcRelationFieldName     = "BillToDebtor_ID":U
       tMergeValidateField.tc_ParentRowid          = tMergeValidateTable.tc_RowId.
 
create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tcBusinessRelationCode":U       
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid   = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tlBusinessRelationIsDomRestr":U
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = true
       tMergeValidateField.tc_ParentRowid   = tMergeValidateTable.tc_Rowid.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tcBusinessRelationDomainCode":U
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = true
       tMergeValidateField.tc_ParentRowid   = tMergeValidateTable.tc_Rowid.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tcCurrencyCode":U       
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid   = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tiDebtor_ID":U       
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-ID}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid   = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tcDebtorCode":U       
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-KEY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid    = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tlDebtorIsActive":U       
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid    = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tlDebtorIsTaxable":U       
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid    = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tlDebtorIsTaxInCity":U       
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid    = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tlDebtorIsTaxIncluded":U       
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid    = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tiDebtorTaxDeclaration":U       
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid    = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tcDebtorTaxIDFederal":U       
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid    = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tcDebtorTaxIdMisc1":U       
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid    = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tcDebtorTaxIdMisc2":U       
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid    = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tcDebtorTaxIdMisc3":U       
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid    = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tcDebtorTaxIDState":U       
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid    = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tcNormalPaymentConditionCode":U       
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid    = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tcReasonCode":U
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid    = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tcTxclTaxCls":U
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid    = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tcTxuTaxUsage":U
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid    = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tcTxzTaxZone":U
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-MANDATORY}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid    = tMergeValidateTable.tc_RowId.

create tMergeValidateField.
assign tMergeValidateField.tcFieldName      = "tiSharedSet_ID":U
       tMergeValidateField.tiMergeType      = {&SHAREDSETMERGE-FIELDTYPE-TECHNICAL}
       tMergeValidateField.tlIsBlankAllowed = false
       tMergeValidateField.tc_ParentRowid   = tMergeValidateTable.tc_Rowid.


/* =================================================================================================== */
/* Return                                                                                              */
/* =================================================================================================== */
if oiReturnStatus = -98 then assign oiReturnStatus = 0.