Revrecscheduleentry
Retrieves RevRecScheduleEntry report data.
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | Long | False |
Record Number |
| Revrecschedulekey | Long | False |
REVRECSCHEDULEKEY |
| Posted | String | True |
Period Offset |
| Position | String | False |
Position |
| Next | String | False |
Next |
| Postingdate | Date | False |
Posting Date |
| Revacctkey | String | False |
Account Key |
| Accountno | String | False |
ACCOUNTNO |
| Accounttitle | String | False |
ACCOUNTTITLE |
| Journalkey | Long | False |
GL Journal Key |
| Gljournal | String | True |
GL Journal Key |
| Deferredrevacctkey | String | False |
Defered Rev Acct Key |
| Amount | Decimal | True |
Amount |
| Glbatchkey | Long | False |
GLBATCHKEY |
| Schopkey | Long | False |
SCHOPKEY |
| Tr_type | Long | False |
tr type |
| Trx_amount | Decimal | False |
Amount |
| Currency | String | True |
Currency |
| Posted_amount | Decimal | True |
Amount |
| Basecurr | String | True |
Base Currency |
| Exch_rate_date | Date | False |
Exchange Rate Date |
| Exch_rate_type_id | Long | False |
Exchange Rate Type |
| Exchange_rate | Decimal | False |
Exchange Rate |
| Description | String | False |
Description |
| Parentstatus | String | True |
Revenue Posting Status |
| Unscheduled | Bool | False | |
| Budgetqty | Decimal | True |
Budgeted hours |
| Estqty | Decimal | True |
Estimated hours |
| Plannedqty | Decimal | True |
Planned hours |
| Actualqty | Decimal | True |
Approved hours |
| Percentcompleted | Decimal | True |
Percent Completed |
| Percentrecognized | Decimal | True |
Percent Recognized |
| Obspercentcomplete | Decimal | True |
Observed Percent Completed |
| Budgetedcost | Decimal | True |
Budgeted Cost |
| Totalcost | Decimal | True |
Actual Cost |
| Whencreated | Datetime | True |
timestamp marking last time this was created. |
| Whenmodified | Datetime | True |
timestamp marking last time this was changed. |
| Createdby | Long | True |
User who created this. |
| Modifiedby | Long | True |
User who modified this. |
| Projectdimkey | Long | False |
Projectdimkey |
| Projectid | String | False |
Project |
| Projectname | String | False |
Project Name |
| Customerdimkey | Long | False |
Customerdimkey |
| Customerid | String | False |
Customer |
| Customername | String | False |
Customer Name |
| Vendordimkey | Long | False |
Vendordimkey |
| Vendorid | String | False |
Vendor |
| Vendorname | String | False |
Vendor Name |
| Employeedimkey | Long | False |
Employeedimkey |
| Employeeid | String | False |
Employee |
| Employeename | String | False |
Employee Name |
| Itemdimkey | Long | False |
Itemdimkey |
| Itemid | String | False |
Item |
| Itemname | String | False |
Item Name |
| Classdimkey | Long | False |
Classdimkey |
| Classid | String | False |
Class |
| Classname | String | False |
Class Name |
| Warehousedimkey | Long | False |
Warehousedimkey |
| Warehouseid | String | False |
Warehouse |
| Warehousename | String | False |
Warehouse Name |
| Contractdimkey | Long | False |
Contractdimkey |
| Contractid | String | False |
Contract |
| Contractname | String | False |
Contract Name |
| Record_url | String | True |
A portable, user-independent, deep-link URL for viewing this record |
| Gldimtestegi1 | String | False | |
| Gldimtest | String | False |