PeopleSoft 9 Account Payables |
Table Name | CNTRCT_HDR_MISC |
Table Description |
CNTRCT_HDR_MISC |
Columns |
Name | Datatype | Is PK | Is FK |
SETID | VARCHAR(5) | Yes | Yes |
CNTRCT_ID | VARCHAR(25) | Yes | Yes |
MISC_CHARGE_SETID | VARCHAR(5) | Yes | No |
MISC_CHARGE_CODE | VARCHAR(10) | Yes | No |
LC_COMP_FLAG | VARCHAR(1) | No | No |
DST_ACCT_TYPE | VARCHAR(4) | No | No |
LC_COMP_CALC | VARCHAR(3) | No | No |
LC_COMP_ALLOC | VARCHAR(3) | No | No |
LC_COMP_ON_PO | VARCHAR(1) | No | No |
CHARGE_AMOUNT | decimal(26,3) | No | No |
CURRENCY_CD | VARCHAR(3) | No | No |
X_VENDOR_SETID | VARCHAR(5) | No | No |
X_VENDOR_ID | VARCHAR(10) | No | No |
X_VNDR_LOC | VARCHAR(10) | No | No |
UNIT_PRICE | decimal(15,5) | No | No |
PRORATE_FLG | VARCHAR(1) | No | No |
FLAT_AMOUNT | decimal(26,3) | No | No |
PCT_VALUE | decimal(7,2) | No | No |
UNIT_OF_MEASURE | VARCHAR(3) | No | No |
LC_ACCRUAL_FLAG | VARCHAR(1) | No | No |
LC_RTV_CREDIT | VARCHAR(1) | No | No |
OPRID_MODIFIED_BY | VARCHAR(30) | No | No |
LAST_DTTM_UPDATE | PSDATETIME | No | No |
Index |
Name | Type | Unique | Member |
PS_CNTRCT_HDR_MISC | PK | Yes |
![]() |
Member(s) of "PS_CNTRCT_HDR_MISC" Index |
SETID |
CNTRCT_ID |
MISC_CHARGE_SETID |
MISC_CHARGE_CODE |
Published June 06, 2007 |