Data Warehouse

PO_ACKNOW_REQD

Po acknow reqd associated with the record.

VARCHAR2

1

PO_ADDED_AGENCY

Po added agency associated with the record.

VARCHAR2

1

PO_ADDED_BY

Po added by associated with the record.

VARCHAR2

12

PO_ADDED_DATE

Date associated with po added.

VARCHAR2

23

PO_ADDED_TERM

Po added term associated with the record.

VARCHAR2

7

PO_AMT

Po amt associated with the record.

NUMBER

11,2

PO_ATTENTION

Po attention associated with the record.

VARCHAR2

25

PO_AUTHORIZATION

Po authorization associated with the record.

VARCHAR2

10

PO_BEGIN_DATE

Date associated with po begin.

DATE

PO_BUYER_CODE

Code identifying po buyer.

VARCHAR2

3

PO_CONFIRM_DATE

Date associated with po confirm.

DATE

PO_CONFIRM_NAME

Po confirm name associated with the record.

VARCHAR2

25

PO_CO_NUM

Po co num associated with the record.

NUMBER

3

PO_CO_STATUS

Po co status associated with the record.

VARCHAR2

1

PO_CO_STATUS_AGENCY

Po co status agency associated with the record.

VARCHAR2

1

PO_CO_STATUS_BY

Po co status by associated with the record.

VARCHAR2

12

PO_CO_STATUS_DATE

Date associated with po co status.

VARCHAR2

23

PO_CO_STATUS_TERM

Po co status term associated with the record.

VARCHAR2

7

PO_CO_TNUM

Po co tnum associated with the record.

NUMBER

3

PO_CO_TNUM_A

Po co tnum a associated with the record.

VARCHAR2

8

PO_CO_TNUM_C

Po co tnum c associated with the record.

VARCHAR2

8

PO_CO_TNUM_R

Po co tnum r associated with the record.

VARCHAR2

8

PO_CO_TYPE

Po co type associated with the record.

VARCHAR2

2

PO_CUM_AMT

Po cum amt associated with the record.

NUMBER

11,2

PO_DAPO_FLAG

Indicator identifying whether po dapo (Y/N).

VARCHAR2

1

PO_DATE

Date associated with po.

DATE

PO_DATE1

Po date1 associated with the record.

DATE

PO_DEPTNUM2

Po deptnum2 associated with the record.

VARCHAR2

2

PO_DEPTNUM4

Po deptnum4 associated with the record.

VARCHAR2

4

PO_END_DATE

Date associated with po end.

DATE

PO_EQUIPMENT

Po equipment associated with the record.

VARCHAR2

1

PO_FOBCODE

Po fobcode associated with the record.

VARCHAR2

26

PO_HANDLING

Po handling associated with the record.

VARCHAR2

25

PO_HIDE

Po hide associated with the record.

VARCHAR2

1

PO_ISSUE_CNT

Po issue cnt associated with the record.

VARCHAR2

2

PO_LOG

Po log associated with the record.

VARCHAR2

1

PO_MESSAGE_CODE

Code identifying po message.

VARCHAR2

3

PO_NUM

Po num associated with the record.

NUMBER

7

PO_OFFICE_CODE

Code identifying po office.

VARCHAR2

4

PO_OK_FREIGHT

Po ok freight associated with the record.

VARCHAR2

1

PO_OLS_MARKUP

Po ols markup associated with the record.

NUMBER

5,2

PO_PA

Po pa associated with the record.

VARCHAR2

2

PO_PAID_AMT

Po paid amt associated with the record.

NUMBER

11,2

PO_POD_CNT

Po pod cnt associated with the record.

NUMBER

12

PO_POLI_CNT

Po poli cnt associated with the record.

NUMBER

8

PO_POLI_PREV_CNT

Po poli prev cnt associated with the record.

NUMBER

8

PO_PREFIX_STYLE

Po prefix style associated with the record.

VARCHAR2

1

PO_PRICING_CODE

Code identifying po pricing.

VARCHAR2

1

PO_PRINT_OPTIONS

Po print options associated with the record.

VARCHAR2

5

PO_PROVIDER

Po provider associated with the record.

VARCHAR2

4

PO_PURCH_CENTER

Po purch center associated with the record.

VARCHAR2

4

PO_QUOTE_BY

Po quote by associated with the record.

VARCHAR2

20

PO_QUOTE_DATE

Date associated with po quote.

DATE

PO_QUOTE_TO

Po quote to associated with the record.

VARCHAR2

20

PO_REF_NUM

Po ref num associated with the record.

VARCHAR2

12

PO_REL_AMT

Po rel amt associated with the record.

NUMBER

11,2

PO_REQD_DATE

Date associated with po reqd.

VARCHAR2

10

PO_REQ_NUM

Po req num associated with the record.

VARCHAR2

7

PO_REQ_SUBID

Po req subid associated with the record.

NUMBER

2

PO_REQ_TYPE

Po req type associated with the record.

VARCHAR2

1

PO_RETENTION

Po retention associated with the record.

VARCHAR2

1

PO_SEND_INV_TO_COME

Po send inv to come associated with the record.

VARCHAR2

4

PO_SEND_PO_NAME

Po send po name associated with the record.

VARCHAR2

25

PO_SEND_PO_ROOM

Po send po room associated with the record.

VARCHAR2

10

PO_SEND_TO_VEN

Po send to ven associated with the record.

VARCHAR2

1

PO_SHIP_FOR_NAME

Po ship for name associated with the record.

VARCHAR2

25

PO_SHIP_FOR_PHONE

Po ship for phone associated with the record.

VARCHAR2

7

PO_SHIP_FOR_ROOM

Po ship for room associated with the record.

VARCHAR2

10

PO_SHIP_TO_CODE

Code identifying po ship to.

VARCHAR2

4

PO_SHIP_VIA

Po ship via associated with the record.

VARCHAR2

20

PO_SPONSOR_CONSENT_DATE

Date associated with po sponsor consent.

VARCHAR2

12

PO_STATUS

Po status associated with the record.

VARCHAR2

1

PO_STATUS_AGENCY

Po status agency associated with the record.

VARCHAR2

1

PO_STATUS_BY

Po status by associated with the record.

VARCHAR2

12

PO_STATUS_DATE

Date associated with po status.

VARCHAR2

23

PO_STATUS_TERM

Po status term associated with the record.

VARCHAR2

7

PO_SUPER_BY_NUM

Po super by num associated with the record.

NUMBER

7

PO_SUPER_BY_PA

Po super by pa associated with the record.

VARCHAR2

2

PO_SUPER_NUM

Po super num associated with the record.

NUMBER

7

PO_SUPER_PA

Po super pa associated with the record.

VARCHAR2

2

PO_SUPER_PA_TYPE

Po super pa type associated with the record.

VARCHAR2

1

PO_SUPER_TYPE

Po super type associated with the record.

VARCHAR2

1

PO_TERMS_DISC_DAYS

Po terms disc days associated with the record.

NUMBER

12

PO_TERMS_DISC_PC

Po terms disc pc associated with the record.

NUMBER

9

PO_TERMS_NET_DAYS

Po terms net days associated with the record.

NUMBER

12

PO_TYPE

Po type associated with the record.

VARCHAR2

1

PO_VENPAY_NUM

Po venpay num associated with the record.

NUMBER

6

PO_VEN_NUM

Po ven num associated with the record.

NUMBER

6

PO_VERSION

Po version associated with the record.

VARCHAR2

2

PO_WO_NUM

Po wo num associated with the record.

VARCHAR2

7