Wednesday, November 23, 2011

PO_REQ_DISTRIBUTIONS_ALL

Purchasing
Table Or View: Table

Important columns: 
DISTRIBUTION_ID : Requisition distribution unique identifier
LAST_UPDATE_DATE : Standard Who column
LAST_UPDATED_BY : Standard Who column
REQUISITION_LINE_ID : Requisition line unique identifier
SET_OF_BOOKS_ID : Set of Books unique identifier
CODE_COMBINATION_ID : Unique identifier for the General Ledger charge account
DISTRIBUTION_NUM : Distribution number
ALLOCATION_TYPE : Method of allocation across distributions. Can be PERCENT

Description: 
PO_REQ_DISTRIBUTIONS_ALL stores information about the accounting distributions associated with each requisition line. Each requisition line must have at least one accounting distribution. You need one row for each requisition distribution you create. Each row includes the Accounting Flexfield ID and requisition line quantity.
 
PO_REQ_DISTRIBUTIONS_ALL is one of three tables storing your requisition information. This table corresponds to the requisition Distributions window, accessible through the Requisitions window.

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect