VAPS POLI Table
View exposing legacy VAPS purchase order line-item detail including purchase order, company, line type, and item-level purchasing attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
POLI_ADDED_AGENCY |
Poli added agency associated with the record. |
VARCHAR2 |
1 |
POLI_ADDED_BY |
Poli added by associated with the record. |
VARCHAR2 |
13 |
POLI_ADDED_DATE |
Date associated with poli added. |
VARCHAR2 |
12 |
POLI_AMT |
Poli amt associated with the record. |
NUMBER |
11,2 |
POLI_CAS |
Poli cas associated with the record. |
NUMBER |
8 |
POLI_CO_NUM |
Poli co num associated with the record. |
NUMBER |
3 |
POLI_CUM_AMT |
Poli cum amt associated with the record. |
NUMBER |
11,2 |
POLI_CUM_QTY |
Poli cum qty associated with the record. |
NUMBER |
11,3 |
POLI_DESCRIPTION |
Description of poli. |
VARCHAR2 |
1000 |
POLI_DISC_D |
Poli disc d associated with the record. |
NUMBER |
11,2 |
POLI_DISC_P |
Poli disc p associated with the record. |
NUMBER |
11,3 |
POLI_DISC_TYPE |
Poli disc type associated with the record. |
VARCHAR2 |
1 |
POLI_EQUIPMENT |
Poli equipment associated with the record. |
VARCHAR2 |
1 |
POLI_EST_DATE |
Date associated with poli est. |
DATE |
|
POLI_FORMAT |
Poli format associated with the record. |
VARCHAR2 |
1 |
POLI_INV_GROUP |
Poli inv group associated with the record. |
VARCHAR2 |
4 |
POLI_LI_NUM |
Poli li num associated with the record. |
NUMBER |
3 |
POLI_LOG |
Poli log associated with the record. |
VARCHAR2 |
1 |
POLI_PO_NUM |
Poli po num associated with the record. |
NUMBER |
7 |
POLI_PRICE |
Poli price associated with the record. |
NUMBER |
13,5 |
POLI_QTY |
Poli qty associated with the record. |
NUMBER |
11,3 |
POLI_REQD_DATE |
Date associated with poli reqd. |
VARCHAR2 |
10 |
POLI_REQ_ID |
Business identifier for the poli req. |
VARCHAR2 |
12 |
POLI_SUBTYPE |
Poli subtype associated with the record. |
VARCHAR2 |
1 |
POLI_TYPE |
Poli type associated with the record. |
VARCHAR2 |
1 |
POLI_UNITS |
Poli units associated with the record. |
VARCHAR2 |
12 |
POLI_VEN_PART_NUM |
Poli ven part num associated with the record. |
VARCHAR2 |
13 |
POLI_WO_NUM |
Poli wo num associated with the record. |
NUMBER |
7 |