PO_REQUISITION_HEADERS_ALL (SEGMENT1 column in this table represents the requisition number):

This table stores HEADER information of a Purchase Requisition.

Important columns of this table:

REQUISITION_HEADER_ID:It is a unique system generated Requisition identifier

PREPARER_ID:It is a unique identifier of the employee who prepared the requisition

SEGMENT1:It is the Requisition number

AUTHORIZATION_STATUS:Authorization status type

TYPE_LOOKUP_CODE:Requisition type

ORG_ID:Unique OPERATING unit unique identifier

PO_REQUISITION_LINES_ALL:

This table stores information about Requisition lines in a Purchase Requisition. This table stores information related to the line number, item number, item category, item description, item quantities, units, prices, need-by date, deliver-to location, REQUESTOR, notes, and suggested supplier information for the requisition line.

Important columns of this table:

REQUISITION_HEADER_ID:It is a unique system generated Requisition identifier

REQUISITION_LINE_ID:Link between PO_REQUISITION_LINES_ALL And PO_REQ_DISTRIBUTIONS_ALL

LINE_NUM:INDICATES the Line number

LINE_TYPE_ID:Indicates the Line type

CATEGORY_ID:Unique Item category identifier

ITEM_DESCRIPTION:Description of the Item

QUANTITY NUMBER:Quantity ordered

PO_REQ_DISTRIBUTIONS_ALL:

This table stores information about the accounting distributions of a requisition line. Each requisition line must have at least one accounting distribution. Each row includes the Accounting Flexfield ID and Requisition line quantity.

Important columns of this table:

DISTRIBUTION_ID:Unique Requisition distribution identifier

REQUISITION_LINE_ID:Unique Requisition line identifier

CODE_COMBINATION_ID:Unique General Ledger charge account identifier

 DISTRIBUTION_NUM:Distribution number

PO_REQUISITION_HEADERS_ALL (SEGMENT1 column in this table represents the requisition number):

This table stores Header information of a Purchase Requisition.

Important columns of this table:

REQUISITION_HEADER_ID:It is a unique system generated Requisition identifier

PREPARER_ID:It is a unique identifier of the employee who prepared the requisition

SEGMENT1:It is the Requisition number

AUTHORIZATION_STATUS:Authorization status type

TYPE_LOOKUP_CODE:Requisition type

ORG_ID:Unique Operating unit unique identifier

PO_REQUISITION_LINES_ALL:

This table stores information about Requisition lines in a Purchase Requisition. This table stores information related to the line number, item number, item category, item description, item quantities, units, prices, need-by date, deliver-to location, requestor, notes, and suggested supplier information for the requisition line.

Important columns of this table:

REQUISITION_HEADER_ID:It is a unique system generated Requisition identifier

REQUISITION_LINE_ID:Link between PO_REQUISITION_LINES_ALL And PO_REQ_DISTRIBUTIONS_ALL

LINE_NUM:Indicates the Line number

LINE_TYPE_ID:Indicates the Line type

CATEGORY_ID:Unique Item category identifier

ITEM_DESCRIPTION:Description of the Item

QUANTITY NUMBER:Quantity ordered

PO_REQ_DISTRIBUTIONS_ALL:

This table stores information about the accounting distributions of a requisition line. Each requisition line must have at least one accounting distribution. Each row includes the Accounting Flexfield ID and Requisition line quantity.

Important columns of this table:

DISTRIBUTION_ID:Unique Requisition distribution identifier

REQUISITION_LINE_ID:Unique Requisition line identifier

CODE_COMBINATION_ID:Unique General Ledger charge account identifier

 DISTRIBUTION_NUM:Distribution number