SETIDCNAO_DOCT_IDCNAO_TRX_TY_IDPrompt Table: DOC_TYPE_TBL
CNAO_TRX_TYPE(SQL Table) |
Index Back |
|---|---|
CNAO Transaction TypeCNAO Transaction Type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CNAO_DOCT_ID |
Character(60) | VARCHAR2(60) NOT NULL | CNAO Document Type ID |
| 3 | CNAO_TRX_TY_ID |
Character(60) | VARCHAR2(60) NOT NULL | CNAO Transaction Type ID |
| 4 | CNAO_TRX_TY_NM | Character(60) | VARCHAR2(60) NOT NULL | CNAO Transaction Type Name |
| 5 | DOC_TYPE | Character(8) | VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
Prompt Table: DOC_TYPE_TBL |