PROCUREMENT CARD INBOX DETAIL Table
View exposing procurement card inbox detail records including transaction review, approval, and processing attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT |
Amount associated with the record. |
NUMBER |
13,2 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
DEBIT_CREDIT_INDICATOR |
Indicator identifying whether debit credit (Y/N). |
VARCHAR2 |
1 |
DOCUMENT_DATE |
Date associated with document. |
DATE |
|
DOCUMENT_ENTRY_DATE |
Date associated with document entry. |
DATE |
|
DOCUMENT_LINE_ITEM |
Document line item associated with the record. |
VARCHAR2 |
3 |
DOCUMENT_NUMBER |
Document number associated with the record. |
VARCHAR2 |
10 |
DOCUMENT_POSTING_DATES |
Document posting dates associated with the record. |
DATE |
|
DOCUMENT_TEXT |
Document text associated with the record. |
VARCHAR2 |
50 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
13 |
LINE_ITEM_TEXT |
Line item text associated with the record. |
VARCHAR2 |
75 |
POSTING_KEY |
Surrogate key identifying the posting. |
VARCHAR2 |
2 |
PROFIT_CENTER_KEY |
Surrogate key identifying the profit center. |
VARCHAR2 |
12 |
REFERENCE_DOCUMENT_NUMBER |
Reference document number associated with the record. |
VARCHAR2 |
16 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |