AUTO_REASON_TBL(SQL Table) |
Index Back |
|---|---|
Auto Entry Reason Codes |
| # | 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 | ENTRY_USE_ID |
Character(5) | VARCHAR2(5) NOT NULL |
Specifies the System Function or type of processing associated with an entry type.
Prompt Table: ENTRY_USE_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | ENTRY_REASON |
Character(5) | VARCHAR2(5) NOT NULL |
"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
Prompt Table: ENTRY_REASN_TBL |
| 5 | ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table: EE_AR_CODE1_VW |
| 6 | DEFAULT_RSN | Character(1) | VARCHAR2(1) NOT NULL |
Default Reason Code
Y/N Table Edit Default Value: N |
| 7 | OC_SEQ_NUM | Number(4,0) | SMALLINT NOT NULL | Overdue Charge Sequence |
| 8 | BALANCED_LINES | Character(1) | VARCHAR2(1) NOT NULL |
Entries Must Balance
Y/N Table Edit Default Value: Y |
| 9 | DST_ID_AR | Character(10) | VARCHAR2(10) NOT NULL |
Specifies the general ledger ChartField combination that is affected when subsequent activity such as a payment occurs for the item.
Prompt Table: DST_CODE_AR_VW |
| 10 | CC_REV_BUCKET | Character(1) | VARCHAR2(1) NOT NULL |
Inidcate which revenue bucket to update.
B=Both C=Collected N=None R=Recognized Prompt Table: REV_EST_OPT_VW |
| 11 | CC_AMT_MULTIPLIER | Signed Number(2,0) | DECIMAL(1) NOT NULL | To reset the sign of the amount when generating commitment control source transaction. |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 13 | MAX_WRITE_OFF_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Maximum amount allowed for write off on worksheet |
| 14 | MAX_WRITE_OFF_PCT | Number(3,0) | SMALLINT NOT NULL | Write off Tolerance Percentage of amount |
| 15 | MAX_WRITE_OFF_DAYS | Number(3,0) | SMALLINT NOT NULL | Write off Tolerance Days from Deduction date |
| 16 | BANKRUPT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Bankrupt
Y/N Table Edit Default Value: N |