BEN_BI_DETAIL(SQL Table) |
Index Back |
|---|---|
Billing Accounting DetailBEN_BI_DETAIL is the repository of accounting information from charges, payments and adjustments. It is the primary table for the accounting transactions. The BILL_CHARGE_ID, BILL_PAY_ID and BILL_ADJ_ID fields provide the links back to the charges, payments and adjustments on BEN_BI_CHARGE, BEN_BI_PAYMENT and BEN_BI_ADJSTMNT. Using a separate table for the accounting information allows the system to attach the numbers to whatever entries are affected. For example, a payment against a charge will have an entry in both the BILL_CHARGE_ID and BILL_PAY_ID fields, tying the amount paid to both the charge and the payment. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | BILL_CHARGE_ID |
Number(7,0) | INTEGER NOT NULL |
Billing Charge ID
Prompt Table: BEN_BI_CHG_VW |
| 3 | BILL_PAY_ID |
Number(7,0) | INTEGER NOT NULL |
Payment ID
Prompt Table: BEN_BI_PAYMENT |
| 4 | BILL_ADJ_ID |
Signed Number(8,0) | DECIMAL(7) NOT NULL |
Billing Adjustment ID
Prompt Table: BEN_BI_ADJSTMNT |
| 5 | POSTED_DATE | Date(10) | DATE | Date Posted |
| 6 | DETAIL_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Action Type
CADJ=Adjust Charge CHRG=Charge EXCS=Excess Cash PADJ=Adjust Payment PMNT=Payment Prompt Table: PSXLATITEM |
| 7 | CHARGE_AMT | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Charge Amount |
| 8 | CHRG_ADJUST | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Charge Adjustments |
| 9 | PAY_AMT | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | An indicator used in Benefits Billing to identify amounts that have been, or are to be, paid (as opposed to a charge). |
| 10 | PMT_ADJUST | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Payment Adjustments |
| 11 | EXCESS_CASH | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Excess Cash |
| 12 | GL_POST_DT | Date(10) | DATE | General Ledger Posting Date |