SII_INV_MNT_TMP

(SQL Table)
Index Back

SII_INV_MNT_TMP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SII_INVOICE_ID Character(60) VARCHAR2(60) NOT NULL SII_INVOICE_ID
3 INVOICE_DT Date(10) DATE Invoice Date
4 ERROR_CODE Character(10) VARCHAR2(10) NOT NULL Error Code
5 LOC_RGSTRN_ID Character(20) VARCHAR2(20) NOT NULL Local VAT Registration ID
6 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
7 STATUS_STRING Character(100) VARCHAR2(100) NOT NULL String Text
8 SII_INVOICE_STATUS Character(2) VARCHAR2(2) NOT NULL VAT Submission Status
A=Accepted
AE=Accepted with Error
E=Error
G=Generated
M=Manual
R=Ready
RV=Reversed
RX=Rejected
S=Submitted