FND Design Data [Home] [Help]

Table: PA_BC_COMMITMENTS_ALL

Product: PA - Projects
Description: PA_BC_COMMITMENTS holds all the commitment transactions (Req, PO and Payables) that are funds checked. When maintain project balances programs sweeps the commitment records to project balances, the commitments are inserted into this table.
Implementation/DBA Data: TablePA.PA_BC_COMMITMENTS_ALL
Primary Key: PA_BC_COMMITMENTS_PK
  1. ColumnBC_COMMITMENT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PA_BC_COMMITMENTS_ALL FK Joins to TablePO_DISTRIBUTIONS_ALL PA_BC_COMMITMENTS_ALL.DOCUMENT_DISTRIBUTION_ID
PA_BC_COMMITMENTS_ALL FK Joins to TablePA_EXPENDITURE_TYPES PA_BC_COMMITMENTS_ALL.EXPENDITURE_TYPE
PA_BC_COMMITMENTS_ALL FK Joins to TablePA_RESOURCE_LIST_MEMBERS PA_BC_COMMITMENTS_ALL.RESOURCE_LIST_MEMBER_ID
PA_BC_COMMITMENTS_ALL FK Joins to TableGL_SETS_OF_BOOKS_11I PA_BC_COMMITMENTS_ALL.SET_OF_BOOKS_ID
PA_BC_COMMITMENTS_ALL FK Joins to TablePA_TASKS PA_BC_COMMITMENTS_ALL.TOP_TASK_ID
PA_BC_COMMITMENTS_ALL FK Joins to TablePA_PROJECTS_ALL PA_BC_COMMITMENTS_ALL.PROJECT_ID
PA_BC_COMMITMENTS_ALL FK Joins to TablePA_TASKS PA_BC_COMMITMENTS_ALL.TASK_ID
PA_BC_COMMITMENTS_ALL FK Joins to TablePA_BUDGET_VERSIONS PA_BC_COMMITMENTS_ALL.BUDGET_VERSION_ID
PA_BC_COMMITMENTS_ALL FK Joins to TablePO_HEADERS_ALL PA_BC_COMMITMENTS_ALL.DOCUMENT_HEADER_ID
PA_BC_COMMITMENTS_ALL FK Joins to TablePO_DISTRIBUTIONS_ALL PA_BC_COMMITMENTS_ALL.DOCUMENT_DISTRIBUTION_ID
PA_BC_COMMITMENTS_ALL FK Joins to TableAP_INVOICES_ALL PA_BC_COMMITMENTS_ALL.DOCUMENT_HEADER_ID
PA_BC_COMMITMENTS_ALL FK Joins to TableAP_INVOICE_DISTRIBUTIONS_ALL PA_BC_COMMITMENTS_ALL.AIL_INVOICE_ID
PA_BC_COMMITMENTS_ALL.AIL_DISTRIBUTION_LINE_NUMBER
PA_BC_COMMITMENTS_ALL FK Joins to TablePA_COST_DISTRIBUTION_LINES_ALL PA_BC_COMMITMENTS_ALL.PCL_LINE_NUM
PA_BC_COMMITMENTS_ALL.PCL_EXPENDITURE_ITEM_ID
PA_BC_COMMITMENTS_ALL FK Joins to TablePO_DISTRIBUTIONS_ALL PA_BC_COMMITMENTS_ALL.PDL_PO_DISTRIBUTION_ID
PA_BC_COMMITMENTS_ALL FK Joins to TablePO_REQ_DISTRIBUTIONS_ALL PA_BC_COMMITMENTS_ALL.PRL_DISTRIBUTION_ID