ACCTG_TAG_HD(SQL Table) |
Index Back |
---|---|
Accounting Tag Header RecordsThis table contains Accounting tag header definition information. |
# | 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 Prompt Table: SP_SETID_NONVW |
2 | ACCOUNT_CODE | Character(20) | VARCHAR2(20) NOT NULL | Accounting Tag |
3 | BALANCE_PCT | Character(1) | VARCHAR2(1) NOT NULL |
Balanced Speedchart
N=No Y=Yes Default Value: N |
4 | ACCTG_TAG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Permission for Accounting Tag
C=Permission List O=User List U=All Users Default Value: U |
5 | PUBLISH | Character(1) | VARCHAR2(1) NOT NULL | Publish Data |
6 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
7 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
8 | ACCTG_LINE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Accounting Line Type
M=Multiple Line S=Single Line Default Value: M |