PeopleSoft 9
Account Payables

Table Name VOUCHER_LINE

Table Description
VOUCHER_LINE
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
VOUCHER_LINE_NUM int Yes No
TOTAL_DISTRIBS int No No
MAX_DISTRIB_LINE int No No
BUSINESS_UNIT_PO VARCHAR(5) No No
PO_ID VARCHAR(10) No Yes
LINE_NBR int No Yes
SCHED_NBR SMALLINT No Yes
DESCR VARCHAR(30) No No
DESCR254_MIXED VARCHAR(254) No No
MERCHANDISE_AMT decimal(26,3) No No
MERCH_AMT_BSE decimal(26,3) No No
ITM_SETID VARCHAR(5) No No
INV_ITEM_ID VARCHAR(18) No Yes
QTY_VCHR decimal(15,4) No No
STATISTIC_AMOUNT decimal(15,2) No No
UNIT_OF_MEASURE VARCHAR(3) No Yes
UNIT_PRICE decimal(15,5) No No
FRGHT_PRORATE_FLG VARCHAR(1) No No
DSCNT_APPL_FLG VARCHAR(1) No No
ERROR_FLAG VARCHAR(1) No No
PROCESS_INSTANCE decimal(10) No No
WTHD_SW VARCHAR(1) No No
TAX_CD_VAT VARCHAR(8) No Yes
VAT_RECOVERY_PCT decimal(5,2) No No
FINAL_REF_IND VARCHAR(1) No No
BUSINESS_UNIT_RECV VARCHAR(5) No No
RECEIVER_ID VARCHAR(10) No Yes
RECV_LN_NBR int No Yes
RECV_SHIP_SEQ_NBR SMALLINT No Yes
MATCH_LINE_OPT VARCHAR(1) No No
DISTRIB_MTHD_FLG VARCHAR(1) No No
VCHR_AMT_FORCE_FLG VARCHAR(1) No No
AMT_ONLY_FLG VARCHAR(1) No No
TXN_CURRENCY_CD VARCHAR(3) No No
BASE_CURRENCY VARCHAR(3) No No
CURRENCY_CD VARCHAR(3) No No
VAT_TXN_TYPE_CD VARCHAR(4) No Yes
ECTRANSID VARCHAR(15) No No
ECQUEUEINSTANCE int No No
ECTRANSINOUTSW VARCHAR(1) No No
SHIPTO_ID VARCHAR(10) No Yes
SUT_BASE_ID VARCHAR(10) No No
TAX_CD_SUT VARCHAR(8) No Yes
ULTIMATE_USE_CD VARCHAR(8) No Yes
SUT_EXCPTN_TYPE VARCHAR(1) No No
SUT_EXCPTN_CERTIF VARCHAR(20) No No
SUT_APPLICABILITY VARCHAR(1) No No
WTHD_SETID VARCHAR(5) No No
WTHD_CD VARCHAR(5) No Yes
NATURE_OF_TXN1 VARCHAR(1) No No
NATURE_OF_TXN2 VARCHAR(1) No No
VAT_APPLICABILITY VARCHAR(1) No No
VAT_USE_ID VARCHAR(6) No Yes
VAT_ENTITY VARCHAR(20) No No
BUSINESS_UNIT_RTV VARCHAR(5) No No
RTV_ID VARCHAR(10) No No
RTV_LN_NBR int No No
FISCAL_REGIME VARCHAR(6) No No
GEO_CODE VARCHAR(11) No No
MATCH_LINE_STATUS VARCHAR(1) No No
CNTRCT_ID VARCHAR(25) No No
CNTRCT_LINE_NBR int No No
RELEASE_NBR int No No
BUS_UNIT_RELATED VARCHAR(5) No No
VOUCHER_ID_RELATED VARCHAR(8) No No
VENDOR_ID VARCHAR(10) No No
SPEEDCHART_KEY VARCHAR(10) No No
RECEIPT_DT PSDATE No No
INSPECT_DT PSDATE No No
VAT_LN_ENT_AMT decimal(26,3) No No
VAT_LN_ENT_AMT_BSE decimal(26,3) No No
VAT_MBASIS_AMT decimal(26,3) No No
VAT_MBASIS_AMT_BSE decimal(26,3) 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
VNDR_LOC VARCHAR(10) No No
USER_LINE_CHAR1 VARCHAR(1) No No
USER_SCHED_CHAR1 VARCHAR(1) No No
APPR_STATUS VARCHAR(1) No No
TAX_DSCNT_FLG VARCHAR(1) No No
TAX_FRGHT_FLG VARCHAR(1) No No
TAX_MISC_FLG VARCHAR(1) No No
TAX_VAT_FLG VARCHAR(1) No No
ORG_SETID VARCHAR(5) No No
ORG_CODE VARCHAR(6) No No
ORG_TAX_LOC_CD VARCHAR(10) No No
EXS_TAX_TXN_TYPE VARCHAR(4) No No
EXS_SERV_TAX_FLG VARCHAR(1) No No
EXD_APPL_FLG VARCHAR(1) No No
EXD_TAX_RATE_CD VARCHAR(10) No No
EXD_TPRTNR_CATG_CD VARCHAR(10) No No
EXD_ITM_CATG_CD VARCHAR(10) No No
EXD_TAX_ITEM_TYPE VARCHAR(4) No No
EXD_CHAPTER_ID VARCHAR(7) No No
EXD_UOM VARCHAR(3) No No
EXD_USE_AV_FLG VARCHAR(1) No No
EXD_ASSESS_VALUE decimal(26,3) No No
EXD_CONVERSION_RT decimal(15,8) No No
EXD_ASSESS_AMT decimal(26,3) No No
EXD_ASSESS_AMT_BSE decimal(26,3) No No
EXD_ASSESS_AMT_RPT decimal(26,3) No No
STX_APPL_FLG VARCHAR(1) No No
STX_TAX_RATE_CD VARCHAR(10) No No
STX_TPRTNR_CATG_CD VARCHAR(10) No No
STX_ITM_CATG_CD VARCHAR(10) No No
STX_TAX_AUTH_RATE VARCHAR(8) No No
STX_TAX_AUTH_RPT VARCHAR(8) No No
STX_FORM_CD VARCHAR(8) No No
CSD_APPL_FLG VARCHAR(1) No No
CSD_TAX_RATE_CD VARCHAR(10) No No
CSD_TPRTNR_CATG_CD VARCHAR(10) No No
CSD_ITM_CATG_CD VARCHAR(10) No No
CSD_BENEFIT_ID VARCHAR(10) No No
EXS_CURRENCY_RPTG VARCHAR(3) No No
RATE_MULT_EXS decimal(15,8) No No
RATE_DIV_EXS decimal(15,8) No No
EXD_TAX_AMT decimal(26,3) No No
EXD_TAX_AMT_BSE decimal(26,3) No No
EXD_TAX_AMT_RPT decimal(26,3) No No
EXD_BASIS_AMT decimal(26,3) No No
EXD_BASIS_AMT_BSE decimal(26,3) No No
EXD_BASIS_AMT_RPT decimal(26,3) No No
EXD_RCVRY_AMT decimal(26,3) No No
EXD_RCVRY_AMT_BSE decimal(26,3) No No
EXD_RCVRY_AMT_RPT decimal(26,3) No No
EXD_NRCVRY_AMT decimal(26,3) No No
EXD_NRCVRY_AMT_BSE decimal(26,3) No No
EXD_NRCVRY_AMT_RPT decimal(26,3) No No
STX_TAX_AMT decimal(26,3) No No
STX_TAX_AMT_BSE decimal(26,3) No No
STX_TAX_AMT_RPT decimal(26,3) No No
STX_BASIS_AMT decimal(26,3) No No
STX_BASIS_AMT_BSE decimal(26,3) No No
STX_BASIS_AMT_RPT decimal(26,3) No No
STX_RCVRY_AMT decimal(26,3) No No
STX_RCVRY_AMT_BSE decimal(26,3) No No
STX_RCVRY_AMT_RPT decimal(26,3) No No
STX_NRCVRY_AMT decimal(26,3) No No
STX_NRCVRY_AMT_BSE decimal(26,3) No No
STX_NRCVRY_AMT_RPT decimal(26,3) No No
CSD_TAX_AMT decimal(26,3) No No
CSD_TAX_AMT_BSE decimal(26,3) No No
CSD_TAX_AMT_RPT decimal(26,3) No No
CSD_BASIS_AMT decimal(26,3) No No
CSD_BASIS_AMT_BSE decimal(26,3) No No
CSD_BASIS_AMT_RPT decimal(26,3) No No
CSD_RCVRY_AMT decimal(26,3) No No
CSD_RCVRY_AMT_BSE decimal(26,3) No No
CSD_RCVRY_AMT_RPT decimal(26,3) No No
CSD_NRCVRY_AMT decimal(26,3) No No
CSD_NRCVRY_AMT_BSE decimal(26,3) No No
CSD_NRCVRY_AMT_RPT decimal(26,3) No No
CATEGORY_ID VARCHAR(5) No No
TAX_CD_SUT_PCT decimal(7,4) No No
FREIGHT_SUT_PCT decimal(7,4) No No
TITLE_PASSAGE VARCHAR(1) No No
TAX_TRANS_TYPE VARCHAR(1) No No
TAX_TRANS_SUB_TYPE VARCHAR(1) No No
TAX_JOB_NUM VARCHAR(10) No No
TAX_USER_AREA VARCHAR(25) No No
SALETX_AMT decimal(26,3) No No
USETAX_AMT decimal(26,3) No No
FREIGHT_SUT_AMT decimal(26,3) No No
FRGT_SUT_BASIS_AMT decimal(26,3) No No
MISC_SUT_BASIS_AMT decimal(26,3) No No
DSCN_SUT_BASIS_AMT decimal(26,3) No No
SUT_PRODUCT_CD VARCHAR(18) No No
SUT_FREIGHT_CD VARCHAR(18) No No
SUT_CALC_BASIS_AMT decimal(26,3) No No
SALETX_CALC_AMT decimal(26,3) No No
FREIGHT_TERMS VARCHAR(10) No No
SHIP_TYPE_ID VARCHAR(10) No No
REQUESTOR_ID VARCHAR(30) No No
VAT_TREATMENT VARCHAR(4) No No
VAT_RCRD_INPT_FLG VARCHAR(1) No No
VAT_RCRD_OUTPT_FLG VARCHAR(1) No No
IST_TXN_FLG VARCHAR(1) No No
PHYSICAL_NATURE VARCHAR(1) 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_DFLT_DONE_FLG VARCHAR(1) No No
FORM_DISTRIB_STAT VARCHAR(1) No No
VAT_RECEIPT VARCHAR(1) No No
VAT_RGSTRN_SELLER VARCHAR(12) No No
TRANS_DT PSDATE No No
CONVERSION_RATE DECIMAL(15,8) No No
Index
Name Type Unique Member
PS_VOUCHER_LINE PK Yes
PSAVOUCHER_LINE IE1 No
Member(s) of "PS_VOUCHER_LINE" Index
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM
Member(s) of "PSAVOUCHER_LINE" Index
BUSINESS_UNIT
VOUCHER_ID_RELATED

Published June 06, 2007