FS_CF_LEDFLD_VW(SQL View) |
Index Back |
|---|---|
Chartfield Template TableChartfield Te |
| SELECT A.ORIG_CF_NAME , A.FIELDNAME , A.CF_ORDER , A.CF_TYPE , A.CF_LENGTH , A.DISPLAY_LENGTH , A.CF_ACTIVE_STATUS , A.DELETE_CF , A.AFFILIATE_TYPE , A.AFF_RELATED_CF , A.ADDED_CF , A.MODEL_CF , A.RECNAME , A.ORIG_REC_NAME , A.PREV_DISPLAY_LEN , A.PREV_CF_ORDER , A.SYNCID , A.SYNCDTTM , B.FIELDNUM FROM PS_FS_CF_TEMPLATE A , PSRECFIELDDB B WHERE A.FIELDNAME = B.FIELDNAME AND B.RECNAME = 'LEDGER' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ORIG_CF_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Holds the Original Chartfield Name. This will not change! |
| 2 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 3 | CF_ORDER | Number(2,0) | SMALLINT NOT NULL | ChartField Sequence Order |
| 4 | CF_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Chartfield Type - Use specificaly for Chartfield Template.
A=Affiliate C=Currency Code D=Deleted Chartfield F=Fully Configurable P=Partially Configurable S=Statistic Code X=Product Specific Default Value: F |
| 5 | CF_LENGTH | Number(2,0) | SMALLINT NOT NULL | ChartField Length |
| 6 | DISPLAY_LENGTH | Number(2,0) | SMALLINT NOT NULL | Use to determine the ChartField Length to be display. |
| 7 | CF_ACTIVE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
The user can specify CF to be Active, Inactive or Deleted. This field was formerly called User Option.
A=Active ChartField D=Delete I=Inactive ChartField Default Value: A |
| 8 | DELETE_CF | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No Indicator
Y/N Table Edit Default Value: N |
| 9 | AFFILIATE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Tells if the Chartfield is Intra Unit Affiliate or Inter Unit Affiliate.
A=IntraUnit Affiliate I=InterUnit Affiliate X=Standard Default Value: X |
| 10 | AFF_RELATED_CF | Character(18) | VARCHAR2(18) NOT NULL |
Holds the Related Chartfield that is needed by Affiliate Chartfield.
Prompt Table: AFF_CF_PRMPT_VW |
| 11 | ADDED_CF | Character(1) | VARCHAR2(1) NOT NULL |
Flag that will determine if the chartfield was added.
Y/N Table Edit Default Value: N |
| 12 | MODEL_CF | Character(18) | VARCHAR2(18) NOT NULL |
Holds the model chartfield that will be use by the CF Config Util.
Prompt Table: MODEL_CF_VW |
| 13 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 14 | ORIG_REC_NAME | Character(15) | VARCHAR2(15) NOT NULL | Original Record Name |
| 15 | PREV_DISPLAY_LEN | Number(2,0) | SMALLINT NOT NULL | Previous ChartField Display Length |
| 16 | PREV_CF_ORDER | Number(2,0) | SMALLINT NOT NULL | Previous ChartField Sequence Order |
| 17 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 18 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |
| 19 | FIELDNUM | Number(4,0) | SMALLINT NOT NULL | Field Number |