Query. It can be N (none) , A (source project and task), B (source project, use client extension for task), C (specific project and task) or D (use client extension for project and task) Allocation run status. organization_id =ACTUAL BEHAVIOR. , revdist. NAME project_owning_org, CASE WHEN. denom_amountPurpose of Report: For the Work Order Execution of the MP battery, the production operator prints the Name Plate Label which contains the description of the product, logo, Designation, Type of MP Battery, Battery Number, Tray Number, Serial Number, Date, Nominal Voltage, Capacity, Number of cells, Weight, Volume of Acid,. cdl. Purpose of this report is to derive all projects expenditure and event details with cost information. BATCH_STATUS: VARCHAR2: 1: Status of the batch. The PJC_PRJ_REQ_DIST_V view displays attributes such as requisition number, item description, and vendor name. Project Foundation, Project Costing, Project Billing, Project Control. 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. PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. 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. AND ppa. usages_source_version. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. expenditure_item_id = RevDist. PJC_TRANSACTION_CONTROLS. project_id AND pei. Comment - Asset Source Line I need above fields will be in the fixed asset module 1. PJC_CC_DIST_LINES_ALL. You can configure transaction controls by employee, expenditure category, expenditure type, and non-labor. Project Management. Goal. Cost distribution. Task Number 4. Oracle Projects provides all system linkages upon installation. override_. pei. expenditure_item_id = pei. Next Page. attribute_category Pjc_Attribute_Category, ProjectsAtrbs. WHERE EXP. The errors are recorded against a transaction (identified by TRANSACTION_TYPE_CODE and. Tags: PA. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. NUMBER. Project Name 2. Applies to: Oracle Project Costing - Version 11. They would like to replicate this for custom reporting. ---------------. acct_event_id. pjc_exp_items_all pei,. source_project_id. usages_source_id, PjcExpAtrbsUsg. gl_date. Joining these tables, there are rows with opposite capitalizable_fl… Accepted answerlooking for PVO for BICC SYNC having columns TXN_XFACE_CTRL_ID and USER_BATCH_NAME from Table PJC_EXP_ITEMS_ALL. ** COST_IND_RATE_SCH_ID:. The identifier of the top task to which this tasks rolls up. Tables and Views for Project Management. Extract for Payments - Check and EFT. WHERE 1 = 1. . 3 there are some records with data corruption as reported in the r13833481. The relationships between Expenditure Types and System Linkages. cdl_line_number. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. 5. Previous Page. API Create a valid category set. 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. quantity. TRANSFERRED_FROM_EXP_ITEM_ID: NUMBER (15) The identifier of the expenditure item from which this expenditure item originated. project_id = pei. expenditure_item_id AND ptv. 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. val_unit_id, ct. Cloud Applications. Indicates an expenditure batch that will be imported from the PJC_EXP_ITEMS_ALL table. There can be only one record for the combination of Supplier and the invoice number. ei_latest_gl_period_name, x. 1. Stores expenditure type exclusions by interest rate code for each operating unit. NAME AS expenditure_bu, v515220161. Possible values are S for Submitted,P for Processed and E for Error: ADJUSTMENT_FLAG: VARCHAR2: 1: Indicates whether the batch that will be impoted is for expenditure item adjustments: CREATION_DATE:. Asset Number 5. name AS Ledger_name, GJS. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. Get it resolved, from our Support team. INVENTORY_ITEM_ID. 0 version, Manage Project Costs-Allocate Project Costs. How can we derive the segments in Payables, Purchasing and Expense using the Project Costing? Qn2:Please confirm that the distribution set be defaulted when I setup SLA even for Project Costing?-- Core processing tbale PJC_TXN_XFACE_ALL will be populated with all required ID columns after performing mapping of name to ID -- This control file can accept six different types of trasactions (Labor, Non Labor, Misc, Inventory, Supplier Invoices, Expenses) -- For each of above type, sequence of columns in CSV is defined as per following order. TRANSACTION_IDFROM pjc_exp_items_all peia, pjf_exp_types_vl pet, pjf_tasks_v ptv, 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. FROM hwm_tm_rep_atrbs PjcExpAtrbs, hwm_tm_rep_atrb_usages PjcExpAtrbsUsg, HWM_TM_ATRB_FLDS_B PjcExpAtrbFlds. AND doc. NUMBER. . TRANSACTION_SOURCE = 'OSCM'. event_id. source_task_id. Indicates Balance type. Oracle Applications P2P,O2C R2R, BI, Oracle Fusion Application, Oracle E Busines Suite, Oracle Financials, SLA, MPA, Functional, Technical,The system generated number that uniquely identifies the work type. pjc_expenditure_type_id = pet. attribute_number1 Pjc_Project_Id, ProjectsAtrbs. ei_project_name, x. Oracle ERP/ FSCM The table PJC_EXP_ITEMS_ALL has a foreign key to PJF_PROJ_ELEMENT as the Task table. transaction_id, 'CST_TRANSACTIONS' source_table, ct. PJB_ERRORS_U1. pjc_exp_items_all pei, okc_k_headers_all_b okha, hz_cust_accounts hca, hz_parties hp,. pjc_expenditure_type_id expenditure_type_id, crt. expenditure_item_id = pei. 1) Last updated on NOVEMBER 17, 2022. Index Uniqueness Tablespace Columns; PJC_ACCT_SWEEPER_LOGS_N2: Non Unique: Default: PJS_SUMMARY_ID: PJC_ACCT_SWEEPER_LOGS_N3: Non Unique: Default: PROJECT_ID: PJC_ACCT_SWEEPER_LOGS_U1:The flag indicates whether to create expenditure items automatically Y means release automatically: DUP_TARGETS_FLAG:. AP_Invoices_All has the unique key on invoice_id. acct_event_id. Project Portfolio. line_number AND ail. Who column: indicates the date and time of the creation of the row. project_id AND hou. project_id = pei. event_id = cdl. Now we need to join one of above table to ap_invoice_distributions_all table to get the distribution_id and later on we will join invoice_id and Invoice_distributoin_id to get expenditure_item_id from pjc_exp_items_all table. invoice_date. An invoice can have multiple distributions. 50. system_linkage_function FROM pjc_Exp_items_all exp WHERE exp. STEP 3: Generate PjcTxnXfaceStageAll_misc. source_attribute1. attribute_category Pjc_Expenditure_Type, PjcExpAtrbsUsg. PJC_EXP_ITEMS_ALL ei, GET_PERIOD_AVG_RATE gpavg WHERE aia. prvdr_pa_period_name, NVL (pei. Simply search with the table name in google, you’ll get complete details about the table and columns in it. linked_task_id. LINKED_PROJECT_ID, ERRORING_PROCESS, TRANSACTION_TYPE_CODE. INVENTORY_ITEM_ID. operating_unit_name, a. 90; TRANSFERRED_FROM_EXP_ITEM_ID = 1612017; Project: 4056; There is another Item ID, 1993043, which also has the. AND ppald. (Includes access to deeplinks for viewing project cost transaction, project overview, project plan pages) When you create a custom job role to provide self-service reporting access, make sure you add the correct. project_id = ptv. AR Transactions and Tax Query - India Localization. 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 PJC_CC_DIST_LINES_ALL. WITH gl_cmn_tbls. PJC_PRJ_PO_DIST_V. hr_all_organization_units_tl trx_org, pjb_rev_distributions prd, per_person_names_f ppn, per_all_people_f papf WHERE 1 = 1 AND pei. Who column: indicates the date and time of the creation of the row. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. UNION ALL. Who column: indicates the user who created the row. SELECT ppa. expenditure_item_id. 18. expenditure_item_id = pec. 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. AND imp. SQL_Statement. expenditure_item_id = pei. PJC_COMMITMENT_TXNS: pjf_exp_types_b: EXPENDITURE_TYPE_ID: PJC_COMMITMENT_TXNS: pjf_system_linkages: SYSTEM_LINKAGE_FUNCTION:. attribute_number4 Pjc_Project_Unit, ProjectsAtrbs. PJC_ALLOC_RULES_ALL: pjf_exp_types_b: OFFSET_EXP_TYPE_ID: PJC_ALLOC_RULES_ALL: pjf_projects_all_b: OFFSET_PROJECT_ID: PJC_ALLOC_RULES_ALL: pjf_proj_elements_b:. pjc_organization_id. 1. system_linkage_function /* 30623237 (SELECT exp. Title and Copyright Information; Get Help; 1 Overview. To get the. expenditure_item_id AND ptv. Views are logical representations of a single or combination of tables. period_name PERIOD_NAME. task_id(+) AND pei. pjc_exp_items_all: pjf_proj_elements_b: TASK_ID: pjf_proj_elements_b: pjf_proj_elements_b: PARENT_STRUCTURE_ID:. The attributes columns in PJC_EXP_ITEMS_ALL for my new transactions are also nullPJC_EXP_GROUPS_ALL. Examples of when your Oracle Payables application automatically creates rows in this table include. 1) Last updated on JULY 25, 2023. pdf) or read online for free. , revdist. Version (include the version you are using, if applicable):PA_TRANSACTION_CONTROLS stores the transaction controls defined for projects or tasks. Generate Draft Invoice uses the flag to exclude fully reversed, uninvoiced items from a customer invoice. person_number AS employee_number,. Other modules related tables list here : Tables for the PO (Purchase Order) in Oracle fusion. PJC_TXN_UPGRADE_TEMP: pjc_exp_items_all: PK1_ID: Indexes. The labor cost multiplier is populated for all overtime expenditure items charged to the task upon manual entry of the items or in the Overtime Calculation program **. I want to get the. There select the Expenditure Items API, you’ll be able to see all the methods, select required method (In our case select. TARGET_EXP_TYPE_ID: PJC_ALLOC_RULES_ALL: pjf_rbs_headers_b: ALLOC_RBS_HEADER_ID: PJC_ALLOC_RULES_ALL: pjf_system_linkages: OFFSET_EXP_TYPE_CLASS:. Cloud. AND TSRC. source_attribute2Goal. /* 1. Details. WHERE pcdl. 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, pjc_exp_comments pec1, pjf_exp_types_vl pet,. Details. 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. PARENT_LINE_NUMBER. ,pjc_exp_items_all PEI ,pjf_projects_all_vl PPA ,pjf_tasks_v PT ,okc_k_headers_all_b OKH ,okc_k_lines_b OKL ,pjf_txn_sources_vl PTS ,hr_operating_units HOU ,pjf_exp_types_vl PET ,pjf_exp_categories_vl PEC ,per_person_names_f PPN ,per_all_people_f PPF ,poz_suppliers_v PS. Hi, I have a report with expenses using tables like (EXM_EXPENSES, exm_expense_reports, exm_expense_types, EXM_EXPENSE_DISTS, pjc_exp_items_all, ap_invoices_all and ap_invoice_distributions_all). expenditure_item_id. TRUNC (peia. contract_line_id. The reason why the distribution is created by linking to the invoice line and the line and the distribution are not limited to one to one. 2 and laterHi team, We have a scenario for which we need to fetch all the eligible expenditures for a project without using PJC tables like pjc_Exp_items_all, PJC_COST_DIST_LINES_A… Accepted answer Mayank_Khatri 22 views 3 comments 0 points Most recent by Pradeep Balakrishnan Sep 28, 2023 7:04AM Project ManagementPrevious Next JavaScript must be enabled to correctly display this content . Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. This number is incremented every time that the row is updated. expenditure_item_date) ei_expenditure_item_date, peia. Schema: FUSION. attribute_number2 Pjc_Task_Id, ProjectsAtrbs. This expenditure item is the new item that is system created when an item is transferred and is charged to the new project/task: CONVERTED_FLAG: VARCHAR2 (1) Flag set to 'Y' if the item is converted. line_type. SELECT. invoice_line_number = ail. Object owner: PJC. TRANSFERRED_FROM_EXP_ITEM_ID. contract_id =. project_id AND ptv. FROM pjc_exp_items_all pei, pjf_projects_all_vl ppa, pjb_bill_trxs pbt, pjb_inv_line_dists pild, pjb_invoice_lines pil,. Date Placed in Service 8. Enter information into the employee number field (automatically entered in Oracle Personal Time and Expense). Source Line Description 7. document_id = ei. sql file in patch 13833481. TRANSACTION_NUMBER. TRANSACTION_SOURCE_ID = TSRC. Cloud. agreement_type, a. There is one row for each invoice distribution. Find the query of Receivable (AR) for the Invoice Number (TRX_NUMBER) Wise, Customer wise, Sales Order Wise, Transaction Date and GL Date Wise in Oracle Apps EBS R12. 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. AS (SELECT DISTINCT GL. expenditure_item_id. inventory_item_id}. CONNECTOR FIVETRAN_SCHEMA_NAME FIVETRAN_TABLE_NAME SOURCE_DATABASE_TABLE_MAPPING Oracle Fusion FSCM (ERP & SCM). txt - Free download as Text File (. NUMBER. invoice_id AND aid. TRANSACTION_IDTable Foreign Table Foreign Key Column; PJC_PATI_ADJ_QUEUE: pjc_exp_items_all: 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. PJC_EXP_ITEMS_ALL_N38: Non Unique: Default: PARENT_HEADER_ID: PJC_EXP_ITEMS_ALL_N39: Non Unique:. Dear All, About Oracle Fusion Applications Cloud (Oracle's SaaS ERP) . org_id employee_cost_org_id, pcdl. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. FROM pjc_exp_items_all ei , pjc_cost_dist_lines_all cdl, xla_events_gt imp, GL_ENCUMBRANCE_TYPES_VL GLET, pjf_txn_document_b doc. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Posts about Project Cost written by Pulkit jainhr_all_organization_units_tl trx_org, pjb_rev_distributions prd, per_person_names_f ppn, per_all_people_f papf WHERE 1 = 1 AND pei. source_id_int_1 = cdl. NUMBER. This causes some records to exist with NULL values in the DOCUMENT_DISTRIBUTION_ID in the PA_EXPENDITURE_ITEMS_ALL table. 18. . contract_type_id. Fusion HCM - Query for Personal Payment Method Details. WHERE ei. expenditure_item_id AS expenditure_item_id,. 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. TRANSACTION_NUMBER. expenditure_item_id. expenditure_item_id(+)PA_SYSTEM_LINKAGES stores system-defined categories used to determine how items should be processed. 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. AND imp. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Inventory item identifier and References {EGP_SYSTEM_ITEMS_B. Oracle Projects creates expenditure groups for supplier invoices transferred from Oracle Payables. Project Contracts Profile Options →. task_id(+) AND pei. Simply search with the table name in google, you’ll get complete details about the table and columns in it. They use stored queries that derive data from the tables on which the views are based. system_linkage_function /* 30623237 (SELECT exp. INVENTORY_ITEM_ID. linked_project_id. expenditure_item_id(+)name; source_bu_id. An expenditure item with the same transaction source and original system reference already exists. 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. . 23B. Query to Find Projects Not Accruing Revenue in Oracle Fusion --*-- SELECT PE. expenditure_item_id. 1. Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. Who column: indicates the date and time of the creation of the row. NAME ei_expenditure_org_name, op. This table is used to store the errors that could ocurr in various processes in project billing. After upgrading from 11i to 12. Tablespace: FUSION_TS_TX_DATA. LAST_UPDATED_BY EXP_CDL_LAST_UPDATED_BY. project_id AND pei. Tables and Views for Project Management; PJC_LOOKUPSGL Account analysis for PA Expenditure & Event query. . Oracle ERP/ FSCM. Also PO_DISTRIBUTIONS_ALL is the table which in my experience connects Purchase. Foreign Keys to Important PJC_EXPENDITURE_ITEMS_ALL Table Fields. expenditure_item_id, expenditureitempeo. pjc_exp_items_all expenditureitempeo, pjf_exp_types_vl pet. They can go online to PA Expenditure Item Inquiry and drill back to to the AP Invoice using the 'Item Details' functionality. accounting_period AS GL_PERIODNow we need to join one of above table to ap_invoice_distributions_all table to get the distribution_id and later on we will join invoice_id and Invoice_distributoin_id to get expenditure_item_id from pjc_exp_items_all table. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. ProjectsAtrbs. event_id = cdl. TRANSACTION_SOURCE_ID. FROM PJC_EXP_ITEMS_ALL EXP, PJF_TXN_SOURCES_B TSRC, PO_LINES_ALL POL. For third party integrations, the customer may interface the name or the identifier. FROM PJC_EXP_ITEMS_ALL PEI WHERE PEI. Next Page. Project Description 3. WHERE ei. . (SELECT expenditureitempeo. denom_currency_code. task_id = pei. This information will be interfaced to Oracle General Ledger from Oracle Projects. Simply search with the table name in google, you’ll get complete details about the table and columns in it. Joining these tables, there are rows with opposite capitalizable_fl… Accepted answerI am looking to pull the External Invoice Status of project expense in Oracle Fusion for a BIP Report. crt. 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. Object owner: PJC. 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. pjc_expenditure_item_date expenditure_item_date, crt. source_pa_date. R11i: PA: PAXTRAPE Incorrect Proj And Projfunc Burdened Cost (Doc ID 1543566. FROM pjc_exp_items_all EXP , pjf_proj_elements_b pt , pjf_projects_all_b pp , pjf_exp_types_vl et , pjf_system_linkages_vl syslink, pjf_exp_categories_vl exp_cat, PJF_NON_LABOR_RES_VL non_lab_res, PJF_TXN_SOURCES_VL TXN_SRC, pjf_txn_document_vl TXN_DOC, PJF_TXN_DOC_ENTRY_VL TXN_DOC_ENTRY, HR_ALL_ORGANIZATION_UNITS_VL HR_ORG. VARCHAR2. Applies to: Oracle Fusion Project Costing Cloud Service - Version 11. User-defined number that uniquely identifies the element within a project or structure. VARCHAR2. Fusion Inventory Queries2. project. cost_org_id, ct. Previous Next JavaScript must be enabled to correctly display this content . system_linkage_function /* 30623237 (SELECT exp. attribute_number7 Pjc_Work_Type,. ← Configurator Concurrent Programs. rev_distribution_id. Skip to Content; Skip to Search; Home; Cloud ApplicationsIf 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. Tables for the AP Invoice in Oracle fusion. PA_TXN_INTERFACE_AUDIT_ALL is used for auditing the updates taking place on PA_TRANSACTION_INTERFACE_ALL table. 0 and later Information in this document applies to any platform. select a. Cost associated with each expenditure type is excluded from the capitalized interest calculation. Extract for Payments - Check and EFT. Cloud Applications. PREDEFINED_FLAG = 'Y'. Based on the Event Processing Method defined at the project level, capital events are system generated or entered manually. approved_flag. Details. name; application_id. Contents. This information will be interfaced to Oracle General Ledger from Oracle Projects. Who column: indicates the user who created the row. | Data Managementexpenditure_item_id source_exp_item_id, line_num source_line_num, expenditure_item_date source_exp_item_date, burden_cost source_burden_cost, denom_burdened_cost source_denom_burdened_cost, acct_burdened_cost source_acct_burdened_cost, project_burdened_cost source_project_burdened_cost,. /*2. Value will be RCV. PJF_EXP_TYPES_VL. These expenditure groups have a status of 'RECEIVED'. WHERE pcdl. entered_currency_codeIt can be R (raw) or B (burdened) Cost type of offset transactions. description , chr (. source_prvdr_gl_date. project_id = prl. pjc_capital_events Stores information about events used to group costs and assets for capitalization and events used to generate retirement cost adjustments. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Flag that indicates whether the work type is billable or capitalizable. Regards, Zahid Rahim. Any idea in which table this can be found or any query to achieve this. project_id(+) AND pei. full_name AS employee_name,. Regards, Zahid Rahim. invoice_id = ail. 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. name; invoice_number. Details. carrying_out_organization_id AND hou1. project_id = PPA. Object type: TABLE. SELECT PjcExpAtrbs. E means Encumbrance entry. segment1 project_number, NVL ((SELECT pt. e. expenditure_item_id = cdl. The number of line items AP_INVOICE_LINES_ALL and Distribution AP_INVIOCE_DISTRIBUTIONS_ALL do not. which GL accounts will be hit by the system. 2. 50. pjc_project_id project_id, crt. 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. posted_flag. PJB_ERRORS. Change the transaction source or original system reference of the expenditure item to be imported. 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. Value will be RCV. 18. Object type: TABLE. Goal. It can be B (burdened) or R (raw) Offset method.