projfunc_cost_exchange_rate src_projfunc_cost_xchng_rate, bre. source_line_id_1. document_type. Used to implement optimistic locking. PJC_RESERVED_ATTRIBUTE1 FUNDING_SOURCE_ID/*Added for grants uptake*/, POD. Goal. I checked for this table PJC_COST_DIST_LINES_ALL and found these columns. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. ae_header_id FROM xla_distribution_links xda2 WHERE xda2. AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface. acct_event_id. 1. PA_CUST_REV_DIST_LINES_ALL is referenced by following: APPSPiper Sandler Companies Reports Third Quarter 2023 Results; Declares Quarterly Dividend of $0. The primary key on this table is:. The output should be Prepayment. approved_flag. trunc(cdl. There is one row for each invoice distribution. pjc_cost_dist_lines_all: pjf_rate_overrides: RATE_OVERRIDE_ID: Indexes. AP_INVOICE_DISTRIBUTIONS_ALL can also be used to find the connectivity between AP invoice & PO or AP invoices & Project. PJC_AWARD_DISTRIBUTIONS interfaces the data with invocation business functions. dist_line_id_reversed. Intern kicks of oracle invoice number tables after a template. FROM pjc_exp_items_all pei, pjf_projects_all_vl ppa, pjb_bill_trxs pbt, pjb_inv_line_dists pild, pjb_invoice_lines pil, pjb_invoice_headers pih, per_all_people_f ppf, per_person_names_f ppn, pjf_tasks_v pt, pjf_exp_types_vl pet, pjc_exp_comments pec WHERE 1 = 1 AND pei. Main: 903. Unique identifier for an allocation rule for the source line: LINE_NUM: NUMBER: Yes: Line number: EXCLUDE_FLAG: VARCHAR2: 1: Yes: The flag indicates whether to exclude returned projects Y means exclude: CREATED_BY: VARCHAR2: 64: Yes: Who column: indicates the user who created the row. " RAW_COST_DR_CCID" and. PJC_CONTRACT_LINE_ID: NUMBER: 18: DFF Column used by Standardized Project Cost Collection Widget: Active: PJC_FUNDING_ALLOCATION_ID:All: Closed: Capital data (asset line details) Capital: Closed: Actuals: - Cost distribution lines - Expenditure items and related tables - Cross charge transactions - Staffing transactions: All: Closed: Actuals: - Customer invoices - Revenue distribution lines: Contract: Closed: Actuals: - Cost distribution lines - Expenditure items and. David. SELECT * FROM PJC_COST_DIST_LINES_ALL D, PJF_PROJECTS_ALL_B P. For external Oracle Import, this flag is derived from the setup data atProject, Task and Document Entry level. WHERE ccdl_orig. pjf_projects_all_b ppab, pjf_projects_all_tl ppat, hr_all_organization_units hr, hr_all_organization_units hr1, hr_operating_units op, pjc_cost_dist_lines_all pcdl,. This column contains the vlaues to identify if current transaction is from internal source or external source. Re: Needs PA, CM, FA base tables [ message #189829 is a reply to message #189618] Mon, 28 August 2006 00:54. WHERE ccdl_orig. This is defaulted to a project from the project template. Please help in identifying the column mapping on fusion application to get the Burdened cost in Receiver Ledger Currency. For external Oracle Import, this flag is derived from the setup data atProject, Task and Document Entry level. 12. Only While uploading the Accounted Project costing transactions with accounting entries, the CCID columns viz. We are trying to find the lookup values for the field PJC_COST_DIST_LINES_ALL. project_status, a. CONTRACT_ID: NUMBER: 18: Identifier of the contract for which the rate override is defined. Cost distribution. AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that is manually entered or system-generated. 21. per_roles_dn 4. Oracle Projects Tables: PA_ACCUM_COLUMNS PA_ACCUM_COLUMN_VALUES PA_ACCUM_TXN_TIME PA_ACTION_SETS PA_ACTION_SETS_AR PA_ACTION_SET_LINES PA_ACTION_SET_LINES_AR PA. PJC_XCC_BURDEN_DIST_ERRORS; PJC_XCC_BURDEN_DIST_ERRORS. pjc_project_id. xla_ae_headers. PrimaryKey: Finds all adjustments performed on the specified project cost. PO_DISTRIBUTIONS_ALL contains accounting distribution information for a purchase order shipment line. Piper Sandler Appoints Dustin Avey and Jeremy Gerber as Co-Heads of Public Finance. ae_header_id = ael1. 1. pjc_task_id. PA_DRAFT_REVENUES_ALL. There are more that 200 records in the table "PJC_COST_DIST_LINES_ALL" Content. 2400 Clarksville Street. GL_LEDGERS g, ap_invoices_all i, POZ_SUPPLIERS_V v, HR_ORGANIZATION_V o, PJF_EXPEND_TYP_SYS_LINKS es, PJF_EXP_TYPES_B et , PJF_TASKS_V t,. AND ROWNUM<=1. expenditure_item_idIt is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. PA_CUST_EVENT_RDL_ALL. AND imp. Oracle Fusion ERP Analytics. DENOM_BURDENED_COST NUMBER Total burdened cost of the expenditure item in transacti. enabled_flag. OVERLAY_DIST_CODE_CONCAT: VARCHAR2: 250:. pa_period_name. For this request we need to know list of the Project tables which will be updated while running Create accounting process for the Expenditure / Costing. ref_ae_line_num IS NULL AND xda2. meaning. attribute2. name columns; pjc_acct_sweeper_logs_pk. FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp. 2) adjusting revenue distribution lines are created when you. ind_rate_sch_revision_id = irsr. PA. It stores currency related information about cost distribution lines for each reporting set of books associated with the parent record on PA_COST_DISTRIBUTION_LINES_ALL. attribute6. AND PRD. This column contains the identifier of the Accounting Event in SLA. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. per_users 2. Active: TRANSFER_COST_DIST_ACCOUNT: NUMBER: 18: Transaction transfer cost distribution account: Active: WAYBILL_AIRBILL: VARCHAR2: 20:. VARCHAR2. Currently I am using pjc_cost_dist_lines_all table in my quer… Accepted answer Ankit_Bhadja 14 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-Oracle Aug 28, 2023 9:44AM Project Management23. Purpose of this report is to display Project billable hours for Internal ===== /* Formatted on 2018/07/30 15:40 (Formatter Plus v4. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. denom_burdened_cost AS amount. The code you enter must be ITEM, TAX, MISCELLANEOUS, or FREIGHT. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. xla_ae_lines. F81674-01. current_run_id extn_current_run_id, bre. Default. A distribution must be associated with an invoice. ref_ae_line_num = xda2. FROM. When a cost distribution program processes an expenditure item, it creates one or more corresponding cost distribution lines to hold the cost amounts and the general ledger account information to which the cost amounts will. Total burdened cost of the expenditure item in transaction currency Burdened cost = (raw cost * (1 + burden cost multiplier)) This must equal the sum of the items burden debit cost distribution lines For non-burdened items, burdened cost. Paris, Texas 75460 Tel: (903) 785-7661 Contact Us. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. ei_revenue_distributed_flag, x. Name of the pay element. inventory_item_id,i. Oracle Fusion Cloud Project Management. expenditure_item_id = pei. 2. But i cant find any type join. Dec 23, 2021 12:06PM edited Dec 23, 2021 12:08PM 1 comment. acct_event_id. PJC’s Brewer drafted by Yankees (2022) Beau Brewer of McKinney,. We want to extract only those that are posted in GL. ae_line_num AND xda1. organization_id. Solution. This information will be interfaced to Oracle General Ledger from Oracle Projects. name AS Ledger_name, GJS. ExpenditureItemId; integer; Identifier of the project cost. ei_latest_gl_period_name, x. Advising and Counseling. This input is required to create reports, understand links between various charts, and even for troubleshooting purpose. approved_flag. FROM pjc_cost_dist_lines_all cdl, pjc_exp_items_all ei, pjf_ind_compiled_sets ics, pjf_irs_revisions irsr, pjf_cost_base_exp_types cbet, pjf_compiled_multipliers cm,. In this Document. WHERE ccdl_orig. Examples of when your Oracle Payables application automatically creates rows in this table include. Foreign Keys to Important PJC_EXPENDITURE_ITEMS_ALL Table Fields Here is a table that lists the foreign keys of the ORIGINAL_HEADER_ID, ORIGINAL_DIST_ID, and ORIGINAL_LINE_NUMBER fields in the PJC_EXPENDITURE_ITEMS_ALL table in some of the most commonly-used transaction sources and documents. The level of summarization in this table is controlled by the CIP Grouping Method for the project type, as well as by the level (task or. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. 1. Processing Start Date, calculated as the maximum award, project, task, assignment, or labor schedule start date. Summary: Get all project costs Rest api not returning any values We are using below rest API to get all project cost details. source_line_id_4. Home / Fusion / Query to Find NonBillable Expense in Oracle Fusion. Table Foreign Table Foreign Key Column; PJF_PERIODS_ALL: pjf_bu_impl_all: ORG_ID: pjc_cost_dist_lines_all: pjf_periods_all: PRVDR_PA_PERIOD_NAME, ORG_ID: pjc_cost_dist_lines_all It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. expenditure_type_id pjf_projects_all_b ppab, pjf_projects_all_tl ppat, hr_all_organization_units hr, hr_all_organization_units hr1, hr_operating_units op, pjc_cost_dist_lines_all pcdl, pjf_exp_categories_tl pec, gl_code_combinations gcc, per_person_names_f ppn, pjb_rev_distributions prd, pjb_errors pe, xla_distribution_links xda, xla_ae_lines xal, ap_invoice. Keyword Analysis & Research: pjc_cost_dist_lines_all in oracle fusionMetrics added for data validation. Goal. From my research, it seems that the OTL. operating_unit_name, a. source_header_id_1. It cc_process_labor_flag is set t. 13. Learn how to use a query in Oracle Fusion to find project estimation to complete based on budgeted and actual costs, hours, and revenue. Posted by Manjesh's Fusion World at 2:42 AM No comments: Email This BlogThis! Share to Twitter Share to Facebook Share to Pinterest. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. need_by_date. . Burdenable Raw Cost: ACCOUNTING_EVENT_ID: NUMBER: 18:. To override the cost center in the account, enter a value. ACCOUNTING_DEFINITION_ID: NUMBER: 18: Yes: Reference to the cost accounting definition line. It stores currency related information about project asset lines for each reporting set of books associated with the parent record on PJC_PRJ_ASSET_LNS_ALL. name; award_distribution_line_id. pjc_expenditure_type_id. expenditure_item_date expenditure_item_date2. PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. 0 and later: Detailes About Some Errors from Table PJC_TXN_ERRORS. xla_distribution_links. Inventory Transactions subject area with 1 base metric. cc_dist_line_id(+) = ccdl. These lookup codes are stored in the AP_LOOKUP_CODES table. 1) Last updated on NOVEMBER 08, 2022. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. award_distribution_batch_id. dist_base_amount dist_base_amount, l. The system generated number that uniquely identifies the work type. cc_dist_line_id(+) = ccdl. WHERE D. description. source_line_id_1. Free essays, homework help, flashcards, research papers, book reports, term papers, history, science, politicsAP_INVOICE_LINES_ALL is one of the most important table in P2P Cycle. acct_event_id. . Assignment ID related to the assignment record for this labor cost. dist_line_id_reversed. Provision with single sign-on. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. source_line_id_3. ind_rate_sch_revision_id = irsr. This release works with any of the currently supported Oracle Fusion Cloud Applications versions and the minimum Oracle Fusion Cloud Applications version is 23A (11. This column contains the identifier of. pa_date. InvoicesThey can be found in MetaLink, Knowledge, (scroll down left navigator) Online Documentation, last item. 23. project_id = ppa. FROM pjc_cost_dist_lines_all pcdl, pjf_projects_b_v pp, pjf_project_types_b_v ppt, pjf_proj_elements_b_v pt, pjc_exp_items_all pei, pjf_exp_types_b_v pet, pjf_exp_categories_b_v pec, pjc_cint_rate_names pcrn, pjc_cint_rate_info_all pcri, gl_period_statuses gps, pjf_bu_impl_v imp. 18. Flag that indicates whether the work type is billable or capitalizable. PJC_AWARD_DIST_LINES_U1. Currently I am using pjc_cost_dist_lines_all table in my query to derive cost transactions data. attribute5. 1 Overview Project Portfolio Management Tables and Views 2 Grants Management Tables Views 3 Project Billing Tables Views 4 Project Collaboration Tables 5 Project Control Tables Views 6 Project Costing Tables Views 7 Project Foundation Tables Views 8 Project Management Tables Views 9 Project Management Control Tables Views For example, the PJC_COST_DIST_LINES_ALL table stores the cost distributions for expenditure items, including attributes such as expenditure item ID, line number, and quantity. PA_CUST_REV_DIST_LINES_ALL does not reference any database object. pjc_contract_line_id CONTRACT_LINE_ID/*Added for grants uptake*/, l. ,d. You can optionally redirect only certain. source_prvdr_gl_date. Dear , I need to join my external transaction into accounting so i can check period name and account status. data_set_id data_set_id, ei. Default flag for items charged to the task that indicates if the item can accrue revenue (Y or N). expenditure_type_idProgram for Return to Vendor in Oracle purchasing (1) Program to create receipts for approved Purchase order (1) Project Accounting (1) Project Contract Table Links in Fusion (1) Project Cost query (1) Project Details query Fusion (1) Project Directory query in Fusion (1) Project invoice query in fusion (1)Yes. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. display_sequencePurpose of this report is to derive all projects expenditure and event details with cost information. 1. PJC: Add Project Validations Using Cost Collection Descriptive Flexfields In Invoice Page (Doc ID 2417605. This table stores exceptions encountered during burden cost generation, planning resource breakdown structure element mapping for raw cost and burden cost, or burden cost account generation. Required fields are marked. Paris Junior College. AND imp. SOURCE_LINE_ID_2:. expenditure_item_idAP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that is manually entered or system-generated. For this request we need. projfunc_cost_exchange_rate src_projfunc_cost_xchng_rate, bre. Founded In 1924. Refer to comments on the columns in the main table. C for cost rate override and B for bill rate override. possible vlaues I,P,R,E. Solution. 1) you account for borrowed and lent revenue for labor or usage. expenditure_type_id = pet. COST MANAGEMENT AND CONTROL. requestor_nameEnd date of the payroll period. They need a way to review their expenditure costs and the accounting to see how it will affect their financials before the expenditures ever gets released. pjf_projects_all_b ppab, pjf_projects_all_tl ppat, hr_all_organization_units hr, hr_all_organization_units hr1, hr_operating_units op, pjc_cost_dist_lines_all pcdl, pjf_exp_categories_tl pec, gl_code_combinations gcc, pjb_errors pe, okc_k_headers_all_b okh, okc_k_lines_b okl, pjb_bill_plans_vl pjbp, okc_contract_types_tl okct,. expenditure_item_id = pei. Goal. Once all lines associated with a schedule are purged, the whole schedule is purged. T. April 17 edited April 17. AP_Invoices_All has the unique key on invoice_id. Adding those ought to give "20", but the UNION will eliminate one of the "10"s and the answer will be "10" instead of. Content (required): The values in this field are RPBNN. description. pa_cost_distribution_lines_all. If the task is a top task, the top_task_id is set to its own task_id. pjc_txn_xface_all: pjf_work_types_b: WORK_TYPE_ID: pjc_cost_dist_lines_all: pjf_work_types_b: WORK_TYPE_ID: Indexes. When you select a Distribution Set for an invoice, your Oracle Payables application uses this information to create invoice distribution. inventory_item_id,i. PA_COST_DIST_OVERRIDES stores configurations defined at the project level that redirect specific costs and revenue to another organization. source_line_id_2. INVOICE_TYPE_LOOKUP_CODE. dist_acct_burdened_cost dist_acct_burdened_cost, l. Fusion User Roles SQL Query & Tables. FROM pjc_exp_items_all pei, pjf_projects_all_vl ppa, pjb_bill_trxs pbt, pjb_inv_line_dists pild, pjb_invoice_lines pil, pjb_invoice_headers pih, per_all_people_f ppf, per_person_names_f ppn, pjf_tasks_v pt, pjf_exp_types_vl pet, pjc_exp_comments pec WHERE 1 = 1 AND pei. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. RAW_COST: NUMBER (22) ORG_ID: NUMBER (15) OUTPUT_VAT_TAX_ID: NUMBER: Default output tax code identifier for invoice line: OUTPUT_TAX_EXEMPT_FLAG: VARCHAR2 (1). accounting_event_id) source_header_id_1, ' ' source_header_id_2, decode(cre. COST_ID: NUMBER: 18: Yes: Reference to the layer, write-off or transfer. release_revision. calc_burden_status extn_calc_burden_status, cdl. The level of summarization in this table is controlled by the CIP Grouping Method for the project type, as well as by the level (task or. pjc_expenditure_item_date. VARCHAR2. When a cost distribution program processes an expenditure item, it creates one or more corresponding cost distribution lines to hold the cost amounts and the general ledger account information to which the cost amounts will post. source_line_id_4. INVOICE_TYPE_LOOKUP_CODE. Paris, Texas 75460 Tel: (903) 785-7661 Contact Us. ever_approved_flag. Previous Page. F85651-01. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. project_id AND pbt. Unique. expenditure_item_id. line_type in ('R', 'B') AND pcdl. if you are looking to connect the AP invoice to any entity like PO/ Project etc, most probably this is your table like you can use PO_DISTRIBUTION_ID to. dist_line_id_reversed. ae_line_num = ael1. FROM pjc_exp_items_all pei, pjf_projects_all_vl ppa, pjb_bill_trxs pbt, pjb_inv_line_dists pild, pjb_invoice_lines pil, pjb_invoice_headers pih, per_all_people_f ppf, per_person_names_f ppn, pjf_tasks_v pt, pjf_exp_types_vl pet, pjc_exp_comments pec WHERE 1 = 1 AND pei. SELECT pcdl. ,d. PA tables in fusion - Read online for free. Default flag for items charged to the task that indicates if the item can accrue revenue (Y or N). project_number, a. 2. FROM pjc_cost_dist_lines_all projectcostdistributionpeo, pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet WHERE (projectcostdistributionpeo. The schedule must be for the organization specified in the Submit Purge window. For indirect projects this flag is set. expenditure_item_idWITH gl_cmn_tbls. Applies to: Oracle Fusion Project. display_sequencePurpose of this report is to derive all projects expenditure and event details with cost information. Active. Paris, Texas 75460. The issue can be reproduced at will with the following steps: 1. Indicates the code used to derive default rate dates. HTH. source_id_int_1 = ccdl. pjc_capitalizable. Schema: FUSION. Tablespace: Default. The Paris Junior College District. line_type in ('R', 'B') AND. I see cost distributions and expenditures on a project from AP but when mapping the cost distribution back to the. Tables and Views for Financials. expenditure_item_id AND expenditureitempeo. 0 and later Information in this document applies to any platform. PA_PROJECT_ASSET_LINES_ALL stores summarized project CIP cost lines. Meeting support account set certain item flexfield attribute you enter the combination of the overflow. From my research, it seems that the OTL timecard tables are HXT_TM_MTRX and HXT_TM_HEADER. User can “View Accounting” only after “Create Accounting” is run. CAC ICP PII Material Account Detail CAC ICP PII Material Account Summary CAC ICP PII WIP Material Usage Variance CAC ICP PII WIP Pending Cost Adjustment CAC ICP PII vs. Tables and Views for Project Management. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Approve the PO 3. This information will be interfaced to Oracle General Ledger from Oracle Projects. project_name,We have a query that extracts records from PJC_COST_DIST_LINES_ALL. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. The identifier of the top task to which this tasks rolls up. NUMBER. source_line_id_3. lookup_code. When an asset line is initially created, this table contains one record for each cost distribution line summarized into the asset line. **. Currently I am using pjc_cost_dist_lines_all table in my quer… Accepted answer Ankit_Bhadja 11 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-Oracle Aug 28, 2023 9:44AM Project ManagementTable to store Catalog of Federal Domestic Assistance values. gl_ledgers g, per_person_names_f_v req, po_line_types lt, por_requisition_lines_all rl, por_requisition_headers_all rh, pjf_tasks_v t, hr_organization_v o, pjf_exp_types_vl et, por_req_distributions_all rd, pjf_projects_all_vl p, pjf_exp_categories_vl cat, fun_all. VARCHAR2. Oracle Fusion Cloud Financials. acct_event_id. SELECT revenue_type, TO_CHAR (customer_id) customer_id, customer_name, TO_CHAR (project_id) project_id, project_number, contract_number,. Transaction identifier of the burden cost. expenditure_item_id = expenditureitempeo. 72. expenditure_item_idIf you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. An invoice can have one or more invoice lines. EBS Tables. CREATED_BY EXP_CDL_DIST_CREATED_BY, trunc(cdl. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. VARCHAR2. ae_header_id. Name of the pay element. This table corresponds to the Invoice distributions window of Invoice workbench. rounding_class_code = 'RAW_COST_CLEARING' AND NOT EXISTS ( SELECT 1 FROM xla_distribution_links xda1 WHERE xda1. FROM pjc_cost_dist_lines_all pcdl, pjc_exp_items_all pei, pjf_tasks_v ptv, pjf_projects_all_b prb, pjf_projects_all_tl prl,. Columns. cc_dist_line_id(+) = ccdl. This flag determines if Cross Charge processing is allowed or not. actual_amount, 0)) - SUM(nvl(main. dist_acct_raw_cost dist_acct_raw_cost, l. source_line_id_5Qn1:The customer wants to have the ability to "view accounting" for unreleased expenditure batches. Through testing we decided we just need one by expend…Subject: SQL query to get the Project Details, Contract Details, Invoice Details--SQL Query:--SELECT. Add to Compare. INVOICE_TYPE_LOOKUP_CODE. Cost distribution lines amount are implicitly debit amounts. We would like to show you a description here but the site won’t allow us. Index Uniqueness Tablespace Columns; PJF_RATE_OVERRIDES_N1: Non Unique: Default:. lookup_code. EVENT_ID: NUMBER: 18: Reference to the event created in the SLA for this distribution header line. We want to derive the Accounting Code Combination based on Expenditure Types.