| # |
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
Default Value: NEXT
|
| 3 |
VOUCHER_STYLE |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Style
A=Adjustment
ADJ=Adjustments
ERS=ERS Voucher
J=Journal
JRNL=Journal Voucher
P=Purchase Order
PPAY=Prepaid Voucher
R=Regular
REG=Regular Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
|
| 4 |
INVOICE_ID |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice Number
|
| 5 |
ERS_INV_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
ERS Invoice Sequence
|
| 6 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 7 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor Set ID
|
| 8 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 9 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 10 |
ADDRESS_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Address Sequence Number
|
| 11 |
GRP_AP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Control Group ID
|
| 12 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
|
| 13 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 14 |
VCHR_TTL_LINES |
Number(5,0) |
INTEGER NOT NULL |
Lines Entered
|
| 15 |
CLOSE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Close Status Indicator
C=Closed
O=Open
Default Value: O
|
| 16 |
ENTRY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Entry Status
C=Complete
D=Through batch defaults
E=Edited by Batch Voucher Module
L=Loaded by Batch VoucherModule
O=Open
P=Postable
R=Recycle
S=Schedule for Payment
X=Deleted
Default Value: O
|
| 17 |
ACCOUNTING_DT |
Date(10) |
DATE |
Accounting Date
|
| 18 |
POST_VOUCHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Voucher Now
D=Post Later
N=Do Not Post
P=Post Immediately
Default Value: D
|
| 19 |
POST_STATUS_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied
P=Posted
U=Unposted
Default Value: U
|
| 20 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 21 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
General Ledger Unit
|
| 22 |
PROCESS_MAN_CLOSE |
Character(1) |
VARCHAR2(1) NOT NULL |
N=No
P=Processed
Y=Yes
Default Value: N
|
| 23 |
DST_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Template
|
| 24 |
DUP_INVOICE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate Invoice Status
Y/N Table Edit
Default Value: N
|
| 25 |
VOUCHER_ID_RELATED |
Character(8) |
VARCHAR2(8) NOT NULL |
Related Voucher
|
| 26 |
GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Invoice Amount
|
| 27 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 28 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 29 |
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.
|
| 30 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 31 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 32 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency
|
| 33 |
DSCNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amount
|
| 34 |
DSCNT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Discount Amount
|
| 35 |
DSCNT_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Discount
|
| 36 |
USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Use tax amount.
|
| 37 |
USETAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base use tax amount.
|
| 38 |
USETAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Use tax code.
|
| 39 |
USETAX_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate use tax.
|
| 40 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 41 |
SALETX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Sales Tax Amount
|
| 42 |
SALETX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Sales Tax Code
|
| 43 |
SALETX_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Sales Tax
|
| 44 |
VAT_INV_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT invoice amount.
|
| 45 |
VAT_INV_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT invoice amount base.
|
| 46 |
VAT_NONINV_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT non invoice amount.
|
| 47 |
VAT_NONINV_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT non invoice amount base.
|
| 48 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 49 |
FREIGHT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Freight Amount
|
| 50 |
MISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 51 |
MISC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Misc. Amount
|
| 52 |
FRGHT_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Freight Charges
|
| 53 |
DUE_DT |
Date(10) |
DATE |
Due Date
|
| 54 |
DSCNT_DUE_DT |
Date(10) |
DATE |
Discount Due Date
|
| 55 |
PYMNT_CNT_MAX |
Number(5,0) |
INTEGER NOT NULL |
Maximum payment count.
Default Value: 1
|
| 56 |
PYMNT_CNT_TOTAL |
Number(5,0) |
INTEGER NOT NULL |
Total payment count.
Default Value: 1
|
| 57 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Terms ID
|
| 58 |
ENTERED_DT |
Date(10) |
DATE |
Entered on
|
| 59 |
LAST_UPDATE_DT |
Date(10) |
DATE |
Last Updated
|
| 60 |
TIME_EDIT |
Time(15) |
TIMESTAMP |
Cumulative Edit Time
|
| 61 |
VCHR_TEMPLATE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Template ID
|
| 62 |
VCHR_TMPLTE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 63 |
WTHD_ADJUST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Withholding adjustments.
Y/N Table Edit
Default Value: N
|
| 64 |
WTHD_FISCAL_YR |
Character(4) |
VARCHAR2(4) NOT NULL |
Withholding Year
|
| 65 |
POST_STATUS_WTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Withholding Post Status
N=Not Postable
P=Posted
U=Unposted
Default Value: U
|
| 66 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
Y/N Table Edit
Default Value: N
|
| 67 |
VAT_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT basis amount.
|
| 68 |
VAT_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT basis amount in base current.
|
| 69 |
VAT_CALC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT calculated amount.
|
| 70 |
VAT_ENTRD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered VAT amount.
|
| 71 |
VAT_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT recovery amount.
|
| 72 |
VAT_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT recovery amount base.
|
| 73 |
MATCH_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Action
E=ERS Match
N=No Matching
Y=Standard Match
Default Value: N
|
| 74 |
MATCH_STATUS_VCHR |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Status
E=Match Exceptions Exist
I=Match in Progress
M=Matched
N=Not Applicable
O=Manually Overridden
R=Rejected
T=To be Matched
Default Value: N
|
| 75 |
BCM_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check
N=Not Budget Checked
V=Valid Budget Check
Default Value: N
|
| 76 |
BCM_TRAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Transaction Type
AR=Accounts Receivable Item
EN=Encumbrance
EX=Expended
JU=Journal Unpost
JV=Journal Voucher
PM=AR Payment (Reference Item)
PN=AR Payment (No Reference Item)
PO=Purchase Order
PR=Pre Encumbrance
RQ=Requisition
Default Value: EX
|
| 77 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
|
| 78 |
MERCH_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Merchandise Amount
|
| 79 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In Process
Y/N Table Edit
Default Value: N
|
| 80 |
MANUAL_CLOSE_DT |
Date(10) |
DATE |
Manual Close Date
|
| 81 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract ID
|
| 82 |
REMIT_ADDR_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Remitting Location
|
| 83 |
CUR_RT_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Exchange Rate Source
T=Use Exchange Rate Tables
U=User Specified
Default Value: T
|
| 84 |
DSCNT_AMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount Amount Control
T=Controlled by Payment Terms
U=User Specified
Default Value: T
|
| 85 |
DUE_DT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Due Date Control
T=Controlled by Terms
U=User Specified
Default Value: T
|
| 86 |
VCHR_APPRVL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Approval Flag
D=Default from Higher Level
P=Pre-Approved
S=Specify at this Level
Default Value: P
|
| 87 |
BUSPROCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
|
| 88 |
APPR_RULE_SET |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule Set
|
| 89 |
APPR_CHECK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Check Flag
Y/N Table Edit
Default Value: N
|
| 90 |
APPR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending
Default Value: P
|
| 91 |
APPR_INSTANCE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Unique number for each runtime occurrence of a virtual approver process
|
| 92 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Operator to Update
|
| 93 |
VAT_DCLRTN_POINT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT declaration point.
D=Delivery
I=At Invoice Time
P=At Payment Time
|
| 94 |
VAT_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT calculation type.
E=Exclusive
I=Inclusive
N=Not Applicable
|
| 95 |
VAT_ENTITY |
Character(20) |
VARCHAR2(20) NOT NULL |
VAT reporting entity.
|
| 96 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Transaction Type
|
| 97 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
VAT code.
|
| 98 |
VAT_RCRD_INPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT record input.
Y/N Table Edit
Default Value: N
|
| 99 |
VAT_RCRD_OUTPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT record output.
Y/N Table Edit
Default Value: N
|
| 100 |
VAT_RECOVERY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT recovery percent.
|
| 101 |
VAT_CALC_GROSS_NET |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT calculate at gross or net.
G=Calculate at Gross
N=Calculate at Net
|
| 102 |
VAT_RECALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT recalculation at payment.
|
| 103 |
VAT_CALC_FRGHT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT include freight.
|
| 104 |
VAT_NRCVR_PRO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate non recoverable VAT.
|
| 105 |
VAT_NRCVR_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT non recoverable amount.
|
| 106 |
VAT_NRCVR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT non recoverable amount.
|
| 107 |
VAT_CALC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT calculated amount base current.
|
| 108 |
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)
|
| 109 |
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.
|
| 110 |
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
|
| 111 |
VAT_RGSTRN_SELLER |
Character(12) |
VARCHAR2(12) NOT NULL |
Seller's VAT registration.
|
| 112 |
MISC_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Miscellaneous Charge
Y/N Table Edit
Default Value: N
|
| 113 |
COUNTRY_VAT_BILLFR |
Character(3) |
VARCHAR2(3) NOT NULL |
Seller's VAT Rgstrn Country
|
| 114 |
COUNTRY_VAT_BILLTO |
Character(3) |
VARCHAR2(3) NOT NULL |
Buyer's VAT Rgstrn Country
|
| 115 |
COUNTRY_SHIP_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
Ship to Country
|
| 116 |
COUNTRY_VAT_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Reporting Country
|
| 117 |
VAT_DCMNT_ID |
Number(8,0) |
INTEGER NOT NULL |
VAT document id.
|
| 118 |
VAT_DCMNT_LN_MAX |
Number(5,0) |
INTEGER NOT NULL |
VAT document maximum line count.
|
| 119 |
SALETX_CALC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Calculated Sales Tax Amount
|
| 120 |
SALETX_CLC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Calculated Sales Tax Base Amt
|
| 121 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Document Type
L=Letter
N=Notice
O=Other
Q=Request
R=Report
|
| 122 |
DOC_SEQ_DATE |
Date(10) |
DATE |
Document Sequence Date
|
| 123 |
DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Document Sequence Number
|
| 124 |
DOC_SEQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Sequencing Status
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date Blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
|
| 125 |
VOUCHER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Type
A=Adjustment Voucher
B=Batch Edit Voucher
C=Recurring Voucher
E=ERS Voucher
J=Journal Voucher
P=Prepaid Voucher
R=Regular Voucher
T=Third Party Voucher
V=VAT Register Voucher
X=Template Voucher
|
| 126 |
VNDR_TMPLTE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Vendor Template Flag
|
| 127 |
VAT_TREATMENT_PUR |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Treatment Pur
DOM=Domestic VAT
EUA=Intra-EU Acquisitiom
IMP=Import
OOS=Outside the Scope of VAT
|
| 128 |
VAT_EXCPTN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT exception type.
N=None
S=Suspended
X=Exonerated
|
| 129 |
VAT_EXCPTN_CERTIF |
Character(20) |
VARCHAR2(20) NOT NULL |
VAT certification id.
|
| 130 |
COUNTRY_SHIP_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
Ship From Country
|
| 131 |
VAT_USE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Use Type
|
| 132 |
VAT_REBATE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT rebate amount.
|
| 133 |
VAT_REBATE_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT rebate amount base.
|
| 134 |
IST_TXN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Transaction Flag
|
| 135 |
LC_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Letter of Credit ID
|
| 136 |
REVALUE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Revalue Flag
|
| 137 |
BUDGET_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check
N=Not Budget Checked
V=Valid Budget Check
Default Value: V
|
| 138 |
BUDGET_MISC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Header Status
V=Valid
Default Value: V
|
| 139 |
KK_TRAN_OVER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Transaction
|
| 140 |
KK_TRAN_OVER_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Override Oper
|
| 141 |
KK_TRAN_OVER_DTTM |
DateTime(26) |
TIMESTAMP |
Override Date
|
| 142 |
PREPAID_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Prepayment Reference
|
| 143 |
PREPAID_AUTO_APPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically Apply Prepayment
Y/N Table Edit
Default Value: Y
|
| 144 |
SBI_DOC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Self Billing Invoice Options
G=Group Vouchers by Vendor
I=Individual SBI
P=Packing Slip
Default Value: G
|
| 145 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 146 |
RECV_ONLY_MTCH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Only Match
Y/N Table Edit
Default Value: N
|
| 147 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 148 |
ERS_TAX_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ERS Tax Type
B=Buyers Sales Tax
G=GST
N=None
U=Use Tax
V=Value Added Tax
|
| 149 |
ERS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ERS Type
N=Not Applicable
P=PO Receipt
R=Non PO Receipt
|
| 150 |
INV_RECPT_DT |
Date(10) |
DATE |
Invoice Receipt Date
|
| 151 |
PACKSLIP_NO |
Character(22) |
VARCHAR2(22) NOT NULL |
Packing Slip Number
|
| 152 |
RECEIPT_DT |
Date(10) |
DATE |
Received Date
|
| 153 |
SHIP_DATE |
Date(10) |
DATE |
Item Shipping Date
|
| 154 |
PAY_TRM_BSE_DT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Terms Basis Date Type
A=Accounting Date
C=Constructive Doc Receipt Date
I=Invoice Date
R=Receipt Date
S=Ship Date
U=User Specified Date
|
| 155 |
TERMS_BASIS_DT |
Date(10) |
DATE |
Payment Terms Basis Date
|
| 156 |
UNMTCH_PAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Unmatched Voucher
Y/N Table Edit
Default Value: N
|
| 157 |
UNMTCH_PAY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Unmatched Pay Status
N=Not Applicable
P=Paid
U=Unpaid
Default Value: N
|
| 158 |
VCHR_SRC |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Source
CNTR=Contracts
CONS=Consigned Inventory
EDI=EDI
MADJ=Match Adjustment
NERS=Non PO Evaluated Receipt
ONL=On Line
PAYR=Payroll Interface
PERS=PO Evaluated Receipts
QUCK=Quick Invoice
RTV=Return To Vendor
TADJ=Tax Adjustment
|
| 159 |
VCHR_SYSGEN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
System Generated
Y/N Table Edit
Default Value: N
|
| 160 |
MEMO_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Memo Amount
|
| 161 |
MEMO_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Memo Amt Base
|
| 162 |
PAY_AMT |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
An indicator used in Benefits Billing to identify amounts that have been, or are to be, paid (as opposed to a charge).
|
| 163 |
PAY_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment amount - base current.
|
| 164 |
SBI_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
SBI Applicable
Y/N Table Edit
Default Value: N
|
| 165 |
SBI_IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
SBI In Process
Y/N Table Edit
Default Value: N
|
| 166 |
SBI_NUM |
Character(40) |
VARCHAR2(40) NOT NULL |
Self-Billed Invoice ID Number
|
| 167 |
SBI_PROCESS_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 168 |
DELETE_DT |
Date(10) |
DATE |
Deletion Date
|
| 169 |
CURRENCY_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
Reporting Currency
|
| 170 |
VAT_RPTG_CURR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Amounts for reporting currency.
|
| 171 |
VAT_OVR_RPTG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT reporting amount overridden.
|
| 172 |
RATE_MULT_VAT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 173 |
RATE_DIV_VAT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 174 |
VAT_INV_AMT_RPTG |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT amount in reporting currency.
|
| 175 |
VAT_TRANS_AMT_RPTG |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT transaction amount reporting.
|
| 176 |
VAT_DCLRTN_DT |
Date(10) |
DATE |
VAT declaration date.
|
| 177 |
VAT_DCLRTN_DT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT declaration date source.
A=Delivery Date - Ext Process
D=Delivery Date - Txn Entry
I=Invoice Date
M=Manual Entry
N=Not Applicable
|
| 178 |
VAT_CALC_MISC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT include miscellaneous.
|
| 179 |
LC_EXTRCT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Landed Cost Extract Status
Default Value: N
|
| 180 |
EIN_FEDERAL |
Character(9) |
VARCHAR2(9) NOT NULL |
EIN Federal
|
| 181 |
EIN_STATE_LOCAL |
Character(20) |
VARCHAR2(20) NOT NULL |
EIN State Local
|
| 182 |
VAT_ADVPAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT on advance payments.
|
| 183 |
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
|
| 184 |
VAT_TRANS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT transaction amount.
|
| 185 |
VAT_TRANS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT transaction amount base currency.
|
| 186 |
TAX_PYMNT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Tax payment type.
|
| 187 |
TAX_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
Tax group.
|
| 188 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|