PO_CLS_SHT_RULE(SQL Table) |
Index Back |
|---|---|
PO Close Short RulesPO Close Short Rules |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PO_RULE_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
PO Rule Type
CS=PO Close Short |
| 2 | PO_RULE_ID |
Character(10) | VARCHAR2(10) NOT NULL | PO Close Short Rule ID |
| 3 | RECV_REQ |
Character(1) | VARCHAR2(1) NOT NULL |
Receiving Required
N=Optional X=Do Not Y=Required |
| 4 | AMT_ONLY_FLG |
Character(1) | VARCHAR2(1) NOT NULL |
Amount Only
N=No Y=Yes Y/N Table Edit |
| 5 | MATCH_LINE_OPT |
Character(1) | VARCHAR2(1) NOT NULL |
Match Line Option
E=ERS F=Full Match N=Don't Match |
| 6 | CLS_SHORT_SET_OPT | Character(4) | VARCHAR2(4) NOT NULL |
Close Short Set Option
MA=Matched Amount MQ=Matched Quantity NA=Disable RA=Received Amount RMGA=Greater - Receipt/Match Amt RMGQ=Greater - Receipt/Match Qty RQ=Received Quantity RVGA=Greater - Receipt/Voucher Amt RVGQ=Greater Receipt/Voucher Qty VA=Vouchered Amount VQ=Vouchered Quantity |