SETIDPROJECT_IDLEDGERB=Amt in Project Hdr & Ledger KK
L=Amount in Ledger KK only
P=Amount in Project Header only
UPG_PROJDIFF_EG(SQL Table) |
Index Back |
|---|---|
Store Diff btwn PROJH & LEDKKStore mismatch amounts and rows between UPG_PROJH_EG & UPG_LEDKK_EG by after-upgrade AE UPG_PH_RECON. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 3 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 4 | FROM_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | From Amount |
| 5 | TO_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | To Amount |
| 6 | UPG_RECON_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Upgrade Reconciliation Flag
B=Amt in Project Hdr & Ledger KK L=Amount in Ledger KK only P=Amount in Project Header only |