MGCLatticeProjectPostedTransactionEntity
The MGCLatticeProjectPostedTransactionEntity exposes posted project cost and revenue postings from ProjTransPosting. Read-only export entity with an explicit minimal field projection. Because ProjTransPosting stores multiple posting rows per project transaction (one per posting type), TransId is not unique; the entity is keyed on a SysRecId surrogate mapped to the table RecId.
- Public collection name:
LatticeProjectPostedTransactions
- Primary key:
SysRecId
Fields
| Name | Type | Mandatory | Description |
|---|
TransactionId | Num | No | |
ProjectId | ProjId | No | |
ProjectTransactionType | ProjTransType | No | |
TransactionDate | ProjTransDate | No | |
CategoryId | ProjCategoryId | No | |
PostingType | LedgerPostingType | No | |
AccountingCurrencyAmount | AmountMSTDebCred | No | |
Quantity | ProjQtyEmpl | No | |
InventoryLotId | InventTransId | No | |
ProjectFundingSourceRecId | ProjFundingSourceRefId | No | |
SysRecId | RefRecId | No | |
Mappings
| Entity field | Data source | Field |
|---|
TransactionId | ProjTransPosting | TransId |
ProjectId | ProjTransPosting | ProjId |
ProjectTransactionType | ProjTransPosting | ProjTransType |
TransactionDate | ProjTransPosting | ProjTransDate |
CategoryId | ProjTransPosting | CategoryId |
PostingType | ProjTransPosting | PostingType |
AccountingCurrencyAmount | ProjTransPosting | AmountMst |
Quantity | ProjTransPosting | Qty |
InventoryLotId | ProjTransPosting | InventTransId |
ProjectFundingSourceRecId | ProjTransPosting | ProjFundingSource |
SysRecId | ProjTransPosting | RecId |