Skip to main content

Window: Unprocessed Documents (All)

[Created: 24/07/2009 - Updated: 24/07/2009 ]
Description: Unprocessed Documents (All)
Help: View all unprocessed documents

Tab: Unprocessed Documents

[Created: 24/07/2009 - Updated: 24/07/2009 ]
Description:
Help:
Tab Level: 0

Table 10: Unprocessed Documents - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.rv_unprocessed.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.rv_unprocessed.AD_Org_ID numeric(10)
Table Direct
TableDatabase Table informationThe Database Table provides the information of the table definitionrv_unprocessed.AD_Table_ID integer
Table Direct
Record IDDirect internal record IDThe Record ID is the internal unique identifier of a record. Please note that zooming to the record may not be successful for Orders, Invoices and Shipment/Receipts as sometimes the Sales Order type is not known.rv_unprocessed.Record_ID numeric(10)
Record ID
Document NoDocument sequence number of the documentThe document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "".If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_", where TableName is the actual name of the table (e.g. C_Order).rv_unprocessed.DocumentNo
String
Document DateDate of the DocumentThe Document Date indicates the date the document was generated. It may or may not be the same as the accounting date.rv_unprocessed.DateDoc timestamp without time zone
Date+Time
Account DateAccounting DateThe Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion.rv_unprocessed.DateAcct timestamp without time zone
Date+Time
Document StatusThe current status of the documentThe Document Status indicates the status of a document at this time. If you want to change the document status, use the Document Action fieldrv_unprocessed.DocStatus character(2)
List
ProcessedThe document has been processedThe Processed checkbox indicates that a document has been processed.rv_unprocessed.Processed character(1)
Yes-No
Process Nowrv_unprocessed.Processing character(1)
Yes-No
Sales TransactionThis is a Sales TransactionThe Sales Transaction checkbox indicates if this item is a Sales Transaction.rv_unprocessed.IsSOTrx
Yes-No
ActiveThe record is active in the systemThere are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.rv_unprocessed.IsActive character(1)
Yes-No