GPIT_GV93_P_AGG

(SQL Table)
Index Back

GV93 Additional Payments

Record for GV93 report

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPIT_GV93_BOX_ID Character(6) VARCHAR2(6) NOT NULL Field for GV93 report

Prompt Table: GPIT_GV93_BOX

2 INPDAI_CODE_ITA Character(16) VARCHAR2(16) NOT NULL INPDAI Code ITA

Prompt Table: INPDAI_TBL_ITA

3 GPIT_PER_BGN_DT1 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