PeopleSoft 9
Account Payables

Table Name CNTRCT_LINE

Table Description
CNTRCT_LINE
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
CNTRCT_ID VARCHAR(25) Yes Yes
CNTRCT_LINE_NBR int Yes No
LINE_STATUS VARCHAR(1) No No
ITM_SETID VARCHAR(5) No No
INV_ITEM_ID VARCHAR(18) No No
DESCR254_MIXED VARCHAR(254) No No
ITM_ID_VNDR VARCHAR(50) No No
VNDR_CATALOG_ID VARCHAR(20) No No
CATEGORY_ID VARCHAR(5) No No
MFG_ID VARCHAR(50) No No
MFG_ITM_ID VARCHAR(50) No No
QTY_LINE_MIN decimal(14,2) No No
QTY_LINE_MAX decimal(14,2) No No
QTY_LINE_RELEASED decimal(14,2) No No
QTY_LINE_RELSD_CUM DECIMAL(14,2) No No
AMT_LINE_MIN decimal(26,3) No No
AMT_LINE_MAX decimal(26,3) No No
AMT_LINE_RELEASED decimal(26,3) No No
AMT_LINE_RELSD_CUM DECIMAL(26,3) No No
INCLUDE_FOR_RELS VARCHAR(1) No No
LINE_PRICE_TYPE VARCHAR(1) No No
USE_CNTRCT_BASE VARCHAR(1) No No
PRICE_UOM_ADJ VARCHAR(1) No No
PRICE_SHIPTO_ADJ VARCHAR(1) No No
ADJ_BEFORE VARCHAR(1) No No
QTY_TYPE VARCHAR(1) No No
PRICE_DT_TYPE VARCHAR(1) No No
PRICE_CAN_CHANGE VARCHAR(1) No No
UNIT_OF_MEASURE VARCHAR(3) No No
MERCHANDISE_AMT decimal(26,3) No No
TOTAL_DISTRIBS int No No
MAX_DISTRIB_LINE int No No
STATISTIC_AMOUNT decimal(15,2) No No
UNIT_PRICE decimal(15,5) No No
TAX_CD VARCHAR(8) No No
DSCNT_APPL_FLG VARCHAR(1) No No
FRGHT_PRORATE_FLG VARCHAR(1) No No
CURRENCY_CD VARCHAR(3) No No
RFQ_ID VARCHAR(10) No No
RFQ_LINE_NBR int No No
PHYSICAL_NATURE VARCHAR(1) No No
VAT_RECOVERY_PCT decimal(5,2) No No
WTHD_SETID VARCHAR(5) No No
WTHD_SW VARCHAR(1) No No
WTHD_CD VARCHAR(5) No No
SHIPTO_ID VARCHAR(10) No No
SUT_BASE_ID VARCHAR(10) No No
TAX_CD_SUT VARCHAR(8) No No
SUT_EXCPTN_TYPE VARCHAR(1) No No
SUT_EXCPTN_CERTIF VARCHAR(20) No No
SUT_APPLICABILITY VARCHAR(1) No No
AMT_ONLY_FLG VARCHAR(1) No No
RETENTION_CD VARCHAR(1) No No
RETENTION_PCT decimal(6,3) No No
RETENTION_AMT decimal(26,3) No No
ULTIMATE_USE_CD VARCHAR(8) No No
CNTRCT_LN_TYPE VARCHAR(1) No No
CNTR_LN_TYPE_ID VARCHAR(30) No No
USER_LINE_CHAR1 VARCHAR(1) No No
OPRID_MODIFIED_BY VARCHAR(30) No No
LAST_DTTM_UPDATE PSDATETIME No No
Index
Name Type Unique Member
PS_CNTRCT_LINE PK Yes
Member(s) of "PS_CNTRCT_LINE" Index
SETID
CNTRCT_ID
CNTRCT_LINE_NBR

Published June 06, 2007