CONTRACT_NUM?=Validation in Progress
V=Valid ChartField Combination
X=Invalid ChartField Combo
CA_H_ACCT_ERR(SQL View) |
Index Back |
|---|---|
Overall accounting errors |
| SELECT DISTINCT CONTRACT_NUM , 'X' FROM PS_CA_L_ACCT_ERR UNION SELECT DISTINCT CONTRACT_NUM , 'X' FROM PS_CA_RED_ACCT_ERR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | COMBO_VALID_FLG | Character(1) | VARCHAR2(1) NOT NULL |
ChartField Combinatn Valid Flg
?=Validation in Progress V=Valid ChartField Combination X=Invalid ChartField Combo |