Importance of AUTORULE_COMPLETE_FLAG

Field Name Description


INVOICING_RULE_ID Contains the Invoicing rule id, value = -2 or -3

ACCOUNTING_RULE_ID Contains Accounting rule id

ACCOUNTING_RULE_DURATION Contains the number of periods

AUTORULE_DURATION_PROCESSED Upon creation of an invoice with rules, this field is null. When the Revenue Recognition process is run, this field will get incremented to reflect the number of periods for which revenue has already been recognized.

AUTORULE_COMPLETE_FLAG Upon creation of an invoice with rules, this field is N. When the Revenue Recognition process is run and completes processing all periods for this line, this field will get updated to null.

RULE_START_DATE Contains the start date

RULE_END_DATE Contains the end date (if provided)