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 |