PeopleSoft 9
Account Payables

Table Name SHIP_METHOD

Table Description
SHIP_METHOD
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes No
SHIP_TYPE_ID VARCHAR(10) Yes No
DESCR VARCHAR(30) No No
DESCRSHORT VARCHAR(10) No No
CUST_PICKUP VARCHAR(1) No No
MAX_WEIGHT decimal(15,4) No No
MAX_VOLUME decimal(15,4) No No
MIN_WEIGHT decimal(15,4) No No
MIN_VOLUME decimal(15,4) No No
UNIT_MEASURE_WT VARCHAR(3) No No
UNIT_MEASURE_VOL VARCHAR(3) No No
IST_TRANSPORT_MODE VARCHAR(1) No No
Index
Name Type Unique Member
PS_SHIP_METHOD PK Yes
PS0SHIP_METHOD IE4 No
Member(s) of "PS_SHIP_METHOD" Index
SETID
SHIP_TYPE_ID
Member(s) of "PS0SHIP_METHOD" Index
DESCR
SETID
SHIP_TYPE_ID

Published June 06, 2007