MGCLatticeSetBasedVendorPaymentJournalLineEntity
Imports vendor payment journal lines 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 | |
VendorAccount | VendAccount | Yes | |
Description | LedgerJournalTransTxt | No | |
CurrencyCode | CurrencyCode | No | |
ExchangeRate | ExchRate | No | |
DebitAmount | AmountCurDebit | No | |
CreditAmount | AmountCurCredit | No | |
MethodOfPayment | PaymMode | No | |
BankTransactionType | BankTransactionType | No | |
PaymentReference | PaymReference | No | |
PostingProfile | PostingProfile | 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 |
Description | LedgerJournalTrans | Txt |
CurrencyCode | LedgerJournalTrans | CurrencyCode |
ExchangeRate | LedgerJournalTrans | ExchRate |
DebitAmount | LedgerJournalTrans | AmountCurDebit |
CreditAmount | LedgerJournalTrans | AmountCurCredit |
MethodOfPayment | LedgerJournalTrans | PaymMode |
BankTransactionType | LedgerJournalTrans | BankTransType |
PaymentReference | LedgerJournalTrans | PaymReference |
PostingProfile | LedgerJournalTrans | PostingProfile |
OffsetAccountType | LedgerJournalTrans | OffsetAccountType |