Share via

ProjProposalJour Table

  • Article

The ProjProposalJour table stores invoice proposal headers. Project invoice proposals are created when billing customers. Posting a project invoice proposal will create a project invoice.

Configuration Key: ProjBasic

Methods

  Method Description
Gg915797.pubmethod(en-us,AX.60).gif amountMST Returns invoice proposal amount in company currency.
Gg915797.pubmethod(en-us,AX.60).gif aosValidateDelete Validates on the server that the specified record can be deleted from a table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif aosValidateInsert Validates on the server that the specified record can be inserted. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif aosValidateRead Validates on the server that the specified record can be read. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif aosValidateUpdate Validates on the server that the specified record can be updated. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif approveProposale Approves an invoice proposal by updating its LinePropertyCode field to approved.
Gg915797.pubmethod(en-us,AX.60).gif buf2con Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif calcCashDiscDate Calculates the date when the cash discount is to be applied and sets the CashDiscDate using this value.
Gg915797.pubmethod(en-us,AX.60).gif calcDue Determines the due date for payment of the invoice proposal. The DueDate field is set with this value.
Gg915797.pubmethod(en-us,AX.60).gif calcDueDateLimit_ES Determine the PaymDueDateLimit_ES record that fits the criteria.
Gg915797.pubmethod(en-us,AX.60).gif cancelApprovel Cancels an approved invoice proposal and set its status to an open status.
Gg915797.pubmethod(en-us,AX.60).gif cancelTimeOut Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
Gg915797.pubmethod(en-us,AX.60).gif canManageInvoiceFormat Returns a true/false value indicating whether invoice format can be modified.
Gg915797.pubmethod(en-us,AX.60).gif canSubmitToWorkflow Returns a true/false value indicating whehter invoice proposal can be submitted to workflow.
Gg915797.pubmethod(en-us,AX.60).gif caption Gets and sets the caption property of a table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif checkInvalidFieldAccess Gets and sets invalid field access. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif checkRecord Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif checkRestrictedDeleteActions Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif clear Removes all rows from the table buffer. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif company Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif companyInfo Retrieves the CompanyInfo record associated with the current record.
Gg915797.pubmethod(en-us,AX.60).gif con2buf Unpacks a container into the table buffers. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif concurrencyModel Gets and sets the default concurrency model to use to update records. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif context Gets and sets the context property. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif copyPaymentSched Copies payment schedule to a record in ProjInvoiceJour table.
Gg915797.pubmethod(en-us,AX.60).gif createPaymentSched Calculates the total amount to be received for the invoice proposal from a customer or vendor. It creates a payment schedule based on the amount and the type of payment schedule set for the invoice proposal.
Gg915797.pubmethod(en-us,AX.60).gif creditNote_CZ Checks whether this line represents an item credit note.
Gg915797.pubmethod(en-us,AX.60).gif data Retrieves a row from the table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif dataSource Retrieves the data source of the table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif defaultField Populates default values in a field in the table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif defaultRow Populates default values in fields in the table in the non-interactive case. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif delete Deletes the current record from the table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif deliveryAddress Returns delivery address associated with the invoice proposal.
Gg915797.pubmethod(en-us,AX.60).gif disableCache Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif displayContractName Returns name of the contract associated which the invoice proposal.
Gg915797.pubmethod(en-us,AX.60).gif displayInvoiceAmount Displays the tax amount for the ProjProposalJour record.
Gg915797.pubmethod(en-us,AX.60).gif displayTaxAmount Displays the tax amount for the ProjProposalJour record.
Gg915797.pubmethod(en-us,AX.60).gif dispose Releases resources that are used by the xRecord object. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif dispVATRegistrationNum display method for customer VAT registration number.
Gg915797.pubmethod(en-us,AX.60).gif doClear Removes all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif doDelete Deletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif doInsert Inserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif doUpdate Updates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif doValidateDelete Performs the action to validate that a record can be deleted. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif editReasonCode Gets and sets the reason code.
Gg915797.pubmethod(en-us,AX.60).gif editReasonComment Gets and sets the reason comment.
Gg915797.pubmethod(en-us,AX.60).gif enablePostButton return true if post button is enabled; otherwise false.
Gg915797.pubmethod(en-us,AX.60).gif equal Determines whether the specified object is equal to the current one. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif fieldAccessRight Returns the field access right. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif fieldBufferAccessRight Returns the field access right for the current record. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif fieldState Sets or returns the state of a field in the table buffer. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif getAllowRedefault Returns the list of fields that are allowed to re-default. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif getDefaultingDependencies Returns the container that holds defaulting dependencies. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif getExtension Returns the table extension. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif getFieldValue Gets the value of the specified field from a table buffer. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif getInstanceRelationType Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif getOriginalProjInvoiceJour Get the original project invoice journal for the credit project invoice proposal.
Gg915797.pubmethod(en-us,AX.60).gif getPhysicalTableName Return the physical table name, which, in the case of the SQL Temp DB table, is the table instance name. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif getPresenceFieldData Retrieves the PresenceInfo value from the specified field. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif getSQLStatement Gets the SQL statement that is used to return records from the database. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif getTableInInstanceHierarchy (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif getTableType Indicates the type of the table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif getTimeOutTimerHandle Returns the timer handle for the object. (Inherited from Object.)
Gg915797.pubmethod(en-us,AX.60).gif groupId Determines the customer group for the customer on an invoice proposal.
Gg915797.pubmethod(en-us,AX.60).gif handle Retrieves the handle of the class of the object. (Inherited from Object.)
Gg915797.pubmethod(en-us,AX.60).gif hasRelatedTable Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif helpField Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif initFromProjInvoiceTable Initializes the appropriate fields of this invoice proposal with corresponding fields from the invoice project and currency code passed in.
Gg915797.pubmethod(en-us,AX.60).gif initValue Initializes field values in a new ProjProposalJour record.
Gg915797.pubmethod(en-us,AX.60).gif inputStatus Sets or returns the current input status of the table buffer. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif insert Inserts a new invoice proposal into the table.
Gg915797.pubmethod(en-us,AX.60).gif interactiveContext Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.)
Gg915797.privmethod(en-us,AX.60).gif isCustAdvance Returns a true/false value indicating whether invoice proposal includes line of type pre-payment.
Gg915797.privmethod(en-us,AX.60).gif isCustRetentionRelease
Gg915797.pubmethod(en-us,AX.60).gif isFieldDataRetrieved Checks whether the data of the given field has been retrieved. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif isFieldSet Checks whether a field has a Set or Defaulted state. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif isFormDataSource Indicates whether the data source is a form. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif isNewRecord Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif isPartOfUOWSaveChanges (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif isPostingUsingWorkflow Returns true if the workflow contains 'post' element; otherwise false.
Gg915797.pubmethod(en-us,AX.60).gif isTempDb Indicates whether the type of the table is SQL TempDB. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif isTmp Indicates whether this is a temporary table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif joinChild Finds the join child of the current record. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif joinParent Finds the join parent of the current record. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif linkPhysicalTableInstance Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif merge Merges the current table with the specified table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif modifiedField Modifies the specified field to the original. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif modifiedFieldValue Executes code based on value of fields changed by user from UI
Gg915797.pubmethod(en-us,AX.60).gif netInvoiceAmount Displays the net invoice amount for the ProjProposalJour record.
Gg915797.pubmethod(en-us,AX.60).gif new Initializes a new instance of the Object class. (Inherited from Object.)
Gg915797.pubmethod(en-us,AX.60).gif notify Releases the hold on an object that has called the wait method on this object. (Inherited from Object.)
Gg915797.pubmethod(en-us,AX.60).gif notifyAll Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
Gg915797.pubmethod(en-us,AX.60).gif objectOnServer Determines whether the object is on a server. (Inherited from Object.)
Gg915797.pubmethod(en-us,AX.60).gif orig Retrieves the original values of the current record. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif overwriteSystemfields Gets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif owner Returns the instance that owns the object. (Inherited from Object.)
Gg915797.pubmethod(en-us,AX.60).gif postCacheLoad Is executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif postLoad Is executed after a record is read. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif preRemoting Is executed before a cross-tier call is about to be executed for the table that would pack its state to the other tier. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif projId Returns project ID associated with the invoice proposoal.
Gg915797.pubmethod(en-us,AX.60).gif projInvoiceTable Retrieves the invoice project for the invoice proposal journal.
Gg915797.pubmethod(en-us,AX.60).gif projProposalId_BR Displays the form caption.
Gg915797.pubmethod(en-us,AX.60).gif psaProjTypeOnAcc Return type of the project associated with the invoice proposoal.
Gg915797.pubmethod(en-us,AX.60).gif querySalesTable Builds a query to retrieve all the sales orders attached to the item transaction lines on the invoice proposal journal.
Gg915797.pubmethod(en-us,AX.60).gif queryTimedOut Indicates whether the query exceeded the time limit for execution. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif queryTimeout Gets and sets the property that indicates the time limit for the execution of a query. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif readCommittedLock (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif readPast Gets and sets the property that indicates whether to skip rows that are locked by other processes when a record is read. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif recordLevelSecurity Gets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif relatedTable Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif renamePrimaryKey This method should not be called.
Gg915797.pubmethod(en-us,AX.60).gif reread Rereads the record from the table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif retentionAmount Displays the retention amount for the ProjProposalJour record.
Gg915797.pubmethod(en-us,AX.60).gif RowCount Retrieves the number of rows in the table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif salesTable Retrieves the first sales order created that is attached to the item transaction lines of the invoice proposal.
Gg915797.pubmethod(en-us,AX.60).gif selectForUpdate Gets and sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif selectLocked Indicates whether to select locked records. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif selectRefRecord Selects the record by referenced field ID. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif selectWithRepeatableRead Gets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif setConnection Sets the user connection for this table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif setCrossPartition Sets or resets cross-partitioning for the table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif setFieldValue Sets the field value in the record buffer. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif setSQLTracing Enables or disables SQL tracing mode. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif setTimeOut Sets up the scheduled execution of a specified method. (Inherited from Object.)
Gg915797.pubmethod(en-us,AX.60).gif setTmp Sets the table so that it is not persisted to the database. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif setTmpData Sets the contents of the temporary table to the specified data. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif setXDSContext Sets new XDS context. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif skipAosValidation Gets and sets the property that indicates whether to skip validation of Microsoft Dynamics AX Application Object Server (AOS). (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif skipDatabaseLog Gets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif skipDataMethods Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif skipDeleteActions Gets and sets the property that indicates whether to skip delete actions on the table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif skipDeleteMethod Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif skipEvents Provides an option to turn off calling the Application.event* methods for the lifetime of an xRecord object. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif skipPostLoad Gets and sets the property that indicates whether to skip executing the xRecord.postLoad method on the table. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif skipTTSCheck Gets and sets the property that indicates whether to skip the check to determine whether the record is selected for update. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif suppressWarnings Gets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif tableAccessRight Returns the table access right. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif tableBufferAccessRight Returns the table access right for the current record. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif takeOwnershipOfTempDBTable (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif toolTipField Retrieves the HelpText value for the specified field. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif toolTipRecord Retrieves the ToolTip value for the current record. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif toString Returns a string that represents the current object. (Inherited from Object.)
Gg915797.pubmethod(en-us,AX.60).gif ttsabort Aborts a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif ttsbegin Starts a transaction that can be either committed by the ttscommit method or aborted by the ttsabort method. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif ttscommit Commits a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif update Updates the current record. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif usageCount Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif useExistingTempDBTable (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif validateDelete Determines whether the current record is valid and ready to be deleted from the database. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif validateField Determines whether the specified field is valid. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif validateFieldValue (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif validateWrite Determines whether the current record is valid and ready to be written to the database.
Gg915797.pubmethod(en-us,AX.60).gif validTimeStateUpdateMode Sets a valid time state update mode on the cursor. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif wait Pauses a process. (Inherited from Object.)
Gg915797.pubmethod(en-us,AX.60).gif wasCached Specifies the location from which the data was retrieved. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif wipInvoicedOnAcc Returns value of onaccount transactins in company currency.
Gg915797.pubmethod(en-us,AX.60).gif write Updates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gif xml Retrieves an XML string that represents the current object. (Inherited from xRecord.)
Gg915797.pubmethod(en-us,AX.60).gifGg915797.static(en-us,AX.60).gif ::exist Determines if a sales order invoice exists for the ID of the sales order passed in as a parameter.
Gg915797.pubmethod(en-us,AX.60).gifGg915797.static(en-us,AX.60).gif ::find Returns the invoice proposal journal for the given proposal ID passed in as a parameter.
Gg915797.pubmethod(en-us,AX.60).gifGg915797.static(en-us,AX.60).gif ::findRecid Returns the invoice proposal journal for the given record ID passed in as a parameter.
Gg915797.pubmethod(en-us,AX.60).gifGg915797.static(en-us,AX.60).gif ::findRecId_W Returns the invoice proposal journal for the given record ID passed in as a parameter.
Gg915797.pubmethod(en-us,AX.60).gifGg915797.static(en-us,AX.60).gif ::hasDetails Returns true false value indicating whether the invoice proposal has any transactions of type item, cost, empl, revenue, on account.
Gg915797.pubmethod(en-us,AX.60).gifGg915797.static(en-us,AX.60).gif ::isProposalRelease Returns a true/false value indicating whether the invoice proposal is of type release.
Gg915797.pubmethod(en-us,AX.60).gifGg915797.static(en-us,AX.60).gif ::jumpRefProposal Launches a ProjInvoiceProposal object and passes the invoice proposal record for the proposal ID passed in as a parameter.
Gg915797.privmethod(en-us,AX.60).gifGg915797.static(en-us,AX.60).gif ::modifiedFieldValueServer
Gg915797.pubmethod(en-us,AX.60).gifGg915797.static(en-us,AX.60).gif ::numOfRecords Returns the number of lines in a project invoice propsoal.
Gg915797.pubmethod(en-us,AX.60).gifGg915797.static(en-us,AX.60).gif ::proposalQuery Returns a container containing the query definition to return records associated with an invoice proposal.
Gg915797.pubmethod(en-us,AX.60).gifGg915797.static(en-us,AX.60).gif ::psaIsCTLNChecked Returns a true/false value indicating whether the proposal jour has associated contract lines.
Gg915797.pubmethod(en-us,AX.60).gifGg915797.static(en-us,AX.60).gif ::psaSplitBilling Returns a true/false value indicating whether billing should be split.

Top

Fields

Field Type Configuration key Description
BOLCarrierName Extended Data Type: WMSCarrierName
Type: String
 SalesShipments Name of carrier. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
CanceledBy Extended Data Type: UserId
Type: String
 None ID for the user
CashDisc Extended Data Type: ProjCashDiscAmount
Type: Real
 ProjBasic Cash discount amount included in the customer transaction when invoicing.
CashDiscCode Extended Data Type: ProjCashDiscCode
Type: String
 ProjBasic Terms of cash discount for the current invoice.
CashDiscDate Extended Data Type: ProjCashDiscDate
Type: Date
 ProjBasic Last date of payment to qualify for cash discount.
CostValue Extended Data Type: CostAmountProject
Type: Real
 None Cost value of invoice content.
createdBy Extended Data Type: CreatedBy
Type: String
 None (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
CurrencyId Extended Data Type: ProjSalesCurrencyCode
Type: String
 None Currency in which the project is invoiced.
CustBankAccountId Extended Data Type: CustBankAccountId
Type: String
 Bank Identification of customer's bank account. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dataAreaId Extended Data Type: DataAreaId
Type: String
 None
DefaultDimension Extended Data Type: DimensionDefault
Type: Int64
 LedgerBasic Default dimensions
DeliveryName Extended Data Type: CompanyName
Type: String
 None The name that is associated with the selected delivery address
DeliveryPostalAddress Extended Data Type: LogisticsPostalAddressRecId
Type: Int64
 None Reference field in a different table
Description Extended Data Type: Description
Type: String
 Project3 Brief description of transaction (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
DiscPercent Extended Data Type: SalesEndDiscPct
Type: Real
 PriceDisc Total discount on the sales order, in rounded percentage
DlvMode Extended Data Type: CustDlvModeId
Type: String
 None Specify mode of delivery for the current delivery.
DlvTerm Extended Data Type: CustDlvTermId
Type: String
 None Specify terms of delivery for current delivery.
DlvTransportBrand_BR Extended Data Type: DlvTransportBrand_BR
Type: String
 None The brand of the carrier service. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
DueDate Extended Data Type: DueDate
Type: Date
 LedgerBasic Due date of invoice amount.
EInvoiceAccountCode Extended Data Type: EInvoiceAccountCode
Type: String
 None When settling to a public sector organization it is possible to specify a dimension account code.
EInvoiceLineSpecific Extended Data Type: EInvoiceLineSpecific
Type: Enum
 None Specify the dimension account code for settlement to the public sector organization on line level.
EndDisc Extended Data Type: DiscAmount
Type: Real
 None Total invoice discount
exchRate Extended Data Type: ExchRate
Type: Real
 None Specify the cost in the foreign currency.
ExchrateSecondary Extended Data Type: ExchrateSecondary
Type: Real
 None Rate of the secondary part of the currency calculation, when triangulation is used
FiscalDocumentType_BR Extended Data Type: FiscalDocumentTypeRecID_BR
Type: Int64
 None Type of fiscal document. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
FiscalEstablishment_BR Extended Data Type: FiscalEstablishmentRecId_BR
Type: Int64
 None Fiscal establishment identification (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
FundingSource Extended Data Type: ProjFundingSourceRefId
Type: Int64
 ProjBasic Funding source that the transaction is attached to
GiroType Extended Data Type: PaymentStubProjId
Type: Enum
 CustGiro Print associated payment attachment for project invoice and project on account invoice?
InterCompanyPosted Extended Data Type: InterCompanyPosted
Type: Enum
 TradeInterCompany The journal was posted automatically via intercompany
IntrastatAddValue_LV Extended Data Type: LvIntrastatAddValue
Type: Real
 ForeignTrade The additional value to be distributed equally among the lines to calculate the statistical value (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
IntrastatDispatchId Extended Data Type: IntrastatDispatchId
Type: String
 ForeignTrade Shipment batch number in Intrastat.
InvoiceAccount Extended Data Type: CustInvoiceAccount
Type: String
 None Customer account number.
InvoiceAmount Extended Data Type: AmountCur
Type: Real
 None Total amount of the invoice proposal
InvoiceAutoNumbering_LT Extended Data Type: LtInvoiceAutoNumbering
Type: Enum
 None Use the auto numbering. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
InvoiceDate Extended Data Type: TransDate
Type: Date
 None The date on which the selected invoiced proposal is posted
InvoiceRoundOff Extended Data Type: RoundOff
Type: Real
 None Rounding-off of invoice amount.
InvoiceType Enumeration: ProjInvoiceType
 ProjBasic Specifies the type of invoice (invoice, on account, etc.).
LanguageId Extended Data Type: ProjLanguageId
Type: String
 ProjBasic Select the language for the current text.
LedgerVoucher Extended Data Type: Voucher
Type: String
 LedgerBasic Voucher number incl. attached ledger transactions.
LineProperty Enumeration: ProjLinePropertyCode
 ProjBasic The status of the selected invoice proposal
ListCodeId Extended Data Type: ListcodeId
Type: Enum
 ForeignTrade List code to be used with the EU sales list.
NumberSequenceGroupId Extended Data Type: NumberSequenceGroupId
Type: String
 None Group for allocation of different number sequences to different customers/vendors.
OnAccountAmount Extended Data Type: AmountCur
Type: Real
 None Specify sum on account for on-account invoice from Project.
OrderAccount Extended Data Type: CustAccount
Type: String
 None Customer account that generated the order.
Partition Extended Data Type: Partition
Type: Int64
 None (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
PaymDayId Extended Data Type: CustPaymDayId
Type: String
 LedgerBasic Identification of payment days
Payment Extended Data Type: ProjPaymCode
Type: String
 ProjBasic Terms of payment for the current invoice.
PaymentSched Extended Data Type: PaymSchedId
Type: String
 PaymSched Payment schedule to be used when invoicing.
Port Extended Data Type: IntrastatPortId
Type: String
 ForeignTrade Port where current delivery is loaded.
PostingProfile Extended Data Type: CustPostingProfile
Type: String
 None Posting profile used when posting interest note.
ProjGroupId Extended Data Type: ProjGroupId
Type: String
 ProjBasic Group number that is used for reference.
ProjInvoiceId Extended Data Type: ProjInvoiceId
Type: String
 ProjBasic Project - invoice number.
ProjInvoiceProjId Extended Data Type: ProjInvoiceProjId
Type: String
 ProjBasic Project contract identifier
ProposalId Extended Data Type: ProjProposalId
Type: String
 ProjBasic The identifier of the invoice proposal
PSAEndDate Extended Data Type: ToDate
Type: Date
 PSAContractLine To (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PSAInvoiceFormats Enumeration: PSAInvoiceFormats
 Project3 Specifies invoice formats (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PSAInvoiceMethod Enumeration: PSAInvoiceMethod
 Project3 Invoicing method used for this project (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PSAInvoiceTxtPost Extended Data Type: Notes
Type: VarString
 Project3 Text printed after the lines on the invoice (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PSAInvoiceTxtPre Extended Data Type: Notes
Type: VarString
 Project3 Text printed before the lines on the invoice (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PSAnfRefProjId Extended Data Type: ProjIdBase
Type: String
 Project3 Identification of the project. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
PSAWorkerSubmittedBy Extended Data Type: ProjWorkerRecId
Type: Int64
 Project3 The name of the worker (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK))
ReasonTableRef Extended Data Type: ReasonTableRefRecId
Type: Int64
 None Contains stored financial reason codes and comments for entered or posted transactions or actions. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
RecId Extended Data Type: RecId
Type: Int64
 None
recVersion Extended Data Type: RecVersion
Type: Integer
 None
SalesFreightChargeTerms_BR Enumeration: WMSFreightChargeTerms
 SalesShipments Who is to pay freight? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
SalesOrderbalance Extended Data Type: AmountCur
Type: Real
 None Total of the invoice lines after line discount.
SumLineDisc Extended Data Type: DiscAmount
Type: Real
 None Total line discount on the invoice.
SumTax Extended Data Type: TaxAmountCur
Type: Real
 LedgerBasicSalesTax Total tax deducted.
TaxGroupId Extended Data Type: TaxGroup
Type: String
 LedgerBasicSalesTax A group of sales tax codes for calculating taxes on a sale or purchase
TaxInformation_IN Extended Data Type: RefRecId
Type: Int64
 None Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
TaxPeriodPaymentCode_PL Extended Data Type: PlTaxPeriodPaymentCode
Type: String
 None Enter a time period code for VAT transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
TaxPrintOnInvoice Extended Data Type: TaxPrintOnInvoice
Type: Enum
 LedgerBasicSalesTax Write marking on invoice.
TaxServiceCodeId_BR Extended Data Type: TaxServiceCodeId_BR
Type: String
 None Fiscal classification applied for services (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
TaxSpecifyByLine Enumeration: NoYes
 None Sales tax is specified per invoice line.
TaxSpecifyTotal Enumeration: NoYes
 None Sales tax is specified on invoice total.
TransportationDocument Extended Data Type: TransportationDocumentRecId
Type: Int64
 None Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
Triangulation Extended Data Type: EUROTriangulation
Type: Enum
 None Specify whether the exchange rate is included in triangulation.
VATInvoiceDescTable Extended Data Type: VATInvoiceDescIdRef_CN
Type: Int64
 LedgerBasicSalesTax Identification of the tax invoice description. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
VehicleLicensePlate_BR Extended Data Type: DlvNoOfCarrier_BR
Type: String
 None The transport vehicle number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
VehicleLicensePlateState_BR Extended Data Type: DlvStateRegistered_BR
Type: String
 None The state where the transport vehicle is registered (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
VolumeQty_BR Extended Data Type: VolumeQty_BR
Type: Real
 None Volume quantity used in invoice and packing slip posting for fiscal integration (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
VolumeType_BR Extended Data Type: VolumeType_BR
Type: String
 None Volume type is used in invoice and packing slip posting for fiscal integration (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
WorkerApprovedBy Extended Data Type: ProjWorkerRecId
Type: Int64
 None The name of the worker

Top

Field Groups

Field Group Fields
PSAWorkflow
PrintingSpecifications
Project
PaymentSchedule
PSA
Reason
SalesTax
ShipmentInformation
PSAEndDate
TermsOfDelivery
SplitInfo_BR
System
TaxInformation_IN
WebCategoryBrowsing
WorkflowPreview
WorkflowSummary
VehicleInformation_BR
Invoice
InvoiceNumbering_LT
Ledger
AddressDisplay
Address
Amount
Approval
AutoReport
AutoSummary
BillOfLading
Currency
Customer
FundingSource
Dimension
Intrastat
DeliveryAddress
EInvoice
InterCompany

Top

Relations

Relation Table Lines
BOLCarrierName SalesCarrier
CashDisc CashDisc
Currency Currency
CustBankAccount CustBankAccount
CustLedger CustLedger
CustTable_Invoice CustTable
CustTable_Order CustTable
dataAreaId DataArea
DefaultDimension DimensionAttributeValueSet
DeliveryPostalAddress_FK LogisticsPostalAddress
DlvMode DlvMode
DlvTerm DlvTerm
FiscalDocumentType_BR FiscalDocumentType_BR
FiscalEstablishment_BR FiscalEstablishment_BR
FundingSource ProjFundingSource
IntrastatPort IntrastatPort
LanguageTable LanguageTable
LanguageTable1 LanguageTable
NumberSequenceGroup NumberSequenceGroup
Partition Partitions
PaymDay PaymDay
PaymSched PaymSched
PaymTerm PaymTerm
PlTaxDueTable PlTaxDueTable
ProjGroup ProjGroup
ProjInvoiceId ProjInvoiceJour
ProjInvoiceJour ProjInvoiceJour
ProjInvoiceTable ProjInvoiceTable
ProposalId ProjProposalJour
PSAWorkerSubmittedBy HcmWorker
ReasonTableRef ReasonTableRef
TaxGroupHeading TaxGroupHeading
TaxInformation_IN TaxInformation_IN
TransportationDocument TransportationDocument
UserInfo UserInfo
VATInvoiceDescTable VATInvoiceDescTable_CN
WorkerApproved HcmWorker

Top

Indexes

Index AllowDuplicates Enabled Fields
FiscalEstablishment_BRIdx Yes Yes
FK_DimensionAttributeValueSet_ProjPropos Yes Yes
HcmWorkerIdx Yes Yes
InvoiceAccountIdx Yes Yes
OrderAccountIdx Yes Yes
ProposalNumIdx No Yes
RecId No Yes

Top

Security Note

Use of this table could lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to an enumeration value of CreateReadUpdateDelete. The Application Object Server authorizes each create, read, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception occurs.

Top

Inheritance Hierarchy

xRecord Class
  Common Table
    ProjProposalJour Table

See Also

Table Methods

Tables Overview