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 |