PROCESS_INSTANCEVAT_ENTITYCOUNTRY_VAT_RPTGVAT_DCMNT_IDLINE_NBRUNPOST_SEQVAT_RETURN_VW(SQL View) |
Index Back |
|---|
| SELECT INST2.PROCESS_INSTANCE , INST2.VAT_ENTITY , INST2.COUNTRY_VAT_RPTG , INST2.VAT_DCMNT_ID , INST2.LINE_NBR , INST2.UNPOST_SEQ , INST2.TAX_BASIS_AMT_RPTG , INST2.TAX_TRANS_AMT_RPTG , INST2.TAX_AMT_GROSS_RPTG , INST2.TAX_AMT_RBT_RPTG , INST2.TAX_AMT_RCVRY_RPTG FROM PS_VAT_RPT_INST2 INST2 , PS_VAT_RPT_INST1 INST1 WHERE INST1.PROCESS_INSTANCE = INST2.PROCESS_INSTANCE AND INST1.VAT_RPT_ID = INST2.VAT_RPT_ID AND INST1.VAT_RPT_TYPE = 'R' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | VAT_ENTITY |
Character(20) | VARCHAR2(20) NOT NULL | Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements. |
| 3 | COUNTRY_VAT_RPTG |
Character(3) | VARCHAR2(3) NOT NULL | VAT Reporting Country |
| 4 | VAT_DCMNT_ID |
Number(8,0) | INTEGER NOT NULL | VAT Document ID |
| 5 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 6 | UNPOST_SEQ |
Number(2,0) | SMALLINT NOT NULL | Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1". |
| 7 | TAX_BASIS_AMT_RPTG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Basis Amount - Reporting |
| 8 | TAX_TRANS_AMT_RPTG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Transaction Amt - Report |
| 9 | TAX_AMT_GROSS_RPTG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Tax Amount - Reporting |
| 10 | TAX_AMT_RBT_RPTG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Rebate Amount - Reporting |
| 11 | TAX_AMT_RCVRY_RPTG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Recovery Amt - Reporting |