NETTING_RULE_IDAP_AR_INDP=Payable
R=Receivable
Default Value: R
NET_RULE_SQL(SQL Table) |
Index Back |
|---|---|
Netting rules SQLThis record holds the SQL statement for Net Settlement Selection Rule. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NETTING_RULE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Netting Selection Rule ID |
| 2 | AP_AR_IND |
Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether the selection rule will be allpied to AP transactions or AR transactions.
P=Payable R=Receivable Default Value: R |
| 3 | SQLTEXT | Long Character(14000) | CLOB | SQL Statement Text |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |