GPIT_GV93_P_AGG(SQL Table) |
Index Back |
---|---|
GV93 Additional PaymentsRecord for GV93 report |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(6) | VARCHAR2(6) NOT NULL |
Field for GV93 report
Prompt Table: GPIT_GV93_BOX |
|
2 | Character(16) | VARCHAR2(16) NOT NULL |
INPDAI Code ITA
Prompt Table: INPDAI_TBL_ITA |
|
3 | Date(10) | DATE NOT NULL | Field to be used as Period Begin Date. Different labels can be inserted for different purposes. | |
4 | GPIT_PER_END_DT1 | Date(10) | DATE NOT NULL | Field to be used as Period Begin Date. Different labels can be inserted for different purposes. |
5 | GPIT_PER_BGN_DT2 | Date(10) | DATE | Field to be used as Period Begin Date. Different labels can be inserted for different purposes. |
6 | GPIT_PER_END_DT2 | Date(10) | DATE | Field to be used as Period Begin Date. Different labels can be inserted for different purposes. |
7 | GPIT_GV93_IDECOD | Character(4) | VARCHAR2(4) NOT NULL |
GV93 Identification Code
Field for GV93 report
Prompt Table: GPIT_GV93_IDE |
8 | GPIT_AMOUNT_12_6 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount |
9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: EUR Prompt Table: CURRENCY_CD_TBL |