PeopleSoft 9
Account Payables

Table Name CNTRCT_RLS_LN

Table Description
CNTRCT_RLS_LN
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
CNTRCT_ID VARCHAR(25) Yes Yes
BUSINESS_UNIT VARCHAR(5) Yes Yes
TRANS_DATE PSDATE Yes Yes
SEQ_NUM SMALLINT Yes Yes
RELEASE_TYPE VARCHAR(1) Yes Yes
LINE_NBR int Yes No
CNTRCT_LINE_NBR int No No
RECV_REQ VARCHAR(1) No No
INSPECT_CD VARCHAR(1) No No
ROUTING_ID VARCHAR(10) No No
UNIT_PRC_TOL decimal(13,5) No No
PCT_UNIT_PRC_TOL decimal(5,2) No No
INVENTORY_ITEM VARCHAR(1) No No
RFQ_ID VARCHAR(10) No No
RFQ_LINE_NBR int No No
LEAD_TIME SMALLINT No No
UNIT_OF_MEASURE VARCHAR(3) No No
TOTAL_DISTRIBS int No No
MAX_DISTRIB_LINE int No No
DESCR254_MIXED VARCHAR(254) No No
MERCHANDISE_AMT decimal(26,3) No No
ITM_SETID VARCHAR(5) No No
INV_ITEM_ID VARCHAR(18) No No
STATISTIC_AMOUNT decimal(15,2) No No
UNIT_PRICE decimal(15,5) No No
DSCNT_APPL_FLG VARCHAR(1) No No
WTHD_SETID VARCHAR(5) No No
WTHD_SW VARCHAR(1) No No
WTHD_CD VARCHAR(5) No No
VAT_RECOVERY_PCT decimal(5,2) No No
TAX_CD VARCHAR(8) No No
VAT_APPL_FLG VARCHAR(1) No No
CURRENCY_CD VARCHAR(3) No No
TAX_CD_VAT VARCHAR(8) No No
VAT_TXN_TYPE_CD VARCHAR(4) 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
ULTIMATE_USE_CD VARCHAR(8) No No
VAT_APPLICABILITY VARCHAR(1) No No
VAT_USE_ID VARCHAR(6) No No
PHYSICAL_NATURE VARCHAR(1) No No
VAT_SVC_PERFRM_FLG VARCHAR(1) No No
CATEGORY_ID VARCHAR(5) No No
AMT_ONLY_FLG VARCHAR(1) No No
UNIT_PRC_TOL_L decimal(13,5) No No
PCT_UNIT_PRC_TOL_L decimal(5,2) No No
MILESTONE_NBR int No No
RETENTION_CD VARCHAR(1) No No
RETENTION_AMT decimal(26,3) No No
MFG_ID VARCHAR(50) No No
MFG_ITM_ID VARCHAR(50) No No
VNDR_CATALOG_ID VARCHAR(20) No No
ITM_ID_VNDR VARCHAR(50) No No
USER_LINE_CHAR1 VARCHAR(1) No No
Index
Name Type Unique Member
PS_CNTRCT_RLS_LN PK Yes
Member(s) of "PS_CNTRCT_RLS_LN" Index
SETID
CNTRCT_ID
BUSINESS_UNIT
TRANS_DATE
SEQ_NUM
RELEASE_TYPE
LINE_NBR

Published June 06, 2007