MGCLatticeSetBasedCustomerInvoiceJournalLineEntity
Imports customer invoices in bulk with set-based processing into general journals, which post the invoices to the customers: 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 | |
CustomerAccount | CustAccount | Yes | |
InvoiceNumber | InvoiceId | Yes | |
DocumentNumber | DocumentNum | No | |
DocumentDate | DocumentDate | No | |
DueDate | DueDate | No | |
TermsOfPayment | PaymTermId | No | |
Description | LedgerJournalTransTxt | No | |
CurrencyCode | CurrencyCode | No | |
ExchangeRate | ExchRate | No | |
DebitAmount | AmountCurDebit | No | |
CreditAmount | AmountCurCredit | No | |
MethodOfPayment | PaymMode | No | |
BankTransactionType | BankTransactionType | No | |
PaymentReference | PaymReference | No | |
SalesTaxGroup | TaxGroupJournal | No | |
ItemSalesTaxGroup | TaxGroupJournal | No | |
PostingProfile | PostingProfile | No | |
OffsetAccountType | LedgerJournalACType | No | |
OffsetAccountDisplayValue | DimensionDisplayValue | No | |
DefaultDimensionDisplayValue | DimensionDisplayValue | No | |
Mappings
| Entity field | Data source | Field |
|---|
JournalNumber | LedgerJournalTable | JournalNum |
JournalNameId | LedgerJournalTable | JournalName |
LineNumber | LedgerJournalTrans | LineNum |
TransactionDate | LedgerJournalTrans | TransDate |
Voucher | LedgerJournalTrans | Voucher |
InvoiceNumber | LedgerJournalTrans | Invoice |
DocumentNumber | LedgerJournalTrans | DocumentNum |
DocumentDate | LedgerJournalTrans | DocumentDate |
DueDate | LedgerJournalTrans | Due |
TermsOfPayment | LedgerJournalTrans | Payment |
Description | LedgerJournalTrans | Txt |
CurrencyCode | LedgerJournalTrans | CurrencyCode |
ExchangeRate | LedgerJournalTrans | ExchRate |
DebitAmount | LedgerJournalTrans | AmountCurDebit |
CreditAmount | LedgerJournalTrans | AmountCurCredit |
MethodOfPayment | LedgerJournalTrans | PaymMode |
BankTransactionType | LedgerJournalTrans | BankTransType |
PaymentReference | LedgerJournalTrans | PaymReference |
SalesTaxGroup | LedgerJournalTrans | TaxGroup |
ItemSalesTaxGroup | LedgerJournalTrans | TaxItemGroup |
PostingProfile | LedgerJournalTrans | PostingProfile |
OffsetAccountType | LedgerJournalTrans | OffsetAccountType |