6.5.4.1 Accounting Records Mapping Table
- Former user (Deleted)
- Tobias Tillack
Collection / Distribution / Deferral Mapping
Accounting Rule
Accounting Record Field (target) | Accounting Rule Field (source) |
|---|---|
Account Number | Account Number |
Accounting Rule | Id |
Cost Center | Cost Center |
Dunning Block | Dunning Block |
Internal Order | Internal Order |
Profit Center | Profit Center |
WBS No. | WBS No. |
Invoice
Accounting Record Field (target) | Invoice Field (source) |
|---|---|
Currency | Currency |
Date of Receipt | Invoice Date |
Date of Revenue | Invoice Date |
Debitor Number | Debtor Debtor Id |
Invoice | Id |
Line Number | Invoice Full Number |
Payment Due Date | Payment Due Date |
Receipt Number | Invoice Full Number |
Transaction Type | Transaction Type |
Type of Receipt | Type Of Receipt |
Invoice Item
Accounting Record Field (target) | Invoice Item (source) |
|---|---|
Campaign Item | Campaign Item → Id |
Invoice Item | Id |
VAT | VAT Amount |
VAT Code | VAT External Name |
Media Campaign
Accounting Record Field (target) | Media Campaign (source) |
|---|---|
Company Code | Legal Entity → Company Code |
Legal Entity | Legal Entity → Id |
Payment Reference | Media Campaign Full Number |
Payment Processing | Payment Processing |
Reference | Media Campaign Full Number |
Terms of Payment | Terms of Payment → Name |
Terms of Payment Key | Terms of Payment → External Key |
VAT ID | Debtor → VAT ID |
AdServer ID
Accounting Record Field (target) | AdServer ID (source) | |
|---|---|---|
Advertising Medium (Delivery Data) | Site | Only filled for Accounting Rules based Delivery Data |
Logic
Accounting Record Field (target) | |
|---|---|
Accounting Period | Set to earliest open Accounting Period |
AccRec # | Auto Number field |
Amount | Calculated based on Process Type |
Debit / Credit | Set based on Process Type, Rule Type and Item Type |
Job Id | Id of Apex Job which created the Accounting Record |
Posting Date | Set based on Process Type and involved Accounting Period |
Record Type | Set based on Process Type |
Status | Set to "Created" |
Accrual Mapping
Accounting Rule
Accounting Record Field (taget) | Accounting Rule Field (source) |
|---|---|
Account Number | Account Number |
Accounting Rule | Id |
Cost Center | Cost Center |
Profit Center | Profit Center |
Dunning Block | Dunning Block |
Internal Order | Internal Order |
WBS No. | WBS No. |
Media Campaign
Accounting Record Field (target) | Media Campaign (source) |
|---|---|
Company Code | Legal Entity → Company Code |
Currency | Currency |
Debitor Number | Debtor → Account Number |
Legal Entity | Legal Entity → Id |
Line Number | Media Campaign Full Number |
Payment Reference | Media Campaign Full Number |
Payment Processing | Payment Processing |
Receipt Number | Media Campaign Full Number |
Reference | Media Campaign Full Number |
Terms of Payment | Terms of Payment → Name |
Terms of Payment Key | Terms of Payment → External Key |
Transaction Type | Transaction Type |
Type of Receipt | Document Type |
VAT ID | Debtor → VAT ID |
Campaign Item
Accounting Record Field (target) | Campaign Item (source) |
|---|---|
Campaign Item | Id |
VAT | VAT Amount |
VAT Code | VAT External Name |
AdServer ID
Accounting Record Field (target) | AdServer ID (source) | |
|---|---|---|
Advertising Medium (Delivery Data) | Site | Only filled for Accounting Rules based on Delivery Data |
Logic
Accounting Record Field (target) | |
|---|---|
Accounting Period | Set to earliest open Accounting Period |
AccRec # | Auto Number field |
Amount | Calculated based on Process Type |
Debit / Credit | Set based on Process Type, Rule Type and Item Type |
Job Id | Id of Apex Job which created the Accounting Record |
Posting Date | Set based on Process Type and involved Accounting Period |
Record Type | Set based on Process Type |
Status | Set to "Created" |