CA_LMT_SET_TAO

(SQL Table)
Index Back

Set of Limits to Process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
5 BUSINESS_UNIT_CA Character(5) VARCHAR2(5) NOT NULL Contracts Business Unit
6 CONTRACT_SIGN_DT Date(10) DATE Contract Signed
7 DISCOUNT_ID Character(15) VARCHAR2(15) NOT NULL Discount ID
8 DISCOUNT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Discount Percentage
9 RETAINAGE_ID Character(15) VARCHAR2(15) NOT NULL Retainage ID
10 RETAINAGE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Retainage Percentage
11 LIMIT_AMT_BIL Signed Number(28,3) DECIMAL(26,3) NOT NULL Funded/Billing Limit Amount