ProjInvoiceJour Table
The ProjInvoiceJour table stores invoice headers. Posting an invoice proposal will create a record in the ProjInvoiceJour table.
Configuration Key: ProjBasic
Methods
Method | Description | |
---|---|---|
amountCur | Converts an amount of money in default currency to an equivalent amount in the currency used on this invoice journal. | |
amountCur2Euro | ||
amountMST | Converts an amount that is in currency used on the invoice journal to its equivalent amount in the default currency. | |
amountMST2Euro | Converts an amount in the default currency to its equivalent amount in the Euro currency. | |
amountOutstanding | ||
amountSettled | ||
aosValidateDelete | Validates on the server that the specified record can be deleted from a table. (Inherited from xRecord.) | |
aosValidateInsert | Validates on the server that the specified record can be inserted. (Inherited from xRecord.) | |
aosValidateRead | Validates on the server that the specified record can be read. (Inherited from xRecord.) | |
aosValidateUpdate | Validates on the server that the specified record can be updated. (Inherited from xRecord.) | |
buf2con | Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.) | |
calcCashDiscDate | Calculates the date when the cash discount is to be applied and sets the CashDiscDate field with this value. | |
calcDue | Determines the due date for payment of an invoice journal. | |
calcDueDateLimit_ES | Determine the PaymDueDateLimit_ES record that fits the criteria. | |
cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) | |
canSubmitToWorkflow | Indicates whether submission to workflow is possible. (Inherited from xRecord.) | |
canXMLBeSent | Determines whether document can be sent electronically or not. | |
caption | Gets and sets the caption property of a table. (Inherited from xRecord.) | |
cashDiscTxt | Returns a cash discount text built from the cash discount date and amount on an invoice journal. | |
cashDiscTxtOnInvoice | Determines the appropriate cash discount text to build for an invoice journal based on the cash discount amount, cash discount date, taxes, or Value Added Tax (VAT). | |
checkInvalidFieldAccess | Gets and sets invalid field access. (Inherited from xRecord.) | |
checkRecord | Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.) | |
checkRestrictedDeleteActions | Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.) | |
clear | Removes all rows from the table buffer. (Inherited from xRecord.) | |
company | Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.) | |
companyInfo | Retrieves the CompanyInfo record associated with the current record. | |
con2buf | Unpacks a container into the table buffers. (Inherited from xRecord.) | |
concurrencyModel | Gets and sets the default concurrency model to use to update records. (Inherited from xRecord.) | |
context | Gets and sets the context property. (Inherited from xRecord.) | |
contributionAmountMST | Determines the contribution amount of the invoice journal. | |
contributionMargin | Determines the contribution margin of the invoice journal. | |
contributionRatio | Determines the percentage of sales on an invoice journal. | |
contributionRatioMST | Determines the percentage of sales on this invoice journal. | |
copyDimension | Returns a dimension set that can be applied to the defaultDimension field on this table. | |
countryRegionId | ||
createPaymentSched | Creates a payment schedule based on an amount and the type of payment schedule set for the invoice journal. | |
creditCardBypassCreditLimit | ||
data | Retrieves a row from the table. (Inherited from xRecord.) | |
dataSource | Retrieves the data source of the table. (Inherited from xRecord.) | |
defaultField | Populates default values in a field in the table. (Inherited from xRecord.) | |
defaultRow | Populates default values in fields in the table in the non-interactive case. (Inherited from xRecord.) | |
delete | Deletes the current record from the table. (Inherited from xRecord.) | |
deliveryAddress | ||
disableCache | Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.) | |
dispose | Releases resources that are used by the xRecord object. (Inherited from xRecord.) | |
doClear | Removes all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.) | |
doDelete | Deletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.) | |
doInsert | Inserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.) | |
doUpdate | Updates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.) | |
doValidateDelete | Performs the action to validate that a record can be deleted. (Inherited from xRecord.) | |
editExchRate | Sets or gets the exchange rate used on the invoice journal. | |
editExchRateSecondary | Sets or gets the secondary exchange rate used on the invoice journal. | |
editReasonCode | Gets and sets the reason code. | |
editReasonComment | Gets and sets the reason comment. | |
endDiscEuro | Converts the amount in the EndDisc field of an invoice journal to its equivalent amount in the Euro currency. | |
equal | Determines whether the specified object is equal to the current one. (Inherited from xRecord.) | |
fieldAccessRight | Returns the field access right. (Inherited from xRecord.) | |
fieldBufferAccessRight | Returns the field access right for the current record. (Inherited from xRecord.) | |
fieldState | Sets or returns the state of a field in the table buffer. (Inherited from xRecord.) | |
getAllowRedefault | Returns the list of fields that are allowed to re-default. (Inherited from xRecord.) | |
getDefaultingDependencies | Returns the container that holds defaulting dependencies. (Inherited from xRecord.) | |
getExtension | Returns the table extension. (Inherited from xRecord.) | |
getFieldValue | Gets the value of the specified field from a table buffer. (Inherited from xRecord.) | |
getInstanceRelationType | Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.) | |
getPhysicalTableName | Return the physical table name, which, in the case of the SQL Temp DB table, is the table instance name. (Inherited from xRecord.) | |
getPresenceFieldData | Retrieves the PresenceInfo value from the specified field. (Inherited from xRecord.) | |
getSalesTable | Gets the SalesTable with the smallest sales id for the proposal. | |
getSQLStatement | Gets the SQL statement that is used to return records from the database. (Inherited from xRecord.) | |
getTableInInstanceHierarchy | (Inherited from xRecord.) | |
getTableType | Indicates the type of the table. (Inherited from xRecord.) | |
getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) | |
groupId | Retrieves the group ID for the customer on the invoice journal. | |
handle | Retrieves the handle of the class of the object. (Inherited from Object.) | |
hasRelatedTable | Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.) | |
helpField | Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.) | |
initFromProjProposal | Initializes the fields of this invoice journal with the value of the corresponding fields in an invoice proposal journal. | |
initValue | Initializes field values in a new ProjInvoiceJour record. | |
inputStatus | Sets or returns the current input status of the table buffer. (Inherited from xRecord.) | |
insert | Inserts the current record into the database. | |
interactiveContext | Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.) | |
invoiceAmountEuro | Converts the amount on the invoice to its equivalent in the Euro currency. | |
invoiceAmountMST | Retrieves the amount on an invoice journal in the default currency. | |
invoiceReferenceNumberFI | ||
invoiceRoundOffEuro | Converts the amount in the InvoiceRoundOff field to its equivalent in the Euros. | |
isCreditNote_CZ | Check is this record a credit note document | |
isFieldDataRetrieved | Checks whether the data of the given field has been retrieved. (Inherited from xRecord.) | |
isFieldSet | Checks whether a field has a Set or Defaulted state. (Inherited from xRecord.) | |
isFormDataSource | Indicates whether the data source is a form. (Inherited from xRecord.) | |
isNewRecord | Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.) | |
isPartOfUOWSaveChanges | (Inherited from xRecord.) | |
isProforma | ||
isTempDb | Indicates whether the type of the table is SQL TempDB. (Inherited from xRecord.) | |
isTmp | Indicates whether this is a temporary table. (Inherited from xRecord.) | |
joinChild | Finds the join child of the current record. (Inherited from xRecord.) | |
joinParent | Finds the join parent of the current record. (Inherited from xRecord.) | |
linkPhysicalTableInstance | Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.) | |
merge | Merges the current table with the specified table. (Inherited from xRecord.) | |
mergeDimension | Returns a dimension set that holds the merged combination of the current defaultDimensionfield on this table and the provided dimension set. | |
modifiedField | Modifies the specified field to the original. (Inherited from xRecord.) | |
modifiedFieldValue | Modifies the specified field to the original value. (Inherited from xRecord.) | |
module | Returns a numeric value that represents a project module in Microsoft Dynamics AX. | |
netAmount | ||
netAmountEuro | ||
new | Initializes a new instance of the Object class. (Inherited from Object.) | |
notify | Releases the hold on an object that has called the wait method on this object. (Inherited from Object.) | |
notifyAll | Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.) | |
objectOnServer | Determines whether the object is on a server. (Inherited from Object.) | |
orig | Retrieves the original values of the current record. (Inherited from xRecord.) | |
ourAccountNum | Returns the account number of the customer on the invoice journal. | |
overwriteSystemfields | Gets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.) | |
owner | Returns the instance that owns the object. (Inherited from Object.) | |
payment | ||
paymentBankAccountId | ||
paymentCondition | Determines the message text for the terms of payment to use for an invoice journal. | |
postCacheLoad | Is executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.) | |
postLoad | Is executed after a record is read. (Inherited from xRecord.) | |
prepaidAmount | Determines the total settled prepaid amount from all the transactions posted for the customer on an invoice journal. | |
prepaidAmountEuro | Determines the total settled prepaid amount in the Euro currency from all the transactions posted for the customer on an invoice journal. | |
prepaidAmountMST | Determines the total settled prepaid amount in the default currency from all the transactions posted for the customer on an invoice journal. | |
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.) | |
psaIsFromContractLine | ||
qtyHour | ||
queryCustTrans | ||
queryRunCustTrans | ||
queryTaxTrans | Builds a query that retrieves all the tax transactions associated with project invoice journal. | |
queryTimedOut | Indicates whether the query exceeded the time limit for execution. (Inherited from xRecord.) | |
queryTimeout | Gets and sets the property that indicates the time limit for the execution of a query. (Inherited from xRecord.) | |
queryTmpTaxWorkTrans | ||
readCommittedLock | (Inherited from xRecord.) | |
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.) | |
recordLevelSecurity | Gets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.) | |
relatedTable | Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.) | |
remainAmountToBePaid | Determines the remaining amount to be paid for an invoice journal. | |
remainAmountToBePaidEuro | Determines the remaining amount to be paid for an invoice journal in the Euro currency. | |
remainAmountToBePaidMST | Determines the remaining amount to be paid for an invoice journal in the default currency. | |
renamePrimaryKey | Does not function. | |
reread | Rereads the record from the table. (Inherited from xRecord.) | |
returnOriginalTransRecId_CZ | The method returns RecId of an original line for the current credit note line | |
revenue | ||
revenueMST | ||
RowCount | Retrieves the number of rows in the table. (Inherited from xRecord.) | |
salesBalanceEuro | Determines the sales order balance in the Euro currency. | |
selectForUpdate | Gets and sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.) | |
selectLocked | Indicates whether to select locked records. (Inherited from xRecord.) | |
selectRefRecord | Selects the record by referenced field ID. (Inherited from xRecord.) | |
selectWithRepeatableRead | Gets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.) | |
sendElectronically | ||
setConnection | Sets the user connection for this table. (Inherited from xRecord.) | |
setCrossPartition | Sets or resets cross-partitioning for the table. (Inherited from xRecord.) | |
setFieldValue | Sets the field value in the record buffer. (Inherited from xRecord.) | |
setSQLTracing | Enables or disables SQL tracing mode. (Inherited from xRecord.) | |
setTimeOut | Sets up the scheduled execution of a specified method. (Inherited from Object.) | |
setTmp | Sets the table so that it is not persisted to the database. (Inherited from xRecord.) | |
setTmpData | Sets the contents of the temporary table to the specified data. (Inherited from xRecord.) | |
setXDSContext | Sets new XDS context. (Inherited from xRecord.) | |
skipAosValidation | Gets and sets the property that indicates whether to skip validation of Microsoft Dynamics AX Application Object Server (AOS). (Inherited from xRecord.) | |
skipDatabaseLog | Gets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.) | |
skipDataMethods | Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.) | |
skipDeleteActions | Gets and sets the property that indicates whether to skip delete actions on the table. (Inherited from xRecord.) | |
skipDeleteMethod | Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.) | |
skipEvents | Provides an option to turn off calling the Application.event* methods for the lifetime of an xRecord object. (Inherited from xRecord.) | |
skipPostLoad | Gets and sets the property that indicates whether to skip executing the xRecord.postLoad method on the table. (Inherited from xRecord.) | |
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.) | |
sumMarkupEuro | Determines the equivalent amount in the euro currency for the amount in the SumMarkup field in an invoice journal. | |
sumTaxEuro | Determines the equivalent amount in the Euro currency for the amount in the SumMarkup field for an invoice journal. | |
suppressWarnings | Gets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.) | |
tableAccessRight | Returns the table access right. (Inherited from xRecord.) | |
tableBufferAccessRight | Returns the table access right for the current record. (Inherited from xRecord.) | |
takeOwnershipOfTempDBTable | (Inherited from xRecord.) | |
taxableBalanceEuro | ||
taxableBalanceMST | Determines the total tax base amount from all the tax transactions associated with invoice journals. | |
taxFreeBalance | ||
taxFreeBalanceEuro | ||
toolTipField | Retrieves the HelpText value for the specified field. (Inherited from xRecord.) | |
toolTipRecord | Retrieves the ToolTip value for the current record. (Inherited from xRecord.) | |
toString | Returns a string that represents the current object. (Inherited from Object.) | |
ttsabort | Aborts a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.) | |
ttsbegin | Starts a transaction that can be either committed by the ttscommit method or aborted by the ttsabort method. (Inherited from xRecord.) | |
ttscommit | Commits a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.) | |
update | Updates the current project invoice journal. | |
usageCount | Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.) | |
useExistingTempDBTable | (Inherited from xRecord.) | |
validateDelete | Determines whether the current record is valid and ready to be deleted from the database. (Inherited from xRecord.) | |
validateField | Determines whether the specified field is valid. (Inherited from xRecord.) | |
validateFieldValue | (Inherited from xRecord.) | |
validateWrite | Determines whether the current record is valid and ready to be written to the database. | |
validTimeStateUpdateMode | Sets a valid time state update mode on the cursor. (Inherited from xRecord.) | |
vatDueDate_W | ||
wait | Pauses a process. (Inherited from Object.) | |
wasCached | Specifies the location from which the data was retrieved. (Inherited from xRecord.) | |
wipInvoicedOnAcc | ||
write | Updates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.) | |
xml | Retrieves an XML string that represents the current object. (Inherited from xRecord.) | |
::adjustCostAmount | ||
::exist | Determines whether sales order invoices exist for a project invoice journal. | |
::find | Returns the invoice journal for the given invoice journal ID and invoice date. | |
::findRecId | ||
::getNumSeqAndVoucher | Creates a number sequence reference for new invocie journal. | |
::invoiceQuery | ||
::jumpRefInvoice | Launches a ProjInvoiceJournal object and passes an invoice journal record. | |
::lookupCustomsInvoiceID_IN | Lookup Project Custom's invoice id. | |
::revenueExists | Determines if revenue transaction lines are in the project invoice journal. | |
::updatePrinted |
Top
Fields
Field | Type | Configuration key | Description |
---|---|---|---|
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. |
CashDiscPercent | Extended Data Type: DiscPct Type: Real |
None | Discount in percentage. |
CostValue | Extended Data Type: CostAmountProject Type: Real |
None | Cost value of invoice content. |
CurrencyId | Extended Data Type: ProjSalesCurrencyCode Type: String |
None | Currency specified on the invoice. |
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)) |
DirectDebitMandate | 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) |
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. |
DocumentDate_W | Extended Data Type: DocumentDate Type: Date |
None | Date of any external document (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 |
EnterpriseNumber | Extended Data Type: TaxEnterpriseNumber Type: String |
None | Enterprise number used to identify Belgian companies. |
EUSalesList | Extended Data Type: ListDispatchId Type: String |
ForeignTrade | Sequence transaction number. |
ExchRate | Extended Data Type: ExchRate Type: Real |
None | Exchange rate for invoice amount. |
ExchrateSecondary | Extended Data Type: ExchrateSecondary Type: Real |
None | Rate of the secondary part of the currency calculation, when triangulation is used |
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 invoice. |
InvoiceDate | Extended Data Type: TransDate Type: Date |
None | Date of invoice. |
InvoiceNumberingCode_LT | Extended Data Type: NumberSequenceCode Type: String |
None | Invoice numbering code. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
InvoiceRegister_LT | Extended Data Type: LtDocRegister Type: Enum |
None | Include document in register log. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
InvoiceRoundOff | Extended Data Type: RoundOff Type: Real |
None | Rounding-off of invoice amount. |
InvoiceStatus_LT | Enumeration: LtDocStatus |
None | Document status for transaction. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
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. |
ListCodeId | Extended Data Type: ListcodeId Type: Enum |
ForeignTrade | List code to be used with the EU sales list. |
Narration_BR | Extended Data Type: Description Type: String |
None | The narration of the debit note. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
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. |
ParmId | Extended Data Type: ParmId Type: String |
None | Number of the reporting (one total update). |
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. |
PaymId | Extended Data Type: PaymId Type: String |
LedgerBasic | Payment identification used upon payment. |
Port | Extended Data Type: IntrastatPortId Type: String |
ForeignTrade | Port where current delivery is loaded. |
PostingJournalId | Extended Data Type: LedgerPostingJournalId Type: String |
ProjBasic | Journal name used when posting to journals. |
PostingProfile | Extended Data Type: CustPostingProfile Type: String |
None | Posting profile being processed. |
PrintedOriginals | Extended Data Type: PrintedOriginals Type: Integer |
None | Number of invoice originals printed. |
ProjGroupId | Extended Data Type: ProjGroupId Type: String |
ProjBasic | Project group that the invoice is associated with. |
ProjInvoiceId | Extended Data Type: ProjInvoiceId Type: String |
ProjBasic | Project - invoice number. |
ProjInvoiceProjId | Extended Data Type: ProjInvoiceProjId Type: String |
ProjBasic | Project contract identifier |
ProjInvoiceType | Enumeration: ProjInvoiceType |
ProjBasic | Specifies the type of invoice (invoice, on account, etc.). |
ProposalId | Extended Data Type: ProjProposalId Type: String |
ProjBasic | Number used currently with specified status. |
PSAEndDateMaxInvoiceId | Extended Data Type: ProjInvoiceId Type: String |
Project3 | Project - invoice number. (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)) |
qty | Extended Data Type: SalesQty Type: Real |
None | Quantity of units on invoice. |
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 | |
SalesDate_CZ | Extended Data Type: CzSalesDate Type: Date |
TradeDates_W | Transaction date (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. |
SMASpecIndexCalc | Extended Data Type: SMASpecIndexCalc Type: Enum |
SMASubscription | Should index calculation be specified. |
SourceDocumentHeader | Extended Data Type: RefRecId Type: Int64 |
None | Reference field in a different table |
SumLineDisc | Extended Data Type: DiscAmount Type: Real |
None | Total line discount on the invoice. |
SumMarkup | Extended Data Type: MarkupSumSales Type: Real |
Markup | The total incidental cost of product delivery |
SumTax | Extended Data Type: TaxAmountCur Type: Real |
LedgerBasicSalesTax | Total tax deducted. |
TaxGroupId | Extended Data Type: ProjTaxGroup Type: String |
ProjBasic | 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)) |
TaxPrintOnInvoice | Extended Data Type: TaxPrintOnInvoice Type: Enum |
LedgerBasicSalesTax | Write marking on invoice. |
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. |
VATNum | Extended Data Type: VATNumJournal Type: String |
LedgerBasicSalesTax | Tax exempt identification number |
Volume | Extended Data Type: Volume Type: Real |
None | Total volume of delivered items. |
VoucherNumberSequenceTable | Extended Data Type: ProjVoucherNumberSequenceTable Type: Int64 |
ProjBasic | Voucher series to be used in journals with the journal name. |
Weight | Extended Data Type: Weight Type: Real |
None | Total weight of the delivered items. |
WhoIsAuthor_LT | Enumeration: LtDocOriginator |
None | Originator of the document. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
Top
Field Groups
Field Group | Fields |
---|---|
TaxInformation_IN | |
TermsOfDelivery | |
Intrastat | |
InterCompany | |
Invoice | |
InvoiceNumbering_LT | |
Languages | |
Matching | |
Ledger | |
Misc | |
Narration_BR | |
Overview | |
PaymentSchedule | |
PrintingSpecifications | |
Project | |
PSA | |
Reason | |
PSAEndDateMaxInvoiceId | |
SalesTax | |
Subscription | |
System | |
AmountTotal | |
AutoReport | |
Amount | |
Currency | |
CurrencyShow | |
Customer | |
Data | |
Dimension | |
EInvoice | |
Address | |
Address_RU | |
AddressDisplay | |
WebCategoryBrowsing |
Top
Relations
Relation | Table | Lines |
---|---|---|
CashDisc | CashDisc | |
Currency | Currency | |
CustDirectDebitMandate | CustDirectDebitMandate | |
CustLedger | CustLedger | |
CustTable | CustTable | |
CustTable_Order | CustTable | |
dataAreaId | DataArea | |
DefaultDimension | DimensionAttributeValueSet | |
DeliveryPostalAddress_FK | LogisticsPostalAddress | |
DlvMode | DlvMode | |
DlvTerm | DlvTerm | |
IntrastatPort | IntrastatPort | |
InvoiceNumberingCode_LT | NumberSequenceTable | |
LanguageTable | LanguageTable | |
LanguageTable1 | LanguageTable | |
LedgerPostingJournal | LedgerPostingJournal | |
NumberSequenceGroup | NumberSequenceGroup | |
NumberSequenceTable | NumberSequenceTable | |
Partition | Partitions | |
PaymDay | PaymDay | |
PaymSched | PaymSched | |
PaymTerm | PaymTerm | |
ProjGroup | ProjGroup | |
ProjInvoiceId | ProjInvoiceJour | |
ProjInvoiceTable | ProjInvoiceTable | |
ProjProposalJour | ProjProposalJour | |
ReasonTableRef | ReasonTableRef | |
SourceDocumentHeader | SourceDocumentHeader | |
TaxGroupHeading | TaxGroupHeading | |
TaxInformation_IN | TaxInformation_IN | |
TransportationDocument | TransportationDocument |
Top
Indexes
Index | AllowDuplicates | Enabled | Fields |
---|---|---|---|
CustDirectDebitMandateIdx | Yes | Yes | |
FK_DimensionAttributeValueSet_ProjInvoic | Yes | Yes | |
InvoiceAccountIdx | Yes | Yes | |
InvoiceIdIdx | Yes | Yes | |
NumberSequenceTableIdx | Yes | Yes | |
OrderAccountIdx | Yes | Yes | |
ParmIdx | Yes | Yes | |
RecId | No | Yes | |
SourceDocumentHeaderIdx | Yes | Yes |
Top
Inheritance Hierarchy
xRecord Class
Common Table
ProjInvoiceJour Table