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 |