MGCLatticeSetBasedProjectJournalLineEntity
Imports project hour and fee journal lines in bulk with set-based processing.
- Primary key:
JournalNumber, LineNumber
Fields
| Name | Type | Mandatory | Description |
|---|
JournalNumber | ProjJournalId | Yes | |
JournalNameId | ProjJournalNameId | No | |
JournalDescription | JournalDescription | No | |
LineNumber | LineNum | Yes | |
ProjectDate | ProjTransDate | No | |
VoucherDate | JournalTransDate | No | |
ProjectId | ProjId | No | |
CategoryId | ProjCategoryId | No | |
LinePropertyId | ProjLinePropertyId | No | |
WorkerPersonnelNumber | HcmPersonnelNumberId | No | |
Quantity | ProjQtyEmpl | No | |
CostPrice | ProjCostPriceCost | No | |
SalesPrice | ProjSalesPriceCost | No | |
SalesCurrencyCode | ProjSalesCurrencyCode | No | |
ActivityNumber | ProjActivityNumber | No | |
Text | Description255 | No | |
DefaultDimensionDisplayValue | DimensionDisplayValue | No | |
Mappings
| Entity field | Data source | Field |
|---|
JournalNumber | ProjJournalTable | JournalId |
JournalNameId | ProjJournalTable | JournalNameId |
JournalDescription | ProjJournalTable | Description |
LineNumber | ProjJournalTrans | LineNum |
ProjectDate | ProjJournalTrans | ProjTransDate |
VoucherDate | ProjJournalTrans | TransDate |
ProjectId | ProjJournalTrans | ProjId |
CategoryId | ProjJournalTrans | CategoryId |
LinePropertyId | ProjJournalTrans | LinePropertyId |
Quantity | ProjJournalTrans | Qty |
CostPrice | ProjJournalTrans | CostPrice |
SalesPrice | ProjJournalTrans | SalesPrice |
SalesCurrencyCode | ProjJournalTrans | CurrencyId |
ActivityNumber | ProjJournalTrans | ActivityNumber |
Text | ProjJournalTrans | Txt |