VAT_TX_BI_NT1_V (SQL View)	Index Back
Billing VAT View

VAT_TX_BI_NT1_V

(SQL View)

Billing VAT View

SELECT H.BUSINESS_UNIT ,H.INVOICE ,L.LINE_SEQ_NUM ,H.COUNTRY_VAT_BILLFR ,'BILL' ,L.VAT_DST_ACCT_TYPE ,'N' ,H.BI_CURRENCY_CD ,H.BASE_CURRENCY ,' ' ,L.VAT_BASIS_AMT ,L.VAT_BASIS_AMT_BSE ,0 ,L.VAT_AMT ,L.VAT_AMT_BSE ,0 ,L.VAT_TRANS_AMT ,L.VAT_TRANS_AMT_BSE ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,L.TAX_CD_VAT ,L.VAT_TXN_TYPE_CD ,L.TAX_CD_VAT_PCT ,L.VAT_TREATMENT ,L.VAT_APPLICABILITY ,V.VAT_DCLRTN_DT ,V.VAT_DCLRTN_DT_SRC ,V.VAT_DCLRTN_POINT ,V.VAT_DCLRTN_DT ,0 ,0 ,H.INVOICE_DT ,L.BUSINESS_UNIT ,H.BUSINESS_UNIT_GL ,' ' ,' ' ,S.SETID ,H.BILL_TO_CUST_ID ,V.VAT_RGSTRN_BUYER ,H.COUNTRY_VAT_BILLTO ,H.COUNTRY_VAT_BILLFR ,H.COUNTRY_VAT_BILLTO ,H.COUNTRY_SHIP_TO ,H.COUNTRY_SHIP_FROM ,H.DOC_TYPE ,H.DOC_SEQ_DATE ,H.DOC_SEQ_NBR ,L.PHYSICAL_NATURE ,L.COUNTRY_VAT_SUPPLY ,L.VAT_SVC_SUPPLY_FLG ,L.VAT_SERVICE_TYPE ,L.COUNTRY_VAT_PERFRM ,L.STATE_VAT_DEFAULT ,' ' ,' ' ,' ' FROM PS_BI_HDR H , PS_BI_HDR_VAT V , PS_BI_LINE L , PS_SET_CNTRL_REC S WHERE L.VAT_DISTRIB_STATUS = 'N' AND L.VAT_DST_ACCT_TYPE = 'VONT' AND V.VAT_DCLRTN_POINT IN ('I', 'A', 'D') AND H.BILL_STATUS = 'INV' AND H.FINAL_CURCNV_FLG = 'Y' AND H.BUSINESS_UNIT = V.BUSINESS_UNIT AND H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.INVOICE = V.INVOICE AND H.INVOICE = L.INVOICE AND H.BUSINESS_UNIT = S.SETCNTRLVALUE AND S.RECNAME = 'CUSTOMER'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

3 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence

4 COUNTRY_VAT_RPTG Character(3) VARCHAR2(3) NOT NULL VAT Reporting Country

5 VAT_TXN_SOURCE Character(6) VARCHAR2(6) NOT NULL VAT Transaction Source

6 VAT_DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger.
Prompt Table: VAT_DST_VAT_VW

7 VAT_RPTG_CURR_FLG Character(1) VARCHAR2(1) NOT NULL Amounts in Reporting Currency

8 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
Prompt Table: CURRENCY_CD_TBL

9 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Prompt Table: CURRENCY_CD_TBL

10 CURRENCY_RPTG Character(3) VARCHAR2(3) NOT NULL Reporting Currency
Prompt Table: CURRENCY_CD_TBL

11 TAX_BASIS_AMT_TXN Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Basis Amount - Transaction

12 TAX_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Basis Amount - Base

13 TAX_BASIS_AMT_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Basis Amount - Reporting

14 TAX_AMT_GROSS_TXN Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Tax Amount - Transaction

15 TAX_AMT_GROSS_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Tax Amount - Base

16 TAX_AMT_GROSS_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Tax Amount - Reporting

17 TAX_TRANS_AMT_TXN Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Transaction Amt - Transact

18 TAX_TRANS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Transaction Amt - Base

19 TAX_TRANS_AMT_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Transaction Amt - Report

20 TAX_AMT_RCVRY_TXN Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Recovery Amt - Transaction

21 TAX_AMT_RCVRY_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Recovery Amount - Base

22 TAX_AMT_RCVRY_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Recovery Amt - Reporting

23 TAX_AMT_RBT_TXN Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Rebate Amt - Transaction

24 TAX_AMT_RBT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Rebate Amount - Base

25 TAX_AMT_RBT_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Rebate Amount - Reporting

26 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
Prompt Table: VAT_HEADER_VW

27 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
Prompt Table: VAT_TXN_CD

28 TAX_CD_VAT_PCT Signed Number(9,4) DECIMAL(7,4) NOT NULL Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.

29 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment
Prompt Table: VAT_TREATMENT

30 VAT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated

31 VAT_DCLRTN_DT Date(10) DATE "Specifies the date of the invoice when the VAT declaration point (VAT_DCLRTN_POINT) is ""Invoice"". The VAT declaration date is automatically set to the invoice date by the system. This field does not apply when the declaration point is ""payment"". "

32 VAT_DCLRTN_DT_SRC Character(1) VARCHAR2(1) NOT NULL Declaration Date Source
A=Delivery Date - Ext Process
D=Delivery Date - Txn Entry
I=Invoice Date
M=Manual Entry
N=Not Applicable
Default Value: N

33 VAT_DCLRTN_POINT Character(1) VARCHAR2(1) NOT NULL A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time

34 CUR_EFFDT Date(10) DATE Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.

35 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

36 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

37 VAT_RGSTR_RPT_DT Date(10) DATE Date to be used on Italian VAT Register Reports

38 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
Prompt Table: SP_BU_FS_NONVW

39 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

40 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

41 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

42 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

43 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

44 VAT_RGSTRN_TPRTNR Character(20) VARCHAR2(20) NOT NULL Trading Partner's VAT Registration ID **** WARNING **** - This field has label ids of CUSTOMER, VENDOR, BANK. Do NOT delete these label ids. They are used to ensure the correct label is displayed on the common VAT subpages.

45 COUNTRY_VAT_TPRTNR Character(3) VARCHAR2(3) NOT NULL Trading Partner's VAT Registration Country. **** WARNING **** - This field has label ids of CUSTOMER, VENDOR, BANK. Do NOT delete these label ids. They are used to ensure the correct label is displayed on the common VAT subpages.

46 COUNTRY_VAT_BILLFR Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is generated (for VAT processing only).

47 COUNTRY_VAT_BILLTO Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is sent (for VAT processing only).

48 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).
Prompt Table: COUNTRY_TBL

49 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).

50 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.

51 DOC_SEQ_DATE Date(10) DATE Specifies the date that a document sequence number is assigned to a document or the date the document was created.

52 DOC_SEQ_NBR Character(12) VARCHAR2(12) NOT NULL Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.

53 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services

54 COUNTRY_VAT_SUPPLY Character(3) VARCHAR2(3) NOT NULL VAT Place of Supply Country
Prompt Table: COUNTRY_TBL

55 VAT_SVC_SUPPLY_FLG Character(1) VARCHAR2(1) NOT NULL VAT Services Place of Supply Flag
1=Supplier's Countries
2=Buyer's Countries
3=Where Physically Performed

56 VAT_SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication

57 COUNTRY_VAT_PERFRM Character(3) VARCHAR2(3) NOT NULL Country Where Service Physically Performed
Prompt Table: COUNTRY_TBL

58 STATE_VAT_DEFAULT Character(6) VARCHAR2(6) NOT NULL VAT Defaulting State
Prompt Table: STATE_TBL

59 VAT_RPT_STATUS Character(1) VARCHAR2(1) NOT NULL VAT Return Status
N=Not Reported
R=Reported
Default Value: N

60 ESL_RPT_STATUS Character(1) VARCHAR2(1) NOT NULL EC Sales List Status
N=Not Reported
R=Reported
Default Value: N

61 RCSL_RPT_STATUS Character(1) VARCHAR2(1) NOT NULL Rev Charge Sales List Status
N=Not Reported
R=Reported
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
3	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
4	COUNTRY_VAT_RPTG	Character(3)	VARCHAR2(3) NOT NULL	VAT Reporting Country
5	VAT_TXN_SOURCE	Character(6)	VARCHAR2(6) NOT NULL	VAT Transaction Source
6	VAT_DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger. Prompt Table: VAT_DST_VAT_VW
7	VAT_RPTG_CURR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Amounts in Reporting Currency
8	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency Prompt Table: CURRENCY_CD_TBL
9	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " Prompt Table: CURRENCY_CD_TBL
10	CURRENCY_RPTG	Character(3)	VARCHAR2(3) NOT NULL	Reporting Currency Prompt Table: CURRENCY_CD_TBL
11	TAX_BASIS_AMT_TXN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Basis Amount - Transaction
12	TAX_BASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Basis Amount - Base
13	TAX_BASIS_AMT_RPTG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Basis Amount - Reporting
14	TAX_AMT_GROSS_TXN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Tax Amount - Transaction
15	TAX_AMT_GROSS_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Tax Amount - Base
16	TAX_AMT_GROSS_RPTG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Tax Amount - Reporting
17	TAX_TRANS_AMT_TXN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Transaction Amt - Transact
18	TAX_TRANS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Transaction Amt - Base
19	TAX_TRANS_AMT_RPTG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Transaction Amt - Report
20	TAX_AMT_RCVRY_TXN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Recovery Amt - Transaction
21	TAX_AMT_RCVRY_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Recovery Amount - Base
22	TAX_AMT_RCVRY_RPTG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Recovery Amt - Reporting
23	TAX_AMT_RBT_TXN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Rebate Amt - Transaction
24	TAX_AMT_RBT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Rebate Amount - Base
25	TAX_AMT_RBT_RPTG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Rebate Amount - Reporting
26	TAX_CD_VAT	Character(8)	VARCHAR2(8) NOT NULL	Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for. Prompt Table: VAT_HEADER_VW
27	VAT_TXN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales. Prompt Table: VAT_TXN_CD
28	TAX_CD_VAT_PCT	Signed Number(9,4)	DECIMAL(7,4) NOT NULL	Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
29	VAT_TREATMENT	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment Prompt Table: VAT_TREATMENT
30	VAT_APPLICABILITY	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible. E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT Only X=Exonerated
31	VAT_DCLRTN_DT	Date(10)	DATE	"Specifies the date of the invoice when the VAT declaration point (VAT_DCLRTN_POINT) is ""Invoice"". The VAT declaration date is automatically set to the invoice date by the system. This field does not apply when the declaration point is ""payment"". "
32	VAT_DCLRTN_DT_SRC	Character(1)	VARCHAR2(1) NOT NULL	Declaration Date Source A=Delivery Date - Ext Process D=Delivery Date - Txn Entry I=Invoice Date M=Manual Entry N=Not Applicable Default Value: N
33	VAT_DCLRTN_POINT	Character(1)	VARCHAR2(1) NOT NULL	A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment. A=At Accounting Date D=At Delivery Time I=At Invoice Time P=At Payment Time
34	CUR_EFFDT	Date(10)	DATE	Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
35	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
36	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
37	VAT_RGSTR_RPT_DT	Date(10)	DATE	Date to be used on Italian VAT Register Reports
38	SETCNTRLVALUE	Character(20)	VARCHAR2(20) NOT NULL	Tree Definition User Key Value Prompt Table: SP_BU_FS_NONVW
39	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
40	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
41	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
42	CUSTOMER_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
43	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
44	VAT_RGSTRN_TPRTNR	Character(20)	VARCHAR2(20) NOT NULL	Trading Partner's VAT Registration ID ** WARNING ** - This field has label ids of CUSTOMER, VENDOR, BANK. Do NOT delete these label ids. They are used to ensure the correct label is displayed on the common VAT subpages.
45	COUNTRY_VAT_TPRTNR	Character(3)	VARCHAR2(3) NOT NULL	Trading Partner's VAT Registration Country. ** WARNING ** - This field has label ids of CUSTOMER, VENDOR, BANK. Do NOT delete these label ids. They are used to ensure the correct label is displayed on the common VAT subpages.
46	COUNTRY_VAT_BILLFR	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is generated (for VAT processing only).
47	COUNTRY_VAT_BILLTO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is sent (for VAT processing only).
48	COUNTRY_SHIP_TO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country to which the invoice contents were shipped (for VAT processing only). Prompt Table: COUNTRY_TBL
49	COUNTRY_SHIP_FROM	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country from which the invoice contents were shipped (for VAT processing only).
50	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
51	DOC_SEQ_DATE	Date(10)	DATE	Specifies the date that a document sequence number is assigned to a document or the date the document was created.
52	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
53	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
54	COUNTRY_VAT_SUPPLY	Character(3)	VARCHAR2(3) NOT NULL	VAT Place of Supply Country Prompt Table: COUNTRY_TBL
55	VAT_SVC_SUPPLY_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT Services Place of Supply Flag 1=Supplier's Countries 2=Buyer's Countries 3=Where Physically Performed
56	VAT_SERVICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT Service Type 1=Freight Transport 2=Other 3=Electronics/Communication
57	COUNTRY_VAT_PERFRM	Character(3)	VARCHAR2(3) NOT NULL	Country Where Service Physically Performed Prompt Table: COUNTRY_TBL
58	STATE_VAT_DEFAULT	Character(6)	VARCHAR2(6) NOT NULL	VAT Defaulting State Prompt Table: STATE_TBL
59	VAT_RPT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	VAT Return Status N=Not Reported R=Reported Default Value: N
60	ESL_RPT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	EC Sales List Status N=Not Reported R=Reported Default Value: N
61	RCSL_RPT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Rev Charge Sales List Status N=Not Reported R=Reported Default Value: N