Mapping: Customer Account, Line Item, Clearing

Customer + company code is the customer account, company code · document · fiscal year · line is the line item — and a partial payment is a new document.

The debtor is customer + company code

Payment term, dunning block, reconciliation account, and accounting clerk are tied to A_CustomerCompany and therefore to the company code; from a commercial standpoint, the same customer in two company codes is two different things. The customer without a company code is the umbrella above them.

BilendoSAPRule
customer_numberCustomer + CompanyCodeconcatenated
external_parent_idA_Customer.CustomerUmbrella across the company codes
customer_name_1 … customer_countryA_BusinessPartner / A_BusinessPartnerAddressDefault address, country ISO-2
external_payment_termA_CustomerCompany.PaymentTermsKey
dunning_stopA_CustomerDunning.DunningBlockDunning block on the debtor
imported_reminder_stage / imported_last_reminder_dateA_CustomerDunning.DunningLevel / LastDunnedOnonly during the initial extraction — after that, Bilendo manages the level
Custom field “Dunning procedure” (mapped)A_CustomerDunning.DunningProcedure→ Bilendo dunning area
Custom field “Head office”A_CustomerCompany.CustomerHeadOfficepopulated = dunning is sent to the head office
Custom field “Reconciliation account” / “Accounting clerk”ReconciliationAccount / AccountingClerkthe structure the customer itself works by

Head office, alternative payer, and alternative dunning recipient are passed along as separate fields and are NOT resolved: who pays whom is a decision for the dunning strategy, not for the collector.

The open item

Identity in Bilendo: Company code · Document number · Fiscal year · Posting line. The fiscal year is part of it because document number ranges run per fiscal year. An item that is delivered again is updated.

BilendoSAP (A_OperationalAcctgDocItemCube)Rule
receipt_numberAccountingDocumentKey component
company_codeCompanyCodeKey component
fiscal_yearFiscalYearKey component
external_positionAccountingDocumentItemKey component
imported_customer_numberCustomer + CompanyCodeconcatenated like the customer account number
invoice_numberDocumentReferenceIDXBLNR — the invoice number from the customer's perspective
receipt_date / external_creation_dateDocumentDate / PostingDatePosting date is a delta anchor
due_dateNetDueDateNet due date; cash discount dates are carried alongside as custom fields
amount / currencyAmountInTransactionCurrency / TransactionCurrencySign derived from DebitCreditCode
external_doctypeAccountingDocumentTypeBLART → customer's mapping table
external_doctype_hintPostingKeydistinguishes invoice, credit memo, and payment within a document type
erp_associationAssignmentReferenceZUONR — the link for payments without clearing
dunning_stopDunningBlockingReasonBilendo doesn't dun what SAP blocks
delete_indicatorIsReversed / ReverseDocumentReversal withdraws the item
special_ledger_indicationSpecialGLCodepopulated = down payment, guarantee, memo item → not delivered
— (do not deliver)FinancialAccountType ≠ Dexcept within the scope of accounts payable

Clearing

Which of the two partial-payment models applies to you is the question where a wrong assumption immediately produces wrong amounts — that's why it appears in the "Business Decisions" question catalog.