PeopleSoft 9
Account Payables

Table Name VCHR_LINE_TXGEO

Table Description
VCHR_LINE_TXGEO
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
VOUCHER_LINE_NUM int Yes Yes
LOC_TYPE VARCHAR(1) Yes No
COUNTRY VARCHAR(3) No No
ADDRESS1 VARCHAR(55) No No
ADDRESS2 VARCHAR(55) No No
ADDRESS3 VARCHAR(55) No No
ADDRESS4 VARCHAR(55) No No
CITY VARCHAR(30) No No
NUM1 VARCHAR(6) No No
NUM2 VARCHAR(4) No No
HOUSE_TYPE VARCHAR(2) No No
ADDR_FIELD1 VARCHAR(2) No No
ADDR_FIELD2 VARCHAR(4) No No
ADDR_FIELD3 VARCHAR(4) No No
COUNTY VARCHAR(30) No No
STATE VARCHAR(6) No No
POSTAL VARCHAR(12) No No
GEO_CODE VARCHAR(11) No No
IN_CITY_LIMIT VARCHAR(1) No No
Index
Name Type Unique Member
PS_VCHR_LINE_TXGEO PK Yes
Member(s) of "PS_VCHR_LINE_TXGEO" Index
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM
LOC_TYPE

Published June 06, 2007