PROCESS_INSTANCEBUSINESS_UNITINVOICECONTRACT_NUMGM_BI_LN_FLGC=Current Record
H=History Record
M=Merged Record
S=Summed Record
DESCR1GM_BI_LN_X_TMP(SQL Table) |
Index Back |
|---|---|
Summary Line Tbl Copy |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 4 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 5 | GM_BI_LN_FLG |
Character(1) | VARCHAR2(1) NOT NULL |
This flag is used to mark records inserted into this table from BI_LINE. A "C" indicates that this is a current period record. A 'H' means it is a history record that will be used for cumulative calculations. An "M" indicates this is a "merged" record. And an "S" indicates this is a summed record. This is also needed as an additional key for uniqueness.
C=Current Record H=History Record M=Merged Record S=Summed Record |
| 6 | DESCR1 |
Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | GROSS_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Extended |
| 9 | NET_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amt |
| 10 | TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount |
| 11 | TOT_LINE_DST_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Line Dist Amount |
| 12 | TOT_DISCOUNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount Amt |
| 13 | TOT_SURCHARGE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Surcharge Amt |
| 14 | VAT_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges. |
| 15 | VAT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice. |
| 16 | GM_GRS_AMT_CUM | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Gross Extended Amt Cumulative |
| 17 | GM_NET_AMT_CUM | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Net Extended Amt Cumulative |
| 18 | GM_TAX_AMT_CUM | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Tax Amount Cumulative |
| 19 | GM_TOT_LN_DST_CUM | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Total Line Dist Amt Cumulative |
| 20 | GM_TOT_DSCNT_CUM | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Tot Ln Discount Amt Cumulative |
| 21 | GM_TOT_SCHRG_CUM | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Surcharge Amt Cumulative |
| 22 | GM_VAT_BASIS_CUM | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | VAT Basis Amount Cumulative |
| 23 | GM_VAT_AMT_CUM | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | VAT Amount Cumulative |