PeopleSoft 9 Asset Management |
Table Name | VAT_ENT_RGSTRN |
Table Description |
VAT_ENT_RGSTRN |
Columns |
Name | Datatype | Is PK | Is FK |
VAT_ENTITY | char(20) | Yes | No |
COUNTRY | char(3) | Yes | No |
COUNTRY_2CHAR | char(2) | No | No |
VAT_RGSTRN_ID | char(12) | No | No |
LOC_RGSTRN_ID | char(15) | No | No |
HOME_COUNTRY_FLG | char(1) | No | No |
TAX_AUTH_REGION | char(4) | No | No |
NAME1 | char(40) | No | No |
NAME2 | char(40) | No | No |
VAT_ADMIN_ID | char(20) | No | No |
LOCATION_SETID | char(5) | No | No |
LOCATION | char(10) | No | Yes |
CURRENCY_RPTG | char(3) | No | No |
IST_CRNCY_RPTG | char(3) | No | No |
LAST_VAT_DCMNT_ID | int | No | No |
LAST_IST_DCMNT_ID | int | No | No |
IST_RPTG_FLG | char(1) | No | No |
IST_LEVEL_OBLIG | char(1) | No | No |
VAT_ACCTG_SCHEME | char(1) | No | No |
Index |
Name | Type | Unique | Member |
PS_VAT_ENT_RGSTRN | PK | Yes |
![]() |
Member(s) of "PS_VAT_ENT_RGSTRN" Index |
VAT_ENTITY |
COUNTRY |
Published December 16, 2006 |