CA_LINE_DST_STG

(SQL Table)
Index Back

Line: Accounting Distrib

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
3 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
5 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
6 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code
7 PRICING_STRUCTURE Character(4) VARCHAR2(4) NOT NULL Price Type
AMT=Amount
PCT=Percent
RATE=Rate
RCR=Recurring
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
10 EFFDT Date(10) DATE Effective Date

Default Value: %date

11 SRC_CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Source Contract Number
12 SRC_CONTR_LN_NUM Number(3,0) SMALLINT NOT NULL Source Contract Line Number