PeopleSoft 9 Asset Management |
Table Name | VOUCHER |
Table Description |
VOUCHER |
Columns |
Name | Datatype | Is PK | Is FK |
BUSINESS_UNIT | char(5) | Yes | No |
VOUCHER_ID | char(8) | Yes | No |
VOUCHER_STYLE | char(4) | No | No |
INVOICE_ID | char(30) | No | No |
ERS_INV_SEQ | smallint | No | No |
INVOICE_DT | PSDATE | No | No |
VENDOR_SETID | char(5) | No | No |
VENDOR_ID | char(10) | No | No |
VNDR_LOC | char(10) | No | No |
ADDRESS_SEQ_NUM | INT | No | No |
GRP_AP_ID | char(10) | No | No |
ORIGIN | char(3) | No | No |
OPRID | char(30) | No | No |
VCHR_TTL_LINES | int | No | No |
CLOSE_STATUS | char(1) | No | No |
ENTRY_STATUS | char(1) | No | No |
ACCOUNTING_DT | PSDATE | No | No |
POST_VOUCHER | char(1) | No | No |
POST_STATUS_AP | char(1) | No | No |
PROCESS_INSTANCE | decimal(10) | No | No |
BUSINESS_UNIT_GL | char(5) | No | No |
PROCESS_MAN_CLOSE | char(1) | No | No |
DST_CNTRL_ID | char(10) | No | No |
DUP_INVOICE_STATUS | char(1) | No | No |
VOUCHER_ID_RELATED | char(8) | No | No |
GROSS_AMT | decimal(26,3) | No | No |
GROSS_AMT_BSE | decimal(26,3) | No | No |
TXN_CURRENCY_CD | char(3) | No | Yes |
RT_TYPE | char(5) | No | No |
RATE_MULT | decimal(15,8) | No | No |
RATE_DIV | decimal(15,8) | No | No |
BASE_CURRENCY | char(3) | No | No |
DSCNT_AMT | decimal(26,3) | No | No |
DSCNT_AMT_BSE | decimal(26,3) | No | No |
DSCNT_PRORATE_FLG | char(1) | No | No |
TAX_EXEMPT | char(1) | No | No |
USETAX_AMT | decimal(26,3) | No | No |
USETAX_AMT_BSE | decimal(26,3) | No | No |
USETAX_PRORATE_FLG | char(1) | No | No |
SALETX_AMT | decimal(26,3) | No | No |
SALETX_AMT_BSE | decimal(26,3) | No | No |
SALETX_PRORATE_FLG | char(1) | No | No |
VAT_INV_AMT | decimal(26,3) | No | No |
VAT_INV_AMT_BSE | decimal(26,3) | No | No |
VAT_NONINV_AMT | decimal(26,3) | No | No |
VAT_NONINV_AMT_BSE | decimal(26,3) | No | No |
FREIGHT_AMT | decimal(26,3) | No | No |
FREIGHT_AMT_BSE | decimal(26,3) | No | No |
MISC_AMT | decimal(26,3) | No | No |
MISC_AMT_BSE | decimal(26,3) | No | No |
FRGHT_PRORATE_FLG | char(1) | No | No |
DUE_DT | PSDATE | No | No |
DSCNT_DUE_DT | PSDATE | No | No |
PYMNT_CNT_MAX | int | No | No |
PYMNT_CNT_TOTAL | int | No | No |
PYMNT_TERMS_CD | char(5) | No | No |
ENTERED_DT | PSDATE | No | No |
LAST_UPDATE_DT | PSDATE | No | No |
TIME_EDIT | PSTIME | No | No |
VCHR_TEMPLATE_ID | char(10) | No | No |
VCHR_TMPLTE_DESCR | char(30) | No | No |
WTHD_ADJUST_FLG | char(1) | No | No |
WTHD_FISCAL_YR | smallint | No | No |
POST_STATUS_WTHD | char(1) | No | No |
ERROR_FLAG | char(1) | No | No |
VAT_BASIS_AMT | decimal(26,3) | No | No |
VAT_BASIS_AMT_BSE | decimal(26,3) | No | No |
VAT_CALC_AMT | decimal(26,3) | No | No |
VAT_ENTRD_AMT | decimal(26,3) | No | No |
VAT_RCVRY_AMT | decimal(26,3) | No | No |
VAT_RCVRY_AMT_BSE | decimal(26,3) | No | No |
MATCH_ACTION | char(1) | No | No |
MATCH_STATUS_VCHR | char(1) | No | No |
BCM_HDR_STATUS | char(1) | No | No |
BCM_TRAN_TYPE | char(2) | No | No |
MERCHANDISE_AMT | decimal(26,3) | No | No |
MERCH_AMT_BSE | decimal(26,3) | No | No |
IN_PROCESS_FLG | char(1) | No | No |
MANUAL_CLOSE_DT | PSDATE | No | No |
CNTRCT_ID | char(25) | No | No |
REMIT_ADDR_SEQ_NUM | INT | No | No |
CUR_RT_SOURCE | char(1) | No | No |
DSCNT_AMT_FLG | char(1) | No | No |
DUE_DT_FLG | char(1) | No | No |
VCHR_APPRVL_FLG | char(1) | No | No |
BUSPROCNAME | char(30) | No | No |
APPR_RULE_SET | char(30) | No | No |
APPR_CHECK_FLG | char(1) | No | No |
APPR_STATUS | char(1) | No | No |
APPR_INSTANCE | int | No | No |
OPRID_LAST_UPDT | char(30) | No | No |
VAT_DCLRTN_POINT | char(1) | No | No |
VAT_CALC_TYPE | char(1) | No | No |
VAT_ENTITY | char(20) | No | No |
VAT_RECOVERY_PCT | decimal(5,2) | No | No |
VAT_CALC_GROSS_NET | char(1) | No | No |
VAT_RECALC_FLG | char(1) | No | No |
VAT_CALC_FRGHT_FLG | char(1) | No | No |
VAT_NRCVR_PRO_FLG | char(1) | No | No |
VAT_NRCVR_AMT_BSE | decimal(26,3) | No | No |
VAT_NRCVR_AMT | decimal(26,3) | No | No |
VAT_CALC_AMT_BSE | decimal(26,3) | No | No |
ECTRANSID | char(15) | No | No |
ECQUEUEINSTANCE | int | No | No |
ECTRANSINOUTSW | char(1) | No | No |
VAT_RGSTRN_SELLER | char(12) | No | No |
MISC_PRORATE_FLG | char(1) | No | No |
COUNTRY_VAT_BILLFR | char(3) | No | No |
COUNTRY_VAT_BILLTO | char(3) | No | No |
COUNTRY_SHIP_TO | char(3) | No | No |
COUNTRY_VAT_RPTG | char(3) | No | No |
VAT_DCMNT_ID | int | No | No |
SALETX_CALC_AMT | decimal(26,3) | No | No |
SALETX_CLC_AMT_BSE | decimal(26,3) | No | No |
DOC_TYPE | char(8) | No | No |
DOC_SEQ_DATE | PSDATE | No | No |
DOC_SEQ_NBR | char(12) | No | No |
DOC_SEQ_STATUS | char(1) | No | No |
VOUCHER_TYPE | char(1) | No | No |
VNDR_TMPLTE_FLG | char(1) | No | No |
VAT_EXCPTN_TYPE | char(1) | No | No |
VAT_EXCPTN_CERTIF | char(20) | No | No |
COUNTRY_SHIP_FROM | char(3) | No | No |
VAT_REBATE_AMT | decimal(26,3) | No | No |
VAT_REBATE_AMT_BSE | decimal(26,3) | No | No |
LC_ID | char(12) | No | No |
REVALUE_FLAG | char(1) | No | No |
BUDGET_HDR_STATUS | char(1) | No | No |
BUDGET_MISC_STATUS | char(1) | No | No |
KK_TRAN_OVER_FLAG | char(1) | No | No |
KK_TRAN_OVER_OPRID | char(30) | No | No |
KK_TRAN_OVER_DTTM | PSDATETIME | No | No |
PREPAID_REF | char(10) | No | No |
PREPAID_AUTO_APPLY | char(1) | No | No |
SBI_DOC_OPT | char(1) | No | No |
BUSINESS_UNIT_PO | char(5) | No | No |
RECV_ONLY_MTCH_FLG | char(1) | No | No |
PO_ID | char(10) | No | No |
ERS_TAX_TYPE | char(1) | No | No |
ERS_TYPE | char(1) | No | No |
INV_RECPT_DT | PSDATE | No | No |
PACKSLIP_NO | char(22) | No | No |
RECEIPT_DT | PSDATE | No | No |
SHIP_DATE | PSDATE | No | No |
PAY_TRM_BSE_DT_OPT | char(1) | No | No |
TERMS_BASIS_DT | PSDATE | No | No |
UNMTCH_PAY_FLG | char(1) | No | No |
UNMTCH_PAY_STATUS | char(1) | No | No |
VCHR_SRC | char(4) | No | No |
VCHR_SYSGEN_FLG | char(1) | No | No |
MEMO_AMT | decimal(26,3) | No | No |
MEMO_AMT_BSE | decimal(26,3) | No | No |
PAY_AMT | decimal(26,3) | No | No |
PAY_AMT_BASE | decimal(26,3) | No | No |
SBI_FLG | char(1) | No | No |
SBI_IN_PROCESS_FLG | char(1) | No | No |
SBI_NUM | char(40) | No | No |
SBI_PROCESS_ID | decimal(10) | No | No |
DELETE_DT | PSDATE | No | No |
CURRENCY_RPTG | char(3) | No | No |
VAT_RPTG_CURR_FLG | char(1) | No | No |
RATE_MULT_VAT | decimal(15,8) | No | No |
RATE_DIV_VAT | decimal(15,8) | No | No |
VAT_INV_AMT_RPTG | decimal(26,3) | No | No |
VAT_TRANS_AMT_RPTG | decimal(26,3) | No | No |
VAT_DCLRTN_DT | PSDATE | No | No |
VAT_DCLRTN_DT_SRC | char(1) | No | No |
VAT_CALC_MISC_FLG | char(1) | No | No |
LC_EXTRCT_STATUS | char(1) | No | No |
EIN_FEDERAL | char(9) | No | No |
EIN_STATE_LOCAL | char(20) | No | No |
TAX_GRP | char(4) | No | No |
TAX_PYMNT_TYPE | char(5) | No | No |
VAT_ADVPAY_FLG | char(1) | No | No |
VAT_ROUND_RULE | char(1) | No | No |
VAT_TRANS_AMT | decimal(26,3) | No | No |
VAT_TRANS_AMT_BSE | decimal(26,3) | No | No |
WTHD_PREPAY_OPT | char(1) | No | No |
VAT_CF_ANLSYS_TYPE | char(1) | No | No |
VAT_NRCVR_CHRG_CD | char(10) | No | No |
VAT_RPTG_CURR_CTRL | char(1) | No | No |
IMAGE_REF_ID | char(12) | No | No |
IMAGE_DATE | PSDATE | No | No |
PAY_SCHEDULE_TYPE | char(3) | No | No |
VCHR_POADJ_OPT | char(1) | No | No |
VCHR_MTCH_ADJ_OPT | char(1) | No | No |
INTERUNIT_ERR_FLG | char(1) | No | No |
VCHR_BAL_ERR_FLG | char(1) | No | No |
INSPECT_DT | PSDATE | No | No |
DATE_CALC_BASIS | char(1) | No | No |
BASIS_DATE | PSDATE | No | No |
PO_RECPT_DT | PSDATE | No | No |
MTCH_LEVEL_STATUS | char(1) | No | No |
MTCH_LEVEL_OPT | char(1) | No | No |
MATCH_OVERRIDE | char(1) | No | No |
INVOICE_RCPT_DT | PSDATE | No | No |
USER_VCHR_CHAR1 | char(1) | No | No |
USER_VCHR_CHAR2 | char(1) | No | No |
USER_VCHR_DEC | decimal(26,3) | No | No |
USER_VCHR_DATE | PSDATE | No | No |
USER_VCHR_NUM1 | smallint | No | No |
DESCR254_MIXED | char(254) | No | No |
DOC_TOL_HDR_STATUS | char(1) | No | No |
USER_HDR_CHAR1 | char(1) | No | No |
VNDR_AFFILIATE | char(5) | No | No |
RTM_LOCK_FLG | char(1) | No | No |
VCHR_LINE_APPR | char(1) | No | No |
EXD_TAX_AMT | decimal(26,3) | No | No |
EXD_TAX_AMT_BSE | decimal(26,3) | No | No |
STX_TAX_AMT | decimal(26,3) | No | No |
STX_TAX_AMT_BSE | decimal(26,3) | No | No |
CSD_TAX_AMT | decimal(26,3) | No | No |
CSD_TAX_AMT_BSE | decimal(26,3) | No | No |
COMBO_ERROR_FLG | char(1) | No | No |
PHYSICAL_NATURE | char(1) | No | No |
VAT_TREATMENT_GRP | char(4) | No | No |
COUNTRY_LOC_BUYER | char(3) | No | No |
STATE_LOC_BUYER | char(6) | No | No |
COUNTRY_LOC_SELLER | char(3) | No | No |
STATE_LOC_SELLER | char(6) | No | No |
VAT_SVC_SUPPLY_FLG | char(1) | No | No |
VAT_SERVICE_TYPE | char(1) | No | No |
COUNTRY_VAT_PERFRM | char(3) | No | No |
STATE_VAT_PERFRM | char(6) | No | No |
COUNTRY_VAT_SUPPLY | char(3) | No | No |
STATE_VAT_SUPPLY | char(6) | No | No |
STATE_SHIP_FROM | char(6) | No | No |
STATE_SHIP_TO | char(6) | No | No |
STATE_VAT_DEFAULT | char(6) | No | No |
VAT_RPT_CNTRY_SRC | char(1) | No | No |
VAT_DFLT_DONE_FLG | char(1) | No | No |
FED_PROJDT_EDT_FLG | char(1) | No | No |
PERFORM_START_DT | PSDATE | No | No |
PERFORM_END_DT | PSDATE | No | No |
PO_ROLLED_FLG | char(1) | No | No |
LS_KEY | decimal(15) | No | No |
MATCH_DUE_DT | PSDATE | No | No |
AP_MATCH_TYPE | char(1) | No | No |
DBMEMO_DISP_METHOD | char(3) | No | No |
DBMEMO_DISP_STATUS | char(1) | No | No |
DBMEMO_DEST | char(70) | No | No |
MATCHED_DT | PSDATE | No | No |
MATCH_CNTRL_ID | char(10) | No | No |
Index |
Name | Type | Unique | Member |
PS_VOUCHER | PK | Yes |
![]() |
PS0VOUCHER | IE1 | No |
![]() |
PS1VOUCHER | IE2 | No |
![]() |
PSAVOUCHER | IE3 | No |
![]() |
PSBVOUCHER | IE4 | No |
![]() |
PSCVOUCHER | IE5 | No |
![]() |
PSDVOUCHER | IE6 | No |
![]() |
PSEVOUCHER | IE7 | No |
![]() |
Member(s) of "PS_VOUCHER" Index |
BUSINESS_UNIT |
VOUCHER_ID |
Member(s) of "PS0VOUCHER" Index |
INVOICE_ID |
BUSINESS_UNIT |
VOUCHER_ID |
Member(s) of "PS1VOUCHER" Index |
VENDOR_ID |
BUSINESS_UNIT |
VOUCHER_ID |
Member(s) of "PSAVOUCHER" Index |
BUSINESS_UNIT |
GRP_AP_ID |
GROSS_AMT |
Member(s) of "PSBVOUCHER" Index |
PROCESS_INSTANCE |
Member(s) of "PSCVOUCHER" Index |
BUSINESS_UNIT |
ENTRY_STATUS |
APPR_STATUS |
MATCH_STATUS_VCHR |
BUDGET_HDR_STATUS |
VOUCHER_ID |
Member(s) of "PSDVOUCHER" Index |
VENDOR_SETID |
VENDOR_ID |
BUSINESS_UNIT |
VOUCHER_ID |
Member(s) of "PSEVOUCHER" Index |
VOUCHER_ID_RELATED |
BUSINESS_UNIT |
Published December 16, 2006 |