| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 3 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 4 |
TOTAL_DISTRIBS |
Number(5,0) |
INTEGER NOT NULL |
Total Number of Distributions
|
| 5 |
MAX_DISTRIB_LINE |
Number(5,0) |
INTEGER NOT NULL |
Highest Distribution Line
|
| 6 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 7 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 8 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number
|
| 9 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 10 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 11 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 12 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
|
| 13 |
MERCH_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Merchandise Amount
|
| 14 |
ITM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Item SetID
|
| 15 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 16 |
QTY_VCHR |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Vouchered
|
| 17 |
STATISTIC_AMOUNT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Statistic Amount
|
| 18 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set
|
| 19 |
UNIT_PRICE |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Unit Price
|
| 20 |
SALETX_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Tax Applicable
Default Value: Y
|
| 21 |
USETAX_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use tax applicable flag.
Default Value: Y
|
| 22 |
FRGHT_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Freight Charges
Default Value: Y
|
| 23 |
DSCNT_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Discount
Default Value: Y
|
| 24 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
Default Value: N
|
| 25 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 26 |
WTHD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Withholding Flag
|
| 27 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
VAT code.
|
| 28 |
VAT_RECOVERY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT recovery percent.
|
| 29 |
FINAL_REF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Reference Indicator
|
| 30 |
BUSINESS_UNIT_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Receiving Business Unit
|
| 31 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver ID Number
|
| 32 |
RECV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Receiver Line Number
|
| 33 |
RECV_SHIP_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Receiver Shipping Sequence
|
| 34 |
MATCH_LINE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Line Option
E=ERS Match
F=Full Match
N=Don't Match
Default Value: N
|
| 35 |
DISTRIB_MTHD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribute by
A=Amount
Q=Quantity
Default Value: A
|
| 36 |
VCHR_AMT_FORCE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Set Merchandise Amount
Default Value: N
|
| 37 |
AMT_ONLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Amount Only
Default Value: N
|
| 38 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 39 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency
|
| 40 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 41 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Transaction Type
|
| 42 |
ECTRANSID |
Character(15) |
VARCHAR2(15) NOT NULL |
Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
|
| 43 |
ECQUEUEINSTANCE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
|
| 44 |
ECTRANSINOUTSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
|
| 45 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
|
| 46 |
SUT_BASE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales/Use Tax Destination
|
| 47 |
TAX_CD_SUT |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax code - Sales and Use tax.
|
| 48 |
ULTIMATE_USE_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Ultimate Use Code
|
| 49 |
SUT_EXCPTN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales/Use Tax Exception Type
D=Direct Pay
E=Exempt/Exonerated
N=None
|
| 50 |
SUT_EXCPTN_CERTIF |
Character(20) |
VARCHAR2(20) NOT NULL |
Sales/Use Tax Exception Certif
|
| 51 |
SUT_APPLICABILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales/Use Tax Applicability
D=Sales Tax Appl, Direct Pay
E=Item is Exempt
S=Sales Tax Appl
U=Use Tax Appl
X=Purchaser is Exonerated
Default Value: E
|
| 52 |
WTHD_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Setid
|
| 53 |
WTHD_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Code
|
| 54 |
NATURE_OF_TXN1 |
Character(1) |
VARCHAR2(1) NOT NULL |
nATURE OF tRANSACTION 1
|
| 55 |
NATURE_OF_TXN2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Nature of Transaction 2
|
| 56 |
VAT_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT applicable flag.
|
| 57 |
VAT_APPLICABILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Applicability
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT only
|
| 58 |
VAT_USE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Use Type
|
| 59 |
VAT_ENTITY |
Character(20) |
VARCHAR2(20) NOT NULL |
VAT reporting entity.
|
| 60 |
BUSINESS_UNIT_RTV |
Character(5) |
VARCHAR2(5) NOT NULL |
RTV Business Unit
|
| 61 |
RTV_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Return To Vendor ID
|
| 62 |
RTV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Return To Vendor Line
|
| 63 |
FISCAL_REGIME |
Character(2) |
VARCHAR2(2) NOT NULL |
Fiscal Regime
|
| 64 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|