| # |
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:
SET_VLD_FS_05
|
| 2 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
Prompt Table:
GL_ACCOUNT_TBL
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 7 |
BUDG_OVERRIDE_ACCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Override Account
Default Value: N
|
| 8 |
ACCOUNTING_OWNER |
Character(30) |
VARCHAR2(30) NOT NULL |
Accounting Owner
|
| 9 |
AB_ACCOUNT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
ABM Account
Default Value: N
|
| 10 |
GL_ACCOUNT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
General Ledger Account
Default Value: Y
|
| 11 |
PF_ACCOUNT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Performance Measurement
Default Value: N
|
| 12 |
ACCOUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Type
$=Issue Check
C=Checking
L=Liability
N=Non Applicable
S=Savings
X=Expense
|
| 13 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set
|
| 14 |
OPEN_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
OpenItem Account
Default Value: N
|
| 15 |
OPEN_ITEM_DESCR |
Character(10) |
VARCHAR2(10) NOT NULL |
Description of OpenItem
|
| 16 |
OPEN_ITEM_EDIT_REC |
Character(15) |
VARCHAR2(15) NOT NULL |
OpenItem Edit Record
|
| 17 |
OPEN_ITEM_EDIT_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
OpenItem Edit Field
|
| 18 |
OPEN_ITEM_PROMPT |
Character(15) |
VARCHAR2(15) NOT NULL |
Open Item Prompt Table
|
| 19 |
OPEN_ITEM_TOL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Reconcile Tolerance
|
| 20 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 21 |
STATISTICS_ACCOUNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Statistical Account
Default Value: N
|
| 22 |
BALANCE_FWD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Balance forward indicator.
Default Value: Y
|
| 23 |
CONTROL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag in used to desginate an Account or Alternate Account as Control Accounts and Control Alternate Accounts, respectively.
Default Value: N
|
| 24 |
BOOK_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Book Code for GL Account Tbl synchronization
|
| 25 |
BAL_SHEET_IND |
Character(2) |
VARCHAR2(2) NOT NULL |
Balance Sheet Indicator No translates required as this is only for a message synchronization
|
| 26 |
VAT_ACCOUNT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Account Flag.
A=VAT Applicable Account
N=Non-VAT Related
V=VAT Account
Default Value: N
|
| 27 |
VAT_RCRD_INPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT record input.
Default Value: N
|
| 28 |
VAT_RCRD_OUTPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT record output.
Default Value: N
|
| 29 |
VAT_CALC_TYPE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT calculation type.
D=Default From Higher Level
S=Specify at this Level
Default Value: D
|
| 30 |
VAT_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT calculation type.
E=Exclusive
I=Inclusive
N=Not Applicable
|
| 31 |
VAT_TXN_CD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT transaction code.
D=Default From Higher Level
S=Specify at this Level
Default Value: D
|
| 32 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Transaction Type
|
| 33 |
VAT_TOL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT tolerance check indicator.
D=Default From igher Level
S=Specify at this Level
Default Value: D
|
| 34 |
VAT_TOL_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
VAT Tolerance Amount
|
| 35 |
VAT_TOL_CUR_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency
|
| 36 |
VAT_TOL_PCT |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
VAT Tolerance Percentage
|
| 37 |
VAT_TOL_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Rate Type
|
| 38 |
TAX_CD_VAT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Code flag.
D=Default From Higher Level
S=Specify at this Level
Default Value: D
|
| 39 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
VAT code.
|
| 40 |
VAT_USE_ID_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT use id flag.
D=Default from a higher level
Default Value: D
|
| 41 |
VAT_USE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Use Type
|
| 42 |
VAT_DST_ACCT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger.
|
| 43 |
VAT_APPLICABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Applicable This field is intended for GL Account Tbl synchronization. No translates are added to allow adding translates on FDM without affecting HR.
|
| 44 |
BUDGETARY_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Budgetary only replaces System Maint Acct intended for table synchronization
Default Value: N
|