Revrecscheduleentry
Details each component of a revenue recognition schedule, noting corresponding accounts, allocation amounts, and recognition statuses.
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | Long | False |
Unique identifier for the revenue recognition schedule entry. |
| Revrecschedulekey | Long | False |
Key for the associated revenue recognition schedule. |
| Posted | String | True |
Offset or period information for posting. |
| Position | String | False |
Position of the entry within the schedule. |
| Next | String | False |
Indicator for the next posting in the schedule. |
| Postingdate | Date | False |
Date when the entry was posted. |
| Revacctkey | String | False |
Key for the revenue account associated with this entry. |
| Accountno | String | False |
Account number associated with the entry. |
| Accounttitle | String | False |
Title of the account associated with the entry. |
| Journalkey | Long | False |
Key for the general ledger journal associated with the entry. |
| Gljournal | String | True |
Name of the general ledger journal. |
| Deferredrevacctkey | String | False |
Key for the deferred revenue account associated with the entry. |
| Amount | Decimal | True |
Amount for this schedule entry. |
| Glbatchkey | Long | False |
Key for the general ledger batch associated with this entry. |
| Schopkey | Long | False |
Schedule operation key associated with the entry. |
| Tr_type | Long | False |
Transaction type for the entry. |
| Trx_amount | Decimal | False |
Transaction amount for the entry. |
| Currency | String | True |
Currency used for this entry. |
| Posted_amount | Decimal | True |
Amount posted in the schedule entry. |
| Basecurr | String | True |
Base currency for this entry. |
| Exch_rate_date | Date | False |
Date of the exchange rate applied to the entry. |
| Exch_rate_type_id | Long | False |
Type of exchange rate used for this entry. |
| Exchange_rate | Decimal | False |
Exchange rate applied to the entry. |
| Description | String | False |
Description or notes for the entry. |
| Parentstatus | String | True |
Status of the parent revenue posting. |
| Unscheduled | Bool | False |
Indicates if this entry is unscheduled. |
| Budgetqty | Decimal | True |
Budgeted quantity for this entry. |
| Estqty | Decimal | True |
Estimated quantity for this entry. |
| Plannedqty | Decimal | True |
Planned quantity for this entry. |
| Actualqty | Decimal | True |
Actual quantity recorded for this entry. |
| Percentcompleted | Decimal | True |
Percentage of the schedule completed for this entry. |
| Percentrecognized | Decimal | True |
Percentage of the revenue recognized for this entry. |
| Obspercentcomplete | Decimal | True |
Observed percentage completion of the schedule. |
| Budgetedcost | Decimal | True |
Budgeted cost for this entry. |
| Totalcost | Decimal | True |
Total actual cost for this entry. |
| Whencreated | Datetime | True |
Timestamp when the entry was created. |
| Whenmodified | Datetime | True |
Timestamp when the entry was last modified. |
| Createdby | Long | True |
Identifier of the user who created the entry. |
| Modifiedby | Long | True |
Identifier of the user who last modified the entry. |
| Projectdimkey | Long | False |
Key for the project dimension associated with the entry. |
| Projectid | String | False |
Identifier for the project associated with the entry. |
| Projectname | String | False |
Name of the project associated with the entry. |
| Customerdimkey | Long | False |
Key for the customer dimension associated with the entry. |
| Customerid | String | False |
Identifier for the customer associated with the entry. |
| Customername | String | False |
Name of the customer associated with the entry. |
| Vendordimkey | Long | False |
Key for the vendor dimension associated with the entry. |
| Vendorid | String | False |
Identifier for the vendor associated with the entry. |
| Vendorname | String | False |
Name of the vendor associated with the entry. |
| Employeedimkey | Long | False |
Key for the employee dimension associated with the entry. |
| Employeeid | String | False |
Identifier for the employee associated with the entry. |
| Employeename | String | False |
Name of the employee associated with the entry. |
| Itemdimkey | Long | False |
Key for the item dimension associated with the entry. |
| Itemid | String | False |
Identifier for the item associated with the entry. |
| Itemname | String | False |
Name of the item associated with the entry. |
| Classdimkey | Long | False |
Key for the class dimension associated with the entry. |
| Classid | String | False |
Identifier for the class associated with the entry. |
| Classname | String | False |
Name of the class associated with the entry. |
| Warehousedimkey | Long | False |
Key for the warehouse dimension associated with the entry. |
| Warehouseid | String | False |
Identifier for the warehouse associated with the entry. |
| Warehousename | String | False |
Name of the warehouse associated with the entry. |
| Contractdimkey | Long | False |
Key for the contract dimension associated with the entry. |
| Contractid | String | False |
Identifier for the contract associated with the entry. |
| Contractname | String | False |
Name of the contract associated with the entry. |
| Record_url | String | True |
A deep-link URL for viewing the record. |
| Gldimtestegi1 | String | False |
Test entry for general ledger dimension (unspecified purpose). |
| Gldimtest | String | False |
Test entry for general ledger dimension (unspecified purpose). |