| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_GL_NONVW
|
| 2 |
ACCTG_POLICY |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Policy
G=Gross
N=Net
Default Value: G
|
| 3 |
ACCOUNT_INTERUNIT |
Character(10) |
VARCHAR2(10) NOT NULL |
InterUnit Account
Prompt Table:
GL_ACCT_MON_VW
|
| 4 |
ALTACCT_INTERUNIT |
Character(10) |
VARCHAR2(10) NOT NULL |
InterUnit Alt. Account
Prompt Table:
ALTACCT_CUR_VW
|
| 5 |
INTER_UNIT_PAYMENT |
Character(10) |
VARCHAR2(10) NOT NULL |
InterUnit Payment
Prompt Table:
GL_ACCT_MON_VW
|
| 6 |
ACCOUNTING_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Method Field
A=Accrual Method
E=Encumbrance
Default Value: A
|
| 7 |
DSCNT_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Discount
Y/N Table Edit
Default Value: N
|
| 8 |
SALETX_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Sales Tax
Y/N Table Edit
Default Value: N
|
| 9 |
USETAX_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Use Tax
Y/N Table Edit
Default Value: N
|
| 10 |
FRGHT_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Freight Charges
Y/N Table Edit
Default Value: N
|
| 11 |
VAT_NRCVR_PRO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Non-Recoverable VAT
Y/N Table Edit
Default Value: Y
|
| 12 |
VAT_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate VAT
Y/N Table Edit
Default Value: N
|
| 13 |
WRTOFF_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Write Off to Expenses
Y/N Table Edit
Default Value: Y
|
| 14 |
ACCR_DSCNT_LOST_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in the Procurement Accounting Controls to determine the method used for Posting Net vouchers. If Yes, use the new German requirement and book the APA at Gross. If No, book the APA at Net.
Y/N Table Edit
Default Value: N
|
| 15 |
DSCNT_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in the Procurment Accounting Controls to determine if Discounts for a GLBU should be Allocated, Prorated or Non-Prorated. For E&G users, you can only choose Allocate or Prorate. Should set the default on the record to Non-Prorate (Expense)..
A=Allocate Discounts
E=Expense Discounts
P=Prorate Discounts
Default Value: A
|
| 16 |
DSCNT_EARNED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Discount Earned
Y/N Table Edit
Default Value: N
|
| 17 |
DSCNT_LOST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Discount Lost
Y/N Table Edit
Default Value: N
|
| 18 |
FRGHT_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocate Freight
Y/N Table Edit
Default Value: N
|
| 19 |
LATE_INTR_ALL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in the Procurement Accounting Controls page to determine the method of allocation/proration for Late Charges for E&G Customers.
A=Allocate Late Charges
P=Prorate Late Charges
Default Value: A
|
| 20 |
LATE_INTR_PRO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Late Interest
Y/N Table Edit
Default Value: N
|
| 21 |
MISC_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocate Miscellaneous Charges
Y/N Table Edit
Default Value: N
|
| 22 |
SALETX_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocate Sales Tax
Y/N Table Edit
Default Value: N
|
| 23 |
USETAX_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocate Use Tax
Y/N Table Edit
Default Value: N
|
| 24 |
VAT_NRCVR_ALL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocate Non-Recoverable VAT
Y/N Table Edit
Default Value: N
|
| 25 |
VAT_RCVR_PRO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Recoverable VAT
Y/N Table Edit
Default Value: N
|
| 26 |
VAT_RCVR_ALL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocate Recoverable VAT
Y/N Table Edit
Default Value: N
|
| 27 |
APPL_JRNL_ID_ACCR |
Character(10) |
VARCHAR2(10) NOT NULL |
Accruals
Prompt Table:
JRNLGEN_APPL_ID
|
| 28 |
APPL_JRNL_ID_CASH |
Character(10) |
VARCHAR2(10) NOT NULL |
Payments
Prompt Table:
JRNLGEN_APPL_ID
|
| 29 |
APPL_JRNL_ID_VOID |
Character(10) |
VARCHAR2(10) NOT NULL |
Cancels
Prompt Table:
JRNLGEN_APPL_ID
|
| 30 |
APPL_JRNL_ID_CLOSE |
Character(10) |
VARCHAR2(10) NOT NULL |
Closes
Prompt Table:
JRNLGEN_APPL_ID
|
| 31 |
APPL_JRNL_ID_RVL |
Character(10) |
VARCHAR2(10) NOT NULL |
Revaluations
Prompt Table:
JRNLGEN_APPL_ID
|
| 32 |
APPL_JRNL_ID_CSHCL |
Character(10) |
VARCHAR2(10) NOT NULL |
Cash Clearings
Prompt Table:
JRNLGEN_APPL_ID
|
| 33 |
APPL_JRNL_ID_ENCM |
Character(10) |
VARCHAR2(10) NOT NULL |
Encumbrance
Prompt Table:
JRNLGEN_APPL_ID
|
| 34 |
APPL_JRNL_ID_ENCR |
Character(10) |
VARCHAR2(10) NOT NULL |
Encumbrance Reversal
Prompt Table:
JRNLGEN_APPL_ID
|
| 35 |
APPL_JRNL_ID_ENCL |
Character(10) |
VARCHAR2(10) NOT NULL |
Encumbrance Closure
Prompt Table:
JRNLGEN_APPL_ID
|
| 36 |
APPL_JRNL_ID_PREM |
Character(10) |
VARCHAR2(10) NOT NULL |
Pre-Encumbrance
Prompt Table:
JRNLGEN_APPL_ID
|
| 37 |
APPL_JRNL_ID_PRER |
Character(10) |
VARCHAR2(10) NOT NULL |
Pre-Encumbrance Reversal
Prompt Table:
JRNLGEN_APPL_ID
|
| 38 |
APPL_JRNL_ID_PREL |
Character(10) |
VARCHAR2(10) NOT NULL |
Pre-Encumbrance Closure
Prompt Table:
JRNLGEN_APPL_ID
|
| 39 |
APPL_JRNL_ID_RACC |
Character(10) |
VARCHAR2(10) NOT NULL |
Receipt Accrual
Prompt Table:
JRNLGEN_APPL_ID
|
| 40 |
APPL_JRNL_ID_PCARD |
Character(10) |
VARCHAR2(10) NOT NULL |
Procard
Prompt Table:
JRNLGEN_APPL_ID
|
| 41 |
APPL_JRNL_ID_PEACR |
Character(10) |
VARCHAR2(10) NOT NULL |
Period End Accruals
Prompt Table:
JRNLGEN_APPL_ID
|
| 42 |
NPL_BNK_CHRTFLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Bank ChartField
Prompt Table:
AP_CHARTFLD_VW
|
| 43 |
BAL_CHRT_TXT |
Character(254) |
VARCHAR2(254) NOT NULL |
Balanced Chartfields Text
|
| 44 |
COMBO_EDIT_TMPL |
Character(10) |
VARCHAR2(10) NOT NULL |
Record Template
Prompt Table:
AP_COMB_TMPL_VW
|
| 45 |
MISC_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Miscellaneous Charge
Y/N Table Edit
Default Value: N
|
| 46 |
SALETX_CHARGE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
Prompt Table:
BU_STX_LC_CMPVW
|
| 47 |
USETAX_CHARGE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
Prompt Table:
BU_UTX_LC_CMPVW
|
| 48 |
FRGHT_CHARGE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
Prompt Table:
BU_FRG_LC_CMPVW
|
| 49 |
MISC_CHARGE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
Prompt Table:
BU_MSC_LC_CMPVW
|
| 50 |
ERS_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
ERS Option
N=No ERS
Y=Allow ERS
Default Value: N
|
| 51 |
ERS_INV_DT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
ERS Invoice Date Option
F=Frt Terms
R=Recv Date
Default Value: R
|
| 52 |
SBI_DOC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
SelfBillingNumber
G=Group Vouchers (Auto-Num)
I=Individual Voucher (Auto-Num)
P=Individual Vchr-Invoice Number
Default Value: I
|
| 53 |
ERS_TAX_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ERS Tax Type
B=Sales Tax
N=No Taxes
U=Use Tax
V=Value Added Tax
|
| 54 |
UNPOST_PAID_VCHR |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Unpost Paid Vouchers
Y/N Table Edit
Default Value: Y
|
| 55 |
ACCT_DT_EDT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Date Edit Option
E=Error Message
N=No Message
W=Warning Message
Default Value: N
|
| 56 |
VAT_CF_ANLSYS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Chartfield Analysis
E=Use Expense Line Chartfields
N=Not Applicable
V=Use VAT Accounting Chartfields
|
| 57 |
VAT_NRCVR_CHRG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
ProrateVAT Non-Recovery
Prompt Table:
BU_NRV_LC_CMPVW
|
| 58 |
DOC_TOL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Document Tolerance
Y/N Table Edit
Default Value: N
|
| 59 |
DISCOUNT_MEMO_ACCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in Procurement Acctg Control to set whether to record Discount Memo account during Posting.
Y/N Table Edit
Default Value: N
|
| 60 |
AP_ACCRL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Period End Accruals indicator Flag
Y/N Table Edit
Default Value: N
|
| 61 |
AP_KK_ACCRL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control option for Period End Accruals
Y/N Table Edit
Default Value: N
|