Data Warehouse

PO_ACKNOW_REQD

Indicator identifying whether vendor acknowledgment is required (Y/N).

VARCHAR2

1

PO_ADDED_AGENCY

Agency associated with record creation.

VARCHAR2

1

PO_ADDED_BY

User who created the purchase order record.

VARCHAR2

12

PO_ADDED_DATE

Date the purchase order record was created.

VARCHAR2

23

PO_ADDED_TERM

Term associated with record creation.

VARCHAR2

7

PO_AMT

Total amount of the purchase order.

NUMBER

11,2

PO_ATTENTION

Attention or contact name for the purchase order.

VARCHAR2

25

PO_AUTHORIZATION

Authorization code or identifier for the purchase order.

VARCHAR2

10

PO_BEGIN_DATE

Begin date for the purchase order validity period.

DATE

PO_BUYER_CODE

Code identifying the buyer responsible for the purchase order.

VARCHAR2

3

PO_CONFIRM_DATE

Date the purchase order was confirmed.

DATE

PO_CONFIRM_NAME

Name of the person confirming the purchase order.

VARCHAR2

25

PO_CO_NUM

Company code associated with the purchase order.

NUMBER

3

PO_CO_STATUS

Company-level status of the purchase order.

VARCHAR2

1

PO_CO_STATUS_AGENCY

Agency associated with the company-level status.

VARCHAR2

1

PO_CO_STATUS_BY

User who set the company-level status.

VARCHAR2

12

PO_CO_STATUS_DATE

Date the company-level status was set.

VARCHAR2

23

PO_CO_STATUS_TERM

Term or period associated with the company-level status.

VARCHAR2

7

PO_CO_TNUM

Company transaction number associated with the purchase order.

NUMBER

3

PO_CO_TNUM_A

Alternate company transaction number associated with the purchase order.

VARCHAR2

8

PO_CO_TNUM_C

Company transaction number (character format) associated with the purchase order.

VARCHAR2

8

PO_CO_TNUM_R

Related company transaction number associated with the purchase order.

VARCHAR2

8

PO_CO_TYPE

Company type associated with the purchase order.

VARCHAR2

2

PO_CUM_AMT

Cumulative amount recorded against the purchase order.

NUMBER

11,2

PO_DAPO_FLAG

Indicator identifying whether the purchase order is a DAPO transaction (Y/N).

VARCHAR2

1

PO_DATE

Date the purchase order was created.

DATE

PO_DATE1

Secondary or alternate purchase order date.

DATE

PO_DEPTNUM2

Two-digit department grouping code associated with the purchase order.

VARCHAR2

2

PO_DEPTNUM4

Four-digit department number associated with the purchase order.

VARCHAR2

4

PO_END_DATE

End date for the purchase order validity period.

DATE

PO_EQUIPMENT

Indicator identifying whether the purchase order is for equipment (Y/N).

VARCHAR2

1

PO_FOBCODE

Freight-on-board (FOB) terms associated with the purchase order.

VARCHAR2

26

PO_HANDLING

Handling instructions or notes associated with the purchase order.

VARCHAR2

25

PO_HIDE

Indicator identifying whether the purchase order is hidden from standard outputs (Y/N).

VARCHAR2

1

PO_ISSUE_CNT

Count of issues or revisions associated with the purchase order.

VARCHAR2

2

PO_LOG

Indicator identifying whether the purchase order has log activity (Y/N).

VARCHAR2

1

PO_MESSAGE_CODE

Code identifying special messaging or handling instructions for the purchase order.

VARCHAR2

3

PO_NUM

Unique legacy VAPS purchase order identifier.

NUMBER

7

PO_OFFICE_CODE

Office or organizational unit responsible for the purchase order.

VARCHAR2

4

PO_OK_FREIGHT

Indicator identifying whether freight charges are approved (Y/N).

VARCHAR2

1

PO_OLS_MARKUP

Markup percentage or amount applied under OLS rules.

NUMBER

5,2

PO_PA

Purchasing authority code associated with the purchase order.

VARCHAR2

2

PO_PAID_AMT

Total amount paid against the purchase order.

NUMBER

11,2

PO_POD_CNT

Count of distribution records associated with the purchase order.

NUMBER

12

PO_POLI_CNT

Count of line items associated with the purchase order.

NUMBER

8

PO_POLI_PREV_CNT

Previous count of line items associated with the purchase order.

NUMBER

8

PO_PREFIX_STYLE

Prefix style used for purchase order numbering.

VARCHAR2

1

PO_PRICING_CODE

Code identifying pricing conditions or structure for the purchase order.

VARCHAR2

1

PO_PRINT_OPTIONS

Print or output options associated with the purchase order.

VARCHAR2

5

PO_PROVIDER

Provider or source system associated with the purchase order.

VARCHAR2

4

PO_PURCH_CENTER

Purchasing center responsible for the purchase order.

VARCHAR2

4

PO_QUOTE_BY

Person or vendor providing the quote.

VARCHAR2

20

PO_QUOTE_DATE

Date of the vendor quote associated with the purchase order.

DATE

PO_QUOTE_TO

Recipient of the vendor quote.

VARCHAR2

20

PO_REF_NUM

External reference number associated with the purchase order.

VARCHAR2

12

PO_REL_AMT

Released or obligated amount associated with the purchase order.

NUMBER

11,2

PO_REQD_DATE

Requested delivery or fulfillment date for the purchase order.

VARCHAR2

10

PO_REQ_NUM

Requisition number associated with the purchase order.

VARCHAR2

7

PO_REQ_SUBID

Sub-identifier associated with the requisition.

NUMBER

2

PO_REQ_TYPE

Code identifying the type of requisition.

VARCHAR2

1

PO_RETENTION

Indicator identifying whether retention applies to the purchase order (Y/N).

VARCHAR2

1

PO_SEND_INV_TO_COME

Code identifying where invoices should be sent.

VARCHAR2

4

PO_SEND_PO_NAME

Name of the recipient for the purchase order document.

VARCHAR2

25

PO_SEND_PO_ROOM

Room number for purchase order delivery.

VARCHAR2

10

PO_SEND_TO_VEN

Indicator identifying whether the purchase order is sent to the vendor (Y/N).

VARCHAR2

1

PO_SHIP_FOR_NAME

Name of the individual receiving shipped goods.

VARCHAR2

25

PO_SHIP_FOR_PHONE

Phone number for the delivery contact.

VARCHAR2

7

PO_SHIP_FOR_ROOM

Room number for delivery of shipped goods.

VARCHAR2

10

PO_SHIP_TO_CODE

Code identifying the shipping destination.

VARCHAR2

4

PO_SHIP_VIA

Shipping method or carrier.

VARCHAR2

20

PO_SPONSOR_CONSENT_DATE

Date sponsor consent was obtained for the purchase order.

VARCHAR2

12

PO_STATUS

Overall status of the purchase order.

VARCHAR2

1

PO_STATUS_AGENCY

Agency associated with the purchase order status.

VARCHAR2

1

PO_STATUS_BY

User who set the purchase order status.

VARCHAR2

12

PO_STATUS_DATE

Date the purchase order status was set.

VARCHAR2

23

PO_STATUS_TERM

Term associated with the purchase order status.

VARCHAR2

7

PO_SUPER_BY_NUM

Supervisor identifier responsible for the purchase order (numeric).

NUMBER

7

PO_SUPER_BY_PA

Supervisor purchasing authority code.

VARCHAR2

2

PO_SUPER_NUM

Supervisor identifier associated with the purchase order.

NUMBER

7

PO_SUPER_PA

Supervisor purchasing authority code associated with the purchase order.

VARCHAR2

2

PO_SUPER_PA_TYPE

Supervisor purchasing authority type.

VARCHAR2

1

PO_SUPER_TYPE

Supervisor type associated with the purchase order.

VARCHAR2

1

PO_TERMS_DISC_DAYS

Number of days for discount eligibility.

NUMBER

12

PO_TERMS_DISC_PC

Discount percentage available under payment terms.

NUMBER

9

PO_TERMS_NET_DAYS

Number of days until payment is due.

NUMBER

12

PO_TYPE

Code identifying the type of purchase order.

VARCHAR2

1

PO_VENPAY_NUM

Vendor pay-to identifier associated with the purchase order.

NUMBER

6

PO_VEN_NUM

Vendor identifier associated with the purchase order.

NUMBER

6

PO_VERSION

Version number of the purchase order record.

VARCHAR2

2

PO_WO_NUM

Work order number associated with the purchase order.

VARCHAR2

7