Share via


Purch. Inv. Line Table

When an invoice is posted as received, you can see it in the Posted Purchase Invoice window.

The purchase invoice was created when you clicked Post on a purchase invoice and then chose Post.

Important

If the Receipt on Invoice check box in the Purchases & Payables Setup window contains a check mark, a receipt will also be created when you post an invoice.

A purchase invoice consists of a purchase invoice header and one or more purchase invoice lines.

The purchase invoice header contains all the relevant information about the buy-from and pay-to vendors such as name, address, document number, and date. The program copied the information from the purchase header when it was posted.

The purchase invoice lines contain information (such as item number, quantity and cost) copied from the posted purchase line.

You cannot change any of the fields on a purchase invoice header or lines because the invoice has already been posted.

List of Fields in the Table

To see the list of fields in this table, change to the Classic view. Choose the Choose View button in the upper-right corner, and then choose Classic.

Field Location
TDS Percentage Field, Purch. Inv. Line Table Income Tax
ADE Amount Field, Purch. Inv. Line Table Excise
Temp TDS Base Field, Purch. Inv. Line Table Income Tax
Excise as Service Tax Credit Field, Purch. Inv. Line Table Excise
Work Tax Percentage Field, Purch. Inv. Line Table Income Tax
TDS Base Amount Field, Purch. Inv. Line Table Income Tax
State Field, Purch. Inv. Line Table Sales Tax
TDS Category Field, Purch. Inv. Line Table Income Tax
SAED Amount Field, Purch. Inv. Line Table Excise
Set Off Available Field, Purch. Inv. Line Table Excise
Input Credit/Output Tax Amount Field, Purch. Inv. Line Table Sales Tax
Tax Base Amount Field, Purch. Inv. Line Table Sales Tax
Service Tax eCess Amount Field, Purch. Inv. Line Table Service Tax
Purchase Tax Amount Field, Purch. Inv. Line Table Sales Tax
AED(TTA) Amount Field, Purch. Inv. Line Table Excise
Excise Accounting Type Field, Purch. Inv. Line Table Excise
TDS Group Field, Purch. Inv. Line Table Income Tax
Service Tax as Excise Credit Field, Purch. Inv. Line Table Service Tax
Amount Including Tax Field, Purch. Inv. Line Table Sales Tax
Service Tax Base Field, Purch. Inv. Line Table Service Tax
Form Code Field, Purch. Inv. Line Table Sales Tax
VAT Type Field, Purch. Inv. Line Table Income Tax
Non ITC Claimable Usage Percentage Field, Purch. Inv. Line Table Sales Tax
Form No. Field, Purch. Inv. Line Table Sales Tax
NCCD Field, Purch. Inv. Line Table Excise
Tax Percentage Field, Purch. Inv. Line Table Sales Tax
SHE Cess Percentage On TDS Field, Purch. Inv. Line Table Income Tax
Service Tax Registration No. Field, Purch. Inv. Line Table Service Tax
Capital Item Field, Purch. Inv. Line Table Excise
Assessable Value Field, Purch. Inv. Line Table Sales Tax
CVD Field, Purch. Inv. Line Table Excise
Work Tax Group Field, Purch. Inv. Line Table Income Tax
BCD Amount Field, Purch. Inv. Line Table Excise
Service Tax SHE Cess Amount Field, Purch. Inv. Line Table Service Tax
Excise Refund Field, Purch. Inv. Line Table Excise
ADC VAT Amount Field, Purch. Inv. Line Table Excise
Surcharge Percentage Field, Purch. Inv. Line Table Income Tax
Total TDS Including SHE Cess Field, Purch. Inv. Line Table Income Tax
Excise Base Amount Field, Purch. Inv. Line Table Excise
SHE Cess On TDS Amount Field, Purch. Inv. Line Table Income Tax
ADET Amount Field, Purch. Inv. Line Table Excise
Work Tax Amount Field, Purch. Inv. Line Table Income Tax
Per Contract Field, Purch. Inv. Line Table Service Tax
Service Tax Group Field, Purch. Inv. Line Table Service Tax
SED Field, Purch. Inv. Line Table Excise
Notification No. Field, Purch. Inv. Line Table Excise
Bal. TDS Including SHE Cess Field, Purch. Inv. Line Table Income Tax
Surcharge Amount Field, Purch. Inv. Line Table Income Tax
Work Tax Nature Of Deduction Field, Purch. Inv. Line Table Income Tax
Service Tax Amount Field, Purch. Inv. Line Table Service Tax
WHT Business Posting Group Field, Purch. Inv. Line Table New Zealand Local Functionality
Surcharge Base Amount Field, Purch. Inv. Line Table Service Tax
TDS Nature of Deduction Field, Purch. Inv. Line Table Income Tax
TDS Amount Including Surcharge Field, Purch. Inv. Line Table Income Tax
RG Record Type Field, Purch. Inv. Line Table Excise
Work Tax Base Amount Field, Purch. Inv. Line Table Income Tax
eCESS Percentage on TDS Field, Purch. Inv. Line Table Income Tax
WHT Absorb Base Field, Purch. Inv. Line Table New Zealand Local Functionality
Amount Including VAT (ACY) Field, Purch. Inv. Line Table New Zealand Local Functionality
TDS Assessee Code Field, Purch. Inv. Line Table Income Tax
Concessional Code Field, Purch. Inv. Line Table Income Tax
eCESS on TDS Amount Field, Purch. Inv. Line Table Income Tax
TDS Amount Field, Purch. Inv. Line Table Income Tax
Reason Code Field, Purch. Inv. Line Table Excise
Notification No. Field, Purch. Inv. Line Table Excise
WHT Product Posting Group Field, Purch. Inv. Line Table New Zealand Local Functionality
Excise Base Quantity Field, Purch. Inv. Line Table Excise
Excise Bus. Posting Group Field, Purch. Inv. Line Table Excise
VAT Amount (ACY) Field, Purch. Inv. Line Table New Zealand Local Functionality
Excise Loading On Inventory Field, Purch. Inv. Line Table Excise
CIF Amount Field, Purch. Inv. Line Table Excise
Provincial Tax Area Code Field, Purch. Inv. Line Table United States Local Functionality
eCess Amount Field, Purch. Inv. Line Table Excise
CESS Amount Field, Purch. Inv. Line Table Excise
Excise Amount Field, Purch. Inv. Line Table Excise
BED Amount Field, Purch. Inv. Line Table Excise
Prepayment % Field, Purch. Inv. Line Table New Zealand Local Functionality
VAT Difference (ACY) Field, Purch. Inv. Line Table New Zealand Local Functionality
Excise Prod. Posting Group Field, Purch. Inv. Line Table Excise
Amount Including Excise Field, Purch. Inv. Line Table Excise
SHE Cess Amount Field, Purch. Inv. Line Table Excise
IRS 1099 Liable Field, Purch. Inv. Line Table United States Local Functionality
AED(GSI) Amount Field, Purch. Inv. Line Table Excise
Receipt No. Field, Purch. Inv. Line Table Iceland Local Functionality
Receipt Line No. Field, Purch. Inv. Line Table Iceland Local Functionality
Source Document Type Field, Purch. Inv. Line Table India Local Functionality
VAT Base (ACY) Field, Purch. Inv. Line Table New Zealand Local Functionality
Tax Amount Field, Purch. Inv. Line Table Excise
Reverse Charge Field, Purch. Inv. Line Table United Kingdom Local Functionality
Reverse Charge Item Field, Purch. Inv. Line Table United Kingdom Local Functionality
Amount Loaded on Inventory Field, Purch. Inv. Line Table India Local Functionality
Amount (ACY) Field, Purch. Inv. Line Table New Zealand Local Functionality
Auto. Acc. Group Field, Purch. Inv. Line Table Sweden Local Functionality
Amount To Vendor Field, Purch. Inv. Line Table India Local Functionality
Periodic Template Code Field, Purch. Inv. Line Table Sweden Local Functionality
Periodic Starting Date Field, Purch. Inv. Line Table Sweden Local Functionality
VAT Code Field, Purch. Inv. Line Table Norway Local Functionality
CWIP G/L Type Field, Purch. Inv. Line Table India Local Functionality
Charges To Vendor Field, Purch. Inv. Line Table India Local Functionality
Vendor Shipment No. Field, Purch. Inv. Line Table India Local Functionality
Receipt Document Line No. Field, Purch. Inv. Line Table India Local Functionality
Source Document No. Field, Purch. Inv. Line Table India Local Functionality
Custom eCess Amount Field, Purch. Inv. Line Table India Local Functionality
CTSH No. Field, Purch. Inv. Line Table India Local Functionality
Receipt Document No. Field, Purch. Inv. Line Table India Local Functionality
Supplementary Field, Purch. Inv. Line Table India Local Functionality
Custom SHECess Amount Field, Purch. Inv. Line Table India Local Functionality
Job Line Discount Amount Field, Purch. Inv. Line Table Purchases and Payables
Indirect Cost % Field, Purch. Inv. Line Table Purchases and Payables
Entry Point Field, Purch. Inv. Line Table Purchases and Payables
Quantity Field, Purch. Inv. Line Table Purchases and Payables
Cross-Reference Type Field, Purch. Inv. Line Table Purchases and Payables
Type Field, Purch. Inv. Line Table Purchases and Payables
Transaction Specification Field, Purch. Inv. Line Table Purchases and Payables
Job Line Disc. Amount (LCY) Field, Purch. Inv. Line Table Purchases and Payables
Job No. Field, Purch. Inv. Line Table Purchases and Payables
Cross-Reference Type No. Field, Purch. Inv. Line Table Purchases and Payables
Responsibility Center Field, Purch. Inv. Line Table Purchases and Payables
Tax Area Code Field, Purch. Inv. Line Table Purchases and Payables
No. Field, Purch. Inv. Line Table Purchases and Payables
Posting Group Field, Purch. Inv. Line Table Purchases and Payables
Budgeted FA No. Field, Purch. Inv. Line Table Purchases and Payables
Purchasing Code Field, Purch. Inv. Line Table Purchases and Payables
Unit Cost (LCY) Field, Purch. Inv. Line Table Purchases and Payables
Depr. Acquisition Cost Field, Purch. Inv. Line Table Purchases and Payables
Unit of Measure Code Field, Purch. Inv. Line Table Purchases and Payables
Unit Cost Field, Purch. Inv. Line Table Purchases and Payables
Attached to Line No. Field, Purch. Inv. Line Table Purchases and Payables
Unit Volume Field, Purch. Inv. Line Table Purchases and Payables
Job Line Amount Field, Purch. Inv. Line Table Purchases and Payables
EC Difference Field, Purch. Inv. Line Table Spain Local Functionality
VAT % Field, Purch. Inv. Line Table Purchases and Payables
Amount Field, Purch. Inv. Line Table Purchases and Payables
Transport Method Field, Purch. Inv. Line Table Purchases and Payables
Line No. Field, Purch. Inv. Line Table Purchases and Payables
Insurance No. Field, Purch. Inv. Line Table Purchases and Payables
Pmt. Disc. Rcd. Amount Field, Purch. Inv. Line Table Spain Local Functionality
Job Unit Price (LCY) Field, Purch. Inv. Line Table Purchases and Payables
Tax Group Code Field, Purch. Inv. Line Table Purchases and Payables
Shortcut Dimension 2 Code Field, Purch. Inv. Line Table Purchases and Payables
VAT Base Amount Field, Purch. Inv. Line Table Purchases and Payables
Transaction Type Field, Purch. Inv. Line Table Purchases and Payables
VAT Bus. Posting Group Field, Purch. Inv. Line Table Purchases and Payables
Job Line Discount % Field, Purch. Inv. Line Table Purchases and Payables
Prod. Order No. Field, Purch. Inv. Line Table Purchases and Payables
Line Discount % Field, Purch. Inv. Line Table Purchases and Payables
VAT Difference Field, Purch. Inv. Line Table Purchases and Payables
Qty. per Unit of Measure Field, Purch. Inv. Line Table Purchases and Payables
Job Task No. Field, Purch. Inv. Line Table Purchases and Payables
Units per Parcel Field, Purch. Inv. Line Table Purchases and Payables
Unit Price (LCY) Field, Purch. Inv. Line Table Purchases and Payables
Allow Invoice Disc. Field, Purch. Inv. Line Table Purchases and Payables
Overhead Rate Field, Purch. Inv. Line Table Purchases and Payables
Job Currency Code Field, Purch. Inv. Line Table Purchases and Payables
Prepayment Line Field, Purch. Inv. Line Table Purchases and Payables
Document No. Field, Purch. Inv. Line Table Purchases and Payables
Direct Unit Cost Field, Purch. Inv. Line Table Purchases and Payables
Gen. Prod. Posting Group Field, Purch. Inv. Line Table Purchases and Payables
Location Code Field, Purch. Inv. Line Table Purchases and Payables
Unit of Measure (Cross Ref.) Field, Purch. Inv. Line Table Purchases and Payables
Dimension Set ID Field, Purch. Inv. Line Table Purchases and Payables
VAT Identifier Field, Purch. Inv. Line Table Purchases and Payables
Area Field, Purch. Inv. Line Table Purchases and Payables
Vendor Item No. Field, Purch. Inv. Line Table Purchases and Payables
Inv. Discount Amount Field, Purch. Inv. Line Table Purchases and Payables
Prod. Order Line No. Field, Purch. Inv. Line Table Purchases and Payables
Net Weight Field, Purch. Inv. Line Table Purchases and Payables
Posting Date Field, Purch. Inv. Line Table Purchases and Payables
Variant Code Field, Purch. Inv. Line Table Purchases and Payables
Operation No. Field, Purch. Inv. Line Table Purchases and Payables
IC Partner Ref. Type Field, Purch. Inv. Line Table Purchases and Payables
Depr. until FA Posting Date Field, Purch. Inv. Line Table Purchases and Payables
VAT Prod. Posting Group Field, Purch. Inv. Line Table Purchases and Payables
FA Posting Type Field, Purch. Inv. Line Table Purchases and Payables
Use Tax Field, Purch. Inv. Line Table Purchases and Payables
Job Line Amount (LCY) Field, Purch. Inv. Line Table Purchases and Payables
Tax Liable Field, Purch. Inv. Line Table Purchases and Payables
Use Duplication List Field, Purch. Inv. Line Table Purchases and Payables
Job Total Price Field, Purch. Inv. Line Table Purchases and Payables
VAT Calculation Type Field, Purch. Inv. Line Table Purchases and Payables
Gross Weight Field, Purch. Inv. Line Table Purchases and Payables
Work Center No. Field, Purch. Inv. Line Table Purchases and Payables
Job Line Type Field, Purch. Inv. Line Table Purchases and Payables
Appl.-to Item Entry Field, Purch. Inv. Line Table Purchases and Payables
Job Currency Factor Field, Purch. Inv. Line Table Purchases and Payables
Description Field, Purch. Inv. Line Table Purchases and Payables
Unit of Measure Field, Purch. Inv. Line Table Purchases and Payables
Product Group Code Field, Purch. Inv. Line Table Purchases and Payables
Shortcut Dimension 1 Code Field, Purch. Inv. Line Table Purchases and Payables
Expected Receipt Date Field, Purch. Inv. Line Table Purchases and Payables
Job Unit Price Field, Purch. Inv. Line Table Purchases and Payables
Blanket Order No. Field, Purch. Inv. Line Table Purchases and Payables
Buy-from Vendor No. Field, Purch. Inv. Line Table Purchases and Payables
Line Amount Field, Purch. Inv. Line Table Purchases and Payables
Nonstock Field, Purch. Inv. Line Table Purchases and Payables
Cross-Reference No. Field, Purch. Inv. Line Table Purchases and Payables
Item Category Code Field, Purch. Inv. Line Table Purchases and Payables
Routing No. Field, Purch. Inv. Line Table Purchases and Payables
Bin Code Field, Purch. Inv. Line Table Purchases and Payables
FA Posting Date Field, Purch. Inv. Line Table Purchases and Payables
Quantity (Base) Field, Purch. Inv. Line Table Purchases and Payables
IC Partner Code Field, Purch. Inv. Line Table Purchases and Payables
Job Total Price (LCY) Field, Purch. Inv. Line Table Purchases and Payables
Line Discount Amount Field, Purch. Inv. Line Table Purchases and Payables
Depreciation Book Code Field, Purch. Inv. Line Table Purchases and Payables
Gen. Bus. Posting Group Field, Purch. Inv. Line Table Purchases and Payables
Routing Reference No. Field, Purch. Inv. Line Table Purchases and Payables
Maintenance Code Field, Purch. Inv. Line Table Purchases and Payables
Return Reason Code Field, Purch. Inv. Line Table Purchases and Payables
IC Partner Reference Field, Purch. Inv. Line Table Purchases and Payables
Amount Including VAT Field, Purch. Inv. Line Table Purchases and Payables
Pay-to Vendor No. Field, Purch. Inv. Line Table Purchases and Payables
Blanket Order Line No. Field, Purch. Inv. Line Table Purchases and Payables
System-Created Entry Field, Purch. Inv. Line Table Purchases and Payables
Description 2 Field, Purch. Inv. Line Table Purchases and Payables
Duplicate in Depreciation Book Field, Purch. Inv. Line Table Purchases and Payables
Salvage Value Field, Purch. Inv. Line Table Purchases and Payables
Order Line No. Field, Purch. Inv. Line Table Switzerland Local Functionality
Order No. Field, Purch. Inv. Line Table Switzerland Local Functionality
EC % Field, Purch. Inv. Line Table Spain Local Functionality
Include in VAT Transac. Rep. Field, Purch. Inv. Line Table Italy Local Functionality
Related Entry No. Field, Purch. Inv. Line Table Italy Local Functionality
Service Tariff No. Field, Purch. Inv. Line Table Italy Local Functionality
Deductible % Field, Purch. Inv. Line Table Italy Local Functionality

See Also

Reference

Purch. Inv. Header
Purchase Invoice