PeopleSoft 9 Account Payables |
Table Name | PRE_AM_STG |
Table Description |
PRE_AM_STG |
Columns |
Name | Datatype | Is PK | Is FK |
PROCESS_INSTANCE | DECIMAL(10) | Yes | No |
PRE_INTFC_ID | INT | Yes | No |
PRE_INTFC_LINE_NUM | INT | Yes | No |
DTTM_STAMP | PSDATETIME | Yes | No |
SYSTEM_SOURCE | VARCHAR(3) | No | No |
INTFC_ID | INT | No | No |
INTFC_LINE_NUM | INT | No | No |
LOAD_STATUS | VARCHAR(3) | No | No |
TRANS_DT | datetime | No | No |
ACCOUNTING_DT | datetime | No | No |
INTFC_TYPE | VARCHAR(3) | No | No |
BUSINESS_UNIT_PO | VARCHAR(5) | No | No |
PO_ID | VARCHAR(10) | No | No |
PO_LINE_NBR | INT | No | No |
SCHED_NBR | SMALLINT | No | No |
PO_DIST_LINE_NUM | INT | No | No |
BUSINESS_UNIT_RECV | VARCHAR(5) | No | No |
RECEIVER_ID | VARCHAR(10) | No | No |
RECV_LN_NBR | INT | No | No |
RECV_SHIP_SEQ_NBR | SMALLINT | No | No |
RECV_DIST_LINE_NUM | INT | No | No |
DISTRIB_SEQ_NUM | INT | No | No |
BUSINESS_UNIT_AP | VARCHAR(5) | No | No |
VOUCHER_ID | VARCHAR(8) | No | No |
VOUCHER_LINE_NUM | INT | No | No |
DISTRIB_LINE_NUM | INT | No | No |
BUSINESS_UNIT_AM | VARCHAR(5) | No | No |
ASSET_ID | VARCHAR(12) | No | No |
PROFILE_ID | VARCHAR(10) | No | No |
FINANCIAL_ASSET_SW | VARCHAR(1) | No | No |
OPERATING_UNIT | VARCHAR(8) | No | No |
PRODUCT | VARCHAR(6) | No | No |
FUND_CODE | VARCHAR(5) | No | No |
CLASS_FLD | VARCHAR(5) | No | No |
PROGRAM_CODE | VARCHAR(5) | No | No |
BUDGET_REF | VARCHAR(8) | No | No |
AFFILIATE | VARCHAR(5) | No | No |
AFFILIATE_INTRA1 | VARCHAR(10) | No | No |
AFFILIATE_INTRA2 | VARCHAR(10) | No | No |
CHARTFIELD1 | VARCHAR(10) | No | No |
CHARTFIELD2 | VARCHAR(10) | No | No |
CHARTFIELD3 | VARCHAR(10) | No | No |
PROJECT_ID | VARCHAR(15) | No | No |
DEPTID | VARCHAR(10) | No | No |
COST_TYPE | VARCHAR(1) | No | No |
TAG_NUMBER | VARCHAR(12) | No | No |
SERIAL_ID | VARCHAR(20) | No | No |
DESCR | VARCHAR(30) | No | No |
INV_ITEM_ID | VARCHAR(18) | No | No |
VENDOR_ID | VARCHAR(10) | No | No |
MANUFACTURER | VARCHAR(30) | No | No |
MODEL | VARCHAR(30) | No | No |
CUSTODIAN | VARCHAR(30) | No | No |
LOCATION | VARCHAR(10) | No | No |
QUANTITY | DECIMAL(15,4) | No | No |
COST | DECIMAL(26,3) | No | No |
SALETX_CD | VARCHAR(8) | No | No |
USETAX_CD | VARCHAR(8) | No | No |
INVOICE_ID | VARCHAR(30) | No | No |
INVOICE_DT | datetime | No | No |
CURRENCY_CD | VARCHAR(3) | No | No |
TXN_CURRENCY_CD | VARCHAR(3) | No | No |
CAP_NUM | VARCHAR(15) | No | No |
CAP_SEQUENCE | SMALLINT | No | No |
EMPLID | VARCHAR(11) | No | No |
BUSINESS_UNIT_PC | VARCHAR(5) | No | No |
ACTIVITY_ID | VARCHAR(15) | No | No |
ANALYSIS_TYPE | VARCHAR(3) | No | No |
RESOURCE_TYPE | VARCHAR(5) | No | No |
RESOURCE_CATEGORY | VARCHAR(5) | No | No |
RESOURCE_SUB_CAT | VARCHAR(5) | No | No |
MERCH_AMT_BSE | DECIMAL(26,3) | No | No |
MERCHANDISE_AMT | DECIMAL(26,3) | No | No |
DSCNT_AMT | DECIMAL(26,3) | No | No |
DSCNT_AMT_BSE | DECIMAL(26,3) | No | No |
CSD_NRCVRY_AMT | DECIMAL(26,3) | No | No |
CSD_NRCVRY_AMT_BSE | DECIMAL(26,3) | No | No |
CSD_RCVRY_AMT | DECIMAL(26,3) | No | No |
CSD_RCVRY_AMT_BSE | DECIMAL(26,3) | No | No |
EXD_NRCVRY_AMT | DECIMAL(26,3) | No | No |
EXD_NRCVRY_AMT_BSE | DECIMAL(26,3) | No | No |
EXD_RCVRY_AMT | DECIMAL(26,3) | No | No |
EXD_RCVRY_AMT_BSE | DECIMAL(26,3) | No | No |
FREIGHT_AMT | DECIMAL(26,3) | No | No |
FREIGHT_AMT_BSE | DECIMAL(26,3) | No | No |
FREIGHT_AMT_NP | DECIMAL(26,3) | No | No |
FREIGHT_AMT_NP_BSE | DECIMAL(26,3) | No | No |
MISC_AMT | DECIMAL(26,3) | No | No |
MISC_AMT_BSE | DECIMAL(26,3) | No | No |
MISC_AMT_NP | DECIMAL(26,3) | No | No |
MISC_AMT_NP_BSE | DECIMAL(26,3) | No | No |
SALETX_AMT | DECIMAL(26,3) | No | No |
SALETX_AMT_BSE | DECIMAL(26,3) | No | No |
SALETX_AMT_NP | DECIMAL(26,3) | No | No |
SALETX_AMT_NP_BSE | DECIMAL(26,3) | No | No |
STX_NRCVRY_AMT | DECIMAL(26,3) | No | No |
STX_NRCVRY_AMT_BSE | DECIMAL(26,3) | No | No |
STX_RCVRY_AMT | DECIMAL(26,3) | No | No |
STX_RCVRY_AMT_BSE | DECIMAL(26,3) | No | No |
USETAX_AMT | DECIMAL(26,3) | No | No |
USETAX_AMT_BSE | DECIMAL(26,3) | No | No |
USETAX_AMT_NP | DECIMAL(26,3) | No | No |
USETAX_AMT_NP_BSE | DECIMAL(26,3) | No | No |
VAT_INV_AMT | DECIMAL(26,3) | No | No |
VAT_INV_AMT_BSE | DECIMAL(26,3) | No | No |
VAT_RCVRY_AMT | DECIMAL(26,3) | No | No |
VAT_RCVRY_AMT_BSE | DECIMAL(26,3) | No | No |
VAT_NRCVR_AMT | DECIMAL(26,3) | No | No |
VAT_NRCVR_AMT_BSE | DECIMAL(26,3) | No | No |
RATE_MULT | DECIMAL(15,8) | No | No |
RATE_DIV | DECIMAL(15,8) | No | No |
RT_TYPE | VARCHAR(5) | No | No |
TXN_COST | DECIMAL(26,3) | No | No |
Index |
Name | Type | Unique | Member |
PS_PRE_AM_STG | PK | Yes |
![]() |
PS0PRE_AM_STG | IE1 | No |
![]() |
PS1PRE_AM_STG | IE2 | No |
![]() |
Member(s) of "PS_PRE_AM_STG" Index |
PROCESS_INSTANCE |
PRE_INTFC_ID |
PRE_INTFC_LINE_NUM |
DTTM_STAMP |
Member(s) of "PS0PRE_AM_STG" Index |
BUSINESS_UNIT_AP |
PROCESS_INSTANCE |
PRE_INTFC_ID |
PRE_INTFC_LINE_NUM |
DTTM_STAMP |
Member(s) of "PS1PRE_AM_STG" Index |
VOUCHER_ID |
PROCESS_INSTANCE |
PRE_INTFC_ID |
PRE_INTFC_LINE_NUM |
DTTM_STAMP |
Published June 06, 2007 |