SETIDVENDOR_IDINVOICE_IDINVOICE_DTDefault Value: %date
I=Invoiced
P=Invoice Pending
Default Value: P
PV_SS_INVC_HDR(SQL Table) |
Index Back |
|---|---|
Invoice HeaderInvoice Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | INVOICE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 4 | INVOICE_DT |
Date(10) | DATE NOT NULL |
Invoice Date
Default Value: %date |
| 5 | SALETX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 6 | FREIGHT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 7 | GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Invoice Amount |
| 8 | VCHR_TTL_LINES | Number(5,0) | INTEGER NOT NULL | Lines Entered |
| 9 | PV_SS_INVC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Status
I=Invoiced P=Invoice Pending Default Value: P |
| 10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |