PeopleSoft 9 Account Payables |
Table Name | NET_STG_HDR |
Table Description |
NET_STG_HDR |
Columns |
Name | Datatype | Is PK | Is FK |
NET_REF_ID | VARCHAR(12) | Yes | No |
NET_HDR_STATUS | VARCHAR(1) | No | No |
DESCR | VARCHAR(30) | No | No |
NET_CONTRACT_ID | VARCHAR(10) | No | No |
NET_PARTICIPANT_ID | VARCHAR(12) | No | No |
NETTING_RULE_ID | VARCHAR(10) | No | No |
NET_SEQ_METHOD_AP | VARCHAR(2) | No | No |
NET_SORT_FIELD_AP | VARCHAR(30) | No | No |
NET_SEQ_METHOD_AR | VARCHAR(2) | No | No |
NET_SORT_FIELD_AR | VARCHAR(30) | No | No |
CONTACT_ID | VARCHAR(15) | No | No |
NETTING_DATE | PSDATE | No | No |
NETTING_STL_DATE | PSDATE | No | No |
PAYMENT_METHOD_AR | VARCHAR(3) | No | No |
DEPOSIT_BU | VARCHAR(5) | No | No |
PAYMENT_METHOD_AP | VARCHAR(3) | No | No |
REMIT_SETID | VARCHAR(5) | No | No |
REMIT_VENDOR | VARCHAR(10) | No | No |
VNDR_LOC | VARCHAR(10) | No | No |
BANK_ACCT_SEQ_NBR | SMALLINT | No | No |
PAY_BANK_SETID | VARCHAR(5) | No | No |
PAY_BANK_CD | VARCHAR(5) | No | No |
PAY_BANK_ACCT_KEY | VARCHAR(4) | No | No |
NET_BANK_SETID | VARCHAR(5) | No | No |
NET_BANK_CD | VARCHAR(5) | No | No |
NET_BANK_ACCT_KEY | VARCHAR(4) | No | No |
NETTING_CURRENCY | VARCHAR(3) | No | No |
BASE_CURRENCY | VARCHAR(3) | No | No |
RT_TYPE | VARCHAR(5) | No | No |
RATE_MULT | decimal(15,8) | No | No |
RATE_DIV | decimal(15,8) | No | No |
TOTAL_PAY_AMT | decimal(26,3) | No | No |
TOTAL_PAY_AMT_BASE | decimal(26,3) | No | No |
TOTAL_AP_TXNS | int | No | No |
TOTAL_RCV_AMT | decimal(26,3) | No | No |
TOTAL_REC_AMT_BASE | decimal(26,3) | No | No |
TOTAL_AR_TXNS | int | No | No |
NET_BAL_AMT | decimal(26,3) | No | No |
NET_BAL_AMT_BASE | decimal(26,3) | No | No |
BAL_BAL_AMT | decimal(26,3) | No | No |
BAL_BAL_AMT_BASE | decimal(26,3) | No | No |
PRE_APPROVAL_FLG | VARCHAR(1) | No | No |
NET_ADJUST_TYPE | VARCHAR(1) | No | No |
NET_PROCESS_TYPE | VARCHAR(1) | No | No |
NET_CLOSING_METHOD | VARCHAR(1) | No | No |
BUSINESS_UNIT_AR | VARCHAR(5) | No | No |
CUST_SETID | VARCHAR(5) | No | No |
CUST_ID | VARCHAR(15) | No | No |
ENTRY_TYPE_SETID | VARCHAR(5) | No | No |
ENTRY_TYPE | VARCHAR(5) | No | No |
ENTRY_REASON | VARCHAR(5) | No | No |
DSTID_SETID | VARCHAR(5) | No | No |
DST_ID_AR | VARCHAR(10) | No | No |
BUSINESS_UNIT_AP | VARCHAR(5) | No | No |
VENDOR_SETID | VARCHAR(5) | No | No |
VENDOR_ID | VARCHAR(10) | No | No |
DSTCD_SETID | VARCHAR(5) | No | No |
DST_CNTRL_ID | VARCHAR(10) | No | No |
PROCESS_INSTANCE | decimal(10) | No | No |
RUN_OPRID | VARCHAR(30) | No | No |
RUN_DTTM | PSDATETIME | No | No |
APPROVAL_OPRID | VARCHAR(30) | No | No |
APPROVAL_DTTM | PSDATETIME | No | No |
OPRID_ENTERED_BY | VARCHAR(30) | No | No |
DTTM_ENTERED | PSDATETIME | No | No |
OPRID_LAST_UPDT | VARCHAR(30) | No | No |
LAST_DTTM_UPDATE | PSDATETIME | No | No |
ORIGIN_ID | VARCHAR(5) | No | No |
GROUP_TYPE | VARCHAR(1) | No | No |
VAT_ENTITY | VARCHAR(20) | No | No |
VAT_CALC_GROSS_NET | VARCHAR(1) | No | No |
VAT_EXCPTN_TYPE | VARCHAR(1) | No | No |
VAT_DCLRTN_POINT | VARCHAR(1) | No | No |
VAT_RECALC_FLG | VARCHAR(1) | No | No |
COUNTRY_VAT_BILLFR | VARCHAR(3) | No | No |
COUNTRY_SHIP_TO | VARCHAR(3) | No | No |
COUNTRY_SHIP_FROM | VARCHAR(3) | No | No |
VAT_ROUND_RULE | VARCHAR(1) | No | No |
VAT_ADVPAY_FLG | VARCHAR(1) | No | No |
VAT_TRANS_AMT | decimal(26,3) | No | No |
VAT_TXN_TYPE_CD | VARCHAR(4) | No | No |
VAT_CALC_TYPE | VARCHAR(1) | No | No |
ORIGIN | VARCHAR(3) | No | No |
Index |
Name | Type | Unique | Member |
PS_NET_STG_HDR | PK | Yes |
![]() |
PS0NET_STG_HDR | IE13 | No |
![]() |
PS1NET_STG_HDR | IE14 | No |
![]() |
PS2NET_STG_HDR | IE15 | No |
![]() |
Member(s) of "PS_NET_STG_HDR" Index |
NET_REF_ID |
Member(s) of "PS0NET_STG_HDR" Index |
NET_HDR_STATUS |
NET_REF_ID |
Member(s) of "PS1NET_STG_HDR" Index |
NET_CONTRACT_ID |
NET_REF_ID |
Member(s) of "PS2NET_STG_HDR" Index |
NETTING_DATE |
NET_REF_ID |
Published June 06, 2007 |