PeopleSoft 9.0
Cash Management

Table Name VOUCHER_LINE

Table Description
VOUCHER_LINE
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
VOUCHER_ID char(8) Yes Yes
VOUCHER_LINE_NUM int Yes No
TOTAL_DISTRIBS int No No
MAX_DISTRIB_LINE int No No
BUSINESS_UNIT_PO char(5) No No
PO_ID char(10) No No
LINE_NBR int No No
SCHED_NBR smallint No No
DESCR char(30) No No
DESCR254_MIXED char(254) No No
MERCHANDISE_AMT decimal(26,3) No No
MERCH_AMT_BSE decimal(26,3) No No
ITM_SETID char(5) No No
INV_ITEM_ID char(18) No No
QTY_VCHR decimal(15,4) No No
STATISTIC_AMOUNT decimal(15,2) No No
UNIT_OF_MEASURE char(3) No No
UNIT_PRICE decimal(15,5) No No
FRGHT_PRORATE_FLG char(1) No No
DSCNT_APPL_FLG char(1) No No
ERROR_FLAG char(1) No No
PROCESS_INSTANCE decimal(10) No No
WTHD_SW char(1) No No
TAX_CD_VAT char(8) No No
VAT_RECOVERY_PCT decimal(5,2) No No
FINAL_REF_IND char(1) No No
BUSINESS_UNIT_RECV char(5) No No
RECEIVER_ID char(10) No No
RECV_LN_NBR int No No
RECV_SHIP_SEQ_NBR smallint No No
MATCH_LINE_OPT char(1) No No
DISTRIB_MTHD_FLG char(1) No No
VCHR_AMT_FORCE_FLG char(1) No No
AMT_ONLY_FLG char(1) No No
TXN_CURRENCY_CD char(3) No No
BASE_CURRENCY char(3) No No
CURRENCY_CD char(3) No No
VAT_TXN_TYPE_CD char(4) No No
ECTRANSID char(15) No No
ECQUEUEINSTANCE int No No
ECTRANSINOUTSW char(1) No No
SHIPTO_ID char(10) No No
SUT_BASE_ID char(10) No No
TAX_CD_SUT char(8) No No
ULTIMATE_USE_CD char(8) No No
SUT_EXCPTN_TYPE char(1) No No
SUT_EXCPTN_CERTIF char(20) No No
SUT_APPLICABILITY char(1) No No
WTHD_SETID char(5) No No
WTHD_CD char(5) No No
NATURE_OF_TXN1 char(1) No No
NATURE_OF_TXN2 char(1) No No
VAT_APPLICABILITY char(1) No No
VAT_USE_ID char(6) No No
VAT_ENTITY char(20) No No
BUSINESS_UNIT_RTV char(5) No No
RTV_ID char(10) No No
RTV_LN_NBR int No No
FISCAL_REGIME char(2) No No
GEO_CODE char(11) No No
MATCH_LINE_STATUS char(1) No No
CNTRCT_ID char(25) No No
CNTRCT_LINE_NBR int No No
RELEASE_NBR int No No
BUS_UNIT_RELATED char(5) No No
VOUCHER_ID_RELATED char(8) No No
VENDOR_ID char(10) No No
SPEEDCHART_KEY char(10) No No
RECEIPT_DT datetime No No
INSPECT_DT datetime 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 char(1) No No
USER_VCHR_CHAR2 char(1) No No
USER_VCHR_DEC decimal(26,3) No No
USER_VCHR_DATE datetime No No
USER_VCHR_NUM1 smallint No No
VNDR_LOC char(10) No No
USER_LINE_CHAR1 char(1) No No
USER_SCHED_CHAR1 char(1) No No
APPR_STATUS char(1) No No
TAX_DSCNT_FLG char(1) No No
TAX_FRGHT_FLG char(1) No No
TAX_MISC_FLG char(1) No No
TAX_VAT_FLG char(1) No No
ORG_SETID char(5) No No
ORG_CODE char(6) No No
ORG_TAX_LOC_CD char(10) No No
EXS_TAX_TXN_TYPE char(4) No No
EXS_SERV_TAX_FLG char(1) No No
EXD_APPL_FLG char(1) No No
EXD_TAX_RATE_CD char(10) No No
EXD_TPRTNR_CATG_CD char(10) No No
EXD_ITM_CATG_CD char(10) No No
EXD_TAX_ITEM_TYPE char(4) No No
EXD_CHAPTER_ID char(7) No No
EXD_UOM char(3) No No
EXD_USE_AV_FLG char(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 char(1) No No
STX_TAX_RATE_CD char(10) No No
STX_TPRTNR_CATG_CD char(10) No No
STX_ITM_CATG_CD char(10) No No
STX_TAX_AUTH_RATE char(8) No No
STX_TAX_AUTH_RPT char(8) No No
STX_FORM_CD char(8) No No
CSD_APPL_FLG char(1) No No
CSD_TAX_RATE_CD char(10) No No
CSD_TPRTNR_CATG_CD char(10) No No
CSD_ITM_CATG_CD char(10) No No
CSD_BENEFIT_ID char(10) No No
EXS_CURRENCY_RPTG char(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 char(5) No No
TAX_CD_SUT_PCT decimal(7,4) No No
FREIGHT_SUT_PCT decimal(7,4) No No
TITLE_PASSAGE char(1) No No
TAX_TRANS_TYPE char(1) No No
TAX_TRANS_SUB_TYPE char(1) No No
TAX_JOB_NUM char(10) No No
TAX_USER_AREA char(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 char(18) No No
SUT_FREIGHT_CD char(18) No No
SUT_CALC_BASIS_AMT decimal(26,3) No No
SALETX_CALC_AMT decimal(26,3) No No
FREIGHT_TERMS char(10) No No
SHIP_TYPE_ID char(10) No No
REQUESTOR_ID char(30) No No
VAT_TREATMENT char(4) No No
VAT_RCRD_INPT_FLG char(1) No No
VAT_RCRD_OUTPT_FLG char(1) No No
IST_TXN_FLG CHAR(1) No No
PHYSICAL_NATURE char(1) 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_DFLT_DONE_FLG char(1) No No
FORM_DISTRIB_STAT char(1) No No
VAT_RECEIPT char(1) No No
VAT_RGSTRN_SELLER char(12) No No
TRANS_DT datetime No No
Index
Name Type Unique Member
PS_VOUCHER_LINE PK Yes
Member(s) of "PS_VOUCHER_LINE" Index
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM

Published April 30, 2007