PY_PDF_TXFRM_CN(SQL Table) |
Index Back |
|---|---|
Define PDF Tax FormThe record stores information of PDF Tax Form used for updatable TD1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL | Unique identifier for the PDF form used for updatable TD1 PDF. | |
| 2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: PY_PDF_CTY_CNVW |
| 5 | ACTIVE_INACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Definition Active or Inactive?
A=Active I=Inactive Default Value: A |
| 6 | REPORT_DEFN_ID | Character(12) | VARCHAR2(12) NOT NULL |
Report Name (see PSXPRPTDEFN).
Prompt Table: PSXPRPTDEFN |
| 7 | PY_MASK_TIN_CN | Character(1) | VARCHAR2(1) NOT NULL |
Indicator to determine if MASK TIN is required
Y/N Table Edit |
| 8 | PY_DSP_CNF_FORM_CN | Character(1) | VARCHAR2(1) NOT NULL |
Display Confirmation Form
Y/N Table Edit |