| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 4 |
TRANS_DATE |
Date(10) |
DATE |
Transaction Date
|
| 5 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
Default Value: 1
|
| 6 |
RELEASE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Release Type
P=Purchase Order
V=Voucher
|
| 7 |
RELEASE_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Release Status
C=Complete
CL=Closed
E=Error
I=In Process
O=Open
S=Staged
Default Value: O
|
| 8 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 9 |
BUYER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer
Prompt Table:
%EDIT_BUYER
|
| 10 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
Default Value: CNTRCT_HDR.ORIGIN
Prompt Table:
ORIGIN_PO
|
| 11 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID
|
| 12 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
Default Value: BUS_UNIT_OPT_PM.PYMNT_TERMS_CD
Prompt Table:
PYMT_TR_EFF_VW
|
| 13 |
BILL_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Location
Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION
|
| 14 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 15 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 16 |
RATE_DATE |
Date(10) |
DATE |
Exchange Rate Date
|
| 17 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 18 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 19 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 20 |
DST_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Template
|
| 21 |
GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Invoice Amount
|
| 22 |
VAT_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
"A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
E=Exclusive
I=Inclusive
|
| 23 |
VAT_CALC_GROSS_NET |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross
N=Calculate at Net
|
| 24 |
VAT_RECALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
Y/N Table Edit
Default Value: N
|
| 25 |
VAT_CALC_FRGHT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Freight
Y/N Table Edit
Default Value: N
|
| 26 |
VAT_RCRD_INPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a business unit will pay the VAT and recover it later from the VAT tax authority. VAT input is usually associated with purchase transactions.
Y/N Table Edit
Default Value: N
|
| 27 |
VAT_RCRD_OUTPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) VAT will be collected by the vendor on behalf of the government. VAT output is usually associated with sales transactions.
Y/N Table Edit
Default Value: N
|
| 28 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
Prompt Table:
VAT_HEADER_VW
|
| 29 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
Prompt Table:
VAT_TXN_CD
|
| 30 |
VAT_RECOVERY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Recovery Percent
|
| 31 |
VAT_ROUND_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
" Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up
|
| 32 |
VAT_CALC_MISC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Miscellaneous
Y/N Table Edit
Default Value: N
|
| 33 |
VAT_DCLRTN_POINT |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time
|
| 34 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 35 |
MISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 36 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 37 |
VAT_ENTRD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered VAT Amount
|
| 38 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 39 |
CNTCT_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Contact Sequence Number
|
| 40 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 41 |
TAX_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit
Default Value: N
|
| 42 |
TAX_EXEMPT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Tax Exempt ID
|
| 43 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 44 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In process flag
Y/N Table Edit
Default Value: N
|
| 45 |
PAY_TRM_BSE_DT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Terms Basis Date Type
A=Acct Date
C=Doc Date
I=Inv Date
R=Recpt Date
S=Ship Date
U=User Date
|
| 46 |
TERMS_BASIS_DT |
Date(10) |
DATE |
Payment Terms Basis Date
|
| 47 |
COMMENTS_2000 |
Long Character |
CLOB |
Comment Text
|
| 48 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 49 |
EIN_FEDERAL |
Character(9) |
VARCHAR2(9) NOT NULL |
EIN Federal
|
| 50 |
EIN_STATE_LOCAL |
Character(20) |
VARCHAR2(20) NOT NULL |
EIN State Local
|
| 51 |
VCHR_SRC |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Source
Default Value: CNTR
|
| 52 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 53 |
USER_HDR_CHAR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 1
|
| 54 |
CUSTOM_C100_A1 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 1
|
| 55 |
CUSTOM_C100_A2 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 2
|
| 56 |
CUSTOM_C100_A3 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 3
|
| 57 |
CUSTOM_C100_A4 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 4
|
| 58 |
CUSTOM_DATE_A |
Date(10) |
DATE |
Custom Date
|
| 59 |
CUSTOM_C1_A |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 2
|
| 60 |
PREPAID_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Prepayment Reference
|
| 61 |
VERSION_NBR |
Number(5,0) |
INTEGER NOT NULL |
Contract Version number
Default Value: 1
|