|
| REQ_HDR |
Requisition ID, BCM status, requester ID |
| REQ_LINE |
Requisition line number, Item ID, Vendor ID |
| REQ_LINE_SHIP |
Shipping Date |
| REQ_LN_DISTRIB |
ChartField distributions, quantity, open quantity |
| REQ_LINE_ACCTG |
Same as REQ_LN_DISTRIB. The table is not poplulated until posting. |
| PO_HDR |
BU, PO ID, PO Description |
| PO_LINE |
PO Line number, Item ID, Quantity |
| PO_LINE_SHIP |
Shipping location |
| PO_LINE_DISTRIB |
ChartField distributions, value adjustment description |
| PO_LINE_ACCTG |
Same as PO_LINE_DISTRIB. The table is not populatd until posting. |
| PO_DISTRIB_STG |
Filled with Req. Distributions for selected Req's, for builidng PO's copied to PO_LINE_DISTRIB |
| PO_ITM_STG |
Filled with Req. line and ship data for building PO's, many work fields on this table. |
| VOUCHER |
Hight-level voucher data such as voucher ID, payment terms, invoice number and vendor number. |
| VOUCHER_LINE |
Item description, line quantities, PO-related fields |
| DISTRIB_LINE |
ChartField distributions, distribution lines quantities, budget checking info and status. |
| VCHR_ACCTG_LINE |
Same as DISTRIB_LINE. Not populated until posting. |
| PAYMENT |
Payment ID, accounting date, discounts |
| PYMNT_VCHR_XREF |
Voucher and payment info, including paycycle used and bank paid from |
| JRNL_HEADER |
BCM status, post status, process flag, journal date, journal ID, accounting period and fiscal year |
| JRNL_LN |
ChartFields, edit and BCM status for each line, journal date, journal ID, journal line number, line reference |
| LEDGER |
Data from posting journals (incl jrnl gen), chartfields, accounting period and fiscal year, pre_encumb, encumb, posted total amounts(highest table) |
| LEDGER_BUDG |
Data from the BMC process, chartfields, pre-encumb, encumb, expended, same as LEDGER for most fields except updated at different time |
| GL_ACCOUNT_TBL |
Accounts and their descriptions, by SETID |
| DEPARTMENT_TBL |
Department values and their destinations, by SETID |
|
