PJC_BC_PACKETS_T_LINE_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name

PROCESS_ID SOURCE_LINE_ID_CHAR_1 SOURCE_LINE_ID_CHAR_2 SOURCE_LINE_ID_CHAR_3 SOURCE_LINE_ID_CHAR_4 SOURCE_LINE_ID_CHAR_5 SOURCE_LINE_ID_NUM_1 SOURCE_LINE_ID_NUM_2 SOURCE_LINE_ID_NUM_3 SOURCE_LINE_ID_NUM_4 SOURCE_LINE_ID_NUM_5 ACCOUNTING_LINE_CODE ACCOUNTING_LINE_TYPE_CODE SOURCE_HEADER_ID_CHAR_1 SOURCE_HEADER_ID_CHAR_2 SOURCE_HEADER_ID_CHAR_3 SOURCE_HEADER_ID_CHAR_4 SOURCE_HEADER_ID_NUM_1 SOURCE_HEADER_ID_NUM_2 SOURCE_HEADER_ID_NUM_3 SOURCE_HEADER_ID_NUM_4 APPLIED_TO_SRC_LINE_ID_CHAR_1 APPLIED_TO_SRC_LINE_ID_CHAR_2 APPLIED_TO_SRC_LINE_ID_CHAR_3 APPLIED_TO_SRC_LINE_ID_CHAR_4 APPLIED_TO_SRC_LINE_ID_CHAR_5 APPLIED_TO_SRC_LINE_ID_NUM_1 APPLIED_TO_SRC_LINE_ID_NUM_2 APPLIED_TO_SRC_LINE_ID_NUM_3 APPLIED_TO_SRC_LINE_ID_NUM_4 APPLIED_TO_SRC_LINE_ID_NUM_5 ENTERED_CURRENCY POSTED_AMOUNT ACCOUNTED_CURRENCY POSTED_ACCOUNTED_AMT ACCOUNTING_LEDGER_ID BALANCE_TYPE_CODE BALANCE_SUBTYPE_ID BUDGET_LEDGER_ID BUDGET_DATE ACCOUNTING_DATE CODE_COMBINATION_ID PROJECT_ID TASK_ID RBS_ELEMENT_ID K_HEADER_ID K_LINE_ID FUND_ALLOCATION_ID GL_PERIOD_SET_NAME GL_PERIOD_NAME BUDGET_PERIOD_SET_NAME BUDGET_PERIOD_NAME BUDGET_CODE_COMBINATION_ID CLOSE_PRIOR_FLAG ACCOUNT_PRIOR_FLAG BUDGET_TRAN_TYPE XCC_GEN_PARENT_FLAG BOM_LABOR_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID PERSON_ID EVENT_ID EXPENDITURE_TYPE_ID ITEM_CATEGORY_ID INVENTORY_ITEM_ID JOB_ID PERSON_TYPE_ID NON_LABOR_RESOURCE_ID PROJECT_ROLE_ID VENDOR_ID ORGANIZATION_ID EXPENDITURE_ITEM_DATE ENTERED_DR ENTERED_CR ACCOUNTED_DR ACCOUNTED_CR DOCUMENT_TYPE TRANSACTION_DISTRIBUTION_TYPE BC_PACKET_ID PARENT_BC_PACKET_ID

Query

SQL_Statement

SELECT -1 PROCESS_ID, NULL SOURCE_LINE_ID_CHAR_1, NULL SOURCE_LINE_ID_CHAR_2, NULL SOURCE_LINE_ID_CHAR_3, NULL SOURCE_LINE_ID_CHAR_4, NULL SOURCE_LINE_ID_CHAR_5, bc.DOCUMENT_DISTRIBUTION_ID SOURCE_LINE_ID_NUM_1, NULL SOURCE_LINE_ID_NUM_2, NULL SOURCE_LINE_ID_NUM_3, NULL SOURCE_LINE_ID_NUM_4, NULL SOURCE_LINE_ID_NUM_5, NULL ACCOUNTING_LINE_CODE, NULL ACCOUNTING_LINE_TYPE_CODE, NULL SOURCE_HEADER_ID_CHAR_1, NULL SOURCE_HEADER_ID_CHAR_2, NULL SOURCE_HEADER_ID_CHAR_3, NULL SOURCE_HEADER_ID_CHAR_4, bc.DOCUMENT_HEADER_ID SOURCE_HEADER_ID_NUM_1, NULL SOURCE_HEADER_ID_NUM_2, NULL SOURCE_HEADER_ID_NUM_3, NULL SOURCE_HEADER_ID_NUM_4, NULL APPLIED_TO_SRC_LINE_ID_CHAR_1, NULL APPLIED_TO_SRC_LINE_ID_CHAR_2, NULL APPLIED_TO_SRC_LINE_ID_CHAR_3, NULL APPLIED_TO_SRC_LINE_ID_CHAR_4, NULL APPLIED_TO_SRC_LINE_ID_CHAR_5, NULL APPLIED_TO_SRC_LINE_ID_NUM_1, NULL APPLIED_TO_SRC_LINE_ID_NUM_2, NULL APPLIED_TO_SRC_LINE_ID_NUM_3, NULL APPLIED_TO_SRC_LINE_ID_NUM_4, NULL APPLIED_TO_SRC_LINE_ID_NUM_5, bc.ENTERED_CURRENCY_CODE ENTERED_CURRENCY, NULL POSTED_AMOUNT, bc.ACCOUNTED_CURRENCY_CODE ACCOUNTED_CURRENCY, NULL POSTED_ACCOUNTED_AMT, bc.ACCOUNTING_LEDGER_ID ACCOUNTING_LEDGER_ID, bc.BALANCE_TYPE_CODE BALANCE_TYPE_CODE, bc.BALANCE_SUBTYPE_ID BALANCE_SUBTYPE_ID, NULL BUDGET_LEDGER_ID, bc.BUDGET_DATE BUDGET_DATE, bc.GL_DATE ACCOUNTING_DATE, NULL CODE_COMBINATION_ID, bc.PROJECT_ID PROJECT_ID, bc.TASK_ID TASK_ID, bc.RBS_ELEMENT_ID RBS_ELEMENT_ID, NULL K_HEADER_ID, NULL K_LINE_ID, NULL FUND_ALLOCATION_ID, NULL GL_PERIOD_SET_NAME, NULL GL_PERIOD_NAME, NULL BUDGET_PERIOD_SET_NAME, NULL BUDGET_PERIOD_NAME, NULL BUDGET_CODE_COMBINATION_ID, NULL CLOSE_PRIOR_FLAG, NULL ACCOUNT_PRIOR_FLAG, NULL BUDGET_TRAN_TYPE, NULL XCC_GEN_PARENT_FLAG, NULL BOM_LABOR_RESOURCE_ID, NULL BOM_EQUIPMENT_RESOURCE_ID, NULL PERSON_ID, NULL EVENT_ID, bc.EXPENDITURE_TYPE_ID EXPENDITURE_TYPE_ID, NULL ITEM_CATEGORY_ID, NULL INVENTORY_ITEM_ID, NULL JOB_ID, NULL PERSON_TYPE_ID, NULL NON_LABOR_RESOURCE_ID, NULL PROJECT_ROLE_ID, NULL VENDOR_ID, NULL ORGANIZATION_ID, NULL EXPENDITURE_ITEM_DATE, bc.ENTERED_DR ENTERED_DR, bc.ENTERED_CR ENTERED_CR, bc.ACCOUNTED_DR ACCOUNTED_DR, bc.ACCOUNTED_CR ACCOUNTED_CR, NULL DOCUMENT_TYPE, NULL TRANSACTION_DISTRIBUTION_TYPE, bc.BC_PACKET_ID BC_PACKET_ID, bc.PARENT_BC_PACKET_ID PARENT_BC_PACKET_ID FROM PJC_BC_PACKETS_T bc WHERE bc.packet_id = -1 AND bc.parent_bc_packet_id is null AND bc.status_code ='P'