FO_ERNCD_ATTRIB

(SQL Table)
 Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

Prompt Table: EARNINGS_TBL

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

5 TIME_RPTG_CD Character(5) VARCHAR2(5) NOT NULL Time Reporting Code

Prompt Table: FO_TRC_VW

6 LINE_DST_SEQ_NUM Number(3,0) SMALLINT NOT NULL Revenue Sequence Number
7 LINE_TYPE Character(4) VARCHAR2(4) NOT NULL Line Type 1
ADV=Advance Billing
BAE=Billed Amount in Excess
BRT=Billing Retainage
DAPP=Cust Deposit Applied
DEP=Customer Deposit
DISC=Discount Line
DREF=Cust Deposit Refunded
DRFF=Cust Deposit Refund Fee
FRGT=Freight (Surcharge)
MISC=Miscellaneous Charge
PYCV=Payment with Corporate Voucher
RAE=Reclaimed Amount in Excess
REV=Revenue Line
RSTK=Restock (Surcharge)
SUR=Surcharge Line
UTL=Utilization Line
8 FO_TRC_1099_FLG Character(1) VARCHAR2(1) NOT NULL Reportable 1099 TRC

Y/N Table Edit

Default Value: N

9 FO_TRC_SEP_CHK_FLG Character(1) VARCHAR2(1) NOT NULL Separate Check Required TRC

Y/N Table Edit

Default Value: N

10 FO_UI_PAYMENT_TYPE Character(1) VARCHAR2(1) NOT NULL UI Payment Type
11 FO_ACCT_AV_EXP Character(35) VARCHAR2(35) NOT NULL Associate Supplier Expense

Prompt Table: GL_ACCOUNT_TBL
Set Control Field: BUSINESS_UNIT

12 FO_ACCT_AV_REV Character(35) VARCHAR2(35) NOT NULL Associate Supplier Revenue

Prompt Table: GL_ACCOUNT_TBL
Set Control Field: BUSINESS_UNIT

13 FO_ACCT_DIR_EXP Character(35) VARCHAR2(35) NOT NULL Direct Expense

Prompt Table: GL_ACCOUNT_TBL
Set Control Field: BUSINESS_UNIT

14 FO_ACCT_INDIR_EXP Character(35) VARCHAR2(35) NOT NULL Indirect Expense

Prompt Table: GL_ACCOUNT_TBL
Set Control Field: BUSINESS_UNIT

15 FO_ACCT_REV_DIR Character(35) VARCHAR2(35) NOT NULL Revenue

Prompt Table: GL_ACCOUNT_TBL
Set Control Field: BUSINESS_UNIT

16 FO_ACCT_REV_INTER Character(35) VARCHAR2(35) NOT NULL InterUnit Revenue

Prompt Table: GL_ACCOUNT_TBL
Set Control Field: BUSINESS_UNIT

17 FO_ACCT_REV_INTRA Character(35) VARCHAR2(35) NOT NULL IntraUnit Revenue

Prompt Table: GL_ACCOUNT_TBL
Set Control Field: BUSINESS_UNIT

18 FO_ACCT_EXP_INTER Character(35) VARCHAR2(35) NOT NULL InterUnit Expense

Prompt Table: GL_ACCOUNT_TBL
Set Control Field: BUSINESS_UNIT

19 FO_ACCT_EXP_INTRA Character(35) VARCHAR2(35) NOT NULL IntraUnit Expense

Prompt Table: GL_ACCOUNT_TBL
Set Control Field: BUSINESS_UNIT

20 DESCR Character(30) VARCHAR2(30) NOT NULL Description
21 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RES_TYPE
Set Control Field: BUSINESS_UNIT

22 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: PROJ_CATG_TBL
Set Control Field: BUSINESS_UNIT

23 FO_RESOURCE_TYP_AP Character(5) VARCHAR2(5) NOT NULL AP Resource Type

Prompt Table: PROJ_RES_TYPE
Set Control Field: BUSINESS_UNIT

24 FO_RESOURCE_CAT_AP Character(5) VARCHAR2(5) NOT NULL AP Resource Category

Prompt Table: PROJ_CATG_TBL
Set Control Field: BUSINESS_UNIT