MGCLatticeSetBasedProjectExpenseJournalLineEntity
Imports project expense journal lines (ledger journals of type Cost) in bulk with set-based processing: one new journal per journal key, or lines added to an open journal.
- Primary key:
JournalNumber, LineNumber
Fields
| Name | Type | Mandatory | Description |
|---|
JournalNumber | LedgerJournalId | Yes | |
JournalNameId | LedgerJournalNameId | No | |
LineNumber | LineNum | Yes | |
TransactionDate | TransDate | No | |
Voucher | Voucher | No | |
ProjectId | ProjId | Yes | |
ProjectCategoryId | ProjCategoryCostId | Yes | |
ProjectLinePropertyId | ProjLinePropertyId | No | |
ProjectDate | ProjTransDate | No | |
Quantity | Qty | No | |
CostPrice | CostPrice | No | |
SalesPrice | SalesPrice | No | |
SalesCurrencyCode | ProjSalesCurrencyCode | No | |
Description | LedgerJournalTransTxt | No | |
CurrencyCode | CurrencyCode | No | |
ExchangeRate | ExchRate | No | |
DebitAmount | AmountCurDebit | No | |
CreditAmount | AmountCurCredit | No | |
OffsetAccountType | LedgerJournalACType | No | |
OffsetAccountDisplayValue | DimensionDisplayValue | No | |
DefaultDimensionDisplayValue | DimensionDisplayValue | No | |
OffsetDefaultDimensionDisplayValue | DimensionDisplayValue | No | |
Mappings
| Entity field | Data source | Field |
|---|
JournalNumber | LedgerJournalTable | JournalNum |
JournalNameId | LedgerJournalTable | JournalName |
LineNumber | LedgerJournalTrans | LineNum |
TransactionDate | LedgerJournalTrans | TransDate |
Voucher | LedgerJournalTrans | Voucher |
ProjectCategoryId | LedgerJournalTrans_Project | CategoryId |
ProjectLinePropertyId | LedgerJournalTrans_Project | LinePropertyId |
ProjectDate | LedgerJournalTrans_Project | ProjTransDate |
Quantity | LedgerJournalTrans_Project | Qty |
CostPrice | LedgerJournalTrans_Project | CostPrice |
SalesPrice | LedgerJournalTrans_Project | SalesPrice |
SalesCurrencyCode | LedgerJournalTrans_Project | SalesCurrencyId |
Description | LedgerJournalTrans | Txt |
CurrencyCode | LedgerJournalTrans | CurrencyCode |
ExchangeRate | LedgerJournalTrans | ExchRate |
DebitAmount | LedgerJournalTrans | AmountCurDebit |
CreditAmount | LedgerJournalTrans | AmountCurCredit |
OffsetAccountType | LedgerJournalTrans | OffsetAccountType |