RMA_IVC_TAX_VW(SQL View) |
Index Back |
|---|---|
RMA Tax Fields fr InvoiceRMA Tax Fields fr Invoice |
| SELECT LT.BUSINESS_UNIT , LT.INVOICE , LT.LINE_SEQ_NUM , LT.CUST_PICKUP , LT.GROUP_CODE , LT.ORD_ACCEPT_LOC , LT.ORD_ORIGIN_LOC , LT.PT_SALE_FLG , LT.SHIP_FROM_LOC , LT.SRV_PERFORM_LOC , LT.STORE_LOC , LT.CUSTOMER_GROUP , LT.TAX_CUST_ID , LT.TAX_DATE , LT.TAX_DEPARTMENT , LT.TAX_DIVISION , LT.TAX_EXEMPT_RC , LT.TAX_GROUP , LT.TAX_JOB_NUM , LT.TAX_TRANS_SUB_TYPE , LT.TAX_TRANS_TYPE , LT.TAX_USER_AREA , LT.TITLE_PASSAGE , LT.USETAX_BASIS_AMT FROM PS_BI_LINE_TAX LT |
| # | 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 | CUST_PICKUP | Character(1) | VARCHAR2(1) NOT NULL |
Counter sale customer pickup flag
N=No Y=Yes |
| 5 | GROUP_CODE | Number(5,0) | INTEGER NOT NULL | Group With Line |
| 6 | ORD_ACCEPT_LOC | Character(10) | VARCHAR2(10) NOT NULL | Order Acceptance |
| 7 | ORD_ORIGIN_LOC | Character(10) | VARCHAR2(10) NOT NULL | Order Origin |
| 8 | PT_SALE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Point of Sale Flag |
| 9 | SHIP_FROM_LOC | Character(10) | VARCHAR2(10) NOT NULL | Ship From Location |
| 10 | SRV_PERFORM_LOC | Character(10) | VARCHAR2(10) NOT NULL | Service Performance Location |
| 11 | STORE_LOC | Character(10) | VARCHAR2(10) NOT NULL | Store Location |
| 12 | CUSTOMER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Customer Group |
| 13 | TAX_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Tax Customer ID |
| 14 | TAX_DATE | Date(10) | DATE | Tax Date |
| 15 | TAX_DEPARTMENT | Character(5) | VARCHAR2(5) NOT NULL | Department used by Tax Vendors |
| 16 | TAX_DIVISION | Character(5) | VARCHAR2(5) NOT NULL | Division for Tax Suppliers |
| 17 | TAX_EXEMPT_RC | Character(2) | VARCHAR2(2) NOT NULL |
Exempt Reason Code
01=Certificat |
| 18 | TAX_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Tax Group |
| 19 | TAX_JOB_NUM | Character(10) | VARCHAR2(10) NOT NULL | Job Number |
| 20 | TAX_TRANS_SUB_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Sub Type
1=Property 2=Freight 3=Service 4=Rental or Lease 5=Expense 6=Misc N=None |
| 21 | TAX_TRANS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Type
1=Sale 2=Rental 3=Service 4=Purchase 5=Lease B=Return |
| 22 | TAX_USER_AREA | Character(25) | VARCHAR2(25) NOT NULL | Used for tax calculation by tax vendor. |
| 23 | TITLE_PASSAGE | Character(1) | VARCHAR2(1) NOT NULL |
Title Passage
B=Buyer's Destination-Ship To I=Intermediate Consignee S=Seller's Origination-Ship From |
| 24 | USETAX_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Use Tax Basis Amount |