PeopleSoft 9 Account Payables |
Table Name | VCHR_HDR_STG |
Table Description |
VCHR_HDR_STG |
Columns |
Name | Datatype | Is PK | Is FK |
BUSINESS_UNIT | VARCHAR(5) | Yes | Yes |
VCHR_BLD_KEY_C1 | VARCHAR(25) | Yes | No |
VCHR_BLD_KEY_C2 | VARCHAR(25) | Yes | No |
VCHR_BLD_KEY_N1 | decimal(10) | Yes | No |
VCHR_BLD_KEY_N2 | decimal(10) | Yes | No |
VOUCHER_ID | VARCHAR(8) | Yes | No |
VOUCHER_STYLE | VARCHAR(4) | No | No |
INVOICE_ID | VARCHAR(30) | 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 | No |
OPRID | VARCHAR(30) | No | No |
ACCOUNTING_DT | PSDATE | No | No |
POST_VOUCHER | VARCHAR(1) | No | No |
DST_CNTRL_ID | VARCHAR(10) | No | No |
VOUCHER_ID_RELATED | VARCHAR(8) | No | No |
GROSS_AMT | decimal(26,3) | No | No |
DSCNT_AMT | decimal(26,3) | No | No |
TAX_EXEMPT | VARCHAR(1) | No | No |
SALETX_AMT | decimal(26,3) | No | No |
FREIGHT_AMT | decimal(26,3) | No | No |
MISC_AMT | decimal(26,3) | No | No |
PYMNT_TERMS_CD | VARCHAR(5) | No | No |
ENTERED_DT | PSDATE | 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 |
VAT_ENTRD_AMT | decimal(26,3) | No | No |
MATCH_ACTION | VARCHAR(1) | 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 |
VAT_DCLRTN_POINT | VARCHAR(1) | No | No |
VAT_CALC_TYPE | VARCHAR(1) | 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_TREATMENT_GRP | VARCHAR(4) | No | No |
COUNTRY_SHIP_FROM | VARCHAR(3) | No | No |
STATE_SHIP_FROM | VARCHAR(6) | No | No |
COUNTRY_SHIP_TO | VARCHAR(3) | No | No |
STATE_SHIP_TO | VARCHAR(6) | No | No |
COUNTRY_VAT_BILLFR | VARCHAR(3) | No | No |
COUNTRY_VAT_BILLTO | VARCHAR(3) | No | No |
VAT_EXCPTN_CERTIF | VARCHAR(20) | No | No |
VAT_ROUND_RULE | VARCHAR(1) | No | No |
COUNTRY_LOC_SELLER | VARCHAR(3) | No | No |
STATE_LOC_SELLER | VARCHAR(6) | No | No |
COUNTRY_LOC_BUYER | VARCHAR(3) | No | No |
STATE_LOC_BUYER | VARCHAR(6) | No | No |
COUNTRY_VAT_SUPPLY | VARCHAR(3) | No | No |
STATE_VAT_SUPPLY | VARCHAR(6) | No | No |
COUNTRY_VAT_PERFRM | VARCHAR(3) | No | No |
STATE_VAT_PERFRM | VARCHAR(6) | No | No |
STATE_VAT_DEFAULT | VARCHAR(6) | No | No |
PREPAID_REF | VARCHAR(10) | No | No |
PREPAID_AUTO_APPLY | VARCHAR(1) | No | No |
DESCR254_MIXED | VARCHAR(254) | No | No |
EIN_FEDERAL | VARCHAR(9) | No | No |
EIN_STATE_LOCAL | VARCHAR(20) | No | No |
PROCESS_INSTANCE | decimal(10) | No | No |
IN_PROCESS_FLG | VARCHAR(1) | No | No |
BUSINESS_UNIT_PO | VARCHAR(5) | No | No |
PO_ID | VARCHAR(10) | No | No |
PACKSLIP_NO | VARCHAR(22) | No | No |
PAY_TRM_BSE_DT_OPT | VARCHAR(1) | No | No |
VAT_CALC_MISC_FLG | VARCHAR(1) | No | No |
IMAGE_REF_ID | VARCHAR(12) | No | No |
IMAGE_DATE | PSDATE | No | No |
PAY_SCHEDULE_TYPE | VARCHAR(3) | No | No |
TAX_GRP | VARCHAR(4) | No | No |
TAX_PYMNT_TYPE | VARCHAR(5) | No | No |
INSPECT_DT | PSDATE | No | No |
INV_RECPT_DT | PSDATE | No | No |
RECEIPT_DT | PSDATE | No | No |
BILL_OF_LADING | VARCHAR(30) | No | No |
CARRIER_ID | VARCHAR(10) | No | No |
DOC_TYPE | VARCHAR(8) | No | No |
DSCNT_DUE_DT | PSDATE | No | No |
DSCNT_PRORATE_FLG | VARCHAR(1) | No | No |
DUE_DT | PSDATE | No | No |
ECQUEUEINSTANCE | int | No | No |
ECTRANSID | VARCHAR(15) | No | No |
FRGHT_CHARGE_CODE | VARCHAR(10) | No | No |
LC_ID | VARCHAR(12) | No | No |
MISC_CHARGE_CODE | VARCHAR(10) | No | No |
REMIT_ADDR_SEQ_NUM | INT | No | No |
SALETX_CHARGE_CODE | VARCHAR(10) | No | No |
VCHR_BLD_CODE | VARCHAR(6) | No | No |
BUSINESS_UNIT_AR | VARCHAR(5) | No | No |
CUST_ID | VARCHAR(15) | No | No |
ITEM | VARCHAR(30) | No | No |
ITEM_LINE | int | No | No |
ERS_INV_SEQ | SMALLINT | No | No |
LS_KEY | DECIMAL(15) | No | No |
VCHR_SRC | VARCHAR(4) | No | No |
VAT_EXCPTN_TYPE | VARCHAR(1) | No | No |
TERMS_BASIS_DT | datetime | 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 |
USER_HDR_CHAR1 | VARCHAR(1) | No | No |
Index |
Name | Type | Unique | Member |
PS_VCHR_HDR_STG | PK | Yes |
![]() |
Member(s) of "PS_VCHR_HDR_STG" Index |
BUSINESS_UNIT |
VCHR_BLD_KEY_C1 |
VCHR_BLD_KEY_C2 |
VCHR_BLD_KEY_N1 |
VCHR_BLD_KEY_N2 |
VOUCHER_ID |
Published June 06, 2007 |