MSC_INVOICING_ACCT_RULES
Receivables uses invoicing rules to determine when to recognize a receivable for invoices that span more than one accounting period. Assign invoicing rules to invoices that are manually entered or imported into Receivables through AutoInvoice. Receivables provides two invoicing rules: the Bill in Advance rule tells Receivables to recognize your receivable immediately, while the Bill in Arrears rule tells Receivables to recognize the receivable at the end of the revenue recognition schedule
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
MSC_INVOICING_ACCT_RULES_PK |
RULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| RULE_ID | NUMBER | 18 | Yes | Revenue recognition rule identifier | ||
| NAME | VARCHAR2 | 30 | Yes | Revenue recognition rule name | ||
| DESCRIPTION | VARCHAR2 | 80 | Revenue recognition rule description | |||
| TYPE | VARCHAR2 | 10 | Yes | This value indicates the Type of the rule in invoicing accounting rules. | ||
| STATUS | VARCHAR2 | 1 | Yes | This value indicates the Status of the accounting rules. | ||
| SET_ID | NUMBER | 18 | Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs. | Obsolete | ||
| REFRESH_NUMBER | NUMBER | Refresh identifier populated by the collection program. | ||||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| doo_fulfill_lines_all | msc_invoicing_acct_rules | INVOICING_RULE_ID |
| doo_fulfill_lines_all | msc_invoicing_acct_rules | ACCOUNTING_RULE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_INVOICING_ACCT_RULES_U1 | Unique | Default | RULE_ID |
| MSC_INVOICING_ACCT_RULES_U2 | Unique | Default | NAME |