PeopleSoft 9 Account Payables |
Table Name | VOUCHER |
Table Description |
VOUCHER |
Columns |
Name | Datatype | Is PK | Is FK |
BUSINESS_UNIT | VARCHAR(5) | Yes | Yes |
VOUCHER_ID | VARCHAR(8) | Yes | No |
VOUCHER_STYLE | VARCHAR(4) | No | No |
INVOICE_ID | VARCHAR(30) | No | No |
ERS_INV_SEQ | SMALLINT | No | No |
INVOICE_DT | PSDATE | No | No |
VENDOR_SETID | VARCHAR(5) | No | No |
VENDOR_ID | VARCHAR(10) | No | No |
VNDR_LOC | VARCHAR(10) | No | No |
ADDRESS_SEQ_NUM | INT | No | No |
GRP_AP_ID | VARCHAR(10) | No | No |
ORIGIN | VARCHAR(3) | No | Yes |
OPRID | VARCHAR(30) | No | No |
VCHR_TTL_LINES | int | No | No |
CLOSE_STATUS | VARCHAR(1) | No | No |
ENTRY_STATUS | VARCHAR(1) | No | No |
ACCOUNTING_DT | PSDATE | No | No |
POST_VOUCHER | VARCHAR(1) | No | No |
POST_STATUS_AP | VARCHAR(1) | No | No |
PROCESS_INSTANCE | decimal(10) | No | No |
BUSINESS_UNIT_GL | VARCHAR(5) | No | No |
PROCESS_MAN_CLOSE | VARCHAR(1) | No | No |
DST_CNTRL_ID | VARCHAR(10) | No | No |
DUP_INVOICE_STATUS | VARCHAR(1) | No | No |
VOUCHER_ID_RELATED | VARCHAR(8) | No | No |
GROSS_AMT | decimal(26,3) | No | No |
GROSS_AMT_BSE | decimal(26,3) | No | No |
TXN_CURRENCY_CD | VARCHAR(3) | No | No |
RT_TYPE | VARCHAR(5) | No | No |
RATE_MULT | decimal(15,8) | No | No |
RATE_DIV | decimal(15,8) | No | No |
BASE_CURRENCY | VARCHAR(3) | No | No |
DSCNT_AMT | decimal(26,3) | No | No |
DSCNT_AMT_BSE | decimal(26,3) | No | No |
DSCNT_PRORATE_FLG | VARCHAR(1) | No | No |
TAX_EXEMPT | VARCHAR(1) | No | No |
USETAX_AMT | decimal(26,3) | No | No |
USETAX_AMT_BSE | decimal(26,3) | No | No |
USETAX_PRORATE_FLG | VARCHAR(1) | No | No |
SALETX_AMT | decimal(26,3) | No | No |
SALETX_AMT_BSE | decimal(26,3) | No | No |
SALETX_PRORATE_FLG | VARCHAR(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 | VARCHAR(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 | VARCHAR(5) | No | No |
ENTERED_DT | PSDATE | No | No |
LAST_UPDATE_DT | PSDATE | No | No |
TIME_EDIT | PSTIME | No | No |
VCHR_TEMPLATE_ID | VARCHAR(10) | No | No |
VCHR_TMPLTE_DESCR | VARCHAR(30) | No | No |
WTHD_ADJUST_FLG | VARCHAR(1) | No | No |
WTHD_FISCAL_YR | SMALLINT | No | No |
POST_STATUS_WTHD | VARCHAR(1) | No | No |
ERROR_FLAG | VARCHAR(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 | VARCHAR(1) | No | No |
MATCH_STATUS_VCHR | VARCHAR(1) | No | No |
BCM_HDR_STATUS | VARCHAR(1) | No | No |
BCM_TRAN_TYPE | VARCHAR(2) | No | No |
MERCHANDISE_AMT | decimal(26,3) | No | No |
MERCH_AMT_BSE | decimal(26,3) | No | No |
IN_PROCESS_FLG | VARCHAR(1) | No | No |
MANUAL_CLOSE_DT | PSDATE | No | No |
CNTRCT_ID | VARCHAR(25) | No | No |
REMIT_ADDR_SEQ_NUM | INT | No | No |
CUR_RT_SOURCE | VARCHAR(1) | No | No |
DSCNT_AMT_FLG | VARCHAR(1) | No | No |
DUE_DT_FLG | VARCHAR(1) | No | No |
VCHR_APPRVL_FLG | VARCHAR(1) | No | No |
BUSPROCNAME | VARCHAR(30) | No | No |
APPR_RULE_SET | VARCHAR(30) | No | No |
APPR_CHECK_FLG | VARCHAR(1) | No | No |
APPR_STATUS | VARCHAR(1) | No | No |
APPR_INSTANCE | int | No | No |
OPRID_LAST_UPDT | VARCHAR(30) | No | No |
VAT_DCLRTN_POINT | VARCHAR(1) | No | No |
VAT_CALC_TYPE | VARCHAR(1) | No | No |
VAT_ENTITY | VARCHAR(20) | No | No |
VAT_RECOVERY_PCT | decimal(5,2) | No | No |
VAT_CALC_GROSS_NET | VARCHAR(1) | No | No |
VAT_RECALC_FLG | VARCHAR(1) | No | No |
VAT_CALC_FRGHT_FLG | VARCHAR(1) | No | No |
VAT_NRCVR_PRO_FLG | VARCHAR(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 | VARCHAR(15) | No | No |
ECQUEUEINSTANCE | int | No | No |
ECTRANSINOUTSW | VARCHAR(1) | No | No |
VAT_RGSTRN_SELLER | VARCHAR(12) | No | No |
MISC_PRORATE_FLG | VARCHAR(1) | No | No |
COUNTRY_VAT_BILLFR | VARCHAR(3) | No | No |
COUNTRY_VAT_BILLTO | VARCHAR(3) | No | No |
COUNTRY_SHIP_TO | VARCHAR(3) | No | No |
COUNTRY_VAT_RPTG | VARCHAR(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 | VARCHAR(8) | No | No |
DOC_SEQ_DATE | PSDATE | No | No |
DOC_SEQ_NBR | VARCHAR(12) | No | No |
DOC_SEQ_STATUS | VARCHAR(1) | No | No |
VOUCHER_TYPE | VARCHAR(1) | No | No |
VNDR_TMPLTE_FLG | VARCHAR(1) | No | No |
VAT_EXCPTN_TYPE | VARCHAR(1) | No | No |
VAT_EXCPTN_CERTIF | VARCHAR(20) | No | No |
COUNTRY_SHIP_FROM | VARCHAR(3) | No | No |
VAT_REBATE_AMT | decimal(26,3) | No | No |
VAT_REBATE_AMT_BSE | decimal(26,3) | No | No |
LC_ID | VARCHAR(12) | No | No |
REVALUE_FLAG | VARCHAR(1) | No | No |
BUDGET_HDR_STATUS | VARCHAR(1) | No | No |
BUDGET_MISC_STATUS | VARCHAR(1) | No | No |
KK_TRAN_OVER_FLAG | VARCHAR(1) | No | No |
KK_TRAN_OVER_OPRID | VARCHAR(30) | No | No |
KK_TRAN_OVER_DTTM | PSDATETIME | No | No |
PREPAID_REF | VARCHAR(10) | No | No |
PREPAID_AUTO_APPLY | VARCHAR(1) | No | No |
SBI_DOC_OPT | VARCHAR(1) | No | No |
BUSINESS_UNIT_PO | VARCHAR(5) | No | No |
RECV_ONLY_MTCH_FLG | VARCHAR(1) | No | No |
PO_ID | VARCHAR(10) | No | No |
ERS_TAX_TYPE | VARCHAR(1) | No | No |
ERS_TYPE | VARCHAR(1) | No | No |
INV_RECPT_DT | PSDATE | No | No |
PACKSLIP_NO | VARCHAR(22) | No | No |
RECEIPT_DT | PSDATE | No | No |
SHIP_DATE | PSDATE | No | No |
PAY_TRM_BSE_DT_OPT | VARCHAR(1) | No | No |
TERMS_BASIS_DT | PSDATE | No | No |
UNMTCH_PAY_FLG | VARCHAR(1) | No | No |
UNMTCH_PAY_STATUS | VARCHAR(1) | No | No |
VCHR_SRC | VARCHAR(4) | No | No |
VCHR_SYSGEN_FLG | VARCHAR(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 | VARCHAR(1) | No | No |
SBI_IN_PROCESS_FLG | VARCHAR(1) | No | No |
SBI_NUM | VARCHAR(40) | No | No |
SBI_PROCESS_ID | decimal(10) | No | No |
DELETE_DT | PSDATE | No | No |
CURRENCY_RPTG | VARCHAR(3) | No | No |
VAT_RPTG_CURR_FLG | VARCHAR(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 | VARCHAR(1) | No | No |
VAT_CALC_MISC_FLG | VARCHAR(1) | No | No |
LC_EXTRCT_STATUS | VARCHAR(1) | No | No |
EIN_FEDERAL | VARCHAR(9) | No | No |
EIN_STATE_LOCAL | VARCHAR(20) | No | No |
TAX_GRP | VARCHAR(4) | No | No |
TAX_PYMNT_TYPE | VARCHAR(5) | No | No |
VAT_ADVPAY_FLG | VARCHAR(1) | No | No |
VAT_ROUND_RULE | VARCHAR(1) | No | No |
VAT_TRANS_AMT | decimal(26,3) | No | No |
VAT_TRANS_AMT_BSE | decimal(26,3) | No | No |
WTHD_PREPAY_OPT | VARCHAR(1) | No | No |
VAT_CF_ANLSYS_TYPE | VARCHAR(1) | No | No |
VAT_NRCVR_CHRG_CD | VARCHAR(10) | No | No |
VAT_RPTG_CURR_CTRL | VARCHAR(1) | No | No |
IMAGE_REF_ID | VARCHAR(12) | No | No |
IMAGE_DATE | PSDATE | No | No |
PAY_SCHEDULE_TYPE | VARCHAR(3) | No | No |
VCHR_POADJ_OPT | VARCHAR(1) | No | No |
VCHR_MTCH_ADJ_OPT | VARCHAR(1) | No | No |
INTERUNIT_ERR_FLG | VARCHAR(1) | No | No |
VCHR_BAL_ERR_FLG | VARCHAR(1) | No | No |
INSPECT_DT | PSDATE | No | No |
DATE_CALC_BASIS | VARCHAR(1) | No | No |
BASIS_DATE | PSDATE | No | No |
PO_RECPT_DT | PSDATE | No | No |
MTCH_LEVEL_STATUS | VARCHAR(1) | No | No |
MTCH_LEVEL_OPT | VARCHAR(1) | No | No |
MATCH_OVERRIDE | VARCHAR(1) | No | No |
INVOICE_RCPT_DT | PSDATE | No | No |
USER_VCHR_CHAR1 | VARCHAR(1) | No | No |
USER_VCHR_CHAR2 | VARCHAR(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 | VARCHAR(254) | No | No |
DOC_TOL_HDR_STATUS | VARCHAR(1) | No | No |
USER_HDR_CHAR1 | VARCHAR(1) | No | No |
VNDR_AFFILIATE | VARCHAR(5) | No | No |
RTM_LOCK_FLG | VARCHAR(1) | No | No |
VCHR_LINE_APPR | VARCHAR(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 | VARCHAR(1) | No | No |
PHYSICAL_NATURE | VARCHAR(1) | No | No |
VAT_TREATMENT_GRP | VARCHAR(4) | No | No |
COUNTRY_LOC_BUYER | VARCHAR(3) | No | No |
STATE_LOC_BUYER | VARCHAR(6) | No | No |
COUNTRY_LOC_SELLER | VARCHAR(3) | No | No |
STATE_LOC_SELLER | VARCHAR(6) | No | No |
VAT_SVC_SUPPLY_FLG | VARCHAR(1) | No | No |
VAT_SERVICE_TYPE | VARCHAR(1) | No | No |
COUNTRY_VAT_PERFRM | VARCHAR(3) | No | No |
STATE_VAT_PERFRM | VARCHAR(6) | No | No |
COUNTRY_VAT_SUPPLY | VARCHAR(3) | No | No |
STATE_VAT_SUPPLY | VARCHAR(6) | No | No |
STATE_SHIP_FROM | VARCHAR(6) | No | No |
STATE_SHIP_TO | VARCHAR(6) | No | No |
STATE_VAT_DEFAULT | VARCHAR(6) | No | No |
VAT_RPT_CNTRY_SRC | VARCHAR(1) | No | No |
VAT_DFLT_DONE_FLG | VARCHAR(1) | No | No |
FED_PROJDT_EDT_FLG | VARCHAR(1) | No | No |
PERFORM_START_DT | PSDATE | No | No |
PERFORM_END_DT | PSDATE | No | No |
PO_ROLLED_FLG | VARCHAR(1) | No | No |
LS_KEY | DECIMAL(15) | No | No |
MATCH_DUE_DT | datetime | No | No |
AP_MATCH_TYPE | VARCHAR(1) | No | No |
DBMEMO_DISP_METHOD | VARCHAR(3) | No | No |
DBMEMO_DISP_STATUS | VARCHAR(1) | No | No |
DBMEMO_DEST | VARCHAR(70) | No | No |
MATCHED_DT | datetime | No | No |
MATCH_CNTRL_ID | VARCHAR(10) | No | No |
Index |
Name | Type | Unique | Member |
PS_VOUCHER | PK | Yes |
![]() |
PS0VOUCHER | IE10 | No |
![]() |
PS1VOUCHER | IE11 | No |
![]() |
PSAVOUCHER | IE12 | No |
![]() |
PSBVOUCHER | IE4 | No |
![]() |
PSCVOUCHER | IE5 | No |
![]() |
PSDVOUCHER | IE6 | No |
![]() |
PSEVOUCHER | IE7 | No |
![]() |
PSFVOUCHER | IE8 | 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 |
Member(s) of "PSFVOUCHER" Index |
BUSINESS_UNIT |
ENTRY_STATUS |
POST_STATUS_AP |
IN_PROCESS_FLG |
Published June 06, 2007 |