PROJ_TXP_TYP_LG(SQL Table) |
Index Back |
---|---|
Project Transaction Types LineProject Transaction Types Line |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID |
2 | PROJ_TRANS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Project Transaction Type |
3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
4 | PROJ_DIST_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Project Distribution Type
AP=Accounts Payable Liability AR=Accounts Receivable AS=Fixed Asset CA=Contra Asset CG=Cost of Goods Sold CL=Contra Liability EX=Expense IF=Intercompany From IN=Inventory IT=Intercompany To RE=Revenue UE=Unearned Revenue UR=Unbilled Receivable WP=Work in Progress |
5 | DEBIT_CREDIT | Character(2) | VARCHAR2(2) NOT NULL |
Debit / Credit Indicator
CR=Credit DR=Debit Default Value: DR |
6 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
8 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |