PeopleSoft 9
Account Payables

Table Name VCHR_LINE_SUTL

Table Description
VCHR_LINE_SUTL
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
TAX_LOC_TYPE VARCHAR(1) No 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_SUTL PK Yes
Member(s) of "PS_VCHR_LINE_SUTL" Index
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM

Published June 06, 2007